freemartianBridge From Aptos copy
Updated 2023-12-10
99
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
›
⌄
-- forked from Bridge From Aptos @ https://flipsidecrypto.xyz/edit/queries/28c0a5b2-a41a-4273-bc54-959f9268f43c
with chains_meta AS(
-- resource: https://layerzero.gitbook.io/docs/technical-reference/mainnet/supported-chain-ids
SELECT 'Ethereum' AS chain_name, '101' AS id UNION
SELECT 'BNB Chain' AS chain_name, '102' AS id UNION
SELECT 'Avalanche' AS chain_name, '106' AS id UNION
SELECT 'Aptos' AS chain_name, '108' AS id UNION
SELECT 'Polygon' AS chain_name, '109' AS id UNION
SELECT 'Arbitrum' AS chain_name, '110' AS id UNION
SELECT 'Optimism' AS chain_name, '111' AS id UNION
SELECT 'Fantom' AS chain_name, '112' AS id UNION
SELECT 'DFK' AS chain_name, '115' AS id UNION
SELECT 'Harmony' AS chain_name, '116' AS id UNION
SELECT 'Dexalot' AS chain_name, '118' AS id UNION
SELECT 'Celo' AS chain_name, '125' AS id UNION
SELECT 'Moonbeam' AS chain_name, '126' AS id UNION
SELECT 'Fuse' AS chain_name, '138' AS id UNION
SELECT 'Gnosis' AS chain_name, '145' AS id UNION
SELECT 'Klaytn' AS chain_name, '150' AS id UNION
SELECT 'Metis' AS chain_name, '151' AS id UNION
SELECT 'CoreDAO' AS chain_name, '153' AS id UNION
SELECT 'OKT (OKX)' AS chain_name, '155' AS id UNION
SELECT 'Polygon zkEVM' AS chain_name, '158' AS id UNION
SELECT 'Canto' AS chain_name, '159' AS id UNION
SELECT 'Sepolia' AS chain_name, '161' AS id UNION
SELECT 'zkSync Era' AS chain_name, '165' AS id UNION
SELECT 'Moonriver' AS chain_name, '167' AS id UNION
SELECT 'Tenet' AS chain_name, '173' AS id UNION
SELECT 'Arbitrum Nova' AS chain_name, '175' AS id UNION
SELECT 'Meter.io' AS chain_name, '176' AS id UNION
SELECT 'Kava' AS chain_name, '177' AS id UNION
SELECT 'Mantle' AS chain_name, '181' AS id UNION
SELECT 'Linea' AS chain_name, '183' AS id UNION
SELECT 'Base' AS chain_name, '184' AS id UNION
SELECT 'Zora' AS chain_name, '195' AS id UNION
Run a query to Download Data