nexusmutual_v1_ethereum

Tables

Cover_buyCover_function

Insurance policy purchase transactions from Nexus Mutual on Ethereum. Contains cover parameters including product ID, coverage amount, duration, premium pricing, and pool allocations for analyzing protection demand across DeFi protocols.

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_params`	`STRUCT<coverId STRING, owner STRING, productId STRING, coverAsset INT64, amount STRING, period STRING, maxPremiumInAsset STRING, paymentAsset INT64, commissionRatio STRING, commissionDestination STRING, ipfsData STRING>`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
`in_poolAllocationRequests`	`ARRAY<STRUCT<poolId STRING, skip BOOL, coverAmountInAsset STRING>>`	Input parameters specifying how the purchased cover amount should be allocated across different Nexus Mutual staking pools. Each request contains a pool ID, cover amount in the asset denomination, and a skip flag indicating whether to use that pool allocation.
`out_coverId`	`STRING`	Unique identifier assigned to the newly purchased cover by Nexus Mutual. Returns as a string representation of an integer that increments sequentially with each cover purchase.

Sample Data

gas	value	status	gas_used	in_params	signature	to_address	out_coverId	block_number	from_address	block_timestamp	transaction_hash	in_poolAllocationRequests
767447	0	true	751041	{“owner”:“0x4fdb601aebf2c6ad947d97a00b7eeaf71cc5bf93”,“amount”:“150000000000000000000000”,“period”:“15552000”,“coverId”:“0”,“ipfsData”:"",“productId”:“15”,“coverAsset”:1,“paymentAsset”:255,“commissionRatio”:“1765”,“maxPremiumInAsset”:“157109998931506849314”,“commissionDestination”:“0x586b9b2f8010b284a0197f392156f1a7eb5e86e9”}	0xf6579632	0xcafeac0ff5da0a2777d915531bfa6b29d282ee62	11	16850250	0x4fdb601aebf2c6ad947d97a00b7eeaf71cc5bf93	2023-03-17T21:38:47.000Z	0x843ff41033365d74b17d519d2935622ece5e5e032aec06c660149888133b0cc4	[{“skip”:false,“poolId”:“2”,“coverAmountInAsset”:“150000000000000000000000”}]
755127	0	true	738913	{“owner”:“0x383f42b5de515c564641f65f5da3bd8b4a35b4b4”,“amount”:“500000000000000000000”,“period”:“3456000”,“coverId”:“0”,“ipfsData”:"",“productId”:“36”,“coverAsset”:0,“paymentAsset”:255,“commissionRatio”:“1765”,“maxPremiumInAsset”:“134912233479452054793”,“commissionDestination”:“0x586b9b2f8010b284a0197f392156f1a7eb5e86e9”}	0xf6579632	0xcafeac0ff5da0a2777d915531bfa6b29d282ee62	10	16850244	0x383f42b5de515c564641f65f5da3bd8b4a35b4b4	2023-03-17T21:37:35.000Z	0x1251f0dd862a1b2c27aba33a89e8ea2aa435699a57927903e47d5926fdb62a39	[{“skip”:false,“poolId”:“1”,“coverAmountInAsset”:“500000000000000000000”}]
1090679	540171097397865500	true	710658	{“owner”:“0xfa6ff2ad3fed19a19310f928268e78c1aa349bda”,“amount”:“50000000000000000000”,“period”:“3801600”,“coverId”:“0”,“ipfsData”:"",“productId”:“135”,“coverAsset”:0,“paymentAsset”:0,“commissionRatio”:“1500”,“maxPremiumInAsset”:“540171097397865455”,“commissionDestination”:“0x586b9b2f8010b284a0197f392156f1a7eb5e86e9”}	0xf6579632	0xcafeac0ff5da0a2777d915531bfa6b29d282ee62	544	19451959	0xfa6ff2ad3fed19a19310f928268e78c1aa349bda	2024-03-17T03:40:59.000Z	0x281d5879da0e20ad2a3b7b0e3f3b4e324955ff108b0bd8e31e977913eff9b94b	[{“skip”:false,“poolId”:“2”,“coverAmountInAsset”:“50000197797569697601”}]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.nexusmutual_v1_ethereum.Cover_buyCover_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Cover_CoverEdited_event

Cover policy modification events from Nexus Mutual protocol on Ethereum. Tracks edits to existing insurance covers with cover ID, product ID, buyer address, and optional IPFS metadata for analyzing policy changes and coverage adjustments.

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_coverId`	`STRING`	Unique identifier for the Nexus Mutual insurance cover policy being edited. Numeric string value that references a specific cover instance in the protocol.
`in_productId`	`STRING`	Identifier for the financial product or trading pair involved in the transaction. Numeric string representation of the product ID in the protocol’s internal indexing system.
`in_segmentId`	`STRING`	Identifier for the coverage segment or tier within a Nexus Mutual insurance product. Typically ‘0’ for standard coverage, may vary for products with multiple risk segments or coverage levels.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_ipfsMetadata`	`STRING`	IPFS content identifier hash pointing to off-chain metadata about the cover policy. Typically empty in most cover edit events, as metadata updates are optional.

Sample Data

address	removed	in_buyer	log_index	in_coverId	block_number	in_productId	block_timestamp	transaction_hash
0xcafeac0ff5da0a2777d915531bfa6b29d282ee62	false	0x4fdb601aebf2c6ad947d97a00b7eeaf71cc5bf93	175	11	16850250	15	2023-03-17T21:38:47.000Z	0x843ff41033365d74b17d519d2935622ece5e5e032aec06c660149888133b0cc4
0xcafeac0ff5da0a2777d915531bfa6b29d282ee62	false	0xcafeac41b010299a9bec5308cce6afc2c4df8d39	224	9	16848920	33	2023-03-17T17:10:11.000Z	0x0847b769760163a95cb50447a4868aa3e147651954fb2912e8b9f82be624b2b6
0xcafeac0ff5da0a2777d915531bfa6b29d282ee62	false	0xcafeac41b010299a9bec5308cce6afc2c4df8d39	21	8	16848482	33	2023-03-17T15:41:35.000Z	0xe2aff02e2c9a8edbda10de21f564ecc4e56a0b7820314425f6a1b48407aeb553

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.nexusmutual_v1_ethereum.Cover_CoverEdited_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

QuotationData_CoverDetailsEvent_event

Insurance cover policy details from Nexus Mutual on Ethereum, capturing premiums in ETH and NXM tokens, coverage amounts, expiry timestamps, and protected smart contract addresses. Used for analyzing coverage trends, pricing dynamics, and protocol risk exposure across DeFi protocols.

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_cid`	`STRING`	Cover ID assigned by Nexus Mutual’s quotation system, uniquely identifying each insurance policy. Sequential numeric identifier stored as string, increments with each new cover purchase.
`in_scAdd`	`STRING`	Smart contract address being covered by this Nexus Mutual insurance policy. Hex-encoded, 0x-prefixed 40-character Ethereum address representing the protocol or contract protected.
`in_sumAssured`	`STRING`	Sum assured amount of the cover policy denominated in the currency specified by in_curr. Represents the maximum payout amount the policy holder can claim if a valid claim is approved.
`in_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
`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_premiumNXM`	`STRING`	Premium amount paid in NXM tokens for this Nexus Mutual cover. Value is denominated in wei units (10^-18 NXM).
`in_curr`	`STRING`	Currency code for the cover premium payment. Hex-encoded identifier (e.g., 0x45544800 for ETH, 0x44414900 for DAI) indicating which token was used to pay the insurance premium.

Sample Data

in_cid	address	in_curr	removed	in_scAdd	in_expiry	log_index	in_premium	block_number	in_premiumNXM	in_sumAssured	block_timestamp	transaction_hash
3839	0x1776651f58a17a50098d31ba3c3cd259c1903f7a	0x45544800	false	0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c	1626686068	332	355920602327173169	12211268	9299506394226154702	50	2021-04-10T09:14:28.000Z	0xf8c4718f928c544f57c6f7a1afd87fd7f11066759313b452299edce9e5438b08
3843	0x1776651f58a17a50098d31ba3c3cd259c1903f7a	0x45544800	false	0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f	1620660249	232	427104722792607802	12212933	11159407673071385643	200	2021-04-10T15:24:09.000Z	0x996dbaaeb1b275680c557a6c824d64b00693341e882075be4fa322958d72fb89
3837	0x1776651f58a17a50098d31ba3c3cd259c1903f7a	0x45544800	false	0x67b66c99d3eb37fa76aa3ed1ff33e8e39f0b9c7a	1620625046	285	89691991786447638	12210298	2344161388454781121	42	2021-04-10T05:37:26.000Z	0xcb6f94830826758b2327cb22aa45bc7c71e8dfad7862fe0478f404d0fcbf77a7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.nexusmutual_v1_ethereum.QuotationData_CoverDetailsEvent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

Cover_buyCover_function

Cover_CoverEdited_event

QuotationData_CoverDetailsEvent_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Cover_buyCover_function

​Cover_CoverEdited_event

​QuotationData_CoverDetailsEvent_event

Tables

Cover_buyCover_function

Cover_CoverEdited_event

QuotationData_CoverDetailsEvent_event