coinshift_v1_ethereum

Tables

csUSDC_AccrueInterest_event

Interest accrual events from Coinshift’s csUSDC vault on Ethereum, tracking total assets under management and fee shares generated. Used to analyze vault yield performance and fee distribution 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_newTotalAssets`	`STRING`	Updated total asset value in the vault after interest accrual. Numeric string representation of the asset quantity in the vault’s base denomination.
`in_feeShares`	`STRING`	Number of fee shares minted to the protocol during the interest accrual event. Numeric string representation of share quantity.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newTotalAssets
0x7204b7dbf9412567835633b6f00c3edc3a8d6330	false	291	22513049	2025-05-18T23:08:47.000Z	0x7d3a261b0ff3109e4f0296d43c023d248b7739addd51c3abf69ef17031ad84da	996108364571
0x7204b7dbf9412567835633b6f00c3edc3a8d6330	false	200	22513049	2025-05-18T23:08:47.000Z	0x7d3a261b0ff3109e4f0296d43c023d248b7739addd51c3abf69ef17031ad84da	996108375727
0x7204b7dbf9412567835633b6f00c3edc3a8d6330	false	145	22508897	2025-05-18T09:10:59.000Z	0xb938c1ad01dfa585843d71ed9b7ced70e9e4a566799109771e23096858d92fe5	1108323339224

Example Query

Query with partition filter

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

csUSDC_Deposit_event

Deposit events for Coinshift’s csUSDC vault on Ethereum, recording USDC deposits with corresponding share allocations. Tracks depositor addresses, asset amounts (6 decimals), and shares minted (18 decimals) for analyzing vault inflows and share price dynamics.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x7204b7dbf9412567835633b6f00c3edc3a8d6330	false	0xfeed46c11f57b7126a773eec6ae9ca7ae1c03c9a	3000000	0x4095f064b8d3c3548a3bebfd0bbfd04750e30077	2984353341982333319	322	21673097	2025-01-21T13:15:35.000Z	0x6b9638aa4c23bb7f9b41f0a860277bc8f58691a94e57bba72ec2b2be8f6d3758
0x7204b7dbf9412567835633b6f00c3edc3a8d6330	false	0xfeed46c11f57b7126a773eec6ae9ca7ae1c03c9a	3000000	0x4095f064b8d3c3548a3bebfd0bbfd04750e30077	2984377365614432296	498	21672857	2025-01-21T12:27:23.000Z	0x66a2ca6595fb0393c7e48d8bea9e4deebe86dc4b32586b331557b5dd66064825
0x7204b7dbf9412567835633b6f00c3edc3a8d6330	false	0xd24e52c61d68773f3be4117c1f0c1acc4ab130ca	53030657	0xd24e52c61d68773f3be4117c1f0c1acc4ab130ca	52649242501512040552	216	21741820	2025-01-31T03:26:23.000Z	0x88c7be8be65d9db8847d60b9ed65ce7a5ca023bcb5db9290ab7f8a1ff0b88ac2

Example Query

Query with partition filter

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

csUSDC_SetFeeRecipient_event

Fee recipient configuration changes for Coinshift’s csUSDC token contract on Ethereum. Tracks administrative updates to the address designated to receive protocol fees, useful for monitoring governance actions and fee structure 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_newFeeRecipient`	`STRING`	Address of the new fee recipient being set in the contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFeeRecipient
0x7204b7dbf9412567835633b6f00c3edc3a8d6330	false	133	23039868	2025-07-31T15:05:47.000Z	0xc89638aa06856359e26b89f2514ca4e7ba9ca0ec3b67c20fb4ed80ddff0dbb6c	0xc01ba42d4bd241892b813fa8bd4589eaa4c60672

Example Query

Query with partition filter

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

csUSDC_UpdateLastTotalAssets_event

Total asset value updates for Coinshift’s csUSDC vault on Ethereum, tracking the vault’s underlying USDC holdings over time. Used for monitoring vault performance, calculating yields, and analyzing asset management 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_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
0x7204b7dbf9412567835633b6f00c3edc3a8d6330	false	249	21575178	2025-01-07T21:07:47.000Z	0x5b63ba7a68aea3f065ff7c6983ed384a17d4fb09b694d25e6e9b36d31f6d442b	161141441
0x7204b7dbf9412567835633b6f00c3edc3a8d6330	false	259	21575178	2025-01-07T21:07:47.000Z	0x5b63ba7a68aea3f065ff7c6983ed384a17d4fb09b694d25e6e9b36d31f6d442b	20261141441
0x7204b7dbf9412567835633b6f00c3edc3a8d6330	false	171	21945436	2025-02-28T14:27:35.000Z	0x365517bf8274e41188f412d4ddd8e10f6aa37dfa5014fdbe9b0c1d706bacb6b0	4552362664781

