date_trunc('day',block_timestamp) as "date(day)",

date_trunc('week',block_timestamp) as "date(week)",

date_trunc('month',block_timestamp) as "date(month)",

count(distinct tx_hash) as "count of swap",

count(distinct ORIGIN_FROM_ADDRESS) as "count of swapper",

sum(AMOUNT_out_USD) as "volume (USD) of swap"

from ethereum.core.ez_dex_swaps

where TOKEN_IN = lower('0x4d224452801ACEd8B2F0aebE155379bb5D594381')

and AMOUNT_in_USD is not null

group by 1,2,3

union

select

date_trunc('day',block_timestamp) as "date(day)",

date_trunc('week',block_timestamp) as "date(week)",

date_trunc('month',block_timestamp) as "date(month)",

count(distinct tx_hash) as "count of swap",

count(distinct ORIGIN_to_ADDRESS) as "count of swapper",

sum(AMOUNT_in_USD) as "volume (USD) of swap"

from ethereum.core.ez_dex_swaps

where TOKEN_out = lower('0x4d224452801ACEd8B2F0aebE155379bb5D594381')

and AMOUNT_in_USD is not null

group by 1,2,3