jackguyBTC (OMB)
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with tab1 as (
SELECT *
FROM crosschain.core.address_labels
WHERE project_name like 'omb'
AND address LIKE '59103c383a3dfc3f8acaf3e29fda6a42ade729c5fbc27a16a33da8ff8b3d2f76i0'
)
SELECT *
FROM bitcoin.core.fact_outputs
WHERE tx_id
IN (
'59103c383a3dfc3f8acaf3e29fda6a42ade729c5fbc27a16a33da8ff8b3d2f76',
'fa7543fce4c21b16a56bd92aa8180588295854ea5ed3439e6272a37540bb1a7d',
'c7b6aababe6feaf2dc8669974b1fa4059e2b408ec86e6f87d24506d2745b628a',
'23b9c6d08a19a58c92a736b9dcefc2302410d2874522b1e6eafd8ed1ef73fc57',
'1eea9082dc739f40351780d829a77ecad0ccfc2434bc32f1fe80be536e33f296'
)
--(tx_id LIKE '29546dd0fd5c16b3e746e2ff00c70ddb1af3d67ff05d3dd023c6b09098b9bf64'
--OR tx_id LIKE '1eea9082dc739f40351780d829a77ecad0ccfc2434bc32f1fe80be536e33f296'
--OR tx_id LIKE '23b9c6d08a19a58c92a736b9dcefc2302410d2874522b1e6eafd8ed1ef73fc57'
--WHERE PUBKEY_SCRIPT_DESC LIKE 'rawtr(89cde2ae61eba6889aee9e9c3e88b572c523301753e957123bc5d483c4ee685e)#qaq4t072'
--AND PUBKEY_SCRIPT_TYPE LIKE 'witness_v1_taproot'
LIMIT 100
SELECT *
FROM bitcoin.core.fact_transactions
WHERE tx_id
IN (
'59103c383a3dfc3f8acaf3e29fda6a42ade729c5fbc27a16a33da8ff8b3d2f76',
'fa7543fce4c21b16a56bd92aa8180588295854ea5ed3439e6272a37540bb1a7d',
'c7b6aababe6feaf2dc8669974b1fa4059e2b408ec86e6f87d24506d2745b628a',
'23b9c6d08a19a58c92a736b9dcefc2302410d2874522b1e6eafd8ed1ef73fc57',
'1eea9082dc739f40351780d829a77ecad0ccfc2434bc32f1fe80be536e33f296'
)
Run a query to Download Data