alirsAlgoDex Volume
Updated 2022-07-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with algodex_txns as (
select
TRY_BASE64_DECODE_STRING(tx_message:txn:note) as note,
replace(REGEXP_SUBSTR(note,'("escrowOrderType":)("\\w+")'),'\"','') as order_type,
*
from algorand.transactions
where
block_timestamp::date >= '2022-02-09'and block_timestamp::date <= '2022-07-02'
and order_type is not null
)
select
date_trunc('day',block_timestamp) as date,
sum(tx_message:txn:amt/1e6) as algo_amount,
sum(algo_amount) over (order by date asc rows between unbounded preceding and current row) as cumulative_algo_amount
from algorand.transactions
where tx_group_id in (select tx_group_id from algodex_txns)
and asset_id = 0 -- ALGO
and block_timestamp::date >= '2022-02-09'and block_timestamp::date <= '2022-07-02'
group by date
Run a query to Download Data