Rif rifkiamil

rifkiamil / sql-bitcoin-02.sql

Created February 10, 2021 14:38

SQL Bitcoin Part 1 - Find ethereum transaction

	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'

rifkiamil / sql-bitcoin_find-transcation.sql

Last active February 11, 2021 13:22

SQL Bitcoin Part 1 - Find bitcoin transaction

	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'

rifkiamil / bigquery-public-data.crypto_ethereum.blocks.QDD

Last active February 16, 2025 12:24

DATASET bigquery-public-data DB crypto_ethereum - quickdatabasediagrams

	"bigquery-public-data.crypto_ethereum.balances" as Bal
	-
	address STRING
	eth_balance NUMERIC

	"bigquery-public-data.crypto_ethereum.blocks" as B
	--
	column_name data_type
	timestamp TIMESTAMP
	number INT64