Updated 2024-10-24
    -- Get started with Flipside by running your first query:
    -- the SQL statement below will get you a list of NFT
    -- platforms on Ethereum, ranked by how many sales
    -- they've had in the past month.
    -- Be sure to see our documentation for more guidance,
    -- including a full walkthrough of the app:
    -- https://docs.flipsidecrypto.xyz/our-app/getting-started
    select
    BLOCK_NUMBER
    AMOUNT0_USD
    from
    ethereum.uniswapv3.ez_swaps
    where
    POOL_ADDRESS = '0x3f23d2a1a1ecc72a9b03480be7a1981196aadbf7' AND
    block_timestamp > current_date - interval '30 days'
    limit 200
    QueryRunArchived: QueryRun has been archived