Example Query

Query with partition filter

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

csUSDC_Withdraw_event

Withdrawal events from Coinshift’s csUSDC vault on Ethereum, tracking redemptions of vault shares for underlying USDC assets with owner, receiver, and share-to-asset conversion data. Used for analyzing vault outflows, redemption patterns, and liquidity movements.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x7204b7dbf9412567835633b6f00c3edc3a8d6330	false	0xd24e52c61d68773f3be4117c1f0c1acc4ab130ca	4053657606	0xd24e52c61d68773f3be4117c1f0c1acc4ab130ca	3997720598634515787560	133	0xf3d7459c7f6f75252aadf594d2ea74f04b359f82	22100592	2025-03-22T06:20:35.000Z	0x010280cbd130478459a0c8dac9dd1531042dbb9de49f57bfe9a99d6b3bd06722
0x7204b7dbf9412567835633b6f00c3edc3a8d6330	false	0xbd551abbe87464c97b153acb8d21524acb0fdfff	135863	0xbd551abbe87464c97b153acb8d21524acb0fdfff	132821328152807048	368	0xbd551abbe87464c97b153acb8d21524acb0fdfff	22524051	2025-05-20T12:12:23.000Z	0xa7cc0d2774e121228fcc22b9e3831ee700a94e291817ca495db304f0b68137c0
0x7204b7dbf9412567835633b6f00c3edc3a8d6330	false	0x45fb5af0a1ad80ea16c803146eb81844d9972373	762120454	0x45fb5af0a1ad80ea16c803146eb81844d9972373	746446901425997185698	197	0x45fb5af0a1ad80ea16c803146eb81844d9972373	22446026	2025-05-09T12:51:11.000Z	0xbfc61d0dcf01f2805c5f71fcbc25a9e69f7d43538239f3a8173f473a02542591

Example Query

Query with partition filter

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

csUSDL_AccrueInterest_event

