Address | Total Value Locked (ETH) | Total Value Locked(USD) | Total Value Locked (USD) | |
|---|---|---|---|---|
1 | 0x602f9d37dd5cddc1feee4f93034d066d2fe0503b | 17.8 | 32190.61 | $32,191 |
2 | 0x3f179c5fc34b172eafc15e360765860501942953 | 10.1 | 18281.96 | $18,282 |
3 | 0xd6df4739d072b946f8ed923df99c767ee4258cbc | 10 | 18090.2 | $18,090 |
4 | 0xd090337edef149164d517051c29ef6cfac3faf44 | 10 | 18090.2 | $18,090 |
5 | 0x5386c4b1c1a8b7e4542722f2ebba24573874ac29 | 9.1 | 16434.95 | $16,435 |
6 | 0x58179fe0488e8224039ddd093f652b4605ed11d4 | 4.7 | 8527.72 | $8,528 |
7 | 0xc5c8eff68183581f8a108ce6414a21a6675a4b79 | 4 | 7236.08 | $7,236 |
8 | 0xa21cac491798843c233f84422c005e71d754650e | 3.6 | 6577.63 | $6,578 |
9 | 0x20b4a8ce0b1d02d8b4c18c7e511bb6fbba6b04ec | 3.5 | 6309.11 | $6,309 |
10 | 0xc3b0c233304e29875da7035247aaf519b4596048 | 3.3 | 5969.77 | $5,970 |
11 | 0x866723d6ce69b3d0b8657afec856a4325015c609 | 3 | 5427.06 | $5,427 |
12 | 0xcf6958a6ac07b989dda0150d9cff4e2293bccbc7 | 3 | 5408.97 | $5,409 |
13 | 0xce9a21635269b14e815615e0e6d1613c0789eaf3 | 2.8 | 5099.26 | $5,099 |
14 | 0x4aabd422abe35b6b6e0b308dea05fd4973e415a7 | 2.3 | 4133.61 | $4,134 |
15 | 0x1518ba893f8a3adb1bbce1614bb3439ac1a66ca4 | 2 | 3618.04 | $3,618 |
16 | 0xd3c6fd5a4d1e6588ecc044e40c5c29fcd011d23f | 2 | 3618.04 | $3,618 |
17 | 0x04c4a90801d1ef5ae8576a0a5bdd8eeab362a644 | 2 | 3618.04 | $3,618 |
18 | 0x8b5b3ea7a18c91bda9e63c924822cbf5b21e636e | 2 | 3618.04 | $3,618 |
19 | 0x944406f35ff2f30332d102b29760163420028bf9 | 2 | 3618.04 | $3,618 |
20 | 0x018de6e5e01ba8df7583e16fe37200d5784f405e | 2 | 3618.04 | $3,618 |
spacebarTotal Value Locked By User
Updated 6 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 6 hours agoAuto-refreshes every 1 hour
...
9242
635KB
117s