MLDZMNfNFT6
Updated 2022-09-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with price AS (
select
BLOCK_TIMESTAMP::date as day1,
(sum(SWAP_TO_AMOUNT)/sum(SWAP_FROM_AMOUNT)) as price_usd
from solana.core.fact_swaps
where SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112'
and SWAP_TO_MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
and day1>='2022-05-01'
group by 1)
select
CONTRACT_NAME as NFT_project,
count(distinct PURCHASER) as number_purchasers,
sum(SALES_AMOUNT*price_usd) as volume
from solana.core.fact_nft_sales x join solana.core.dim_nft_metadata y on x.mint=y.mint
inner join price on price.day1=date_trunc('day',BLOCK_TIMESTAMP)
where SUCCEEDED='TRUE'
and tx_id is not NULL
group by 1
order by 3 desc
limit 10
Run a query to Download Data