# Historical Fee Change Data Dump

**URL:** <https://gov.bancor.network/t/historical-fee-change-data-dump/3415>\
**Category:** Data and Analysis\
**Created:** [February 7, 2022, 4:26am UTC](https://gov.bancor.network/t/historical-fee-change-data-dump/3415 "2022-02-07T04:26:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![NIX](https://avatars.discourse-cdn.com/v4/letter/n/a183cd/32.png) [@NIX](https://gov.bancor.network/u/NIX)\
**Post date:** [February 7, 2022, 4:26am UTC](https://gov.bancor.network/t/historical-fee-change-data-dump/3415/1 "2022-02-07T04:26:16Z")

</div>

# Historical Fee Change Data Dump

TLDR; We are currently experimenting with changes to the fee rate on many different pools. This data repository can be used to observe the historical average daily volume and daily fees generated in the time period of each fee.

Two folders within [Fee Changes](https://drive.google.com/drive/folders/1Z2FrpxOxCcIzoFVmxK9zYdU83Hze8AzD?usp=sharing) :

1. Avg Daily Vol-Fees at Each Rate:

- Historical fee changes and the average daily volume and fees at each rate
- Great overview for historical fee changes

1. Avg 30d VolFees:

- Average daily volume and fees for the most recent 30 days (above) vs the previous 30 days (below - i.e. 60 to 30 days ago).
- Most useful for pools currently being experimented with

## Intro

Since the launch of v2.1, we have had over 200 pools added to Bancor of which about 160 are whitelisted. During this time, we have implemented approximately 90 fee changes focussed around 40 pools.

Statistically, the fee changes we have implemented in days gone by do not correlate with volume changes indicating that there is room to increase the fee rate on many pools without detracting from LP yields. We seek to change this by correlating the fee changes with statistically significant volume changes and identify market tolerance levels.

## Data

### Example from [Avg Daily Vol-Fees at Each Rate](https://drive.google.com/drive/folders/1EiAKunye3jC03dyY-1ZqyfO8RXhnijxo?usp=sharing)

 ![](https://europe1.discourse-cdn.com/flex013/uploads/bancordao/original/2X/f/f610275f676e933f72c349557a3ce5f0804cb7a8.png)

Interpreting x-axis:  
`0` # Index position  
`21 days` # Duration that fee was at this rate  
`2020-12-20` # Start time of fee change  
`WBTC` # Pool of interest

Left y-axis: Average Daily Volume (blue)  
Right y-axis: Average Daily Fees (red) set at 1% of volume

Note that this is the daily average for the duration that the fee was at this rate. While this is an excellent benchmark it can lose the ability for a meaningful comparison if the durations are very different (hence the section below).

### Example from [Avg 30d VolFees](https://drive.google.com/drive/folders/1Lzm2K0yDsGxql0qQN7D4PbZIDeFGYGWr?usp=sharing)

This dataset compares the average daily volume and fees for the most recent 30 days (right) with the previous 30 days (i.e. the time frame from 60 days ago to 30 days ago) with the centre date listed in the x-axis and title.

In this example, the recent experiments with the fee rate on the USDC pool show that even though the average daily volume has decreased in the recent 30 days, the average daily fees have increased almost 100%.

 ![](https://europe1.discourse-cdn.com/flex013/uploads/bancordao/original/2X/e/e3cd99b82804cf086ff97e825e508bf30d95c36a.png)

### Csv files:

Each folder contains the raw data in a csv file for ease of comparison.

## Data Notes

This dataset will be continually updated every day or two. This is currently a manual process from Dune Analytics as it is contingent on marrying the token addresses, pool addresses and bancor converter addresses.

Feel free to use this data for other governance proposals.

This is still a work in progress so if you have some suggestions for formatting or specific queries/data you would like to see let me know here.

Note that the pool naming convention hasn’t been perfect in the past so might require searching (e.g. AAVEBNT not BNTAAVE, and PSP not PSPBNT)

Many thanks to @tfns and @glenn for feedback.

---

<div class="post-metadata">

**Author:** ![eldude](https://avatars.discourse-cdn.com/v4/letter/e/c6cbf5/32.png) [@eldude](https://gov.bancor.network/u/eldude)\
**Post date:** [February 7, 2022, 10:30am UTC](https://gov.bancor.network/t/historical-fee-change-data-dump/3415/2 "2022-02-07T10:30:03Z")

</div>

Damn, this is great stuff.

---

<div class="post-metadata">

**Author:** ![tfns](https://dub1.discourse-cdn.com/flex013/user_avatar/gov.bancor.network/tfns/32/465_2.png) [@tfns](https://gov.bancor.network/u/tfns)\
**Post date:** [February 7, 2022, 4:10pm UTC](https://gov.bancor.network/t/historical-fee-change-data-dump/3415/3 "2022-02-07T16:10:27Z")

</div>

Thank you so much @NIX !!!
