Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
The Ethereum Name Service (ENS)is a distributed, open, and extensible naming system based on the Ethereum blockchain.
Users are able to register an ENS domain and replace their address with human-readable names that are easier to type and remember.
ENS Tables
The following ENS tables are available for users to query and enrich their analysis.
| Table Name | Description |
|---|
| names | Contains all ENS names and their corresponding numeric token ID. |
| registrations | Contains all ENS registration events. Registration events happen when a new ENS name is registered (almost like minted) for the first time, or when a registration expires and someone else registers it again. |
| renewals | Contains all ENS renewal events |
| net_transfers | Contains all ENS transfer events with ENS token ID as, sender and recipient address as well as transaction-level data. |
| primary_records_latest | Contains the current ENS primary record of any address. |
Sample Queries
Below are some examples of how you can use the ENS table to enrich your analysis.
Example 1 - Labelling of Wallets.
Using ens.primary_records_latest to identify ENS names of BoredApeYachtClub minters
select
block_timestamp,
name,
token_to_address,
token_address,
token_name,
token_symbol,
token_id,
raw_price,
price,
usd_price,
transaction_hash
from ethereum.nfts.mints
left join (select name, address from ethereum.ens.primary_records_latest) on address = token_to_address
where token_address = '0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d' -- BAYC contract
limit 100
Example 2 - Identify ENS sold by name
Using the ens.names to find sales of ENS by name with nfts.trades.
select
a.token_id as ens_id,
ens.name as ens_name,
marketplace,
buyer_address,
seller_address,
usd_price,
transaction_hash,
block_timestamp
from ethereum.nfts.trades a
left join ethereum.ens.names ens on a.token_id = ens.token_id
where token_address = '0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85' -- ENS Contract
limit 100
Table Column Name
Names
ethereum.ens.names
| Column Name | Description |
|---|
| token_id | Numeric token ID corresponding to the ENS name. |
| name | An ENS identifier such as ‘alice.eth’. Names may consist of multiple parts, called labels, separated by dots. |
Registrations
ethereum.ens.registrations
| Column | Description |
|---|
| name | An individual component of a name, such as ‘alice’. |
| owner_address | Address of the ENS owner. |
| eth_cost | ETH cost of the ENS registration. |
| usd_cost | USD cost of the ENS registration at the time of transaction. |
| registration_timestamp | Timestamp of the ENS registration. |
| expiry_timestamp | Expiry timestamp of the ENS name registered. |
| token_id | Numeric token ID corresponding to the ENS name. |
| log_index | Log index of the ENS registration. |
| transaction_hash | Transaction hash of the ENS registration. |
| block_number | Block number of the record. |
| block_hash | Block hash of the record. |
Renewals
ethereum.ens.renewals
| Column Name | Description |
|---|
| block_hash | Block hash of the renewal. |
| block_number | Block number of the renewal. |
| block_timestamp | Block timestamp of the renewal. |
| cost | Renewal cost in ETH. |
| expiry_date | Date of expiry of the renewal. |
| log_index | Log index of the ENS registration. |
| name | Name of the ENS domain that was renewed |
| transaction_hash | Transaction hash of the renewal. |
Net Transfers
ethereum.ens.net_transfers
| Column Name | Description |
|---|
| block_hash | Block hash of the transfer. |
| block_number | Block number of the transfer. |
| block_timestamp | Block timestamp of the transfer. |
| prev_transfer_block_timestamp | Block timestamp of the previous transfer. |
| from_address | Address of the sender. |
| to_address | Address of the receiver |
| token_id | Token ID of the ENS being transferred. |
| transaction_hash | Transaction hash of the transfer. |
Primary Record Latest
ethereum.ens.primary_records_latest
| Column Name | Description |
|---|
| address | Address that registered the ENS name. |
| block_hash | Block hash of the record. |
| block_number | Block number of the record. |
| block_timestamp | Block timestamp of the record. |
| name | An ENS identifier such as ‘alice.eth’. Names may consist of multiple parts, called labels, separated by dots. |
