binhachonALGO Transaction Payment Size
Updated 2022-03-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
with transactions as (
select
block_timestamp,
coalesce(amount, 0) as amount
from algorand.payment_transaction
where block_timestamp::date >= '2022-01-01'
),
transaction_count as (
select
date_trunc('day', block_timestamp) as time,
case
when 10 > amount then '1. 0 - 10 Algo'
when 100 > amount >= 10 then '2. 10 - 100 Algo'
when 1000 > amount >= 100 then '3. 100 - 1000 Algo'
when 10000 > amount >= 1000 then '4. 1000 - 10000 Algo'
when amount >= 10000 then '5. 10000+ Algo'
end as category,
count(*) as number_of_transactions,
sum(amount) as volume
from transactions
group by time, category
)
select * from transaction_count
order by time, number_of_transactions
Run a query to Download Data