Ethereum Smart Contracts
Historical smart contracts data for blockchain ethereum
@blt.ethereum_contracts
Historical smart contracts data for blockchain ethereum
@blt.ethereum_contracts
CREATE TABLE contract_abis (
"contract_address" VARCHAR,
"abi_source_type" VARCHAR,
"abi_source" VARCHAR,
"abi_sha256" VARCHAR,
"contract_name" VARCHAR,
"is_proxy" BOOLEAN,
"implementation_address" VARCHAR,
"block_number" BIGINT,
"block_timestamp" TIMESTAMP,
"ingested_at" TIMESTAMP
);
CREATE TABLE contract_bytecode_hashes (
"contract_address" VARCHAR,
"bytecode_hash" VARCHAR,
"block_timestamp" TIMESTAMP
);
CREATE TABLE contracts (
"address" VARCHAR,
"bytecode" VARCHAR,
"creator_address" VARCHAR,
"creation_transaction_hash" VARCHAR,
"block_number" BIGINT,
"block_timestamp" TIMESTAMP,
"ingested_at" TIMESTAMP
);
Anyone who has the link will be able to view this.