Contracts

A "smart contract" is simply a program that runs on the Ethereum blockchain. It's a collection of code (its functions) and data (its state) that resides at a specific address on the Ethereum blockchain.

Smart contracts are a type of Ethereum account. This means they have a balance and can be the target of transactions. However they're not controlled by a user, instead they are deployed to the network and run as programmed. User accounts can then interact with a smart contract by submitting transactions that execute a function defined on the smart contract. Smart contracts can define rules, like a regular contract, and automatically enforce them via the code. Smart contracts cannot be deleted by default, and interactions with them are irreversible. Source: Official Ethereum Docs

Sample Query

Find the latest contracts deployed by block_timestamp.

select *
  from ethereum.raw.contracts
order by block_timestamp desc 
limit 100

Table Columns

Uniswap V3 Router 2 used as an example.

Column Name	Description	Example
address	Contract address.	0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45
bytecode	The bytecode data of this contract.	<truncated> 0x6080604052600436106102
block_timestamp	The timestamp of the block that this contract was created in.	2021-12-14 17:37:26
block_number	The number of the block that this contract was created in.	13,804,681
block_hash	The hash of the block that this contract was created in.	0xa13d35ff8d6037c88537d5f1bcfaceb6eeb735956923e30a773a28e9a4917d43
transaction_hash	The transaction hash of the block that this contract was created in.	0x7299cca7203f60a831756e043f4c2ccb0ee6cb7cf8aed8420f0ae99a16883a2b
deployer	Address of the contract deployer.	0x6c9fc64a53c1b71fb3f9af64d1ae3a4931a5f4e9