trunc(block_timestamp,'day') as date,

count(distinct tx_id) as txs,

sum(txs) over (order by date) as cum_txs,

avg(txs) over (order by date, date rows between 6 preceding and current row) as ma7_txs,

avg(txs) over (order by date, date rows between 14 preceding and current row) as ma15_txs,

avg(txs) over (order by date, date rows between 29 preceding and current row) as ma30_txs,

sum(TX:body:messages[0]:amount[0]:amount)/pow(10,6) as volume,

sum(volume) over (order by date) as cum_volume,

avg(volume) over (order by date, date rows between 6 preceding and current row) as ma7_volume,

avg(volume) over (order by date, date rows between 14 preceding and current row) as ma15_volume,

avg(volume) over (order by date, date rows between 29 preceding and current row) as ma30_volume

FROM terra.core.fact_transactions

WHERE tx:body:messages[0]:amount[0]:denom = 'uluna' -- LUNA 2.0 ACTIONS

AND block_timestamp > '2022-05-28' -- LUNA 2.0 LAUNCH

AND tx_succeeded = true

group by 1

order by 1