base AS (

SELECT

block_timestamp::date AS date,

initcap(replace(transfer_type, '_', ' ')) AS type_transfer,

count(DISTINCT tx_id) AS tx_count,

count(DISTINCT sender) AS user_count,

sum(amount / pow(10, 18)) AS tx_amount,

sum(tx_count) OVER (

partition BY

type_transfer

ORDER BY

date_trunc('day', block_timestamp::date) ASC

) AS cumu_tx,

sum(user_count) OVER (

partition BY

type_transfer

ORDER BY

date_trunc('day', block_timestamp::date) ASC

) AS cumu_users,

sum(tx_amount) OVER (

partition BY

type_transfer

ORDER BY

date_trunc('day', block_timestamp::date) ASC

) AS cumu_tx_amount

FROM

evmos.core.fact_transfers

GROUP BY

1,

2

)

*

base