SELECT

swap_from_symbol AS token

, SUM(swap_to_amount_usd) AS amount

, swap_from_mint AS address

FROM solana.defi.ez_dex_swaps

WHERE swap_from_mint != 'So11111111111111111111111111111111111111112'

AND swap_from_mint != 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

AND swap_from_mint != 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'

AND block_timestamp >= CURRENT_DATE - INTERVAL '30 DAYS'

GROUP BY swap_from_symbol, swap_from_mint

UNION ALL

SELECT

swap_to_symbol AS token

, SUM(swap_from_amount_usd) AS amount

, swap_to_mint AS address

FROM solana.defi.ez_dex_swaps

WHERE swap_to_mint != 'So11111111111111111111111111111111111111112'

AND swap_to_mint != 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

AND swap_to_mint != 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'

AND block_timestamp >= CURRENT_DATE - INTERVAL '30 DAYS'

GROUP BY swap_to_symbol, swap_to_mint

SELECT

CASE WHEN address = 'FUAfBo2jgks6gB4Z4LfZkqSZgzNucisEHqnNebaRxM1P' THEN 'MELANIA'

WHEN address = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN' THEN 'TRUMP'

WHEN address = 'ECY31gWwxy4s2VnMkYhmqDkrV75KrwR2yTtsnrnSpump' THEN 'BARRON'

WHEN address = 'FeR8VBqNRSUD5NtXAj2n3j1dAHkZHfyDktKuLXD4pump' THEN 'jellyjelly'

WHEN address = 'BftUiGB2iDkNDa8AKdhtLuJHHXiUfqLvTNmiXaSopump' THEN 'ELON'

WHEN address = '8XtRWb4uAAJFMP4QQhoYYCWR6XXb7ybcCdiqPwz9s5WS' THEN 'ALON'

WHEN address = 'BP8RUdhLKBL2vgVXc3n7oTSZKWaQVbD8S6QcPaMVBAPo' THEN 'FAFO'

WHEN address = '6NcdiK8B5KK2DzKvzvCfqi8EHaEqu48fyEzC8Mm9pump' THEN 'STONKS'

WHEN address = '6AJcP7wuLwmRYLBNbi825wgguaPsWzPBEHcHndpRpump' THEN 'VINE'