flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Profit for AMMs
sakineh5021-nIQRzB
Profit for AMMs
Updated 2022-04-12
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
SELECT
block_timestamp
::
date
as
swap_date
,
sum
(
amount_usd
)
*
0.25
/
100
as
fee_reward_for_LPs
,
count
(
tx_id
)
from
ethereum
.
dex_swaps
where
block_timestamp
::
date
>
'2022-01-01'
and
platform
=
'sushiswap'
group
by
1
Results
Run a query to Download Data