Uniswap V3 position data since inception was obtained from Flipside crypto's Uniswap V3 positions and Uniswap V3 poool stats tables. The following steps were then taken to obtain the daily number of in-range positions:
- Classifying a position as inactive when the most recent entry in the positions table has the 'is_active' equal to False. If inactive, the position is no longer considered in the analysis unless a new position is added at a later date.
- Removing positions if they supply no liquidity (the liquidity_adjusted field is zero).
- Classifying positions as out of range if the daily price is greater than the position upper price, or less than the position's lower price.