kaiblade
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.
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.