count(distinct from_address) as "Wallets",

count(distinct tx_hash) as "Transactions",

sum("Transactions") over (order by daily asc) as "Cumulative Transactions",

avg("Wallets") over (order by daily rows between 7 preceding and current row) as "7dd Moving Average Wallet Count"

from mezo.testnet.fact_transactions

group by 1;