WITH memes AS ( SELECT distinct tx_hash FROM ethereum.core.ez_token_transfers WHERE ( contract_address = lower('0x1A963Df363D01EEBB2816b366d61C917F20e1EbE') or contract_address=lower('0x2718fEDFc22CC6d727932c8424993218B0AcB859') or contract_address=lower('0x2F573070E6090b3264Fe707e2C9F201716F123c7') or contract_address=lower('0x6982508145454ce325ddbe47a25d4ec3d2311933') ) --and from_address != origin_from_address and to_address = origin_from_address --and EVENT_TYPE = 'erc20_transfer' and amount_usd>0 and amount_usd<1e6 ), nomemes as ( SELECT distinct tx_hash FROM ethereum.core.ez_token_transfers WHERE ( contract_address <> lower('0x1A963Df363D01EEBB2816b366d61C917F20e1EbE') and contract_address<>lower('0x2718fEDFc22CC6d727932c8424993218B0AcB859') and contract_address<>lower('0x2F573070E6090b3264Fe707e2C9F201716F123c7') and contract_address<>lower('0x6982508145454ce325ddbe47a25d4ec3d2311933') ) --and from_address != origin_from_address and to_address = origin_from_address --and EVENT_TYPE = 'erc20_transfer' and amount_usd>0 and amount_usd<1e6 ), wallet_flows as ( SELECT 'Meme tokens' as type,* from memes union SELECT 'No Meme tokens' as type,* from nomemes ) , swap_memes AS ( SELECT distinct tx_hash FROM ethereum.core.ez_dex_swaps WHERE ( token_in = lower('0x1A963Df363D01EEBB2816b366d61C917F20e1EbE') or token_in=lower('0x2718fEDFc22CC6d727932c8424993218B0AcB859') or token_in=lower('0x2F573070E6090b3264Fe707e2C9F201716F123c7') or token_in=lower('0x6982508145454ce325ddbe47a25d4ec3d2311933') or token_out = lower('0x1A963Df363D01EEBB2816b366d61C917F20e1EbE') or token_out=lower('0x2718fEDFc22CC6d727932c8424993218B0AcB859') or token_out=lower('0x2F573070E6090b3264Fe707e2C9F201716F123c7') or token_out=lower('0x6982508145454ce325ddbe47a25d4ec3d2311933') ) and amount_out_usd>0 and amount_out_usd<1e6 ), swap_nomemes as ( SELECT distinct tx_hash FROM ethereum.core.ez_dex_swaps WHERE ( token_in <> lower('0x1A963Df363D01EEBB2816b366d61C917F20e1EbE') and token_in<>lower('0x2718fEDFc22CC6d727932c8424993218B0AcB859') and token_in<>lower('0x2F573070E6090b3264Fe707e2C9F201716F123c7') and token_in<>lower('0x6982508145454ce325ddbe47a25d4ec3d2311933') and token_out <> lower('0x1A963Df363D01EEBB2816b366d61C917F20e1EbE') and token_out<>lower('0x2718fEDFc22CC6d727932c8424993218B0AcB859') and token_out<>lower('0x2F573070E6090b3264Fe707e2C9F201716F123c7') and token_out<>lower('0x6982508145454ce325ddbe47a25d4ec3d2311933') ) and amount_in_usd>0 and amount_in_usd<1e6 ), swap_flows as ( SELECT 'Meme tokens' as type,* from swap_memes union select 'No Meme tokens' as type,* from swap_nomemes ), totals as ( select * from wallet_flows union select * from swap_flows ) SELECT trunc(block_timestamp,'day') as date, type, sum(tx_fee) as tx_fees, avg(tx_fee) as avg_tx_fee, avg(gas_price) as avg_gas_price from ethereum.core.fact_transactions x join totals y on x.tx_hash=y.tx_hash where block_timestamp>=current_date-interval '1 MONTH' group by 1,2 order by 1 asc

Meme era's..