wanlinDaily general info copy
    Updated 2023-05-13
    -- forked from sami-1990 / Daily general info @ https://flipsidecrypto.xyz/sami-1990/q/2023-05-02-09-33-am-IasJ50

    select
    date_trunc ('day',BLOCK_TIMESTAMP) as date,
    count (DISTINCT ORIGIN_FROM_ADDRESS) as swappers,
    count (DISTINCT TX_HASH) as swaps,
    sum (AMOUNT_IN_USD) as volume
    from ethereum.core.ez_dex_swaps
    WHERE PLATFORM = 'uniswap-v3'
    and POOL_NAME like '%USDC-WETH%'
    and EVENT_NAME='Swap'
    and block_timestamp >= '2022-11-04'
    AND block_timestamp <= '2022-11-18'
    and AMOUNT_IN_USD is not NULL
    GROUP BY 1


    Run a query to Download Data