Methodology

Dashboard Objective

Show Uniswap v3 Reception on Avalanche after Launch, showcasing their Liquidity Pools Activity.

Dashboard Structure

Uniswap on Avalanche
Uniswap v3 Performance
- Uniswap Has Achieved on Avalanche.
- Daily Liquidity Pools Created.
- Liquidity Pools Total Activity.
  - Transfer Transactions.
  - Active Users.
  - USD Inflows.
  - USD Netflows.
- Liquidity Pools Total Activity.
- The Full Table of Liquidity Pools.
USDC↔WAVAX
- USDC ↔ WAVAX 0.05% Overview.
- Liquidity Activity.
- Swap Activity.
USDt ↔ WAVAX
- USDt ↔ WAVAX 0.05% Overview.
- Liquidity Activity.
- Swap Activity.
BTC.b ↔ WAVAX
- BTC.b ↔ WAVAX 0.05% Overview.
- Liquidity Activity.
- Swap Activity.
Liquidators
- Uniswap v3 Liquidators
- Share of Liquiditors Volume in the Liquidity Pools
Key Takeaways
Methodology

Dashboard Method

Using Flipside Tables of Avalanche I'll track the activity of Uniswap V3 Liquidity Pools Using:

Method To track Uniswap v3 Pools:

Using the Uniswap V3 Factory Contract and the Decoded Event Logs Table of Avalanche I can find the data for all the LPs created

SELECT 
decoded_log:pool as pool_address,
decoded_log:token0 as token0_address,
decoded_log:token1 as token1_address,
decoded_log:fee/10000 as fee
FROM avalanche.core.fact_decoded_event_logs
WHERE contract_address ='0x740b1c1de25031c31ff4fc9a62f554a55cdc1bad' -- Uniswap V3 Factory
and event_name = 'PoolCreated'

After That I used that data to name each pool_address by their tokens and Fee (%).

With that I can track Activity of all the Pools using the Transfer Table:

avalanche.core.ez_token_transfers

Where I used Origin_from_address For the Users that Initiated the Liquidity or Swap Event.

To filter only the Liquidity Events I used origin_function_signature = '0xac9650d8'
When this signature is distinct to that value it means a Swap Event.

Uniswap V3 LPs Addresses:
0xfae3f424a0a47706811521e3ee268f00cfb5c45e as USDC ↔ WAVAX 0.05%
0x78b58a7e21b08f1fceb8d6ae9a235abb900b5716 as USDt ↔ WAVAX 0.05%
0xfc1e7bc60adfc151565c033521ee6ccbde027f54 as BTC.b ↔ WAVAX 0.05%

Because I Focused on these three pools I had to use their contracts directly, for the rest I used the method above.

Additionally I used:

avalanche.core.dim_contracts to label the token addresses obtained and created the LPs Names by Symbol.

avalanche.core.fact_transactions To track the Gas Fees (AVAX)

Dashboard Sources

Logos By Cryptologo:

Tether - USDC - BTC - Avalanche

Color Palette:

Bitcoin Color Palette - Tether Color Palette - Uniswap Color Palette - EURO Color Palette - The Rest are from Flipside Default Color Palettes

Uniswap Logo by Wikimedia

Uniswap Image from Avalanche

Other Images from Avalanche Twitter Thread

CaesarJulius0 Tweet that Inspired the Dashboard

Uniswap v3 on Avalanche