Skip to content

Instantly share code, notes, and snippets.

@rifkiamil

rifkiamil/sql-bitcoin-02.sql

Created February 10, 2021 14:38
Show Gist options
  • Save rifkiamil/13024a599882aeea1c1eb395689912b6 to your computer and use it in GitHub Desktop.
Save rifkiamil/13024a599882aeea1c1eb395689912b6 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Bitcoin Part 1 - Find ethereum transaction
Raw
sql-bitcoin-02.sql
SELECT et.hash,
et.nonce,
et.from_address,
et.to_address,
et.block_hash,
et.block_timestamp
FROM `bigquery-public-data.crypto_ethereum.transactions` as et
WHERE et.hash = '0x523542d3bbca5d8fce33c933b6bf169723b49294319227e145c48e5b4ce13f11'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment