kaiblade
Merkle Trade Perp Trades Schema And Validation
May 22, 2024 - The table contains all the perpetual trades on the Merkle trade protocol.
Merkle ez_withdraws & ez_deposits tables validation
Jun 30, 2024 - These tables contain all Merkle liquidity pool deposits and withdraws data.
Aptos governance (staking pool balances) schema and validation
Apr 19, 2024 - Staking pool balances as extracted from changes logs ( i.e. aptos.core.fact_changes table) when an individual makes a staking action. To calculate balance at a point in time, isolate a single record for each pool. This table is transactional-based, so balances are updated with every staking event by users. Note - the amount in balance is decimal adjusted by 10^8.
Aptos governance (votes and proposal creation) schema and validation
Mar 30, 2024 - Staking pool balances as extracted from changes logs ( i.e. `aptos.core.fact_changes`) when an individual makes a staking action. To calculate balance at a point in time, isolate a single record for each pool. This table is transactional-based, so balances are updated with every staking event by users. Note - the amount in balance is decimal adjusted by 10^8.
Proposed NFT Schema
Dec 18, 2023 - The tables shown under this schema are ez_nft_sales and ez_nft_mints. I opted to use the Ethereum ez_nft_sales schema for the Aptos table as I observed the structure of Aptos transactions has a lot in common with the structure of the transactions on Ethereum and other EVM chains. Due to the complexity of the queries and the large volume of data generated, only 10,000 rows of data will be displayed for each table.