date_trunc('day', block_timestamp) as day,

'FIFA+ Collect' as collection,

sum(total_sales_amount_usd) as VOLUME,

avg(total_sales_amount_usd) as AVG_VOLUME,

sum(VOLUME) over (partition by collection order by day) as CUM_VOLUME,

count(distinct(tx_group_id)) as TRXS,

sum(TRXS) over (partition by collection order by day) as CUM_TRXS,

count(distinct(purchaser)) as BUYERS,

sum(BUYERS) over (partition by collection order by day) as CUM_BUYERS,

count(distinct( NUMBER_OF_NFTS)) AS NFT_IDS ,

sum(NFT_IDS) over (partition by collection order by day) as CUM_NFT_IDS,

count(distinct( purchaser)) AS SELLERS ,

sum(SELLERS) over (partition by collection order by day) as CUM_SELLERS,

row_number () over (order by day) as DAYS

from algorand.nft.ez_nft_sales_fifa

where sale_type = 'secondary'

group by 1