Skip to main content

​
Tables

​
MarginPool_TransferToPool_event

Asset deposits into Ribbon Finance margin pools emitted when users transfer collateral to the pool contract. Records user address, asset contract address, and deposit amount for tracking collateral movements in options vault strategies.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressin_userremovedin_assetin_amountlog_indexblock_numberblock_timestamptransaction_hash
0xccf6629aeab734e621cc59ebb0297196774fdb9d0x6bf686d99a4ce17798c45d09c21181fac29a9fb3false0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be1003968183743146040228910296217952023-05-05T09:57:11.000Z0x7da540e67c9399ac5639b077289c0acb81860c821292d466b4d8c4c71bdeb45e
0xccf6629aeab734e621cc59ebb0297196774fdb9d0x98d03125c62dae2328d9d3cb32b7b969e6a87787false0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7129057207007243359561704296216882023-05-05T09:53:36.000Z0xa8c0ad287d42fec31c5379242331c60bd5556c72ca5f7ed3ac2c7c127254be56
0xccf6629aeab734e621cc59ebb0297196774fdb9d0x98d03125c62dae2328d9d3cb32b7b969e6a87787false0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7118612245595825155412464346358452023-09-01T09:56:10.000Z0x6ff89c607befb460785f4611490d47c9024ca66abe59c6689e4c13061bc487f8
Query with partition filter
SELECT *
FROM `tt-contracts.ribbon_v1_avalanche.MarginPool_TransferToPool_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
MarginPool_TransferToUser_event

Asset transfer events from Ribbon Finance margin pool contracts recording withdrawals to user accounts. Contains user address, asset token address, and transfer amount for tracking collateral movements and liquidity operations.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressin_userremovedin_assetin_amountlog_indexblock_numberblock_timestamptransaction_hash
0xccf6629aeab734e621cc59ebb0297196774fdb9d0x98d03125c62dae2328d9d3cb32b7b969e6a87787false0xb31f66aa3c1e785363f0875a1b74e27b85fd66c725652425998967992111304672101648172022-01-28T10:57:29.000Z0xa00479d59ba907c6229bc2c00aae3af817a2aa938b90487a5331d80fac822b48
0xccf6629aeab734e621cc59ebb0297196774fdb9d0x6bf686d99a4ce17798c45d09c21181fac29a9fb3false0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be92647906522644289610421239999292022-12-23T09:10:07.000Z0xd9c5a2099b26e14b468b679ea5bcf7ebc66b679e1fb601c7da899f9b722b10b6
0xccf6629aeab734e621cc59ebb0297196774fdb9d0x98d03125c62dae2328d9d3cb32b7b969e6a87787false0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7201200056615543176144181239999302022-12-23T09:10:09.000Z0xe853b2c4d53a5a480529c24268161b41ad7f715a722ab02fe9cefbfc4df0e3c0
Query with partition filter
SELECT *
FROM `tt-contracts.ribbon_v1_avalanche.MarginPool_TransferToUser_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100