date_trunc('day', hour) day,

avg(price) price

from ethereum.price.ez_hourly_token_prices

where symbol ilike 'WBTC'

group by day

select

count(*) total_inscriptions,

count(distinct outputs[0]:scriptPubKey:address) unique_minters,

sum(size) size_usage,

sum(virtual_size) virtual_size_usage,

sum(fee) fees_btc,

sum(fee*price) fees_usd

from bitcoin.core.fact_transactions fact_tx

join price_btc

on fact_tx.block_timestamp::date = price_btc.day

where block_number > 767429

and hex like '%0063036f726401%'