flyingfishPolygon - weekly volume tracker copy
Updated 2023-01-26Copy Reference Fork
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
31
32
33
34
35
36
›
⌄
SELECT
block_timestamp::date as date
, pool_name
-- , symbol_in
-- , symbol_out
, sum(CASE when symbol_in = 'WMATIC' THEN amount_in ELSE 0 end) as weth_in
, sum(CASE when symbol_out = 'WMATIC' THEN amount_out ELSE 0 end) as weth_out
, weth_in + weth_out AS volume
, weth_in - weth_out AS delta
, sum(amount_in) as amount_in
, sum(amount_in_usd) as amount_in_usd
, sum(amount_out) as amount_out
, sum(amount_out_usd) as amount_out_usd
-- , token_in
-- , token_out
FROM polygon.sushi.ez_swaps
WHERE block_timestamp::date > '2023-01-01' AND block_timestamp < current_date() -- and pool_name IN ('MAGIC-WETH', 'WETH-USDC')
-- AND (symbol_in = 'WMATIC' OR symbol_out = 'WMATIC')
-- AND pool_name = 'WMATIC-IXT'
-- AND pool_name NOT IN ('DPX-WETH', 'RDPX-WETH','MAGIC-WETH', 'WETH-MIM',
-- 'WETH-USDT', 'RDNT-WETH', 'WETH-gOHM')
-- AND (token_in = '0x82af49447d8a07e3bd95bd0d56f35241523fbab1' OR
-- token_out = '0x82af49447d8a07e3bd95bd0d56f35241523fbab1')
GROUP BY date, pool_name --, token_in, token_out --, symbol_in, symbol_out
HAVING volume > 10
-- ORDER BY block_timestamp DESC
ORDER BY date, weth_in DESC
-- LIMIT 10
SELECT amount_in / pow(10,18) as amin,
amount_out / pow(10,18) as amout,
*
FROM polygon.sushi.ez_swaps
WHERE block_timestamp::date = '2023-01-02'
AND pool_name = 'NXTT-WMATIC' and symbol_in = 'WMATIC'
ORDER BY amount_in DESC
Run a query to Download Data