Profit for AMMs 2

Updated 2022-04-12

SELECT block_timestamp::date as swap_date ,platform , sum(amount_usd)*0.25/100 as fee_reward_for_LPs

from ethereum.dex_swaps

where block_timestamp::date > '2022-01-01'

and platform <> 'curve'

and amount_usd <1000000

group by 1 , 2

Run a query to Download Data

flipside