.
`bigquery-public-data.crypto_ethereum.transactions` et LEFT JOIN labeled_data ld ON et.from_address = ld.address WHERE block_timestamp > TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 30 DAY) GROUP BY day, ld.entity ORDER BY total_blobs DESC; """ # Run the query query_job = client.query(query) results