Skip to content

Instantly share code, notes, and snippets.

@franz101

franz101/get_idm_ethereum.SQL

Created April 7, 2022 12:59
Show Gist options
  • Save franz101/08a951b43d94b550a2cba799051d7a28 to your computer and use it in GitHub Desktop.
Save franz101/08a951b43d94b550a2cba799051d7a28 to your computer and use it in GitHub Desktop.
Download ZIP
Query Ascii text on ethereum
Raw
get_idm_ethereum.SQL
SELECT * FROM `bigquery-public-data.crypto_ethereum.transactions` WHERE DATE(block_timestamp) > "2021-06-01" AND
(input LIKE '%68747470733a2f2f%' OR input LIKE '%2074686520%' OR input LIKE '%20616e6420%') AND input NOT LIKE '%000%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment