makerdao_v1_ethereum - Token Terminal Docs

Tables

Cat_Bite_event

MakerDAO vault liquidation events triggered when collateral positions become undercollateralized, recording collateral type (ilk), vault address (urn), seized collateral amount (ink), debt amount (art), and associated auction contract (flip). Used to analyze liquidation patterns, collateral risk, and vault health across different asset types like ETH-A, BAT-A, and KNC-A.

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_ilk`	`STRING`	Collateral type identifier in the MakerDAO system. 66-character hex string including 0x prefix.
`in_urn`	`STRING`	Ethereum address of the vault (CDP) being liquidated in MakerDAO. Hex-encoded, 0x-prefixed 40-character string representing the undercollateralized position subject to the liquidation bite.
`in_ink`	`STRING`	Amount of collateral (ink) seized from the under-collateralized vault during liquidation. Denominated in the collateral token’s smallest unit (e.g., wei for ETH).
`in_art`	`STRING`	Amount of DAI debt in the vault at the time of liquidation, denominated in smallest units (wei). Represents the normalized debt (art) multiplied by the debt accumulator for the collateral type.
`in_tab`	`STRING`	Total debt amount (including accumulated stability fees) seized from the undercollateralized vault at the time of liquidation, denominated in DAI with 45 decimal precision. This value represents the debt being auctioned off in the corresponding flip auction.
`in_flip`	`STRING`	Contract address of the collateral auction (flip) contract where the liquidated collateral will be sold. This is the specific Flipper contract instance assigned to handle the auction for the collateral type being liquidated.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.

Sample Data

in_id	in_art	in_ilk	in_ink	in_tab	in_urn	address	in_flip	removed	log_index	block_number	block_timestamp	transaction_hash
2	98035190121839934541	0x4554482d41000000000000000000000000000000000000000000000000000000	313800000000000000	100000000000000000000362863123855638974932318394	0x539a327f34d826fd22b2f62c552538340acefe57	0xa5679c04fc3d9d8b0aab1f0ab83555b301ca70ea	0xf32836b9e1f47a0515c6ec431592d5ebc276407f	false	351	10780611	2020-09-02T08:03:30.000Z	0xb5afecd822d6f27464cc31b9775fb948629a433b01dc45ec6e7d4e883e291be3
4	39385059050465286935467	0x4554482d41000000000000000000000000000000000000000000000000000000	128149858188440510103	40174409823163307282655000114637783040153934733878	0x62a2851197a313901990d277e32cedec0905ecf5	0xa5679c04fc3d9d8b0aab1f0ab83555b301ca70ea	0xf32836b9e1f47a0515c6ec431592d5ebc276407f	false	141	10780886	2020-09-02T09:03:50.000Z	0x45b0a9e3717a74d2babe071cd6229a4242018ed7db29f7e7db2ab1be53e8c03e
3	43378402708778732097630	0x4554482d41000000000000000000000000000000000000000000000000000000	141143273352674739344	44247787610619469026548462037559510584438025239420	0x62a2851197a313901990d277e32cedec0905ecf5	0xa5679c04fc3d9d8b0aab1f0ab83555b301ca70ea	0xf32836b9e1f47a0515c6ec431592d5ebc276407f	false	233	10780881	2020-09-02T09:02:48.000Z	0x33e21c9ec0548c2c2adda36087f01a59af556c2fcdc28f7229b11a2cb9a1a0d9

Example Query

Query with partition filter

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

CatV0_Bite_event

Liquidation events from MakerDAO’s Cat contract (liquidator) on Ethereum, recording undercollateralized Vault (CDP) liquidations with collateral type (ilk), seized collateral amount (ink), debt amount (art), and assigned auction contract (flip). Used for analyzing liquidation cascades, collateral recovery rates, and protocol risk events.

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_ilk`	`STRING`	Collateral type identifier in the MakerDAO system. 66-character hex string including 0x prefix.
`in_urn`	`STRING`	Ethereum address of the Collateralized Debt Position (CDP) vault being liquidated in this bite event. Represents the user’s vault contract that held collateral and generated DAI debt.
`in_ink`	`STRING`	Collateral amount locked in the vault (urn) at the time of liquidation. Denominated in the smallest unit of the collateral token (wei for ETH), represented as a string to preserve precision.
`in_art`	`STRING`	Amount of DAI debt (in WAD format) associated with the vault (CDP) being liquidated. Represents the outstanding debt denominated in DAI at the time of liquidation.
`in_tab`	`STRING`	Total debt obligation of the liquidated vault including stability fee accrual, denominated in DAI with 45 decimal precision. This is the amount that must be recovered through the collateral auction initiated by the bite event.
`in_flip`	`STRING`	Contract address of the auction contract (Flipper) created to liquidate the collateral from this undercollateralized vault. This address receives the seized collateral and conducts the auction process for the specific collateral type.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.

Sample Data

in_id	in_art	in_ilk	in_ink	in_tab	in_urn	address	in_flip	removed	log_index	block_number	block_timestamp	transaction_hash
8	2103827996432927037709	0x4554482d41000000000000000000000000000000000000000000000000000000	17950000000000000000	2105075914149005890324697730534223343599919375257	0x266f0dc4b0553e1c9dad74039fb0915042987249	0x78f2c2af65126834c51822f56be0d7469d7a523e	0xd8a04f5412223f513dc55f839574430f5ec15531	false	53	8961430	2019-11-19T08:33:30.000Z	0x651fb08b75efe17ce7fe624418262b4e7180947c1802ede8dcf610cfe0585eb8
11	59241836840664278028	0x4554482d41000000000000000000000000000000000000000000000000000000	510000000000000000	59280050059560444663518535162320761895566109292	0x601279f2b9a9c153b72739ac40ce7f66d9337690	0x78f2c2af65126834c51822f56be0d7469d7a523e	0xd8a04f5412223f513dc55f839574430f5ec15531	false	6	8964295	2019-11-19T20:08:50.000Z	0x38b3f1a30365e02bc7ad67926336494e58f1ff17008d1e71a209ee1a226015f1
7	665728988537926618085	0x4554482d41000000000000000000000000000000000000000000000000000000	5680000000000000000	666118783423484254917584340012994360879717243880	0x6fdea88724c2d4de7e383d10a4bf5fd09910e86a	0x78f2c2af65126834c51822f56be0d7469d7a523e	0xd8a04f5412223f513dc55f839574430f5ec15531	false	141	8961005	2019-11-19T06:50:22.000Z	0xed7798a19cb30805b2078387c89ca7d3c4f24783185a3b5053bb710657258b2f

Example Query

Query with partition filter

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

ChainLog_UpdateAddress_event

MakerDAO ChainLog contract address update events tracking changes to protocol component registry on Ethereum. Records hex-encoded key identifiers mapping to contract addresses for analyzing system upgrades and governance-approved integrations.

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_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_addr`	`STRING`	Contract address referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_key	address	in_addr	removed	log_index	block_number	block_timestamp	transaction_hash
0x5049505f41415645000000000000000000000000000000000000000000000000	0xda0ab1e0017debcd72be8599041a2aa3ba7e740f	0x8df8f06dc2de0434db40dcbb32a82a104218754c	false	237	11497506	2020-12-21T15:10:19.000Z	0x8186a5ef42282848d31ef0cac1521a86ed2fd6aa36235db5c229b03018ae1d26
0x5049505f554e4956324441494554480000000000000000000000000000000000	0xda0ab1e0017debcd72be8599041a2aa3ba7e740f	0x87ecbd742ceb40928e6cde77b2f0b5cfa3342a09	false	267	11497506	2020-12-21T15:10:19.000Z	0x8186a5ef42282848d31ef0cac1521a86ed2fd6aa36235db5c229b03018ae1d26
0x4d43445f4a4f494e5f414156455f410000000000000000000000000000000000	0xda0ab1e0017debcd72be8599041a2aa3ba7e740f	0x24e459f61ceaa7b1ce70dbaea938940a7c5ad46e	false	235	11497506	2020-12-21T15:10:19.000Z	0x8186a5ef42282848d31ef0cac1521a86ed2fd6aa36235db5c229b03018ae1d26

Example Query

Query with partition filter

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

D3MHub_Fees_event

Fee collection events from MakerDAO’s D3M (Direct Deposit DAI Module) Hub contract on Ethereum. Tracks accumulated fee amounts across different D3M integrations (Spark, Morpho) identified by ilk (collateral type) for monitoring protocol revenue.

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_ilk`	`STRING`	Collateral type identifier in the MakerDAO system. 66-character hex string including 0x prefix.
`in_amt`	`STRING`	Fee amount collected from the D3M (Direct Deposit DAI Module) vault in DAI wei units. Values are large integers representing 18-decimal precision DAI amounts extracted as protocol fees.

Sample Data

in_amt	in_ilk	address	removed	log_index	block_number	block_timestamp	transaction_hash
45031369504110945971073	0x4449524543542d535041524b2d44414900000000000000000000000000000000	0x12f36cdea3a28c35ac8c6cc71d9265c17c74a27f	false	69	18698537	2023-12-02T11:51:35.000Z	0x37b7e6ac647c362b06e7f436ad705efb18091f1ab9cdcc52f0705a60258e4b1c
12129262724975304853332	0x4449524543542d535041524b2d44414900000000000000000000000000000000	0x12f36cdea3a28c35ac8c6cc71d9265c17c74a27f	false	280	18699932	2023-12-02T16:32:11.000Z	0x1d3ad56ca20daf37d589ad816eb1ecd6e2f0cfb374ac03663a53910786373512
369877954564768967353844	0x4449524543542d535041524b2d4d4f5250484f2d444149000000000000000000	0x12f36cdea3a28c35ac8c6cc71d9265c17c74a27f	false	264	19789850	2024-05-03T13:21:23.000Z	0x70cdad7ef6f7364e3af909521e61d4d40210c5783afe801364d2733f53c6c8b3

Example Query

Query with partition filter

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

D3MHub_Wind_event

MakerDAO D3M (Direct Deposit DAI Module) Hub wind-up events tracking DAI withdrawals from external protocols like Spark and Morpho. Records debt ceiling reduction operations with collateral type identifiers and withdrawal amounts for monitoring D3M liquidity management.

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_ilk`	`STRING`	Collateral type identifier in the MakerDAO system. 66-character hex string including 0x prefix.
`in_amt`	`STRING`	Amount of DAI debt being wound down from the D3M (Direct Deposit DAI Module) position, denominated in wei (18 decimal places). Values typically range from 10-50 quintillion wei, representing millions of DAI being unwound from MakerDAO’s direct lending modules.

Sample Data

in_amt	in_ilk	address	removed	log_index	block_number	block_timestamp	transaction_hash
39081095198762420719051362	0x4449524543542d535041524b2d44414900000000000000000000000000000000	0x12f36cdea3a28c35ac8c6cc71d9265c17c74a27f	false	133	21318608	2024-12-03T01:10:35.000Z	0x39979ee974a9018f5cd3c0b61aae75f719e1b26429cdcb572b512f39b8ec37e5
39984557845947943819854021	0x4449524543542d535041524b2d44414900000000000000000000000000000000	0x12f36cdea3a28c35ac8c6cc71d9265c17c74a27f	false	79	21318904	2024-12-03T02:10:11.000Z	0x73770986943ac78dd66e421214d8e4062d7d4427d03572ad6463c142b157205c
18292074876830281873554591	0x4449524543542d535041524b2d44414900000000000000000000000000000000	0x12f36cdea3a28c35ac8c6cc71d9265c17c74a27f	false	115	18484195	2023-11-02T11:47:35.000Z	0xc44d3335d80eb19c0b5e43f7e292b95acf528cd312aaede1c67178deb6085e38

Example Query

Query with partition filter

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

Dai_burn_function

DAI stablecoin burn events from MakerDAO v1 protocol on Ethereum, recording destruction of DAI tokens with amount (wad) and account (usr) details. Used for tracking DAI supply changes and debt repayment activity in the MakerDAO system.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

gas	in_usr	in_wad	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
1295836	0x1eb4cf3a948e7d72a198fe073ccb8c7a948cd853	1057699750358252262211922	true	3546	0x9dc29fac	0x6b175474e89094c44da98b954eedeac495271d0f	13610393	0x9759a6ac90977b93b58547b4a71c78317f391a28	10,0,12,5,7,4,1	2021-11-13T22:49:16.000Z	0x7cd6ef473a960e3ec0fe01ce8e6d2036c3816de48fda0450cd253c5de3ca5a2e
1683423	0x2a49eae5cca3f050ebec729cf90cc910fadaf7a2	644107315697450875101869	true	4503	0x9dc29fac	0x6b175474e89094c44da98b954eedeac495271d0f	13605737	0x9759a6ac90977b93b58547b4a71c78317f391a28	0,2,2,6,1	2021-11-13T05:05:32.000Z	0xcf06ee9953e1ab41e5d7b794605ba7adb77d78e9be7ea0540dab31a31b50a17f
832534	0x2a49eae5cca3f050ebec729cf90cc910fadaf7a2	316916064020537892899	true	4503	0x9dc29fac	0x6b175474e89094c44da98b954eedeac495271d0f	13609148	0x9759a6ac90977b93b58547b4a71c78317f391a28	0,2,2,6,1	2021-11-13T18:04:21.000Z	0x493b3c5c4e296e18c04c96276bf7a766608597aa5cb0229126cf22b4e9019f4f

Example Query

Query with partition filter

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

Dai_mint_function

DAI stablecoin minting events from MakerDAO v1 protocol on Ethereum, capturing mint function calls with recipient addresses and amounts in wei. Used for analyzing DAI supply creation and vault liquidation flows.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

gas	in_usr	in_wad	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
380655	0x2a49eae5cca3f050ebec729cf90cc910fadaf7a2	26086436727074277679768	true	3145	0x40c10f19	0x6b175474e89094c44da98b954eedeac495271d0f	17304632	0x9759a6ac90977b93b58547b4a71c78317f391a28	0,2,3,16,1	2023-05-21T01:57:23.000Z	0xb080483f4f522b4d69386a4ab7ec8401510ddab4a7b3ddfa03f60f5da51826eb
367993	0x1136b25047e142fa3018184793aec68fbb173ce4	1125000000000000000000000	true	5945	0x40c10f19	0x6b175474e89094c44da98b954eedeac495271d0f	17304586	0x9759a6ac90977b93b58547b4a71c78317f391a28	0,3,1,1,0,1,1,3,1	2023-05-21T01:48:11.000Z	0x69e6c751eff1a8030e342f9da7b944d3984c2aa41dadf709a93432a9a6d782e3
325080	0x1136b25047e142fa3018184793aec68fbb173ce4	143546216446000000000000	true	9945	0x40c10f19	0x6b175474e89094c44da98b954eedeac495271d0f	17307492	0x9759a6ac90977b93b58547b4a71c78317f391a28	1,0,1,1,0,1,1,1,3,1	2023-05-21T11:37:23.000Z	0x589c81c6de64fe6873c556ca7b16a8a50fa251b5d9afc12fb1a242aab9a8f076

Example Query

Query with partition filter

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

DaiJoin_cage_function

No description available.

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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

DaiJoin_deny_function

No description available.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

DaiJoin_exit_function

DAI withdrawal events from MakerDAO’s DaiJoin adapter contract on Ethereum, recording when users exit DAI from the protocol by converting internal balances to ERC20 tokens. Tracks recipient addresses and withdrawal amounts (wad) for analyzing DAI redemption patterns and vault collateral management.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

gas	in_usr	in_wad	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
226786	0x9da6ca884f24dc29b320cc9075d769909a55a544	0	true	26649	0xef693bed	0x9759a6ac90977b93b58547b4a71c78317f391a28	11500870	0x5d3a536e4d6dbd6114cc1ead35777bab948e3643	0,11	2020-12-22T03:40:59.000Z	0x914bfb819c69dd9dcaa032768a65bdcec7da18b67cd27f979febb8bf63131c0c
405516	0x9ae0b5b44aa17d178253cc2a4efc398bdefbbaf0	583824524042645832000	true	26701	0xef693bed	0x9759a6ac90977b93b58547b4a71c78317f391a28	11505518	0x06af07097c9eeb7fd685c692751d5c66db49c215	0,15,3	2020-12-22T20:45:31.000Z	0xc2f1b22d9ecea9d0fbaf69ea16359f4af8adcd14d14f32ba43eca7e1bba86a69
116620	0x240edc6143e1859f4c06bc3d7f7a7962be1ebbd7	376636800910073000000000	true	30901	0xef693bed	0x9759a6ac90977b93b58547b4a71c78317f391a28	11503564	0x5d3a536e4d6dbd6114cc1ead35777bab948e3643	0,1,0,7,0,3,4,0,9	2020-12-22T13:31:28.000Z	0xe63675e97e849e251a9ddee9da9ede0ebe54404ac3e1179514b2f12e1f2b2407

Example Query

Query with partition filter

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

DaiJoin_join_function

MakerDAO DaiJoin contract function calls on Ethereum that deposit collateral DAI into vaults, showing user addresses, deposit amounts in wei (in_wad), and transaction execution details. Used for tracking DAI inflows into the MakerDAO protocol and analyzing vault funding patterns.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

gas	in_usr	in_wad	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
40788	0xa950524441892a31ebddf91d3ceefa04bf454466	115978266100000000000000	true	40336	0x3b4da69f	0x9759a6ac90977b93b58547b4a71c78317f391a28	16398667	0x0048fc4357db3c0f45adea433a07a20769ddb0cf	0,1,1,1	2023-01-13T15:08:47.000Z	0x9125a79157570c42ebf31f19f670274ac9b334cd307c592918f56317fd9be70b
195809	0xcdda482d40d028d80c6b9f64ecedd10caeaac158	1000000000000000000000	true	37293	0x3b4da69f	0x9759a6ac90977b93b58547b4a71c78317f391a28	16397919	0x118f2c4497ebd671fa5ff4a55d98c9d78caae355	0,8	2023-01-13T12:37:59.000Z	0x872cbaaf58226e5204f0cdaeb8e2dde9acd944e41e78336eb5d4dbedca8dae83
946020	0x1eb4cf3a948e7d72a198fe073ccb8c7a948cd853	2544829095426473026897	true	39336	0x3b4da69f	0x9759a6ac90977b93b58547b4a71c78317f391a28	16395253	0x1eb4cf3a948e7d72a198fe073ccb8c7a948cd853	0,4,0,7,10,4	2023-01-13T03:41:11.000Z	0x4dcad7e082583e9842e38497f1ed8d92d82203bd3785e34dca59464e6d2f4de5

Example Query

Query with partition filter

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

DaiJoin_LogNote_event

No description available.

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_sig`	`STRING`	ECDSA signature authorizing the transaction or order. Structure containing v (recovery identifier), r (first 32 bytes of signature), and s (second 32 bytes of signature) components.
`in_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_arg1`	`STRING`	-
`in_arg2`	`STRING`	-
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

DaiJoin_rely_function

No description available.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Dog_Bark_event

Liquidation initiation events from MakerDAO’s Dog contract on Ethereum, triggered when vaults become undercollateralized. Records collateral type (ilk), vault address (urn), debt amount (art), collateral amount (ink), and assigned liquidation auction contract (clip) for analyzing vault health and liquidation patterns.

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_ilk`	`STRING`	Collateral type identifier in the MakerDAO system. 66-character hex string including 0x prefix.
`in_urn`	`STRING`	Vault (collateralized debt position) address that is being liquidated in this Bark event. Hex-encoded Ethereum address identifying the specific position within the collateral type (ilk) that triggered the liquidation.
`in_ink`	`STRING`	Collateral amount locked in the vault being liquidated, denominated in the smallest unit of the collateral token. This value represents the quantity of assets (ink) available for auction through the specified clip contract.
`in_art`	`STRING`	Debt amount in DAI owed by the liquidated vault at the time of liquidation event. Expressed in wei (smallest unit with 18 decimals).
`in_due`	`STRING`	Total DAI amount owed for the liquidated vault, including principal debt and accrued stability fees, denominated in wei (10^18 precision). This value represents the full obligation that must be covered by the collateral auction.
`in_clip`	`STRING`	Contract address of the Clipper auction contract assigned to liquidate this undercollateralized vault position. Hex-encoded, 0x-prefixed 40-character string identifying the specific auction module for the collateral type.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.

Sample Data

in_id	in_art	in_due	in_ilk	in_ink	in_urn	address	in_clip	removed	log_index	block_number	block_timestamp	transaction_hash
5	5278814031727543461370	5300000000000000000000242661639681225925904176480	0x554e495632574254434441492d41000000000000000000000000000000000000	243013334369094	0xd4c78cd292576eb13b9d8f4b219a869b4e70239e	0x135954d155898d42c90d2a57824c690e0c7bef1b	0x4fc53a57262b87abda61d6d0db2be7e9be68f6b8	false	31	15083465	2022-07-05T16:00:00.000Z	0x34329e65b647465e33445243542f62f7836d21c3f9db9cf132c782d3579afd62
2	163415442253042312462824	169515900205203118561266673161453792163029707615328	0x554e495632574254434554482d41000000000000000000000000000000000000	310735088659653	0x25fb9b56da8f672649ea22ecf119a02f4f3c32a9	0x135954d155898d42c90d2a57824c690e0c7bef1b	0xb15afab996904170f87a64fe42db0b64a6f75d24	false	17	15083465	2022-07-05T16:00:00.000Z	0x34329e65b647465e33445243542f62f7836d21c3f9db9cf132c782d3579afd62
6	16267563849861568484080	16665231244551124491707991010041019959311259965200	0x554e4956324441494554482d4100000000000000000000000000000000000000	220713711698250693345	0xd78e7e3f1df6e2d0864bd9e98f5be8578a48fd13	0x135954d155898d42c90d2a57824c690e0c7bef1b	0x9f6981ba5c77211a34b76c6385c0f6fa10414035	false	24	15083465	2022-07-05T16:00:00.000Z	0x34329e65b647465e33445243542f62f7836d21c3f9db9cf132c782d3579afd62

Example Query

Query with partition filter

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

DSProxy_LogSetAuthority_event

Authority assignment events from MakerDAO’s DSProxy contracts on Ethereum, recording when permission control is delegated to new authority addresses. Used for tracking governance changes and proxy contract permission updates across MakerDAO’s vault management system.

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_authority`	`STRING`	Account address authorized to perform the operation. Base58-encoded Solana public key or hex-encoded EVM address.

Sample Data

address	removed	log_index	block_number	in_authority	block_timestamp	transaction_hash
0xb7140c34ccc029850aad409bd2da7c00f408fa0f	false	183	10891144	0x655a130c9f78383bc501349c4fa9c20b4e18d203	2020-09-19T06:53:27.000Z	0xcc3d9488f26dd31eec8e16c2342869eddb3296959141d0e37bc80dab42a49f16
0x6d579481a688993bb8b80dcde528e4b92b693d67	false	116	16273519	0xf9fb01b79e9373252595d72b0c79bdff26345814	2022-12-27T03:52:47.000Z	0x32a2a43ce160acb6137f3130742ad8c36bf90f60c18e7b83449aee0ed6f7b0f6
0x7f1c5556cf0506847df80f18ef843a6a8587b563	false	65	16278386	0x5b647d9b61946c09aa0fd78ae69d6a7e2bdf8eb3	2022-12-27T20:11:23.000Z	0x36e4676ce38a54b416e9f8cee2ea405e8591935c7ae4ebc5241a34fbdb133ae4

Example Query

Query with partition filter

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

DSProxy_LogSetOwner_event

Ownership transfer events for MakerDAO DSProxy contracts on Ethereum, recording when proxy contract control changes from one address to another. Used for tracking proxy ownership history and analyzing account management patterns in the Maker protocol.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_owner	log_index	block_number	block_timestamp	transaction_hash
0x6adf1e9d9afcea0747d6e1c38b6b9ede51f2accd	false	0xecc5acc39f800f0e1c9db3d9b351c4fd47aab0c6	229	12376066	2021-05-05T19:16:24.000Z	0x66a93c257e2c7029f2b9c8e7eb541fafbc92e067f503e7f524745916121374fa
0x6adf1e9d9afcea0747d6e1c38b6b9ede51f2accd	false	0xa26e15c895efc0616177b7c1e7270a4c7d51c997	226	12376066	2021-05-05T19:16:24.000Z	0x66a93c257e2c7029f2b9c8e7eb541fafbc92e067f503e7f524745916121374fa
0x9ad63d26934b673318df65c7307551b36fd5f251	false	0xa26e15c895efc0616177b7c1e7270a4c7d51c997	135	12375556	2021-05-05T17:26:56.000Z	0x69109629939bea62bdc86f21c5e24abc39b316389c63b8b35ce21e4034691ed0

Example Query

Query with partition filter

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

DSProxy_setAuthority_function

DSProxy authority assignment events from MakerDAO v1 on Ethereum, capturing when proxy contracts delegate permissions to new authority addresses. Used for tracking governance control changes and proxy contract permission management.

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`	`NUMERIC`	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_authority_`	`STRING`	Address of the authority contract being assigned to the DSProxy instance. Defines which contract will control permissions and access for the proxy.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_authority_	trace_address	block_timestamp	transaction_hash
1850373	true	21995	0x7a9e5e4b	0xdb6c1ba31b7257b0fc22252b3bfcc173a567c4e2	16195369	0xdb6c1ba31b7257b0fc22252b3bfcc173a567c4e2	0xae51b01a4108d09e23fbdbe8ae2c9380eee32571	0,4	2022-12-16T06:08:47.000Z	0x7bf9867bdd6eb06a39a3db5fb78edaeda037501ac64261d18e6216726b253240
2096578	true	21995	0x7a9e5e4b	0x9b60fd399ee9e58f54f82e476ec67a136a3b7340	16199251	0x9b60fd399ee9e58f54f82e476ec67a136a3b7340	0x51f0a9f9c4258820d8c131497e96852e63067b30	0,4	2022-12-16T19:08:35.000Z	0x441a6754fc16b1de00f32e98f802fd03b734f2161419da2f9f684f5beea5c9f6
337584	true	22695	0x7a9e5e4b	0x7c3761507a566a0eeb5cae93c2827a13e6ffe6c2	10328102	0x7c3761507a566a0eeb5cae93c2827a13e6ffe6c2	0xd7ee9d4ff73013ef09561631f54850d4bda65a85	0,2	2020-06-24T11:05:31.000Z	0xbeaa83902efc9d0ce2c0645753b697fea8f7d2a950b9d91c081753884a648e97

Example Query

Query with partition filter

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

DSProxy_setCache_function

MakerDAO DSProxy contract cache address configuration function calls on Ethereum. Tracks setCache operations that update the code cache addresses used by proxy contracts for delegatecall execution.

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`	`NUMERIC`	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__cacheAddr`	`STRING`	Contract address being set as the cache for the MakerDAO DSProxy contract. Hex-encoded, 0x-prefixed 40-character Ethereum address that defines the code cache implementation.
`out_anon0`	`BOOL`	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

gas	status	gas_used	out_anon0	signature	to_address	block_number	from_address	in__cacheAddr	block_timestamp	transaction_hash
8173	true	6749	true	0x948f5076	0xdbdf406c6498dcf68f378605f5ec13e483769443	11962019	0x30c9223d9e3d23e0af1073a38e0834b055bf68ed	0x271293c67e2d3140a0e9381eff1f9b01e07b0795	2021-03-03T00:09:55.000Z	0xea411ae705e147dfd455a044d1c734b5ff74e1f566c27eb2358c71a800f92a89
27139	true	10949	true	0x948f5076	0x8185c573d687c3c2f8411949411f4b50199242a2	11117408	0x7f9d39de53a3036463146e91e921cc9fbfcb2de4	0x7f9d39de53a3036463146e91e921cc9fbfcb2de4	2020-10-24T06:18:46.000Z	0x4b73853ede1cfe1dae79aae6818a97eccd1eb376723d49119056cdf9ff1ae9cd
22975	true	6749	true	0x948f5076	0x59ccf5d966875325d3658e88eac93d62d1a080be	11121194	0xfb8caa905a2e87ef0790df090d90765f83eafd5a	0x271293c67e2d3140a0e9381eff1f9b01e07b0795	2020-10-24T20:14:07.000Z	0xb576dda94c0e6f8b98b74da4d226a94f2d541739e69eab35c121ad0fbe053e2a

