datavortexOverall
    Updated 2024-09-12
    SELECT
    COUNT(DISTINCT tx_id) AS nft_sales,
    COUNT(DISTINCT CASE WHEN tx_succeeded = 'True' THEN tx_id END) AS successful_sales,
    COUNT(DISTINCT CASE WHEN tx_succeeded = 'False' THEN tx_id END) AS unsuccessful_sales,
    (COUNT(DISTINCT CASE WHEN tx_succeeded = 'True' THEN tx_id END) * 100.0 / COUNT(DISTINCT tx_id)) AS success_rate,
    COUNT(DISTINCT CASE WHEN event_type = 'sale' THEN tx_id END) AS direct_sales_transactions,
    COUNT(DISTINCT CASE WHEN event_type = 'bid_won' THEN tx_id END) AS bid_won_transactions,
    COUNT(DISTINCT CASE WHEN event_type = 'redeem' THEN tx_id END) AS redeem_transactions,
    COUNT(DISTINCT buyer_address) AS distinct_buyers,
    COUNT(DISTINCT seller_address) AS distinct_sellers,
    (COUNT(DISTINCT buyer_address) + COUNT(DISTINCT seller_address)) AS total_traders,
    SUM(amount_usd) AS volume_traded,
    COUNT(DISTINCT project_name) As total_assets
    FROM
    sei.nft.ez_nft_sales
    WHERE
    platform_name = 'pallet';

    QueryRunArchived: QueryRun has been archived