StangFASTinteractions
Updated 2023-06-27
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
›
⌄
-- forked from 01 @ https://flipsidecrypto.xyz/edit/queries/6b4d366b-91ba-452a-9497-1bbc059cbb00
with
total_user AS
(
SELECT
min( a.block_timestamp ) AS date
, a.signer_id AS users
FROM
near.social.fact_addkey_events a
JOIN
near.core.fact_transactions b
ON a.tx_hash = b.tx_hash
GROUP BY 2
ORDER BY 1 DESC
)
SELECT
CASE
when users NOT IN ( SELECT DISTINCT signer_id FROM near.social.fact_decoded_actions ) then 'Not interacted' else 'Interacted'
END
AS type
, count( DISTINCT users ) AS total_users
FROM
total_user
GROUP BY 1
Run a query to Download Data