MeirLP Balances Singular Per Asset
Updated 2023-10-01
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from LP Balances Singular @ https://flipsidecrypto.xyz/edit/queries/b03ee584-fcbc-4ff1-a4ff-783cbf933c08
-- forked from LP Balances @ https://flipsidecrypto.xyz/edit/queries/9bc858ae-d47c-4852-8fb4-935c422ca1cb
-- forked from eth+Curve Market Cap @ https://flipsidecrypto.xyz/edit/queries/27388b7c-87c6-40cb-bf47-157aaa7901ed
-- forked from eUSD Curve Market Cap @ https://flipsidecrypto.xyz/edit/queries/2581db12-5560-417b-b9db-aabf58459e4b
-- BUILD TOKENS
with curve_swaps as (
SELECT
*
FROM ethereum.defi.ez_dex_swaps
WHERE PLATFORM = 'curve'
AND CONTRACT_ADDRESS = lower('{{pool_address}}')
),
tokens_out as (
SELECT
DISTINCT TOKEN_OUT as token,
CONTRACT_ADDRESS as pool_address,
POOL_NAME as pool_name,
SYMBOL_OUT as symbol
FROM curve_swaps
GROUP BY TOKEN_OUT, SYMBOL_OUT, CONTRACT_ADDRESS, POOL_NAME
),
tokens_in as (
SELECT
DISTINCT TOKEN_IN as token,
CONTRACT_ADDRESS as pool_address,
POOL_NAME as pool_name,
SYMBOL_IN as symbol
FROM curve_swaps
-- GROUP BY TOKEN_IN
Run a query to Download Data