platform,

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

CASE

WHEN origin_to_address = '0x9008d19f58aabd9ed0d60971565aa8510560ab41' THEN 'CoW'

ELSE 'Other'

END as "swap_origin",

COUNT(DISTINCT(tx_hash)) as total_txs

FROM ethereum.core.ez_dex_swaps

where block_timestamp::date BETWEEN '2021-08-04' and SYSDATE()::date

GROUP BY platform, "date", "swap_origin"