block_timestamp :: DATE,

count(distinct tx_hash)

FROM ETHEREUM.CORE.EZ_DEX_SWAPS

WHERE (platform = 'balancer')

AND pool_name ilike '%bb%'

GROUP BY block_timestamp :: date

ORDER BY block_timestamp :: date ASC