ML6Solana Users : Time of Returning
Updated 2022-07-16
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with sol_tbl1 as (select min(block_timestamp::date) as mi , signers as p1 from solana.core.fact_transactions group by p1)
,sol_tbl2 as (select max(block_timestamp::date) as ma , signers as p2 from solana.core.fact_transactions group by p2)
,sol_data as (select mi,ma, datediff('day',mi,ma) as range ,p1 from sol_tbl1 inner join sol_tbl2 on p1=p2)
select count(*), case
when range <=30 then 'under a month'
when range > 30 and range <=60 then 'Between 1 and 2 months'
when range > 60 then 'More than 5 months' end as retornot
from sol_data
group by retornot
Run a query to Download Data