select date_trunc('day',BLOCK_TIMESTAMP) as date

, sum(AMOUNT_IN_USD)*-1 as volume

, count(TX_HASH)*-1 as transactions

, count(distinct ORIGIN_FROM_ADDRESS)*-1 as swappers

, 'swap from' as action

from ethereum.defi.ez_dex_swaps

where TOKEN_IN = '0x6982508145454ce325ddbe47a25d4ec3d2311933'

and date >= '2024-01-01'

group by 1

union

select date_trunc('day',BLOCK_TIMESTAMP) as date

, sum(AMOUNT_OUT_USD) as volume

, count(TX_HASH) as transactions

, count(distinct ORIGIN_TO_ADDRESS) as swappers

, 'swap to' as action

from ethereum.defi.ez_dex_swaps

where TOKEN_OUT = '0x6982508145454ce325ddbe47a25d4ec3d2311933'

and date >= '2024-01-01'

group by 1