tkvresearchhurt-fuchsia
    Updated 2025-01-29

    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
    DATETIME
    Delegated Volume
    Undelegated Volume
    1
    2024-06-19 00:00:00.000110024.598213796-20081.135448133
    2
    2024-09-01 00:00:00.000388886.982155403-5348.672224084
    3
    2024-11-27 00:00:00.000238111.27474383-81572.996243112
    4
    2024-06-21 00:00:00.000177872.252213036-25105.532343285
    5
    2024-08-22 00:00:00.000522766.574166069-213394.182291136
    6
    2024-10-18 00:00:00.000647727.978804371-11521.062084021
    7
    2025-01-10 00:00:00.000142022.272145757-34595.757426603
    8
    2024-07-04 00:00:00.000135464.418744209-2236.53521853
    9
    2024-08-31 00:00:00.000246451.259756098-5211.862558204
    10
    2024-10-27 00:00:00.000312621.454946918-6024.720530002
    11
    2024-12-20 00:00:00.000283403.958511085-110867.80849737
    12
    2024-07-07 00:00:00.000366359.751923005-721.697517836
    13
    2025-01-19 00:00:00.000571968.151799684-458509.165092564
    14
    2024-11-30 00:00:00.000226615.369646471-29402.50662408
    15
    2024-09-07 00:00:00.000107912.821000509-3749.876105334
    16
    2024-07-22 00:00:00.000226146.582759855-6314.222241638
    17
    2024-08-15 00:00:00.000852165.868337426-32572.067432513
    18
    2024-06-20 00:00:00.000243999.903732199-705.600067009
    19
    2024-09-30 00:00:00.000265450.97208279-5046.057213173
    20
    2024-11-23 00:00:00.000191871.113605439-39391.189294337
    ...
    236
    14KB
    116s