date_trunc('day' , block_timestamp) as daily,

sum(amount) as total,

COUNT(tx_id) as transactions,

from_label,

FROM ethereum.udm_events

WHERE symbol='PSP' and amount > 0 AND event_type='erc20_transfer' AND block_timestamp >= getdate() - interval '4 months'

GROUP BY daily,from_label,to_label having to_label is not null

ORDER BY daily