vendettaEVM - 8. 1-Up The Mountain - Price copy
Updated 2023-02-17
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
›
⌄
-- forked from 358a40e5-75a4-4e52-b050-0b773e3cd89b
-- An Avalanche has been building up steam as of late — the price of AVAX rose by nearly 100% in the month of January and BTC
-- hodlers have been moving holdings to the Avalanche chain.
-- What’s been fueling this growth over the past month — and what does the future hold for Avalanche?
-- Will this growth continue into the new year? Or will growth stagnate as 2023 continues to progress?
-- USDC Payouts:
-- Rank USDC amount
-- First place 100
-- 2nd through 18th place 50
with t1 as
(
select
recorded_hour::date as date,
avg(close) as avax_price_usd,
avax_price_usd - lag(avax_price_usd, 1) ignore nulls over (order by date asc) as avax_daily_change,
100 * (avax_daily_change/avax_price_usd) as avax_daily_change_pct
from crosschain.core.fact_hourly_prices
where 1=1
and recorded_hour >= '2023-01-01'
and id in('avalanche-2')
group by 1
),
t2 as
(
select
recorded_hour::date as date,
avg(close) as btc_price_usd,
btc_price_usd - lag(btc_price_usd, 1) ignore nulls over (order by date asc) as btc_daily_change,
100 * (btc_daily_change/btc_price_usd) as btc_daily_change_pct
from crosschain.core.fact_hourly_prices
where 1=1
and recorded_hour >= '2023-01-01'
and id in('bitcoin')
group by 1
Run a query to Download Data