DATE | ORDER_PLACED | BUYER | MUSD_AMOUNT | CUMULATIVE_ORDER_PLACED | CUMULATIVE_BUYER | CUMULATIVE_MUSD_AMOUNT | |
|---|---|---|---|---|---|---|---|
1 | 2025-04-12 00:00:00.000 | 43 | 32 | 36700 | 5931 | 3412 | 4304900 |
2 | 2025-04-11 00:00:00.000 | 492 | 300 | 339000 | 5888 | 3380 | 4268200 |
3 | 2025-04-10 00:00:00.000 | 595 | 332 | 410300 | 5396 | 3080 | 3929200 |
4 | 2025-04-09 00:00:00.000 | 709 | 376 | 540500 | 4801 | 2748 | 3518900 |
5 | 2025-04-08 00:00:00.000 | 736 | 404 | 522200 | 4092 | 2372 | 2978400 |
6 | 2025-04-07 00:00:00.000 | 567 | 378 | 387900 | 3356 | 1968 | 2456200 |
7 | 2025-04-06 00:00:00.000 | 632 | 441 | 462800 | 2789 | 1590 | 2068300 |
8 | 2025-04-05 00:00:00.000 | 639 | 372 | 437900 | 2157 | 1149 | 1605500 |
9 | 2025-04-04 00:00:00.000 | 493 | 274 | 362300 | 1518 | 777 | 1167600 |
10 | 2025-04-03 00:00:00.000 | 327 | 203 | 259100 | 1025 | 503 | 805300 |
11 | 2025-04-02 00:00:00.000 | 166 | 84 | 138800 | 698 | 300 | 546200 |
12 | 2025-04-01 00:00:00.000 | 62 | 30 | 41800 | 532 | 216 | 407400 |
13 | 2025-03-31 00:00:00.000 | 51 | 34 | 42300 | 470 | 186 | 365600 |
14 | 2025-03-30 00:00:00.000 | 268 | 96 | 207600 | 419 | 152 | 323300 |
15 | 2025-03-29 00:00:00.000 | 151 | 56 | 115700 | 151 | 56 | 115700 |
zyroqs4
Updated 2025-04-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
DATE(block_timestamp) AS date,
COUNT(DISTINCT tx_hash) AS order_placed,
COUNT(DISTINCT '0x' || SUBSTR(topics[1], 27)) AS buyer,
SUM(ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18) AS musd_amount,
SUM(COUNT(DISTINCT tx_hash)) OVER (ORDER BY date) AS cumulative_order_placed,
SUM(COUNT(DISTINCT '0x' || SUBSTR(topics[1], 27))) OVER (ORDER BY date) AS cumulative_buyer,
SUM(SUM(ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18)) OVER (ORDER BY date)AS cumulative_musd_amount
FROM
mezo.testnet.fact_event_logs
WHERE
CONTRACT_ADDRESS = LOWER('0x637e22A1EBbca50EA2d34027c238317fD10003eB')
AND topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
AND '0x' || SUBSTR(topics[2], 27) = '0xd6626dcca8aa760b227e02b2391aaaecf9371c5d'
GROUP BY
DATE(block_timestamp)
ORDER BY
date DESC;
Last run: 13 days ago
15
885B
3s