Price per Day

Eman-RazPrice per Day

Updated 2023-11-07

select date_trunc('day',hour) as date, max(price) as "Maximum", min(price) as "Minimum", avg(price) as "Average",

max(price)-min(price) as "RoPC"

from ethereum.core.fact_hourly_token_prices

where symbol='{{DEX_Token}}' and

(token_address='0x1f9840a85d5af5bf1d1762f925bdaddc4201f984' --uni

or token_address='0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f' --snx

or token_address='0xd533a949740bb3306d119cc777fa900ba034cd52' --crv

or token_address='0x111111111117dc0aa78b770fa6a738034120c302' --1inch

or token_address='0xbbbbca6a901c926f240b89eacb641d8aec7aeafd' --lrc

or token_address='0xba100000625a3754423978a60c9317c58a424e3d' --bal

or token_address='0x6b3595068778dd592e39a122f4f5a5cf09c90fe2' --sushi

or token_address='0x92d6c1e31e14520e676a687f0a93788b716beff5' --dydx

or token_address='0xe41d2489571d322189246dafa5ebde1f4699f498' --zrx

or token_address='0x43dfc4159d86f3a37a5a4b3d4580b888ad7d4ddd' --dodo

or token_address='0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c') --bnt

group by 1

order by 1

-- UNI, BAL, BNT, CRV, DODO, DYDX, LRC, SNX, SUSHI, ZRX, 1INCH

Run a query to Download Data

flipside