0xNolenseETH SY over time
    Updated 2024-09-26
    WITH token_balances AS (
    SELECT
    DATE_TRUNC('day', block_timestamp) AS date,
    user_address,
    contract_address,
    AVG(balance) AS token_balance
    FROM
    ethereum.core.fact_token_balances
    WHERE
    user_address IN (
    lower('0xF32e58F92e60f4b0A37A69b95d642A471365EAe8'),
    lower('0xfb35Fd0095dD1096b1Ca49AD44d8C5812A201677')
    )
    AND CONTRACT_ADDRESS = lower('0xAC0047886a985071476a1186bE89222659970d65')
    AND DATE <= '2024-09-14'
    AND date >= '2024-06-27'
    GROUP BY
    date,
    user_address,
    contract_address
    )
    SELECT
    tb.date,
    -- tb.user_address,
    -- tb.contract_address,
    SUM(tb.token_balance * 1e-18) as SY_holdings
    FROM
    token_balances tb
    GROUP BY
    tb.date
    ORDER BY
    tb.date DESC;
    QueryRunArchived: QueryRun has been archived