SELECT MAX(block_number) AS max_block

FROM bitcoin.core.fact_transactions

),

outputs AS (

SELECT *

FROM bitcoin.core.fact_outputs

WHERE block_timestamp > DATE '2024-08-22'

AND block_number >= 857909

),

transactions AS (

SELECT tx_id AS id

FROM bitcoin.core.fact_transactions

WHERE block_timestamp > DATE '2024-08-22'

AND block_number >= 857909

),

restaking_txs AS (

SELECT

o.tx_id,

SUBSTR(o.PUBKEY_SCRIPT_HEX, 7, 1) AS version,

SUBSTR(o.PUBKEY_SCRIPT_HEX, 8, 32) AS staker,

SUBSTR(o.PUBKEY_SCRIPT_HEX, 40, 32) AS finality_provider,

SUBSTR(o.PUBKEY_SCRIPT_HEX, 72, 2) AS stakingtime

FROM outputs o

JOIN transactions t

ON o.tx_id = t.id

WHERE SUBSTR(PUBKEY_SCRIPT_HEX, 1, 6) = '0x6a4762626e31'

),

restake_info AS (

SELECT

o.block_timestamp AS block_time,

o.block_number AS block_height,

o.tx_id,

o.VALUE_SATS / 100000000.0 AS value,

o.PUBKEY_SCRIPT_ADDRESS AS address,

o.PUBKEY_SCRIPT_TYPE AS type,