FROM_ADDRESS AS UserAddress,

DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS TransactionDay,

COUNT(*) AS TransactionCount

FROM

bsc.core.fact_transactions;

WHERE

BLOCK_TIMESTAMP >= '2023-08-01' AND BLOCK_TIMESTAMP < '2023-09-01'

GROUP BY

FROM_ADDRESS, DATE_TRUNC('DAY', BLOCK_TIMESTAMP)

ORDER BY

TransactionDay, TransactionCount DESC;