SniperKashi pairs on Arbitrum for sushi
Updated 2022-07-07
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
›
⌄
with pools as ( select 'USDC/WETH' as pair , '0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8' as token0 , '0x82aF49447D8a07e3bd95BD0d56f35241523fBab1' as token1, '0x4E8df9C66f055940190eB6593d919bB5Ba6558A9' as contract
from arbitrum.core.fact_event_logs
UNION
select 'USDT/WBTC' as pair ,'0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9' as token0 , '0x2f2a2543B76A4166549F7aaB2e75Bef0aefC5B0f' as token1, '0x5fA33Fe1663dDFd4aa2E51736531B7aB1Ffb4703' as contract
from arbitrum.core.fact_event_logs
UNION
select 'LINK/USDT' as pair ,'0xf97f4df75117a78c1A5a0DBb814Af92458539FB4' as token0 , '0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9' as token1, '0xF3b87E78Dcaa42Ebfd309Ab458df055f3776b045' as contract
from arbitrum.core.fact_event_logs
UNION
select 'WETH/WBTC' as pair ,'0x82aF49447D8a07e3bd95BD0d56f35241523fBab1' as token0 , '0x2f2a2543B76A4166549F7aaB2e75Bef0aefC5B0f' as token1, '0x4d355A9EC3755F3A95bE11276F33c6628001846E' as contract
from arbitrum.core.fact_event_logs
UNION
select 'USDC/LINK' as pair ,'0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8' as token0 , '0xf97f4df75117a78c1A5a0DBb814Af92458539FB4' as token1, '0x9416D2018D42C62f8E545c23D7483eC8cB377DfA' as contract
from arbitrum.core.fact_event_logs
UNION
select 'USDC/WBTC' as pair ,'0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8' as token0 , '0x2f2a2543B76A4166549F7aaB2e75Bef0aefC5B0f' as token1, '0xaD010D4e3064E4de9978ce8D61A1c357Eb6EFa43' as contract
from arbitrum.core.fact_event_logs
UNION
select 'USDT/WETH' as pair ,'0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9' as token0 , '0x82aF49447D8a07e3bd95BD0d56f35241523fBab1' as token1, '0xFB274df1ba0c5908DBdB0A817Da59f3D798B7dD6' as contract
from arbitrum.core.fact_event_logs
UNION
select 'WETH/USDC' as pair , '0x82aF49447D8a07e3bd95BD0d56f35241523fBab1' as token0 , '0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8' as token1,'0xdd9fDAe46234A5CfF95C40e87D8E06423a940547' as contract
from arbitrum.core.fact_event_logs
UNION
select 'Link/WETH' as pair ,'' as token0 , '0x82aF49447D8a07e3bd95BD0d56f35241523fBab1' as token1, '0xFf9204b12E7a472401f3Fd74E6376baad2339747' as contract
from arbitrum.core.fact_event_logs
UNION
select 'WBTC/WETH' as pair ,'0x2f2a2543B76A4166549F7aaB2e75Bef0aefC5B0f' as token0 , '0x82aF49447D8a07e3bd95BD0d56f35241523fBab1' as token1, '0xc952F6A5CE6E6731CD29abD8ae9c210DA081E2A3' as contract
from arbitrum.core.fact_event_logs
UNION
select 'WBTC/USDT' as pair ,'0x2f2a2543B76A4166549F7aaB2e75Bef0aefC5B0f' as token0 , '0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9' as token1, '0xf5ee248d350E8868bbF17497D1b5F6E6B2266c74' as contract
from arbitrum.core.fact_event_logs
UNION
select 'USDT/USDC' as pair , '0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9' as token0 , '0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8' as token1,'0x1045a9856174b1B06735Cd37B01613C822d0c0BA' as contract
from arbitrum.core.fact_event_logs
UNION
Run a query to Download Data