select

date_trunc('day', block_timestamp) as day,

count(distinct signers[0]) as "Number of Users",

avg("Number of Users") over (order by day rows between 14 preceding and current row) as "Daily Users Moving Average",

sum("Number of Users") over (order by day) as cumulative_number_of_users,

count(distinct tx_id) as "Number of Transactions",

avg("Number of Transactions") over (order by day rows between 14 preceding and current row) as "Transactions Moving Average",

sum("Number of Transactions") over (order by day) as cumulative_number_of_transactions,

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

avg("Volume") over (order by day rows between 14 preceding and current row) as "Volume Moving Average",

sum("Volume") over (order by day) as cumulative_volume

from

solana.core.fact_transactions

where

inner_instructions[1]:instructions[0]:parsed:info:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'

and succeeded

group by

day

order by

day asc