par_rnUntitled Query
Updated 2022-12-02
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 nfts as (
SELECT *
from solana.core.dim_labels
where ADDRESS_NAME ilike 'DeGods'
),
dust_token_price as (
SELECT date_Trunc('day', block_timestamp) as pdate,
median(swap_from_amount/swap_to_amount) as dust_price,
lag(dust_price) ignore nulls over(order by pdate asc) as lag_dust_price,
((dust_price-lag_dust_price)/ lag_dust_price)*100 as dust_volatility
FROM solana.core.fact_swaps
WHERE succeeded = 'TRUE'
AND swap_to_mint = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'
AND swap_from_mint IN ('7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT','Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX')
AND swap_from_amount>0 AND swap_to_amount>0
GROUP BY 1
),
main1 as (
SELECT
date(BLOCK_TIMESTAMP) as date,
sum(SALES_AMOUNT) as sale_volume,
lag(sale_volume) ignore nulls over(order by date asc) as lag_sale_volume,
((sale_volume-lag_sale_volume)/ lag_sale_volume)*100 as sale_volume_volatility,
b.dust_volatility
from solana.core.fact_nft_sales a
join dust_token_price b
on b.pdate = date(a.BLOCK_TIMESTAMP)
where MINT in (SELECT address from nfts)
GROUP by date, b.dust_volatility
)
select
date,
sale_volume_volatility as "DeGods NFT sale volume daily volatility percentage",
Run a query to Download Data