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

),

nft_data AS (

SELECT

block_timestamp AS mintdate,

event_data:editionID AS editionID,

event_data:id AS momentID,

event_data:serialNumber AS serialID

FROM flow.core.fact_events

WHERE event_contract = 'A.e4cf4bdc1751c65d.AllDay'

AND event_type = 'MomentNFTMinted'

AND event_data:id IN (SELECT nft_id FROM top_sales)

SELECT *

FROM top_sales

LEFT JOIN nft_data

ON nft_id = momentID