Skip to content

Instantly share code, notes, and snippets.

@rifkiamil

rifkiamil/sql-bitcoin_find-transcation.sql

Last active February 11, 2021 13:22
Show Gist options
  • Save rifkiamil/8756f79deb43c906fe919f0ff22c91eb to your computer and use it in GitHub Desktop.
Save rifkiamil/8756f79deb43c906fe919f0ff22c91eb to your computer and use it in GitHub Desktop.
Download ZIP
SQL Bitcoin Part 1 - Find bitcoin transaction
Raw
sql-bitcoin_find-transcation.sql
SELECT bi.transaction_hash,
bi.block_number,
bi.block_timestamp,
bi.addresses,
bi.value
FROM `bigquery-public-data.crypto_bitcoin.inputs` as bi
WHERE bi.transaction_hash = 'f4184fc596403b9d638783cf57adfe4c75c605f6356fbc91338530e9831e9e16'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment