strawbettyTotal volume in USD
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
›
⌄
with fees as (select TX_GROUP_ID as group_,*
from algorand.payment_transaction
where receiver = 'XNFT36FUCFRR6CK675FW4BEBCCCOJ4HOSMGCN6J2W6ZMB34KM2ENTNQCP4'
)
,
algo as ( select date(BLOCK_TIMESTAMP) as data, sum(amount) as total_algo
from algorand.payment_transaction
where TX_GROUP_ID in ( select group_ from fees) and block_timestamp::date >= '2022-01-01'
group by 1
order by 1)
,
price as ( select date(BLOCK_HOUR) as date , avg(price_usd) as price_usd
from algorand.prices_swap
where asset_id = 0 and BLOCK_HOUR::date >= '2022-01-01'
group by 1)
select data, total_algo , price_usd , total_algo*price_usd as total_volume_usd
from algo join price
where date = data
and date >= '2022-01-01'
order by 1
Run a query to Download Data