min(block_timestamp) as first_tx

from gnosis.core.ez_xdai_transfers

where block_timestamp >= '2022-05-17'

group by 1),

base2 as (select

eth_to_address,

date_trunc('day', first_tx) as day,

date_trunc('week', first_tx) as week,

date_trunc('month', first_tx) as month,

1 as counts

from base)

select day,

week,

month,

sum(counts) as numbering

from base2

group by 1,2,3