tx_signer as user

from near.core.fact_transactions

where TX_SUCCEEDED = 'true'

select block_timestamp,

tx_receiver as user

from near.core.fact_transactions

where TX_SUCCEEDED = 'true'

,

tb2 as ( select min(block_timestamp) as min,

user

from tb1

group by 2)

,

tb3 as (select trunc(min,'day') as daily,

count(DISTINCT user) as users

from tb2

where min::date >= '2024-06-01' and min::date < '2024-08-01'

group by 1)

select daily,

case when daily >= '2024-06-01' and daily < '2024-07-01' then 'June' else 'July' end as month,

users,

rank() over (partition by month order by daily asc) as day

from tb3

qualify day <= 30