moonshot21Course 3 - Homework 1
Updated 2024-08-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- Find an address of choice (maybe a treasury or your favorite influencer), and aggregate the amount of ETH sent out by month (sum by month)
SELECT
ORIGIN_FROM_ADDRESS,
SUM(AMOUNT) AS total_amount,
DATE_TRUNC('month', BLOCK_TIMESTAMP) AS month
FROM ethereum.core.ez_native_transfers
WHERE
FROM_ADDRESS = LOWER('0x329c54289ff5d6b7b7dae13592c6b1eda1543ed4')
GROUP BY
ORIGIN_FROM_ADDRESS,
DATE_TRUNC('month', BLOCK_TIMESTAMP)
ORDER BY
month;