clayopDelioBTC_Inflow
Updated 2023-08-14
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
›
⌄
WITH
ADDRESSES AS (
SELECT *
FROM (VALUES
('1CbypS4uDdxPdYE93TQVw2UXo7Mv5AnB7t')
) AS address(address)
),
TARGET_OUTPUT AS (
SELECT DISTINCT
TX_ID, INDEX, VALUE
FROM
bitcoin.core.fact_outputs
WHERE
PUBKEY_SCRIPT_ADDRESS in (SELECT address FROM ADDRESSES)
)
SELECT
i.BLOCK_TIMESTAMP AS TIMESTAMP,
t.TX_ID AS TX_ID,
i.PUBKEY_SCRIPT_ADDRESS AS FROM_ADDRESS,
'Delio' AS TO_ADDRESS,
t.VALUE AS AMOUNT
FROM
TARGET_OUTPUT AS t
INNER JOIN bitcoin.core.fact_inputs AS i ON t.TX_ID = i.TX_ID AND i.INDEX = 0
WHERE
FROM_ADDRESS not in (SELECT address FROM ADDRESSES)
ORDER BY TIMESTAMP
Run a query to Download Data