Diamond2023 Season Data
    Updated 2023-09-22
    WITH PlayerData AS (
    SELECT DISTINCT
    set_id,
    nft_collection,
    tier,
    set_name,
    CONCAT(metadata:playerFirstName::text, ' ', metadata:playerLastName::text) AS playerName,
    metadata:teamName::text AS teamName
    FROM flow.nft.dim_moment_metadata
    WHERE set_id = '37'
    AND nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
    AND tier = 'LEGENDARY'
    AND set_name = 'Dynamic'
    ),
    SalesData AS (
    SELECT
    count(distinct buyer) as "Buyers",
    count(distinct seller) as "Sellers",
    count(distinct tx_id) as "Total Transactions"
    FROM flow.nft.ez_nft_sales ez
    WHERE ez.nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
    )
    SELECT
    PD.set_id,
    PD.nft_collection,
    PD.playerName,
    PD.teamName,
    PD.tier,
    PD.set_name,
    SD."Buyers",
    SD."Sellers",
    SD."Total Transactions"
    FROM PlayerData PD
    JOIN SalesData SD ON PD.nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
    AND PD.set_name = 'Dynamic';
    Run a query to Download Data