flipside

    Multichain MPC Wallet Balances
    JhanlycnMultichain MPC Wallet Balances
    Updated 2024-01-30
    select
    user_address,
    symbol,
    sum(usd_value_now) as usd_by_token,
    sum(sum(usd_value_now)) over (partition by user_address) as wallet_usd,
    sum(sum(usd_value_now)) over () as total_usd_all_wallets
    from
    ethereum.core.ez_current_balances as main
    where
    user_address in (
    '0x027f1571aca57354223276722dc7b572a5b05cd8',
    '0xefeef8e968a0db92781ac7b3b7c821909ef10c88',
    '0x622e5f32e9ed5318d3a05ee2932fd3e118347ba0',
    '0x418ed2554c010a0c63024d1da3a93b4dc26e5bb7',
    '0x9d5765ae1c95c21d4cc3b1d5bba71bad3b012b68',
    '0x48bead89e696ee93b04913cb0006f35adb844537'
    )
    group by
    user_address,
    symbol
    having
    sum(usd_value_now) > 0 -- filter spam tokens
    order by
    wallet_usd desc,
    usd_by_token desc

    Last run: about 1 year agoAuto-refreshes every 3 hours
    USER_ADDRESS
    SYMBOL
    USD_BY_TOKEN
    WALLET_USD
    TOTAL_USD_ALL_WALLETS
    1
    		0xefeef8e968a0db92781ac7b3b7c821909ef10c88USDC30145131.3530145364.369063537.47
    2
    		0xefeef8e968a0db92781ac7b3b7c821909ef10c88ETH231.0830145364.369063537.47
    3
    		0xefeef8e968a0db92781ac7b3b7c821909ef10c88MTV1.8730145364.369063537.47
    4
    		0x027f1571aca57354223276722dc7b572a5b05cd8USDC27659451.2827659460.1169063537.47
    5
    		0x027f1571aca57354223276722dc7b572a5b05cd8ETH6.9627659460.1169063537.47
    6
    		0x027f1571aca57354223276722dc7b572a5b05cd8MTV1.8727659460.1169063537.47
    7
    		0x48bead89e696ee93b04913cb0006f35adb844537USDC5498123.966540544.5169063537.47
    8
    		0x48bead89e696ee93b04913cb0006f35adb844537USDT1042379.466540544.5169063537.47
    9
    		0x48bead89e696ee93b04913cb0006f35adb844537ETH39.226540544.5169063537.47
    10
    		0x48bead89e696ee93b04913cb0006f35adb844537MTV1.876540544.5169063537.47
    11
    		0x9d5765ae1c95c21d4cc3b1d5bba71bad3b012b68UNIDX2727571.214718098.9869063537.47
    12
    		0x9d5765ae1c95c21d4cc3b1d5bba71bad3b012b68USDT1493085.224718098.9869063537.47
    13
    		0x9d5765ae1c95c21d4cc3b1d5bba71bad3b012b68TUSD497341.094718098.9869063537.47
    14
    		0x9d5765ae1c95c21d4cc3b1d5bba71bad3b012b68ETH99.584718098.9869063537.47
    15
    		0x9d5765ae1c95c21d4cc3b1d5bba71bad3b012b68MTV1.874718098.9869063537.47
    16
    		0x9d5765ae1c95c21d4cc3b1d5bba71bad3b012b68ICE0.014718098.9869063537.47
    17
    		0x622e5f32e9ed5318d3a05ee2932fd3e118347ba0ETH51.8351.8369063537.47
    18
    		0x418ed2554c010a0c63024d1da3a93b4dc26e5bb7ETH17.7417.7469063537.47
    18
    1KB
    192s