SYMBOL | TOKEN_ADDRESS | TREYNOR_RATIO | BETA | TOTAL_LIQUIDITY | LATEST_PRICE | |
---|---|---|---|---|---|---|
1 | SPX | 0x50da645f148798f68ef2d7db7c1cb22a6819bb2c | 0.0007158787992 | 1.417559933 | 7180356.32 | 0.499561 |
2 | RSC | 0xfbb75a59193a3525a8825bebe7d4b56899e2f7e1 | 0.0006221776635 | 0.8763678885 | 3175870.38 | 0.31161 |
3 | tBTC | 0x236aa50979d5f3de3bd1eeb40e81137f22ab794b | 0.0006105212657 | 0.4300858868 | 9633081.32 | 83908 |
4 | VIRTUAL | 0x0b3e328455c4059eeb9e3f84b5543f74e24e7e1b | 0.0004963912798 | 1.078405444 | 247571986.38 | 0.742228 |
5 | WETH | 0x4200000000000000000000000000000000000006 | 0.0002401717357 | 1 | 5075072488.38 | 1993.5 |
6 | PRIME | 0xfa980ced6895ac314e7de34ef1bfae90a5add21b | 0.00002639215355 | 0.8933886656 | 5515950.1 | 3.98 |
7 | cbETH | 0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22 | -0.00002365717763 | 0.8816768523 | 16198239.6 | 2177.83 |
8 | rETH | 0xb6fe221fe9eef5aba221c348ba20a1bf5e73624c | -0.00005178594073 | 0.8636894628 | 2980719.56 | 2254.13 |
9 | SEAM | 0x1c7a460413dd4e964f96d8dfc56e7223ce88cd85 | -0.001025975202 | 0.1489176236 | 3486218.28 | 0.400372 |
10 | DAI | 0x50c5725949a6f0c72e6c4a641f24049a917db0cb | -0.001097152461 | 0.04511236382 | 4135955.33 | 0.999803 |
11 | USD+ | 0xb79dd08ea68a908a97220c76d19a6aa9cbde4376 | -0.001186681201 | 0.03383606683 | 2005402.69 | 0.999595 |
12 | USDbC | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | -0.05867249251 | -0.9734692239 | 30349317.06 | 0.999657 |
13 | AERO | 0x940181a94a35a4569e4529a3cdfb74e38fd98631 | -0.2662020725 | -0.2297856772 | 30523128.17 | 0.509849 |
14 | USDC | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | -4.141822216 | -0.006121546164 | 3368485174.43 | 0.999879 |
feyikemiScript 1
Updated 2025-03-22
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
›
⌄
WITH weth_pairs AS (
SELECT DISTINCT TOKEN_OUT AS token_address
FROM {{network}}.defi.ez_dex_swaps
WHERE SYMBOL_IN = 'WETH' AND platform = 'uniswap-v3'
UNION ALL
SELECT DISTINCT TOKEN_IN AS token_address
FROM {{network}}.defi.ez_dex_swaps
WHERE SYMBOL_OUT = 'WETH' AND platform = 'uniswap-v3'
),
v3_assets AS (
SELECT DISTINCT token_address FROM weth_pairs
),
price_data AS (
SELECT
token_address,
hour,
price,
LAG(price) OVER (PARTITION BY token_address ORDER BY hour) AS prev_price
FROM {{network}}.price.ez_prices_hourly
WHERE token_address IN (SELECT token_address FROM v3_assets)
),
returns AS (
SELECT
token_address,
hour,
(price - prev_price) / prev_price AS hourly_return
FROM price_data
WHERE prev_price IS NOT NULL
),
weth_prices AS (
SELECT
hour,
Last run: 2 months ago
14
1KB
17s