SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS datetime,

SUM(ETH_VALUE) AS val,

COUNT(*) AS cnt,

COUNT(DISTINCT FROM_ADDRESS) AS unique_address

FROM ethereum.core.fact_traces

WHERE TO_ADDRESS='0xae7ab96520de3a18e5e111b5eaab095312d7fe84'

AND INPUT LIKE '0xa1903eab%'

GROUP BY datetime

CAST(datetime AS DATE) AS formatted_date,

/* CONCAT(DAY(datetime), '-', MONTHNAME(datetime)) AS human_date, */

CAST(val AS INT) AS ETH_submitted,

cnt AS deposits,

unique_address AS unique_sender

FROM deposits

ORDER BY 1 DESC

LIMIT 90;