articoloquintoFLOOR token price + rebase rewards
Updated 2022-07-04
9
1
2
3
4
5
6
7
8
9
›
⌄
select f."price", f."price"+f."price"*sum(r."rebase") over (order by r."date") as "price + rebase rewards", f."date" from(
select PRICE as "price", "HOUR" as "date" from ethereum.core.fact_hourly_token_prices
where TOKEN_ADDRESS = lower('0xf59257E961883636290411c11ec5Ae622d19455e') and "HOUR" >= DATEADD(day, -90, GETDATE())) as f
inner join(
select 0.000262557077625571 as "rebase", "HOUR" as "date" from ethereum.core.fact_hourly_token_prices
where TOKEN_ADDRESS = lower('0xf59257E961883636290411c11ec5Ae622d19455e') and "HOUR" >= DATEADD(day, -90, GETDATE())) as r
on f."date" = r."date"
order by 3 asc
Run a query to Download Data