h4wksales 2
    Updated 2023-11-07
    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