-- Tarik - revised from query by johan | Flipside Crypto:
SELECT block_timestamp::date AS metric_date,
event_currency as currency,
count(distinct tx_id) AS metric_value
FROM terra.transfers
WHERE event_currency IN('KRT',
'LUNA',
'SDT',
'UST')
and block_timestamp::date >= CURRENT_DATE - 500
GROUP BY 1,
2
ORDER BY 1 DESC,
2 DESC