Top 10 Uniswap Pools By Swap Volume
Tags: crypto, uniswap, liquiditypools, sql
Published: 2021-07-30 13:12:44

---
title: Top 10 Uniswap Pools By Swap Volume 
published: true
description: An investigation into the top 10 Uniswap liquidity pools by volume.
tags: crypto, uniswap, liquiditypools, sql
//cover_image: https://dev-to-uploads.s3.amazonaws.com/uploads/articles/hw8t14z16nmdrotqqa04.png
---
### Introduction
The central idea around the invention of cryptocurrencies is that traditional fiat currencies are failing to serve a fast-advancing society. Since bitcoin's invention, the idea of money has changed from being an asset controlled by a single entity to a decentralized system that is trustless, permissionless, and accessible to anyone with an internet connection. 

Blockchain technology, the backbone of this innovation, has spurred off countless cryptocurrencies, with different approaches, solutions, and ideologies coming together to create a new paradigm. The realization now is that there is no one currency to rule them all, however, an ecosystem is emerging where different types of cryptocurrencies serve different purposes. 

### Decentralized Exchanges
A crypto ecosystem that will promote adoption and utility should provide the means of seamless exchange of currencies (tokens). Decentralized exchanges (DEXs) enable the exchange of tokens by allowing token holders to provide tokens in a pool to facilitate trades. Mechanisms of DEXs vary by design however, the leaders in this space happen to be automated market makers (AMM) that allow tokens to be traded automatically and without permission using liquidity pools.

### Uniswap
Uniswap is an AMM designed for exchanging tokens on the Ethereum blockchain. As a pioneer in the space of AMMs, Uniswap is the [largest decentralized exchange](https://defipulse.com/uniswap) with total value locked (TTVL) over $5 billion. In this piece, we seek to investigate the liquidity pools available on Uniswap and rank the pools with the most swap volumes. We define swap volumes as the number of tokens exchanged within a particular pool over time. 

### On-chain data
Our investigation requires access to on-chain data. [FlipsideCrypto](https://flipsidecrypto.com/) is a data analytics firm that provides free access to crypto on-chain data via an SQL interface and a REST application programming interface (API). For simplicity’s sake, we shall use the SQL interface to make the search query. The purpose of the query is to get the top 10 Uniswap pools by swap volume. 

### Method
According to [FlipsideCrypto documentation](https://docs.flipsidecrypto.com/our-data/tables/uniswap-v3-tables/swaps), to get Uniswap swap data, we have to call the `Uniswapv3.swap` table. Uniswap v3 is chosen over v2 and v1 because it is the latest iteration of the Uniswap protocol at the time of writing. Next, we  identify the `amount0_usd` and `amount1_usd` columns which hold the swap amount for every trade made on the protocol. To get the top 10 pools, we sum up the swap amounts for every transaction associated with a particular pool. The result is ordered in descending order and limited to 10 entries representing the top 10 pools. Here’s how the query looks like: 
```
WITH swap_raw AS (
    SELECT
        pool_address,
        pool_name,
        CASE WHEN amount0_usd < 0 THEN amount0_usd ELSE amount1_usd END AS swap_usd_amount_out,
        CASE WHEN amount0_usd >= 0 THEN amount0_usd ELSE amount1_usd END AS swap_usd_amount_in
    FROM uniswapv3.swaps
    WHERE amount0_usd IS NOT NULL AND amount1_usd IS NOT NULL
)
-- // Only amount in
SELECT
    pool_address,
    pool_name,
    SUM(ABS(swap_usd_amount_in)) AS swap_volume_usd 
FROM swap_raw
GROUP BY 1,2
ORDER BY 3 DESC
LIMIT 10
```
Note: Conditions are applied to only add one of `amount0_usd` or `amount1_usd` to the summation depending on the direction of the trade. 

The [chart](https://velocity-app.flipsidecrypto.com/velocity/visuals/6cd06cc2-4676-4a0c-879d-39efdce6e430/3fe887aa-73c2-4c3b-9ecf-ba3ae2bb24d0) below presents the bar graph visualization of the top 10 Uniswap pools by swap volume.
![Top 10 Uniswap Pools By Swap Volume](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/wbukpltglmpy9zfzgkcx.png)

###  Findings & Conclusion 
The top 10 Uniswap pools have a combined swap volume of $66,082,676,649 out of the total all-time swap volume of $87,614,231,061. This represent a share of ~75%, which means that about 75 percent of swaps made on Uniswap happen within the top 10 liquidity pools.