SELECT

BLOCK_TIMESTAMP,

tx_id,

split(EVENT_DATA:nftType, '.')[2] as Collection,

( EVENT_DATA:nftID) AS token_id ,

(CASE

when EVENT_CONTRACT IN ('A.3cdbb3d569211ff3.NFTStorefrontV2') AND EVENT_TYPE = 'ListingCompleted' then event_data:buyer::string

when EVENT_CONTRACT IN ('A.b8ea91944fd51c43.OffersV2') AND EVENT_TYPE = 'OfferCompleted' then event_data:offerAddress::string

end) AS buyer_address,

(CASE

when EVENT_CONTRACT IN ('A.3cdbb3d569211ff3.NFTStorefrontV2') AND EVENT_TYPE = 'ListingCompleted' then event_data:storefrontAddress::string

when EVENT_CONTRACT IN ('A.b8ea91944fd51c43.OffersV2') AND EVENT_TYPE = 'OfferCompleted' then event_data:acceptingAddress::string

end) AS seller_address,

(CASE

when EVENT_CONTRACT IN ('A.3cdbb3d569211ff3.NFTStorefrontV2') AND EVENT_TYPE = 'ListingCompleted' then event_data:salePrice::float

when EVENT_CONTRACT IN ('A.b8ea91944fd51c43.OffersV2') AND EVENT_TYPE = 'OfferCompleted' then event_data:offerAmount::float

end) AS sale_price

FROM

FLOW.CORE.FACT_EVENTS

WHERE

(

EVENT_CONTRACT IN ('A.3cdbb3d569211ff3.NFTStorefrontV2')

AND EVENT_TYPE = 'ListingCompleted'

AND TX_SUCCEEDED = TRUE

AND EVENT_DATA:purchased::string = 'true'

and block_timestamp::date >= current_date-30

)

OR

(

EVENT_CONTRACT IN ('A.b8ea91944fd51c43.OffersV2')

AND EVENT_TYPE = 'OfferCompleted'

AND tx_succeeded = 'true'

AND EVENT_DATA::string LIKE '%0x6590f8918060ef13%'

AND EVENT_DATA:purchased LIKE '%true%'