Interest accrual events from Coinshift’s csUSDL vault on Ethereum, tracking total asset value updates and protocol fee distribution. Used for calculating yield generation and vault performance 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_newTotalAssets`	`STRING`	Updated total asset value in the vault after interest accrual. Numeric string representation of the asset quantity in the vault’s base denomination.
`in_feeShares`	`STRING`	Number of fee shares minted to the protocol during the interest accrual event. Numeric string representation of share quantity.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newTotalAssets
0xbeefc011e94f43b8b7b455ebab290c7ab4e216f1	false	12	22397088	2025-05-02T15:44:11.000Z	0x4b706ee1345e5593601e0a61b336ef5e00492437d5ffe38bc4bf5455a2603da0	73610661582485321125750482
0xbeefc011e94f43b8b7b455ebab290c7ab4e216f1	false	17	22399297	2025-05-02T23:10:23.000Z	0x0be2dea61492b7db1b6838dbc1dd2a9918e213087c39532555f8a45685deef0f	73886772921883206095234182
0xbeefc011e94f43b8b7b455ebab290c7ab4e216f1	false	17	22399315	2025-05-02T23:14:11.000Z	0xfa90a3d4b05de0a2527994146316f96e247f400e5c2b0a1117a1e0560ad9c466	73893652175335623272095853

Example Query

Query with partition filter

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

csUSDL_Deposit_event

Deposit events from Coinshift’s csUSDL vault contract on Ethereum, tracking user deposits with corresponding asset amounts and share allocations. Used for analyzing vault deposit activity, share price dynamics, and liquidity provider behavior.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0xbeefc011e94f43b8b7b455ebab290c7ab4e216f1	false	0x8077b6f34e9193d5bbb0ef06a73119060534d130	58687772268692976756	0x8077b6f34e9193d5bbb0ef06a73119060534d130	58564339921939170496	196	22366422	2025-04-28T08:38:23.000Z	0x8bb616b5c59cbc9cfe45562893013c8a84a3da2eff3b59e96abaa134c58e9ada
0xbeefc011e94f43b8b7b455ebab290c7ab4e216f1	false	0x8077b6f34e9193d5bbb0ef06a73119060534d130	365818913255100813526	0x8077b6f34e9193d5bbb0ef06a73119060534d130	365049257725912977435	105	22367534	2025-04-28T12:23:11.000Z	0xc2461245a4dc75bf342df47573076a5ef39e61426fabe67b3b2bf62c56cccc2a
0xbeefc011e94f43b8b7b455ebab290c7ab4e216f1	false	0x8077b6f34e9193d5bbb0ef06a73119060534d130	195625830194454367497	0x8077b6f34e9193d5bbb0ef06a73119060534d130	195214360437201960446	209	22366650	2025-04-28T09:24:23.000Z	0x15096ea83aaf161bd020a406fa47aa39390818f06f587a8cc5b981e217a8c26b

Example Query

Query with partition filter

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

csUSDL_OLD_AccrueInterest_event

Interest accrual events from the deprecated Coinshift USDL vault contract on Ethereum, tracking total asset changes and protocol fee distributions. Useful for analyzing historical vault performance and fee generation before contract migration.

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_newTotalAssets`	`STRING`	Updated total asset value in the vault after interest accrual. Numeric string representation of the asset quantity in the vault’s base denomination.
`in_feeShares`	`STRING`	Number of fee shares minted to the protocol during the interest accrual event. Numeric string representation of share quantity.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newTotalAssets
0xbeefc01767ed5086f35decb6c00e6c12bc7476c1	false	199	21432188	2024-12-18T21:46:23.000Z	0x322807670823dedf5b03dea90f59b564a6c815dfbf8e99533ed28bda61a4fa67	15644480708009243782011527
0xbeefc01767ed5086f35decb6c00e6c12bc7476c1	false	81	21432621	2024-12-18T23:13:35.000Z	0x12a31f72d83b20c1d839cc61e37e4e6f664d01cdb06e08596d2439b6f126eafc	15148491663278400460354460
0xbeefc01767ed5086f35decb6c00e6c12bc7476c1	false	689	21429709	2024-12-18T13:26:59.000Z	0x92087f34b165cfbe1ab22d36e205de7d9088340c2619c4340528c6d9db50a155	16644282494299479332780487

Example Query

Query with partition filter

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

csUSDL_OLD_Deposit_event

Deposit events from Coinshift’s deprecated csUSDL vault contract on Ethereum, recording user deposits with asset amounts and corresponding vault share allocations. Used for tracking historical vault deposit activity and share-to-asset conversion ratios.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0xbeefc01767ed5086f35decb6c00e6c12bc7476c1	false	0x733c33339684f38c8aada0434751611e168255c4	500000000000000000000	0x4095f064b8d3c3548a3bebfd0bbfd04750e30077	499967299572812802361	240	21364109	2024-12-09T09:40:23.000Z	0xb874c76748474d21f59fe60935d245a940c840f472674ab963249d9301dc5b79
0xbeefc01767ed5086f35decb6c00e6c12bc7476c1	false	0xa77d05335d7c1a913c7708fb4f22340be3abed55	500000000000000000000	0x4095f064b8d3c3548a3bebfd0bbfd04750e30077	499967302561148596524	614	21364074	2024-12-09T09:33:23.000Z	0x2ff6a544f7a157cb92b912c0d22a352ab7ad61b5ca59c45d609efdc1d8e8c3fd
0xbeefc01767ed5086f35decb6c00e6c12bc7476c1	false	0x9aa2de29f9eed06436b346c071ab4bd14ad9ba75	20503481324575865035404	0x4095f064b8d3c3548a3bebfd0bbfd04750e30077	20495812653752418299562	363	21446543	2024-12-20T21:53:11.000Z	0xadd49570e06ef20330ce1095b873c7829635879a720b2c89f62d7348dc27f605

Example Query

Query with partition filter

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

csUSDL_OLD_SetFeeRecipient_event

