Pine Analyticsfragile-bronze copy copy copy
    Updated 2024-12-30
    -- forked from fragile-bronze copy copy @ https://flipsidecrypto.xyz/studio/queries/bc3c72e3-e00d-43a6-90b2-1b950807400f

    WITH combined_sales AS (
    SELECT
    SELLER_ADDRESS,
    price_usd AS usd_volume
    FROM ethereum.nft.ez_nft_sales

    UNION ALL

    SELECT
    SELLER_ADDRESS,
    price_usd AS usd_volume
    FROM base.nft.ez_nft_sales

    UNION ALL

    SELECT
    SELLER_ADDRESS,
    price_usd AS usd_volume
    FROM avalanche.nft.ez_nft_sales

    UNION ALL

    SELECT
    SELLER_ADDRESS,
    price_usd AS usd_volume
    FROM arbitrum.nft.ez_nft_sales

    UNION ALL

    SELECT
    SELLER_ADDRESS,
    price_usd AS usd_volume
    FROM optimism.nft.ez_nft_sales

    QueryRunArchived: QueryRun has been archived