BLOCK_TIMESTAMP | BLOCK_NUMBER | BLOCK_HASH | TX_ID | INDEX | PUBKEY_SCRIPT_ASM | PUBKEY_SCRIPT_HEX | PUBKEY_SCRIPT_ADDRESS | PUBKEY_SCRIPT_TYPE | PUBKEY_SCRIPT_DESC | VALUE | VALUE_SATS | OUTPUT_ID | FACT_OUTPUTS_ID | INSERTED_TIMESTAMP | MODIFIED_TIMESTAMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2024-08-26 01:30:14.000 | 858450 | 000000000000000000006af03afb2a23a9b4927d1e4aa759f9d4cf240a79c08f | fb0346d81da0e5bf6cbe52cbe1c690b71f9bce02240ec080c8bb6cab0aae2633 | 0 | OP_RETURN 13 1310996 | 6a5d0414011400 | nulldata | raw(6a5d0414011400)#cwmyltm8 | 0 | 0 | ff85ed4b9b68bdefbd075ac64a8e1b80 | ff85ed4b9b68bdefbd075ac64a8e1b80 | 2024-08-26 03:02:22.288 | 2024-08-26 03:02:22.288 | |
2 | 2024-08-26 09:05:29.000 | 858494 | 00000000000000000001c0ee3f62f680c6ebcd20f9228f3f2e7a1e93c7086cb6 | fb0381c53e2e4faffcb08fab98aa85b7b40d43d4c26a582c6c48a0430cc8a398 | 0 | 1 338b71e5240681217d98d68aa29c8226d769c58df7929b00ed70677f8cc24cf0 | 5120338b71e5240681217d98d68aa29c8226d769c58df7929b00ed70677f8cc24cf0 | bc1pxw9hrefyq6qjzlvc669298yzymtkn3vd77ffkq8dwpnhlrxzfncqn6rqgd | witness_v1_taproot | rawtr(338b71e5240681217d98d68aa29c8226d769c58df7929b00ed70677f8cc24cf0)#... | 0.00000546 | 546 | a417773bb2d9cdfb932578fe7762a249 | a417773bb2d9cdfb932578fe7762a249 | 2024-08-26 10:03:02.082 | 2024-08-26 10:03:02.082 |
3 | 2024-08-26 07:10:02.000 | 858486 | 000000000000000000007fc2db35d12f2d58a433e6d1400cfd61bebdd66ca0c1 | fb039d8d935b2ddc0c176e66e9178e6e06b633a6c1ea62b6f5fc91d118912c09 | 0 | OP_DUP OP_HASH160 713b6871bf556ed1cc54082b80bd100bd4c6a512 OP_EQUALVERIF... | 76a914713b6871bf556ed1cc54082b80bd100bd4c6a51288ac | 1BKiXR8aF6wBsWvNU7tGC1cHAhWjnz6SH2 | pubkeyhash | addr(1BKiXR8aF6wBsWvNU7tGC1cHAhWjnz6SH2)#ctamtdf8 | 0.0006 | 60000 | 147d832bc560eb3c1f8c3fcfff8ed5cd | 147d832bc560eb3c1f8c3fcfff8ed5cd | 2024-08-26 08:01:52.941 | 2024-08-26 08:01:52.941 |
4 | 2024-08-26 07:10:02.000 | 858486 | 000000000000000000007fc2db35d12f2d58a433e6d1400cfd61bebdd66ca0c1 | fb039d8d935b2ddc0c176e66e9178e6e06b633a6c1ea62b6f5fc91d118912c09 | 1 | 0 ec437953979f3bcb687a562dcd0f49f947d700d5 | 0014ec437953979f3bcb687a562dcd0f49f947d700d5 | bc1qa3phj5uhnuauk6r62cku6r6fl9rawqx4n6d690 | witness_v0_keyhash | addr(bc1qa3phj5uhnuauk6r62cku6r6fl9rawqx4n6d690)#68z0ycvh | 0.09937482 | 9937482 | 84ed99ee4ed55ec8d7d549f46af17245 | 84ed99ee4ed55ec8d7d549f46af17245 | 2024-08-26 08:01:52.941 | 2024-08-26 08:01:52.941 |
5 | 2024-08-26 07:12:10.000 | 858487 | 00000000000000000001f9eba0b9ec00e85882635a566578ea56abc627b14f95 | fb03ee2ab3a5516c637fa24b0f225824f9efa7dc1ef240d71af89e8496bc6529 | 0 | 0 2d676105409b5a81ea49b32157e45b78d5c78c9c | 00142d676105409b5a81ea49b32157e45b78d5c78c9c | bc1q94nkzp2qnddgr6jfkvs40ezm0r2u0ryuzmkvm8 | witness_v0_keyhash | addr(bc1q94nkzp2qnddgr6jfkvs40ezm0r2u0ryuzmkvm8)#075aw7ck | 0.00002998 | 2998 | b8fd8e49672cf539baa94425c616a3f9 | b8fd8e49672cf539baa94425c616a3f9 | 2024-08-26 08:31:40.997 | 2024-08-26 08:31:40.997 |
6 | 2024-08-26 07:12:10.000 | 858487 | 00000000000000000001f9eba0b9ec00e85882635a566578ea56abc627b14f95 | fb03ee2ab3a5516c637fa24b0f225824f9efa7dc1ef240d71af89e8496bc6529 | 1 | OP_RETURN 13 1310996 | 6a5d0414011400 | nulldata | raw(6a5d0414011400)#cwmyltm8 | 0 | 0 | 0de612b5f02aa7485658f8b30b9e869b | 0de612b5f02aa7485658f8b30b9e869b | 2024-08-26 08:31:40.997 | 2024-08-26 08:31:40.997 | |
7 | 2024-08-26 03:30:27.000 | 858467 | 000000000000000000026f27c2ed0ab43bf7bc38ce09b42f8af45e472f3b61bb | fb0401e408bc9f23603febda091c3b3d3fb5e7d351635d6acb822d561892694c | 1 | OP_RETURN 13 1310996 | 6a5d0414011400 | nulldata | raw(6a5d0414011400)#cwmyltm8 | 0 | 0 | 9cbff593b4f214b2a80b72fdab422737 | 9cbff593b4f214b2a80b72fdab422737 | 2024-08-26 04:01:45.224 | 2024-08-26 04:01:45.224 | |
8 | 2024-08-26 03:30:27.000 | 858467 | 000000000000000000026f27c2ed0ab43bf7bc38ce09b42f8af45e472f3b61bb | fb0401e408bc9f23603febda091c3b3d3fb5e7d351635d6acb822d561892694c | 0 | 0 47deeff82c55fad8f93da0d174a2eca01d8ab552 | 001447deeff82c55fad8f93da0d174a2eca01d8ab552 | bc1qgl0wl7pv2had37fa5rghfghv5qwc4d2jpyqf5v | witness_v0_keyhash | addr(bc1qgl0wl7pv2had37fa5rghfghv5qwc4d2jpyqf5v)#ert85fc6 | 0.00005026 | 5026 | 91b8de51aeb3fe28faa6e08a01401d74 | 91b8de51aeb3fe28faa6e08a01401d74 | 2024-08-26 04:01:45.224 | 2024-08-26 04:01:45.224 |
9 | 2024-08-26 05:18:07.000 | 858475 | 00000000000000000000a74d4b3ba67e270842eed030f2813c26dd5050fd06fc | fb0426131302dc2f59bae985c3ac6379872bdfd30e3d7898553627bfccee0b38 | 1 | 0 fb267485287d3893b19fcf05addc2432e86ea63c | 0014fb267485287d3893b19fcf05addc2432e86ea63c | bc1qlvn8fpfg05uf8vvleuz6mhpyxt5xaf3um7hnz3 | witness_v0_keyhash | addr(bc1qlvn8fpfg05uf8vvleuz6mhpyxt5xaf3um7hnz3)#0yuxdpv7 | 0.00103558 | 103558 | c6440b304bf9eb23da98f0dadb854f68 | c6440b304bf9eb23da98f0dadb854f68 | 2024-08-26 06:01:41.340 | 2024-08-26 06:01:41.340 |
10 | 2024-08-26 05:18:07.000 | 858475 | 00000000000000000000a74d4b3ba67e270842eed030f2813c26dd5050fd06fc | fb0426131302dc2f59bae985c3ac6379872bdfd30e3d7898553627bfccee0b38 | 0 | OP_RETURN 13 1310996 | 6a5d0414011400 | nulldata | raw(6a5d0414011400)#cwmyltm8 | 0 | 0 | 55d62216052746db17f3cc90dcd17f26 | 55d62216052746db17f3cc90dcd17f26 | 2024-08-26 06:01:41.340 | 2024-08-26 06:01:41.340 | |
11 | 2024-08-26 05:55:53.000 | 858479 | 00000000000000000000423d63a3e2e967a30cf1a0ac411bcb9380a61030d5d4 | fb0437433ac45a1652fc4c9c3d797d5352cd24d39fed67da9c6eee966ff2bdfd | 1 | OP_RETURN 13 1310996 | 6a5d0414011400 | nulldata | raw(6a5d0414011400)#cwmyltm8 | 0 | 0 | 89aa8483be27aec98f58e02f14973836 | 89aa8483be27aec98f58e02f14973836 | 2024-08-26 07:31:45.766 | 2024-08-26 07:31:45.766 | |
12 | 2024-08-26 05:55:53.000 | 858479 | 00000000000000000000423d63a3e2e967a30cf1a0ac411bcb9380a61030d5d4 | fb0437433ac45a1652fc4c9c3d797d5352cd24d39fed67da9c6eee966ff2bdfd | 0 | 0 c17a298fef0c391c72656753d5c8c79ca9724182 | 0014c17a298fef0c391c72656753d5c8c79ca9724182 | bc1qc9aznrl0psu3cun9vafatjx8nj5hysvzxhwfwx | witness_v0_keyhash | addr(bc1qc9aznrl0psu3cun9vafatjx8nj5hysvzxhwfwx)#jpkslcpp | 0.00005082 | 5082 | d68ee6a36816fe029367298858fe8801 | d68ee6a36816fe029367298858fe8801 | 2024-08-26 07:31:45.766 | 2024-08-26 07:31:45.766 |
13 | 2024-08-26 02:36:44.000 | 858456 | 000000000000000000019b53f4121bc336c746b409637d10ca2de07e0be24f19 | fb04566c0eeab501cfd22970a4ccd3fb99865b8a9525bbe1968415c082503da0 | 0 | OP_RETURN 13 1310996 | 6a5d0414011400 | nulldata | raw(6a5d0414011400)#cwmyltm8 | 0 | 0 | 739f39471bf8c64d917776b23e2c5118 | 739f39471bf8c64d917776b23e2c5118 | 2024-08-26 03:32:16.182 | 2024-08-26 03:32:16.182 | |
14 | 2024-08-26 02:36:44.000 | 858456 | 000000000000000000019b53f4121bc336c746b409637d10ca2de07e0be24f19 | fb04566c0eeab501cfd22970a4ccd3fb99865b8a9525bbe1968415c082503da0 | 1 | 0 2c13c5c0d3cca0bdd39b1f5d6e976c920c760b7c | 00142c13c5c0d3cca0bdd39b1f5d6e976c920c760b7c | bc1q9sfutsxnejstm5umrawka9mvjgx8vzmuh2h8nc | witness_v0_keyhash | addr(bc1q9sfutsxnejstm5umrawka9mvjgx8vzmuh2h8nc)#shlnpxzx | 0.00011121 | 11121 | cdd518551d5845be6006e786c9596e16 | cdd518551d5845be6006e786c9596e16 | 2024-08-26 03:32:16.182 | 2024-08-26 03:32:16.182 |
15 | 2024-08-26 01:49:27.000 | 858452 | 0000000000000000000208580c631e5ca52b49098a301341a5c754a0fb4cef20 | fb046366dd1c473a95b4c6469371444603dd45333cd90c418283bd966a51c7bb | 0 | 0 0565905246a56bc3426ae62d97dd06b41a73ec3b | 00140565905246a56bc3426ae62d97dd06b41a73ec3b | bc1qq4jeq5jx544uxsn2ucke0hgxksd88mpmqc7m5a | witness_v0_keyhash | addr(bc1qq4jeq5jx544uxsn2ucke0hgxksd88mpmqc7m5a)#2vlncnhh | 0.00003381 | 3381 | eac574eb8d9482765f5ba3dbe683452d | eac574eb8d9482765f5ba3dbe683452d | 2024-08-26 03:32:16.182 | 2024-08-26 03:32:16.182 |
16 | 2024-08-26 01:49:27.000 | 858452 | 0000000000000000000208580c631e5ca52b49098a301341a5c754a0fb4cef20 | fb046366dd1c473a95b4c6469371444603dd45333cd90c418283bd966a51c7bb | 1 | OP_RETURN 13 1310996 | 6a5d0414011400 | nulldata | raw(6a5d0414011400)#cwmyltm8 | 0 | 0 | ef7d1f0e13ea7f5fffa124bf42fbc38d | ef7d1f0e13ea7f5fffa124bf42fbc38d | 2024-08-26 03:32:16.182 | 2024-08-26 03:32:16.182 | |
17 | 2024-08-26 08:59:42.000 | 858493 | 000000000000000000013a943e053b6811b25eefb200234dbbc7d4f4e219aba7 | fb0472a7b3c3e8c2a0a5b11334ed25c5a1cbc1bc56f39b56406b9a37036aaeae | 1 | 0 7f903b825d76e4ae0ef433655b99aa7e5e0a4d7f | 00147f903b825d76e4ae0ef433655b99aa7e5e0a4d7f | bc1q07grhqjawmj2urh5xdj4hxd20e0q5ntlu72q9h | witness_v0_keyhash | addr(bc1q07grhqjawmj2urh5xdj4hxd20e0q5ntlu72q9h)#5enycutx | 0.07913689 | 7913689 | 5b2b7c60cb40608e4cf214acf81fa7c8 | 5b2b7c60cb40608e4cf214acf81fa7c8 | 2024-08-26 09:36:31.452 | 2024-08-26 09:36:31.452 |
18 | 2024-08-26 08:59:42.000 | 858493 | 000000000000000000013a943e053b6811b25eefb200234dbbc7d4f4e219aba7 | fb0472a7b3c3e8c2a0a5b11334ed25c5a1cbc1bc56f39b56406b9a37036aaeae | 0 | OP_DUP OP_HASH160 d653c3ba28504d36a5c432a12b0ae9dce6b8278d OP_EQUALVERIF... | 76a914d653c3ba28504d36a5c432a12b0ae9dce6b8278d88ac | 1LYFx7gweJ7R7ygtkHsXDhcZfoinmpUsSS | pubkeyhash | addr(1LYFx7gweJ7R7ygtkHsXDhcZfoinmpUsSS)#4s3u0mke | 0.005236 | 523600 | 7a868e43538be1719ef5e51b4b640ce3 | 7a868e43538be1719ef5e51b4b640ce3 | 2024-08-26 09:36:31.452 | 2024-08-26 09:36:31.452 |
19 | 2024-08-26 01:26:09.000 | 858449 | 00000000000000000002fb86dd850428379d2e02cdc1f1dda1140d3e5e7b56e8 | fb04ae03ab3c261ac1e78aaa8bb359dc13611055b96870fecb78ff74fe912523 | 2 | OP_RETURN 3d3a4554482e555344542d4543373a30783364623061423241654435613339... | 6a453d3a4554482e555344542d4543373a30783364623061423241654435613339353937... | nulldata | raw(6a453d3a4554482e555344542d4543373a3078336462306142324165443561333935... | 0 | 0 | 23c802094df72030936ae0dbf0db8834 | 23c802094df72030936ae0dbf0db8834 | 2024-08-26 02:01:42.323 | 2024-08-26 02:01:42.323 | |
20 | 2024-08-26 01:26:09.000 | 858449 | 00000000000000000002fb86dd850428379d2e02cdc1f1dda1140d3e5e7b56e8 | fb04ae03ab3c261ac1e78aaa8bb359dc13611055b96870fecb78ff74fe912523 | 1 | 0 451b9136a79a8ec5a5b9a255d5a2f763d6886b7b | 0014451b9136a79a8ec5a5b9a255d5a2f763d6886b7b | bc1qg5dezd48n28vtfde5f2atghhv0tgs6mmrehl6a | witness_v0_keyhash | addr(bc1qg5dezd48n28vtfde5f2atghhv0tgs6mmrehl6a)#sj70w0wa | 0.02185978 | 2185978 | 0d7c59bf6379767c74787b07fbccf7a0 | 0d7c59bf6379767c74787b07fbccf7a0 | 2024-08-26 02:01:42.323 | 2024-08-26 02:01:42.323 |
datavortexback test 2
Updated 2025-02-28
9
1
2
3
4
5
›
⌄
SELECT *
FROM bitcoin.core.fact_outputs
WHERE block_timestamp > DATE '2024-08-22'
AND block_number >= 857909
limit 100
Last run: 3 months ago
100
48KB
2s