jackguybb 2
Updated 2023-10-31
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 Receive AS (
SELECT
PUBKEY_SCRIPT_ADDRESS as address,
sum(value) AS value
FROM bitcoin.core.fact_outputs
where PUBKEY_SCRIPT_ADDRESS is not null
AND PUBKEY_SCRIPT_ADDRESS in (
'34xp4vRoCGJym3xR7yCVPFHoCNxv4Twseo',
'bc1qgdjqv0av3q56jvd82tkdjpy7gdp9ut8tlqmgrpmv24sq90ecnvqqjwvw97',
'bc1ql49ydapnjafl5t2cp9zqpjwe6pdgmxy98859v2',
'39884E3j6KZj82FK4vcCrkUvWYL5MQaS3v'
)
AND block_timestamp > current_date - 365
GROUP BY 1
), Send AS (
SELECT
PUBKEY_SCRIPT_ADDRESS as address, SUM(-1 * value) AS value
FROM bitcoin.core.fact_inputs
where PUBKEY_SCRIPT_ADDRESS is not null
AND PUBKEY_SCRIPT_ADDRESS in (
'34xp4vRoCGJym3xR7yCVPFHoCNxv4Twseo',
'bc1qgdjqv0av3q56jvd82tkdjpy7gdp9ut8tlqmgrpmv24sq90ecnvqqjwvw97',
'bc1ql49ydapnjafl5t2cp9zqpjwe6pdgmxy98859v2',
'39884E3j6KZj82FK4vcCrkUvWYL5MQaS3v'
)
AND block_timestamp > current_date - 365
GROUP BY 1
)
select address, sum(value) as amount
from (
select * from Receive
union all
select * from Send
)
Run a query to Download Data