The above chart compares the number of swap events on Quickswap v3 to the raw swap transactions processed through the Quickswap v3 swap router on the decoded transactions table. As we can see from the swap_difference line, the variance between the two sources is minimal.

To determine the fees on Quickswap v3, we adopted a systematic approach:

Identifying Active Pools: We began by identifying all the currently active pools. This was achieved by sifting through the event logs and pinpointing instances where new pools were created, essentially giving us a snapshot of the active trading pools in Quickswap v3.

Extracting Fee Events: With the list of active pools in hand, we delved deeper to extract all the 'Fee' events emitted by these pools. These events provide crucial insights into the fee dynamics and are pivotal for our subsequent computations.

Merging with Swap Data: To gain a comprehensive understanding of the fee landscape, we then amalgamated the extracted fee data with the dex_swaps table. This integration enabled us to discern the exact fee amount levied on each individual swap transaction.

Aggregating Daily Metrics: Lastly, we proceeded to aggregate the fees on a daily basis. This culminated in a holistic view, presenting both the daily fees and the corresponding trading volume on Quickswap v3.

The result of this meticulous process is a granular breakdown of fees and trading volumes, providing a clear picture of Quickswap v3's financial dynamics.

These final two charts compare the volume and fees calculated with Flipside data to those provided by DeFi Llama. As we can see from the difference line, the two source