Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in_idSTRINGUnique identifier for the position, record, or entity within the protocol. Numeric string representation.
in_durationSTRINGDuration period for the operation or quest. Numeric string representation in seconds.
out_anon0STRINGActual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
gasin_idvaluestatusgas_usedout_anon0signatureto_addressin_durationblock_numberfrom_addresstrace_addressblock_timestamptransaction_hash
20430354283665415810833004751765004348349424420738500918818071642713318198182765610false1797416201073520xc475abff0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea853155695296779800x283af0b28c62c092c9727f1ee09c02ca627eb7f522020-03-15T19:24:00.000Z0x6cc137cd83df0eda4e29d13b3533ce7aa40fd376050685e5f5618a0e3a5b8ca6
204301086908690566705282377723643687880481067496400566116401719822337337388618609770false1797416201073520xc475abff0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea853155695296779850x283af0b28c62c092c9727f1ee09c02ca627eb7f522020-03-15T19:25:27.000Z0xfbcf563f733b8f964b81e627db717cf939007d238deb2f49ad06b329a12a1149
20430921863696866596475347142028752544781183523261366204829184487461158365319158720false1797416201073520xc475abff0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea853155695296779900x283af0b28c62c092c9727f1ee09c02ca627eb7f522020-03-15T19:25:46.000Z0xc8a4cfa6bffe7f6e070d9a018b88e7802156b39b382ef5837e5baa3bd113de83
Query with partition filter
SELECT *
FROM `tt-contracts.ens_v1_ethereum.BaseRegistrarImplementation_renew_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_nameSTRINGName or label identifier for the entity being created, registered, or updated in the event.
in_labelSTRINGLabel describing the type of operation or transaction. Common values include ‘mint’, ‘redeem’, and ‘buy’.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_costSTRINGRegistration cost paid in wei (smallest unit of ETH) for acquiring the ENS domain. Stored as string to preserve precision for large integer values.
in_expiresSTRINGUnix timestamp when the ENS domain name registration expires. String-encoded integer representing seconds since epoch.
addressin_costin_nameremovedin_labelin_ownerlog_indexin_expiresblock_numberblock_timestamptransaction_hash
0xf0ad5cad05e10572efceb849f6ff0c68f970045530998075788385340contractcertfalse0x9498c08802cf7e509333413f06f32e55b30c102581e1e19fe62eb5407cc614310x605ee5541b1a79e3461145b8ba2ca106f5fdd74766160343288787997922019-10-24T00:12:15.000Z0x2269d5eec4d63b05d678c0878712dd0205127df1a88fca0bbe9c30d3a2b27005
0xf0ad5cad05e10572efceb849f6ff0c68f970045530921924030863118salecertfalse0x3af8dce421e3284e486ad13a8684a4392cbad03d841c82eb9367496e60c03d280x605ee5541b1a79e3461145b8ba2ca106f5fdd74727160343598087999962019-10-24T01:03:48.000Z0xeba1e294f21ba44efec86bfcd3ea860a97a37e2ba1eff77a1b364078eff0a4b9
0xf0ad5cad05e10572efceb849f6ff0c68f970045530921924030863118rentcertfalse0xd0aba00ff5b65f46222c5b5b5ed82c5acfcdb2ca81e7d0d03eb1f90e8bc99a950x605ee5541b1a79e3461145b8ba2ca106f5fdd747135160343684388000702019-10-24T01:18:11.000Z0x768789fa6df3fbfe196dff368f3392c566297ecdc94111f857e646bf8d8ab93a
Query with partition filter
SELECT *
FROM `tt-contracts.ens_v1_ethereum.ETHRegistrarController_NameRegistered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_nameSTRINGName or label identifier for the entity being created, registered, or updated in the event.
in_labelSTRINGLabel describing the type of operation or transaction. Common values include ‘mint’, ‘redeem’, and ‘buy’.
in_costSTRINGCost 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_expiresSTRINGUnix timestamp when the ENS domain name registration expires. String-encoded integer representing seconds since epoch.
addressin_costin_nameremovedin_labellog_indexin_expiresblock_numberblock_timestamptransaction_hash
0x283af0b28c62c092c9727f1ee09c02ca627eb7f524497267517693923etherdeltafalse0x53da75fc5c2036760338ff2c47fc2e8b921c0a4f8362c001744380b12fd7b50e1151620107352101393232020-05-26T04:48:05.000Z0xc1036bac5a96914b26cf0c2ed70480acb9d242f7ad6b060d0e7102046c9ad427
0x283af0b28c62c092c9727f1ee09c02ca627eb7f524497267517693923rewardcardsfalse0x9a610bf0e64712af7464e9a90661d7855d9ee5fe8010a1053ad7878c724263f01271620107352101393232020-05-26T04:48:05.000Z0xc1036bac5a96914b26cf0c2ed70480acb9d242f7ad6b060d0e7102046c9ad427
0x283af0b28c62c092c9727f1ee09c02ca627eb7f524497267517693923paymentprotocolfalse0xcf744f441bae49631dc0fff71821d931bffe2638e7157ffebd8ba87906b571de1351620107352101393232020-05-26T04:48:05.000Z0xc1036bac5a96914b26cf0c2ed70480acb9d242f7ad6b060d0e7102046c9ad427
Query with partition filter
SELECT *
FROM `tt-contracts.ens_v1_ethereum.ETHRegistrarController_NameRenewed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in_nameSTRINGName or label identifier for the entity being created, registered, or updated in the event.
in_durationSTRINGDuration period for the operation or quest. Numeric string representation in seconds.
gasvaluestatusin_namegas_usedsignatureto_addressin_durationblock_numberfrom_addresstrace_addressblock_timestamptransaction_hash
50593168286364999959870trueatptour505930xacf1a8410xb22c1c159d12461ea124b0deb4b5b93020e6ad1615778476090574690x7739ffe6706bae8087f104ee388cd622e7dbba002019-12-05T23:22:34.000Z0xa83194716e402ca7e13c67ef93cc8512e3bb0f4fc8e0b0f48b325f478439d8c1
50845168246752229935000trueflylevel508450xacf1a8410xb22c1c159d12461ea124b0deb4b5b93020e6ad1615778476090572310x7739ffe6706bae8087f104ee388cd622e7dbba002019-12-05T22:22:25.000Z0x9d70d97ca938c4a57e617bbe5fb2e59d7e6ca6e3e508f44698ba00df77ef4a18
50341168246752229935000trueflynas503410xacf1a8410xb22c1c159d12461ea124b0deb4b5b93020e6ad1615778476090572220x7739ffe6706bae8087f104ee388cd622e7dbba002019-12-05T22:19:34.000Z0x7f892e6b614d280c518aa17a82b6f4c6a481f15fe1bed983d5922b9407dc4dfa
Query with partition filter
SELECT *
FROM `tt-contracts.ens_v1_ethereum.ETHRegistrarController_renew_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_nameSTRINGName or label identifier for the entity being created, registered, or updated in the event.
in_labelSTRINGLabel describing the type of operation or transaction. Common values include ‘mint’, ‘redeem’, and ‘buy’.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_baseCostSTRINGCost of purchasing or selling an options contract before fees. String-encoded integer representing the amount in smallest denomination of the payment token.
in_premiumSTRINGFee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
in_expiresSTRINGUnix timestamp when the ENS domain name registration expires. String-encoded integer representing seconds since epoch.
addressin_nameremovedin_labelin_ownerlog_indexin_expiresin_premiumin_baseCostblock_numberblock_timestamptransaction_hash
0x253553366da8546fc250f225fe3d25d0c782303bmcleanfalse0xc1267eec9fc87b79e55d1e792e74003ee44647013953ac8cba595779f32758170x928153c752df49146eaadc7497658eb45108a15524317261030512523934481976466873127304524663310181239952023-09-13T01:04:11.000Z0x390d81d589f2903397bc6cb63689bc26981ff1a0198e74bd7add55f161198f4d
0x253553366da8546fc250f225fe3d25d0c782303bguifalse0xc76c9283fa1ad2e4a66b910869994e7461691f64a0f3abd5cd832250f31d2a5e0x8ec780c9dc4d7a2c47a4e1e107a92b5fbfb91b49416172611142736469714700252688401143258286108800181246862023-09-13T03:23:47.000Z0x5a1d1bce684d661b0574c8297a28033e29933b7aca33ad4488c6092475f9e3fe
0x253553366da8546fc250f225fe3d25d0c782303bwynwoodwallsfalse0x2eecdc667da79c4dcdbb6fcc613a1896f8c8877451b4f6dd85ed35360fac98660xe323a9a5cc1d51d28a7c2e99cdbb4f7122dfbc2b17617261124111985399879800303133931705363776181247662023-09-13T03:40:11.000Z0x0b42afd27d049cc0282125ecf9f00b16c991a63bc0757dc87d903b6a6630d28c
Query with partition filter
SELECT *
FROM `tt-contracts.ens_v1_ethereum.ETHRegistrarControllerV2_NameRegistered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_nameSTRINGName or label identifier for the entity being created, registered, or updated in the event.
in_labelSTRINGLabel describing the type of operation or transaction. Common values include ‘mint’, ‘redeem’, and ‘buy’.
in_costSTRINGAmount paid in wei to renew the ENS name registration. Non-null numeric string representing the renewal fee in the smallest ETH denomination.
in_expiresSTRINGUnix timestamp when the ENS domain name registration expires. String-encoded integer representing seconds since epoch.
addressin_costin_nameremovedin_labellog_indexin_expiresblock_numberblock_timestamptransaction_hash
0x253553366da8546fc250f225fe3d25d0c782303b193715260580032380gmctfalse0xb9408efcaaebec70ea6aabf21aee0030a6387504154c24c79a5249623e42b563611785325826172687052023-05-16T00:24:35.000Z0x88ebd732b32b84c38cd52c80721ce03aa52fd15da275eae90986dd9efa9bb11b
0x253553366da8546fc250f225fe3d25d0c782303b21999392858496636kensfalse0xb9759599cd55acc27420954b77e7d6cddffdcb64560089fd68e7c90ba4b6fb17981684555618172713472023-05-16T09:21:23.000Z0x06546bd732a1a9b970eecaf831173786e7c238167b2259b6447df63ccf80c3b9
0x253553366da8546fc250f225fe3d25d0c782303b972257515661015897265false0x807af7c7c70135ab83390f24d6417a2d81e816d364ef32ae3fade5522cffc3662581725062214172696792023-05-16T03:41:35.000Z0x2cfb86bc9494e2986e7bd827779722b5aa28fc4634fedbca625006bc32a5b95e
Query with partition filter
SELECT *
FROM `tt-contracts.ens_v1_ethereum.ETHRegistrarControllerV2_NameRenewed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in_nameSTRINGName or label identifier for the entity being created, registered, or updated in the event.
in_durationSTRINGDuration period for the operation or quest. Numeric string representation in seconds.
gasvaluestatusin_namegas_usedsignatureto_addressin_durationblock_numberfrom_addresstrace_addressblock_timestamptransaction_hash
252733122281230581711truebiosecure425340xacf1a8410x253553366da8546fc250f225fe3d25d0c782303b2629746196044880x5d81ce189bf5267e70fb555916ffbc3d4c7b224512024-04-07T14:43:47.000Z0x5aa464e28a209b6ea799e01f7c5bad62a57f04bd8df655c031bbf2ad6acf7ac9
190018122281230581711true80805263220xacf1a8410x253553366da8546fc250f225fe3d25d0c782303b2629746196044880x5d81ce189bf5267e70fb555916ffbc3d4c7b224532024-04-07T14:43:47.000Z0x5aa464e28a209b6ea799e01f7c5bad62a57f04bd8df655c031bbf2ad6acf7ac9
143261122281230581711true06950263220xacf1a8410x253553366da8546fc250f225fe3d25d0c782303b2629746196044880x5d81ce189bf5267e70fb555916ffbc3d4c7b224552024-04-07T14:43:47.000Z0x5aa464e28a209b6ea799e01f7c5bad62a57f04bd8df655c031bbf2ad6acf7ac9
Query with partition filter
SELECT *
FROM `tt-contracts.ens_v1_ethereum.ETHRegistrarControllerV2_renew_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100