chispasParadigm Capital ETH Investments copy
Updated 2024-06-21
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
›
⌄
-- forked from Pantera Capital ETH Investments @ https://flipsidecrypto.xyz/edit/queries/19966c54-ecbc-4042-8b6c-0137ec2d83b5
-- forked from Pantera Capital ETH Balances @ https://flipsidecrypto.xyz/edit/queries/5db195a8-cc45-4187-aadb-acd7d1e7cf76
SELECT
user_address,
SYMBOL as token,
usd_value_now as usd_value,
MAX(current_bal) AS current_token_balance
FROM
ETHEREUM.core.ez_current_balances
WHERE
user_address IN (
LOWER('0x820fb25352BB0c5E03E07AFc1d86252fFD2F0A18'),
LOWER('0x11577a8A5bAF1e25B9a2d89f39670F447d75c3cD'),
LOWER('0x917B3ACa2142Dd136fa106229990EA4D02763A83'),
LOWER('0xC9946538580e71D2FE276FD6a26D4cA475eEd535'),
LOWER('0xCA8d6F69D8f32516a109Df68B623452cc9f5E64d'),
LOWER('0x09F82Ccd6baE2AeBe46bA7dd2cf08d87355ac430'),
LOWER('0xA1b61405791170833070C0eA61eD28728A840241'),
LOWER('0xeD046C851A3134e159f958D3bCfDD5A3f2102D13'),
LOWER('0xe523Fc253BcdEA8373E030ee66e00c6864776d70')
)
--AND SYMBOL = 'ETH'
GROUP BY
user_address,
symbol,
usd_value
QueryRunArchived: QueryRun has been archived