ArioNFL All Day Tournament [Round 1] - play-Type- daily
    Updated 2022-09-14
    with NFL_data as (
    select
    BLOCK_TIMESTAMP,
    TX_ID,
    NFT_COLLECTION a,
    NFT_ID,
    BUYER,
    SELLER,
    PRICE
    from flow.core.fact_nft_sales
    where NFT_COLLECTION ilike '%allday%'
    and PRICE is not null
    and TX_SUCCEEDED = 'TRUE'
    ),
    NFL_Total_data as (
    select
    BLOCK_TIMESTAMP,
    TX_ID,
    NFT_COLLECTION,
    d.NFT_ID,
    BUYER,
    SELLER,
    PRICE,
    player,
    team,
    PLAY_TYPE,
    MOMENT_STATS_FULL:metadata:playerPosition as PlayerPosition
    from NFL_data d Inner join flow.core.dim_allday_metadata m on d.NFT_ID = m.NFT_ID
    )
    select
    BLOCK_TIMESTAMP::date as date,
    PLAY_TYPE,
    count(distinct tx_id) as Number_TXs,
    sum(Price) as sales_Volume
    from NFL_Total_data
    group by 1,2

    Run a query to Download Data