PolygonAccount Creations

Column Descriptions

for polygon.account_creations

7 rows

Name	Type	Description
account	TEXT	Address of the newly created account
block_date	DATE	Date of the block in which the account was created
tx_hash	TEXT	Hash of the transaction that created the account
block_number	NUMBER	Block number in which the account was created
block_time	TIMESTAMP_NTZ	Timestamp of the block in which the account was created
ordinal	NUMBER	Ordinal of the account creation within the block
block_hash	TEXT	Hash of the block in which the account was created

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
  polygon.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
  polygon.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
  polygon.account_creations
GROUP BY
  block_number
ORDER BY
  account_creations DESC
LIMIT
  10;