with tab10 as ( with tab9 as ( with tab7 as ( with tab5 as ( with tab3 as ( with tab1 as ( select block_timestamp :: date as date, tx_id, signers [0] as user from solana.core.fact_events where program_id = 'PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY' and block_timestamp :: date >= '2023-08-23' ), tab2 as ( select block_timestamp :: date as date, amount, mint, tx_id from solana.core.fact_transfers where block_timestamp :: date >= '2023-08-23' ) select tab1.date as date_, tab1.tx_id as tx_id_, user, amount, mint from tab1 left join tab2 on tab1.date = tab2.date and tab1.tx_id = tab2.tx_id ), tab4 as ( select tx_id, fee / pow(10, 9) as fee from solana.core.fact_transactions where block_timestamp :: date >= '2023-08-23' ) select date_, tx_id_, fee, user, amount, mint from tab3 left join tab4 on tab3.tx_id_ = tab4.tx_id ), tab6 as ( select token_address, coin_market_cap_id as id FROM solana.core.dim_tokens ) select date_, tx_id_, fee, user, amount, mint, id from tab5 left join tab6 on tab5.mint = tab6.token_address ), tab8 as ( select recorded_hour :: date as date, avg(close) as avg_price, id, symbol from solana.price.fact_token_prices_hourly where recorded_hour :: date >= '2023-08-23' group by 1, 3, 4 order by 1 ) select date_, tx_id_, fee, user, amount, amount * avg_price as amount_usd, symbol, mint from tab7 left join tab8 on tab7.date_ = tab8.date and tab7.id = tab8.id ) select user as "User", sum(amount_usd), CASE when sum(amount_usd) <= 1 then 'V<=1 USD' when sum(amount_usd) > 1 and sum(amount_usd) <= 10 then '1 10 and sum(amount_usd) <= 100 then '10 100 and sum(amount_usd) <= 1000 then '100 1000 and sum(amount_usd) <= 10000 then '1K 10000 and sum(amount_usd) <= 100000 then '10K 100000 and sum(amount_usd) <= 1000000 then '100K1M USD' end as "Class" from tab9 group by 1 ) select "Class", count(distinct "User") as "User Count" from tab10 group by 1 order by 2

🐦‍🔥Phoenix Analysis