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

SELECT COUNT(*) AS Total

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)