Example Query

Query with partition filter

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

DssLitePsm_BuyGem_event

Gem purchase events from MakerDAO’s Lite Peg Stability Module (PSM) on Ethereum, recording stablecoin-to-collateral swaps with owner addresses, transaction values, and fees. Used for analyzing PSM arbitrage activity, liquidity provision patterns, and stablecoin peg maintenance operations.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

address	removed	in_owner	in_value	log_index	block_number	block_timestamp	transaction_hash
0xf6e72db5454dd049d0788e411b06cfaf16853042	false	0x00000000009e50a7ddb7a7b0e2ee6604fd120e49	53421521729	81	22672206	2025-06-10T05:54:59.000Z	0x50301103552982df3f716b585bcb60f0ec5174351709cf2f2cb912d7d64eaa5d
0xf6e72db5454dd049d0788e411b06cfaf16853042	false	0x00000000009e50a7ddb7a7b0e2ee6604fd120e49	25174057378	40	22675867	2025-06-10T18:10:11.000Z	0x7e76e22a859d7ca4396260c18ba0f0eb26abab83014e531ae860eaa808cdf949
0xf6e72db5454dd049d0788e411b06cfaf16853042	false	0x00000000009e50a7ddb7a7b0e2ee6604fd120e49	903211647	258	22674829	2025-06-10T14:41:59.000Z	0x4b5a732985e426f8ee2a060cfe81e4cbf163c87cf4e2515f76d39c2179a7d24b

Example Query

Query with partition filter

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

DssLitePsm_buyGem_function

MakerDAO Lite PSM (Peg Stability Module) buyGem function calls on Ethereum, recording stablecoin-to-collateral swaps where users exchange DAI for underlying gem tokens (USDC/GUSD). Tracks gem amounts received, DAI amounts paid in WAD precision (18 decimals), and recipient addresses for analyzing PSM redemption activity and peg arbitrage.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_gemAmt`	`STRING`	Amount of gem tokens being transacted in the MakerDAO Peg Stability Module. String-encoded integer representing the token amount in its smallest unit denomination.
`out_daiInWad`	`STRING`	DAI amount received by the user in wei denomination (18 decimal places), representing the output of the buyGem function in MakerDAO’s PSM (Peg Stability Module). Values are string-encoded integers where the last 18 digits represent fractional DAI.

Sample Data

gas	in_usr	status	gas_used	in_gemAmt	signature	to_address	block_number	from_address	out_daiInWad	trace_address	block_timestamp	transaction_hash
1184883	0x70bf6634ee8cb27d04478f184b9b8bb13e5f4710	true	13639	1003923477244	0x8d7ef9bb	0xf6e72db5454dd049d0788e411b06cfaf16853042	21088279	0x70bf6634ee8cb27d04478f184b9b8bb13e5f4710	1003923477244000000000000	6,1,8	2024-10-31T21:21:47.000Z	0xee16c8654c63121c199d5f6cd3474ea3ae815f5113dd9f49200939ff2bde4338
1262343	0x9008d19f58aabd9ed0d60971565aa8510560ab41	true	13639	100094435099	0x8d7ef9bb	0xf6e72db5454dd049d0788e411b06cfaf16853042	21086661	0x9008d19f58aabd9ed0d60971565aa8510560ab41	100094435099000000000000	12	2024-10-31T15:57:11.000Z	0xf83eee83bf8e31f95abc3db6df5012ebdee860a1241a593c97bb413021d87bf9
512934	0xf081470f5c6fbccf48cc4e5b82dd926409dcdd67	true	13639	123934595639	0x8d7ef9bb	0xf6e72db5454dd049d0788e411b06cfaf16853042	21088805	0xf081470f5c6fbccf48cc4e5b82dd926409dcdd67	123934595639000000000000	4,7,3	2024-10-31T23:07:23.000Z	0x0e2a630b3c3ffb3e31282c4a109d17361cddf8b34d961021b10f5f8b24f218df

Example Query

Query with partition filter

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

DssLitePsm_buyGemNoFee_function

MakerDAO Lite PSM (Peg Stability Module) function call records for buying collateral gems with DAI stablecoin at 1:1 ratio without fees on Ethereum. Useful for analyzing stablecoin redemptions and PSM liquidity flows where users convert DAI to USDC or other whitelisted collateral.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_gemAmt`	`STRING`	Amount of gem tokens being transacted in the MakerDAO Peg Stability Module. String-encoded integer representing the token amount in its smallest unit denomination.
`out_daiInWad`	`STRING`	DAI amount received in this PSM (Peg Stability Module) swap operation, denominated in wei (1e18 smallest units). Always 1e12 times the input gem amount, representing the 1:1 swap ratio with 18-decimal precision.

Sample Data

gas	in_usr	status	gas_used	in_gemAmt	signature	to_address	block_number	from_address	out_daiInWad	trace_address	block_timestamp	transaction_hash
598681	0x1601843c5e9bc251a3272907010afa41fa18347e	true	68105	3355763071670	0x067d9274	0xf6e72db5454dd049d0788e411b06cfaf16853042	22314911	0x1601843c5e9bc251a3272907010afa41fa18347e	3355763071670000000000000	0,1,1,4,0	2025-04-21T04:13:35.000Z	0x6d0a834cea02c86237d293269b3a179b9a51787e10c2c14762eb861616ea7da0
586733	0x1601843c5e9bc251a3272907010afa41fa18347e	true	68105	50000000000000	0x067d9274	0xf6e72db5454dd049d0788e411b06cfaf16853042	22318172	0x1601843c5e9bc251a3272907010afa41fa18347e	50000000000000000000000000	0,0,1,4,0	2025-04-21T15:07:47.000Z	0xf832fe94123aab15b2ba130f6789dfa3b0fd2aee74778f2ed28604130fd73ece
801647	0x1601843c5e9bc251a3272907010afa41fa18347e	true	68105	15000000000000	0x067d9274	0xf6e72db5454dd049d0788e411b06cfaf16853042	22318154	0x1601843c5e9bc251a3272907010afa41fa18347e	15000000000000000000000000	0,0,1,4,0	2025-04-21T15:03:59.000Z	0x33325afb12913f2e55ec9fa9ad8e2fa7aeb17c0f0fa72dfc4cef5ac7adcd20f5

Example Query

Query with partition filter

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

DssLitePsm_Chug_event

PSM (Peg Stability Module) chug events from MakerDAO’s Lite PSM contract on Ethereum, recording small-value stablecoin swap transactions. Tracks individual swap amounts in WAD (18 decimal) format for monitoring PSM utilization and stablecoin peg maintenance activity.

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_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
29542019000000000000	0xf6e72db5454dd049d0788e411b06cfaf16853042	false	19	23412239	2025-09-21T15:12:35.000Z	0x1ff24479a3e0a5c341e02b090d9823c8c670a20adf361a94ca0f3bfd3baeb6f2

Example Query

Query with partition filter

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

DssLitePsm_chug_function

Function calls to the chug method in MakerDAO’s Lite PSM (Peg Stability Module) contract on Ethereum, recording DAI/stablecoin swap operations with output amounts in WAD (18 decimal) format. Used for analyzing PSM liquidity provision and stablecoin peg maintenance activity.

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.
`out_wad`	`STRING`	Output amount in WAD format (18 decimal places) returned from the Lite PSM chug function. Represents the quantity of tokens received, typically DAI or the gem token, denominated in the smallest unit (wei-equivalent).

Sample Data

gas	value	status	out_wad	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
143059	0	true	29542019000000000000	94415	0x9b652df6	0xf6e72db5454dd049d0788e411b06cfaf16853042	23412239	0xd86caaf6b6af7d44a3927165f087b5c18f169ab7		2025-09-21T15:12:35.000Z	0x1ff24479a3e0a5c341e02b090d9823c8c670a20adf361a94ca0f3bfd3baeb6f2

Example Query

Query with partition filter

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

DssLitePsm_Deny_event

Authorization removal events from MakerDAO’s Lite PSM (Peg Stability Module) contract on Ethereum, tracking when addresses lose permissions to perform privileged operations. Used for monitoring access control changes and governance actions affecting the stablecoin peg mechanism.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.

Sample Data

in_usr	address	removed	log_index	block_number	block_timestamp	transaction_hash
0xb27b6fa77d7fbf3c1bd34b0f7da59b39d3db0f7e	0xf6e72db5454dd049d0788e411b06cfaf16853042	false	324	20283670	2024-07-11T13:49:35.000Z	0x91aabc7563f13aea7299e68a04331bc92bbcf72c895b9f4dde38b3f131a78d60

Example Query

Query with partition filter

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

DssLitePsm_deny_function

Permission revocation events from MakerDAO’s Lite PSM (Peg Stability Module) contract on Ethereum, tracking administrative deny function calls that remove authorized addresses from accessing the protocol.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.

Sample Data

gas	value	in_usr	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
34096	0	0xb27b6fa77d7fbf3c1bd34b0f7da59b39d3db0f7e	true	23314	0x9c52a7f1	0xf6e72db5454dd049d0788e411b06cfaf16853042	20283670	0xb27b6fa77d7fbf3c1bd34b0f7da59b39d3db0f7e		2024-07-11T13:49:35.000Z	0x91aabc7563f13aea7299e68a04331bc92bbcf72c895b9f4dde38b3f131a78d60

Example Query

Query with partition filter

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

DssLitePsm_Diss_event

No description available.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

DssLitePsm_diss_function

No description available.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

DssLitePsm_file_function

