DEPOSITS_COUNT | WITHDRAWS_COUNT | TIME | |
|---|---|---|---|
1 | 16 | 69 | 2023-05-22 00:00:00.000 |
2 | 8 | 79 | 2023-05-15 00:00:00.000 |
3 | 23 | 96 | 2023-05-01 00:00:00.000 |
4 | 97 | 2 | 2023-03-08 00:00:00.000 |
5 | 496 | 15 | 2023-03-26 00:00:00.000 |
6 | 13 | 32 | 2023-06-21 00:00:00.000 |
7 | 1132 | 74 | 2023-04-02 00:00:00.000 |
8 | 444 | 16 | 2023-04-05 00:00:00.000 |
9 | 498 | 25 | 2023-03-30 00:00:00.000 |
10 | 209 | 5 | 2023-03-04 00:00:00.000 |
11 | 108 | 16 | 2023-03-06 00:00:00.000 |
12 | 3 | 113 | 2023-05-08 00:00:00.000 |
13 | 5 | 19 | 2023-07-05 00:00:00.000 |
14 | 221 | 9 | 2023-03-22 00:00:00.000 |
15 | 156 | 8 | 2023-03-19 00:00:00.000 |
16 | 27 | 43 | 2023-06-01 00:00:00.000 |
17 | 38 | 69 | 2023-07-09 00:00:00.000 |
18 | 26 | 25 | 2023-06-15 00:00:00.000 |
19 | 22 | 47 | 2023-06-11 00:00:00.000 |
20 | 17 | 50 | 2023-05-26 00:00:00.000 |
freemartianEtherfi Count - Daily Deposits & Withdraws
Updated 2024-02-11
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 - Daily Stakers & Deposits Count @ https://flipsidecrypto.xyz/edit/queries/c6611652-3788-4669-84fc-22dcebb6d81b
-- 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 (
Last run: about 1 year agoAuto-refreshes every 3 hours
...
133
4KB
342s