flipside

    Test Staking - Transactions
    Flipside TeamTest Staking - Transactions
    Updated 3 hours ago
    -------------- Query updated at 2025-03-11 by Zanyar_98
    -------------- Previous query archived at: https://flipsidecrypto.xyz/studio/queries/071153db-6ae8-4849-9a3c-87f83a8b69ff

    -------------------- V1 Staking --------------------
    with 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
    block_timestamp > '2024-04-12'
    and 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,
    Last run: about 3 hours agoAuto-refreshes every 6 hours
    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
    		f98a4b6f4da7e61744b586b423757fef7fa17fe45d4e200a37d93a793a3348a22025-05-28 23:08:45.000
    898806
    		041a39ae68b17576a914a32da83d66d2d11fc80d5588e7816f673eebadca88ac2025-08-26 22:45:46.000
    0x1f517602070233817336e9f3e7dec3a3b92ac8ed
    		bc1qv7clkts7n477upqpz4a8pdtfrq2nefqql98m4dxthrt4c42fs3qs85vg0m
    0x7c706ca44a28fdd25761250961276bd61d5aa87b
    		dao validator 10.0177
    2
    		4c04e674ea8803a235a357b738b5087b18013ad94e40e5502fbc2fb71a6ff08b2025-05-28 19:41:06.000
    898777
    		0486e55e68b17576a914f020cd19d1ebbe65efe0658d18715713922c592688ac2025-06-27 18:40:06.000
    0x42af17419dc354d460603fb25bf98e96abd38e03
    		31xqPtHu1GTvPabwEZ7nKxpc7ncKzVeMwv
    0x7c706ca44a28fdd25761250961276bd61d5aa87b
    		dao validator 10.06
    3
    		28120e5e81e6c01d7442f0e0f5b0dd9bc568e168916892e2cc817647113dd04b2025-05-28 04:48:12.000
    898683
    		04fb42b268b17576a914988ba4e395ae150c7894a72a9f23dea3b42b52ad88ac2025-08-30 00:16:59.000
    0x966ab1ba51a794a1993f23d0d1df878039ee6188
    		bc1q6mnmhvwvrxjp6uesds606f09q4vfuu8rj7ka6tmux2mtuu97786s7hcpd5
    0x1c151923cf6c381c4af6c3071a2773b3cdbbf704
    		kiln3
    4
    		26230d9da0c580906509b38982f9b31394cb9b73310e816b612db9460e54d6bd2025-05-28 04:48:03.000
    898683
    		04fb42b268b17576a914988ba4e395ae150c7894a72a9f23dea3b42b52ad88ac2025-08-30 00:16:59.000
    0xca671447ea09a85fa173042a4de4c4975cfa7c16
    		bc1q6mnmhvwvrxjp6uesds606f09q4vfuu8rj7ka6tmux2mtuu97786s7hcpd5
    0xee79f2b4be44b582f496d857727f2d6aff4c71f3
    		zan node4
    5
    		3fa40a9429da3c4203bf33937c1493e20e0c614305a7e005ef9030b0c15a94b32025-05-28 04:47:54.000
    898683
    		04fb42b268b17576a914988ba4e395ae150c7894a72a9f23dea3b42b52ad88ac2025-08-30 00:16:59.000
    0x35d4e5c487987531d5a5f50846550904aefb5e60
    		bc1q6mnmhvwvrxjp6uesds606f09q4vfuu8rj7ka6tmux2mtuu97786s7hcpd5
    0xf6fdbc19a25dc91454cec19ef7714e8b67c4e0e6
    		animoca brands4
    6
    		9f6e8bac9cde9d7e8bc8db354752efb5b7326cccb9d75053a125df66d3e079772025-05-28 04:47:45.000
    898683
    		04fb42b268b17576a914988ba4e395ae150c7894a72a9f23dea3b42b52ad88ac2025-08-30 00:16:59.000
    0x37af4ceb0cf634f0ffc29a891faf9264d88c89ac
    		bc1q6mnmhvwvrxjp6uesds606f09q4vfuu8rj7ka6tmux2mtuu97786s7hcpd5
    0x536de38d1db7c68636fc989e4d0daac51e4eb950
    		0x536d...4eb95020
    7
    		e7a4da742a31104ded4a42d2708051b888f629830d33d9b72a9dc142af8d11812025-05-28 04:47:36.000
    898683
    		04fb42b268b17576a914988ba4e395ae150c7894a72a9f23dea3b42b52ad88ac2025-08-30 00:16:59.000
    0x7c4ab53cfcaaec175dd5c1ae93e14f67505a70da
    		bc1q6mnmhvwvrxjp6uesds606f09q4vfuu8rj7ka6tmux2mtuu97786s7hcpd5
    0xc24fe962e6230841c5019e531e3c713ed30161b4
    		fireblocks20
    8
    		372bb8f6025e6c24f926a8f0539b99472cdc8df78292306809811e70d894bf5d2025-05-28 04:47:27.000
    898683
    		04fb42b268b17576a914988ba4e395ae150c7894a72a9f23dea3b42b52ad88ac2025-08-30 00:16:59.000
    0x41145f6b7235d86253ff9795cf6fe626acde95fa
    		bc1q6mnmhvwvrxjp6uesds606f09q4vfuu8rj7ka6tmux2mtuu97786s7hcpd5
    0xa898e2f126b642d6e401bdcb79979c691a8fd90d
    		wolfedge labs20
    9
    		0883f2baea03079330e865a217ffb1dc188b9e2b4b4f64a8b6594c92a670a64d2025-05-28 04:47:18.000
    898683
    		04fb42b268b17576a914988ba4e395ae150c7894a72a9f23dea3b42b52ad88ac2025-08-30 00:16:59.000
    0x25b5d5e8351a62a36ee9d9726e5cae8dfdc3bb7b
    		bc1q6mnmhvwvrxjp6uesds606f09q4vfuu8rj7ka6tmux2mtuu97786s7hcpd5
    0xbe795699b8789a27d20a6ca7cd84a0b057fae46c
    		25
    10
    		c7ccfba463bdb1ad8a7c69937fb15b8ae22826a481b6fc8e7f22ad8495517c972025-05-28 04:47:09.000
    898683
    		04fb42b268b17576a914988ba4e395ae150c7894a72a9f23dea3b42b52ad88ac2025-08-30 00:16:59.000
    0x5cac10ecb8179fe8f8868f4cd08530f0652bf7d2
    		bc1q6mnmhvwvrxjp6uesds606f09q4vfuu8rj7ka6tmux2mtuu97786s7hcpd5
    0xbfbbacbd59c3bd551d40729061dc4d21ccbea792
    		utxo35
    11
    		a38f378d4a44a70ee700b55acfb88e6f9309f2f52e67e0267e192efbe3d29d8d2025-05-28 04:47:00.000
    898683
    		04fb42b268b17576a914988ba4e395ae150c7894a72a9f23dea3b42b52ad88ac2025-08-30 00:16:59.000
    0x92feb86520af0f54ff0d15b8bc91db5afd363ae0
    		bc1q6mnmhvwvrxjp6uesds606f09q4vfuu8rj7ka6tmux2mtuu97786s7hcpd5
    0xebbaf365b0d5fa072e2b2429db23696291f2c038
    		ardennes45
    12
    		28632becd9aa3137ff46ba1666b1f61bc19a359bd26abb6b3c1a132ddcfa17c92025-05-28 04:00:45.000
    898675
    		042c23ad68b17576a91431c1d12ec8f89933a40b46c5339e75eeecd82b2f88ac2025-08-26 02:59:56.000
    0x6534818294d3742f4b73988c17984af79b6f8f2a
    		3FwDT154favKo5v7k1ugTa7RAUqZARrJnM
    0x7c706ca44a28fdd25761250961276bd61d5aa87b
    		dao validator 10.36
    13
    		230c75a5b723dd332679eeccda056c9b6409b91b0c3f4fd9c792b9628380a7bd2025-05-28 03:02:00.000
    898669
    		04acb23b68b17576a91478e237c8304d986931239d0d2317dc70a109d85788ac2025-06-01 01:53:48.000
    0x4b1dc0fcdf2e9783bcb0aa8246804bbb3657d21b
    		bc1ql9hfqh7jd0tk4qhfmr3ktl8qagg5wk7q8wzeyqt8pq9ehl0gqe0qx7dve6
    0x1c151923cf6c381c4af6c3071a2773b3cdbbf704
    		kiln0.01
    14
    		df6a4574848f729c25ce55e4631d3b58a37bb3064e3d101d7f11ed3f55f0356d2025-05-28 00:42:39.000
    898656
    		04fb42b268b17576a914988ba4e395ae150c7894a72a9f23dea3b42b52ad88ac2025-08-30 00:16:59.000
    0x72feda972052ea833e8d53d7ad055a1a1a188016
    		bc1q6mnmhvwvrxjp6uesds606f09q4vfuu8rj7ka6tmux2mtuu97786s7hcpd5
    0xbe795699b8789a27d20a6ca7cd84a0b057fae46c
    		4
    15
    		89f35e227dc285a4d00fb5fe7c138ba23180e9ce5bc358ab4c22dcc8f63d99c82025-05-28 00:42:30.000
    898656
    		04fb42b268b17576a914988ba4e395ae150c7894a72a9f23dea3b42b52ad88ac2025-08-30 00:16:59.000
    0x4cb55b5e4b8375e3cd1998cc41cb9f529a7cfd6f
    		bc1q6mnmhvwvrxjp6uesds606f09q4vfuu8rj7ka6tmux2mtuu97786s7hcpd5
    0xbe795699b8789a27d20a6ca7cd84a0b057fae46c
    		4
    16
    		e9a4fefa5cf9394efc1db60bed2381e38e1da59a38a061953ba187039a598fda2025-05-28 00:42:21.000
    898656
    		04fb42b268b17576a914988ba4e395ae150c7894a72a9f23dea3b42b52ad88ac2025-08-30 00:16:59.000
    0x4a702747035861fd977defea516e65295d887336
    		bc1q6mnmhvwvrxjp6uesds606f09q4vfuu8rj7ka6tmux2mtuu97786s7hcpd5
    0xbe795699b8789a27d20a6ca7cd84a0b057fae46c
    		3
    17
    		ee7f63922e39c687fccf07b49935b6f2d7900a8c809b29ec311a80aae0187d322025-05-28 00:03:39.000
    898652
    		0480eb7668b17576a914fecfb459d0dd7083f433e367de9c930174d2661588ac2025-07-16 00:00:00.000
    0xfd818e3544a8a72632ab53324eae6370bbe9bad7
    		bc1qzp3uyk4p7vj3tsk6qlxe9hw2mp76tq86k6ytsykny4lrl423vjnq4mf7q4
    0xc24fe962e6230841c5019e531e3c713ed30161b4
    		fireblocks12.15
    18
    		92590a5c3001d71d06d1a353b4ffca4387a72766c998ecdb4edfb6a6f23af15b2025-05-27 23:53:30.000
    898651
    		0480d36168b17576a9149981ba1ec00f5c07da2cc1f18e9c393ee997c66988ac2025-06-30 00:00:00.000
    0x79b5ebfb767e732dcdb4c7e14b8cd912cf5426ed
    		bc1qayshs7kq0spkhpwg488hu6zm5j80a0saxg4mn9l0lvn6fms7xkzsgcqrew
    0x1c151923cf6c381c4af6c3071a2773b3cdbbf704
    		kiln0.64
    19
    		0a726deabc7f607b07c62bbe4b34c99e44f649a6f75745f5a366c67c05e3fdf02025-05-27 18:23:18.000
    898629
    		049f684468b17576a9146f7ec3fd5ad964fbccb951ebf2fbcb5c54a0282688ac2025-06-07 16:28:15.000
    0xae707b0df2fb82405b2439c8edc6725ca3e4d560
    		bc1qe2rg5dwgx825lrp75r5dgkjxykk8r74tqlq438uw9wlyaqxtw2equyqcc2
    0xbe795699b8789a27d20a6ca7cd84a0b057fae46c
    		0.47404034
    20
    		97249e153d6511f13ad2a7e7bf55a3c612a464a9ac5e23637cd64cdb7d639f2c2025-05-27 10:59:23.000
    898592
    		04799c8468b17576a914e49b5f1791903939bbfafdf79cd8df005ad1ba4388ac2025-07-26 09:14:33.000
    0x425b7e9c0a6a02bfd9972d549a186468ffe8dd92
    		bc1qmyh4lvwe6fty78en7h32yzylq2qr02wmndf8hg2fdwarll0v5ruq298d7f
    0x2953559db5cc88ab20b1960faa9793803d070337
    		dao mining pool 20.02855922
    ...
    4523
    2MB
    328s