
on-chain analyst community in Indonesia. Also talk about anything on web3 industry. So don't worry, let's learn a new spell 🔮 Founder: @0xgulali
SEA
Joined November 2024
- Tweets190
- Following17
- Followers555
- Likes258
House of Wizard retweeted
most of BisonFi's volume doesn’t come from people trading on BisonFi
around 85% last month was routed through @dflow and @JupiterExchange. a lot of people are swapping on it without knowing
prop amm on @solana from forward industries. cumulative volume already past $109b. last 30d: ~$9b, 36m swaps, ~690k wallets
dashboard’s on dune if you wanna look around
dune.com/house_of_wizard/bis…
House of Wizard retweeted
.@Uniswap volume was up 68% in September, yet UNI burned fell. UNI doubled ($4.35 to $8.88) while the release threshold stayed fixed, so opening a jar costs 2x but the jar only grew 66%. Searcher margins went to roughly zero. The jars aren't empty, they're saving up.
House of Wizard retweeted
Tracking ethereum:0x1f9840a85d5af5bf1d1762f925bdaddc4201f984 TokenJar metrics from Jan to Sept 2026, and the trajectory is wild. Fees surged 5x (from $2.86M to $14.23M), while releases jumped from 135 to 880.
The real catalyst? @RobinhoodCrypto Chain. It went from zero fees in June to $8.31M in Sept; capturing over half of that month's total fees and shifting the ethereum:0x1f9840a85d5af5bf1d1762f925bdaddc4201f984 burn mechanism from ETH-centric to genuinely multichain.
(Note: Sept data is up to the 27th. Sourced via DeFiLlama & on-chain logs, visualized in @PowerBI).
.@MeteoraAG headline numbers look incredibly stable on the surface. But when you look at the monthly breakdown, the real story looks completely different.
Replying to @MeteoraAG
@MeteoraAG Jan–Aug 2026 overview:
💰 $217.5M revenue
📊 $18.2B volume
👥 6.5M active users
Headline looks stable, but January did 5x normal revenue thanks to the $MET fee-based airdrop deadline. CPAMM & DLMM dominate volume.
Filtered out heavy bot/sniper activity to find the real active user baseline.
Built in @PowerBI, queried on @Dune ☄️
118
Today marks a special milestone - House of Wizard turns 2! 🎂💪🏼🥳
A huge thank you for your unwavering support and love ❤️.
We're excited to share a brand-new experience with our data family...
OMG!!!
@Dune and I share a special bond - we're twins!!
Today is my birthday too!!!
House of Wizard retweeted
This one hits.
@Dune’s free plan is how I started. 12 Days of Dune with @andrewhong5297 and @agaperste . No background. Just curiosity.
Years later: @House_of_Wizard, @dune_Indonesia, and dashboards built with the Dune team.
Thank you @arno39, @AlsieLC, and especially @thecaptncrunch.
Grateful doesn’t cover it.
Today we are announcing that we are making the @Dune free plan view only. Meaning you can still look at all the amazing dashboards on Dune, but not run queries without a paid plan. The simple reason is that compute costs for running flexible queries over large amounts of data is very costly. We will still offer incredible value for money self-serve plans at $65 and $349 per month where you have access to vast amounts of blockchain data with completely serverless and hassle free querying. You can also try our very popular and powerful Plus plan on a 14 day trial when you sign up for a free account.
For years Dune has had a very generous free plan including free compute an data access. Hundreds of thousands of users have queried blockchain data with Dune, and millions of people have been exploring the dashboards created. We know of hundreds of users that have built a data career on top of Dune, and there are likely many more. We are grateful to everyone that’s been exploring this data together with us. I’m proud and humbled that we’ve gone from @mewwts, me, some blockchain data in a postgres db and a few users in a Telegram channel, to reaching millions with the Dune platform and community.
During Dune’s 8+ years in business countless data providers have come and gone. And I can tell you that what is worse than losing access to free compute is to lose your mission critical data provider all together. The reason why we’ve been able to stick around, and will keep sticking around, is because we adjust to the market. Thousands of industry leading businesses rely on Dune for their blockchain data, and they can safely keep doing that.
Some have called these plan changes the end of an era. And that might be right, but I think the new era is going to be bigger and more exciting. The blockchain industry is now mature enough that businesses and financial institutions are coming onchain at a blistering pace. Dune is all in on empowering them with onchain data. During this new era Dune data will keep reaching millions of people, businesses and AIs in our mission to make onchain finance observable.
House of Wizard retweeted
Spent the week digging into @Uniswap's H1 2026 numbers
$821B total volume, $381M revenue (+114% vs last period), 2.8M active users across chains, 1.3B trades
Volume's basically flat, users down slightly, but revenue growth tells a different story
@ethereum, @BNBCHAIN, and @base still dominate volume share
Built the dashboard with @Dune in PowerBI 🦄
House of Wizard retweeted
House of Wizard retweeted
NUMBER IS NEVER LIE!!
According to @stacy_muur : Revenue > Narrative.
The data really shows it -> Tron’s revenue is dominating. The interesting part is, @trondao barely gets talked about on X, but they actually have real, loyal users. It’s the complete opposite with @SuiNetwork and @solana . Those two have been trending non-stop for the past year, but their revenue doesn’t come anywhere close to matching the hype.
Source data @Dune :
dune.com/queries/6952067/108…
House of Wizard retweeted
Setelah kita bisa ambil datanya dan bisa visualisasinya trus step selanjutnya apa???
Kita mesti paham tentang proyek apa yg mau kita bedah datanya, apakah Proyek itu termasuk dalam Defi? Dex? Dex perpetual? Bridge? Blockchain? Launchpad? atau proyek yg lain.
Jadi ini yg menjadi tantangan tersendiri bagi seorang Onchain Analyst karena "dipaksa" paham dengan berbagai macam proyek di crypto dengan segala "challenge"nya.
Tapi tenang, di era AI sekarang kita bisa belajar dengan lebih mudah soal proyek crypto tersebut tanpa capek2 baca whitepapernya, Jadi itu dapat memangkas waktu kita dalam memahami sebelum menganalisa suatu proyek.
Trus ambil datanya dari mana? pake bahasa pemprograman apa? visualisasinya pake apa?
Itu pertanyaan yang sering banget ditanyakan orang awam saat mendengar soal Onchain Analyst.
mari kita bahas satu2
# kita bisa ambil data dari @etherscan @solscanofficial @coingecko @nansen_ai @DefiLlama dan @Dune
# bahasa yang biasa digunakan adalah SQL or Pyhton karena besaran data yg diproses bisa menyampai jutaan data.
# visualisasinya bisa pake native web 3 seperti @Dune @DefiLlama @tokenterminal @artemis atau mau dashboard yg interaktif di web 2 seperti @tableau atau @PowerBI
Jadi kalo kalian merasa data di web 3 ribet dan susah dibawa ke dunia web 2 mungkin kalian belum "digging" lebih dalam lagi
House of Wizard retweeted
Trus ambil datanya dari mana? pake bahasa pemprograman apa? visualisasinya pake apa?
Itu pertanyaan yang sering banget ditanyakan orang awam saat mendengar soal Onchain Analyst.
mari kita bahas satu2
# kita bisa ambil data dari @etherscan @solscanofficial @coingecko @nansen_ai @DefiLlama dan @Dune
# bahasa yang biasa digunakan adalah SQL or Pyhton karena besaran data yg diproses bisa menyampai jutaan data.
# visualisasinya bisa pake native web 3 seperti @Dune @DefiLlama @tokenterminal @artemis atau mau dashboard yg interaktif di web 2 seperti @tableau atau @PowerBI
Jadi kalo kalian merasa data di web 3 ribet dan susah dibawa ke dunia web 2 mungkin kalian belum "digging" lebih dalam lagi
Apa sih sebenarnya Onchain Analyst ???
Apakah sama dengan Data Analyst ??
konsep besarnya sebenarnya sama tapi beda ekosistemnya jadi cara mendapatkan datanya berbeda, besar datanya juga beda.
cek poster dibawah ini untuk lebih jelasnya dan terus pantengin akun ini buat info selanjutnya, karena aku akan share info seputar Onchain Analyst
House of Wizard retweeted
Apa sih sebenarnya Onchain Analyst ???
Apakah sama dengan Data Analyst ??
konsep besarnya sebenarnya sama tapi beda ekosistemnya jadi cara mendapatkan datanya berbeda, besar datanya juga beda.
cek poster dibawah ini untuk lebih jelasnya dan terus pantengin akun ini buat info selanjutnya, karena aku akan share info seputar Onchain Analyst
House of Wizard retweeted
Ada ada saja caranya mengumpulkan liquidty di masa sekarang bukannya memperbaiki wajah crypto di mata orang awam malah memperkeruhnya.
It’s ugly business
Every friend has their season, and every season has its friends.
House of Wizard's random gathering, where we connected with folks from other communities.
House of Wizard retweeted
Kalau ngitung "fee" di @initia gimana kak?
Data "fee" initia di database @Dune gak ada di initia.tx_message, tapi ada di initia.transactions(gambar 1).
Kayak misal kalian mau cari ARPU(Annual Revenue per User) di Initia(gambar 2), ambil data fee dari tabel transactions.
Tapi...kalian harus combine data di tx_message sama di transactions dulu untuk dapetin kolom `block_timestamp` karena di tabel transactions ga ada.
Uniknya lagi, data type untuk "fee" ini adalah `varchar` bukan INT atau DOUBLE -> contoh: 2060uinit
Bingung? Gak papa, normal kok 😄
Kalian penasaran gak sih isi "message" di setiap transaksi @initia kayak gmn?
Mari kita bedah!
Misal kita mau hitung active user di blockchain initia...gimana cara ambil data address-nya?
Kalo kita buka initia scan -> pada transaksi bakal muncul "message" yg isinya "sender", "receiver", & "amount". (gambar 1).
Tapi, yg ditampilkan di Database @Dune (gambar 2) amount, sender, & receiver nested di kolom "message".
Pusing gak?
Bersyukurlah karena kalian masih berfikir 🤣
House of Wizard retweeted
Kalian penasaran gak sih isi "message" di setiap transaksi @initia kayak gmn?
Mari kita bedah!
Misal kita mau hitung active user di blockchain initia...gimana cara ambil data address-nya?
Kalo kita buka initia scan -> pada transaksi bakal muncul "message" yg isinya "sender", "receiver", & "amount". (gambar 1).
Tapi, yg ditampilkan di Database @Dune (gambar 2) amount, sender, & receiver nested di kolom "message".
Pusing gak?
Bersyukurlah karena kalian masih berfikir 🤣
Ini project @cosmos kedua yang aku kerjain setelah @injective
udah ada yang pernah ngulik datanya @initia belum?
Kalau gitu yuk kita bedah datanya satu-satu:
- Blockchain ini pakai cosmos SDK, tp bahasanya pakai Move.
- struktur data beda dengan EVM
- Perbedaannya dengan EVM, initia menggunakan "message" dalam setiap transaksinya.
Contoh @Dune dashboard Intia:
dune.com/house_of_wizard/ini…
House of Wizard retweeted
Ini project @cosmos kedua yang aku kerjain setelah @injective
udah ada yang pernah ngulik datanya @initia belum?
Kalau gitu yuk kita bedah datanya satu-satu:
- Blockchain ini pakai cosmos SDK, tp bahasanya pakai Move.
- struktur data beda dengan EVM
- Perbedaannya dengan EVM, initia menggunakan "message" dalam setiap transaksinya.
Contoh @Dune dashboard Intia:
dune.com/house_of_wizard/ini…
Dashboard analitik pertama aku di @Dune tuh soal token $INJ.
Waktu itu aku masih bangun portfolio, tapi entah kenapa orang-orang suka. Mungkin saat itu injective baru hype dan harganya baru ~$6.
Puncaknya di 2024 pas Devcon di Thailand. Aku ketemu langsung sama @ericinjective, co-founder @injective. Langsung aku tunjukin dashboard INJ-nya ke dia sama timnya...dan mereka apresiasi dashboardnya.
Link dash:
dune.com/lydiapita/injective…
House of Wizard retweeted
Dashboard analitik pertama aku di @Dune tuh soal token $INJ.
Waktu itu aku masih bangun portfolio, tapi entah kenapa orang-orang suka. Mungkin saat itu injective baru hype dan harganya baru ~$6.
Puncaknya di 2024 pas Devcon di Thailand. Aku ketemu langsung sama @ericinjective, co-founder @injective. Langsung aku tunjukin dashboard INJ-nya ke dia sama timnya...dan mereka apresiasi dashboardnya.
Link dash:
dune.com/lydiapita/injective…
Setelah mendapatkan kepercayaan mengerjakan dashboard yg lumayan "fenomenal" 😆😆
2 bulan berikutnya kembali dipercaya mengerjakan dashboard untuk proyek Monad Momentum.
Ada 3 proyek yg kebetulan aku handle
* @MondayTrade_ - dex perpetual
Link dashboardnya dune.com/monday_trade/monday…
* @LeverUp_xyz - dex perpetual
Link dashboardnya
dune.com/leverup_team/leveru…
* @kizzymobile - media sosial prediction
Link dashboardnya
dune.com/house_of_wizard/kiz…
Masih inget banget 2022, mulai belajar OnChain analyst sendirian. Di Indonesia waktu itu? Orang2 pada nggak aware. Tapi aku tetep lanjut, bikin portfolio dari nol, coba-coba query, bikin dashboard yang kadang jelek,belum lagi ketemu syntax error.
Sampai aku di notice tim Dune. Mereka kasih kepercayaan buat ngerjain proyek analitik dashboard Monad Momentum.
Sekarang aku resmi wizard grantee di Dune.
Dari belajar sendiri di kamar sampe dibayar timnya, rasanya lega banget.
House of Wizard retweeted
Setelah mendapatkan kepercayaan mengerjakan dashboard yg lumayan "fenomenal" 😆😆
2 bulan berikutnya kembali dipercaya mengerjakan dashboard untuk proyek Monad Momentum.
Ada 3 proyek yg kebetulan aku handle
* @MondayTrade_ - dex perpetual
Link dashboardnya dune.com/monday_trade/monday…
* @LeverUp_xyz - dex perpetual
Link dashboardnya
dune.com/leverup_team/leveru…
* @kizzymobile - media sosial prediction
Link dashboardnya
dune.com/house_of_wizard/kiz…
Masih inget banget 2022, mulai belajar OnChain analyst sendirian. Di Indonesia waktu itu? Orang2 pada nggak aware. Tapi aku tetep lanjut, bikin portfolio dari nol, coba-coba query, bikin dashboard yang kadang jelek,belum lagi ketemu syntax error.
Sampai aku di notice tim Dune. Mereka kasih kepercayaan buat ngerjain proyek analitik dashboard Monad Momentum.
Sekarang aku resmi wizard grantee di Dune.
Dari belajar sendiri di kamar sampe dibayar timnya, rasanya lega banget.
Ikut nambahi kak, bersyukur pivot ke OnChain analyst dari Arsiteknya sebelumnya. Karena effort kerjanya sama tapi pendapatan yang dihasilkan bisa 4-5X dari yg didapatkan pas masih jadi Arsitek 😁😁
Mungkin dashboard yg aku bikin ini rada fenomenal karena dipakai oleh teamnya untuk menentukan alokasi dan ketentuan untuk reward airdropnya. Gmonad!
Most DEX users generate almost no revenue per user.
That’s the hidden story.
Protocols like @Uniswap , @pancakefi , and @Raydium dominate on user scale -> but ARPU stays minimal.
Meanwhile, smaller DEXs like @0xfluid , @CurveFinance , and @BreederDodo monetize far more efficiently with significantly fewer users.
More users ≠ better business.
In this market, monetization efficiency matters more than vanity growth.
Source @Dune dashy:
dune.com/lydiapita/chain-and…
1
136























