-- forked from Swap - $PEPE @ https://flipsidecrypto.xyz/edit/queries/070b87e6-111b-487c-b814-eeac5f9ed3fd

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 bsc.defi.ez_dex_swaps

where TOKEN_IN = '0xba2ae424d960c26247dd6c32edc70b295c744c43'

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 bsc.defi.ez_dex_swaps

where TOKEN_OUT = '0xba2ae424d960c26247dd6c32edc70b295c744c43'

and date >= '2024-01-01'

group by 1