with buy as (

select

tx_hash,

receiver_id as platform,

block_timestamp,

SIGNER_ID as buyer,

args:nft_contract_id :: string as collection,

args:token_id :: string as token_id,

args:price :: int / pow(10, 24) as price

from near.core.fact_actions_events_function_call

where method_name = 'buy'

and RECEIVER_ID = 'marketplace.paras.near'

and RECEIPT_SUCCEEDED = 'TRUE'

and block_timestamp :: date >= current_date - 7

,

near_price as (

select

date_trunc('hour', timestamp) as date,

AVG(price_usd) as price_usd

from near.price.fact_prices

where symbol ilike 'wNEAR'

group by 1

select

a.block_timestamp,

a.tx_hash,

a.platform,

a.buyer,

a.collection,

a.token_id,

a.price,