WITH users AS ( SELECT DISTINCT sender AS user FROM avalanche.defi.ez_dex_swaps UNION SELECT DISTINCT sender AS user FROM arbitrum.defi.ez_dex_swaps UNION SELECT DISTINCT sender AS user FROM optimism.defi.ez_dex_swaps UNION SELECT DISTINCT sender AS user FROM polygon.defi.ez_dex_swaps UNION SELECT DISTINCT sender AS user FROM base.defi.ez_dex_swaps UNION SELECT DISTINCT sender AS user FROM bsc.defi.ez_dex_swaps ), inflow AS ( SELECT DISTINCT to_address AS holder, 'avalanche' AS blockchain, sum (amount_usd) AS inflow FROM avalanche.core.ez_token_transfers WHERE to_address != '0x0000000000000000000000000000000000000000' GROUP BY 1,2 UNION ALL SELECT DISTINCT to_address AS holder, 'arbitrum' AS blockchain, sum (amount_usd) AS inflow FROM arbitrum.core.ez_token_transfers WHERE to_address != '0x0000000000000000000000000000000000000000' GROUP BY 1,2 UNION ALL SELECT DISTINCT to_address AS holder, 'optimism' AS blockchain, sum (amount_usd) AS inflow FROM optimism.core.ez_token_transfers WHERE to_address != '0x0000000000000000000000000000000000000000' GROUP BY 1,2 UNION ALL SELECT DISTINCT to_address AS holder, 'polygon' AS blockchain, sum (amount_usd) AS inflow FROM polygon.core.ez_token_transfers WHERE to_address != '0x0000000000000000000000000000000000000000' GROUP BY 1,2 UNION ALL SELECT DISTINCT to_address AS holder, 'base' AS blockchain, sum (amount_usd) AS inflow FROM polygon.core.ez_token_transfers WHERE to_address != '0x0000000000000000000000000000000000000000' GROUP BY 1,2 UNION ALL SELECT DISTINCT to_address AS holder, 'bsc' AS blockchain, sum (amount_usd) AS inflow FROM polygon.core.ez_token_transfers WHERE to_address != '0x0000000000000000000000000000000000000000' GROUP BY 1,2 ), outflow AS ( SELECT DISTINCT from_address AS wallet, 'avalanche' AS blockchain, sum (amount_usd) AS outflow FROM avalanche.core.ez_token_transfers WHERE from_address != '0x0000000000000000000000000000000000000000' GROUP BY 1,2 UNION ALL SELECT DISTINCT from_address AS holder, 'arbitrum' AS blockchain, sum (amount_usd) AS outflow FROM arbitrum.core.ez_token_transfers WHERE from_address != '0x0000000000000000000000000000000000000000' GROUP BY 1,2 UNION ALL SELECT DISTINCT from_address AS holder, 'optimism' AS blockchain, sum (amount_usd) AS outflow FROM optimism.core.ez_token_transfers WHERE from_address != '0x0000000000000000000000000000000000000000' GROUP BY 1,2 UNION ALL SELECT DISTINCT from_address AS holder, 'polygon' AS blockchain, sum (amount_usd) AS outflow FROM polygon.core.ez_token_transfers WHERE from_address != '0x0000000000000000000000000000000000000000' GROUP BY 1,2 UNION ALL SELECT DISTINCT from_address AS holder, 'base' AS blockchain, sum (amount_usd) AS outflow FROM polygon.core.ez_token_transfers WHERE from_address != '0x0000000000000000000000000000000000000000' GROUP BY 1,2 UNION ALL SELECT DISTINCT from_address AS holder, 'bsc' AS blockchain, sum (amount_usd) AS outflow FROM polygon.core.ez_token_transfers WHERE from_address != '0x0000000000000000000000000000000000000000' GROUP BY 1,2 ), balance AS ( SELECT DISTINCT holder, i.blockchain, inflow - outflow AS balance FROM inflow i JOIN outflow o ON i.holder = o.wallet AND i.blockchain = o.blockchain WHERE holder IN (SELECT user FROM users) HAVING balance > 0 ) SELECT blockchain, CASE WHEN balance < 1 THEN 'a.Plankton<1' WHEN balance >= 1 AND balance < 10 THEN 'b.Shrimp<10' WHEN balance >= 10 AND balance < 100 THEN 'c.Crab<100' WHEN balance >= 100 AND balance < 500 THEN 'd.Fish<500' WHEN balance >= 500 AND balance < 1000 THEN 'e.Octopuses<1000' WHEN balance >= 1000 AND balance < 5000 THEN 'f.Dolphins<5000' WHEN balance >= 5000 AND balance < 10000 THEN 'g.Sharks<10000' WHEN balance >= 10000 THEN 'h.Whales>10000' END AS distribution, count (DISTINCT holder) AS Users_Count FROM balance GROUP BY 1,2

Uniswap Gas Burner