BNB Smart ChainAccount Creations

Column Descriptions

for bsc.account_creations

7 rows

Name	Type	Description
block_date	DATE
block_number	NUMBER
block_hash	TEXT
block_time	TIMESTAMP_NTZ
account	TEXT
tx_hash	TEXT
ordinal	NUMBER

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