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

DATE(block_timestamp) AS event_date,

utils.udf_hex_to_int(DATA) / POW(10, 18) AS undelegated_amount

FROM tbl

)

SELECT

event_date,

SUM(undelegated_amount) AS "total undelegation"

FROM database

GROUP BY 1

),

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'

)

SELECT

DATE(block_timestamp) AS event_date,

utils.udf_hex_to_int(DATA) / POW(10, 18) AS delegated_amount

FROM tbl

)