anomoneFWB - new token price
Updated 2022-11-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
⌄
/*SELECT distinct ORIGIN_FUNCTION_SIGNATURE, ORIGIN_FUNCTION_NAME FROM ethereum.udm_events
WHERE contract_address = ('0x35bd01fc9d6d5d81ca9e055db88dc49aa2c699a8')
--AND to_address like '0x000000000000000000000000000000000000%'
AND origin_function_name like '%burn%'
--LIMIT 5
SELECT row_number() over(partition by POOL_NAME order by DAY desc) as rn FROM
*/
select
date_trunc('day' , hour ) as "Day",
max(PRICE)
-- row_number() over(partition by date_trunc('day' , hour ) order by hour desc) as rn
from ethereum.token_prices_hourly
WHERE TOKEN_ADDRESS = '0x35bd01fc9d6d5d81ca9e055db88dc49aa2c699a8'
GROUP BY date_trunc('day' , hour )
Run a query to Download Data