Afonso_Diaz2023-05-01 03:29 PM
Updated 2023-05-01
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
›
⌄
with
t2 as (
select
tx_id,
block_timestamp,
iff(tx_from = 'RBHdGVfDfMjfU6iUfCb1LczMJcQLx7hGnxbzRsoDNvx', tx_to, tx_from) as user
from solana.core.fact_transfers
where 'RBHdGVfDfMjfU6iUfCb1LczMJcQLx7hGnxbzRsoDNvx' in (tx_from, tx_to) --Rollbit
and mint in ('So11111111111111111111111111111111111111112', 'RLBxxFkseAZ4RgJH3Sqn8jXxhmGoz9jWxDNJMh8pL7a')
)
select
event_type as event,
count(distinct tx_id) as transactions,
count(distinct signers[0]) as users
from solana.core.fact_events
where
(signers[0]) in (select distinct user from t2)
and block_timestamp >= current_date - 90
and succeeded = 1
and event is not null
group by 1
order by users desc
limit 10
Run a query to Download Data