cryptall2024-06-01 12:05 PM
    Updated 2025-01-20
    SELECT
    symbol as "token",
    count (DISTINCT tx_id) as "Total_swaps",
    count (DISTINCT swapper) as "Total_unique_traders",
    sum (amount_in) as "Total_tokens_swapped",
    from sei.defi.fact_dex_swaps a join sei.core.dim_tokens b on a.currency_in = b.currency
    where block_timestamp >= '2023-05-30 00:00:00.000'
    GROUP by 1
    order by 2 desc
    limit 10
    QueryRunArchived: QueryRun has been archived