SELECT
date_trunc('day',block_timestamp) as date,
symbol as stable_coins,
count(symbol) as volume
from ethereum.transactions
where symbol = 'DAI' or symbol = 'USDC' or symbol = 'USDT' or symbol = 'BTC' or symbol = 'ETH'
group by 1, 2
order by date asc