connorhUntitled Query
999
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
›
⌄
-- Everything
SELECT * FROM
(SELECT date_trunc('day', balance_date) AS metric_date,
'USDT' AS symbol,
SUM(amount_usd) AS amount
FROM ethereum.erc20_balances
WHERE (user_address IN('0x0ac6a1d74e84c2df9063bddc31699ff2a2bb22a2', -- Maker
'0xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9', -- Compound
'0x3dfd23a6c5e8bbcfc9581d2e864a68feb6a076d3', -- Aave
LOWER('0x45F783CCE6B7FF23B2ab2D70e416cdb7D6055f51'), -- Curve ySYMBOL
LOWER('0x79a8C46DeA5aDa233ABaFFD40F3A0A2B1e5A4F27'), --ySYMBOL
LOWER('0x52EA46506B9CC5Ef470C5bf89f17Dc28bB35D85C'), -- SYMBOL (CURVE)
LOWER('0xbEbc44782C7dB0a1A60Cb6fe97d0b483032FF1C7'), -- SYMBOL (CURVE)
LOWER('0xA5407eAE9Ba41422680e2e00537571bcC53efBfD'), -- SYMBOL (CURVE)
LOWER('0xA5407eAE9Ba41422680e2e00537571bcC53efBfD')) -- SYMBOL (CURVE)
OR (address_name ~ ' LP' AND label = 'uniswap') --Uniswap
OR (address_name ~ 'SLP' AND label = 'sushiswap') --Sushiswap
OR label LIKE '%alancer%') --Balancer
AND contract_address IN ('0x83f798e925bcd4017eb265844fddabb448f1707d', --yUSDT
'0xdac17f958d2ee523a2206206994597c13d831ec7') --USDT
AND balance_date >= getdate() - interval '9 months'
GROUP BY 1,2
UNION
SELECT metric_date,
'DAI' AS symbol,
sum(amount) AS amount
FROM
(
SELECT metric_date,
amount AS amount
FROM
(SELECT date_trunc('day', block_timestamp) AS metric_date,
amount,
Run a query to Download Data