Skip to content

Instantly share code, notes, and snippets.

@rifkiamil

rifkiamil/sql-eth-03.sql

Created February 23, 2021 07:11
Show Gist options
  • Save rifkiamil/45f7b558abad447df833498ee8d4265c to your computer and use it in GitHub Desktop.
Save rifkiamil/45f7b558abad447df833498ee8d4265c to your computer and use it in GitHub Desktop.
Download ZIP
Find Ethereum - Internal transactions - Matchs Advanced view on Etherscan.io
Raw
sql-eth-03.sql
## Find Ethereum - Internal transactions - Matchs Advanced 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
ORDER BY transaction_index
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment