mariyaWeekly Solana NFT Sales
Updated 2022-12-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH tab0 as (
SELECT
date_trunc('week', hour) as day1,
avg(price) as sol_price
FROM ethereum.core.fact_hourly_token_prices
WHERE token_address LIKE lower('0xD31a59c85aE9D8edEFeC411D448f90841571b89c')
GROUP BY 1
)
SELECT
date_trunc('week', block_timestamp) as day,
-- contract_name,
sum(sales_amount * sol_price) as volume_usd,
count(DISTINCT tx_id) as sales_events,
COUNT(DISTINCT PURCHASER) as buyers
FROM solana.core.fact_nft_sales
LEFT OUTER JOIN solana.core.dim_nft_metadata
ON solana.core.fact_nft_sales.mint = solana.core.dim_nft_metadata.mint
LEFT outer JOIN tab0
ON day1 = date_trunc('week', block_timestamp)
WHERE block_timestamp > '2022-10-01'
GROUP BY 1