anomonetime span of fwb treasury
Updated 2022-02-28
99
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
›
⌄
⌄
/*SELECT DISTINCT CONTRACT_ADDRESS, SYMBOL
FROM ethereum.erc20_balances
WHERE user_address = '0x660f6d6c9bcd08b86b50e8e53b537f2b40f243bd'
--AND date_trunc('day' , balance_date ) >= TO_DATE('2021-03-19')
--AND contract_address in (--'0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2', --WETH '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' , --USDC 'ETH') -- Native ETH
--GROUP BY BALANCE_DATE
LIMIT 10
SELECT BALANCE_DATE,
SUM(CASE WHEN contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' THEN BALANCE ELSE 0 END) AS "USDC Amount",
SUM(CASE WHEN contract_address = 'ETH' THEN BALANCE ELSE 0 END) AS "ETH Amount",
SUM(CASE WHEN contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' THEN AMOUNT_USD ELSE 0 END) AS "USDC Balance_USD",
SUM(CASE WHEN contract_address = 'ETH' THEN AMOUNT_USD ELSE 0 END) AS "ETH Balance_USD"
FROM ethereum.erc20_balances
WHERE user_address = '0x660f6d6c9bcd08b86b50e8e53b537f2b40f243bd'
--AND date_trunc('day' , balance_date ) >= TO_DATE('2021-03-19')
AND contract_address in (--'0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2', --WETH
'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' , --USDC
'ETH') -- Native ETH
GROUP BY BALANCE_DATE
*/
select * from
(select BALANCE_DATE,
ETH,
"UNI-V2",
FWB_OLD,
FWB,
"FWB 420",
DSGN,
WHALE,
USDC,
WETH,
SOCKSCLASSIC
from ethereum.erc20_balances
Run a query to Download Data