MakerDAO Lite PSM (Peg Stability Module) parameter updates on Ethereum, capturing file function calls that modify buffer and fee configuration settings. Used for tracking governance-driven changes to stablecoin swap parameters in the protocol.

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_what`	`STRING`	Parameter identifier specifying which configuration value or contract address to modify. 66-character hex string including 0x prefix, representing a bytes32 encoded parameter name.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

gas	status	in_data	in_what	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
753431	true	0	0x6275660000000000000000000000000000000000000000000000000000000000	2212	0x29ae8114	0xf6e72db5454dd049d0788e411b06cfaf16853042	20421763	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	0,0,0,68	2024-07-30T20:30:11.000Z	0x753150a0d7754eee0af35f271b43833b2fa5d3876e8988fc4b4b610d42f56d89
596362	true	20000000000000000000000000	0x6275660000000000000000000000000000000000000000000000000000000000	22112	0x29ae8114	0xf6e72db5454dd049d0788e411b06cfaf16853042	20421763	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	0,0,0,74	2024-07-30T20:30:11.000Z	0x753150a0d7754eee0af35f271b43833b2fa5d3876e8988fc4b4b610d42f56d89
1088276	true	20000000000000000000000000	0x6275660000000000000000000000000000000000000000000000000000000000	22112	0x29ae8114	0xf6e72db5454dd049d0788e411b06cfaf16853042	20421763	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	0,0,0,58	2024-07-30T20:30:11.000Z	0x753150a0d7754eee0af35f271b43833b2fa5d3876e8988fc4b4b610d42f56d89

Example Query

Query with partition filter

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

DssLitePsm_Fill_event

Fill events from MakerDAO’s Lite PSM (Peg Stability Module) contract on Ethereum, recording when the module’s buffer is replenished with incoming tokens. Used for monitoring PSM liquidity management and stablecoin swap capacity.

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_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
36131879304642000000000000	0xf6e72db5454dd049d0788e411b06cfaf16853042	false	356	21738238	2025-01-30T15:26:11.000Z	0x093234a99cfcbdf9adcc5ac03e322a1eef4382c822ab6200f59a10481743681b
27412490536474000000000000	0xf6e72db5454dd049d0788e411b06cfaf16853042	false	423	21734753	2025-01-30T03:46:23.000Z	0x4f59c899961d9810ade8d9c10b3257a04d8ce75f3b49da8f834bc5e91f84305b
31969642248975000000000000	0xf6e72db5454dd049d0788e411b06cfaf16853042	false	149	23520420	2025-10-06T18:09:35.000Z	0xd03122cefda2ebbc37088b12c7707e7d780de862da1a8c7b3ee1c4ad583aee33

Example Query

Query with partition filter

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

DssLitePsm_fill_function

MakerDAO Lite Peg Stability Module (PSM) fill function executions on Ethereum, capturing stablecoin swap operations with output amounts in WAD format (18 decimals). Used for analyzing PSM liquidity provision and stablecoin peg maintenance activity.

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.
`out_wad`	`STRING`	Output amount in WAD units (wei with 18 decimals) from the PSM (Peg Stability Module) fill operation. Values typically range from 20-300 trillion wei, representing stablecoin or collateral amounts exchanged.

Sample Data

gas	status	out_wad	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
206337	true	23499952090231000000000000	107357	0xd9c55ce1	0xf6e72db5454dd049d0788e411b06cfaf16853042	23730522	0x0c86162ba3e507592fc8282b07cf18c7f902c401	2	2025-11-05T03:47:59.000Z	0x46a7e32bef526de6cfc48bd148dd023b97d1ab22324dd1d09900ca9eafa95b0b
206337	true	21824848136239000000000000	107357	0xd9c55ce1	0xf6e72db5454dd049d0788e411b06cfaf16853042	23731560	0x0c86162ba3e507592fc8282b07cf18c7f902c401	2	2025-11-05T07:18:35.000Z	0x8afacd16071b8717722bd96ea4593f9ecc407972b31e3d959c7a7a9b5f943e8e
1850840	true	25463139069717000000000000	107357	0xd9c55ce1	0xf6e72db5454dd049d0788e411b06cfaf16853042	23734095	0x0c86162ba3e507592fc8282b07cf18c7f902c401	4,0,0,0,2	2025-11-05T15:49:59.000Z	0xfdc1e983edab402ede63777e7e16e7530532cc86aee811d006a2ddfdd2fdc5db

Example Query

Query with partition filter

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

DssLitePsm_Kiss_event

Authorization grant events from MakerDAO’s Lite PSM (Peg Stability Module) contract on Ethereum, tracking addresses given permission to interact with the module. Used for analyzing access control changes and authorized participant management in DAI stablecoin operations.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.

Sample Data

in_usr	address	removed	log_index	block_number	block_timestamp	transaction_hash
0xb6dd7ae22c9922afee0642f9ac13e58633f715a2	0xf6e72db5454dd049d0788e411b06cfaf16853042	false	211	23819348	2025-11-17T14:00:23.000Z	0x865f7bbd3976013411cb77c68822b362f50ea114c798257c1a041352e6ffc518
0x1601843c5e9bc251a3272907010afa41fa18347e	0xf6e72db5454dd049d0788e411b06cfaf16853042	false	209	21119578	2024-11-05T06:12:47.000Z	0xb0986293c49d684759dfebec740e95d89f73675295bbfcd311252d39a0a29397
0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	0xf6e72db5454dd049d0788e411b06cfaf16853042	false	484	20421763	2024-07-30T20:30:11.000Z	0x753150a0d7754eee0af35f271b43833b2fa5d3876e8988fc4b4b610d42f56d89

Example Query

Query with partition filter

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

DssLitePsm_kiss_function

Function call traces for the kiss authorization grant method in MakerDAO’s Lite PSM (Peg Stability Module) contract on Ethereum. Tracks when addresses are granted permissions to interact with the PSM, useful for analyzing governance and access control patterns.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.

Sample Data

gas	in_usr	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
4510401	0xa5139956ec99ae2e51ea39d0b57c42b6d8db0758	true	25931	0xf29c29c4	0xf6e72db5454dd049d0788e411b06cfaf16853042	23534264	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	0,0,0,44	2025-10-08T16:37:23.000Z	0x0af39af528cd328028432e17f451aff046b19536824007f2e1665f1b7ed5b2e3
1366826	0x1601843c5e9bc251a3272907010afa41fa18347e	true	25931	0xf29c29c4	0xf6e72db5454dd049d0788e411b06cfaf16853042	21119578	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	0,0,0,67	2024-11-05T06:12:47.000Z	0xb0986293c49d684759dfebec740e95d89f73675295bbfcd311252d39a0a29397
1750175	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	true	23931	0xf29c29c4	0xf6e72db5454dd049d0788e411b06cfaf16853042	20421763	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	0,0,0,29	2024-07-30T20:30:11.000Z	0x753150a0d7754eee0af35f271b43833b2fa5d3876e8988fc4b4b610d42f56d89

Example Query

Query with partition filter

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

DssLitePsm_Rely_event

Authorization grant events from MakerDAO’s Lite PSM (Peg Stability Module) contract on Ethereum, recording addresses granted administrative permissions. Used for tracking governance changes and access control modifications in the stablecoin liquidity system.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.

Sample Data

in_usr	address	removed	log_index	block_number	block_timestamp	transaction_hash
0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	0xf6e72db5454dd049d0788e411b06cfaf16853042	false	658	20283668	2024-07-11T13:49:11.000Z	0x9f771abc295be0a08d95538f42b85772434e7a6eb06ca095675ebfb7e6e2f7c4
0xb27b6fa77d7fbf3c1bd34b0f7da59b39d3db0f7e	0xf6e72db5454dd049d0788e411b06cfaf16853042	false	168	20283666	2024-07-11T13:48:47.000Z	0x61e5d04f14d1fea9c505fb4dc9b6cf6e97bc83f2076b53cb7e92d0a2e88b6bbd
0x467b32b0407ad764f56304420cddaa563bdab425	0xf6e72db5454dd049d0788e411b06cfaf16853042	false	485	20421763	2024-07-30T20:30:11.000Z	0x753150a0d7754eee0af35f271b43833b2fa5d3876e8988fc4b4b610d42f56d89

Example Query

Query with partition filter

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

DssLitePsm_rely_function

Authorization grant events from MakerDAO’s Lite PSM (Peg Stability Module) contract on Ethereum, tracking rely() function calls that grant admin privileges to addresses. Used for monitoring governance actions and access control changes in the stablecoin peg mechanism.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.

Sample Data

gas	value	in_usr	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
1726074	0	0x467b32b0407ad764f56304420cddaa563bdab425	true	23949	0x65fae35e	0xf6e72db5454dd049d0788e411b06cfaf16853042	20421763	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	0,0,0,30	2024-07-30T20:30:11.000Z	0x753150a0d7754eee0af35f271b43833b2fa5d3876e8988fc4b4b610d42f56d89
69277	0	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	true	47369	0x65fae35e	0xf6e72db5454dd049d0788e411b06cfaf16853042	20283668	0xb27b6fa77d7fbf3c1bd34b0f7da59b39d3db0f7e		2024-07-11T13:49:11.000Z	0x9f771abc295be0a08d95538f42b85772434e7a6eb06ca095675ebfb7e6e2f7c4

Example Query

Query with partition filter

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

DssLitePsm_SellGem_event

Gem-to-DAI sell events from MakerDAO’s Lite Peg Stability Module (PSM) on Ethereum, recording stablecoin redemptions with owner addresses, transaction values, and fees. Used to analyze PSM arbitrage activity and stablecoin liquidity flows in the Maker protocol.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

address	removed	in_owner	in_value	log_index	block_number	block_timestamp	transaction_hash
0xf6e72db5454dd049d0788e411b06cfaf16853042	false	0x000000000054848131c6b40c852dcf9c8f95fae4	242567887	143	22112994	2025-03-23T23:51:59.000Z	0x749a9bcfe5f1acc69f22c689e10fa6abb10fdbd6b45483285970475c586b91fa
0xf6e72db5454dd049d0788e411b06cfaf16853042	false	0x000000000091aa76be15fc8a8338866209e35129	1192629154	297	22108907	2025-03-23T10:10:47.000Z	0x1d226ce4dab3ac6749c810e15aad96afecc21c087a581b398539d1aaf03347a6
0xf6e72db5454dd049d0788e411b06cfaf16853042	false	0x000000000091aa76be15fc8a8338866209e35129	203682939	425	22106975	2025-03-23T03:43:11.000Z	0x6351fb6ae54dc6e252f235cfbbde1e0dc8789d85547fa565347d89042e44ce52

Example Query

Query with partition filter

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

DssLitePsm_sellGem_function

Stablecoin swap transactions through MakerDAO’s Lite PSM (Peg Stability Module) where users sell collateral tokens (gems) like USDC to receive DAI on Ethereum. Useful for analyzing PSM trading volume, DAI supply mechanisms, and arbitrage activity maintaining the DAI peg.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_gemAmt`	`STRING`	Amount of gem tokens being transacted in the MakerDAO Peg Stability Module. String-encoded integer representing the token amount in its smallest unit denomination.
`out_daiOutWad`	`STRING`	Amount of DAI tokens received by the user in wei units (18 decimals). Null when the transaction fails, otherwise represents the DAI output from selling gems through the PSM (Peg Stability Module).

Sample Data

gas	in_usr	status	gas_used	in_gemAmt	signature	to_address	block_number	from_address	out_daiOutWad	trace_address	block_timestamp	transaction_hash
537718		false	3806		0x95991276	0xf6e72db5454dd049d0788e411b06cfaf16853042	22172800	0xefb04c9c34d38f9c0fa616bf2440e77377d09122		0,2,1,2,3	2025-04-01T08:16:11.000Z	0x04a16f1e2f2849290cc2f5e2d415a8eb9c8791b332d19a443672fc234efb14fa
168436	0x00000000009e50a7ddb7a7b0e2ee6604fd120e49	true	13336	5523696580	0x95991276	0xf6e72db5454dd049d0788e411b06cfaf16853042	22171216	0x00000000009e50a7ddb7a7b0e2ee6604fd120e49	5523696580000000000000	0,3,1,7,2,5	2025-04-01T02:57:11.000Z	0x317d27e6d896c563515f575645fc215d43c03ac390c6d0a3b2a9f57bd1fd3faa
818076	0x0f4a1d7fdf4890be35e71f3e0bbc4a0ec377eca3	true	13336	1979708294	0x95991276	0xf6e72db5454dd049d0788e411b06cfaf16853042	22172103	0x0f4a1d7fdf4890be35e71f3e0bbc4a0ec377eca3	1979708294000000000000	0,6,0,3,3,1,5,9,4,4,6,2	2025-04-01T05:55:47.000Z	0x2cde4ca0dc24be683f7dd9acb007d0dc71ea4dc335a02243a59bbdee0ad228e3

Example Query

Query with partition filter

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

DssLitePsm_sellGemNoFee_function

MakerDAO Lite PSM (Peg Stability Module) sellGemNoFee function calls on Ethereum, recording stablecoin-to-DAI swaps with gem input amounts and DAI output amounts. Used for analyzing PSM arbitrage activity and DAI peg maintenance through fee-free collateral redemptions.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_gemAmt`	`STRING`	Amount of gem tokens being transacted in the MakerDAO Peg Stability Module. String-encoded integer representing the token amount in its smallest unit denomination.
`out_daiOutWad`	`STRING`	DAI amount received by the user from selling gems through the Lite PSM (Peg Stability Module), denominated in wei with 18 decimal places. Calculated by multiplying the input gem amount by 10^12 to normalize to DAI’s standard precision.

Sample Data

gas	in_usr	status	gas_used	in_gemAmt	signature	to_address	block_number	from_address	out_daiOutWad	trace_address	block_timestamp	transaction_hash
695975	0x1601843c5e9bc251a3272907010afa41fa18347e	true	49021	5576709179978	0x86c34f42	0xf6e72db5454dd049d0788e411b06cfaf16853042	22619753	0x1601843c5e9bc251a3272907010afa41fa18347e	5576709179978000000000000	0,1,6,3,0	2025-06-02T21:46:35.000Z	0xe209de4055183296bad179beef875be5d561dff034e2911d602f2e46f419241e
660916	0x1601843c5e9bc251a3272907010afa41fa18347e	true	49021	3168517482514	0x86c34f42	0xf6e72db5454dd049d0788e411b06cfaf16853042	22618987	0x1601843c5e9bc251a3272907010afa41fa18347e	3168517482514000000000000	0,1,4,3,0	2025-06-02T19:11:59.000Z	0x66d55ef998b689c7f283b8739d96661976174a6aeb9442ee8cd6c76dac2d7874
714520	0x1601843c5e9bc251a3272907010afa41fa18347e	true	49021	6200297141534	0x86c34f42	0xf6e72db5454dd049d0788e411b06cfaf16853042	22618962	0x1601843c5e9bc251a3272907010afa41fa18347e	6200297141534000000000000	0,1,7,3,0	2025-06-02T19:06:59.000Z	0x05d485476a8f01d7f1de27d0f5bda297cdd5a93bbd584287e12fc6f1aec61ee2

Example Query

Query with partition filter

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

DssLitePsm_Trim_event

Trim events from MakerDAO’s Lite PSM (Peg Stability Module) contract on Ethereum, recording surplus removal operations with amounts in WAD format (18 decimals). Used for tracking when excess stablecoin inventory is trimmed from the PSM to maintain optimal liquidity levels.

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_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
91858291538511000000000000	0xf6e72db5454dd049d0788e411b06cfaf16853042	false	319	22627433	2025-06-03T23:33:47.000Z	0x2aa20c89215b4b6e332884d3f75d854086c83d63c18f478b145e38ca5ee7bead
20328785674533000000000000	0xf6e72db5454dd049d0788e411b06cfaf16853042	false	167	22626073	2025-06-03T18:59:35.000Z	0x8f78777af98d2e0cc6f493b0360a597648b548e5f252a286ff4038a71b79a6b5
20958838307892000000000000	0xf6e72db5454dd049d0788e411b06cfaf16853042	false	404	22625878	2025-06-03T18:20:35.000Z	0x0d86de146b1d258a9f3befd73116112a3f4101f55ea669997af50047fac831f5

Example Query

Query with partition filter

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

DssLitePsm_trim_function

MakerDAO Lite Peg Stability Module (PSM) trim function calls on Ethereum, tracking surplus collateral withdrawal operations. Records show automated treasury management removing excess stablecoin reserves with output amounts (out_wad) in 18-decimal wei format.

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.
`out_wad`	`STRING`	Amount of tokens returned by the trim function in WAD precision (1e18), representing surplus withdrawn from the MakerDAO Lite PSM contract. Values typically range from millions to hundreds of millions of token units in their smallest denomination.

Sample Data

gas	status	out_wad	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
203589	true	45727859063095000000000000	104600	0x40d9c0e3	0xf6e72db5454dd049d0788e411b06cfaf16853042	21912343	0x0c86162ba3e507592fc8282b07cf18c7f902c401	2	2025-02-23T23:35:35.000Z	0x560ef2b857e9b465427266fdf25e2ac2f9be03ef1229c33c3b74126ec622b47f
1850805	true	25426444495693000000000000	104600	0x40d9c0e3	0xf6e72db5454dd049d0788e411b06cfaf16853042	22962772	0x0c86162ba3e507592fc8282b07cf18c7f902c401	4,0,0,0,2	2025-07-20T20:23:59.000Z	0x420b2854ab9324246ac13b8555edc680643f8da30a6bf0a30d64d35b9f86b6e7
1850805	true	23345384328344000000000000	104600	0x40d9c0e3	0xf6e72db5454dd049d0788e411b06cfaf16853042	22961585	0x0c86162ba3e507592fc8282b07cf18c7f902c401	4,0,0,0,2	2025-07-20T16:25:59.000Z	0x3184ce0a98e110051d473bd7c6ad8b49b38a27d55e3e0200b1c5885f2c22bfd1

Example Query

Query with partition filter

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

DSToken_Burn_event

MKR token burn events from MakerDAO’s DSToken contract on Ethereum, recording token destructions with burned amounts and recipient addresses. Used for tracking MKR supply changes and governance token circulation analysis.

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_guy`	`STRING`	Address of the spender or recipient approved to transfer tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_guy	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x00000000009e50a7ddb7a7b0e2ee6604fd120e49	82962945854510736	0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2	false	101	22363649	2025-04-27T23:22:11.000Z	0x878ebfb997178e147773acbc7f77ab02c3c11ee21e98ab87e7fb1c17f3cb8e42
0x00000000009e50a7ddb7a7b0e2ee6604fd120e49	1324045031882883072	0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2	false	86	22360038	2025-04-27T11:17:11.000Z	0x153b68e77ea01843a300f2cb3760db4b2a42f4027321ad4ae86f4b907f8dc031
0x00000000009e50a7ddb7a7b0e2ee6604fd120e49	97637147377995230	0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2	false	259	22363327	2025-04-27T22:17:23.000Z	0x52d362a191ade2a6d29ff4e8fd944b323fda96cb3a623d38a704e04429f65e15

