adam10Top tokens by volatility
Updated 2021-08-11
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
›
⌄
WITH univ3_pools AS (
SELECT
pool_address,
MAX(pool_name) as pool_name, --remove duplicates
MAX(token0_address) as token0_address, --remove duplicates
MAX(token1_address) as token1_address --remove duplicates
FROM
uniswapv3.positions
WHERE
--top pools in july
pool_address IN (
'0x6c6bc977e13df9b0de53b251522280bb72383700',
'0xe8c6c9227491c0a8156a0106a0204d881bb7e531',
'0xcbcdf9626bc03e24f779434178a73a0b4bad62ed',
'0x99ac8ca7087fa4a2a1fb6357269965a2014abc35',
'0x6f48eca74b38d2936b02ab603ff4e36a6c0e3a77',
'0x8ad599c3a0ff1de082011efddc58f1908eb6e6d8',
'0x4e68ccd3e89f51c3074ca5072bbac773960dfa36',
'0x7858e59e0c01ea06df3af3d20ac7b0003275d4bf',
'0x1d42064fc4beb5f8aaf85f4617ae8b3b5b8bd801',
'0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640'
)
GROUP BY 1
),
token_volatility AS (
SELECT
token_address,
symbol,
(MAX(price) - MIN(price)) / MIN(price) * 100 as volatility
FROM
ethereum.token_prices_hourly
WHERE
token_address IN (
'0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2',
Run a query to Download Data