DAY | SOURCE | DESTINATION | COOK_TRANSFERRED | |
|---|---|---|---|---|
1 | 2025-02-18 00:00:00.000 | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 0x00354d59e829fb79e2ff7d8a022553728520cb6a | 55736948 |
2 | 2024-11-13 00:00:00.000 | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 0x5989245e6f296cb84a15cb4882016daa4f9f7b83 | 24975000 |
3 | 2024-11-12 00:00:00.000 | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 0x00354d59e829fb79e2ff7d8a022553728520cb6a | 150000000 |
4 | 2024-11-12 00:00:00.000 | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 0x5989245e6f296cb84a15cb4882016daa4f9f7b83 | 25000 |
5 | 2024-10-29 00:00:00.000 | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 0xfb770638ac4bc24720aac4b337ec098a26685f64 | 4999900 |
6 | 2024-10-28 00:00:00.000 | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 0xf348b307fddf09c0250644c772b2fb97fcf843f5 | 14201952 |
7 | 2024-10-28 00:00:00.000 | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 0x6c925c8e8ce70706c5bc7ec6d8b5440de9e72881 | 100 |
8 | 2024-10-28 00:00:00.000 | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 0xfb770638ac4bc24720aac4b337ec098a26685f64 | 100 |
9 | 2024-10-22 00:00:00.000 | 0x00354d59e829fb79e2ff7d8a022553728520cb6a | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 248950000 |
10 | 2024-10-18 00:00:00.000 | 0x00354d59e829fb79e2ff7d8a022553728520cb6a | 0xf348b307fddf09c0250644c772b2fb97fcf843f5 | 50000000 |
11 | 2024-10-18 00:00:00.000 | 0x00354d59e829fb79e2ff7d8a022553728520cb6a | 0xcc401649651a98ad9aede0146b89fa567c98bbb3 | 50000 |
12 | 2024-10-17 00:00:00.000 | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 0xcc401649651a98ad9aede0146b89fa567c98bbb3 | 1000 |
13 | 2024-10-17 00:00:00.000 | 0x00354d59e829fb79e2ff7d8a022553728520cb6a | 0xcc401649651a98ad9aede0146b89fa567c98bbb3 | 4000000000 |
14 | 2024-09-02 00:00:00.000 | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 0x432abccb04ddd86db9aa91fa3e03fb566270c9ff | 10000 |
15 | 2024-09-02 00:00:00.000 | 0x00354d59e829fb79e2ff7d8a022553728520cb6a | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 1000000 |
16 | 2024-08-27 00:00:00.000 | 0x0000000000000000000000000000000000000000 | 0x00354d59e829fb79e2ff7d8a022553728520cb6a | 5000000000 |
10Blockchain4) Treasury Flows on Ethereum (L1)
Updated 2025-02-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH treasury_addresses AS (
SELECT LOWER('0x00354d59E829fB79e2Ff7D8a022553728520cB6A') AS addr -- MPTreasuryL1-Core
UNION ALL
SELECT LOWER('0x18d336d33a5be54cC62C9034e3a66e3220AA268a') -- MPTreasuryL1-Eco
UNION ALL
SELECT LOWER('0xfB7e8892fBDa0205f6BbdbCd90dD9b0bDD321D16') -- MPTreasuryL1-Rewards
)
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
from_address AS source,
to_address AS destination,
SUM(raw_amount) / 1e18 AS cook_transferred
FROM ethereum.core.fact_token_transfers
WHERE contract_address = LOWER('0x9F0C013016E8656bC256f948CD4B79ab25c7b94D')
AND block_timestamp >= '2023-01-01'
AND (
LOWER(from_address) IN (SELECT addr FROM treasury_addresses)
OR LOWER(to_address) IN (SELECT addr FROM treasury_addresses)
)
GROUP BY 1, 2, 3
ORDER BY day DESC;
Last run: about 2 months ago
16
2KB
5s