flipside

    2023-10-25 07:24 PM copy copy copy copy
    dammyzuks2023-10-25 07:24 PM copy copy copy copy
    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;
    Run a query to Download Data