Example Query

Query with partition filter

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

DSToken_Mint_event

MKR (MakerDAO governance token) minting events on Ethereum, recording new token issuance to recipient addresses with amounts in wei. Used for analyzing MKR supply changes and governance token distribution patterns.

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_guy`	`STRING`	Address of the spender or recipient approved to transfer tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_guy	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x00000000009e50a7ddb7a7b0e2ee6604fd120e49	1136320579605413669	0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2	false	253	21375233	2024-12-10T22:57:23.000Z	0xbd6951659009a84f1b4c008c1e0d26cd7c02b87c0af5a9bb5f4fe221af3be40b
0x03718d05124f9a836ec1b49b6d0931a9a0ee43b4	24737743780165416666	0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2	false	264	21373316	2024-12-10T16:32:23.000Z	0x176c3de1a1036d68aed81a2d6c263e3c619cc53808f21341d875d4db0cd92e09
0x22a956c4755d8c4294b358dc346e74250e175622	20021738819924328505	0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2	false	316	21372270	2024-12-10T13:02:23.000Z	0xbc54ad25dd7bc690e995aca71d5068094f88997137c3e5c88daaeecf517e192c

Example Query

Query with partition filter

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

IlkRegistry_AddIlk_event

Events recording when new collateral types (ilks) are added to MakerDAO’s Ilk Registry on Ethereum. Used for tracking the expansion of supported collateral assets including real-world assets, LP tokens, and DeFi protocol integrations.

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_ilk`	`STRING`	Collateral type identifier in the MakerDAO system. 66-character hex string including 0x prefix.

Sample Data

in_ilk	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x4449524543542d53504b2d414156452d4c49444f2d5553445300000000000000	0x5a464c28d19848f44199d003bef5ecc87d090f87	false	468	20914143	2024-10-07T14:00:23.000Z	0x0e0dfb0127bda1451386c530c99db25fc3c6373daba1bd96feb16a8a0d18da55
0x414c4c4f4341544f522d424c4f4f4d2d41000000000000000000000000000000	0x5a464c28d19848f44199d003bef5ecc87d090f87	false	317	22217481	2025-04-07T14:00:35.000Z	0x269d75d67578c23eac3691228042501baa803d3b5680cfef141b7203e9ff3058
0x414c4c4f4341544f522d4f4245582d4100000000000000000000000000000000	0x5a464c28d19848f44199d003bef5ecc87d090f87	false	181	23619444	2025-10-20T14:35:35.000Z	0xf5590375e7fd63002cc0f3b5613f42d2d7f35c24312b713c80b519afff998745

Example Query

Query with partition filter

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

IlkRegistry_RemoveIlk_event

Events tracking when collateral types (ilks) are added to or removed from MakerDAO’s Ilk Registry on Ethereum. Records hex-encoded ilk identifiers like DIRECT-AAVEV2-DAI, UNI-A, and RETH-A for tracking vault collateral type registry changes.

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_ilk`	`STRING`	Collateral type identifier in the MakerDAO system. 66-character hex string including 0x prefix.

Sample Data

in_ilk	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x4449524543542d4141564556322d444149000000000000000000000000000000	0x5a464c28d19848f44199d003bef5ecc87d090f87	false	371	16519350	2023-01-30T11:29:59.000Z	0xf476621dce2caae01b9003b35c5a7602b03fe365b4cdadf4717bade799a45f64
0x554e492d41000000000000000000000000000000000000000000000000000000	0x5a464c28d19848f44199d003bef5ecc87d090f87	false	138	23118264	2025-08-11T14:00:23.000Z	0x39372da80325b306a02f93de009ecaffdd6e106b7cbd7f305ab7a39adbc527ed
0x5041585553442d41000000000000000000000000000000000000000000000000	0x5a464c28d19848f44199d003bef5ecc87d090f87	false	124	23118264	2025-08-11T14:00:23.000Z	0x39372da80325b306a02f93de009ecaffdd6e106b7cbd7f305ab7a39adbc527ed

Example Query

Query with partition filter

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

Jug_drip_function

MakerDAO Jug contract drip function calls that accrue stability fees for collateral types (ilks) on Ethereum. Returns updated stability fee rate for analyzing fee accrual patterns across different vault collateral types like ETH-A, LINK-A, and AAVE-A.

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_ilk`	`STRING`	Collateral type identifier in the MakerDAO system. 66-character hex string including 0x prefix.
`out_rate`	`STRING`	Accumulated stability fee rate for the specified vault type (ilk) after the drip accrual. Expressed as a high-precision integer representing the cumulative rate multiplier (ray format: 27 decimal places).

Sample Data

gas	in_ilk	status	gas_used	out_rate	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
2496604	0x4554482d42000000000000000000000000000000000000000000000000000000	true	48976	1013504964478419067601536850	0x44e2a5a8	0x19c0976f590d67707e62397c87829d896dc0f1f1	11745412	0xd961fcc6a3e706fdbb55d46bdc6b929de4562544	0,0,1,7,0,2,16,0,2,1,9,0,3,1,0,6,4	2021-01-28T16:33:54.000Z	0x44df14beb1f285c8e959c70718af3034f830e5824e906cdfb5cdaaaa1d15741b
8023041	0x4554482d41000000000000000000000000000000000000000000000000000000	true	51981	1027517172572360475263730993	0x44e2a5a8	0x19c0976f590d67707e62397c87829d896dc0f1f1	11741458	0x1bc9df10a0ebf0104e4b58ac3c65c3859474d3aa	0,1,5,0,1,9	2021-01-28T01:48:07.000Z	0xfa49404643f5c4999763beb187f4cf3166f3a6102da34812dab2bc7d9b697b48
647519	0x554e492d41000000000000000000000000000000000000000000000000000000	true	51465	1003667746839422383137331806	0x44e2a5a8	0x19c0976f590d67707e62397c87829d896dc0f1f1	11746075	0xaaef4463d5ac0aa30bc92f950808586df8ba2116	0,10	2021-01-28T18:59:02.000Z	0xdb1f5ceb55d791e3cfa54740669b0bda73a42b10d5584956c4a7289af2f062d7

Example Query

Query with partition filter

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

Jug_file_function

MakerDAO Jug contract parameter updates recording stability fee (duty) adjustments for different collateral types (ilks) on Ethereum. Used for tracking interest rate governance changes across vault types like ETH-A, WBTC, and Uniswap LP tokens.

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_ilk`	`STRING`	Collateral type identifier in the MakerDAO system. 66-character hex string including 0x prefix.
`in_what`	`STRING`	Parameter identifier specifying which configuration value or contract address to modify. 66-character hex string including 0x prefix, representing a bytes32 encoded parameter name.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

gas	in_ilk	status	in_data	in_what	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
360274	0x554e495632444149555344432d41000000000000000000000000000000000000	true	1000000000158153903837946257	0x6475747900000000000000000000000000000000000000000000000000000000	8066	0x1a0b287e	0x19c0976f590d67707e62397c87829d896dc0f1f1	12678048	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	0,0,0,46,2	2021-06-21T14:05:59.000Z	0x3795ff4554132ebfd4906cb83b897038c09f98c178eec6a830c86942f620ff87
1145320	0x4554482d43000000000000000000000000000000000000000000000000000000	true	1000000000315522921573372069	0x6475747900000000000000000000000000000000000000000000000000000000	8066	0x1a0b287e	0x19c0976f590d67707e62397c87829d896dc0f1f1	12678048	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	0,0,0,29,2	2021-06-21T14:05:59.000Z	0x3795ff4554132ebfd4906cb83b897038c09f98c178eec6a830c86942f620ff87
428907	0x554e495632444149555344542d41000000000000000000000000000000000000	true	1000000000627937192491029810	0x6475747900000000000000000000000000000000000000000000000000000000	8066	0x1a0b287e	0x19c0976f590d67707e62397c87829d896dc0f1f1	12678048	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	0,0,0,44,2	2021-06-21T14:05:59.000Z	0x3795ff4554132ebfd4906cb83b897038c09f98c178eec6a830c86942f620ff87

Example Query

Query with partition filter

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

Jug_file2_function

Trace-level executions of the Jug.file2 function in MakerDAO’s stability fee accumulation contract, recording parameter updates for collateral types and system configurations. Used for tracking governance changes to the protocol’s debt interest rate mechanism.

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_what`	`STRING`	Parameter identifier specifying which configuration value or contract address to modify. 66-character hex string including 0x prefix, representing a bytes32 encoded parameter name.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

gas	value	status	in_data	in_what	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
6382993	0	true	0	0x6261736500000000000000000000000000000000000000000000000000000000	9969	0x29ae8114	0x19c0976f590d67707e62397c87829d896dc0f1f1	8928298	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	0,1,0,0,0	2019-11-13T19:52:49.000Z	0x5b67608d456d9eef77352139a8726eff41fad69df212d78cc350924c228157ab

Example Query

Query with partition filter

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

Jug_file3_function

