anomonetest distinct symbol
Updated 2022-02-23
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT BALANCE_DATE ,CONTRACT_ADDRESS , SYMBOL , BALANCE, AMOUNT_USD FROM ethereum.erc20_balances
WHERE user_address = '0x660f6d6c9bcd08b86b50e8e53b537f2b40f243bd'
--AND date_trunc('day' , balance_date ) = date_trunc('day' , getdate() )
AND contract_address in ('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2', --WETH
'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' , --USDC
'ETH') -- Native ETH
Run a query to Download Data