feyikemiScript 1
    Updated 2025-03-22
    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
    SYMBOL
    TOKEN_ADDRESS
    TREYNOR_RATIO
    BETA
    TOTAL_LIQUIDITY
    LATEST_PRICE
    1
    SPX0x50da645f148798f68ef2d7db7c1cb22a6819bb2c0.00071587879921.4175599337180356.320.499561
    2
    RSC0xfbb75a59193a3525a8825bebe7d4b56899e2f7e10.00062217766350.87636788853175870.380.31161
    3
    tBTC0x236aa50979d5f3de3bd1eeb40e81137f22ab794b0.00061052126570.43008588689633081.3283908
    4
    VIRTUAL0x0b3e328455c4059eeb9e3f84b5543f74e24e7e1b0.00049639127981.078405444247571986.380.742228
    5
    WETH0x42000000000000000000000000000000000000060.000240171735715075072488.381993.5
    6
    PRIME0xfa980ced6895ac314e7de34ef1bfae90a5add21b0.000026392153550.89338866565515950.13.98
    7
    cbETH0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22-0.000023657177630.881676852316198239.62177.83
    8
    rETH0xb6fe221fe9eef5aba221c348ba20a1bf5e73624c-0.000051785940730.86368946282980719.562254.13
    9
    SEAM0x1c7a460413dd4e964f96d8dfc56e7223ce88cd85-0.0010259752020.14891762363486218.280.400372
    10
    DAI0x50c5725949a6f0c72e6c4a641f24049a917db0cb-0.0010971524610.045112363824135955.330.999803
    11
    USD+0xb79dd08ea68a908a97220c76d19a6aa9cbde4376-0.0011866812010.033836066832005402.690.999595
    12
    USDbC0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca-0.05867249251-0.973469223930349317.060.999657
    13
    AERO0x940181a94a35a4569e4529a3cdfb74e38fd98631-0.2662020725-0.229785677230523128.170.509849
    14
    USDC0x833589fcd6edb6e08f4c7c32d4f71b54bda02913-4.141822216-0.0061215461643368485174.430.999879
    14
    1KB
    17s