Address | Total Value Locked (ETH) | Total Value Locked(USD) | Total Value Locked (USD) | |
|---|---|---|---|---|
1 | 0x602f9d37dd5cddc1feee4f93034d066d2fe0503b | 17.8 | 29858.34 | $29,858 |
2 | 0x3f179c5fc34b172eafc15e360765860501942953 | 10.1 | 16957.4 | $16,957 |
3 | 0xd6df4739d072b946f8ed923df99c767ee4258cbc | 10 | 16779.53 | $16,780 |
4 | 0xd090337edef149164d517051c29ef6cfac3faf44 | 10 | 16779.53 | $16,780 |
5 | 0x5386c4b1c1a8b7e4542722f2ebba24573874ac29 | 9.1 | 15244.21 | $15,244 |
6 | 0x58179fe0488e8224039ddd093f652b4605ed11d4 | 4.7 | 7909.87 | $7,910 |
7 | 0xc5c8eff68183581f8a108ce6414a21a6675a4b79 | 4 | 6711.81 | $6,712 |
8 | 0xa21cac491798843c233f84422c005e71d754650e | 3.6 | 6101.07 | $6,101 |
9 | 0x20b4a8ce0b1d02d8b4c18c7e511bb6fbba6b04ec | 3.5 | 5852 | $5,852 |
10 | 0xc3b0c233304e29875da7035247aaf519b4596048 | 3.3 | 5537.25 | $5,537 |
11 | 0xcf6958a6ac07b989dda0150d9cff4e2293bccbc7 | 3 | 5017.08 | $5,017 |
12 | 0x866723d6ce69b3d0b8657afec856a4325015c609 | 3 | 5033.86 | $5,034 |
13 | 0xce9a21635269b14e815615e0e6d1613c0789eaf3 | 2.8 | 4729.81 | $4,730 |
14 | 0x4aabd422abe35b6b6e0b308dea05fd4973e415a7 | 2.3 | 3834.12 | $3,834 |
15 | 0xd3c6fd5a4d1e6588ecc044e40c5c29fcd011d23f | 2 | 3355.91 | $3,356 |
16 | 0x04c4a90801d1ef5ae8576a0a5bdd8eeab362a644 | 2 | 3355.91 | $3,356 |
17 | 0x018de6e5e01ba8df7583e16fe37200d5784f405e | 2 | 3355.91 | $3,356 |
18 | 0xb608e64db2193d0d6a2a1bf3e30ae58e7564a73b | 2 | 3355.91 | $3,356 |
19 | 0xbec08a5b7259564022b15a22f514aa00eb955127 | 2 | 3355.91 | $3,356 |
20 | 0xf459188ef6b65b64cc2560d0ecbaf1798a980de6 | 2 | 3357.58 | $3,358 |
spacebarTotal Value Locked By User
Updated 4 hours ago
999
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 generateDateSeries as (
SELECT
CAST(CAST(date AS TIMESTAMP) AS DATE) as date
FROM
(
SELECT
DATEADD(DAY, SEQ4(), '2024-02-01') AS date
FROM
TABLE(GENERATOR(ROWCOUNT => 1000))
) x
WHERE
date <= CURRENT_DATE
),
stakedBalance as (
SELECT
date_trunc('day', block_timestamp) as date,
index_user,
SUM(
SUM(
CASE
WHEN action = 'Staked' THEN amount
ELSE - amount
END
)
) OVER (
partition by index_user
ORDER BY
date_trunc('day', block_timestamp)
) as cumulative_balance
FROM
(
SELECT
block_timestamp,
block_number,
topics [2] as index_user,
(utils.udf_hex_to_int(data) :: int) / 1e18 as amount,
Last run: about 4 hours agoAuto-refreshes every 1 hour
...
9242
635KB
317s