DATE | NFT_COLLECTION_NAME | NET_STAKED | |
|---|---|---|---|
1 | 2024-09-14 00:00:00.000 | Zanthar Origin Heroes | 118 |
2 | 2024-09-15 00:00:00.000 | Altari Origin Heroes | 223 |
3 | 2024-09-15 00:00:00.000 | Feyrune Origin Heroes | 148 |
4 | 2024-09-15 00:00:00.000 | Glorb Origin Heroes | 149 |
5 | 2024-09-15 00:00:00.000 | Humans Origin Heroes | 230 |
6 | 2024-09-15 00:00:00.000 | Lerathi Origin Heroes | 209 |
7 | 2024-09-15 00:00:00.000 | Pirith Origin Heroes | 171 |
8 | 2024-09-15 00:00:00.000 | Tyxen Origin Heroes | 212 |
9 | 2024-09-15 00:00:00.000 | Zanthar Origin Heroes | 118 |
10 | 2024-09-16 00:00:00.000 | Altari Origin Heroes | 222 |
11 | 2024-09-16 00:00:00.000 | Feyrune Origin Heroes | 148 |
12 | 2024-09-16 00:00:00.000 | Glorb Origin Heroes | 151 |
13 | 2024-09-16 00:00:00.000 | Humans Origin Heroes | 230 |
14 | 2024-09-16 00:00:00.000 | Lerathi Origin Heroes | 218 |
15 | 2024-09-16 00:00:00.000 | Pirith Origin Heroes | 172 |
16 | 2024-09-16 00:00:00.000 | Tyxen Origin Heroes | 213 |
17 | 2024-09-16 00:00:00.000 | Zanthar Origin Heroes | 119 |
18 | 2024-09-17 00:00:00.000 | Altari Origin Heroes | 221 |
19 | 2024-09-17 00:00:00.000 | Feyrune Origin Heroes | 148 |
20 | 2024-09-17 00:00:00.000 | Glorb Origin Heroes | 152 |
steven-sabol-dir-of-economyNet Heros on Adventure
Updated 2025-04-15
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
›
⌄
with cte_days (timestamp_rec) as (
select
TO_TIMESTAMP('2024-08-22')
union
all
select
TO_TIMESTAMP(dateadd(day, 1, timestamp_rec)) --or week, month, week, hour, minute instead of day
from
cte_days
where
timestamp_rec <= DATE_TRUNC('Day', CURRENT_TIMESTAMP())
),
mints as (
SELECT
*
FROM
solana.nft.dim_nft_metadata
WHERE
authority = 'FiG8tbM9RMnJWS7ezFqVzJsGzCRHV3V9e4kaSwZ6vzmR'),
ad AS (
SELECT
DATE_TRUNC('Day', cte_days.timestamp_rec) AS date,
mint,
nft_collection_name
-- wallet
FROM
cte_days
cross JOIN mints
),
tx_in as (
SELECT
date_trunc('day',block_timestamp) as date,
mint,
Last run: 15 days ago
...
2040
107KB
28s