STAKERS_COUNT | DEPOSITS_COUNT | TIME | TOKEN | |
|---|---|---|---|---|
1 | 1176 | 1202 | 2023-04-01 00:00:00.000 | ETH |
2 | 433 | 433 | 2023-04-16 00:00:00.000 | ETH |
3 | 25 | 25 | 2023-06-15 00:00:00.000 | ETH |
4 | 465 | 469 | 2023-04-08 00:00:00.000 | ETH |
5 | 466 | 482 | 2023-03-30 00:00:00.000 | ETH |
6 | 381 | 385 | 2023-03-28 00:00:00.000 | ETH |
7 | 21 | 21 | 2023-06-02 00:00:00.000 | ETH |
8 | 29 | 29 | 2023-03-12 00:00:00.000 | ETH |
9 | 3 | 4 | 2023-03-02 00:00:00.000 | rETH |
10 | 11 | 11 | 2023-04-05 00:00:00.000 | rETH |
11 | 3 | 3 | 2023-03-26 00:00:00.000 | sfrxETH |
12 | 5 | 5 | 2023-04-08 00:00:00.000 | wstETH |
13 | 2 | 3 | 2023-03-02 00:00:00.000 | sfrxETH |
14 | 2 | 2 | 2023-07-06 00:00:00.000 | sfrxETH |
15 | 3 | 3 | 2023-03-04 00:00:00.000 | cbETH |
16 | 1 | 1 | 2023-06-21 00:00:00.000 | wstETH |
17 | 2 | 2 | 2023-07-07 00:00:00.000 | sfrxETH |
18 | 1 | 1 | 2023-03-24 00:00:00.000 | sfrxETH |
19 | 1 | 1 | 2023-06-06 00:00:00.000 | wstETH |
20 | 1 | 1 | 2023-04-30 00:00:00.000 | sfrxETH |
freemartianEtherfi Count - Daily Stakers & Deposits Count
Updated 2024-01-29
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
›
⌄
-- forked from Etherfi Count - total count by token @ https://flipsidecrypto.xyz/edit/queries/5ce23d7d-e7b1-4b26-96c2-99982d1b45b6
-- forked from Etherfi Count - total @ https://flipsidecrypto.xyz/edit/queries/ded0ef30-05c2-438f-b086-8e2b954462d0
with deposits as (
select
tx_hash,
block_timestamp,
eth_from_address as depositor,
amount,
'ETH' as token
from ethereum.core.ez_eth_transfers
where eth_to_address = '0x7623e9dc0da6ff821ddb9ebaba794054e078f8c4'
and origin_function_signature = '0x98ea5fca'
UNION
select
tx_hash,
block_timestamp,
from_address as depositor,
amount,
CASE
when contract_address = '0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0' then 'wstETH'
when contract_address = '0xac3e018457b222d93114458476f3e3416abbe38f' then 'sfrxETH'
when contract_address = '0xae78736cd615f374d3085123a210448e74fc6393' then 'rETH'
when contract_address = '0xbe9895146f7af43049ca1c1ae358b0541ea49704' then 'cbETH'
end as token
from ethereum.core.ez_token_transfers
where to_address = '0x7623e9dc0da6ff821ddb9ebaba794054e078f8c4'
and origin_function_signature = '0x47e7ef24'
),
withdraws as (
SELECT
tx_hash,
Last run: over 1 year agoAuto-refreshes every 3 hours
...
381
15KB
61s