SocioCryptoDaily balance - ETH
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT date_Trunc('day',block_timestamp) as date,
CASE WHEN symbol is null THEN contract_address ELSE symbol END as sym,
contract_address,
avg(balance/pow(10,decimals))
FROM ethereum.core.fact_token_balances a
LEFT JOIN ethereum.core.dim_contracts b
ON a.contract_address = b.address
WHERE user_address = '0x4fafb87de15cff7448bd0658112f4e4b0d53332c'
and decimals > 0
GROUP BY date, contract_address,sym
Run a query to Download Data