with

flowty_marketplace as (

select *

from flow.core.fact_events

where event_type in ('OfferCompleted','ListingCompleted')

and event_contract in ('A.3cdbb3d569211ff3.NFTStorefrontV2','A.b8ea91944fd51c43.OffersV2')

and tx_succeeded = 'true'

and event_data:purchased = 'true'

,

OfferCompleted_Tb as (

select

block_timestamp,

tx_id,

EVENT_DATA:offerAddress::string as buyer,

EVENT_DATA:acceptingAddress::string as seller,

EVENT_DATA:offerAmount::float as sales_amount,

EVENT_DATA:offerType::string as collection,

EVENT_DATA:nftId::integer as nft_id,

EVENT_DATA:paymentVaultType as token

from flowty_marketplace

where event_type = 'OfferCompleted'

AND event_data::string like '%0x6590f8918060ef13%'

,

ListingCompleted_Tb as (

select

block_timestamp,

tx_id,

EVENT_DATA:buyer::string as buyer,

EVENT_DATA:storefrontAddress::string as seller,

EVENT_DATA:salePrice::float as sales_amount,

EVENT_DATA:nftType::string as collection,