jackguysushiswap graphs 3
Updated 2023-03-02
99
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
›
⌄
SELECT --*
date_trunc('day', block_timestamp) as day,
symbol,
avg(price * balance / power(10, decimals)) as balance_usd
-- avg(balance)
FROM ethereum.core.fact_token_balances
left OUTER JOIN (
SELECT
date_trunc('day', hour) as day,
token_address,
decimals,
symbol,
avg(price) as price
FROM ethereum.core.fact_hourly_token_prices
GROUP BY 1,2,3,4
) on contract_address = token_address
AND day = date_trunc('day', block_timestamp)
WHERE user_address in (
SELECT
CONTRACT_ADDRESS as pool_address
FROM ethereum.core.ez_dex_swaps
WHERE amount_in_usd < amount_out_usd * 2
AND platform LIKE 'sushiswap'
AND pool_name LIKE '{{ pool_name }}'
)
--LIMIT 100
GROUP BY 1,2
Run a query to Download Data