select

block_timestamp,

tx_hash as avax_tx,

event_inputs:from as avax_seller,

event_inputs:to as avax_purchaser

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'

,op as (

SELECT

block_timestamp::date as date,

tx_hash as op_tx,

seller_address as op_sellers,

buyer_address as op_buyers

from optimism.core.ez_nft_sales

)

select

block_timestamp::date as day,

count(DISTINCT b.op_buyers) as buyer_cnt,

sum(buyer_cnt) over (order by day) as cum_buyer_cnt

from avax a join op b on a.avax_purchaser = b.op_sellers

group by 1