select

nft_id,

nft_collection,

moment_tier,

player,

team,

season,

week,

play_type,

moment_description as description

from flow.core.dim_allday_metadata

),

nfl_all_day_all_sales as (

select

sale.tx_id as tx_id,

sale.nft_id as nft_id,

metadata.moment_tier as moment_tier,

metadata.player as player,

metadata.team as team,

metadata.season as season,

metadata.week as week,

metadata.play_type as play_type,

metadata.description as description,

sale.price as price,

sale.buyer as buyer,

sale.seller as seller

from flow.core.ez_nft_sales sale

join nfl_all_day_metadata metadata

on sale.nft_collection = metadata.nft_collection

and sale.nft_id = metadata.nft_id

where sale.tx_succeeded = true

and block_timestamp::date <= current_date - 1

and player != 'N/A'

)