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 | 0xfb770638ac4bc24720aac4b337ec098a26685f64 | 100 |
7 | 2024-10-28 00:00:00.000 | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 0x6c925c8e8ce70706c5bc7ec6d8b5440de9e72881 | 100 |
8 | 2024-10-28 00:00:00.000 | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 0xf348b307fddf09c0250644c772b2fb97fcf843f5 | 14201952 |
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 | 0x00354d59e829fb79e2ff7d8a022553728520cb6a | 0xcc401649651a98ad9aede0146b89fa567c98bbb3 | 4000000000 |
13 | 2024-10-17 00:00:00.000 | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 0xcc401649651a98ad9aede0146b89fa567c98bbb3 | 1000 |
14 | 2024-09-02 00:00:00.000 | 0x00354d59e829fb79e2ff7d8a022553728520cb6a | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 1000000 |
15 | 2024-09-02 00:00:00.000 | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 0x432abccb04ddd86db9aa91fa3e03fb566270c9ff | 10000 |
16 | 2024-08-27 00:00:00.000 | 0x0000000000000000000000000000000000000000 | 0x00354d59e829fb79e2ff7d8a022553728520cb6a | 5000000000 |
10Blockchain7) Combined / Aggregated Query Example
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
23
›
⌄
WITH cook_transfers AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
from_address,
to_address,
raw_amount / 1e18 AS cook_amount
FROM mantle.core.ez_token_transfers
WHERE contract_address = LOWER('0x9F0C013016E8656bC256f948CD4B79ab25c7b94D')
AND block_timestamp >= '2023-01-01'
)
SELECT
day,
CASE WHEN GROUPING(from_address) = 1 THEN 'ALL' ELSE from_address END AS source,
CASE WHEN GROUPING(to_address) = 1 THEN 'ALL' ELSE to_address END AS destination,
COUNT(*) AS nb_transfers,
SUM(cook_amount) AS total_cook_traded
FROM cook_transfers
GROUP BY GROUPING SETS (
(day, from_address, to_address),
(day)
)
ORDER BY day DESC;
Last run: 2 months ago
16
2KB
4s