select tx_signer_address

from (

values

('relay.tg'),

('hotwallet.kaiching'),

('0-relay.hot.tg'),

('users.kaiching'),

('sweat-relayer.near')

) as v(tx_signer_address)

select

date_trunc('week', t.block_timestamp) as week_,

case

when t.tx_signer ILIKE '%tg' then 'TG'

when t.tx_signer ILIKE '%kaiching' then 'Kaiching'

when t.tx_signer ILIKE 'sweat%' then 'Sweat'

end as wallet_,

count(t.tx_hash) as n_abstracted_tx

from near.core.fact_transactions t

inner join wallet_target w

on t.tx_signer = w.tx_signer_address

where t.block_timestamp >= '2024-01-01'

and t.block_timestamp < '2024-10-28'

group by week_, wallet_

order by week_ asc