SELECT block_timestamp::date AS date
, CASE WHEN tx_from = '2AQdpHJ2JpcEgPiATUXjQxA8QmafFegfQwSLWSprPicm' THEN 'from_2AQdpH'
WHEN tx_to = '2AQdpHJ2JpcEgPiATUXjQxA8QmafFegfQwSLWSprPicm' THEN 'to_2AQdpH'
ELSE 'Other Tx' END AS tx_type
, ROUND(SUM(amount)) AS amt
, COUNT(1) AS n_tx
FROM solana.core.fact_transfers t
WHERE block_timestamp >= '2022-09-01'
AND mint = 'So11111111111111111111111111111111111111112'
GROUP BY 1, 2
ORDER BY 1, 2, 3