Skip to content
Dune Analytics

@jebonn / Uniswap_v2 YFI/ETH pool liquidity

Quantity of pooled tokens at 1 constant liquidity tokenUniswap_v2 YFI/ETH pool liquidity

Loading
 

About queries and results

Dune Analytics lets you explore, create, and share Ethereum analytics. You can find an endless amount of great queries and dashboards on Dune.

We have decoded Ethereum smart contract data so you can do powerful analysis with simple SQL queries and visualise the query results into beautiful graphs.

Dune Analytics is free for everyone forever. If you want extra features like private queries, export your results and more check out our Pro plan.

SQL query results

Loading
 

SQL query

1WITH supply AS (
2    SELECT
3    day,
4    SUM(transfer) over (order by day) as supply
5    FROM 
6    (
7        SELECT
8        date_trunc('day', evt_block_time) as day,
9        sum(value/1e18) as transfer --Divide by relevant decimal number
10        FROM
11        (
12            SELECT
13            evt_block_time,
14            value
15            FROM uniswap_v2."Pair_evt_Transfer"
16            WHERE contract_address = '\x2fDbAdf3C4D5A8666Bc06645B8358ab803996E28' -- token contract address
17            AND "from" = '\x0000000000000000000000000000000000000000'
18        UNION
19            SELECT
20            evt_block_time,
21            (-value)
22            FROM uniswap_v2."Pair_evt_Transfer"
23            WHERE contract_address = '\x2fDbAdf3C4D5A8666Bc06645B8358ab803996E28' -- token contract address
24            AND "to" = '\x0000000000000000000000000000000000000000'
25        ) as transfers...

Result visualizations

Total supply (liquidity tokens)Uniswap_v2 YFI/ETH pool liquidity

Loading