mz0111social 1
    Updated 2023-03-09
    select
    BLOCK_TIMESTAMP :: date as day,
    'follow' as action,
    count( distinct TX_HASH) as tra_num,
    count( distinct SIGNER_ID) as wallets,
    Sum(tra_num) over (partition by action order by day) as cum_tra,
    Sum(wallets) over (partition by action order by day) as cum_wallet
    from near.social.fact_decoded_actions
    where NODE = 'graph'
    and NODE_DATA ilike '%follow%'
    group by 1


    union ALL

    select
    BLOCK_TIMESTAMP :: date as day,
    'unfollow' as action,
    count( distinct TX_HASH) as tra_num,
    count( distinct SIGNER_ID) as wallets,
    Sum(tra_num) over (partition by action order by day) as cum_tra,
    Sum(wallets) over (partition by action order by day) as cum_wallet
    from near.social.fact_decoded_actions
    where node_data:graph ilike '%unfollow%'
    group by 1


    Run a query to Download Data