[verify] Compare subgraph volumes with dune ones

[GabrielCamba]

Compare subgraph results with data from dune dashboards
Look for data matching and if it's not, figure out where the discrepancy comes from.

[GabrielCamba]

https://docs.google.com/spreadsheets/d/1_d54ISui3J7rD3r4ji89KtdOlqxDAlXVP9p9NWZbLrY/edit?usp=sharing

[elena-zh]

I have verified 1 day 08/06/2022 where deviation was about 45% between Dune and Graph data.
You can see results in this doc https://docs.google.com/spreadsheets/d/19lhovgGurE4J_Vt0Vbp3hGrSWO_06bnwpiXeV7_kBIE/edit#gid=1145393494&fvid=1093969745

The main issue from my analysis is that deviation is caused by missing USD estimations for transactions.
For this day 08/06/2022:

• 35 transactions (8.5%) do not have USD estimation
• Discrepancy amount (no USD estimation) - 40 806 096 $ (44,2%)
• Main transaction with missing estimation: 0xc519f4f83969f7d61ec9da8722f4855a718f61b050df3f34a23903abb8b38fa5 with 40 283 946 $
• Discrepancy without this transaction: 638 965$ (1.23%)
• Additional concern: there are 27 transactions with deviation in USD estimation from 10 to 99.999%, so it would be great to validate them.

Btw, if analyze data per Sell/But USD estimations,

• USD estimation for Sell amount in 65 transactions are missing (15.9%)
• USD estimation for Sell amount in 149 transactions are missing (36.4%)
   
   
  I have to notice, that 6 transactions from Dune do not have USD estimations as well.