AVG( "USERS" ) | AVG( "TOKENS" ) | AVG( "MINT COUNTS" ) | AVG( "USD VOLUME" ) | SUM( "USERS" ) | SUM( "TOKENS" ) | SUM( "MINT COUNTS" ) | SUM( "USD VOLUME" ) | |
---|---|---|---|---|---|---|---|---|
1 | 189.2 | 1111 | 413.4 | 89226.2575 | 946 | 5555 | 2067 | 356905.03 |
StangFAST003 - minted hourly [ number ]
Updated 2024-01-29
999
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
›
⌄
--- Dokyo
--- 0x54c800d2331e10467143911aabca092d68bf4166
--- Creator
--- 0x610512654af4fa883bb727afdff2dd78b65342b7
with
final0 AS
(
SELECT
a.block_timestamp AS dt
, a.tx_hash AS tx
, b.origin_to_address AS oa
, b.avax_from_address AS af
, b.avax_to_address AS at
, a.nft_from_address AS nf
, a.nft_to_address AS nt
, a.project_name AS pj
-- , a.tokenid AS tk
, b.amount_precise AS am
, b.amount_usd AS us
FROM
avalanche.nft.ez_nft_transfers a
LEFT OUTER JOIN
avalanche.core.ez_avax_transfers b
ON a.block_timestamp = b.block_timestamp
AND a.tx_hash = b.tx_hash
WHERE
a.project_name = 'Dokyo'
AND a.nft_address = '0x54c800d2331e10467143911aabca092d68bf4166'
AND a.event_type = 'mint'
GROUP BY 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10
ORDER BY 1 DESC
Last run: about 1 year ago
1
55B
42s