binhachonCurve: yveCRV token holders through time
Updated 2021-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
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