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
| Name | Type | Index? | Description |
|---|---|---|---|
owner_address | hex | ☑️ | |
contract_address | hex | ☑️ | |
token_id | hex | Through contract_address | |
balance | numeric | The balance by tallying all in and outgoing transfers for this owner_address |
erc1155_transfer
| Name | Type | Index? | Description |
|---|---|---|---|
block_number | integer | ☑️ | |
transaction_hash | hex | ☑️ | |
log_index | integer | Through transaction_hash or block_number | |
index | integer | Through log_index | In case of a batch transfer, the index within the emitted log |
to | hex | ☑️ | |
from | hex | ☑️ | |
contract_address | hex | ||
token_id | hex | ||
value | numeric | ||
is_airdrop | boolean | Whether the transaction was not initiated by the receiver of the token. |
erc721_transfer
| Name | Type | Index? | Description |
|---|---|---|---|
block_number | integer | ☑️ | |
transaction_hash | hex | ☑️ | |
log_index | integer | Through transaction_hash | |
to | hex | ☑️ | |
from | hex | ☑️ | |
contract_address | hex | ☑️ | |
token_id | hex | Through contract_address |
marketplace_sale
| Name | Type | Index? | Description |
|---|---|---|---|
log_index | integer | Through transaction_hash | |
event_index | integer | Through log_index | |
transaction_hash | hex | ☑️ | |
taker_address | hex | ||
maker_address | hex | ||
token_contract_address | hex | ☑️ | |
token_id | hex | Through token_contract_address | |
price | numeric | Price in wei, note that this may be a currency other than ETH | |
currency_contract_address | hex | The ERC20 contract this sale was paid in. null if paid in ETH | |
marketplace_contract_address | hex |
erc20_transfer
| Name | Type | Index? | Description |
|---|---|---|---|
block_number | integer | ☑️ | |
transaction_hash | hex | ☑️ | |
log_index | integer | Through transaction_hash | |
to | hex | ☑️ | |
from | hex | ☑️ | |
contract_address | hex | ☑️ | |
value | numeric | - | |
is_airdrop | boolean | - | Whether the transaction was not initiated by the receiver of the token. |
transaction
| Name | Type | Index? | Description |
|---|---|---|---|
block_number | integer | ☑️ | |
hash | hex | ☑️ | |
to | hex | ☑️ | |
from | hex | ☑️ | |
contract_address | hex | ☑️ | The contract deployed in this transaction. Null if none were deployed. |
value | numeric | - | |
gas | numeric | - | |
gas_used | numeric | - | |
gas_price | numeric | - |
transaction_log
| Name | Type | Index? | Description |
|---|---|---|---|
block_number | integer | ☑️ | |
transaction_hash | hex | ☑️ | |
log_index | integer | ||
contract_address | hex | ☑️ | |
topic0 | hex | ☑️ | |
topic1 | hex | ||
topic2 | hex | ||
topic3 | hex | ||
data | hex |