Preview:
# List metadata from selected tables with WHERE clause 
#standardSQL 
SELECT table_name, creation_time 
FROM `bigquery-public-data.ethereum_blockchain`.INFORMATION_SCHEMA.TABLES 
WHERE table_type = "BASE TABLE" 
AND table_name LIKE "%token%";
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter