select

SYMBOL

,sum(AMOUNT_USD) as buy_volume

,count(distinct TX_HASH) as buys

from ronin.core.ez_token_transfers

where ORIGIN_TO_ADDRESS='0x7d0556d55ca1a92708681e2e231733ebd922597d'

and ORIGIN_FROM_ADDRESS=TO_ADDRESS

and BLOCK_TIMESTAMP::date>=current_date-30

and AMOUNT_USD is not null

group by 1

order by 2 desc

limit 10