binhachonHop Whales - Unique users
Updated 2022-06-22
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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
Run a query to Download Data