kaiblade
Total Value Locked
Jun 30, 2022 - Q1. What is the total value locked in the Opyn Squeeth (osQETH) contract? And where does osqeth draw its value from
Merkle Trade Perp Trades Schema And Validation
May 22, 2024 - The table contains all the perpetual trades on the Merkle trade protocol.
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.
Pooly NFTs
Jun 22, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
Merkle ez_withdraws & ez_deposits tables validation
Jun 30, 2024 - These tables contain all Merkle liquidity pool deposits and withdraws data.
![NFL All Day Tournament [Round 1]](https://res.cloudinary.com/dsr37ut2z/image/url2png/c_crop,g_north_west,h_600,q_auto,w_1200,x_0,y_0/v1675649905/https://next.flipsidecrypto.xyz/previews/dashboards/387ef6ba-cc54-443d-8620-32356b233f90%3Ftype%3Dcover "NFL All Day Tournament [Round 1]")
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.
User Retention: NEAR, Arbitrum, Optimism
Oct 23, 2023 - The aim of this dashboard is to compare user retention associated with dapps used on NEAR and airdrops claimed on L2 networks I.e. Arbitrum and Optimism. Cohort analysis would be primarily used to do the user retention analysis. [Cohort analysis](https://www.heavy.ai/technical-glossary/cohort-analysis) is an analytical technique that categorizes and divides data into groups with common characteristics prior to analysis.
Elliptic Seize Order 34-23 Analysis
Nov 2, 2023 - This dashboard will only do an analysis of seize order 34-23 as reported by Elliptic. I will focus on analysing the inflows to the top 2 wallet addresses with the highest inflow volume in USD. The intention is to use the observations from the analysis to debunk the $94 million stated to be funding terrorism by Hamas, Palestinian Islamic Jihad (PIJ) and Hezbollah.
