block_timestamp,

tx_id,

event_type as event_name,

event_data:NFTReceiver::STRING AS buyer_address,

event_data:nftID::STRING AS nft_id,

event_data:name::STRING AS nft_name,

event_data:questionID::STRING AS question_id,

event_data:side::STRING AS side

FROM flow.core.fact_events

WHERE event_contract LIKE 'A.7d09be7121e058eb.NBAsageNFT%' -- Contract for NBAsageNFT

AND event_type = 'NFTPurchased'

AND block_timestamp >= DATEADD(day, -300, CURRENT_TIMESTAMP())

ORDER BY block_timestamp DESC;