0x_spadeNo Of Swaps on EVM chain
Updated 2024-10-09
9
1
2
3
4
5
6
7
8
9
›
⌄
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