Skip to main content

​
Tables

​
Router_LendBorrowTrade_event

Lending and borrowing trade events from Notional V2 fixed-rate protocol on Ethereum, capturing fCash (fixed cash flows) and asset cash positions with maturity dates and currency identifiers. Enables analysis of fixed-rate DeFi lending activity, position changes, and interest rate term structure across different currencies.
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_accountSTRINGAccount address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_currencyIdSTRINGCurrency identifier within the Notional V2 protocol that specifies which asset type is being traded (e.g., 1 for ETH, 2 for DAI, 3 for USDC). This numeric ID maps to specific tokens supported by Notional’s fixed-rate lending markets.
in_maturitySTRINGUnix timestamp representing the maturity date of the fCash position being traded. Values like 1648512000 correspond to specific future settlement dates when the fixed-rate position expires.
in_netAssetCashSTRINGNet change in asset cash balance for the account in the underlying currency denomination, expressed in the currency’s smallest unit. Negative values indicate cash outflows (borrowing or collateral deposits), while positive values indicate inflows (lending repayments or withdrawals).
in_netfCashSTRINGNet change in fCash (fixed cash) tokens for this trade, denominated in the asset’s internal precision. Negative values indicate borrowing or selling fCash, positive values indicate lending or buying fCash.
addressremovedlog_indexin_accountin_maturityin_netfCashblock_numberin_currencyIdblock_timestampin_netAssetCashtransaction_hash
0x1344a36a1b56144c3bc62e7757377d288fde0369false1460xf54d8716e4766e7dd0e2279d9bdeb5c503025a8a1648512000100441421359459912021-11-11T11:17:23.000Z-4976530250xf90770e584eaca792616f2ef5b8f6442b7fffeae0f36766d544c9330f397832d
0x1344a36a1b56144c3bc62e7757377d288fde0369false5480xb4224b2eacc3345102ff0788806e68955efc89c51648512000-103427897900001359457722021-11-11T11:11:56.000Z4606899820110930xc14139ac7fd2e29bdd7256d3e5b0396715f9d79486f4421246ef50e013185c7f
0x1344a36a1b56144c3bc62e7757377d288fde0369false1240x515491350701b46a54c666d18822fd7e3c44ebd81648512000-1171933294300001359623822021-11-11T17:24:36.000Z52056616484924610x25768510557a17ac25fa9cf0c6aa57877f8f5cec80a4c9e1dc21a26216451f49
Query with partition filter
SELECT *
FROM `tt-contracts.notional_v2_ethereum.Router_LendBorrowTrade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
Router_nTokenSupplyChange_event

nToken supply change events from Notional V2 fixed-rate lending protocol on Ethereum. Tracks minting and redemption of interest-bearing nTokens by account and currency, useful for analyzing liquidity provider positions and protocol TVL changes.
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_accountSTRINGAccount address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_currencyIdSTRINGNumeric identifier for the currency on Notional V2 protocol. Maps to specific assets like DAI (1) or USDC (2) within the protocol’s currency system.
in_tokenSupplyChangeSTRINGChange in nToken supply for the account, denominated in the smallest unit of the nToken. Negative values indicate a decrease in supply (redemption), while positive values indicate an increase (minting).
addressremovedlog_indexin_accountblock_numberin_currencyIdblock_timestamptransaction_hashin_tokenSupplyChange
0x1344a36a1b56144c3bc62e7757377d288fde0369false2870x3f7b7e4d86f3cd69153ed062731eb99d0330a7b81366703312021-11-22T21:58:21.000Z0x907d1c87e3fc3e68a580563ba7eeb8e9af8298717378285b0774a59548e92258-74778915857
0x1344a36a1b56144c3bc62e7757377d288fde0369false2290x60b24364e9c5b5c25d3b53050a8865ef4d963ba21366518612021-11-22T15:08:28.000Z0xa3813d0206222c0c6f7d36213467b2a19a6929f732ee057771ddf939a22eb544-4986143398
0x1344a36a1b56144c3bc62e7757377d288fde0369false800x07a2e516993972ecd674058e173f02694617e2331366401012021-11-22T10:40:00.000Z0xc5a3e3f5dea6d333d2d0bdad897afb5c078ed997a7587521897f90f5198e59bc2492633552184
Query with partition filter
SELECT *
FROM `tt-contracts.notional_v2_ethereum.Router_nTokenSupplyChange_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
Router_ReserveFeeAccrued_event

Reserve fee accrual events from Notional V2 protocol on Ethereum, tracking protocol fees collected by currency ID. Used for analyzing protocol revenue generation and fee distribution across different assets.
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_currencyIdSTRINGIdentifier for the currency in which the reserve fee was accrued within the Notional protocol. Numeric string values (1, 2, 3) correspond to specific tokens configured in the Notional system.
in_feeSTRINGFee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
in_feeaddressremovedlog_indexblock_numberin_currencyIdblock_timestamptransaction_hash
134964658491070x1344a36a1b56144c3bc62e7757377d288fde0369false71462140122022-04-20T10:38:45.000Z0xbdda17b1c103625a0e411cf0cb78c54267b386f05d1a9a7543a203145dce424f
141994270866370x1344a36a1b56144c3bc62e7757377d288fde0369false61462140122022-04-20T10:38:45.000Z0xbdda17b1c103625a0e411cf0cb78c54267b386f05d1a9a7543a203145dce424f
45657511654160x1344a36a1b56144c3bc62e7757377d288fde0369false81462140122022-04-20T10:38:45.000Z0xbdda17b1c103625a0e411cf0cb78c54267b386f05d1a9a7543a203145dce424f
Query with partition filter
SELECT *
FROM `tt-contracts.notional_v2_ethereum.Router_ReserveFeeAccrued_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100