flipside

    fragile-bronze copy
    Pine Analyticsfragile-bronze copy
    Updated 2024-12-30
    WITH combined_sales AS (
    SELECT
    block_timestamp,
    buyer_address,
    platform_name,
    price_usd AS usd_volume
    FROM ethereum.nft.ez_nft_sales

    UNION ALL

    SELECT
    block_timestamp,
    buyer_address,
    platform_name,
    price_usd AS usd_volume
    FROM base.nft.ez_nft_sales

    UNION ALL

    SELECT
    block_timestamp,
    buyer_address,
    platform_name,
    price_usd AS usd_volume
    FROM avalanche.nft.ez_nft_sales

    UNION ALL

    SELECT
    block_timestamp,
    buyer_address,
    platform_name,
    price_usd AS usd_volume
    FROM arbitrum.nft.ez_nft_sales

    UNION ALL
    QueryRunArchived: QueryRun has been archived