Contracts

dimensions.contracts holds one row per contract deployed on Arbitrum, keyed on chain_id and contract_address. The row describes the address’s first deployment: the time it appeared, the account that signed for it, the account that called CREATE, and the size of the deployed bytecode. The list is everything we see onchain, which reaches far past the contracts anyone has labeled: joining dimensions.accounts on account_id keeps the result to addresses a project has been attributed, and names them. Every column is documented at Contracts.

Sample queries

The table is clustered on chain_id and contract_address, and those two columns are all that prunes a scan of it. Filter on the chain, and on the address where you have it; a query that filters on neither reads the whole table.

Look up a contract
A factory's output
Token contracts

When one Arbitrum contract was first deployed, and by whom.

select
    first_deployed_at,
    deployer_address,
    creator_address,
    contract_size
from `dimensions.contracts`
where chain_id = 'arbitrum'
  and contract_address = '0x71962b7f226f96e6ee2bc38c937932dcdb949c1f'

List the contracts one factory created. This factory deploys contracts in bulk, so creator_address returns its output.

select
    contract_address,
    first_deployed_at,
    contract_size
from `dimensions.contracts`
where chain_id = 'arbitrum'
  and creator_address = '0x9d0e2aac65d4d59f55eee0ae301f8064f2859f48'
order by first_deployed_at
limit 100

Date the token contracts on Arbitrum. Joining dimensions.tokens on account_id gives each token’s symbol beside the day its contract first appeared.

select
    tokens.symbol,
    contracts.contract_address,
    contracts.first_deployed_at
from `dimensions.contracts` as contracts
join `dimensions.tokens` as tokens
    on tokens.token_id = contracts.account_id
where contracts.chain_id = 'arbitrum'
  and contracts.first_deployed_at >= timestamp('2023-06-01')
order by contracts.first_deployed_at desc
limit 100

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Sample queries

​Sample queries

Sample queries