Abbas_ra21staking daily stats
Updated 2022-07-03
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
›
⌄
select
A.Day AS Day,
unstaked,
staked
from
(
select
DATE_TRUNC ('day' ,BLOCK_TIMESTAMP ) AS Day,
+sum(RAW_AMOUNT/1e9) AS unstaked
from ethereum.core.ez_token_transfers
where
FROM_ADDRESS='0x759c6de5bca9ade8a1a2719a31553c4b7de02539' AND ORIGIN_FUNCTION_SIGNATURE='0x990966d5'
AND BLOCK_TIMESTAMP > DateAdd(d, -89, GetDate())
group by 1) A
inner join
(select
DATE_TRUNC ('day' ,BLOCK_TIMESTAMP ) AS Day,
(sum(RAW_AMOUNT/1e9)) AS staked
from ethereum.core.ez_token_transfers
where
TO_ADDRESS='0x759c6de5bca9ade8a1a2719a31553c4b7de02539' AND ORIGIN_FUNCTION_SIGNATURE='0xd866c9d8'
AND BLOCK_TIMESTAMP > DateAdd(d, -89, GetDate())
group by 1)B
on A.Day=B.Day
Run a query to Download Data