select

block_timestamp

, tx_hash

, event_inputs:from as seller

, origin_from_address as purchaser

, event_inputs:tokenId as token_id

, contract_address as nft_address

from avalanche.core.fact_event_logs lg inner join avalanche.core.fact_transactions tr using(tx_hash)

where

event_inputs:tokenId is not null

and event_inputs:from != '0x0000000000000000000000000000000000000000'

and avax_value>0

and event_inputs:to !='0x0000000000000000000000000000000000000000'

and tx_status = 'SUCCESS'

and event_name = 'Transfer'

)

,avax_vol as (

select

block_timestamp,

a.tx_hash,

avax_value

from avalanche.core.fact_transactions a inner join avax_nft_sales_transactions b using(tx_hash)

),

AVAX_PRICE AS (

SELECT

BLOCK_TIMESTAMP::date as date_Price,

avg(AMOUNT_IN_USD/AMOUNT_IN) as "PRICE (USD)"

FROM avalanche.sushi.ez_swaps

WHERE symbol_in = 'WAVAX'

and symbol_out = 'USDC'

AND BLOCK_TIMESTAMP::date >= '2022-01-01'

group by 1

ORDER by 1

, op_nft_sales_transactions as (