TIME | TRANSACTIONS | MINTERS | QTY_MINTED | MINT_PRICE | |
|---|---|---|---|---|---|
1 | 2024-12-22 12:02:00.000 | 75 | 75 | 75 | 7.5 |
2 | 2024-12-22 12:01:00.000 | 521 | 521 | 521 | 52.1 |
3 | 2024-12-22 12:00:00.000 | 1 | 1 | 1 | 0.1 |
freemartianMinutely phase2 mints
Updated 2025-02-01
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('minute',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 phase2
Last run: 2 months ago
3
125B
4s