nft_mints AS (

SELECT

lg.block_timestamp,

lg.tx_hash,

lgs.origin_to_address as platform_address,

lg.decoded_log:to as minter,

lg.contract_address as nft_address,

lbl.project_name as nft_name,

lg.decoded_log:tokenId as tokenid

FROM

avalanche.core.fact_decoded_event_logs lg

JOIN avalanche.core.fact_event_logs lgs ON lg.contract_address = lgs.contract_address

LEFT JOIN avalanche.core.dim_labels lbl ON lg.contract_address = lbl.address

WHERE

event_name = 'Transfer'

AND decoded_log:tokenId IS NOT NULL

AND decoded_log:

from

= '0x0000000000000000000000000000000000000000'

AND decoded_log:to != '0x0000000000000000000000000000000000000000'

),

avaxprice AS (

SELECT

HOUR::date as p_date,

avg(price) as avax_price

FROM

ethereum.core.fact_hourly_token_prices

WHERE

symbol = 'WAVAX'

GROUP by

1

),

nft_transfers AS (

SELECT

dlg.block_timestamp,