Validator address | DAY | VALIDATOR_NAME | TOTAL_DELEGATION | TOTAL_UNDELEGATION | Daily New Delegation | Cumulative New Delegation | |
|---|---|---|---|---|---|---|---|
1 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-09 00:00:00.000 | BeraHome | 182.47924085 | 0 | 182.47924085 | 182.47924085 |
2 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-10 00:00:00.000 | BeraHome | 502.354473952 | 0 | 502.354473952 | 684.833714802 |
3 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-11 00:00:00.000 | BeraHome | 1293.899126729 | 0 | 1293.899126729 | 1978.732841532 |
4 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-12 00:00:00.000 | BeraHome | 40142.725122841 | 0.4149004176 | 40142.310222424 | 42121.043063955 |
5 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-13 00:00:00.000 | BeraHome | 229.548589484 | 0 | 229.548589484 | 42350.591653439 |
6 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-14 00:00:00.000 | BeraHome | 274.721776432 | 22.061822839 | 252.659953593 | 42603.251607033 |
7 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-15 00:00:00.000 | BeraHome | 855.082696125 | 0 | 855.082696125 | 43458.334303158 |
8 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-16 00:00:00.000 | BeraHome | 1185.107309459 | 0 | 1185.107309459 | 44643.441612617 |
9 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-17 00:00:00.000 | BeraHome | 5800.306069399 | 10403.821346108 | -4603.515276709 | 40039.926335908 |
10 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-18 00:00:00.000 | BeraHome | 2202.919837895 | 0 | 2202.919837895 | 42242.846173803 |
11 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-19 00:00:00.000 | BeraHome | 48621.726830753 | 181 | 48440.726830753 | 90683.573004556 |
12 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-20 00:00:00.000 | BeraHome | 7707.652786553 | 20001.1 | -12293.447213447 | 78390.125791109 |
13 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-21 00:00:00.000 | BeraHome | 1353.690544143 | 76.777012644 | 1276.913531499 | 79667.039322608 |
14 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-22 00:00:00.000 | BeraHome | 15936.234631431 | 18.127204887 | 15918.107426544 | 95585.146749152 |
15 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-23 00:00:00.000 | BeraHome | 18571.701891154 | 6 | 18565.701891154 | 114150.848640305 |
16 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-24 00:00:00.000 | BeraHome | 811.884469637 | 0 | 811.884469637 | 114962.733109942 |
17 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-25 00:00:00.000 | BeraHome | 2047.996593819 | 5 | 2042.996593819 | 117005.729703761 |
18 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-26 00:00:00.000 | BeraHome | 2020.243912274 | 251.083743046 | 1769.160169228 | 118774.889872989 |
19 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-27 00:00:00.000 | BeraHome | 1580.028748169 | 6.1037 | 1573.925048169 | 120348.814921158 |
20 | 0xbbbbd949408332cb50b9f3cb47460b9faa068758 | 2024-10-28 00:00:00.000 | BeraHome | 1070.048273573 | 0 | 1070.048273573 | 121418.863194731 |
TerpLayerNew Delegation
Updated 2025-01-14
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 undelegation_database AS (
WITH database AS (
WITH tbl AS (
SELECT *
FROM berachain.testnet.fact_event_logs
WHERE
ORIGIN_TO_ADDRESS = '0xbda130737bdd9618301681329bf2e46a016ff9ad'
AND CONTRACT_ADDRESS = '0xbda130737bdd9618301681329bf2e46a016ff9ad'
AND ORIGIN_FUNCTION_SIGNATURE = '0xe1f63d2e'
AND TX_SUCCEEDED = 'TRUE'
)
SELECT
block_timestamp,
DATE_TRUNC('day', block_timestamp) AS day,
tx_hash,
'0x' || SUBSTR(PARSE_JSON(TOPICS)[1]::string, -40) AS user_wallet,
'0x' || SUBSTR(PARSE_JSON(TOPICS)[2]::string, -40) AS validator_address,
utils.udf_hex_to_int(DATA) / pow(10, 18) AS undelegated_amount
FROM tbl
)
SELECT validator_address, day, SUM(undelegated_amount) AS total_undelegation
FROM database
GROUP BY validator_address, day
ORDER BY total_undelegation DESC
),
delegation_database AS (
WITH database AS (
WITH tbl AS (
SELECT *
FROM berachain.testnet.fact_event_logs
WHERE
ORIGIN_TO_ADDRESS = '0xbda130737bdd9618301681329bf2e46a016ff9ad'
AND CONTRACT_ADDRESS = '0xbda130737bdd9618301681329bf2e46a016ff9ad'
AND ORIGIN_FUNCTION_SIGNATURE = '0x95c0e232'
AND TX_SUCCEEDED = 'TRUE'
)
Last run: 3 months ago
98
13KB
474s