select block_timestamp::date as fecha,

count(tx_id) as swaps,

sum(swaps) over (order by fecha) as cum_swaps

from flow.core.fact_swaps

group by 1

order by 2 desc

),

nft_sales as (

select block_timestamp::date as fecha,

count(tx_id) as nft_sales,

sum(nft_sales) over (order by fecha) as cum_sales

from flow.core.fact_nft_sales

group by 1

order by 1 desc

),

event_borrows as (

select block_timestamp::date as fecha,

count(distinct tx_id) as txs,

sum (txs) over (order by fecha) as cum_txs

from flow.core.fact_events

where (event_type = 'Borrow' or event_type = 'RepayBorrow')

and tx_succeeded = TRUE

group by 1

order by 1

),

event_FLOAT as (

select block_timestamp::date as fecha,

count(distinct tx_id) as txs,

sum (txs) over (order by fecha) as cum_txs

from flow.core.fact_events

where event_type = 'FLOATClaimed'

and tx_succeeded = TRUE