MAX(inputs.PUBKEY_SCRIPT_ADDRESS) AS FROM_ADDRESS,

outputs.PUBKEY_SCRIPT_ADDRESS AS TO_ADDRESS,

COUNT(*) AS COUNTER,

SUM(outputs.VALUE) AS TOTAL_VALUE,

MIN(inputs.BLOCK_TIMESTAMP) AS FIRST,

MAX(inputs.BLOCK_TIMESTAMP) AS LAST

FROM bitcoin.core.fact_outputs AS outputs

JOIN bitcoin.core.fact_inputs AS inputs

ON inputs.TX_ID = outputs.TX_ID

WHERE inputs.PUBKEY_SCRIPT_ADDRESS = 'bc1qamgjuxaywqls56h7rg7afga3m6rgqwfkew688k'

AND TO_ADDRESS = 'bc1q3kgqhadama6whr89fxnhstsh9zfhpjgculpszx'

GROUP BY TO_ADDRESS