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

SELECT COUNT (DISTINCT T2.pubkey_script_address) AS Total

FROM (

SELECT date_trunc('day', (BT.block_timestamp)) AS DAY, 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}}'

UNION

SELECT TX.pubkey_script_address, TX.tx_id

FROM bitcoin.core.fact_outputs AS TX

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

) AS T2 ON T1.tx_id = T2.tx_id