ArioOptimism-WETH-Destination type-Volume
    Updated 2023-04-15
    select
    Top 10 LABEL_TYPE as Destination,
    sum(amount_usd) as "Transfer Volume (USD)"
    from
    optimism.core.ez_token_transfers a
    join optimism.core.dim_labels b on a.ORIGIN_TO_ADDRESS = b.address
    where symbol = 'WETH'
    group by
    1
    order by 2 DESC