headitmanagerNumbers /Volume of NFT sales over time
Updated 2022-07-20
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
›
⌄
with Aurory_nft as (select distinct mint from solana.dim_nft_metadata where token_name='Aurory')
,nft_sales_count_volums as (select count(*),sum(sales_amount) from solana.core.fact_nft_sales inner join Aurory_nft
on Aurory_nft.mint=solana.core.fact_nft_sales.mint)
,nft_sales as (select count(*),sum(sales_amount),block_timestamp::date from solana.core.fact_nft_sales inner join Aurory_nft
on Aurory_nft.mint=solana.core.fact_nft_sales.mint
group by block_timestamp::date)
,nft_sales_market_place as (select count(*),sum(sales_amount),marketplace,block_timestamp::date from solana.core.fact_nft_sales inner join Aurory_nft
on Aurory_nft.mint=solana.core.fact_nft_sales.mint
group by marketplace,block_timestamp::date)
,staking_count_volume as (select count(distinct tx_id) , sum(inner_instruction:instructions[1]:parsed:info:amount/1e9) from solana.fact_events
where program_id='STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5')
,staking as (select count(distinct tx_id) , sum(inner_instruction:instructions[1]:parsed:info:amount/1e9),block_timestamp::date from solana.fact_events
where program_id='STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5'
group by block_timestamp::date)
, expedition as (select count(distinct pre_token_balances[0]:mint),block_timestamp::date
from solana.fact_transactions
inner join Aurory_nft on Aurory_nft.mint=pre_token_balances[0]:mint
where instructions[0]:programId='EXpwP3pqPzA4arF8i89w7smtvxHzyYETmCpPspLPrR7J' and post_token_balances[0]:owner='ASGSU7Eeyz5wprVfqbKXQ5xB2sCqrCPUFFzmHggbX8Dm'
group by block_timestamp::date)
select * from nft_sales
Run a query to Download Data