Skip to content

Instantly share code, notes, and snippets.

@rifkiamil

rifkiamil/sql-eth-02.sql

Created February 23, 2021 06:54
Show Gist options
  • Save rifkiamil/5a1121c2635450ca513724c995bfe811 to your computer and use it in GitHub Desktop.
Save rifkiamil/5a1121c2635450ca513724c995bfe811 to your computer and use it in GitHub Desktop.
Download ZIP
Find Ethereum - Internal transactions with values - Matchs default view on Etherscan.io
Raw
sql-eth-02.sql
## Find Ethereum - Internal transactions with values - Matchs default view on Etherscan.io
SELECT *
FROM `bigquery-public-data.crypto_ethereum.traces`
WHERE DATE(block_timestamp) = "2021-02-12"
and trace_address IS NOT NULL
and block_number = 11838934
and value > 0
ORDER BY transaction_index
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment