emirprince95Terra Addresses Interactions with Native Currencies in the Latest 90 Days
    Updated 2021-10-11
    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
    Run a query to Download Data