select

min(BLOCK_TIMESTAMP) as min_time,

tx_from as wallet

from

osmosis.core.fact_transactions

group by

2

)

select

date_trunc('week', min_time) as week,

count (tx_id) as tx,

LABEL

from

osmosis.core.fact_staking

JOIn osmosis.core.dim_labels on VALIDATOR_ADDRESS = ADDRESS

LEFT OUTER JOIN actives ON min_time = BLOCK_TIMESTAMP

where

DELEGATOR_ADDRESS in (

select

wallet

from

actives

)

and ACTION = 'delegate'

GROUP by

1,

3

order by

tx desc

limit

200