Fee recipient change events for the deprecated csUSDL token contract on Ethereum. Tracks administrative updates to the address that receives protocol fees from the Coinshift USD Liquid staking token.

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_newFeeRecipient`	`STRING`	Address of the new fee recipient being set in the contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFeeRecipient
0xbeefc01767ed5086f35decb6c00e6c12bc7476c1	false	157	20919546	2024-10-08T08:04:47.000Z	0x0aca9509d6e210ddb5dc1f2f0e021916670d7f800c833cf6b796074054e59c8a	0x255c7705e8bb334dfcae438197f7c4297988085a
0xbeefc01767ed5086f35decb6c00e6c12bc7476c1	false	211	20941264	2024-10-11T08:43:47.000Z	0x895dfa279a67672e75c42889905ab3d426e4b68c0a99f3e5cf275c14acc8e97c	0xc01ba42d4bd241892b813fa8bd4589eaa4c60672

Example Query

Query with partition filter

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

csUSDL_OLD_UpdateLastTotalAssets_event

Historical event logs tracking total asset value updates for the deprecated csUSDL (Coinshift USD Liquid) vault contract on Ethereum. Used for analyzing vault asset fluctuations and rebalancing activity before protocol migration.

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
0xbeefc01767ed5086f35decb6c00e6c12bc7476c1	false	239	21357252	2024-12-08T10:43:47.000Z	0xab95fb5c2442015c5fd18e9c4160aec6993468c061ba1f1d70d7ecca75e16433	10297378559752741369273721
0xbeefc01767ed5086f35decb6c00e6c12bc7476c1	false	622	21355169	2024-12-08T03:44:59.000Z	0x923e686362282f707bb7a074427dc3ab4f2dc3803ddab148e873baae1eb60b5e	10292387500021858709780558
0xbeefc01767ed5086f35decb6c00e6c12bc7476c1	false	133	21359353	2024-12-08T17:45:47.000Z	0x3f2df88091a5a82d45c2c6565d161775ba160b9d8bb8f0713ba6c6a0fa585147	10549663768629286216733719

Example Query

Query with partition filter

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

csUSDL_OLD_Withdraw_event

Withdrawal events from Coinshift’s deprecated csUSDL vault contract on Ethereum, recording share redemptions with asset amounts, owners, and receivers. Used for tracking historical vault exits and liquidity movements before contract migration.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0xbeefc01767ed5086f35decb6c00e6c12bc7476c1	false	0x1259f1511a0579b88bf18cf05e179eed4e37432f	320000000000000000000	0x4095f064b8d3c3548a3bebfd0bbfd04750e30077	319835115938200419367	495	0x1259f1511a0579b88bf18cf05e179eed4e37432f	21472828	2024-12-24T14:09:11.000Z	0xe4bf4070d06298981185a53fdc55f7da535d7782e6a0e97c37512a7bb52d6c64
0xbeefc01767ed5086f35decb6c00e6c12bc7476c1	false	0x98ec5a9996571219925cd82edbea064d81fed182	412707157723036244509	0x4095f064b8d3c3548a3bebfd0bbfd04750e30077	412503148909941698879	588	0x98ec5a9996571219925cd82edbea064d81fed182	21468974	2024-12-24T01:12:35.000Z	0xd833502c7956c449f596bf93c3f8804e4f97018c251509d46c22ff1d3bd06cf6
0xbeefc01767ed5086f35decb6c00e6c12bc7476c1	false	0x7f677cff258702ddb349d227e46991d5a3277b4d	1972518997061741428763	0x4095f064b8d3c3548a3bebfd0bbfd04750e30077	1967661942985012032673	385	0x7f677cff258702ddb349d227e46991d5a3277b4d	21943471	2025-02-28T07:52:35.000Z	0x08de405ae90691b133dffd540077f0720a0097a51b9dbd1afece79639a61c443

Example Query

Query with partition filter

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

csUSDL_SetFeeRecipient_event

Fee recipient configuration changes for the Coinshift csUSDL token contract on Ethereum. Tracks administrative updates to the address designated to receive protocol fees, useful for monitoring fee structure changes and treasury 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_newFeeRecipient`	`STRING`	Address of the new fee recipient being set in the contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFeeRecipient
0xbeefc011e94f43b8b7b455ebab290c7ab4e216f1	false	374	21452150	2024-12-21T16:42:35.000Z	0x6f3a317792f83c3ed8f4f7ac3fe5e1087250ee8b2e6acb6d0ab58d70429c7321	0x255c7705e8bb334dfcae438197f7c4297988085a

Example Query

