Uniswap

In my bid to understanding how APR of a liquidity pool is being calculated, I am forced to take a closer look at the mechanics of liquidity pool rewards. Right now, all I know is that for platforms such as Uniswap, 0.3% of all swap fees will go to liquidity pool rewards, which are then distributed to liquidity providers. The rewards are distributed every block. But there are deeper questions. ...

Dune analytics allows you to query on chain data using SQL queries via its web app. Although execution time is a little slow due to the large data volume (~14s for a simple query, ~1min+ for more complex ones), it is still one of the most useful products for basic on chain analysis I’ve used so far. The prerequisite, though, is that you would need to know a bit of SQL. ...