House of Wizard (@House_of_Wizard) header
House of Wizard (@House_of_Wizard) profile picture

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
Photo by House of Wizard (@House_of_Wizard)Photo by House of Wizard (@House_of_Wizard)Photo by House of Wizard (@House_of_Wizard)Photo by House of Wizard (@House_of_Wizard)Photo by House of Wizard (@House_of_Wizard)Photo by House of Wizard (@House_of_Wizard)Photo by House of Wizard (@House_of_Wizard)Photo by House of Wizard (@House_of_Wizard)Photo by House of Wizard (@House_of_Wizard)Photo by House of Wizard (@House_of_Wizard)
GWhiz 🪄 everybody! Who we are? Who are HoW? Well, let me tell you the story about us 🧵
4
5
3
26
8,235
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…
1
1
1
4
247
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.
2
2
159
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).
2
2
130
.@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!!!
1
3
288
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.
2
2
21
679
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 🦄
2
6
220
House of Wizard retweeted
Built a dashboard tracking Jupiter Perps (Jan–Jun 2026) $19.95M revenue, 176K active users, $21.13bn in volume - big Jan peak, then a steady cooldown after. Revenue -39.4%, users -4.00%, but volume still up +120% MoM. Mixed signals worth digging into 👀 Built with @Dune + @PowerBI
2
1
15
611
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…
3
7
740
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
3
6
339
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
1
3
1
9
982
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
1
4
1
14
1,022
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
Introducing pump fun GO: Pay ANYONE to do ANYTHING Create & complete bounties for ANY task and leverage the power of humans & money across the globe The world is at your fingertips. It’s time to GO 👇
2
1
8
443
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.
2
2
9
2,048
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 🤣
4
5
493
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…
2
1
20
3,918
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…
1
3
1
10
3,856
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.
1
1
1
8
929
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!
13
2
2
47
9,524
What we see? @aeroxyz -> @base ecosystem proxy @CurveFinance -> Aging but still monetizing deeply
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