block_timestamp::date day,

case

when hex like '%0063036f726401%' then 'Ordinals tx'

else 'Other tx'

end tx_type,

count(distinct tx_id) tx,

sum(fee) fee_btc

from bitcoin.core.fact_transactions

where block_number > 767429

group by day, tx_type

order by day