SocioCryptoETH TVL
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT SUM(AMOUNT) AS TVL_ETH
FROM
(
SELECT SYMBOL,
MAX(AMOUNT_USD) AS AMOUNT
FROM ethereum.erc20_balances
WHERE user_address = lower('0xF5BCE5077908a1b7370B9ae04AdC565EBd643966')
AND balance_date = CURRENT_DATE-1
AND AMOUNT_USD IS NOT NULL
GROUP BY SYMBOL
)
Run a query to Download Data