avg buyers | avg sellers | avg token IDs | avg sale counts | avg sale volume | avg transaction fees | avg platform fees | avg creator fees | total buyers | total sellers | total token IDs | total sale counts | total sale volume | total transaction fees | total platform fees | total creator fees | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 87.314286 | 95.828571 | 132.942857 | 241.714286 | 145618.891227518 | 60.972549262 | 2797.142529839 | 697.543716408 | 3056 | 3354 | 4653 | 8460 | 5096661.19296313 | 2134.039224175 | 97899.988544381 | 24414.030074287 |
StangFASTsale - part 2 [ 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
avax AS
(
SELECT
date_trunc( 'day' , a.hour ) AS dt
, avg( a.price ) AS pr
, a.symbol AS sb
, a.decimals AS de
FROM
avalanche.price.ez_hourly_token_prices a
WHERE
a.token_address = '0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7'
GROUP BY 1 , 3 , 4
ORDER BY 1 DESC
)
,
--------------------------------------------------- HYPERSPACE ------------------------------------------------------
market_sale_1 AS
(
SELECT
b.block_timestamp AS dt
, b.tx_hash AS tx
, cast( b.decoded_log:"taker" AS string ) AS bu
, cast( b.decoded_log:"maker" AS string ) AS se
, cast( b.decoded_log:"erc721TokenId" AS string ) AS id
, ( ( cast( b.decoded_log:"erc20TokenAmount" AS integer ) / power( 10 , c.de ) ) * c.pr ) AS am
FROM
avalanche.nft.ez_nft_transfers a
LEFT JOIN
avalanche.core.ez_decoded_event_logs b
ON a.tx_hash = b.tx_hash
LEFT JOIN
avax c
ON a.block_timestamp::date = c.dt
Last run: about 1 year ago
1
188B
140s