-- forked from 2023-10-25 07:24 PM copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/b80569af-3992-4517-b2f1-2e6802de8c05
SELECT
DATE_TRUNC('day', block_timestamp) AS _date,
pool_name,
Event_name,
Sum(event_index) AS Txn count
FROM
ethereum.nft.ethereum.defi.ez_dex_swaps
WHERE
block_timestamp :: DATE BETWEEN '2022-04-01'
AND '2022-08-30'
GROUP BY
1 DESC;