kaibladeFIFA+ Collect Rarity USD Volume Stats
    Updated 2023-04-15
    WITH fifaplus_data AS
    (SELECT sales.*, dim.nft_asset_name, dim.name, dim.application_id, dim.drop_number,
    dim.drop_name, dim.item_no, dim.editions, dim.rarity, dim.world_cup_type, dim.year, dim.event_type, dim.player
    FROM algorand.nft.ez_nft_sales_fifa sales
    JOIN algorand.nft.ez_nft_metadata_fifa dim
    ON sales.nft_asset_id = dim.nft_asset_id)


    -- SELECT (
    SELECT ZEROIFNULL(SUM(total_sales_amount_usd)) AS "Total Sales", drop_name, rarity
    FROM fifaplus_data
    WHERE sale_type = 'secondary'
    AND drop_name IN ('genesis', 'archives', 'south american flair', 'archives 2')
    AND NOT (drop_name = 'archives 2' AND rarity = 'Iconic')
    GROUP BY drop_name, rarity
    ORDER BY drop_name, rarity
    -- WHERE rarity='Common'
    -- AND )
    -- SELECT DATE_TRUNC('day', block_timestamp) AS "Days",
    -- COUNT(tx_group_id) AS "Number of Mints",
    -- drop_name
    -- FROM fifaplus_data
    -- WHERE sale_type = 'mint'
    -- GROUP BY "Days", drop_name

    Run a query to Download Data