date_trunc('day',block_timestamp::date) as "Date",

count(distinct tx_id) as "Daily Transactions",

sum("Daily Transactions") over (order by "Date") as "Cumulative Transactions",

count(distinct signers[0]) as "Unique Users"

FROM solana.core.fact_transactions

where INSTRUCTIONS[0]:programId = '2e1wdyNhUvE76y6yUCvah2KaviavMJYKoRun8acMRBZZ'

and SUCCEEDED = 'true'

and block_timestamp::date >= '2022-05-10'

group by 1

order by 1