(

select

address,

-- block_timestamp,

balance

-- date_trunc('hour', block_timestamp) as date

from algorand.account a

left join algorand.block b

on a.created_at = b.block_id

where block_timestamp >= '2022-05-04'

and block_timestamp <= '2022-05-10'

and balance = 0.25

)

-- *

tx_sender,

count(distinct tx_id)

from algorand.transfers

where receiver in

select

address

from new_wallets

)

group by 1

order by 2 desc