date_trunc('day',block_timestamp) as date,

case input_data

when '0x646174613a2c7b2270223a226173632d3230222c226f70223a226d696e74222c227469636b223a226176616c222c22616d74223a22313030303030303030227d' then 'Inscription'

else 'Other'

end as type,

count(distinct from_address) as users,

count(distinct tx_hash) as tx,

sum(tx) over (order by date) as cum_tx,

avg(tx_fee) as avg_tx_fee

from avalanche.core.fact_transactions

where block_timestamp>=current_date-interval '3 months'

and block_timestamp<current_date

group by 1,2 order by 1 asc