theericstonepolygon bridging
Updated 2023-04-14
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
›
⌄
-- user_address | bridge_name | token_contract | token_symbol | n_in | n_out | in_token_volume | in_usd_volume | out_token_volume | out_usd_volume
-- PLACE Bridges USING PLACEHOLDER BELOW
-- looking at defillama's rankings as of april 2023
-- top 2 bridges are multichain and stargate
-- next are celer hop synapse
-- the canonical bridge should also be covered if possible
with bridges as (
select distinct address, address_name, project_name from polygon.core.dim_labels where project_name = 'multichain' and address_name like '%any%'
union
select lower('0x1205f31718499dBf1fCa446663B532Ef87481fe1') as address, 'USDC' as address_name, 'stargate' as project_name union
select lower('0x29e38769f23701A2e4A8Ef0492e19dA4604Be62c') as address, 'USDT' as address_name, 'stargate' as project_name union
select lower('0x1c272232Df0bb6225dA87f4dEcD9d37c32f63Eea') as address, 'DAI' as address_name, 'stargate' as project_name union
select lower('0x8736f92646B2542B3e5F3c63590cA7Fe313e283B') as address, 'MAI' as address_name, 'stargate' as project_name
union
select lower('0x8f5bbb2bb8c2ee94639e55d5f41de9b4839c1280') as address, 'synapse' as address_name, 'synapse' as project_name union
select lower('0x1c6ae197ff4bf7ba96c66c5fd64cb22450af9cc8') as address, 'synapse zap' as address_name, 'synapse' as project_name
union
select lower('0xc315239cfb05f1e130e7e28e603cea4c014c57f0') as address, 'ETH' as address_name, 'hop' as project_name union
select lower('0x25d8039bb044dc227f741a9e381ca4ceae2e6ae8') as address, 'USDC' as address_name, 'hop' as project_name union
select lower('0xa6a688F107851131F0E1dce493EbBebFAf99203e') as address, 'USDC' as address_name, 'hop' as project_name union
select lower('0xa6a688F107851131F0E1dce493EbBebFAf99203e') as address, 'USDT' as address_name, 'hop' as project_name union
select lower('0xd8781ca9163e9f132a4d8392332e64115688013a') as address, 'MATIC' as address_name, 'hop' as project_name union
select lower('0x10b6CbDFE187c04d63F179B87067C49e7a1E91Af') as address, 'DAI' as address_name, 'hop' as project_name union
select lower('0x710bDa329b2a6224E4B44833DE30F38E7f81d564') as address, 'ETH' as address_name, 'hop' as project_name union
select lower('0x881296Edcb252080bd476c464cEB521d08df7631') as address, 'HOP' as address_name, 'hop' as project_name
union
select lower('0x5a58505a96d1dbf8df91cb21b54419fc36e93fde') as address, 'token' as address_name, 'wormhole' as project_name union
select lower('0x7a4b5a56256163f07b2c80a7ca55abe66c4ec4d7') as address, 'poly' as address_name, 'wormhole' as project_name
union
select lower('0x48d990AbDA20afa1fD1da713AbC041B60a922c65') as address, 'across' as address_name, 'across' as project_name union
select lower('0x69B5c72837769eF1e7C164Abc6515DcFf217F920') as address, 'across' as address_name, 'across' as project_name
union
select lower('0x88DCDC47D2f83a99CF0000FDF667A468bB958a78') as address, 'celer bridge' as address_name, 'celer_bridge' as project_name union
select lower('0xc1a2D967DfAa6A10f3461bc21864C23C1DD51EeA') as address, 'celer bridge' as address_name, 'celer_bridge' as project_name union
Run a query to Download Data