select event_currency as currency, sum(event_amount_usd) as volume_in_usd
from terra.transfers
where date_trunc('day', block_timestamp) >= date_trunc('day', current_date) - 90 and event_amount_usd != 0
group by event_currency
order by volume_in_usd desc