zakkisyedSushi AMM
Updated 2022-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select daily, 0.0025*volume as fees_collected
FROM
(
SELECT
date_trunc('day',block_timestamp) as daily , sum(amount_usd) as volume
--CASE WHEN platform like 'sushiswap' THEN 'sushi' ELSE 'uni' END AS platforms
from ethereum.dex_swaps
where platform = 'sushiswap'
--or platform = 'uniswap-v2'
and block_timestamp > CURRENT_DATE - 102
group by 1
order by 1 desc
)
Run a query to Download Data