DODO V2 QA (Ethereum) Schema Version 1.2.0 Subgraph Version 0.2.1 Methodology Version 1.0.0

[bye43]

Description	Value
Subgraph Reviewed	https://subgraphs.messari.io/subgraph?endpoint=https://api.thegraph.com/subgraphs/name/stan36/messari-dodov2-mainnet&tab=protocol
Date Reviewed	July 19 2022
Schema Version	1.2.0
Subgraph Version	0.2.1
Methodology Version	1.0.0
Evidence Spreadsheet	https://docs.google.com/spreadsheets/d/1Kj8WxJjQTCVlEGWtXha7BcAOZftwZNEC/edit?usp=sharing&ouid=113156017090580515789&rtpof=true&sd=true

Metrics To Review

Protocol Metrics

Section	Metric	Issue
financialsDailySnapshots	totalValueLockedUSD	Subgraph data has up to a 60% discrepancy with the official DODO UI.
financialsDailySnapshots	dailyVolumeUSD	Subgraph is significantly more than the official data. Token Terminal data also indicates the trading volume of the protocol (accumulative of all chains) is generally less than 100m per day while the subgraph is outputting volume in the billions
financialsDailySnapshots	cumulativeVolumeUSD	The day to day trading volume derived from the cumulative data is more in line with the actual trading volume from the official website, in terms of scale, i.e. tens of millions USD a day. But I am guessing this is incorrect since the daily is.
financialsDailySnapshots	dailySupplySideRevenueUSD	The shape of the curve from subgraph looks in line with the shape of curve from Token Terminal, but the values are generally too low. Supply side should also be 80% of total revenue IIRC and it seems like it is ~99%.
financialsDailySnapshots	cumulativeSupplySideRevenueUSD	The cumulative data is mathematically in line with the daily data, but the daily values are not correct, so cumulative will not be either
financialsDailySnapshots	dailyProtocolSideRevenueUSD	The protocol-side revenue is not in line with the values derived from the official website data and are too low. It also seems to be around 1% of total revenue when it should be 20% based on Github methodology.
financialsDailySnapshots	cumulativeProtocolSideRevenueUSD	The cumulative data is mathematically in line with the daily data, but the daily values are not correct, so cumulative will not be either
financialsDailySnapshots	dailyTotalRevenueUSD	The total revenue is not in line with the values derived from the official website data and are too low. All revenues (total, protocol, and supply) seem to be too low compared to the DODO UI. QA'er used the top three pools in the UI and derived the revenues based on fee structure and subgraph values were still smaller. This could be because the subgraph is not accounting for the differentiating fees between pools.
financialsDailySnapshots	cumulativeTotalRevenueUSD	The cumulative data is mathematically in line with the daily data, but the daily values are not correct, so cumulative will not be either
usageMetricsDailySnapshots	cumulativeUniqueUsers	Subgraph data is significantly less than dune dashboard, 5.6K users versus 47K on dune dashboard. Link to dune query - https://dune.com/queries/43858/86006
usageMetricsDailySnapshots	dailyActiveUsers	The subgraph data is more than the official website data or the dune analytics data; however, the data from official website site or dune are only the data for the dex and not including the other businesses of Dodoex such as crowpooling. Link to DODO UI - https://info.dodoex.io/overview
usageMetricsDailySnapshots	dailyTransactionCount	The subgraph data are different from the official website data or the dune analytics data; however, the data from official website site or dune are only the data for the dex and not including the other businesses of Dodoex such as crowpooling. Link to DODO UI - https://info.dodoex.io/overview. Link to dune query - https://dune.com/queries/46225/90958
usageMetricsHourlySnapshots	hourlyTransactionCount	This hourly data is identical to the hourly active user data, and as daily transaction data is usually more than daily active user data, this hourly data is not accurate.
usageMetricsHourlySnapshots	hourlySwapCount	This hourly data is identical to the hourly active user data, and as daily transaction data is usually more than daily active user data, this hourly data is not accurate.

Pool Overview

Pool	Metric	Issue
Some Pools	TVL	The subgraph pool overview data is not accurate compared to official website data. Two largest pools are not captured (ALTA/WETH and USDT/USDC) and the top pools by TVL from subgraph have zero liquidity at the time of review, except for only the DAI-USDT pool. Link to DODO UI - https://info.dodoex.io/top
Some Pools	Reward Tokens	Some of the pools are still incentivized, like DAI-USDT pool with DODO, but subgraph is saying 0% incentivized
Some Pools	Base Yield	The basic yields from subgraph are all zero and there are pools with positive yield on DODO UI, such as WBTC/USDC (This pool is also missing from Pool Overview). Link to DODO UI - https://app.dodoex.io/pool/0x2109f78b46a789125598f5ad2b7f243751c2934d?network=mainnet

Pool Metrics

Pool	Section	Metric	Issue
DLP_3058ef90	liquidityPoolDailySnapshots	dailyVolumeUSD	This is 0 and there should be a positive value here
DLP_3058ef90	liquidityPoolDailySnapshots	cumulativeVolumeUSD	The subgraph output is not reflecting a cumulative value and looks more like daily volume, and the value is different from the official website cumulative data of this pool.
DLP_3058ef90	liquidityPoolDailySnapshots	inputTokenBalances [0] - DAI: Dai Stablecoin	Subgraph seems very off from current DODO UI. . Subgraph outputting 3,437,948,546,509,318,000 and DODO UI outputting 3,320,000. Also the in the schema value of inputTokenWeights is outputting 50/50, when the pool is dynamic and is currently 46/54 in the DODO UI. Link to DODO UI- https://app.dodoex.io/pool/0x3058ef90929cb8180174d74c507176cca6835d73?network=mainnet
DLP_3058ef90	liquidityPoolDailySnapshots	inputTokenBalances [1] - USDT: Tether USD	Subgraph seems very off from current DODO UI. Subgraph outputting 3,437,948,546,509,318,000 and DODO UI outputting 3,940,000 . Link to DODO UI- https://app.dodoex.io/pool/0x3058ef90929cb8180174d74c507176cca6835d73?network=mainnet
DLP_3058ef90	liquidityPoolDailySnapshots	stakedOutputTokenAmount - DLP: DLP_3058ef90	This is zero but for this pool there's a staking step to earn rewards.
DLP_3058ef90	liquidityPoolDailySnapshots	rewardTokenEmissionsAmount [0] - DODO: DODO bird	The subgraph data is zero and this pool has a reward.
DLP_3058ef90	liquidityPoolDailySnapshots	rewardTokenEmissionsUSD [0] - DODO: DODO bird	The subgraph data is zero and this pool has a reward.
DLP_3058ef90	liquidityPoolDailySnapshots	baseYield	The subgraph data is zero and this pool should be generating fees via swaps.
DLP_3058ef90	liquidityPoolDailySnapshots	rewardAPR	The subgraph data is zero and this pool has a reward.

Event Metrics

Pool	Section	Issue
DLP_3058ef90	Deposit	Deposit transaction matches Zerion records, but the subgraph data has missing amount and amountUSD.
DLP_3058ef90	Withdraw	Withdraw transaction matches Zerion records, but the subgraph data has missing amount and amountUSD.
DLP_3058ef90	Swap	Each swap transaction can be matched with official website data. However, the "from" column is not accurate and all transactions in the subgraph are from one address.