ordinals as (

select

block_timestamp,

block_number,

tx_id,

fee, -- BTC

input_value,

output_value,

size, -- Byte

virtual_size, -- vByte

fee * pow(10, 8) / virtual_size as fee_rate, -- sat/vB,

outputs[0]:scriptPubKey:address as minter,

hex

from

bitcoin.core.fact_transactions

where

block_number > 767429

and block_timestamp::date between '2023-12-01' and '2024-03-05'

and hex like '%0063036f726401%'

)

block_timestamp::date as "Date",

count(distinct block_number) as "Blocks",

count(distinct tx_id) as "Inscriptions",

count(distinct minter) as "Minters",

sum(fee) as "Fees",

sum(input_value) as "Input Value",

- sum(output_value) as "Output Value",

sum(size) as "Size",

sum(virtual_size) as "Vitrual Size",

avg(fee_rate) as "Average Fee Rate",

median(fee_rate) as "Median Fee Rate",

sum("Blocks") over (order by "Date") as "Cumulative Blocks",

sum("Inscriptions") over (order by "Date") as "Cumulative Inscriptions",

sum("Minters") over (order by "Date") as "Cumulative Minters",