strawbettyDaily volume in ALGO
Updated 2022-05-12
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
28
29
30
31
›
⌄
with tx_group_ids_0 as (
select tx_group_id as group_id
from algorand.payment_transaction
where receiver ='XNFT36FUCFRR6CK675FW4BEBCCCOJ4HOSMGCN6J2W6ZMB34KM2ENTNQCP4'
group by 1
),
tx_group_ids as (
select tx_group_id as group_id , max(amount) as sale_amount
from algorand.payment_transaction
where tx_group_id in (select * from tx_group_ids_0 )
and amount is not NULL
group by 1
),
amounts as (
select date_trunc('hour',block_timestamp) as hour ,
sum (sale_amount) as Volume ,
count (DISTINCT tx_group_id) as transactions,
sum (sale_amount*price_usd) as USD_volume
from algorand.payment_transaction p join tx_group_ids ids join algorand.prices_swap
on ids.group_id = p.tx_group_id
and date_trunc('hour',block_timestamp) = date_trunc('hour',block_hour)
where prices_swap.asset_id = 0
group by 1
)
select date_trunc('day',hour) as date ,
sum (Volume) as volume ,
sum ( transactions ) as transactions ,
sum (USD_volume) as USD_volume
from amounts
group by 1
Run a query to Download Data