nsa2000total number of the transactions on Gnosis for xDAI versus other tokens transfered
    Updated 2022-10-16
    select
    block_timestamp::date as date,
    'xDAI' as transfer,
    count(distinct origin_from_address) as Users_Count,
    count(distinct tx_hash) as tx_cnt,
    sum(tx_cnt) over (order by date) as cum_tx_cnt
    from gnosis.core.ez_xdai_transfers
    where block_timestamp >= '2022-05-17'
    group by 1,2

    UNION
    select
    block_timestamp::date as date,
    'Other Tokens' as transfer,
    count(distinct origin_from_address) as Users_Count,
    count(distinct tx_hash) as tx_cnt,
    sum(tx_cnt) over (order by date) as cum_tx_cnt
    from gnosis.core.fact_token_transfers
    where block_timestamp >= '2022-05-17'
    group by 1,2
    Run a query to Download Data