block_timestamp,

tx_id,

event_type as event_name,

event_data:nftID::STRING AS nft_id,

event_data:salePrice::FLOAT AS sale_price,

event_data:purchased::BOOLEAN AS was_purchased,

event_data:customID::STRING AS custom_id,

event_data:commissionAmount::FLOAT AS commission_amount,

event_data:commissionReceiver::STRING AS commission_receiver,

event_data:expiry::NUMBER AS expiry

FROM flow.core.fact_events

WHERE event_contract LIKE 'A.9fe6773c00264045.NBAsageTrade%' -- Updated contract address

AND event_type = 'ListingCompleted'

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

ORDER BY block_timestamp DESC;