With raw as
(
SELECT
block_timestamp,
tx_hash,
from_address,
from_address,
amount
FROM ethereum.core.ez_native_transfers
WHERE from_address = lower('0xd8dA6BF26964aF9D7eEd9e03E53415D37aA96045')
and block_timestamp::date >= '2024-01-01'
LIMIT 10;
)
Select
date_trunc('month', block_timestamp) as monthly,
sum(amount)
from raw
group by all
Order by monthly asc