select block_timestamp,

tx_id

from osmosis.core.fact_transfers x

join osmosis.core.dim_labels on currency = address

where project_name in ('USDC.axl','USDC.grv')

and block_timestamp::date >= current_date - 30

)

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

label,

count(distinct a.tx_id) as transactions

from osmosis.core.fact_msg_attributes a

join osmosis.core.dim_labels on attribute_value = address

join usdc_wallets using (tx_id)

where a.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