MakerDAO Jug contract file3 function calls that configure vault-specific stability fee parameters on Ethereum. Tracks governance actions setting collateral type risk parameters identified by the ‘what’ field.

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_what`	`STRING`	Parameter identifier specifying which configuration value or contract address to modify. 66-character hex string including 0x prefix, representing a bytes32 encoded parameter name.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

gas	value	status	in_data	in_what	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
874978	0	true	0xa950524441892a31ebddf91d3ceefa04bf454466	0x766f770000000000000000000000000000000000000000000000000000000000	25293	0xd4e8be83	0x19c0976f590d67707e62397c87829d896dc0f1f1	8928163	0xbaa65281c2fa2baacb2cb550ba051525a480d3f4	3	2019-11-13T19:19:02.000Z	0x85f00375c202fe934a8b77dc510f7b190bf084cd416f16d4276f867877ab6788

Example Query

Query with partition filter

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

MCD_LITE_PSM_USDC_A_JAR_Toss_event

Fee distributions from MakerDAO’s USDC-A Peg Stability Module (PSM) Lite jar contract on Ethereum. Records periodic transfers of accumulated stablecoin fees to designated recipients for protocol revenue tracking.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_usr	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x69ca348bd928a158ade7aa193c133f315803b06e	3890657208331000000000000	0x69ca348bd928a158ade7aa193c133f315803b06e	false	218	21581853	2025-01-08T19:28:47.000Z	0x385c17d466f659eff9959ea57e70fa0f7b833fdda5d69823627d14b1c594687a
0x69ca348bd928a158ade7aa193c133f315803b06e	11131034012125000000000000	0x69ca348bd928a158ade7aa193c133f315803b06e	false	138	21188569	2024-11-14T21:18:23.000Z	0x62033ce0597dc74f7007c53f511b7fe2c5111d003b8b59558970451903a7cb00
0x69ca348bd928a158ade7aa193c133f315803b06e	12850658450810000000000000	0x69ca348bd928a158ade7aa193c133f315803b06e	false	72	22434129	2025-05-07T20:33:59.000Z	0x8ca355a4bdab6506e57c639a14a6be3d301f00b7fe3696131cdbf03ec8666000

Example Query

Query with partition filter

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

MCD_PSM_GUSD_A_JAR_Toss_event

Fee distribution events from MakerDAO’s GUSD Peg Stability Module (PSM) JAR contract on Ethereum, recording accumulated fee transfers to the recipient address with amounts in WAD precision (18 decimals).

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_usr	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0xf2e7a5b83525c3017383deed19bb05fe34a62c27	480406113000000000000000	0xf2e7a5b83525c3017383deed19bb05fe34a62c27	false	661	16234279	2022-12-21T16:30:11.000Z	0x1f2568459121627a7529392788b835bce91678eb9d3787f087ea7afb4af76c53
0xf2e7a5b83525c3017383deed19bb05fe34a62c27	772342190000000000000000	0xf2e7a5b83525c3017383deed19bb05fe34a62c27	false	354	17538081	2023-06-22T22:19:23.000Z	0x9ce7577477223e7a0308a39526794f082fb4e285be74776e12810b8a47c49430
0xf2e7a5b83525c3017383deed19bb05fe34a62c27	1000000000000000000	0xf2e7a5b83525c3017383deed19bb05fe34a62c27	false	293	18488115	2023-11-03T00:58:59.000Z	0x70bda04acb602511c9f32d44fe509bcd88bb82c3a6b60269bac2c31b5530e535

Example Query

Query with partition filter

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

MCD_PSM_PAX_A_JAR_Toss_event

Fee distribution events from MakerDAO’s PAX-A Peg Stability Module (PSM) jar contract on Ethereum, recording transfers of accumulated stability fees in WAD units (18 decimals) to designated recipients. Used for tracking PSM fee collection and treasury operations.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_usr	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x8bf8b5c58bb57ee9c97d0fea773eee042b10a787	754598720000000000000000	0x8bf8b5c58bb57ee9c97d0fea773eee042b10a787	false	263	19326913	2024-02-28T15:26:59.000Z	0xc52abec700b458a970fb9675eee53f116a59260c260b65df71db2d9c8b8ead5d
0x8bf8b5c58bb57ee9c97d0fea773eee042b10a787	3249999000000000000000000	0x8bf8b5c58bb57ee9c97d0fea773eee042b10a787	false	288	18428516	2023-10-25T16:43:35.000Z	0x2f1dd16389adf1eacead54d8c54b57733c467498290baff333275a48b1b0c0e2
0x8bf8b5c58bb57ee9c97d0fea773eee042b10a787	1000000000000000000	0x8bf8b5c58bb57ee9c97d0fea773eee042b10a787	false	341	18428091	2023-10-25T15:18:11.000Z	0x588c4947ebdcec542a157847d6b964494e1b2d04c25ec8a7701eb5ff18c0e02b

Example Query

Query with partition filter

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

MCDLITEPSMUSDCAJar_Toss_event

Toss events from MakerDAO’s Lite PSM USDC-A Jar contract on Ethereum, recording token transfers with user addresses and amounts in WAD format (18 decimals). Used for tracking PSM (Peg Stability Module) liquidity jar operations and USDC flow analysis.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_usr	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x69ca348bd928a158ade7aa193c133f315803b06e	11131034012125000000000000	0x69ca348bd928a158ade7aa193c133f315803b06e	false	138	21188569	2024-11-14T21:18:23.000Z	0x62033ce0597dc74f7007c53f511b7fe2c5111d003b8b59558970451903a7cb00
0x69ca348bd928a158ade7aa193c133f315803b06e	6944644745594000000000000	0x69ca348bd928a158ade7aa193c133f315803b06e	false	592	23120261	2025-08-11T20:41:59.000Z	0x77045a91697bd14a58c48b7fe306ac93f5e90496410e923e75747c1a7c9f685e
0x69ca348bd928a158ade7aa193c133f315803b06e	12850658450810000000000000	0x69ca348bd928a158ade7aa193c133f315803b06e	false	72	22434129	2025-05-07T20:33:59.000Z	0x8ca355a4bdab6506e57c639a14a6be3d301f00b7fe3696131cdbf03ec8666000

Example Query

Query with partition filter

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

MCDPSMGUSDAJar_Toss_event

Toss events from MakerDAO’s PSM (Peg Stability Module) GUSD jar contract on Ethereum, recording surplus transfers to designated addresses. Tracks DAI-equivalent amounts moved from the PSM’s GUSD module for protocol revenue distribution and surplus management.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_usr	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0xf2e7a5b83525c3017383deed19bb05fe34a62c27	300000000000000000000000	0xf2e7a5b83525c3017383deed19bb05fe34a62c27	false	19	18518567	2023-11-07T07:24:35.000Z	0xbafa65fcc6fd28a20f711b812026c4b7b7e8a13ac185ac49712f22d9cd628f20
0xf2e7a5b83525c3017383deed19bb05fe34a62c27	597659000000000000000000	0xf2e7a5b83525c3017383deed19bb05fe34a62c27	false	236	19205634	2024-02-11T15:12:35.000Z	0x00fcbf1e538b56909198aa9449a01f5f7dcbe09ec26b3dacca981b54943c95ab
0xf2e7a5b83525c3017383deed19bb05fe34a62c27	1000000000000000000	0xf2e7a5b83525c3017383deed19bb05fe34a62c27	false	273	16127786	2022-12-06T19:16:59.000Z	0x28aee96bf3b2b90df4ebd860a2dcbdc4446f5d7a620c338b4b27ccd898c58883

Example Query

Query with partition filter

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

MCDPSMPAXAJar_Toss_event

Revenue distribution events from MakerDAO’s PAXUSD Peg Stability Module (PSM) Jar contract on Ethereum. Tracks fee transfers with amounts in WAD units (18 decimals) paid to designated recipients, used for analyzing PSM revenue generation and distribution patterns.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_usr	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x8bf8b5c58bb57ee9c97d0fea773eee042b10a787	84211270000000000000000	0x8bf8b5c58bb57ee9c97d0fea773eee042b10a787	false	65	19727888	2024-04-24T21:23:35.000Z	0x836e72450183c56cb05009ee7ee64fff6b957ca3777264b35b5870c3431ba5ab
0x8bf8b5c58bb57ee9c97d0fea773eee042b10a787	754598720000000000000000	0x8bf8b5c58bb57ee9c97d0fea773eee042b10a787	false	263	19326913	2024-02-28T15:26:59.000Z	0xc52abec700b458a970fb9675eee53f116a59260c260b65df71db2d9c8b8ead5d
0x8bf8b5c58bb57ee9c97d0fea773eee042b10a787	1159000000000000000000	0x8bf8b5c58bb57ee9c97d0fea773eee042b10a787	false	285	20111964	2024-06-17T14:00:23.000Z	0x75ee5811583faac5c9e22f2d4a4ec58091f9307e63eb4c8c77d5bdb75a6254ce

Example Query

Query with partition filter

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

MetaMorphoV1_UpdateLastTotalAssets_event

MetaMorph vault total assets update events from MakerDAO’s MetaMorpho V1 protocol on Ethereum, recording snapshots of vault asset values denominated in base units. Used to track vault performance, total value locked (TVL) changes, and asset growth over time.

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_updatedTotalAssets`	`STRING`	Updated total value of assets managed by the vault after a state change. String-encoded numeric value representing the total asset amount.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_updatedTotalAssets
0x73e65dbd630f90604062f6e02fab9138e713edd9	false	188	21790024	2025-02-06T21:02:35.000Z	0xe7d276aea478849688eac8ab4570d19b31f4511ca715f712c25aaaf20041f87a	600000000000000000000000001
0x73e65dbd630f90604062f6e02fab9138e713edd9	false	118	20563243	2024-08-19T14:22:59.000Z	0xa227df9cab68fdba3923a929d48c083213b0a3b66881f3f473aa0b4e131a9234	375000000000000000000000001
0x73e65dbd630f90604062f6e02fab9138e713edd9	false	738	22138920	2025-03-27T14:42:35.000Z	0xbe40b2009103917c06d8f6d69e4fe74ab730f190754bc533ad0c21daff8f0027	550000000000000000000000001

Example Query

Query with partition filter

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

RWA007_A_JAR_Toss_event

MakerDAO RWA007-A (Real World Asset) JAR contract Toss events on Ethereum, recording DAI distributions with amounts in WAD format (18 decimals) to the designated user address. Tracks yield distributions from the RWA007 collateral vault for analyzing real-world asset revenue flows in the Maker Protocol.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_usr	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0xef1b095f700be471981aae025f92b03091c3ad47	1787483000000000000000000	0xef1b095f700be471981aae025f92b03091c3ad47	false	164	19942241	2024-05-24T20:52:11.000Z	0x8ef4ebbb5137f9f2f637919c1a94c7c7ed06350d9e0c56476cbfbffa40e164fd
0xef1b095f700be471981aae025f92b03091c3ad47	1273243010000000000000000	0xef1b095f700be471981aae025f92b03091c3ad47	false	89	17115940	2023-04-24T11:46:47.000Z	0xcfcae1ec2480ab4a8ab8363cd019741cb67839b2a56545d3b88b6eef0a3a166b
0xef1b095f700be471981aae025f92b03091c3ad47	2114700000000000000000000	0xef1b095f700be471981aae025f92b03091c3ad47	false	248	18963448	2024-01-08T16:22:23.000Z	0x3a8a7cd8f53970634f9aef901caad1f4a7b6384bac01caf6bf8f29b3f257b7bc

Example Query

Query with partition filter

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

RWA007AJar_Toss_event

Toss events from MakerDAO’s RWA007-A Jar contract on Ethereum, recording DAI distributions to a specific user address with amounts in WAD format (18 decimals). Used for tracking Real World Asset (RWA) vault profit distributions and yield payments.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_usr	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0xef1b095f700be471981aae025f92b03091c3ad47	1463819639810000000000000	0xef1b095f700be471981aae025f92b03091c3ad47	false	208	18500060	2023-11-04T17:08:11.000Z	0x45598797362d5c6e9120f5003578f378da1e8c397780a2cbb46a777d875dc999
0xef1b095f700be471981aae025f92b03091c3ad47	2446883000000000000000000	0xef1b095f700be471981aae025f92b03091c3ad47	false	144	20289210	2024-07-12T08:24:59.000Z	0xf79119ea08f37ea395eb6fcf40823d65f9ecb235b74d2e0d640d757db6a4a6e0
0xef1b095f700be471981aae025f92b03091c3ad47	840623140000000000000000	0xef1b095f700be471981aae025f92b03091c3ad47	false	333	18092665	2023-09-08T15:43:47.000Z	0x491268fbe4770f4afe99a6712e271668ad60dd4ff958e292b476fb431e0ce58d

Example Query

Query with partition filter

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

RWA009_A_JAR_Toss_event

Toss events from MakerDAO’s RWA009-A (Real World Asset) JAR contract on Ethereum, recording token movements with amounts in WAD (18-decimal) format. Used for tracking RWA collateral transfers and vault operations within MakerDAO’s RWA009 facility.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_usr	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x6c6d4be2223b5d202263515351034861dd9afdb6	58202470000000000000000	0x6c6d4be2223b5d202263515351034861dd9afdb6	false	204	16751560	2023-03-04T00:34:59.000Z	0x29b2e9cdb326f236c16b7d47c1408dc3eba44a226b8b9541d26c05392075aa8e
0x6c6d4be2223b5d202263515351034861dd9afdb6	150000000000000000	0x6c6d4be2223b5d202263515351034861dd9afdb6	false	286	24119578	2025-12-29T16:45:23.000Z	0xb386cfebd3005d82a523c7286610a3bb67f8935426cd44265262a88be556c57c
0x6c6d4be2223b5d202263515351034861dd9afdb6	8365518566000000000000000	0x6c6d4be2223b5d202263515351034861dd9afdb6	false	300	24120453	2025-12-29T19:41:11.000Z	0x7070a597c8a121134a654174bf36b0e36a7e240eafeb32e3c11ee3e89292eee5

Example Query

Query with partition filter

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

RWA009AJar_Toss_event

Toss events from MakerDAO’s RWA009-A jar contract on Ethereum, recording real-world asset (RWA) stability fee distributions with user addresses and amounts in WAD format (18 decimals). Used for tracking fee payouts and treasury operations for RWA009 vault holders.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_usr	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x6c6d4be2223b5d202263515351034861dd9afdb6	58202470000000000000000	0x6c6d4be2223b5d202263515351034861dd9afdb6	false	204	16751560	2023-03-04T00:34:59.000Z	0x29b2e9cdb326f236c16b7d47c1408dc3eba44a226b8b9541d26c05392075aa8e
0x6c6d4be2223b5d202263515351034861dd9afdb6	8365518566000000000000000	0x6c6d4be2223b5d202263515351034861dd9afdb6	false	300	24120453	2025-12-29T19:41:11.000Z	0x7070a597c8a121134a654174bf36b0e36a7e240eafeb32e3c11ee3e89292eee5
0x6c6d4be2223b5d202263515351034861dd9afdb6	150000000000000000	0x6c6d4be2223b5d202263515351034861dd9afdb6	false	286	24119578	2025-12-29T16:45:23.000Z	0xb386cfebd3005d82a523c7286610a3bb67f8935426cd44265262a88be556c57c

Example Query

Query with partition filter

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

RWA014_A_JAR_Toss_event

Real-World Asset (RWA) 014-A JAR contract Toss events from MakerDAO on Ethereum, recording token distributions with recipient addresses and amounts in 18-decimal wei format. Used for tracking RWA vault payouts and accounting flows in the MakerDAO collateral system.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_usr	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x71ec6d5ee95b12062139311ca1fe8fd698cbe0cf	1250451700000000000000000	0x71ec6d5ee95b12062139311ca1fe8fd698cbe0cf	false	175	18532954	2023-11-09T07:39:59.000Z	0x5aecbf5ab4bd46f74b8b25b4e1ced29a4d80e6efa01f457a03bc8048a7b786ce
0x71ec6d5ee95b12062139311ca1fe8fd698cbe0cf	2134565390000000000000000	0x71ec6d5ee95b12062139311ca1fe8fd698cbe0cf	false	184	18096902	2023-09-09T05:57:59.000Z	0x91d510655121352c1374a767a493b5082cf3c9a24121d7ce4da46af95d42e430
0x71ec6d5ee95b12062139311ca1fe8fd698cbe0cf	2837259344293000000000000	0x71ec6d5ee95b12062139311ca1fe8fd698cbe0cf	false	204	20686145	2024-09-05T18:21:47.000Z	0xf02e44c4e96ca7aabb69612f9a1492906f9d73327ab5759c45bd84e4dfd717ed

Example Query

Query with partition filter

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

RWA014AJar_Toss_event

Toss events from MakerDAO’s RWA014 (Real World Assets) jar contract on Ethereum, recording DAI stablecoin deposit or withdrawal amounts with user addresses. Used for tracking cash flows and balance changes in MakerDAO’s tokenized real-world asset vaults.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_usr	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x71ec6d5ee95b12062139311ca1fe8fd698cbe0cf	1991074232911000000000000	0x71ec6d5ee95b12062139311ca1fe8fd698cbe0cf	false	290	20270957	2024-07-09T19:14:59.000Z	0x0871933ff991397840605d002773061914956c5e681480ae0a0b82f6002c4cea
0x71ec6d5ee95b12062139311ca1fe8fd698cbe0cf	1201596058606000000000000	0x71ec6d5ee95b12062139311ca1fe8fd698cbe0cf	false	86	19388808	2024-03-08T06:57:59.000Z	0x645de976aa813e8f54c27db12ad0ba1394634cdd2c25cd9d095cd1458ec417f8
0x71ec6d5ee95b12062139311ca1fe8fd698cbe0cf	1986942948224000000000000	0x71ec6d5ee95b12062139311ca1fe8fd698cbe0cf	false	126	19654663	2024-04-14T15:27:23.000Z	0xb4ee9e28698a382a3f84b815dffb7d246f83d3e2c97f719d295b396294ff65b9

