flipside

    colourful-magenta
    winnie-fscolourful-magenta
    Updated 2025-01-16
    SELECT
    SUM(swap_from_amount) as total_from_amount,
    COUNT(DISTINCT swapper) as distinct_traders
    FROM
    solana.defi.fact_swaps
    --WHERE swap_from_mint = '{token_mint}'
    WHERE BLOCK_TIMESTAMP > CURRENT_TIMESTAMP() - INTERVAL '24 HOURS'
    QueryRunArchived: QueryRun has been archived