Updated 2023-01-09
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 tbl_NewUsers as
(
select count(1) ,created_date from (select SIGNERS[0] as users , min(to_date(block_timestamp)) as created_date from solana.core.fact_transactions
where SUCCEEDED='TRUE' and to_date(block_timestamp) > current_date - interval '90 days'
group by users)
group by created_date
)
,tbl_token_prices as
(
select avg(CLOSE) as prices , to_date(RECORDED_HOUR) as price_date from solana.core.ez_token_prices_hourly
where price_date > current_date - interval '90 days' and symbol='sol'
group by price_date
)
,tbl_top50_nft as
(
select sum(SALES_AMOUNT) as sales_amount , LABEL from solana.core.fact_nft_sales inner join
solana.core.dim_labels
on mint=address
where to_date(block_timestamp) > current_date - interval '90 days'
group by LABEL
order by sales_amount desc
limit 50
)
,tbl_top50nft_price as
(
select sum(SALES_AMOUNT)/count(*) as nft_price , to_date(block_timestamp) as date,LABEL as nft from solana.core.fact_nft_sales inner join
solana.core.dim_labels
on mint=address
where to_date(block_timestamp) > current_date - interval '90 days' and nft in (select LABEL from tbl_top50_nft)
group by date,nft
)
, tbl_tokens_swap_to_solana as
(
select count(SWAPPER) ,sum(SWAP_TO_AMOUNT) , avg(SWAP_TO_AMOUNT) ,to_date(block_timestamp) as date
from solana.core.fact_swaps
where SWAP_TO_MINT='So11111111111111111111111111111111111111112' and to_date(block_timestamp) > current_date - interval '90 days'
Run a query to Download Data