Example Query

Query with partition filter

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

RWA015_A_JAR_Toss_event

Toss events from MakerDAO’s RWA015-A JAR (Join Adapter for Real World Assets) contract on Ethereum, recording DAI transfers with amounts in WAD format (18 decimals). Used for tracking DAI movements into and out of the RWA015-A collateral vault for real-world asset backing.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_usr	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0xc27c3d3130563c1171fecc4f76c217db603997cf	1067412517500000000000000	0xc27c3d3130563c1171fecc4f76c217db603997cf	false	210	19464004	2024-03-18T20:18:35.000Z	0x0147132b4a6ec5a410be46076cd52b38bbae4069b9343b8f3c852c52253f7ef6
0xc27c3d3130563c1171fecc4f76c217db603997cf	1730213960000000000000000	0xc27c3d3130563c1171fecc4f76c217db603997cf	false	467	19263323	2024-02-19T17:41:35.000Z	0xb33f703e0d1642fc917ed4b50a14e38d905b23e080b1a5818b6ff947b5b43b96
0xc27c3d3130563c1171fecc4f76c217db603997cf	14639184000000000000000000	0xc27c3d3130563c1171fecc4f76c217db603997cf	false	249	18585496	2023-11-16T15:58:59.000Z	0x573fbd191518d31d39824563334920384cf3a85c1fce49b1ef6e0c87053334af

Example Query

Query with partition filter

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

RWA015AJar_Toss_event

Token distribution events from MakerDAO’s RWA015-A Jar contract on Ethereum, tracking allocations to a single recipient address with amounts in WAD format (18 decimals). Used for monitoring Real-World Asset (RWA) vault fund movements and treasury operations.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_usr	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0xc27c3d3130563c1171fecc4f76c217db603997cf	1808955310000000000000000	0xc27c3d3130563c1171fecc4f76c217db603997cf	false	234	18278977	2023-10-04T18:34:47.000Z	0x97aed5039029100b99900dd03673023dff9228a773adb3cefba09f4bca380d75
0xc27c3d3130563c1171fecc4f76c217db603997cf	1576950610000000000000000	0xc27c3d3130563c1171fecc4f76c217db603997cf	false	482	19792484	2024-05-03T22:11:47.000Z	0xe4f06d599572f21556cc60f2214ea374d2881fcafe12f08dbf348fe236eb437e
0xc27c3d3130563c1171fecc4f76c217db603997cf	2588187360000000000000000	0xc27c3d3130563c1171fecc4f76c217db603997cf	false	234	20292295	2024-07-12T18:43:59.000Z	0xe1ef3dc1d96e5be613e9b322f2cc6082d3b4f03d4ad3db51d591fca9bd94228f

Example Query

Query with partition filter

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

RWAJar_Toss_event

Real-World Asset (RWA) jar balance update events from MakerDAO on Ethereum, recording DAI amounts allocated to user addresses. Tracks stability fee accumulation and collateral management for off-chain assets backing DAI issuance.

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_usr`	`STRING`	User address parameter in MakerDAO contract function calls. Hex-encoded, 0x-prefixed, 42-character string representing an Ethereum address.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

in_usr	in_wad	address	removed	log_index	block_number	block_timestamp	transaction_hash
0x69ca348bd928a158ade7aa193c133f315803b06e	3890657208331000000000000	0x69ca348bd928a158ade7aa193c133f315803b06e	false	218	21581853	2025-01-08T19:28:47.000Z	0x385c17d466f659eff9959ea57e70fa0f7b833fdda5d69823627d14b1c594687a
0x69ca348bd928a158ade7aa193c133f315803b06e	6883756650133000000000000	0x69ca348bd928a158ade7aa193c133f315803b06e	false	481	23333985	2025-09-10T16:52:47.000Z	0xc4593c35a6b4affd9e49dd4a7ab910a4537694a5dacc490c25148c5e1eca1998
0x69ca348bd928a158ade7aa193c133f315803b06e	6944644745594000000000000	0x69ca348bd928a158ade7aa193c133f315803b06e	false	592	23120261	2025-08-11T20:41:59.000Z	0x77045a91697bd14a58c48b7fe306ac93f5e90496410e923e75747c1a7c9f685e

Example Query

Query with partition filter

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

RWAJar_toss_function

No description available.

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_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

RWAJar_void_function

Real-World Asset (RWA) Jar void function calls on MakerDAO’s Ethereum protocol. Tracks administrative operations on RWA collateral vaults, useful for monitoring treasury management and real-world asset integration activity.

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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
120325	true	74967	0xac4c25b2	0x69ca348bd928a158ade7aa193c133f315803b06e	21373383	0x79d844a4e96dd0a64e52046556a6a06019ea330a	2024-12-10T16:45:59.000Z	0xaabc99c0478c9cc1f9faf0d9b9747eea0ec88ca3a38f15aaf6001dacccc5c19d
120325	true	74967	0xac4c25b2	0x69ca348bd928a158ade7aa193c133f315803b06e	22668718	0x79d844a4e96dd0a64e52046556a6a06019ea330a	2025-06-09T18:10:59.000Z	0xf683c7739d8d6dd782b0d53f94b4aa18e792dbd5d539f028522ecb822c32bb42
120325	true	74967	0xac4c25b2	0x69ca348bd928a158ade7aa193c133f315803b06e	22877749	0xa11725106e270090c3335d3da0af6e64f613f988	2025-07-08T23:27:11.000Z	0x2d3717582aa8900efc62eb1b5e235646563357743394c1f02a1d6459f8ea5226

Example Query

Query with partition filter

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

Vat_fold_function

Interest rate update transactions from MakerDAO’s Vat (core vault engine) contract on Ethereum, tracking stability fee accrual for collateral types like ETH-A and BAT-A. Used for analyzing MakerDAO’s monetary policy adjustments and debt accumulation across different vault types.

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_i`	`STRING`	Index or identifier parameter used in protocol operations. Numeric string representing a position, rate, or configuration value.
`in_u`	`STRING`	Address parameter used in MakerDAO Vat contract operations. Hex-encoded, 0x-prefixed, 42-character string.
`in_rate`	`STRING`	Interest rate value used in the protocol operation. Numeric string representation without decimal formatting.

Sample Data

gas	in_i	in_u	status	in_rate	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
542847	0x4241542d41000000000000000000000000000000000000000000000000000000	0xa950524441892a31ebddf91d3ceefa04bf454466	true	338856020310943542127	25610	0xb65337df	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	9494754	0x19c0976f590d67707e62397c87829d896dc0f1f1	0,10,1	2020-02-16T14:41:40.000Z	0x6d11dc217b0e8e486dbae38afadba96b1450e8534564a04bd22b41c1060b8b72
549983	0x4241542d41000000000000000000000000000000000000000000000000000000	0xa950524441892a31ebddf91d3ceefa04bf454466	true	390828476140535445705	25610	0xb65337df	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	9497225	0x19c0976f590d67707e62397c87829d896dc0f1f1	0,10,1	2020-02-16T23:43:57.000Z	0x9318fcdf7311d9e7f55682205943653e413bc2062955f764089a28856cdd55d2
550952	0x4241542d41000000000000000000000000000000000000000000000000000000	0xa950524441892a31ebddf91d3ceefa04bf454466	true	3969642224394386931274	25610	0xb65337df	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	9493483	0x19c0976f590d67707e62397c87829d896dc0f1f1	0,10,1	2020-02-16T10:05:59.000Z	0x55a9c8b2cf104ee6fb27c1defcd86f3d963fa64e4754d34fe23817eef9b1ee43

Example Query

Query with partition filter

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

Vat_fork_function

Collateralized Debt Position (CDP) transfer events from MakerDAO’s Vat core accounting contract on Ethereum, tracking vault position movements between addresses with collateral (dink) and debt (dart) amounts by ilk type. Used for analyzing vault migrations, liquidations, and position management across different collateral types like ETH-A and WBTC-A.

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_ilk`	`STRING`	Collateral type identifier in the MakerDAO system. 66-character hex string including 0x prefix.
`in_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_dst`	`STRING`	Address of the account receiving tokens or assets in the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_dink`	`STRING`	Change in collateral amount (dink) being transferred in the vault fork operation. Denominated in wei (10^-18 units) of the collateral token specified by the ilk parameter.
`in_dart`	`STRING`	Debt amount being transferred or split in this MakerDAO Vat fork operation, denominated in DAI base units (18 decimals). Represented as a string-encoded integer to preserve precision for large values.

Sample Data

gas	in_dst	in_ilk	in_src	status	in_dart	in_dink	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
74309	0xf0a6247e5b28d84d0036b81702c2c9215afd5b96	0x574254432d410000000000000000000000000000000000000000000000000000	0x39306e34ee323b066d5b41f7823e84e44355c679	true	134623908383769910208472	9410785330000000000	34858	0x870c616d	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	12520337	0x5ef30b9986345249bc32d8928b7ee64de9435e39	0,1,1	2021-05-28T03:13:17.000Z	0x739daa881a2f5d2562b31430031685b1200c80236104c9c7f284b2ee6f59fc8c
199147	0x904d6814a02bdf14dd41bf780f0e07179721d96e	0x4554482d41000000000000000000000000000000000000000000000000000000	0xac011f8d0f1cb6fb632974fafac54bf057b9bc99	true	3621479792464170709754	34385846943141320257	63458	0x870c616d	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	11535758	0x5ef30b9986345249bc32d8928b7ee64de9435e39	0,8,1	2020-12-27T12:12:28.000Z	0x5f314bdb137fd5d85118a87426cf57f38158b02c5fbb515bbe877c6bd0976fd3
283772	0xac011f8d0f1cb6fb632974fafac54bf057b9bc99	0x4554482d41000000000000000000000000000000000000000000000000000000	0x5ef0b89002a60c6ddc0ae47887f71e87e6309cff	true	3621479792464170709754	34385846943141320257	71858	0x870c616d	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	11535758	0x3f30c2381cd8b917dd96eb2f1a4f96d91324bbed	0,7,3	2020-12-27T12:12:28.000Z	0x5f314bdb137fd5d85118a87426cf57f38158b02c5fbb515bbe877c6bd0976fd3

Example Query

Query with partition filter

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

Vat_frob_function

MakerDAO Vat contract frob function calls on Ethereum, recording collateralized debt position (CDP) modifications including collateral adjustments (dink) and DAI debt changes (dart) for ETH-A vaults. Used for analyzing vault management activity, liquidations, and debt generation patterns in the MakerDAO protocol.

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_i`	`STRING`	Index or identifier parameter used in protocol operations. Numeric string representing a position, rate, or configuration value.
`in_u`	`STRING`	Address parameter used in MakerDAO Vat contract operations. Hex-encoded, 0x-prefixed, 42-character string.
`in_v`	`STRING`	ECDSA signature component v used for cryptographic verification of signed messages or permits. Integer value representing the recovery identifier, typically 27 or 28.
`in_w`	`STRING`	Address receiving the stablecoin (DAI) generated or repaid in this vault operation. Typically the same as in_u or in_v, representing the vault owner or their designated recipient.
`in_dink`	`STRING`	Change in collateral amount for the vault position measured in wei. Positive values indicate collateral deposits, negative values indicate withdrawals, and zero indicates no collateral change.
`in_dart`	`STRING`	Change in normalized debt (DAI borrowed) for the vault, represented as a signed integer in wei. Positive values indicate DAI generation while negative values indicate debt repayment.

Sample Data

gas	in_i	in_u	in_v	in_w	status	in_dart	in_dink	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
704936	0x4554482d41000000000000000000000000000000000000000000000000000000	0x1b165057119ea48e10dc527adb7c69bd0512fe6e	0x1b165057119ea48e10dc527adb7c69bd0512fe6e	0x1b165057119ea48e10dc527adb7c69bd0512fe6e	true	1074796685777527514268	0	12429	0x76088703	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	10594634	0x5ef30b9986345249bc32d8928b7ee64de9435e39	12,0,1,11,0,4,60,0	2020-08-04T17:21:15.000Z	0xa641ae210ee467a7b9e0c1bc2f83650e4711203cb3012ddf50407255fbbe7cd0
722916	0x4554482d41000000000000000000000000000000000000000000000000000000	0x62a2851197a313901990d277e32cedec0905ecf5	0x62a2851197a313901990d277e32cedec0905ecf5	0x62a2851197a313901990d277e32cedec0905ecf5	true	820249257086425001326	0	12429	0x76088703	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	10594030	0x5ef30b9986345249bc32d8928b7ee64de9435e39	0,11,0,4,57,0	2020-08-04T15:08:12.000Z	0xccec7ee7009804ae805d958ea575e6f7e10e452f00994df7158d693f14bab311
3710630					false			12707	0x76088703	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	10594653	0x5ef30b9986345249bc32d8928b7ee64de9435e39	0,5,0	2020-08-04T17:25:02.000Z	0xfcb09f4ed981422365cd09dabf80743f3e8f13e41bb0e3a86c3caddb2015f63f

Example Query

Query with partition filter

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

Vat_grab_function

Collateral confiscation events from MakerDAO’s Vat contract on Ethereum, recording liquidations where vault positions (identified by collateral type in_i) are seized and transferred between addresses. Used for analyzing liquidation mechanics, vault health, and debt settlement across different collateral types like ETH-A, WBTC-A, and WSTETH-B.

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_i`	`STRING`	Index or identifier parameter used in protocol operations. Numeric string representing a position, rate, or configuration value.
`in_u`	`STRING`	Address parameter used in MakerDAO Vat contract operations. Hex-encoded, 0x-prefixed, 42-character string.
`in_v`	`STRING`	ECDSA signature component v used for cryptographic verification of signed messages or permits. Integer value representing the recovery identifier, typically 27 or 28.
`in_w`	`STRING`	Address of the account receiving collateral or debt being transferred during the vault liquidation operation. Typically set to the MakerDAO surplus buffer contract (0xa950524441892a31ebddf91d3ceefa04bf454466).
`in_dink`	`STRING`	Change in collateral amount for the vault, denominated in the collateral token’s smallest unit (wei-equivalent). Negative values indicate collateral being removed during liquidations or withdrawals.
`in_dart`	`STRING`	Change in normalized debt (dai) for the vault position being modified in this grab operation. Negative values indicate debt reduction during liquidation, while positive values represent debt increases.

