SELECT

BLOCK_TIMESTAMP,

tx_id,

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

(EVENT_DATA:nftID) AS mint,

(

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 purchaser,

(

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,

(event_data:commissionAmount :: float) AS Commissions

FROM

FLOW.CORE.FACT_EVENTS

WHERE

(

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