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

SELECT date_trunc('day', (BT.block_timestamp)) AS DAY, BT.block_number, BT.input_value, BT.output_value

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)