type | user | total users | |
---|---|---|---|
1 | a : only 1 time | 24 | 24 |
2 | b : < 5 times | 29 | 53 |
3 | c : < 10 times | 4 | 57 |
4 | d : < 20 times | 4 | 61 |
5 | e : < 30 times | 1 | 62 |
6 | f : > 30 times | 1 | 63 |
StangFASTy001 - distribution transactions
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 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
(
SELECT
Last run: about 1 year ago
6
147B
12s