SELECT '<10' AS amount_range, COUNT(*) AS dex_count FROM ethereum.defi.ez_dex_swaps WHERE (TOKEN_IN = '0x576e2bed8f7b46d34016198911cdf9886f78bea7' AND AMOUNT_IN_USD < 10) OR (TOKEN_OUT = '0x576e2bed8f7b46d34016198911cdf9886f78bea7' AND AMOUNT_OUT_USD < 10) UNION ALL SELECT '10-100' AS amount_range, COUNT(*) AS dex_count FROM ethereum.defi.ez_dex_swaps WHERE (TOKEN_IN = '0x576e2bed8f7b46d34016198911cdf9886f78bea7' AND AMOUNT_IN_USD >= 10 AND AMOUNT_IN_USD < 100) OR (TOKEN_OUT = '0x576e2bed8f7b46d34016198911cdf9886f78bea7' AND AMOUNT_OUT_USD >= 10 AND AMOUNT_OUT_USD < 100) UNION ALL SELECT '100-1000' AS amount_range, COUNT(*) AS dex_count FROM ethereum.defi.ez_dex_swaps WHERE (TOKEN_IN = '0x576e2bed8f7b46d34016198911cdf9886f78bea7' AND AMOUNT_IN_USD >= 100 AND AMOUNT_IN_USD < 1000) OR (TOKEN_OUT = '0x576e2bed8f7b46d34016198911cdf9886f78bea7' AND AMOUNT_OUT_USD >= 100 AND AMOUNT_OUT_USD < 1000) UNION ALL SELECT '1000-10000' AS amount_range, COUNT(*) AS dex_count FROM ethereum.defi.ez_dex_swaps WHERE (TOKEN_IN = '0x576e2bed8f7b46d34016198911cdf9886f78bea7' AND AMOUNT_IN_USD >= 1000 AND AMOUNT_IN_USD < 10000) OR (TOKEN_OUT = '0x576e2bed8f7b46d34016198911cdf9886f78bea7' AND AMOUNT_OUT_USD >= 1000 AND AMOUNT_OUT_USD < 10000) UNION ALL SELECT '10000-100000' AS amount_range, COUNT(*) AS dex_count FROM ethereum.defi.ez_dex_swaps WHERE (TOKEN_IN = '0x576e2bed8f7b46d34016198911cdf9886f78bea7' AND AMOUNT_IN_USD >= 10000 AND AMOUNT_IN_USD < 100000) OR (TOKEN_OUT = '0x576e2bed8f7b46d34016198911cdf9886f78bea7' AND AMOUNT_OUT_USD >= 10000 AND AMOUNT_OUT_USD < 100000) UNION ALL SELECT '>=100000' AS amount_range, COUNT(*) AS dex_count FROM ethereum.defi.ez_dex_swaps WHERE (TOKEN_IN = '0x576e2bed8f7b46d34016198911cdf9886f78bea7' AND AMOUNT_IN_USD >= 100000) OR (TOKEN_OUT = '0x576e2bed8f7b46d34016198911cdf9886f78bea7' AND AMOUNT_OUT_USD >= 100000);

Maga ($Trump) Token Dashboard