SELECT DISTINCT

date(block_timestamp) as sol_date,

signers[0] as sol_wallet

FROM flipside_prod_db.solana.fact_transactions

WHERE block_timestamp >= '2022-05-09'

),

USED_YESTERDAY as(SELECT

s1.sol_date,

s1.sol_wallet

FROM SOL_W s1, SOL_W s2

where s1.sol_wallet=s2.sol_wallet

and s1.sol_date=dateadd('DAY', -1, s2.sol_date)

),

ACTIVE as(select t1.sol_date, t1.sol_wallet, count(*) as count

from USED_YESTERDAY t1 inner join USED_YESTERDAY t2 on t1.sol_date >= t2.sol_date and t1.sol_wallet=t2.sol_wallet

group by t1.sol_date, t1.sol_wallet

having count = datediff(day, '2022-05-09', t1.sol_date) + 1

select sol_date, count(*) as "Everyday Since 05/09"

from ACTIVE

group by sol_date

order by sol_date