0x_spadeNo Of Swaps on EVM chain
    Updated 2024-10-09
    SELECT
    date_trunc('month', block_timestamp) AS month,
    Count (distinct tx_hash) as n_swaps,
    SUM(COUNT(DISTINCT tx_hash)) OVER (ORDER BY date_trunc('month', block_timestamp)) AS cumulative_swaps
    FROM sei.core_evm.fact_event_logs
    WHERE origin_function_signature = '0x52bbbe29' -- this origin function signature is for swaps
    AND block_timestamp >= '2024-01-01'
    GROUP BY date_trunc('month', block_timestamp)
    ORDER BY month;
    QueryRunArchived: QueryRun has been archived