from ethereum.udm_events

where from_address in ('0x86969d29f5fd327e1009ba66072be22db6017cc6', '0x9509665d015bfe3c77aa5ad6ca20c8afa1d98989',

'0xf90e98f3d8dce44632e5020abf2e122e0f99dfab', '0x1bd435f3c054b6e901b7b108a0ab7617c808677b', '0xdef171fe48cf0115b1d80b88dc8eab59176fee57')

and block_timestamp::date >= '2021-01-01' and block_timestamp::date <= '2021-12-31')

select date_trunc('month', block_timestamp) as dt, case when platform like '%uniswap%' then 'uniswap'

else platform end as dexs , sum(amount_usd) as total_usd_vol

from ethereum.dex_swaps

where tx_id in (select tx_id from txs_table) and block_timestamp::date >= '2021-01-01' and block_timestamp::date <= '2021-12-31'

group by dt, dexs