vegardTotal Near transactions in Cexs since inception
    Updated 2022-11-08
    select
    count(distinct(tx_hash)) as tx_num,
    count(distinct(tx_signer)) as signers_num,
    count(distinct(tx_receiver)) as receivers_num
    from near.core.fact_transactions a
    join near.core.dim_address_labels b
    on a.tx_receiver = b.address
    where l2_label in ('distributor_cex_satellite', 'distributor_cex')
    and tx_status = 'Success'
    Run a query to Download Data