CarlOwOs(1) NFL Totals
    Updated 2022-12-05
    WITH prices AS (
    SELECT
    timestamp::DATE AS date,
    AVG(price_usd) AS price
    FROM
    flow.core.fact_prices
    WHERE
    token_contract = 'A.1654653399040a61.FlowToken'
    GROUP BY
    1
    ),
    nft_data AS (
    SELECT
    CASE
    WHEN block_timestamp >= '2022-11-24' THEN 'Thanksgiving Week'
    ELSE 'Rest of Year'
    END AS label,
    COUNT(*) AS sales,
    COUNT(DISTINCT buyer) AS buyers,
    COUNT(DISTINCT seller) AS sellers,
    SUM(CASE WHEN currency = 'A.1654653399040a61.FlowToken' THEN s.price*p.price ELSE s.price END) AS vol,
    AVG(CASE WHEN currency = 'A.1654653399040a61.FlowToken' THEN s.price*p.price ELSE s.price END) AS avg_price,
    MIN(CASE WHEN currency = 'A.1654653399040a61.FlowToken' THEN s.price*p.price ELSE s.price END) AS min_price,
    MAX(CASE WHEN currency = 'A.1654653399040a61.FlowToken' THEN s.price*p.price ELSE s.price END) AS max_price,
    MEDIAN(CASE WHEN currency = 'A.1654653399040a61.FlowToken' THEN s.price*p.price ELSE s.price END) AS median_price
    FROM
    flow.core.ez_nft_sales s
    JOIN prices p ON date = block_timestamp::DATE
    WHERE
    nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
    GROUP BY
    1
    )
    SELECT *
    FROM nft_data

    Run a query to Download Data