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

, avax_value

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 tr.block_timestamp >= '2022-06-16'

and tx_status = 'SUCCESS'

and event_name = 'Transfer'

and tr.block_timestamp::date < CURRENT_DATE

select

distinct block_timestamp::date as DAY

, avg(tx_fee) over (partition by Day) as myAvg_daily_sales_feees

, avg(tx_fee) over () as mysales_Avg_feees

, avg(avax_value) over () as mynft_avg_price

, sum(avax_value) over (partition by Day) as mydaily_sales_volume

, sum(tx_fee) over (partition by Day) as mydaily_sales_feees

, count(tx_hash) over (partition by Day) as mydaily_sales_tx

from

avalanche.core.fact_transactions

WHERE tx_hash in (select tx_hash from nft_sales_transactions)

order by day