TIME | TRANSACTIONS | MINTERS | QTY_MINTED | MINT_PRICE | |
|---|---|---|---|---|---|
1 | 2024-12-20 12:00:00.000 | 119 | 112 | 235 | 23.5 |
2 | 2024-12-20 15:00:00.000 | 30 | 28 | 54 | 5.4 |
3 | 2024-12-20 14:00:00.000 | 40 | 38 | 67 | 6.7 |
4 | 2024-12-21 15:00:00.000 | 7 | 7 | 14 | 1.4 |
5 | 2024-12-20 22:00:00.000 | 3 | 3 | 5 | 0.5 |
6 | 2024-12-21 08:00:00.000 | 1 | 1 | 2 | 0.2 |
7 | 2024-12-22 00:00:00.000 | 2 | 2 | 3 | 0.3 |
8 | 2024-12-22 05:00:00.000 | 4 | 4 | 10 | 1 |
9 | 2024-12-21 03:00:00.000 | 4 | 4 | 6 | 0.6 |
10 | 2024-12-21 05:00:00.000 | 1 | 1 | 2 | 0.2 |
11 | 2024-12-20 20:00:00.000 | 7 | 6 | 11 | 1.1 |
12 | 2024-12-22 08:00:00.000 | 9 | 8 | 16 | 1.6 |
13 | 2024-12-22 10:00:00.000 | 1 | 1 | 3 | 0.3 |
14 | 2024-12-21 01:00:00.000 | 10 | 9 | 17 | 1.7 |
15 | 2024-12-20 23:00:00.000 | 2 | 2 | 6 | 0.6 |
16 | 2024-12-21 19:00:00.000 | 9 | 7 | 13 | 1.3 |
17 | 2024-12-20 18:00:00.000 | 9 | 9 | 15 | 1.5 |
18 | 2024-12-21 00:00:00.000 | 5 | 5 | 7 | 0.7 |
19 | 2024-12-22 06:00:00.000 | 5 | 5 | 11 | 1.1 |
20 | 2024-12-21 20:00:00.000 | 8 | 7 | 10 | 1 |
freemartianHourly phase1 mints
Updated 25 minutes ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with mints AS (
SELECT
block_timestamp,
tx_hash,
decoded_log:dropStageIndex AS phase,
decoded_log:feeRecipient AS fee_recipient,
decoded_log:minter AS minter,
decoded_log:quantityMinted AS quantity_minted,
decoded_log:unitMintPrice / pow(10,18) AS unit_mint_price,
unit_mint_price * quantity_minted AS mint_price,
FROM ethereum.core.ez_decoded_event_logs
WHERE block_timestamp::date >= '2024-12-20'
-- AND block_timestamp::date <= '2024-12-21'
-- AND tx_hash = lower('0x750d65f99cd335a12a08738bd8442ddf9b998377ae2e1df9fd1495466b50580e')
AND event_name = 'SeaDropMint'
AND decoded_log:nftContract = lower('0x9830b32f7210f0857A859c2A86387e4d1bB760B8')
),
phase1 AS(
SELECT * FROM mints
where phase = 1
),
phase2 AS(
SELECT * FROM mints
where phase = 2
)
SELECT
date_trunc('hour',block_timestamp) AS time,
count(tx_hash) AS transactions,
count(DISTINCT minter) AS minters,
SUM(quantity_minted) AS qty_minted,
SUM(mint_price) AS mint_price
FROM phase1
GROUP BY 1
Last run: 25 minutes agoAuto-refreshes every 1 hour
47
2KB
28s