Tobi_12024-06-07 11:25 PM
    Updated 2024-06-07
    SELECT
    SUM(SWAP_FROM_AMOUNT) AS total_swap_from_volume,
    SUM(SWAP_TO_AMOUNT) AS total_swap_to_volume,
    SUM(SWAP_FROM_AMOUNT + SWAP_TO_AMOUNT) AS total_traded_volume
    FROM
    solana.defi.fact_swaps;
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP());


    QueryRunArchived: QueryRun has been archived