BNB Smart ChainStorage Changes

Column Descriptions

for bsc.storage_changes

10 rows

Name	Type	Description
block_time	TIMESTAMP_NTZ
new_value	TEXT
tx_hash	TEXT
block_date	DATE
block_hash	TEXT
block_number	NUMBER
address	TEXT
old_value	TEXT
ordinal	NUMBER
key	TEXT

Sample Queries

Top 10 Modified Addresses

Lists the 10 addresses with the most storage changes in November 2024

SELECT
  address,
  COUNT(*) AS change_count
FROM
  bsc.storage_changes
WHERE
  block_date BETWEEN '2024-11-01' AND '2024-11-30'
GROUP BY
  address
ORDER BY
  change_count DESC
LIMIT
  10;

Addresses With Most Distinct Storage Keys Changed

Lists the 10 addresses that modified the most distinct storage keys in November 2024

SELECT
  address,
  COUNT(DISTINCT key) AS distinct_key_count
FROM
  bsc.storage_changes
WHERE
  block_date BETWEEN '2024-11-01' AND '2024-11-30'
GROUP BY
  address
ORDER BY
  distinct_key_count DESC
LIMIT
  10;

Storage Changes by Block Showing New and Old Value Prefixes

Shows the first 10 characters of new and old values of the first 10 Storage changes for each block, for November 2024

SELECT
  block_number,
  SUBSTR (new_value, 1, 10) as new_value_prefix,
  SUBSTR (old_value, 1, 10) as old_value_prefix
FROM
  bsc.storage_changes
WHERE
  block_date BETWEEN '2024-11-01' AND '2024-11-30'  QUALIFY ROW_NUMBER() OVER (
    PARTITION BY
      block_number
    ORDER BY
      ordinal
  ) <= 10
ORDER BY
  block_number;