flipside

    BTC Staking
    alitaslimiBTC Staking
    Updated 2024-12-09
    with
    -------------------- V1 Staking --------------------
    logs_v1 as (
    select
    block_timestamp,
    block_number,
    tx_hash,
    contract_address,
    origin_from_address,
    origin_to_address,
    origin_function_signature,
    event_name,
    decoded_log:delegator as delegator,
    decoded_log:agent as operator_address,
    lower(to_char(reverse(try_to_binary(replace(decoded_log:txid, '0x', ''))))) as bitcoin_tx_id,
    decoded_log:blockHeight as bitcoin_block_number,
    decoded_log:outputIndex as bitcoin_output_index,
    concat('0', trim(decoded_log:script, '0x')) as bitcoin_script,
    to_timestamp(livequery.utils.udf_hex_to_int(lower(to_char(reverse(try_to_binary(substr(bitcoin_script, 3, 8))))))) as unlock_time
    from
    core.core.ez_decoded_event_logs
    where
    tx_succeeded
    and contract_address = '0x0000000000000000000000000000000000001007'
    and origin_to_address = '0x0000000000000000000000000000000000001007'
    and topics[0] = '0xd9bac531f4c140de07ef9de431f5233b0d6ead3f0aa7834fcffd828c882dfdd2'
    ),
    delegations_v1 as (
    select
    core.block_timestamp,
    core.block_number,
    core.tx_hash,
    'V1' as version,
    core.contract_address,
    core.origin_from_address,
    core.origin_to_address,
    Last run: 3 months ago
    STAKING_TRANSACTION
    WITHDRAWAL_TRANSACTION
    STAKING_TIMESTAMP
    WITHDRAWAL_TIMESTAMP
    STAKING_BLOCK
    WITHDRAWAL_BLOCK
    REDEEM_SCRIPT
    UNLOCK_TIME
    CORE_DELEGATOR
    BITCOIN_DELEGATOR
    OPERATOR_ADDRESS
    VALIDATOR
    STAKED_AMOUNT
    WITHDRAWN_AMOUNT
    1
    		c200473c1c7c52e822d6e1a9e2c0d4477942f7dad189ea4343b96ab7a7c1b7f32025-03-11 07:15:46.000
    887280
    		04b094e967b17576a9149981ba1ec00f5c07da2cc1f18e9c393ee997c66988ac2025-03-30 19:00:00.000
    0xcf84e32af469964550431c07b31610ea40bdcd53
    		bc1q8anjmjl4duwhtkm3kdjj70lfms7c93v8j659x70j9qp5v072pkjqxvmlh3
    0x1c151923cf6c381c4af6c3071a2773b3cdbbf704
    		kiln0.64
    2
    		a6f1db2c215e3c186e564f5a623db6592fa77560a9cc5d9f8356b59f65a9b6482025-03-11 02:52:37.000
    887254
    04007f0968b175522102e90824088bb0c72d4439650c76b590997cedb688cceae9ac4b4b...
    		2025-04-24 00:00:00.000
    0x87f34109e4782736b6869daff588626ffb4764d3
    		bc1qm5u2j5gu9qpf0w49c9ph0c2qemlkjpzwemj2yxxcht6qf78jzegq880uxv
    0x58d8efc838d2de558eedeabce631c7dff92c947a
    		dao validator 67.88
    3
    		a23331f6131343e8c540b55cf662a1b14f270ea0a20e6507db415bc7c027b8b22025-03-10 22:37:37.000
    887229
    04007f0968b175522102e90824088bb0c72d4439650c76b590997cedb688cceae9ac4b4b...
    		2025-04-24 00:00:00.000
    0x87f34109e4782736b6869daff588626ffb4764d3
    		bc1qm5u2j5gu9qpf0w49c9ph0c2qemlkjpzwemj2yxxcht6qf78jzegq880uxv
    0x2e50087fb834747606ed01ad67ad0f32129ab431
    		10
    4
    		79e3eb240ce00f9c4980b2c422604ad7a83957ddb031ac1a63042f5a2ec476862025-03-10 20:35:25.000
    887214
    		042fbdf667b17576a914b5fbc9475bfde998e8679eef40aab1b83081dc9988ac2025-04-09 18:32:15.000
    0x38abbd05b62fa1584f64553f13a5fa91ef0697d0
    		bc1q8qcp5tmlyzxm6vduj9avsv2enj8lcd9ewaz3270d3kqrjupuktqqjm4gfg
    0x2d058b58dcf4b0db11168c62d3109f6e02710b02
    		m labs0.2690957
    5
    		f35d77a44fd2e25fe008dcd482f80c348cebfeb5067aa392f8e2d6fdc2e7c1af2025-03-10 18:10:58.000
    887194
    		04c06bd567b17576a91485a676a7555ee1961c3684a960f9fbbb2eddfe9188ac2025-03-15 12:00:00.000
    0x2e57894cf98bc1ff9ec945535f9a8b32924eb6ad
    		bc1qfxhjnuazshzdzd508e9kty8rt4s4my2lwx7qu7mal22hz2xql45sxcpaks
    0x2953559db5cc88ab20b1960faa9793803d070337
    		dao mining pool 20.25432858
    6
    		64f473b11c8a2f68c9adff5701cfc5a1d1582207bad0dca723711f0e1dc0f41c2025-03-10 18:10:49.000
    887194
    		04c06bd567b17576a9145e7a10f973fd10c6facf9bfff40310d046186c5d88ac2025-03-15 12:00:00.000
    0x2e57894cf98bc1ff9ec945535f9a8b32924eb6ad
    		bc1qpemjm4dn40hp6qyux9znez2vec4kdmxj0c4kmm90suv5vcpqyh5ssmusp0
    0x58d8efc838d2de558eedeabce631c7dff92c947a
    		dao validator 60.24895067
    7
    		0fef57a22784a5b95737b548054d56c5c71c82c29acd890c7dfff7e19e443d492025-03-10 17:07:34.000
    887189
    		040001d367b17576a9146ba914179dcb8ceef986785939e99a0c92851e7f88ac2025-03-13 16:00:00.000
    0xd508090c10339cd0e1d68e61cab0a21037a3344d
    		bc1qd8qsktx4pr2ku9dhkl3fx6h8lsj58s0t0ufhl0r8p83y4ms6p8qs8563ax
    0x42fdeae88682a965939fee9b7b2bd5b99694ff64
    		dao mining pool 30.0011
    8
    		c1b308c3cfefd05ba2f07dea95194b64a605f2ed20109ff42f52f088a6438eee2025-03-10 15:35:16.000
    887179
    		0468f5d267b17576a9143187b3627e6e80c7911ef627a8589ccc51aa8cd888ac2025-03-13 15:10:32.000
    0xd508090c10339cd0e1d68e61cab0a21037a3344d
    		bc1q729e99zu5xgj4krra63vjtdhjn7sfqfgs5ltga3q9h4tfzgey3nsx3arqq
    0x42fdeae88682a965939fee9b7b2bd5b99694ff64
    		dao mining pool 30.002
    9
    		f1a0e9c6d4054509ae0b7d5ef40469b8c04e5be720187218e2e86d78f1e5acf82025-03-10 15:32:07.000
    887178
    		04448af667b17576a914b506ab6d973035708a1905549670b4606176c46688ac2025-04-09 14:55:00.000
    0xb45eb15e2acb1f7cea8ffc7395211e9aa53c586c
    		bc1qpwdd46pn8geh9pxmpxunxve0h8cg5tk4mxy3wq6c4tj5pgkhwrpqf4tx4e
    0x2953559db5cc88ab20b1960faa9793803d070337
    		dao mining pool 20.01489508
    10
    		e931cb6904d4001fb6bd3b9ea70498f5058e4c404dfdeaf39a0b00d009bc22022025-03-10 15:15:52.000
    887173
    		0440b70968b17576a914fecfb459d0dd7083f433e367de9c930174d2661588ac2025-04-24 04:00:00.000
    0xfd818e3544a8a72632ab53324eae6370bbe9bad7
    		bc1qfxj7nzdpes2uwrd5vf7v46aklapgv853aq26dj4dw9apcwmu7rvs39q84u
    0xa898e2f126b642d6e401bdcb79979c691a8fd90d
    		wolfedge labs15
    11
    		eabe3d9c6494e255fe30807a85bf8c024f44bc67d7205c68417e92103fd4c9242025-03-10 06:26:20.000
    887123
    		044c0af667b17576a914d56376c48479e051b9f94d38e41b2df5b6a33b7188ac2025-04-09 05:49:00.000
    0x781689dc3347049cd5a3d9c8bc4a46ba7cd00c55
    		bc1qtcj0mm29wahjrjdx6ckq77dxxx063x8lv48tecspj3ud8llsvakq9530p8
    0x2953559db5cc88ab20b1960faa9793803d070337
    		dao mining pool 21.74884217
    12
    		039d6c1c8209e4a240175752c01a7c1e3917d428d664cccb4d2728df9a63c44a2025-03-10 04:39:56.000
    887110
    		04bc88db67b17576a9147249f9d9e50cdfc4b246a0cafe316ddc46f9596b88ac2025-03-20 03:17:16.000
    0xf8ae090b2c0ba177b7e2fd812daa7ea8e533635e
    		3PHS8uSDYn15Z3o9LWVuQgWCqtBTt4FJ1d
    0x7c706ca44a28fdd25761250961276bd61d5aa87b
    		dao validator 10.014
    13
    		71cbb66abea79ac179c34187014e0d2037d222e44824f07e81ab2dde15175aa32025-03-10 04:24:44.000
    887108
    		04e7a2d367b17576a914708e938a2a7c81b92d361a2dbf0b0463127b898c88ac2025-03-14 03:30:47.000
    0x440777f63677e3d8833e191b57f757b541af3cd8
    		bc1qgpsf6lj4mqxng274jfnrr9kw5fcwfvmwz80njjqs2vftzj9u6azst0kkpz
    0x42fdeae88682a965939fee9b7b2bd5b99694ff64
    		dao mining pool 30.1
    14
    		84818f38425ca62f31688f30c493e3728d4aa2814a856af575c8b274b60329562025-03-10 04:10:35.000
    887107
    		04be9ed367b17576a914012990009dd457089bfa593f097bfbe1c1adb51e88ac2025-03-14 03:13:02.000
    0xe22a8c075ba3cdeebf6fde42489accc3c55ed93d
    		bc1qjndjgfjy7dr9hlxh0s6plmncs5v4wed2prlzvzyv5hd795hpxynsn8srk8
    0x42fdeae88682a965939fee9b7b2bd5b99694ff64
    		dao mining pool 30.1
    15
    		2cf27c2d9dbd39cf7b028ec2df26a343107e7f7c4494c22bcfaf631dc7bb47182025-03-10 00:21:05.000
    887087
    		0403aa1268b17576a91498f4044626e0ccddf1da093e70b718fb6d3ab80188ac2025-04-30 22:53:55.000
    0x25cd8a3918114fc7e73f5f599004119008383ca1
    		bc1qgwgy5c8z0rs7yk8k7d4emf7jdr6k290x4ft4wm3mrn6xp2yhltns744897
    0xa898e2f126b642d6e401bdcb79979c691a8fd90d
    		wolfedge labs0.4
    16
    		83ffab4b5a39fde3c58463ff93f4b92f9de6648228b34bc016e2c9c9bbaafcda2025-03-09 21:31:41.000
    887073
    		04a4be4368b17576a91405a2c1ed6deeb40a14f90907e39af410765679bf88ac2025-06-07 04:23:00.000
    0x90b66c0a0566a1bd5cc5776421047ba2a9c01b77
    		bc1qzrwvnfa75nhk3v9j80xcypuv56mu003psm7w43nu5zy4ygq672ds4rlg5d
    0xa21cbd3caa4fe89bccd1d716c92ce4533e4d4733
    		dao mining pool 10.45
    17
    		c883890bf337846f4d3891043991ce42ec522a8640430e9d415ea612b9eb78022025-03-09 17:07:56.000
    887046
    		04df664468b17576a91422cd1806b8f0571bd5f1778f0050a512cc746fa688ac2025-06-07 16:20:47.000
    0x7c2087262926dc8e3e2495dc7110d34ec2f730f8
    		3BHtADvVqWo67T83oycWNkJqzoFMeG4y9Q
    0x7c706ca44a28fdd25761250961276bd61d5aa87b
    		dao validator 10.03
    18
    		1d1e6fd054c1714f61472391dfff227e98c863c020af742c002cb4bff5a206e12025-03-09 15:27:52.000
    887031
    		0474d7da67b17576a914dddbb5d3c017d76e355c0fa80e81797600ec981e88ac2025-03-19 14:40:52.000
    0xd1294b2d18acb28c30569df4679822b5ada589e4
    		37vuSB5vVxtP3eLe17smLZ6khTp6b6jGGM
    0x7c706ca44a28fdd25761250961276bd61d5aa87b
    		dao validator 10.01
    19
    		9e5086da3cd094381b5be3b19737d6b95ffa99909640a086ec49ffed4d026abc2025-03-09 08:04:28.000
    886985
    		0495a2e367b17576a9143f142f40404d8c390ca3a7448d75103871fffea288ac2025-03-26 06:45:41.000
    0xe5d2cab39660387009c0e09444191c34c8c67c23
    		bc1qzd4gf5sysn0f2lh6594cfy4drfep5nsxmldj4f4nxgp82eyeaf9sg8052x
    0xa898e2f126b642d6e401bdcb79979c691a8fd90d
    		wolfedge labs0.01998515
    20
    		cb91c20b31474d5c6dcac5561d9a4518eee28f504c4a0fd561b2f3e1eb91f0662025-03-08 20:32:55.000
    886911
    		0460bed967b17576a9141c19ea516bef96a5f47782e106d68bc4b02d1c9088ac2025-03-18 18:41:36.000
    0x89ca61843d8a71709281cae31be5365c7e92d5c4
    		3ETcKnreVkTTU9KcJKyfDV4FiwjcpB9PnT
    0x7c706ca44a28fdd25761250961276bd61d5aa87b
    		dao validator 10.01479
    ...
    3697
    2MB
    475s