-- What is the token distribution of UNI for active wallets (i.e. wallets with at least one transaction in the past 90 days?? -- How much is controlled by whales (defined as you want, such as top 100, top 1000, top 1%, etc)? -- Does this distribution change if inactive wallets are included? with uni_holders as ( select user_address as wallet, sum(amount_usd) as balance_usd from ethereum.erc20_balances where contract_address = '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984' -- UNI and balance_date::date = CURRENT_DATE - 1 group by wallet ), active_wallets as ( select * from uni_holders where wallet in ( select distinct from_address as wallet from ethereum.transactions where block_timestamp >= CURRENT_DATE - 91 ) ), active_distibution as ( select count(distinct wallet) as a_n_wallets, CASE WHEN balance_usd > 0 and balance_usd <= 1 THEN 'a.0-1' WHEN balance_usd > 1 and balance_usd <= 10 THEN 'b.1-10' WHEN balance_usd > 10 and balance_usd <= 50 THEN 'c.10-50' WHEN balance_usd > 50 and balance_usd <= 1e2 THEN 'd.50-100' WHEN balance_usd > 1e2 and balance_usd <= 1e3 THEN 'e.100-1000' WHEN balance_usd > 1e3 and balance_usd <= 1e4 THEN 'f.1K-10K' WHEN balance_usd > 1e4 and balance_usd <= 1e5 THEN 'g.10K-100K' WHEN balance_usd > 1e5 and balance_usd <= 1e6 THEN 'h.100K-1M' WHEN balance_usd > 1e6 and balance_usd <= 1e7 THEN 'i.1M-10M' WHEN balance_usd > 1e7 and balance_usd <= 1e8 THEN 'j.10M-100M' WHEN balance_usd > 1e8 THEN 'k.> 100M' END as a_category from active_wallets group by a_category order by a_category ), overall_distibution as ( select count(distinct wallet) as o_n_wallets, CASE WHEN balance_usd > 0 and balance_usd <= 1 THEN 'a.0-1' WHEN balance_usd > 1 and balance_usd <= 10 THEN 'b.1-10' WHEN balance_usd > 10 and balance_usd <= 50 THEN 'c.10-50' WHEN balance_usd > 50 and balance_usd <= 1e2 THEN 'd.50-100' WHEN balance_usd > 1e2 and balance_usd <= 1e3 THEN 'e.100-1000' WHEN balance_usd > 1e3 and balance_usd <= 1e4 THEN 'f.1K-10K' WHEN balance_usd > 1e4 and balance_usd <= 1e5 THEN 'g.10K-100K' WHEN balance_usd > 1e5 and balance_usd <= 1e6 THEN 'h.100K-1M' WHEN balance_usd > 1e6 and balance_usd <= 1e7 THEN 'i.1M-10M' WHEN balance_usd > 1e7 and balance_usd <= 1e8 THEN 'j.10M-100M' WHEN balance_usd > 1e8 THEN 'k.> 100M' END as o_category from uni_holders group by o_category order by o_category ) select * from overall_distibution o left join active_distibution a on o.o_category = a.a_category

Uniswap - 13. UNI token distribution