Flippppppa2023-12-15 11:50 AM copy
    -- forked from 2023-12-15 11:50 AM @ https://flipsidecrypto.xyz/edit/queries/8bc367f9-9482-46b8-8f39-ca90efcbb654

    SELECT
    date_trunc("day", block_timestamp) as Date ,
    platform,
    event_name,
    symbol_in,
    SUM(amount_in_usd) total_usd,

    tx_hash
    FROM ethereum.defi.ez_dex_swaps
    WHERE event_name = 'Swap' AND amount_in_usd is NOT NULL
    GROUP by Date, platform, event_name, symbol_in, tx_hash
    HAVING total_usd >= 1
    AND platform IN ('uniswap_v3','Curve','sushiswap', 'balancer')
    ORDER BY 5 DESC

    LIMIT 100


    Run a query to Download Data