EthereumCode Changes
Column Descriptions
for eth.code_changes
9 rows
| Name | Type | Description |
|---|---|---|
| block_number | NUMBER | |
| block_time | TIMESTAMP_NTZ | |
| code | TEXT | |
| from | TEXT | |
| tx_hash | TEXT | |
| factory | TEXT | |
| block_date | DATE | |
| block_hash | TEXT | |
| address | TEXT |
Sample Queries
Daily Code Change Count in Nov 2024
Number of code changes per day in November 2024
SELECT
block_date,
COUNT(*) AS code_change_count
FROM
eth.code_changes
WHERE
block_date BETWEEN '2024-11-01' AND '2024-11-30'
GROUP BY
block_date
ORDER BY
block_date;Top 10 Contracts by Code Change Count in Nov 2024
Lists the 10 contracts with the most code changes in November 2024
SELECT
address,
COUNT(*) AS change_count
FROM
eth.code_changes
WHERE
block_date BETWEEN '2024-11-01' AND '2024-11-30'
GROUP BY
address
ORDER BY
change_count DESC
LIMIT
10;Code Change Transactions by Factory in Nov 2024
Lists the transactions grouped by factory contracts involved in code changes in November 2024
SELECT
factory,
COUNT(*) AS tx_count
FROM
eth.code_changes
WHERE
block_date BETWEEN '2024-11-01' AND '2024-11-30'
GROUP BY
factory
ORDER BY
tx_count DESC
LIMIT
10;