select event_from as address, event_from_address_name as name_of_address, event_currency as currency, sum(event_amount_usd) as volume_in_usd, count(event_currency) as frequency
from terra.transfers
where date_trunc('day', block_timestamp) >= date_trunc('day', current_date) - 90 and event_amount_usd != 0
group by event_from, event_currency, event_from_address_name
order by volume_in_usd DESC, frequency DESC