, block_timestamp

, tx_id as tx_hash

, pubkey_script_address as from_address

, o.to_address

, NULL as contract_address

, o.symbol

, o.amount

FROM bitcoin.core.fact_inputs i

INNER JOIN(SELECT

tx_id as out_tx_hash

, pubkey_script_address as to_address

, 'BTC' as symbol

, value as amount

FROM bitcoin.core.fact_outputs

WHERE tx_id IN (

'49819c3260fd8b2ecdfa4785e2fedf7b81fe460f0f5b7416962adf3367bf0ef2',

'8fcd6f4c7c684ce79d11e90760d4acbbbac453d84e78aafc426ab0004eb8cb59',

'cde9369a75c7a26a6bc415321ac94b660a06ee3adfaf166666dc030d43a259af',

'e12f64c907929168632e62a00da5840de9a3edb055bd6f5da11fca241eaebb2f',

'e1069d2e21774dc45b6a90c28eb57666f21d5721b4101fc153b6f5e8ede46544',

'b889c8e842aef096862b1ec31d07eaa33a52d702688b0cef6c559832360f0851',

'6f7acb93e34a592d7426622d6a11629b351b29d636959d576bcf39c5d13558fd',

'34ccc889af2f2c66624a3fdb574f10b7f241a5fa9968f84fdef9a3d3df0527b9',

'1a26d47393ee97dad2191b759a72c15f81f07f5af7de1755db0e58e5c00e9b33',

'7397511340775279cdf2f8dd2ee23aa7f850b36f55b8b62862e2e4d02ab828dc',

'4c56f2cf3606cf7700825ed8819b494a837c675828c6d2e2e2c067bb873b1786',

'b8f239b5049ed09e66e2bb6ba35888de93cb24f6fc335207a2ab7af76b585ed2',

'1eee6e8772ff70816c094a7898f4213092ecf92976acea06bd05a128390bf545',

'43a21c02eead4579b6b77d1f33575053d839b1e014d66d0fecdc476f155967c7',

'd40f47d30f5586c278b814c917cf4d270275284da09c060ad3a52ec88d91f765',

'1785fe63d6e3cb71f3d8602fda17d307b384ce54fee1aecf5127dc48e662af0f',

'9f1e727272cc39ca82d544fa00d1a897c1ba01c3051606de7dc1df8c5fae6463',