Query with partition filter

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

csUSDL_UpdateLastTotalAssets_event

Total asset value updates for Coinshift’s csUSDL vault contract on Ethereum. Tracks vault rebalancing events with asset amounts in wei for monitoring vault performance and total value locked 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_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
0xbeefc011e94f43b8b7b455ebab290c7ab4e216f1	false	95	21676430	2025-01-22T00:25:23.000Z	0x21c992138f6954a4daa2ab1db85c24919dc73746320236885e81014ac93fa1d3	15617522528633938232156590
0xbeefc011e94f43b8b7b455ebab290c7ab4e216f1	false	85	21676430	2025-01-22T00:25:23.000Z	0x21c992138f6954a4daa2ab1db85c24919dc73746320236885e81014ac93fa1d3	15616514074558750826574471
0xbeefc011e94f43b8b7b455ebab290c7ab4e216f1	false	117	21679481	2025-01-22T10:38:23.000Z	0x6fb8476a05916220f3c4a2ee0e68bb8bd6f6eba1f6f297a5a338fcbb335b2475	15717644599019651640357789

Example Query

Query with partition filter

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

csUSDL_Withdraw_event

Withdrawal events from Coinshift’s csUSDL vault on Ethereum, recording redemptions where users burn shares to receive underlying assets. Tracks sender, owner, receiver addresses along with share and asset amounts for analyzing vault outflows and user redemption 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0xbeefc011e94f43b8b7b455ebab290c7ab4e216f1	false	0x9deff269b22849889cae9a965769f576a1e72d27	49534610587880176333984	0x4095f064b8d3c3548a3bebfd0bbfd04750e30077	49433476706362652163770	440	0x9deff269b22849889cae9a965769f576a1e72d27	22282509	2025-04-16T15:39:47.000Z	0xca7273c27ea24100f2b81318caa17277982e2c0accae2ac66effa4393d5a548b
0xbeefc011e94f43b8b7b455ebab290c7ab4e216f1	false	0x9deff269b22849889cae9a965769f576a1e72d27	100587728451542521217787	0x4095f064b8d3c3548a3bebfd0bbfd04750e30077	100382481931001231677368	233	0x9deff269b22849889cae9a965769f576a1e72d27	22281033	2025-04-16T10:42:59.000Z	0x825e4a2b6aa8019d13d88c533ecee11eddd9c5608961e92219ecd6a68f5ee224
0xbeefc011e94f43b8b7b455ebab290c7ab4e216f1	false	0xabfe00f81c2b9734c2fecec3f1996e18611ce658	19604821644520724522	0x4095f064b8d3c3548a3bebfd0bbfd04750e30077	19563248850233413708	364	0xabfe00f81c2b9734c2fecec3f1996e18611ce658	22405780	2025-05-03T20:56:11.000Z	0xc42c219a5d5b339657b24f347655740da5c38337750a69593c09e09a5c9967ba

Example Query

Query with partition filter

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

wUSDL_Deposit_event

Deposit events from the wUSDL (wrapped USDL) token vault on Ethereum, recording user deposits with deposited asset amounts and corresponding share tokens minted. Useful for tracking capital inflows and share-to-asset exchange rates 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x7751e2f4b8ae93ef6b79d86419d42fe3295a4559	false	0x7f72d8e4d53a9acc52e40c01d504c9ed7099b512	499511165892773150720	0x7f72d8e4d53a9acc52e40c01d504c9ed7099b512	492817377007584209867	360	21780386	2025-02-05T12:46:59.000Z	0x36e605adb98dc37aeba56b60189f0a5a6ffdaeec1a9afcb0b943792cb48398aa
0x7751e2f4b8ae93ef6b79d86419d42fe3295a4559	false	0xe902f9d2c12833d431c528937658e25b51828fe0	5028000000000000000000	0xe902f9d2c12833d431c528937658e25b51828fe0	4991043147724805981006	169	21357250	2024-12-08T10:43:23.000Z	0xd2f9ca73f4efcbb0c6ed681a402bccfc5038836ab78bbfa9a697bbd5dbe976cf
0x7751e2f4b8ae93ef6b79d86419d42fe3295a4559	false	0x7929db30dcfa2d2fbfbe60b2c579b218555d88b3	254181101593840284860415	0x7929db30dcfa2d2fbfbe60b2c579b218555d88b3	252285192822568327578903	135	21359351	2024-12-08T17:45:23.000Z	0x46f5cfe2d429c7767bdc118e5d5b570f24de63410428ee7a23f5454bc00d01a7

