from_address AS entity,

DATE(block_timestamp) AS transaction_date,

SUM(amount) AS daily_token_amount,

COUNT(*) AS transaction_count

FROM

ethereum.core.ez_token_transfers

WHERE

contract_address = '0x514910771af9ca656af840dff83e8264ecf986ca'

AND block_timestamp >= '2020-08-07'

AND block_timestamp <= '2020-09-07'

GROUP BY

entity, transaction_date

ORDER BY

transaction_date ASC;