DATE_TRUNC('day', block_timestamp) AS date,

platform,

COUNT(DISTINCT tx_id) AS number_of_transactions,

COUNT(DISTINCT swapper) AS number_of_users,

SUM(amount_in)/1e6 AS total_amount_usd_in,

SUM(amount_out)/1e6 AS total_amount_sei_out

sei.defi.fact_dex_swaps

WHERE

block_timestamp >= '2024-02-01'

GROUP BY

1, 2

HAVING

SUM(amount_in)/1e6 < 1000000

AND SUM(amount_out)/1e6 < 1000000

ORDER BY

date;