Example Query

Query with partition filter

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

wUSDL_Withdraw_event

Withdrawal events from the wUSDL (Wrapped USDL) vault contract on Ethereum, recording share redemptions for underlying assets with owner, receiver, and exchange rate data. Useful for tracking vault outflows and analyzing user redemption 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x7751e2f4b8ae93ef6b79d86419d42fe3295a4559	false	0x8077b6f34e9193d5bbb0ef06a73119060534d130	24685385943815938004	0x8077b6f34e9193d5bbb0ef06a73119060534d130	24120595047368238683	467	0x6953358517e9a5cc92274d1dd746a470654d37c2	22464681	2025-05-12T03:56:35.000Z	0xf09c191f80fe8ce47d6ab3fb1c5c7c959248ec58ddc42f467c2dac35d856d427
0x7751e2f4b8ae93ef6b79d86419d42fe3295a4559	false	0x8077b6f34e9193d5bbb0ef06a73119060534d130	371663267978789269511	0x8077b6f34e9193d5bbb0ef06a73119060534d130	363159774017780001702	439	0xd4e9b0d466789d7f6201442eeccba6a75a552db0	22466151	2025-05-12T08:54:23.000Z	0x4ff0d31947aedab334e96d7edc01622bea2d1810d64c6f6bcbff99acc6b8d63e
0x7751e2f4b8ae93ef6b79d86419d42fe3295a4559	false	0x8077b6f34e9193d5bbb0ef06a73119060534d130	14100783666057720339	0x8077b6f34e9193d5bbb0ef06a73119060534d130	13776793736776930132	363	0x76c5f6918c8e02ca3a51da78604d0883e524482e	22469368	2025-05-12T19:48:35.000Z	0x735f29aec8020c8e6935175b8ed5a5b4a7e1a356e17f56de8cdad8573b574645

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

csUSDC_AccrueInterest_event

csUSDC_Deposit_event

csUSDC_SetFeeRecipient_event

csUSDC_UpdateLastTotalAssets_event

csUSDC_Withdraw_event

csUSDL_AccrueInterest_event

csUSDL_Deposit_event

csUSDL_OLD_AccrueInterest_event

csUSDL_OLD_Deposit_event

csUSDL_OLD_SetFeeRecipient_event

csUSDL_OLD_UpdateLastTotalAssets_event

csUSDL_OLD_Withdraw_event

csUSDL_SetFeeRecipient_event

csUSDL_UpdateLastTotalAssets_event

csUSDL_Withdraw_event

wUSDL_Deposit_event

wUSDL_Withdraw_event

​Tables

​csUSDC_AccrueInterest_event

​csUSDC_Deposit_event

​csUSDC_SetFeeRecipient_event

​csUSDC_UpdateLastTotalAssets_event

​csUSDC_Withdraw_event

​csUSDL_AccrueInterest_event

​csUSDL_Deposit_event

​csUSDL_OLD_AccrueInterest_event

​csUSDL_OLD_Deposit_event

​csUSDL_OLD_SetFeeRecipient_event

​csUSDL_OLD_UpdateLastTotalAssets_event

​csUSDL_OLD_Withdraw_event

​csUSDL_SetFeeRecipient_event

​csUSDL_UpdateLastTotalAssets_event

​csUSDL_Withdraw_event

​wUSDL_Deposit_event

​wUSDL_Withdraw_event

Tables

csUSDC_AccrueInterest_event

csUSDC_Deposit_event

csUSDC_SetFeeRecipient_event

csUSDC_UpdateLastTotalAssets_event

csUSDC_Withdraw_event

csUSDL_AccrueInterest_event

csUSDL_Deposit_event

csUSDL_OLD_AccrueInterest_event

csUSDL_OLD_Deposit_event

csUSDL_OLD_SetFeeRecipient_event

csUSDL_OLD_UpdateLastTotalAssets_event

csUSDL_OLD_Withdraw_event

csUSDL_SetFeeRecipient_event

csUSDL_UpdateLastTotalAssets_event

csUSDL_Withdraw_event

wUSDL_Deposit_event

wUSDL_Withdraw_event