h4wksales 2
Updated 2023-11-07
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
›
⌄
with gen3_mint_tx as (
select
block_timestamp,
tx_id,
instruction:accounts[6] as mint,
instruction:accounts[5] as minter
from solana.core.fact_events
where succeeded = TRUE and block_timestamp > '2023-07-05'
and program_id = 'CSGrdwbJ5z58tLGKjjcmiNMj8bG1Zazthk3cXMrbSZoX'
and instruction:accounts[13] = '8Rt3Ayqth4DAiPnW9MDFi63TiQJHmohfTWLMQFHi4KZH'
)
, gen3_mints as (
select distinct mint from gen3_mint_tx
)
SELECT
count(tx_id) as sale_count,
count(distinct purchaser) as unique_buyer,
sum(sales_amount) as volume,
sale_count/count(distinct date_trunc('hour', block_timestamp)) as average_tx_hour,
unique_buyer/count(distinct date_trunc('hour', block_timestamp)) as average_buyer_hour,
volume/count(distinct date_trunc('hour', block_timestamp)) as average_volume_hour
FROM solana.core.fact_nft_sales s
join gen3_mints m on s.mint = m.mint
where block_timestamp::date >= '2023-07-05' and succeeded = TRUE and sales_amount > 0
Run a query to Download Data