binhachonHop Whales - Frequency - Optimism
    Updated 2022-06-22
    with native_bridge as (
    select
    'Arbitrum' as L2,
    address,
    'ERC20' as asset_type
    from flipside_prod_db.crosschain.address_labels
    where project_name = 'arbitrum'
    and address_name like '%l1%'
    and address_name like '%gateway%'
    and address_name not like '%router%'
    union all
    select
    'Arbitrum' as L2,
    '0x011b6e24ffb0b5f5fcc564cf4183c5bbbc96d515' as address,
    'ETH' as asset_type
    union all
    select
    'Polygon' as L2,
    '0x8484ef722627bf18ca5ae6bcf031c23e6e922b30' as address,
    'ETH' as asset_type
    union all
    select
    'Polygon' as L2,
    '0x401f6c983ea34274ec46f84d70b31c151321188b' as address,
    'ERC20' as asset_type -- MATIC / Plasma bridge
    union all
    select
    'Polygon' as L2,
    '0x40ec5b33f54e0e8a33a975908c5ba1c14e5bbbdf' as address,
    'ERC20' as asset_type -- ERC20 bridge
    union all
    select
    'Optimism' as L2,
    lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1') as address,
    'ERC20' as asset_type -- Optimism Gateway
    union all