keshanTracer voters
Updated 2022-02-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with max_date as (
select max(balance_date) as max_date from ethereum.erc20_balances where
contract_address = lower('0x9C4A4204B79dd291D6b6571C5BE8BbcD0622F050')
)
select balance_date, user_address, label, address_name, label_type, label_subtype, sum(balance) as balance, sum(amount_usd) as amount_usd from ethereum.erc20_balances where
contract_address = lower('0x9C4A4204B79dd291D6b6571C5BE8BbcD0622F050')
and (address_name = '0xe55c3e83852429334a986b265d03b879a3d188ac' or address_name = '0x10b5c63a0a94ec3036238190bc88608a02e91e2c')
group by balance_date, user_address, label, address_name, label_type, label_subtype
--select * from ethereum.dex_swaps where pool_address = lower('0xe55c3e83852429334a986b265d03b879a3d188ac') or pool_address = lower('0x10b5c63a0a94ec3036238190bc88608a02e91e2c')
-- pool addresses - 0xe55c3e83852429334a986b265d03b879a3d188ac sushiswap
-- 0x10b5c63a0a94ec3036238190bc88608a02e91e2c uniswap-v3
Run a query to Download Data