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 (

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