keshanTracer voters
    Updated 2022-02-26
    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