date | max price sold | avg price sold | min price sold | |
|---|---|---|---|---|
1 | 2024-01-25 00:00:00.000 | 1186.06504065 | 407.478827199 | 340.993699187 |
2 | 2024-01-24 00:00:00.000 | 1494.221 | 435.617177381 | 323.442640078 |
3 | 2024-01-23 00:00:00.000 | 1192.526829268 | 381.517439054 | 264.059512195 |
4 | 2024-01-22 00:00:00.000 | 1555.4375 | 365.60835438 | 261.9205 |
5 | 2024-01-21 00:00:00.000 | 1319.716666667 | 464.859143423 | 403.008876793 |
6 | 2024-01-20 00:00:00.000 | 2203.059366505 | 479.740776309 | 422.871882147 |
7 | 2024-01-19 00:00:00.000 | 2220.987316387 | 536.907087052 | 428.908057839 |
8 | 2024-01-18 00:00:00.000 | 1362.943731707 | 561.336117164 | 480.898626016 |
9 | 2024-01-17 00:00:00.000 | 1975.53125 | 655.798441541 | 581.165375 |
10 | 2024-01-16 00:00:00.000 | 3495.772357724 | 691.555123707 | 577.152593412 |
11 | 2024-01-15 00:00:00.000 | 1717.476292683 | 766.174884619 | 44.799146341 |
12 | 2024-01-14 00:00:00.000 | 3548.356134146 | 639.398440324 | 97.527292683 |
13 | 2024-01-13 00:00:00.000 | 1926.833333333 | 424.702926572 | 48.626266667 |
14 | 2024-01-12 00:00:00.000 | 10438.083333333 | 532.483583859 | 362.902764228 |
15 | 2024-01-11 00:00:00.000 | 8395.593495935 | 499.708372131 | 343.456097561 |
16 | 2024-01-10 00:00:00.000 | 4788.442588862 | 419.971657892 | 140.917024758 |
StangFASTsale - part 6 [ max , min , avg ]
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
16
1KB
50s