primo_dataOptimism DEXs - Daily Wallets Swaps
Updated 2022-08-01
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
›
⌄
⌄
/* Q8. Let’s take a closer look at DEXs on Optimism, specifically Velodrome. Make a dashboard that compares Velodrome to any other Optimism DEX based on:
-Total number of swaps by day over the last month
-Total number of wallets swapping by day
-What are the most popular asset pairs to swap from and too
-Top 10 assets swapping from
-Top 10 assets to swap to*/
WITH velodrome_pools AS (
SELECT * FROM (
VALUES
('0xd16232ad60188b68076a235c65d692090caba155','USDC','sUSD'),
('0x4f7ebc19844259386dbddb7b2eb759eefc6f8353','USDC','DAI'),
('0xfd7fddfc0a729ecf45fb6b12fa3b71a575e1966f','WETH','sETH'),
('0x79c912fef520be002c2b6e57ec4324e260f38e50','WETH','USDC'),
('0x47029bc8f5cbe3b464004e87ef9c9419a48018cd','OP','USDC'),
('0x207addb05c548f262219f6bfc6e11c02d0f7fdbe','USDC','LUSD'),
('0xd62c9d8a3d4fd98b27caaefe3571782a3af0a737','USDC','MAI'),
('0xe8537b6ff1039cb9ed0b71713f697ddbadbb717d','VELO','USDC'),
('0x7866c6072b09539fc0fde82963846b80203d7beb','USDC','agEUR'),
('0xadf902b11e4ad36b227b84d856b229258b0b0465','FRAX','USDC'),
('0xe75a3f4bf99882ad9f8aebab2115873315425d00','USDC','allUSDC'),
('0xcdd41009e74bd1ae4f7b2eecf892e4bc718b9302','WETH','OP'),
('0x6c5019d345ec05004a7e7b0623a91a0d9b8d590d','USDC','DOLA'),
('0x6fd5bee1ddb4dbbb0b7368b080ab99b8ba765902','allETH','WETH'),
('0x3eec44e94ee86ce79f34bb26dc3cdbbee18d6d17','WETH','AELIN'),
('0xffd74ef185989bff8752c818a53a47fc45388f08','VELO','OP'),
('0xdee1856d7b75abf4c1bdf986da4e1c6c7864d640','LYRA','USDC'),
('0x43ce87a1ad20277b78cae52c7bcd5fc82a297551','WETH','DOLA'),
('0x9355292f66552ea5717b274d27eefc8254011d83','THALES','USDC'),
('0xe2ea57fdf87624f4384ef6da5f3844e8e9e5d878','FRAX','FXS'),
('0xac49498b97312a6716ef312f389b7e4d183a2a7c','FRAX','sUSD'),
('0x5edac6b8ea08d535c01981d75b3361481c0ee999','USDC','USX'),
('0x43c3f2d0aa0ebc433d654bb6ebf67f0c03f8d8d9','OP','DAI'),
('0xfc77e39de40e54f820e313039207dc850e4c9e60','OP','L2DAO'),
('0x588443c932b45f47e936b969eb5aa6b5fd4f3369','HND','USDC'),
('0x9c8a59934fba9af82674eff5d13a24e7c7e7a1f1','USDC','PERP'),
Run a query to Download Data