Skip to main content

Tables

We have exposed a limited set of tables while in beta, and are actively working to add more. Fields with an index perform better when used in a join or where clause.

info

Need a specific type of data or column. Feel free to reach out to support (at) basement.dev, in the #📚sql discord channel or through the support chat in the bottom right corner.

Ethereum​

erc1155_balance​

NameTypeIndex?Description
owner_addresshex☑️
contract_addresshex☑️
token_idhexThrough contract_address
balancenumericThe balance by tallying all in and outgoing transfers for this owner_address

erc1155_transfer​

NameTypeIndex?Description
block_numberinteger☑️
transaction_hashhex☑️
log_indexintegerThrough transaction_hash or block_number
indexintegerThrough log_indexIn case of a batch transfer, the index within the emitted log
tohex☑️
fromhex☑️
contract_addresshex
token_idhex
valuenumeric
is_airdropbooleanWhether the transaction was not initiated by the receiver of the token.

erc721_transfer​

NameTypeIndex?Description
block_numberinteger☑️
transaction_hashhex☑️
log_indexintegerThrough transaction_hash
tohex☑️
fromhex☑️
contract_addresshex☑️
token_idhexThrough contract_address

marketplace_sale​

NameTypeIndex?Description
log_indexintegerThrough transaction_hash
event_indexintegerThrough log_index
transaction_hashhex☑️
taker_addresshex
maker_addresshex
token_contract_addresshex☑️
token_idhexThrough token_contract_address
pricenumericPrice in wei, note that this may be a currency other than ETH
currency_contract_addresshexThe ERC20 contract this sale was paid in. null if paid in ETH
marketplace_contract_addresshex

erc20_transfer​

NameTypeIndex?Description
block_numberinteger☑️
transaction_hashhex☑️
log_indexintegerThrough transaction_hash
tohex☑️
fromhex☑️
contract_addresshex☑️
valuenumeric-
is_airdropboolean-Whether the transaction was not initiated by the receiver of the token.

transaction​

NameTypeIndex?Description
block_numberinteger☑️
hashhex☑️
tohex☑️
fromhex☑️
contract_addresshex☑️The contract deployed in this transaction. Null if none were deployed.
valuenumeric-
gasnumeric-
gas_usednumeric-
gas_pricenumeric-

transaction_log​

NameTypeIndex?Description
block_numberinteger☑️
transaction_hashhex☑️
log_indexinteger
contract_addresshex☑️
topic0hex☑️
topic1hex
topic2hex
topic3hex
datahex