EthereumAccount Creations
Column Descriptions
for eth.account_creations
7 rows
| Name | Type | Description |
|---|---|---|
| tx_hash | TEXT | |
| block_time | TIMESTAMP_NTZ | |
| account | TEXT | |
| ordinal | NUMBER | |
| block_hash | TEXT | |
| block_number | NUMBER | |
| block_date | DATE |
Sample Queries
New Account Creation Rate Over Time
Calculates the number of new accounts created per day.
SELECT
block_date,
COUNT(*) AS new_accounts
FROM
eth.account_creations
GROUP BY
block_date
ORDER BY
block_date;Find Account Creations in a Specific Block
Retrieves all account creations that occurred within a specific block number.
SELECT
*
FROM
eth.account_creations
WHERE
block_number = 15000000;Top 10 Blocks with Most Account Creations
Identifies the top 10 blocks with the highest number of account creations.
SELECT
block_number,
COUNT(*) AS account_creations
FROM
eth.account_creations
GROUP BY
block_number
ORDER BY
account_creations DESC
LIMIT
10;