Sample Data

gas	in_i	in_u	in_v	in_w	status	in_dart	in_dink	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
566019	0x4554482d41000000000000000000000000000000000000000000000000000000	0xb193973824e26936243dc96d09a8cf13b943a8ba	0xa5679c04fc3d9d8b0aab1f0ab83555b301ca70ea	0xa950524441892a31ebddf91d3ceefa04bf454466	true	-4833270799260178779102	-2676875000000000000	50253	0x7bab3f40	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	12346520	0xa5679c04fc3d9d8b0aab1f0ab83555b301ca70ea	5,2	2021-05-01T05:51:27.000Z	0xac489342aa468cb210df72e61395287821a58a8098b2be9a4ebcb711453422cd
780439	0x5753544554482d42000000000000000000000000000000000000000000000000	0xc737e59ab3e7f07c6cf837c7946e2aa3776a675c	0x3ea60191b7d5990a3544b6ef79983fd67e85494a	0xa950524441892a31ebddf91d3ceefa04bf454466	true	-9660286138802809101273	-5372582034633861092	38653	0x7bab3f40	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	19774544	0x135954d155898d42c90d2a57824c690e0c7bef1b	7,2	2024-05-01T10:00:11.000Z	0xc70be732ee3291f2ed63e06f037b212c9708d45998b0befb7a520434a5a6d88c
1460725	0x5753544554482d41000000000000000000000000000000000000000000000000	0xad2234e08cfffd7d104b14c66f59ee3089c5069f	0x49a33a28c4c7d9576ab28898f4c9ac7e52ea457a	0xa950524441892a31ebddf91d3ceefa04bf454466	true	-519156477233974673934366	-259279894411691235774	50253	0x7bab3f40	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	19774544	0x135954d155898d42c90d2a57824c690e0c7bef1b	3,2	2024-05-01T10:00:11.000Z	0xc70be732ee3291f2ed63e06f037b212c9708d45998b0befb7a520434a5a6d88c

Example Query

Query with partition filter

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

Vat_LogNote_event

No description available.

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_sig`	`STRING`	ECDSA signature authorizing the transaction or order. Structure containing v (recovery identifier), r (first 32 bytes of signature), and s (second 32 bytes of signature) components.
`in_arg1`	`STRING`	-
`in_arg2`	`STRING`	-
`in_arg3`	`STRING`	-
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Vat_move_function

Internal DAI balance transfers within MakerDAO’s Vat core accounting contract on Ethereum, tracking movements of system debt and surplus between addresses in RAD denomination (10^45 precision). Used for analyzing CDP liquidations, stability fee collection, and protocol treasury operations.

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_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_dst`	`STRING`	Address of the account receiving tokens or assets in the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_rad`	`STRING`	Internal accounting amount (rad) being transferred in the Vat move operation, denominated in fixed-point 45-decimal precision. This represents DAI debt or surplus balances within MakerDAO’s core accounting system.

Sample Data

gas	in_dst	in_rad	in_src	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
1685162	0x9759a6ac90977b93b58547b4a71c78317f391a28	3000000000000000000000000000000000000000000000000000	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	true	12843	0xbb35783b	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	22396576	0x9759a6ac90977b93b58547b4a71c78317f391a28	0,0,0,6,4,0	2025-05-02T14:00:23.000Z	0xf84bbb02e89091769f32e593856bb70a9886b1f425fef22ee6e7dfc8e6e3fa1b
1467871	0x9759a6ac90977b93b58547b4a71c78317f391a28	5000000000000000000000000000000000000000000000000000	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	true	8843	0xbb35783b	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	22396576	0x9759a6ac90977b93b58547b4a71c78317f391a28	0,0,0,9,4,0	2025-05-02T14:00:23.000Z	0xf84bbb02e89091769f32e593856bb70a9886b1f425fef22ee6e7dfc8e6e3fa1b
154024	0x1d6e3b4803502ccc9c4f332b0e8e524e5b795d4e	600000000000000000000000000000000000000000000000	0x5e803fcff51cfef0b1cc7e041dcb5fc4aaf8193b	true	27943	0xbb35783b	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	22394655	0x5ef30b9986345249bc32d8928b7ee64de9435e39	0,0,5,0	2025-05-02T07:30:35.000Z	0xf6d153847c402b7a9c98a0939915406430202ae8553d48063465bfa8231ee54f

Example Query

Query with partition filter

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

Vat_suck_function

MakerDAO Vat contract suck function calls on Ethereum that create unbacked DAI debt, transferring internal debt (rad) between two addresses. Used for analyzing protocol bad debt handling, liquidation penalties, and emergency system debt minting.

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_u`	`STRING`	Address parameter used in MakerDAO Vat contract operations. Hex-encoded, 0x-prefixed, 42-character string.
`in_v`	`STRING`	ECDSA signature component v used for cryptographic verification of signed messages or permits. Integer value representing the recovery identifier, typically 27 or 28.
`in_rad`	`STRING`	Unbounded debt amount in MakerDAO’s internal precision (RAD units, 45 decimal places) being transferred in the suck operation. Represents the amount of system debt created or moved between addresses.

Sample Data

gas	in_u	in_v	in_rad	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
154764	0xa950524441892a31ebddf91d3ceefa04bf454466	0x521752d41a21d027d09ebb0654e9541e3118439e	269121498768456940535428862625291807541884702846	true	18064	0xf24e23eb	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	17312325	0xc67963a226eddd77b91ad8c421630a1b0adff270	2,4,3	2023-05-22T04:00:11.000Z	0x2d3450935f0e14d0bbe48c33bc368702177368377136c50292ccbe5da89d2ee8
198874	0xa950524441892a31ebddf91d3ceefa04bf454466	0x197e90f9fad81970ba7976f33cbd77088e5d7cf7	7583117063132486502925265681586858887868209011495	true	27664	0xf24e23eb	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	17312538	0x197e90f9fad81970ba7976f33cbd77088e5d7cf7	1,1,1,0	2023-05-22T04:43:23.000Z	0x99f1bceb2731c6f5f672e30638fafe7ab88242c11fbcbf18529dcdd42160853a
216181	0xa950524441892a31ebddf91d3ceefa04bf454466	0x197e90f9fad81970ba7976f33cbd77088e5d7cf7	18851300167045169635434614568611516816127442727	true	27664	0xf24e23eb	0x35d1b3f3d7966a1dfe207aa4514c12a259a0492b	17317470	0x197e90f9fad81970ba7976f33cbd77088e5d7cf7	1,0	2023-05-22T21:21:23.000Z	0x4ce5372a11dc0ed9858f9b0bfa7314f8348b0622f9c59cb7e743192a144436eb

Example Query

Query with partition filter

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

Vow_file2_function

MakerDAO Vow contract governance parameter updates on Ethereum, tracking file function calls that modify system configuration addresses like flapper and flopper (surplus and debt auction contracts). Used for analyzing protocol governance changes and system parameter evolution over time.

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_what`	`STRING`	Parameter identifier specifying which configuration value or contract address to modify. 66-character hex string including 0x prefix, representing a bytes32 encoded parameter name.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

gas	status	in_data	in_what	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
740556	true	0x4d95a049d5b0b7d32058cd3f2163015747522e99	0x666c6f7070657200000000000000000000000000000000000000000000000000	10298	0xd4e8be83	0xa950524441892a31ebddf91d3ceefa04bf454466	9017707	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	1,0,0,10	2019-11-28T22:02:31.000Z	0x6fd3b8c2873015db136ae6ade1d7941642b9d2e8e6a70d2f624d48981d154be3
1640023	true	0xbf7111f13386d23cb2fba5a538107a73f6872bcf	0x666c617070657200000000000000000000000000000000000000000000000000	51859	0xd4e8be83	0xa950524441892a31ebddf91d3ceefa04bf454466	20770191	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	0,0,0,78	2024-09-17T12:00:23.000Z	0x2221973333bd0c22f8b1b2593fa9817765bafcf65a2d3c25ebde8df06bbd197c
165425	true	0xa4f79bc4a5612bdda35904fdf55fc4cb53d1bff6	0x666c617070657200000000000000000000000000000000000000000000000000	51859	0xd4e8be83	0xa950524441892a31ebddf91d3ceefa04bf454466	14385145	0xbe8e3e3618f7474f8cb1d074a26affef007e98fb	0,0,0,33,0	2022-03-14T14:00:35.000Z	0xb02103d4bc1b130632372adf55017cc000df70a77a70f9f7a588368df22dbabe

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​Cat_Bite_event

​CatV0_Bite_event

​ChainLog_UpdateAddress_event

​D3MHub_Fees_event

​D3MHub_Wind_event

​Dai_burn_function

​Dai_mint_function

​DaiJoin_cage_function

​DaiJoin_deny_function

​DaiJoin_exit_function

​DaiJoin_join_function

​DaiJoin_LogNote_event

​DaiJoin_rely_function

​Dog_Bark_event

​DSProxy_LogSetAuthority_event

​DSProxy_LogSetOwner_event

​DSProxy_setAuthority_function

​DSProxy_setCache_function

​DssLitePsm_BuyGem_event

​DssLitePsm_buyGem_function

​DssLitePsm_buyGemNoFee_function

​DssLitePsm_Chug_event

​DssLitePsm_chug_function

​DssLitePsm_Deny_event

​DssLitePsm_deny_function

​DssLitePsm_Diss_event

​DssLitePsm_diss_function

​DssLitePsm_file_function

​DssLitePsm_Fill_event

​DssLitePsm_fill_function

​DssLitePsm_Kiss_event

​DssLitePsm_kiss_function

​DssLitePsm_Rely_event

​DssLitePsm_rely_function

​DssLitePsm_SellGem_event

​DssLitePsm_sellGem_function

​DssLitePsm_sellGemNoFee_function

​DssLitePsm_Trim_event

​DssLitePsm_trim_function

​DSToken_Burn_event

​DSToken_Mint_event

​IlkRegistry_AddIlk_event

​IlkRegistry_RemoveIlk_event

​Jug_drip_function

​Jug_file_function

​Jug_file2_function

​Jug_file3_function

​MCD_LITE_PSM_USDC_A_JAR_Toss_event

​MCD_PSM_GUSD_A_JAR_Toss_event

​MCD_PSM_PAX_A_JAR_Toss_event

​MCDLITEPSMUSDCAJar_Toss_event

​MCDPSMGUSDAJar_Toss_event

​MCDPSMPAXAJar_Toss_event

​MetaMorphoV1_UpdateLastTotalAssets_event

​RWA007_A_JAR_Toss_event

​RWA007AJar_Toss_event

​RWA009_A_JAR_Toss_event

​RWA009AJar_Toss_event

​RWA014_A_JAR_Toss_event

​RWA014AJar_Toss_event

​RWA015_A_JAR_Toss_event

​RWA015AJar_Toss_event

​RWAJar_Toss_event

​RWAJar_toss_function

​RWAJar_void_function

​Vat_fold_function

​Vat_fork_function

​Vat_frob_function

​Vat_grab_function

​Vat_LogNote_event

​Vat_move_function

​Vat_suck_function

​Vow_file2_function

Tables

Cat_Bite_event

CatV0_Bite_event

ChainLog_UpdateAddress_event

D3MHub_Fees_event

D3MHub_Wind_event

Dai_burn_function

Dai_mint_function

DaiJoin_cage_function

DaiJoin_deny_function

DaiJoin_exit_function

DaiJoin_join_function

DaiJoin_LogNote_event

DaiJoin_rely_function

Dog_Bark_event

DSProxy_LogSetAuthority_event

DSProxy_LogSetOwner_event

DSProxy_setAuthority_function

DSProxy_setCache_function

DssLitePsm_BuyGem_event

DssLitePsm_buyGem_function

DssLitePsm_buyGemNoFee_function

DssLitePsm_Chug_event

DssLitePsm_chug_function

DssLitePsm_Deny_event

DssLitePsm_deny_function

DssLitePsm_Diss_event

DssLitePsm_diss_function

DssLitePsm_file_function

DssLitePsm_Fill_event

DssLitePsm_fill_function

DssLitePsm_Kiss_event

DssLitePsm_kiss_function

DssLitePsm_Rely_event

DssLitePsm_rely_function

DssLitePsm_SellGem_event

DssLitePsm_sellGem_function

DssLitePsm_sellGemNoFee_function

DssLitePsm_Trim_event

DssLitePsm_trim_function

DSToken_Burn_event

DSToken_Mint_event

IlkRegistry_AddIlk_event

IlkRegistry_RemoveIlk_event

Jug_drip_function

Jug_file_function

Jug_file2_function

Jug_file3_function

MCD_LITE_PSM_USDC_A_JAR_Toss_event

MCD_PSM_GUSD_A_JAR_Toss_event

MCD_PSM_PAX_A_JAR_Toss_event

MCDLITEPSMUSDCAJar_Toss_event

MCDPSMGUSDAJar_Toss_event

MCDPSMPAXAJar_Toss_event

MetaMorphoV1_UpdateLastTotalAssets_event

RWA007_A_JAR_Toss_event

RWA007AJar_Toss_event

RWA009_A_JAR_Toss_event

RWA009AJar_Toss_event

RWA014_A_JAR_Toss_event

RWA014AJar_Toss_event

RWA015_A_JAR_Toss_event

RWA015AJar_Toss_event

RWAJar_Toss_event

RWAJar_toss_function

RWAJar_void_function

Vat_fold_function

Vat_fork_function

Vat_frob_function

Vat_grab_function

Vat_LogNote_event

Vat_move_function

Vat_suck_function

Vow_file2_function