all_txs as (

select distinct

block_timestamp

, tx_id

from solana.core.fact_events

inner join solana.core.fact_transactions

using(block_timestamp, tx_id, succeeded)

where succeeded

and program_id = 'Leg1xVbrpq5gY6mprak3Ud4q4mBwcJi5C9ZruYjWv7n'

and array_contains('Program log: Instruction: CreateInscription' ::variant, log_messages)

and block_timestamp > '2023-11-13'

),

aggregated as (

select

date_trunc('day', block_timestamp) as date

, count(1) as inscriptions

, sum(inscriptions) over (order by date) as cumulative

from all_txs

group by 1

select *

from aggregated

order by date