zakkisyedSushi swap sizes
Updated 2022-02-09
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
›
⌄
select
date_trunc('day', block_timestamp) AS daily,
--block_timestamp,
pool_name,
avg(amount_usd)
from ethereum.dex_swaps
where
pool_address = '0x6a091a3406e0073c3cd6340122143009adac0eda' ----top 10 pools
or pool_address = '0x397ff1542f962076d0bfe58ea045ffa2d347aca0'
or pool_address = '0xe12af1218b4e9272e9628d7c7dc6354d137d024e'
or pool_address = '0xd4e7a6e2d03e4e48dfc27dd3f46df1c176647e38'
or pool_address = '0xceff51756c56ceffca006cd410b03ffc46dd3a58'
or pool_address = '0x055475920a8c93cffb64d039a8205f7acc7722d3'
or pool_address = '0x06da0fd433c1a5d7a4faa01111c044910a184553'
or pool_address = '0xc3f279090a47e80990fe3a9c30d24cb117ef91a8'
or pool_address = '0xc3d03e4f041fd4cd388c549ee2a29a9e5075882f'
or pool_address = '0x69b81152c5a8d35a67b32a4d3772795d96cae4da'
--token_address = '0x6b3595068778dd592e39a122f4f5a5cf09c90fe2'
and
platform = 'sushiswap'
and block_timestamp > CURRENT_DATE - 30
group by 2,1
order by 1 desc
-- )
Run a query to Download Data