with metadata as

(select name, ADDRESS,PARENT_ADDRESS,

ROW_NUMBER() OVER (PARTITION BY ADDRESS ORDER BY UPDATE_TIMESTAMP_ONCHAIN) AS rn

from ton.nft.fact_nft_metadata

where PARENT_ADDRESS = '0:80D78A35F955A14B679FAA887FF4CD5BFC0F43B4A4EEA2A7E6927F3701B273C2'

and type = 'item'

QUALIFY rn = 1 ),

ton_prcie as (

select hour::date as day,

round(avg(close)) as ton_price

from crosschain.price.fact_prices_ohlc_hourly

where hour::date >= '2024-01-01'

and ASSET_ID = 'the-open-network'

and provider = 'coingecko'

group by all),

mints as (select

a.BLOCK_TIMESTAMP,

a.TX_HASH,

name,

PREV_OWNER as minter,

value/1e9 as fee,

fee*ton_price as f_usd,

from ton.nft.fact_nft_events a

join metadata on ADDRESS = NFT_ITEM_ADDRESS

and PARENT_ADDRESS = COLLECTION_ADDRESS

join ton.core.fact_messages b

on PREV_OWNER = source

and COLLECTION_ADDRESS = destination

and a.trace_id = b.trace_id

join ton_prcie on a.BLOCK_TIMESTAMP::date = day

where

b.BLOCK_TIMESTAMP::date >= '{{Starting_date}}' and