nsa2000MATIC Staking Metrics
Updated 2022-09-21
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
32
33
34
35
36
›
⌄
with
lido_cte as (
-- deposit
select
BLOCK_TIMESTAMP
, BLOCK_TIMESTAMP::date date
, ORIGIN_FROM_ADDRESS
, AMOUNT
, AMOUNT_USD
, TX_HASH
from ethereum.core.ez_token_transfers
where 1=1
and CONTRACT_ADDRESS = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0' -- MATIC
and ORIGIN_TO_ADDRESS = '0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599' -- stMATIC
and ORIGIN_FUNCTION_SIGNATURE = '0xea99c2a6' -- submit
)
, claystack_cte as (
-- deposit
select
BLOCK_TIMESTAMP
, BLOCK_TIMESTAMP::date date
, ORIGIN_FROM_ADDRESS
, AMOUNT
, AMOUNT_USD
, TX_HASH
from ethereum.core.ez_token_transfers
where 1=1
and CONTRACT_ADDRESS = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0' -- MATIC
and ORIGIN_TO_ADDRESS = '0x91730940dce63a7c0501cedfc31d9c28bcf5f905' -- ClayMatic
and ORIGIN_FUNCTION_SIGNATURE = '0xb6b55f25' -- deposit
)
, ankr_cte as (
-- deposit
select
BLOCK_TIMESTAMP
, BLOCK_TIMESTAMP::date date
Run a query to Download Data