ChiefHadesswap Volume
    Updated 2023-01-21
    -- number of traded collections on Hadeswap, does Hadeswap trade fewer collections overall than Magic Eden (ie are small collections only popular on ME)?
    WITH collections AS (
    SELECT
    block_timestamp,
    program_id as program_id_label,
    marketplace as marketplace_label,
    token_name as collection_name,
    sales_amount
    FROM SOLANA.CORE.FACT_NFT_SALES s
    LEFT JOIN SOLANA.CORE.DIM_NFT_METADATA m
    ON s.mint = m.Mint
    WHERE 1=1
    AND block_timestamp > '2022-09-01'
    AND succeeded = 'TRUE'
    AND sales_amount > 0
    AND marketplace_label = 'hadeswap'
    -- AND collection_name > 0
    -- GROUP BY 1,2
    )

    SELECT
    date_trunc('day', block_timestamp) as date,
    collection_name,
    -- sum(sales_amount) as trade_volume,
    sum(sales_amount) as volume_traded,
    -- (volume_traded/collection_count) as volume_per_collection,
    count(distinct case when marketplace_label = 'hadeswap' then collection_name END) as hadeswap_collection_count
    -- count(distinct purchaser) as distinct_buyers,
    -- count(purchaser) as buyers_count,
    -- (trade_volume / buyers_count) as avg_nft_trade_price,
    -- count(distinct seller) as distinct_sellers -- would like to examine total unique sellers and traders as one rather than seperately
    -- count(seller) as sellers_count,
    -- count(distinct tx_id) as sales_count, -- this wildly wrong, buyers count is accurate
    -- distinct_buyers/ buyers_count as buy_ratio
    FROM collections
    Run a query to Download Data