AzinCompare markets
Updated 2023-10-21
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 solprice as
(select
avg(PRICE) as price ,
date_trunc('day',HOUR ) as date
from
crosschain.price.ez_hourly_token_prices
where
SYMBOL='SOL'
group by date)
, solvolume as
(select
count(*) as number ,
sum(SALES_AMOUNT) as volume,
date_trunc('day',BLOCK_TIMESTAMP ) as date
from
solana.nft.fact_nft_sales
where
PROGRAM_ID='M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K'
group by date)
, solvolume2 as
(select
a.date as datee,
volume*price as USD_volume,
number
from
solvolume a left join solprice b
on a.date=b.date),
price as
(select
avg(CLOSE) as price ,
date_trunc('day',RECORDED_HOUR) as date ,
ID
from
Run a query to Download Data