SELECT

date_trunc('{{Time_Frame}}', block_timestamp) AS date,

count(distinct SWAPPER) AS SWAPPER,

count(distinct TX_HASH) AS TX,

round(sum(amount_in_usd)) AS volume

FROM

aptos.defi.ez_dex_swaps

WHERE

amount_in_usd IS NOT NULL

AND block_timestamp::date >= '2024-01-01'

AND PLATFORM = '{{DEX}}'

GROUP BY

date_trunc('{{Time_Frame}}', block_timestamp)

),

cumulative_data AS (

SELECT

date,

SWAPPER,

TX,

volume

FROM

base_data

date,

SWAPPER,

TX,

volume,

round(volume::numeric / SWAPPER, 2) AS volume_per_swapper,

round(TX::numeric / SWAPPER, 2) AS tx_per_swapper

FROM

cumulative_data

ORDER BY

date;