PLATFORM as " platform name ",

date_trunc('day', block_timestamp) as date,

count(TX_HASH) as "number of the transaction"

from ethereum.core.ez_dex_swaps

where BLOCK_TIMESTAMP >='2021-01-01'

and CONTRACT_ADDRESS='0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c'

and SYMBOL_IN = 'BNT'

or SYMBOL_out = 'BNT'

and PLATFORM = 'uniswap-v2'

or PLATFORM = 'uniswap-v3'

GROUP by 1,2

order by 2 DESC