Skip to content

Instantly share code, notes, and snippets.

@Fitblip

Fitblip/CoinbaseBigQuery.sql

Last active May 17, 2017 22:26
Show Gist options
  • Save Fitblip/5b269ef6e92f174e64df3ea26679f87a to your computer and use it in GitHub Desktop.
Save Fitblip/5b269ef6e92f174e64df3ea26679f87a to your computer and use it in GitHub Desktop.
Download ZIP
Finding all coinbase sites using BigQuery
Raw
CoinbaseBigQuery.sql
SELECT
all_dns_names
FROM
[ctl-lists:certificate_data.scan_data]
WHERE
(REGEXP_MATCH(all_dns_names,r'.*\.coinbase.com[\s$]?'))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment