Skip to content

Instantly share code, notes, and snippets.

@rifkiamil

rifkiamil/sql-dogecoin_find-transcation.sql

Created February 11, 2021 13:24
Show Gist options
  • Save rifkiamil/a766c93750170b5f22431e014038d4e8 to your computer and use it in GitHub Desktop.
Save rifkiamil/a766c93750170b5f22431e014038d4e8 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Bitcoin Part 1 - Find dogecoin transaction
Raw
sql-dogecoin_find-transcation.sql
SELECT di.transaction_hash,
di.block_number,
di.block_timestamp,
di.addresses,
di.value
FROM `bigquery-public-data.crypto_dogecoin.inputs` as di
WHERE di.transaction_hash = 'c2941b764e5436aa4bb39eaa1360cf7156f80d831141c0d352e950d7f2427325'
LIMIT 1000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment