type | user | total users | |
---|---|---|---|
1 | b : < $10 | 23 | 23 |
2 | c : < $25 | 13 | 36 |
3 | d : < $75 | 9 | 45 |
4 | e : < $150 | 4 | 49 |
5 | f : > $150 | 14 | 63 |
StangFASTy002 - distribution usd volume
Updated 2024-02-13
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
›
⌄
-- forked from y001 - distribution transactions @ https://flipsidecrypto.xyz/edit/queries/8e6da4d8-43b6-47dd-af6b-40bdfe411c1b
-- forked from 005 - collections @ https://flipsidecrypto.xyz/edit/queries/f2d443ff-3030-4fd6-95c4-d0d127d22360
-- forked from 004 - type @ https://flipsidecrypto.xyz/edit/queries/8e5d96a9-875f-417d-a333-212e7bc93823
-- forked from 001 - overview [ chart ] @ https://flipsidecrypto.xyz/edit/queries/55cd8d83-eb49-4819-be1c-ecf3abed0ce7
with
hon AS
(
SELECT
a.address AS add
, a.address_name AS adn
, a.project_name AS pjn
FROM
avalanche.core.dim_labels a
WHERE
a.project_name = 'heroes of nft'
GROUP BY 1 , 2 , 3
)
,
tkn AS
(
SELECT
date_trunc( 'day' , a.hour ) AS day
, avg( a.price ) AS price
, a.token_address AS add
FROM
avalanche.price.ez_hourly_token_prices a
GROUP BY 1 , 3
ORDER BY 1 DESC
)
,
type AS
Last run: about 1 year ago
5
106B
14s