Pine Analyticsfragile-bronze
    Updated 2025-02-15
    WITH combined_sales AS (
    SELECT
    block_timestamp,
    buyer_address,
    platform_name,
    price_usd
    FROM ethereum.nft.ez_nft_sales

    UNION ALL

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

    UNION ALL

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

    UNION ALL

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

    UNION ALL
    Last run: 2 months ago
    YEAR
    NFTS_BOUGHT
    BUY_VOLUME
    TOTAL_NFTS_BOUGHT
    TOTAL_BUY_VOLUME
    1
    2024-01-01 00:00:00.000125.95219318227174143.092058869
    2
    2022-01-01 00:00:00.00010994765.181250126226174117.139865689
    3
    2021-01-01 00:00:00.00011779351.95861556311779351.958615563
    3
    201B
    4s