select
date_trunc('day', BLOCK_TIMESTAMP) AS Day,
count(*) AS Inscriptions,
sum(Inscriptions) OVER (
ORDER BY
Day
) AS "Cumulative Inscriptions",
sum(size) AS "Size Usage",
sum(virtual_size) AS "vSize Usage",
sum(fee) Fees,
sum(Fees) OVER (
ORDER BY
Day
) AS "Cumulative Fees"
FROM
bitcoin.core.fact_transactions
WHERE
BLOCK_NUMBER > 767429
AND hex LIKE '%0063036f726401%'
GROUP BY
1
ORDER by
1 DESC;