theericstoneethereum bridging
Updated 2023-04-06
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
with outbridges AS (
-- multichain
SELECT 'Multichain' as bridge, LOWER('0x7ea2be2df7ba6e54b1a9c70676f668455e329d29') as BRIDGE_ADDRESS, LOWER('0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48') as CONTRACT_ADDRESS, 'USDC' as SYMBOL FROM DUAL UNION
SELECT 'Multichain' as bridge, LOWER('0xbbc4a8d076f4b1888fec42581b6fc58d242cf2d5') as BRIDGE_ADDRESS, LOWER('0x99d8a9c45b2eca8864373a26d1459e3dff1e17f3') as CONTRACT_ADDRESS, 'MIM' as SYMBOL FROM DUAL UNION
SELECT 'Multichain' as bridge, LOWER('0x739ca6d71365a08f584c8fc4e1029045fa8abc4b') as BRIDGE_ADDRESS, LOWER('0x6b175474e89094c44da98b954eedeac495271d0f') as CONTRACT_ADDRESS, 'DAI' as SYMBOL FROM DUAL UNION
SELECT 'Multichain' as bridge, LOWER('0x22648c12acd87912ea1710357b1302c6a4154ebc') as BRIDGE_ADDRESS, LOWER('0xdac17f958d2ee523a2206206994597c13d831ec7') as CONTRACT_ADDRESS, 'USDT' as SYMBOL FROM DUAL UNION
SELECT 'Multichain' as bridge, LOWER('0xb72842d6f5fedf91d22d56202802bb9a79c6322e') as BRIDGE_ADDRESS, LOWER('0xdb25f211ab05b1c97d595516f45794528a807ad8') as CONTRACT_ADDRESS, 'EURS' as SYMBOL FROM DUAL UNION
SELECT 'Multichain' as bridge, LOWER('0x0bd19f6447cd676255c7c7b00428462b3da67e3a') as BRIDGE_ADDRESS, LOWER('0x0000000000085d4780b73119b644ae5ecd22b376') as CONTRACT_ADDRESS, 'TUSD' as SYMBOL FROM DUAL UNION
SELECT 'Multichain' as bridge, LOWER('0xe6b9d092223f39013656702a40dbe6b7decc5746') as BRIDGE_ADDRESS, LOWER('0x2260fac5e5542a773aa44fbcfedf7c193bc2c599') as CONTRACT_ADDRESS, 'WBTC' as SYMBOL FROM DUAL UNION
SELECT 'Multichain' as bridge, LOWER('0x0615dbba33fe61a31c7ed131bda6655ed76748b1') as BRIDGE_ADDRESS, LOWER('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2') as CONTRACT_ADDRESS, 'WETH' as SYMBOL FROM DUAL UNION
-- Stargate / LayerZero
SELECT 'Stargate' as bridge, LOWER('0x150f94b44927f078737562f0fcf3c95c01cc2376') as BRIDGE_ADDRESS, NULL as CONTRACT_ADDRESS, 'ETH' as SYMBOL FROM DUAL
UNION
SELECT 'Stargate' as bridge, LOWER('0xdf0770dF86a8034b3EFEf0A1Bb3c889B8332FF56') as BRIDGE_ADDRESS, lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48') as CONTRACT_ADDRESS, 'USDC' as SYMBOL FROM DUAL
UNION
SELECT 'Stargate' as bridge, LOWER('0x38EA452219524Bb87e18dE1C24D3bB59510BD783') as BRIDGE_ADDRESS, lower('0xdAC17F958D2ee523a2206206994597C13D831ec7') as CONTRACT_ADDRESS, 'USDT' as SYMBOL FROM DUAL
UNION
SELECT 'Stargate' as bridge, LOWER('0x0Faf1d2d3CED330824de3B8200fc8dc6E397850d') as BRIDGE_ADDRESS, lower('0x6B175474E89094C44Da98b954EedeAC495271d0F') as CONTRACT_ADDRESS, 'DAI' as SYMBOL FROM DUAL
UNION
SELECT 'Stargate' as bridge, LOWER('0xfA0F307783AC21C39E939ACFF795e27b650F6e68') as BRIDGE_ADDRESS, lower('0x853d955aCEf822Db058eb8505911ED77F175b99e') as CONTRACT_ADDRESS, 'FRAX' as SYMBOL FROM DUAL
UNION
SELECT 'Stargate' as bridge, LOWER('0x590d4f8A68583639f215f675F3a259Ed84790580') as BRIDGE_ADDRESS, lower('0x57Ab1ec28D129707052df4dF418D58a2D46d5f51') as CONTRACT_ADDRESS, 'SUSD' as SYMBOL FROM DUAL
UNION
-- HOP USDC Bridge
SELECT 'Hop' as bridge, LOWER('0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a') as BRIDGE_ADDRESS, LOWER('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48') as CONTRACT_ADDRESS, 'USDC' as SYMBOL FROM DUAL
UNION
Run a query to Download Data