-- *

date_trunc('day',block_timestamp) as day,

sum(amount) as comp,

sum(amount_usd) as comp_usd

FROM ethereum.udm_events

WHERE to_address = LOWER('0xE6c78b85f93c25B8EE7d963fD15d1d53a00F5908')

AND symbol = 'COMP'

AND block_timestamp >= getdate() - interval '30 days'

GROUP BY 1

ORDER BY 1 DESC

LIMIT 100