mariyaUntitled Query
9
1
2
3
4
5
6
7
8
›
⌄
select block_timestamp::date as date,
sum(amount) as daily_Cumulative_ALGO_Fee,
sum Count(daily_Cumulative_ALGO_Fee_Txs) over(order_by_day)as Cumulative_Total_Txs
from algorand.payment_transaction
where asset_id = 0
and date >= '2022-01-01'::date - 7
group by date
order by date
Run a query to Download Data