swap amount ratio pt2

Abbas_ra21swap amount ratio pt2

Updated 2022-11-04

SELECT DATE_TRUNC('day',BLOCK_TIMESTAMP) as day,

PLATFORM,

AVG(AMOUNT_OUT)/avg(AMOUNT_IN) as RATIO FROM ethereum.core.ez_dex_swaps

WHERE TOKEN_OUT=lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48') AND TOKEN_in=lower('0x6B175474E89094C44Da98b954EedeAC495271d0F')

and BLOCK_TIMESTAMP::date >= dateadd('month',-1,CURRENT_DATE)

group by 1,2 order by 1

Run a query to Download Data

flipside