block_timestamp::date as day,

count(tx_id) as transactions_count,

count(distinct tx_sender) as unique_wallets,

sum(fee) as total_fee_luna,

sum(transactions_count) over (order by day) as cumulative_transactions_count,

sum(unique_wallets) over (order by day) as cumulative_unique_wallets,

sum(total_fee_luna) over (order by day) as cumulative_fee_luna

from terra.core.fact_transactions

where TX_SUCCEEDED = 'TRUE'

and block_timestamp >= CURRENT_DATE - {{Past_X_Days}}

group by day