DATETIME | Delegated Volume | Undelegated Volume | |
---|---|---|---|
1 | 2024-06-19 00:00:00.000 | 110024.598213796 | -20081.135448133 |
2 | 2024-09-01 00:00:00.000 | 388886.982155403 | -5348.672224084 |
3 | 2024-11-27 00:00:00.000 | 238111.27474383 | -81572.996243112 |
4 | 2024-06-21 00:00:00.000 | 177872.252213036 | -25105.532343285 |
5 | 2024-08-22 00:00:00.000 | 522766.574166069 | -213394.182291136 |
6 | 2024-10-18 00:00:00.000 | 647727.978804371 | -11521.062084021 |
7 | 2025-01-10 00:00:00.000 | 142022.272145757 | -34595.757426603 |
8 | 2024-07-04 00:00:00.000 | 135464.418744209 | -2236.53521853 |
9 | 2024-08-31 00:00:00.000 | 246451.259756098 | -5211.862558204 |
10 | 2024-10-27 00:00:00.000 | 312621.454946918 | -6024.720530002 |
11 | 2024-12-20 00:00:00.000 | 283403.958511085 | -110867.80849737 |
12 | 2024-07-07 00:00:00.000 | 366359.751923005 | -721.697517836 |
13 | 2025-01-19 00:00:00.000 | 571968.151799684 | -458509.165092564 |
14 | 2024-11-30 00:00:00.000 | 226615.369646471 | -29402.50662408 |
15 | 2024-09-07 00:00:00.000 | 107912.821000509 | -3749.876105334 |
16 | 2024-07-22 00:00:00.000 | 226146.582759855 | -6314.222241638 |
17 | 2024-08-15 00:00:00.000 | 852165.868337426 | -32572.067432513 |
18 | 2024-06-20 00:00:00.000 | 243999.903732199 | -705.600067009 |
19 | 2024-09-30 00:00:00.000 | 265450.97208279 | -5046.057213173 |
20 | 2024-11-23 00:00:00.000 | 191871.113605439 | -39391.189294337 |
tkvresearchhurt-fuchsia
Updated 2025-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
›
⌄
with delegate_data as
(select
BLOCK_TIMESTAMP,
TX_HASH,
'0x' || SUBSTR(PARSE_JSON(TOPICS)[1]::string, -40) AS user_wallet,
-- '0x' || SUBSTR(PARSE_JSON(TOPICS)[2]::string, -40) AS validator_address,
TOPICS,
utils.udf_hex_to_int(DATA)/power(10,18) as data_raw
FROM berachain.testnet.fact_event_logs
where ORIGIN_TO_ADDRESS = '0xbda130737bdd9618301681329bf2e46a016ff9ad'
and
contract_address = '0xbda130737bdd9618301681329bf2e46a016ff9ad'
and
TX_SUCCEEDED = 'TRUE'
and
ORIGIN_FUNCTION_SIGNATURE = '0x95c0e232'),
undelegate_data as (
select
BLOCK_TIMESTAMP,
TX_HASH,
'0x' || SUBSTR(PARSE_JSON(TOPICS)[1]::string, -40) AS user_wallet,
-- '0x' || SUBSTR(PARSE_JSON(TOPICS)[2]::string, -40) AS validator_address,
TOPICS,
utils.udf_hex_to_int(DATA)/power(10,18) as data_raw
FROM berachain.testnet.fact_event_logs
where
ORIGIN_TO_ADDRESS = '0xbda130737bdd9618301681329bf2e46a016ff9ad'
and
contract_address = '0xbda130737bdd9618301681329bf2e46a016ff9ad'
and
TX_SUCCEEDED = 'TRUE'
and
ORIGIN_FUNCTION_SIGNATURE = '0xe1f63d2e'
),
Last run: 3 months ago
...
236
14KB
116s