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

GROUP BY 1

),

labels as (

select

SPLIT_PART(column1, ',', 1) AS address,

SPLIT_PART(column1, ',', 2) AS label

from

values

('34xp4vRoCGJym3xR7yCVPFHoCNxv4Twseo,Binance'),

('39884E3j6KZj82FK4vcCrkUvWYL5MQaS3v,Binance'),

('bc1qazcm763858nkj2dj986etajv6wquslv8uxwczt,US Government'),

('bc1qa5wkgaew2dkv56kfvj49j0av5nml45x9ek9hz6,US Government'),

('38DN2uFMZPiHLHJigfv4kWC9JWJrNnhLcn,Binance'),

('3LQUu4v9z6KNch71j7kbj8GPeAGUo1FW6a,Binance'),

('3FHNBLobJnbCTFTVakh5TXmEneyf5PT61B,Binance'),

('bc1qf2yvj48mzkj7uf8lc2a9sa7w983qe256l5c8fs,US Government'),

('bc1qm34lsc65zpw79lxes69zkqmk6ee3ewf0j77s3h,Binance'),

('3Qxak1CZhLyZ7GVckKphLURdLBCjMfz9bA,Binance'),

('34HpHYiyQwg69gFmCq2BGHjF1DZnZnBeBP,Binance'),

('1Pzaqw98PeRfyHypfqyEgg5yycJRsENrE7,Binance'),

('36zSLdRv1jyewjaC12fqK5fptn7PqewunL,Binance'),

('1LnoZawVFFQihU8d8ntxLMpYheZUfyeVAK,OKX'),

),

Send AS (

SELECT

PUBKEY_SCRIPT_ADDRESS as address, SUM(-value) AS value

FROM bitcoin.core.fact_inputs