type | users | total users | |
---|---|---|---|
1 | a : < $500 | 390 | 390 |
2 | b : < $1,000 | 326 | 716 |
3 | c : < $2,500 | 258 | 974 |
4 | d : < $5,000 | 153 | 1127 |
5 | e : > $5,000 | 249 | 1376 |
StangFASTbehavior - part 5
Updated 2024-01-26
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
›
⌄
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
LEFT OUTER JOIN
avalanche.core.ez_avax_transfers b
ON a.block_timestamp = b.block_timestamp
AND a.tx_hash = b.tx_hash
AND a.nft_to_address = b.origin_from_address
Last run: about 1 year ago
5
131B
95s