flipside

    SEI 7-2
    Pine AnalyticsSEI 7-2
    Updated 2024-03-30
    WITH live_data AS (
    SELECT livequery.live.udf_api('https://api.flipsidecrypto.com/api/v2/queries/a21027de-de8b-4257-b0d1-b6660d1b22ad/data/latest'):"data" AS data
    ),
    all_data AS (
    SELECT
    FLATTENED.VALUE:"DAY"::DATE AS DAY, -- Assuming DAY is a valid date string
    FLATTENED.VALUE:"BLOCKCHAIN" AS BLOCKCHAIN,
    FLATTENED.VALUE:"BUYERS"::INTEGER AS BUYERS
    FROM
    live_data,
    LATERAL FLATTEN(INPUT => live_data.data) AS FLATTENED
    )

    SELECT
    date(BLOCK_TIMESTAMP) as date,
    'polygon' as blockchain,
    count(DISTINCT BUYER_ADDRESS) as buyers
    FROM
    polygon.nft.ez_nft_sales
    WHERE
    BLOCK_TIMESTAMP > current_date - INTERVAL '90 DAYS'
    GROUP BY
    1, 2

    UNION ALL

    SELECT
    date(BLOCK_TIMESTAMP) as date,
    'base' as blockchain,
    count(DISTINCT BUYER_ADDRESS) as buyers
    FROM
    base.nft.ez_nft_sales
    WHERE
    BLOCK_TIMESTAMP > current_date - INTERVAL '90 DAYS'
    GROUP BY
    1, 2
    QueryRunArchived: QueryRun has been archived