flipside

    Blast Whale Balance
    mamad-5XN3k3Blast Whale Balance
    Updated 2025-04-15
    with usert as (
    select
    'ETH' as SYMBOL,
    to_address as user,
    AMOUNT_USD as volume
    from blast.core.ez_native_transfers
    --group by 1,2

    union

    select
    'ETH' as SYMBOL,
    from_address as user,
    -1 * AMOUNT_USD as volume
    from blast.core.ez_native_transfers
    --group by 1,2

    UNION

    select
    SYMBOL,
    to_address as user,
    AMOUNT_USD as volume
    from blast.core.ez_token_transfers
    --group by 1,2

    UNION

    select
    SYMBOL,
    from_address as user,
    -1 * AMOUNT_USD as volume
    from blast.core.ez_token_transfers
    --group by 1,2
    ),

    Last run: 13 days ago
    ASSET
    AMOUNT
    1
    		ETH10481353135.1718
    2
    		USDB4150239856.84789
    3
    		BLAST629483613.142299
    4
    		YES381634899.148889
    5
    		YIELD147129491.594339
    6
    		ORBIT141759460.202273
    7
    		JUICE56737224.6078773
    8
    		TES50549414.3087434
    9
    		ezETH40928068.8448183
    10
    		PAC29047696.3473805
    10
    262B
    106s