primo_datasushi_optimism_swaps
Updated 2022-07-19
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
›
⌄
-- Create a document that includes all addresses for all swap pairs for Sushiswap on Optimism plus the addresses of the two tokens belonging to each pair.
-- Getting the decimals for each of the tokens in the pair would be a bonus. If you are using sources from sushi github, please include the link.
WITH sushi_pools AS (
SELECT * FROM (
VALUES
('0xaA1513Ab4622ED52DeEe4Bd2cD984Fe52F336a63', '0x4200000000000000000000000000000000000006', '0x4200000000000000000000000000000000000042'),
('0x8C02104f6f5C60957318455CDc2c5e7db207aE47', '0x4200000000000000000000000000000000000042', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607'),
('0x1E31A2c6e6614273D740358AFFB46beF180EFB7B', '0x4200000000000000000000000000000000000006', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607'),
('0x3e87635b7BF86E62991C1BF2867150eee0C0d65A', '0x0994206dfE8De6Ec6920FF4D779B0d950605Fb53', '0x4200000000000000000000000000000000000006'),
('0x249C5A2B55522295500848910550D0539E1d673d', '0x4200000000000000000000000000000000000006', '0xDA10009cBd5D07dd0CeCc66161FC93D7c9000da1'),
('0xAE8bf5a9cA4e980637526ba1e5B68462D3880D49', '0x4200000000000000000000000000000000000006', '0x4200000000000000000000000000000000000042'),
('0x3E096286ffd113C51cde56f22361a6849F67A0f1', '0x4200000000000000000000000000000000000006', '0x94b008aA00579c1307B0EF2c499aD98a8ce58e58'),
('0x5231C20AF03fD827005E652AFee1B6576589F968', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607', '0xDA10009cBd5D07dd0CeCc66161FC93D7c9000da1'),
('0xf5484AD6c3a69C0ff33dfEd4Fdf5A4c7EEa13634', '0x4200000000000000000000000000000000000006', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607'),
('0x7086622E6Db990385B102D79CB1218947fb549a9', '0x4200000000000000000000000000000000000006', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607'),
('0xc3FAfa11DC8555d1404e7a1046019fF892bDA2B7', '0x4200000000000000000000000000000000000006', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607'),
('0x67A381D449750056f3250c73161da1365dce8781', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607', '0xDA10009cBd5D07dd0CeCc66161FC93D7c9000da1'),
('0x11B072C5259ebd68E888a79c49BFff0BcF742983', '0x4200000000000000000000000000000000000006', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607'),
('0x7170BD6f5Ab1aC44a1ba7a0Beb5f3f06c2D4a898', '0x4200000000000000000000000000000000000006', '0x8c6f28f2F1A3C87F0f938b96d27520d9751ec8d9'),
('0x3b3fADBbB82530408Ec67a9F3a314b51B5B65574', '0x4200000000000000000000000000000000000042', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607'),
('0x0e736045CF438d813848ffD7C9f1443dAC3E2A3D', '0x4200000000000000000000000000000000000042', '0x8c6f28f2F1A3C87F0f938b96d27520d9751ec8d9'),
('0x19847400661159f297cbEf8a6fe567dd89a44BED', '0x4200000000000000000000000000000000000006', '0x68f180fcCe6836688e9084f035309E29Bf0A2095'),
('0x5F46F0f03db438459D4CDaFb61826061a93504FC', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607', '0x94b008aA00579c1307B0EF2c499aD98a8ce58e58'),
('0x421bf64e342429992f6cE7C7E5c6a4dB6993b732', '0x4200000000000000000000000000000000000006', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607'),
('0xFDa7269b90fa2E291026c5E7e31393a58338D0De', '0x8700dAec35aF8Ff88c16BdF0418774CB3D7599B4', '0xDA10009cBd5D07dd0CeCc66161FC93D7c9000da1'),
('0x10961429dd786AbE0fcf427a72397416142AEb0F', '0x4200000000000000000000000000000000000006', '0x4200000000000000000000000000000000000042'),
('0x611165B083E5F3CF1C64b9064CC9E14E0d8B4d99', '0x1EBA7a6a72c894026Cd654AC5CDCF83A46445B08', '0x4200000000000000000000000000000000000042'),
('0x90A521471aec7064480a3BE8BE1e5738B1A6eA90', '0x4200000000000000000000000000000000000042', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607'),
('0x3Ef81036E45743DC31bee5A3fCdb226Bb1B0AA4f', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607', '0xDA10009cBd5D07dd0CeCc66161FC93D7c9000da1'),
('0x7559AA3c295Cb0db37C1D5780dE3D3f865D95131', '0x94b008aA00579c1307B0EF2c499aD98a8ce58e58', '0xDA10009cBd5D07dd0CeCc66161FC93D7c9000da1'),
('0xcfbF5dfb210248965A83Be57C0Af34B07c934A75', '0x4200000000000000000000000000000000000042', '0xDA10009cBd5D07dd0CeCc66161FC93D7c9000da1'),
('0x3A7bA3048fb3287051F6CB3dF64233F13558132C', '0x4200000000000000000000000000000000000006', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607'),
('0x37Ae52069d199Ea473dDE0cB5f41B07AAC937Dd9', '0x4200000000000000000000000000000000000006', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607'),
('0x1b67c104240478a98C7A5dfaeC5Dd4817c12F014', '0x4200000000000000000000000000000000000006', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607'),
('0x1c06A7bA4874B161fC7e72FaA579f21837bDFE33', '0x4200000000000000000000000000000000000006', '0xDA10009cBd5D07dd0CeCc66161FC93D7c9000da1'),
('0x7F17b33e19aB6379DE525073F95519d8DDeBfD02', '0x4200000000000000000000000000000000000006', '0x7F5c764cBc14f9669B88837ca1490cCa17c31607'),
Run a query to Download Data