bye43

Results 58 issues of bye43

It looks like the on the day of the Euler hack the subgraph is capturing a liquidation of ~8B, but the total TVL recorded is about ~200M. ![Screenshot 2023-10-10 at...

@harsh9200 Looks like another pricing error on 08/29 causing this spike in volume from the `0x2bbf681cc4eb09218bee85ea2a5d3d13fa40fc0c` pool. [Query](https://api.thegraph.com/subgraphs/name/messari/balancer-v2-ethereum/graphql?query=%7B%0A++liquidityPoolDailySnapshots+%28orderBy%3A+dailyVolumeUSD%2C+orderDirection%3A+desc%29+%7B%0A++++timestamp%0A++++pool+%7B%0A++++++name%0A++++++id%0A++++++inputTokens+%7B%0A++++++%09name%0A++++++%09id%0A++++++%09lastPriceUSD%0A+++%09+%7D%0A++++%7D%0A++++dailyVolumeUSD%0A++%7D%0A%7D) ![balancer-v2-dailyVolumeUSD-100223](https://github.com/messari/subgraphs/assets/107651107/47f78965-8202-4138-b3e5-67cad105f031)

bug

p1
new subgraph

```[tasklist] ### Tasks - [ ] https://github.com/messari/subgraphs/issues/2319 ```

p1
new subgraph

Two spikes in the billions ![ellipses-finance-dailyVolumeUSD-062123](https://github.com/messari/subgraphs/assets/107651107/1f45691b-3dba-446d-b347-e9df7bace7e1) - Looks like the first on 5/29/2021 is due to the pricing of [`0x160caed03795365f3a589f10c379ffa7d75d4e76`](https://api.thegraph.com/subgraphs/name/messari/sushiswap-bsc/graphql?query=%7B%0A++liquidityPool+%28id%3A+%220x2905817b020fd35d9d09672946362b62766f0d69%22%29+%7B%0A++++name%0A++++id%0A++++swaps+%28orderBy%3A+amountInUSD%2C+orderDirection%3A+desc%2C+where%3A%7Btimestamp_gt%3A1677715200%2C+timestamp_lt%3A+1677801599%7D%2C+first%3A+1%29+%7B%0A++++++hash%0A++++++tokenIn+%7B%0A++++++++name%0A++++++++id%0A++++++%7D%0A++++++tokenOut+%7B%0A++++++++name%0A++++++++id%0A++++++%7D%0A++++++amountInUSD%0A++++++amountOutUSD%0A++++%7D%0A++%7D%0A%7D) - Second one on 07/15/2022 is due to [`0x6dbebd8fa691124e48829de1805be681920fbadf`](https://api.thegraph.com/subgraphs/name/messari/ellipsis-finance-bsc/graphql?query=%7B%0A++liquidityPoolDailySnapshots+%28orderBy%3A+dailyVolumeUSD%2C+orderDirection%3A+desc%2C+where%3A%7Btimestamp_gt%3A+1657843200%2C+timestamp_lt%3A+1657929599%7D%29+%7B%0A++++pool+%7B%0A++++++name%0A++++++id%0A++++%7D%0A++++dailyVolumeUSD%0A++%7D%0A%7D)

bug
p2

```[tasklist] ### Deployment QA Status - [ ] Optimism ```

new subgraph

In subgraphs.xyz: ![Screenshot 2023-06-30 at 1 16 46 PM](https://github.com/messari/subgraphs/assets/107651107/042fa7dc-c56f-4f76-91be-274693ddbf2a) On Messari FE where we sum up `poolSnapshots` to get the protocol level values ![Screenshot 2023-06-30 at 1 16 10 PM](https://github.com/messari/subgraphs/assets/107651107/11cfd919-ebdf-49b4-9051-70a640db2653)...

bug
p1

@tnkrxyz Was investigating some protocols and noticed that Arrakis Finance OP has a really high withdraw values, which after further exploration makes sense for liquidity mining, but some of the...

data quality

> [Optimism](https://subgraphs.messari.io/subgraph?endpoint=https://api.thegraph.com/subgraphs/id/QmedgxwpsTaeGpeHRwgFSkrLMpx7wvUTim7W1wfThnjrWu&tab=protocol): Looks like there was a [liquidity deposit of ~$13.5mil USDC on Nov-11-2022](https://optimistic.etherscan.io/tx/0x19fe364924d456a6b4c7b3effe7046c0bd98c2d25a0af20370bcc9d3cc17de95) which was later [withdrawn on Nov-14-2022](https://optimistic.etherscan.io/tx/0xdac8794b52524b0e80cf97504e3e1dc2e3609dde8458f97c3877809c4484433c), so the spike in TVL looks legit. > However, the...

data quality
p1

@steegecs took a quick look at all the uni v2 forks on @dmelotik hosted service and here is the list of the ones that looks wrong ```[tasklist] ### Deployments -...

data quality
p0