headitmanagerNumbers /Volume of NFT sales over time
    Updated 2022-07-20
    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