cex_list as (

select project_name, address_name, address as tx_receiver

from near.core.dim_address_labels

where (

l2_label = 'distributor_cex_satellite' or

l2_label = 'distributor_cex'

date_trunc('day', block_timestamp)::date "Date",

count(distinct tx_hash) "Transactions Count",

count(distinct tx_signer) "Users Count",

sum ("Transactions Count") over (order by "Date") "Comulative Transactions Count",

sum ("Users Count") over (order by "Date") "Comulative Users Count"

from near.core.fact_transactions

join cex_list

using (tx_receiver)

where tx_status = 'Success'

group by 1

order by "Date", "Transactions Count" desc