Methodology

Calculate the LP balances at the start of each week (Not taking LP token transfers into consideration) For each LPer address look for activity during the week Group based on activity and multiply by their respective balance

USD values are estimates based on the average price of the underlying assets within the week based on asset amounts received on withdrawal. In case USD prices are missing for some assets in a pool (e.g. 1/2) expect the value to be lower in relation to the fraction of missing assets

Params

pool_id => The Id of the pool to look at activity_type => Type of activity that is expected from the user to show as true

Pick from: ANY (sent any tx) STAKE (delegations) LP (LP like add, bond, remove) SWAP (swapped some assets)

(All of these require a tx to be sent from the respective wallet in order to exclude auto compounding)

Note

This depends on a rough estimate of share value (gamm -> assets), as well as just weekly averaged pricing.

This leads to high inaccuracy when prices are volatile!

Due to those issues look at the trend more than the actual absolute values!