@jengreg

I built a starter pulse for $ARENA. It wasn’t easy: table hunting in Dune, a few “schema” errors, and the classic 18-decimal headache. Although the result makes up for the headache. What the data says (last 7 days): • 1.36B $ARENA moved across 44,822 transfers • ≈ 1.33% of all Avalanche transactions • a recurring large counterparty: 0x4bcdb9…d898f What I learned: • Use the right tables; quote "from" and "to" • evt_* columns are event metadata; event from/to aren’t the tx sender/receiver • Normalize units (ARENA = 18 decimals) and cast before dividing • Time windows change the story: 24h pulse, 7d baseline, 30d trend • Exclude zero-address flows when you want circulating activity Dashboard (public): https://dune.com/jengreg/arenatokeninsights

0 reply

0 recast

1 reaction