date | minters | transactions | tokens | amount AVAX | amount USD | total minters | total transactions | total tokens | total amount AVAX | total amount USD | |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2024-01-10 16:05:00.000 | 17 | 17 | 25 | 125 | 4326.25 | 1360 | 1406 | 2500 | 12250 | 423972.5 |
2 | 2024-01-10 16:04:00.000 | 54 | 59 | 89 | 445 | 15401.45 | 1343 | 1389 | 2475 | 12125 | 419646.25 |
3 | 2024-01-10 16:03:00.000 | 104 | 113 | 175 | 875 | 30283.75 | 1289 | 1330 | 2386 | 11680 | 404244.8 |
4 | 2024-01-10 16:02:00.000 | 265 | 274 | 466 | 2330 | 80641.3 | 1185 | 1217 | 2211 | 10805 | 373961.05 |
5 | 2024-01-10 16:01:00.000 | 249 | 256 | 443 | 2215 | 76661.15 | 920 | 943 | 1745 | 8475 | 293319.75 |
6 | 2024-01-10 16:00:00.000 | 670 | 686 | 1252 | 6260 | 216658.6 | 671 | 687 | 1302 | 6260 | 216658.6 |
7 | 2024-01-08 07:06:00.000 | 1 | 1 | 50 | 0 | 0 | 1 | 1 | 50 | 0 | 0 |
StangFASTmint - part 1
Updated 2024-01-26
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
›
⌄
--- avax transfer
--- CALL_ORIGIN
--- steady [ STDY ]
--- 0xcdab7d987f0198edb440d014ed1e71256a0e3e7a
with
minted_tokens AS
(
SELECT
a.tx_hash AS transaction
, count( distinct a.tokenid ) AS token
FROM
avalanche.nft.ez_nft_transfers a
WHERE
a.nft_address = '0xcdab7d987f0198edb440d014ed1e71256a0e3e7a'
AND a.event_type = 'mint'
GROUP BY 1
ORDER BY 2 DESC
)
,
minted_chart_1 AS
(
SELECT
a.block_timestamp AS date
, a.nft_to_address AS minter
, a.tx_hash AS transaction
, a.project_name AS project_name
, a.tokenid AS token_id
, b.amount_precise / c.token AS amount
, b.amount_usd / c.token AS usd_volume
FROM
avalanche.nft.ez_nft_transfers a
Last run: about 1 year ago
7
542B
47s