select block_timestamp,

tx_id

from algorand.core.ez_transaction_asset_transfer

where asset_id = 31566704 -- USDC contract

and block_timestamp::date >= current_date - 30

)

select date_trunc('day', block_timestamp) as date,

label,

count(distinct tx_id) as transactions

from algorand.core.ez_transfer a

join algorand.core.dim_label b on a.receiver = b.address

join usdc_wallets using(tx_id)

where block_timestamp::date >= current_date - 30

group by 1,2

qualify row_number() over (partition by date order by transactions desc) <= 10

order by 1