Hessishcity - prices
Updated 2022-11-15
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
›
⌄
With near as (select TIMESTAMP::date as datex, avg( PRICE_USD) as price
from near.core.fact_prices
where symbol = 'wNEAR' and timestamp >= '2022-11-07' and timestamp < '2022-11-15'
GROUP BY 1 ),
sol as (select block_timestamp::date as datex,
median (swap_to_amount/swap_from_amount) as Price
from solana.fact_swaps
where swap_from_mint = 'So11111111111111111111111111111111111111112'
and swap_to_mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB') --USDC,USDT
and swap_to_amount > 0
and swap_from_amount > 0
and block_timestamp >= '2022-11-07' and block_timestamp < '2022-11-15'
group by 1
) ,
flow as
(select timestamp::date as datex, avg (price_usd) as price
from flow.core.fact_prices
where symbol = 'FLOW' and source = 'coinmarketcap'
and timestamp >= '2022-11-07' and timestamp < '2022-11-15'
group by 1)
select *, 'NEAR' as token from near
UNION
select * ,'SOL' as token from sol
union
select *, 'FLOW' as token from flow
Run a query to Download Data