NakedCollector2023-03-28 10:25 AM
    Updated 2023-03-28
    SELECT
    token_name,
    sum(sales_amount) as sales_volume,
    count(DISTINCT tx_id) as sales_events
    FROM solana.core.fact_nft_sales
    LEFT OUTER JOIN solana.core.dim_nft_metadata
    ON solana.core.fact_nft_sales.mint = contract_address
    --WHERE NOT token_name is NULL
    where token_name like('%Runners%')
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 20
    Run a query to Download Data