MINT_DATE | TOTAL_VALUE_SPENT | |
|---|---|---|
1 | 2025-02-23 00:00:00.000 | 500 |
2 | 2025-02-24 00:00:00.000 | 0 |
3 | 2025-02-25 00:00:00.000 | 0 |
4 | 2025-02-26 00:00:00.000 | 0 |
5 | 2025-02-27 00:00:00.000 | 0 |
6 | 2025-02-28 00:00:00.000 | 0 |
monadmetrics-JFe1_RAmount of ETH spent for NFT mint
Updated 2025-02-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
DATE_TRUNC('day', t.block_timestamp) AS mint_date,
SUM(t.value) AS total_value_spent
FROM monad.testnet.fact_event_logs e
JOIN monad.testnet.fact_transactions t
ON e.tx_hash = t.tx_hash
WHERE e.origin_to_address = '0x66e40f67afd710386379a6bb24d00308f81c183f'
AND e.contract_address = '0x66e40f67afd710386379a6bb24d00308f81c183f'
AND e.topic_0 = '0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62'
AND e.tx_succeeded = 'TRUE'
GROUP BY mint_date
ORDER BY mint_date ASC
Last run: about 1 month ago
6
183B
6s