hessTotal Daily Volume Vs. Price Correlation ( Selected Chain )
Updated 2022-11-23
999
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 price as ( select date(hour) as date,'Ethereum' as chain, 'ETH' as symbol , avg(price) as token_price
from ethereum.core.fact_hourly_token_prices
where date >= CURRENT_DATE - {{N_Days}} and symbol = 'WETH'
group by 1,2,3
UNION
select date(TIMESTAMP) as date,'Flow' as chain, 'Flow' as symbol , avg(PRICE_USD) as token_price
from flow.core.fact_prices
where date >= CURRENT_DATE - {{N_Days}} and token = 'Flow'
group by 1,2,3
UNION
select date(hour) as date,'Optimism' as chain, 'ETH' as symbol , avg(price) as token_price
from ethereum.core.fact_hourly_token_prices
where date >= CURRENT_DATE - {{N_Days}} and symbol = 'WETH'
group by 1,2,3
UNION
select date(hour) as date,'Arbitrum' as chain, 'ETH' as symbol , avg(price) as token_price
from ethereum.core.fact_hourly_token_prices
where date >= CURRENT_DATE - {{N_Days}} and symbol = 'WETH'
group by 1,2,3
UNION
select date(RECORDED_AT) as date,'Osmosis' as chain, 'Osmo' as symbol , avg(price) as token_price
from osmosis.core.dim_prices
where date >= CURRENT_DATE - {{N_Days}} and symbol ilike '%osmo%'
group by 1,2,3
UNION
select date(BLOCK_HOUR) as date,'Algorand' as chain, 'Algo' as symbol , avg(PRICE_USD) as token_price
from algorand.defi.ez_price_swap
where BLOCK_HOUR::date >= CURRENT_DATE - {{N_Days}} and ASSET_NAME = 'Governance Algo'
group by 1,2,3
UNION
select date(block_timestamp) as date, 'Solana' as chain , 'Sol' as symbol, (sum(SWAP_TO_AMOUNT)/sum(SWAP_FROM_AMOUNT)) as token_price
from solana.core.fact_swaps
where SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112'
and SWAP_TO_MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
and date >= CURRENT_DATE - {{N_Days}}
group by 1,2,3
Run a query to Download Data