binhachonCurve: yveCRV token holders through time
    Updated 2021-11-10
    SELECT
    BALANCE_DATE,
    Address,
    Balance
    FROM
    (SELECT --DATE_TRUNC('week',BALANCE_DATE) as Week,
    BALANCE_DATE,
    CASE
    WHEN USER_ADDRESS = '0x10b47177e92ef9d5c6059055d92ddf6290848991' THEN 'SUSHISWAP'
    WHEN USER_ADDRESS = '0x2923a58c1831205c854dbea001809b194fdb3fa5' THEN 'yvBOOST vault'
    WHEN USER_ADDRESS = '0x683b5c88d48fccfb3e778ff0fa954f84ca7ce9df' THEN 'yvBOOST vault'
    WHEN USER_ADDRESS = '0x9d409a0a012cfba9b15f6d4b36ac57a46966ab9a' THEN 'yvBOOST vault'
    WHEN USER_ADDRESS = '0xbfdd0b4f6ab0a24896caf8c892838c26c8b0f7be' THEN 'yvBOOST vault'
    ELSE 'Other users' END as Address,
    SUM(BALANCE) as Balance
    FROM ethereum.erc20_balances
    WHERE CONTRACT_ADDRESS = '0xc5bddf9843308380375a611c18b50fb9341f502a'
    AND BALANCE_DATE >= getdate() - INTERVAL'1 year'
    GROUP BY Address, BALANCE_DATE)
    WHERE date_part('day',BALANCE_DATE) = 1
    ORDER BY BALANCE_DATE DESC, Balance DESC


    Run a query to Download Data