mz0111social 1
Updated 2023-03-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
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