strawbettystaking actions a day
Updated 2022-05-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with staking_num as (
select
t2.tx_message:txn:aamt/1e6 as vol,
t2.*
from
algorand.transactions t1
join algorand.transactions t2 on t1.tx_group_id = t2.tx_group_id
and t2.asset_id = '571576867'
and t2.block_timestamp >= '2022-03-01'
where TRY_BASE64_DECODE_STRING(t1.tx_message :txn :apaa [0] :: STRING) = 'S'
and t1.tx_message:txn:apid = '710543830'
and t1.block_timestamp >= '2022-03-01'
)
select
block_timestamp::date as date,
count(distinct tx_group_id) as transact,
sum(vol) as staked_volume
from staking_num
group by date
Run a query to Download Data