Skip to content
Dune Analytics

@kroeger0x / 07_01_liquidity_provider_query_pt_1.sql

SQL query

1-- returns all addresses that interacted with uniswap
2DROP TABLE IF EXISTS dune_user_generated.lp_query_part_1;
3CREATE TABLE dune_user_generated.lp_query_part_1 AS (
4WITH
5    tokens AS (
6        SELECT
7            token
8        FROM dune_user_generated.uniswap_v1_pairs
9
10        UNION
11
12        SELECT
13            token0 AS token
14        FROM dune_user_generated.uniswap_v2_pairs
15
16        UNION
17
18        SELECT
19            token1 AS token
20        FROM dune_user_generated.uniswap_v2_pairs
21    )
22    , token_transfer_senders AS (
23        SELECT DISTINCT
24            erc20."from" as address
25        FROM erc20."ERC20_evt_Transfer" erc20...

SQL query results

Loading