------------------------------------------------------Arbitrum------------------------------------------------ with arbitrum as ( with final_tab as ( with tab4 as ( with tab3 as ( with tab1 as ( select to_address, sum(amount) as input_vol from arbitrum.core.ez_token_transfers where contract_address = '0x58b9cb810a68a7f3e1e4f8cb45d1b9b3c79705e8' group by 1 ), tab2 as ( select from_address, sum(amount) as output_vol from arbitrum.core.ez_token_transfers where contract_address = '0x58b9cb810a68a7f3e1e4f8cb45d1b9b3c79705e8' group by 1 ) select to_address as address, case when input_vol is null then 0 else input_vol end as input_volume, case when output_vol is null then 0 else output_vol end as output_volume from tab1 left join tab2 on tab1.to_address = tab2.from_address ) select address, input_volume AS "Input Volume", output_volume AS "Output Volume", input_volume - output_volume as "Balance" from tab3 ORDER BY 4 DESC ), tab5 as ( select address, ADDRESS_name from arbitrum.core.dim_labels ) select tab4.address as ADDRESS, "Balance", case when "Balance" <= 1 then 'Balance<=1 NEXT' when "Balance" > 1 and "Balance" <= 10 then '1 10 and "Balance" <= 100 then '10 100 and "Balance" <= 1000 then '100 1000 and "Balance" <= 10000 then '1K 10000 and "Balance" <= 100000 then '10K 100000 and "Balance" <= 1000000 then '100K 1000000 then 'Balance>1M NEXT' end as "Classification" from tab4 left join tab5 on tab4.address = tab5.address WHERE "Balance" > 0 ) select "Classification", count(distinct address) as "Holders Count", sum("Balance") as "Total Balance", '🔵Arbitrum' as "Chain" from final_tab group by 1 order by 2 ), ------------------------------------------------------Optimism------------------------------------------------------- Optimism as ( with final_tab as ( with tab4 as ( with tab3 as ( with tab1 as ( select to_address, sum(amount) as input_vol from optimism.core.ez_token_transfers where contract_address = '0x58b9cb810a68a7f3e1e4f8cb45d1b9b3c79705e8' group by 1 ), tab2 as ( select from_address, sum(amount) as output_vol from optimism.core.ez_token_transfers where contract_address = '0x58b9cb810a68a7f3e1e4f8cb45d1b9b3c79705e8' group by 1 ) select to_address as address, case when input_vol is null then 0 else input_vol end as input_volume, case when output_vol is null then 0 else output_vol end as output_volume from tab1 left join tab2 on tab1.to_address = tab2.from_address ) select address, input_volume AS "Input Volume", output_volume AS "Output Volume", input_volume - output_volume as "Balance" from tab3 ORDER BY 4 DESC ), tab5 as ( select address, ADDRESS_name from optimism.core.dim_labels ) select tab4.address as ADDRESS, "Balance", case when "Balance" <= 1 then 'Balance<=1 NEXT' when "Balance" > 1 and "Balance" <= 10 then '1 10 and "Balance" <= 100 then '10 100 and "Balance" <= 1000 then '100 1000 and "Balance" <= 10000 then '1K 10000 and "Balance" <= 100000 then '10K 100000 and "Balance" <= 1000000 then '100K 1000000 then 'Balance>1M NEXT' end as "Classification" from tab4 left join tab5 on tab4.address = tab5.address WHERE "Balance" > 0 ) select "Classification", count(distinct address) as "Holders Count", sum("Balance") as "Total Balance", '🔴Optimism' as "Chain" from final_tab group by 1 order by 2 ), -----------------------------------------------------Polygon--------------------------------------------------------- Polygon as ( with final_tab as ( with tab4 as ( with tab3 as ( with tab1 as ( select to_address, sum(amount) as input_vol from polygon.core.ez_token_transfers where contract_address = '0x58b9cb810a68a7f3e1e4f8cb45d1b9b3c79705e8' group by 1 ), tab2 as ( select from_address, sum(amount) as output_vol from polygon.core.ez_token_transfers where contract_address = '0x58b9cb810a68a7f3e1e4f8cb45d1b9b3c79705e8' group by 1 ) select to_address as address, case when input_vol is null then 0 else input_vol end as input_volume, case when output_vol is null then 0 else output_vol end as output_volume from tab1 left join tab2 on tab1.to_address = tab2.from_address ) select address, input_volume AS "Input Volume", output_volume AS "Output Volume", input_volume - output_volume as "Balance" from tab3 ORDER BY 4 DESC ), tab5 as ( select address, ADDRESS_name from polygon.core.dim_labels ) select tab4.address as ADDRESS, "Balance", case when "Balance" <= 1 then 'Balance<=1 NEXT' when "Balance" > 1 and "Balance" <= 10 then '1 10 and "Balance" <= 100 then '10 100 and "Balance" <= 1000 then '100 1000 and "Balance" <= 10000 then '1K 10000 and "Balance" <= 100000 then '10K 100000 and "Balance" <= 1000000 then '100K 1000000 then 'Balance>1M NEXT' end as "Classification" from tab4 left join tab5 on tab4.address = tab5.address WHERE "Balance" > 0 ) select "Classification", count(distinct address) as "Holders Count", sum("Balance") as "Total Balance", '🟣Polygon' as "Chain" from final_tab group by 1 order by 2 ), -----------------------------------------------------Gnosis---------------------------------------------------------- Gnosis as ( with final_tab as ( with tab4 as ( with tab3 as ( with tab1 as ( select to_address, sum(amount) as input_vol from gnosis.core.ez_token_transfers where contract_address = '0x58b9cb810a68a7f3e1e4f8cb45d1b9b3c79705e8' group by 1 ), tab2 as ( select from_address, sum(amount) as output_vol from gnosis.core.ez_token_transfers where contract_address = '0x58b9cb810a68a7f3e1e4f8cb45d1b9b3c79705e8' group by 1 ) select to_address as address, case when input_vol is null then 0 else input_vol end as input_volume, case when output_vol is null then 0 else output_vol end as output_volume from tab1 left join tab2 on tab1.to_address = tab2.from_address ) select address, input_volume AS "Input Volume", output_volume AS "Output Volume", input_volume - output_volume as "Balance" from tab3 ORDER BY 4 DESC ), tab5 as ( select address, ADDRESS_name from gnosis.core.dim_labels ) select tab4.address as ADDRESS, "Balance", case when "Balance" <= 1 then 'Balance<=1 NEXT' when "Balance" > 1 and "Balance" <= 10 then '1 10 and "Balance" <= 100 then '10 100 and "Balance" <= 1000 then '100 1000 and "Balance" <= 10000 then '1K 10000 and "Balance" <= 100000 then '10K 100000 and "Balance" <= 1000000 then '100K 1000000 then 'Balance>1M NEXT' end as "Classification" from tab4 left join tab5 on tab4.address = tab5.address WHERE "Balance" > 0 ) select "Classification", count(distinct address) as "Holders Count", sum("Balance") as "Total Balance", '⚫Gnosis' as "Chain" from final_tab group by 1 order by 2 ), -----------------------------------------------------Ethereum-------------------------------------------------------- Ethereum as ( with final_tab as ( with tab4 as ( with tab3 as ( with tab1 as ( select to_address, sum(amount) as input_vol from ethereum.core.ez_token_transfers where contract_address = '0xfe67a4450907459c3e1fff623aa927dd4e28c67a' group by 1 ), tab2 as ( select from_address, sum(amount) as output_vol from ethereum.core.ez_token_transfers where contract_address = '0xfe67a4450907459c3e1fff623aa927dd4e28c67a' group by 1 ) select to_address as address, case when input_vol is null then 0 else input_vol end as input_volume, case when output_vol is null then 0 else output_vol end as output_volume from tab1 left join tab2 on tab1.to_address = tab2.from_address ) select address, input_volume AS "Input Volume", output_volume AS "Output Volume", input_volume - output_volume as "Balance" from tab3 ORDER BY 4 DESC ), tab5 as ( select address, ADDRESS_name from ethereum.core.dim_labels ) select tab4.address as ADDRESS, "Balance", case when "Balance" <= 1 then 'Balance<=1 NEXT' when "Balance" > 1 and "Balance" <= 10 then '1 10 and "Balance" <= 100 then '10 100 and "Balance" <= 1000 then '100 1000 and "Balance" <= 10000 then '1K 10000 and "Balance" <= 100000 then '10K 100000 and "Balance" <= 1000000 then '100K 1000000 then 'Balance>1M NEXT' end as "Classification" from tab4 left join tab5 on tab4.address = tab5.address WHERE "Balance" > 0 ) select "Classification", count(distinct address) as "Holders Count", sum("Balance") as "Total Balance", '⚪Ethereum' as "Chain" from final_tab group by 1 order by 2 ) select * from arbitrum union all select * from optimism union all select * from polygon union all select * from gnosis union all select * from ethereum

🪂Connext Airdrop ($NEXT)