count (distinct tx_id) as transactions,

count (distinct signers[0]) as Users,

sum (inner_instructions[1]:instructions[0]:parsed:info:amount/1e6) as amount,

sum (transactions) over (order by date) as Cumu_transactions,

sum (Users) over (order by date) as Cumu_users,

sum (amount) over (order by date) as Cumu_amount

from solana.core.fact_transactions

where succeeded = 'TRUE'

and instructions[0]:programId = '6LtLpnUFNByNXLyCoK9wA2MykKAmQNZKBdY8s47dehDc'

group by 1

order by 1