shadilALGO Transaction Payment Size
Updated 2022-03-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
date(block_timestamp) as date,
case
when amount > 0 and amount <= 10 then '0-10'
when amount > 10 and amount <= 100 then '0-100'
when amount > 100 and amount <= 1000 then '0-1000'
when amount > 1000 and amount <= 10000 then '0-10000'
when amount > 10000 then '>10000'
end as algo_amount,
COUNT(DISTINCT tx_id) as counter
from algorand.payment_transaction
where amount is NOT NULL
AND date(block_timestamp) BETWEEN '2022-01-01' and CURRENT_DATE - 1
GROUP BY date, algo_amount
ORDER BY date
Run a query to Download Data