Tables
BaseRegistrarImplementation_renew_function
ENS (Ethereum Name Service) domain renewal transactions on Ethereum mainnet, capturing renew function calls with token IDs, renewal durations, and new expiration timestamps. Used for analyzing domain registration lifecycle and renewal patterns.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
trace_address | STRING | Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
value | FLOAT64 | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
gas | INT64 | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
in_id | STRING | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
in_duration | STRING | Duration period for the operation or quest. Numeric string representation in seconds. |
out_anon0 | STRING | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
Sample Data
Sample Data
| gas | in_id | value | status | gas_used | out_anon0 | signature | to_address | in_duration | block_number | from_address | trace_address | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20430 | 35428366541581083300475176500434834942442073850091881807164271331819818276561 | 0 | false | 17974 | 1620107352 | 0xc475abff | 0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85 | 31556952 | 9677980 | 0x283af0b28c62c092c9727f1ee09c02ca627eb7f5 | 2 | 2020-03-15T19:24:00.000Z | 0x6cc137cd83df0eda4e29d13b3533ce7aa40fd376050685e5f5618a0e3a5b8ca6 |
| 20430 | 108690869056670528237772364368788048106749640056611640171982233733738861860977 | 0 | false | 17974 | 1620107352 | 0xc475abff | 0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85 | 31556952 | 9677985 | 0x283af0b28c62c092c9727f1ee09c02ca627eb7f5 | 2 | 2020-03-15T19:25:27.000Z | 0xfbcf563f733b8f964b81e627db717cf939007d238deb2f49ad06b329a12a1149 |
| 20430 | 92186369686659647534714202875254478118352326136620482918448746115836531915872 | 0 | false | 17974 | 1620107352 | 0xc475abff | 0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85 | 31556952 | 9677990 | 0x283af0b28c62c092c9727f1ee09c02ca627eb7f5 | 2 | 2020-03-15T19:25:46.000Z | 0xc8a4cfa6bffe7f6e070d9a018b88e7802156b39b382ef5837e5baa3bd113de83 |
Example Query
Example Query
Query with partition filter
ETHRegistrarController_NameRegistered_event
ENS (Ethereum Name Service) domain registration events on Ethereum mainnet, recording each .eth name registered with registration cost, owner address, expiration timestamp, and name hash label. Used for analyzing ENS adoption, registration patterns, pricing trends, and domain ownership distribution.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_name | STRING | Name or label identifier for the entity being created, registered, or updated in the event. |
in_label | STRING | Label describing the type of operation or transaction. Common values include ‘mint’, ‘redeem’, and ‘buy’. |
in_owner | STRING | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
in_cost | STRING | Registration cost paid in wei (smallest unit of ETH) for acquiring the ENS domain. Stored as string to preserve precision for large integer values. |
in_expires | STRING | Unix timestamp when the ENS domain name registration expires. String-encoded integer representing seconds since epoch. |
Sample Data
Sample Data
| address | in_cost | in_name | removed | in_label | in_owner | log_index | in_expires | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|
| 0xf0ad5cad05e10572efceb849f6ff0c68f9700455 | 30998075788385340 | contractcert | false | 0x9498c08802cf7e509333413f06f32e55b30c102581e1e19fe62eb5407cc61431 | 0x605ee5541b1a79e3461145b8ba2ca106f5fdd747 | 66 | 1603432887 | 8799792 | 2019-10-24T00:12:15.000Z | 0x2269d5eec4d63b05d678c0878712dd0205127df1a88fca0bbe9c30d3a2b27005 |
| 0xf0ad5cad05e10572efceb849f6ff0c68f9700455 | 30921924030863118 | salecert | false | 0x3af8dce421e3284e486ad13a8684a4392cbad03d841c82eb9367496e60c03d28 | 0x605ee5541b1a79e3461145b8ba2ca106f5fdd747 | 27 | 1603435980 | 8799996 | 2019-10-24T01:03:48.000Z | 0xeba1e294f21ba44efec86bfcd3ea860a97a37e2ba1eff77a1b364078eff0a4b9 |
| 0xf0ad5cad05e10572efceb849f6ff0c68f9700455 | 30921924030863118 | rentcert | false | 0xd0aba00ff5b65f46222c5b5b5ed82c5acfcdb2ca81e7d0d03eb1f90e8bc99a95 | 0x605ee5541b1a79e3461145b8ba2ca106f5fdd747 | 135 | 1603436843 | 8800070 | 2019-10-24T01:18:11.000Z | 0x768789fa6df3fbfe196dff368f3392c566297ecdc94111f857e646bf8d8ab93a |
Example Query
Example Query
Query with partition filter
ETHRegistrarController_NameRenewed_event
Ethereum Name Service (ENS) domain renewal events from the ETHRegistrarController contract, capturing when .eth names are extended with renewal cost, expiration timestamps, and domain labels. Used for tracking ENS domain lifecycle, renewal patterns, and registration economics on Ethereum mainnet.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_name | STRING | Name or label identifier for the entity being created, registered, or updated in the event. |
in_label | STRING | Label describing the type of operation or transaction. Common values include ‘mint’, ‘redeem’, and ‘buy’. |
in_cost | STRING | Cost paid in wei to renew the ENS name for the specified period. Represented as a string-encoded integer due to potential overflow of standard numeric types. |
in_expires | STRING | Unix timestamp when the ENS domain name registration expires. String-encoded integer representing seconds since epoch. |
Sample Data
Sample Data
| address | in_cost | in_name | removed | in_label | log_index | in_expires | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x283af0b28c62c092c9727f1ee09c02ca627eb7f5 | 24497267517693923 | etherdelta | false | 0x53da75fc5c2036760338ff2c47fc2e8b921c0a4f8362c001744380b12fd7b50e | 115 | 1620107352 | 10139323 | 2020-05-26T04:48:05.000Z | 0xc1036bac5a96914b26cf0c2ed70480acb9d242f7ad6b060d0e7102046c9ad427 |
| 0x283af0b28c62c092c9727f1ee09c02ca627eb7f5 | 24497267517693923 | rewardcards | false | 0x9a610bf0e64712af7464e9a90661d7855d9ee5fe8010a1053ad7878c724263f0 | 127 | 1620107352 | 10139323 | 2020-05-26T04:48:05.000Z | 0xc1036bac5a96914b26cf0c2ed70480acb9d242f7ad6b060d0e7102046c9ad427 |
| 0x283af0b28c62c092c9727f1ee09c02ca627eb7f5 | 24497267517693923 | paymentprotocol | false | 0xcf744f441bae49631dc0fff71821d931bffe2638e7157ffebd8ba87906b571de | 135 | 1620107352 | 10139323 | 2020-05-26T04:48:05.000Z | 0xc1036bac5a96914b26cf0c2ed70480acb9d242f7ad6b060d0e7102046c9ad427 |
Example Query
Example Query
Query with partition filter
ETHRegistrarController_renew_function
ENS (Ethereum Name Service) domain renewal transactions from the ETHRegistrarController contract on Ethereum mainnet. Captures renewal payments, duration extensions, and domain names for analyzing ENS registration economics and domain holder behavior.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
trace_address | STRING | Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
value | FLOAT64 | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
gas | INT64 | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
in_name | STRING | Name or label identifier for the entity being created, registered, or updated in the event. |
in_duration | STRING | Duration period for the operation or quest. Numeric string representation in seconds. |
Sample Data
Sample Data
| gas | value | status | in_name | gas_used | signature | to_address | in_duration | block_number | from_address | trace_address | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50593 | 168286364999959870 | true | atptour | 50593 | 0xacf1a841 | 0xb22c1c159d12461ea124b0deb4b5b93020e6ad16 | 157784760 | 9057469 | 0x7739ffe6706bae8087f104ee388cd622e7dbba00 | 2019-12-05T23:22:34.000Z | 0xa83194716e402ca7e13c67ef93cc8512e3bb0f4fc8e0b0f48b325f478439d8c1 | |
| 50845 | 168246752229935000 | true | flylevel | 50845 | 0xacf1a841 | 0xb22c1c159d12461ea124b0deb4b5b93020e6ad16 | 157784760 | 9057231 | 0x7739ffe6706bae8087f104ee388cd622e7dbba00 | 2019-12-05T22:22:25.000Z | 0x9d70d97ca938c4a57e617bbe5fb2e59d7e6ca6e3e508f44698ba00df77ef4a18 | |
| 50341 | 168246752229935000 | true | flynas | 50341 | 0xacf1a841 | 0xb22c1c159d12461ea124b0deb4b5b93020e6ad16 | 157784760 | 9057222 | 0x7739ffe6706bae8087f104ee388cd622e7dbba00 | 2019-12-05T22:19:34.000Z | 0x7f892e6b614d280c518aa17a82b6f4c6a481f15fe1bed983d5922b9407dc4dfa |
Example Query
Example Query
Query with partition filter
ETHRegistrarControllerV2_NameRegistered_event
ENS (Ethereum Name Service) domain registration events from the V2 controller contract, capturing name registrations with owner addresses, expiration dates, base costs, and premium fees. Used for analyzing ENS domain acquisition patterns, pricing dynamics, and namespace adoption on Ethereum mainnet.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_name | STRING | Name or label identifier for the entity being created, registered, or updated in the event. |
in_label | STRING | Label describing the type of operation or transaction. Common values include ‘mint’, ‘redeem’, and ‘buy’. |
in_owner | STRING | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
in_baseCost | STRING | Cost of purchasing or selling an options contract before fees. String-encoded integer representing the amount in smallest denomination of the payment token. |
in_premium | STRING | Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset. |
in_expires | STRING | Unix timestamp when the ENS domain name registration expires. String-encoded integer representing seconds since epoch. |
Sample Data
Sample Data
| address | in_name | removed | in_label | in_owner | log_index | in_expires | in_premium | in_baseCost | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x253553366da8546fc250f225fe3d25d0c782303b | mclean | false | 0xc1267eec9fc87b79e55d1e792e74003ee44647013953ac8cba595779f3275817 | 0x928153c752df49146eaadc7497658eb45108a155 | 243 | 1726103051 | 252393448197646687 | 3127304524663310 | 18123995 | 2023-09-13T01:04:11.000Z | 0x390d81d589f2903397bc6cb63689bc26981ff1a0198e74bd7add55f161198f4d |
| 0x253553366da8546fc250f225fe3d25d0c782303b | gui | false | 0xc76c9283fa1ad2e4a66b910869994e7461691f64a0f3abd5cd832250f31d2a5e | 0x8ec780c9dc4d7a2c47a4e1e107a92b5fbfb91b49 | 416 | 1726111427 | 36469714700252688 | 401143258286108800 | 18124686 | 2023-09-13T03:23:47.000Z | 0x5a1d1bce684d661b0574c8297a28033e29933b7aca33ad4488c6092475f9e3fe |
| 0x253553366da8546fc250f225fe3d25d0c782303b | wynwoodwalls | false | 0x2eecdc667da79c4dcdbb6fcc613a1896f8c8877451b4f6dd85ed35360fac9866 | 0xe323a9a5cc1d51d28a7c2e99cdbb4f7122dfbc2b | 176 | 1726112411 | 198539987980030 | 3133931705363776 | 18124766 | 2023-09-13T03:40:11.000Z | 0x0b42afd27d049cc0282125ecf9f00b16c991a63bc0757dc87d903b6a6630d28c |
Example Query
Example Query
Query with partition filter
ETHRegistrarControllerV2_NameRenewed_event
ENS (Ethereum Name Service) domain renewal events from the ETHRegistrarControllerV2 contract on Ethereum mainnet. Tracks when .eth names are extended with renewal costs in wei, new expiration timestamps, and label hashes for analyzing domain lifecycle and pricing trends.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_name | STRING | Name or label identifier for the entity being created, registered, or updated in the event. |
in_label | STRING | Label describing the type of operation or transaction. Common values include ‘mint’, ‘redeem’, and ‘buy’. |
in_cost | STRING | Amount paid in wei to renew the ENS name registration. Non-null numeric string representing the renewal fee in the smallest ETH denomination. |
in_expires | STRING | Unix timestamp when the ENS domain name registration expires. String-encoded integer representing seconds since epoch. |
Sample Data
Sample Data
| address | in_cost | in_name | removed | in_label | log_index | in_expires | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x253553366da8546fc250f225fe3d25d0c782303b | 193715260580032380 | gmct | false | 0xb9408efcaaebec70ea6aabf21aee0030a6387504154c24c79a5249623e42b563 | 61 | 1785325826 | 17268705 | 2023-05-16T00:24:35.000Z | 0x88ebd732b32b84c38cd52c80721ce03aa52fd15da275eae90986dd9efa9bb11b |
| 0x253553366da8546fc250f225fe3d25d0c782303b | 21999392858496636 | kens | false | 0xb9759599cd55acc27420954b77e7d6cddffdcb64560089fd68e7c90ba4b6fb17 | 98 | 1684555618 | 17271347 | 2023-05-16T09:21:23.000Z | 0x06546bd732a1a9b970eecaf831173786e7c238167b2259b6447df63ccf80c3b9 |
| 0x253553366da8546fc250f225fe3d25d0c782303b | 97225751566101589 | 7265 | false | 0x807af7c7c70135ab83390f24d6417a2d81e816d364ef32ae3fade5522cffc366 | 258 | 1725062214 | 17269679 | 2023-05-16T03:41:35.000Z | 0x2cfb86bc9494e2986e7bd827779722b5aa28fc4634fedbca625006bc32a5b95e |
Example Query
Example Query
Query with partition filter
ETHRegistrarControllerV2_renew_function
ENS (Ethereum Name Service) domain renewal transactions from the V2 registrar controller contract on Ethereum mainnet. Contains registration names, renewal durations in seconds, and ETH payment amounts for tracking domain ownership extensions and renewal costs.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
trace_address | STRING | Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
value | FLOAT64 | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
gas | INT64 | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
in_name | STRING | Name or label identifier for the entity being created, registered, or updated in the event. |
in_duration | STRING | Duration period for the operation or quest. Numeric string representation in seconds. |
Sample Data
Sample Data
| gas | value | status | in_name | gas_used | signature | to_address | in_duration | block_number | from_address | trace_address | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 252733 | 122281230581711 | true | biosecure | 42534 | 0xacf1a841 | 0x253553366da8546fc250f225fe3d25d0c782303b | 2629746 | 19604488 | 0x5d81ce189bf5267e70fb555916ffbc3d4c7b2245 | 1 | 2024-04-07T14:43:47.000Z | 0x5aa464e28a209b6ea799e01f7c5bad62a57f04bd8df655c031bbf2ad6acf7ac9 |
| 190018 | 122281230581711 | true | 80805 | 26322 | 0xacf1a841 | 0x253553366da8546fc250f225fe3d25d0c782303b | 2629746 | 19604488 | 0x5d81ce189bf5267e70fb555916ffbc3d4c7b2245 | 3 | 2024-04-07T14:43:47.000Z | 0x5aa464e28a209b6ea799e01f7c5bad62a57f04bd8df655c031bbf2ad6acf7ac9 |
| 143261 | 122281230581711 | true | 06950 | 26322 | 0xacf1a841 | 0x253553366da8546fc250f225fe3d25d0c782303b | 2629746 | 19604488 | 0x5d81ce189bf5267e70fb555916ffbc3d4c7b2245 | 5 | 2024-04-07T14:43:47.000Z | 0x5aa464e28a209b6ea799e01f7c5bad62a57f04bd8df655c031bbf2ad6acf7ac9 |
Example Query
Example Query
Query with partition filter