alirspercentage change-Algo-WBTC-ETH
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with WBTC_price as (
select
distinct balance_date::date as day
,avg(price) as avg_WBTC_Price
from flipside_prod_db.ethereum.erc20_balances
where symbol = 'WBTC'
and balance_date >= CURRENT_DATE-180
GROUP BY 1
order by 1),
ETH_Price as (
select
distinct balance_date::date as day
,avg(price) as avg_ETH_Price
from flipside_prod_db.ethereum.erc20_balances
where symbol = 'ETH'
and balance_date >= CURRENT_DATE-180
GROUP BY 1
order by 1)
,Algo_price as(
select
distinct block_hour::date as day
,avg(price_usd) as avg_Algo_Price
from flipside_prod_db.algorand.prices_swap
where asset_id = 0
and block_hour >= CURRENT_DATE-180
GROUP BY 1
order by 1)
select WBTC_price.day,WBTC_price.avg_WBTC_Price,
ETH_price.avg_ETH_Price,Algo_price.avg_Algo_Price
from WBTC_price
Run a query to Download Data