EthereumLogs

Column Descriptions

for eth.logs

19 rows

Sample Queries

Daily Log Count

Number of logs emitted per day.

SELECT
  block_date,
  COUNT(*) AS log_count
FROM
  eth.logs
GROUP BY
  block_date
ORDER BY
  block_date
LIMIT
  100;

Top 10 Contracts by Log Emission

Lists the 10 contracts that emit the most logs.

SELECT
  contract_address,
  COUNT(*) AS log_count
FROM
  eth.logs
GROUP BY
  contract_address
ORDER BY
  log_count DESC
LIMIT
  10;

Log Count by Topic 0

Counts logs grouped by their primary topic.

SELECT
  topic0,
  COUNT(*) AS log_count
FROM
  eth.logs
GROUP BY
  topic0
ORDER BY
  log_count DESC
LIMIT
  100;