=============================================================== */

SELECT COUNT(DISTINCT T2.pubkey_script_address, T3.pubkey_script_address) AS Total

FROM (

SELECT BT.tx_id

FROM bitcoin.core.fact_transactions AS BT

WHERE date_trunc('day', (BT.block_timestamp)) = '{{DAY}}'

AND BT.input_value >= {{BTC_MIN}} -- Define the MIN Amount of BTC

AND BT.is_coinbase = FALSE -- Exclude COINBASE transactions (no source address)

) AS T1

LEFT JOIN (

SELECT TI.pubkey_script_address, TI.tx_id

FROM bitcoin.core.fact_inputs AS TI

WHERE date_trunc('day', (TI.block_timestamp)) = '{{DAY}}'

) AS T2 ON T1.tx_id = T2.tx_id

LEFT JOIN (

SELECT TX.pubkey_script_address, TX.tx_id

FROM bitcoin.core.fact_outputs AS TX

WHERE date_trunc('day', (TX.block_timestamp)) = '{{DAY}}'

) AS T3 ON T1.tx_id = T3.tx_id

WHERE T2.pubkey_script_address <> T3.pubkey_script_address -- Exclude self loops / Change