trunc(block_timestamp,'week') AS date,

platform,

COUNT(DISTINCT tx_hash) AS swaps,

COUNT(DISTINCT origin_from_address) AS swappers,

SUM(amount_out_usd) AS volume_swapped_usd,

AVG(amount_out_usd) AS avg_volume_swapped_usd

avalanche.core.ez_dex_swaps

where block_timestamp >= current_date - 90

GROUP BY

1,2