block_timestamp :: date as date,

count(distinct tx_hash) as number_swaps

FROM ETHEREUM.CORE.EZ_DEX_SWAPS

WHERE platform ilike '%balancer%'

GROUP BY block_timestamp :: date

ORDER BY block_timestamp :: date ASC