Skip to content

Instantly share code, notes, and snippets.

@rifkiamil

rifkiamil/sql-bitcoin-05.sql

Created February 17, 2021 00:37
Show Gist options
  • Save rifkiamil/db915b307ef85fdc432a3502560d2d92 to your computer and use it in GitHub Desktop.
Save rifkiamil/db915b307ef85fdc432a3502560d2d92 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Bitcoin Part 2 - WHERE block_timestamp_month = Dec 2013 and Bitcoin Value more then 1 Bitcoin and hash transcation is e7f...fd7
Raw
sql-bitcoin-05.sql
SELECT block_timestamp,
block_timestamp_month,
output_value
FROM `bigquery-public-data.crypto_bitcoin.transactions`
WHERE block_timestamp_month = '2013-12-01'
and output_value > 10000000
and `hash` = 'e7f8fe18fdc039535fef6d3e82fc086cca2e50d2e1f7f68ab1e97ee8dcafdfd7'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment