SELECT

block_timestamp as sale_date,

nft_id,

price

FROM flow.core.fact_nft_sales

WHERE nft_collection = 'A.e4cf4bdc1751c65d.AllDay'

ORDER BY price DESC

LIMIT 10

)

SELECT a.sale_date, a.nft_id, a.price, b.player, b.team, b.classification, b.moment_tier, b.play_type, b.series, b.set_name, b.moment_description

FROM top_sales a

LEFT JOIN flow.core.dim_allday_metadata b

ON a.nft_id = b.nft_id