SELECT

DISTINCT address,

LABEL

FROM

bitcoin.core.dim_labels

WHERE

label_type = 'cex'

AND blockchain = 'bitcoin'

),

btc_flows AS (

SELECT

date_trunc('month', block_timestamp) AS day,

LABEL,

SUM(

CASE

WHEN tx_type = 'out' THEN value

END

) AS outflow,

SUM(

CASE

WHEN tx_type = 'in' THEN value

END

) AS inflow

FROM

(

SELECT

block_timestamp,

'out' AS tx_type,

value,

pubkey_script_address

FROM

bitcoin.core.fact_inputs

WHERE

pubkey_script_address IN (

SELECT