SALES | NFTS | BUYERS | SELLERS | SALES_AMOUNTS | AVG_PRICE | MIN_PRICE | MAX_PRICE | MEDIAN_PRICE | |
---|---|---|---|---|---|---|---|---|---|
1 | 903669 | 171726 | 34260 | 30672 | 400270.837199548 | 0.4429396573 | 0.00203928 | 216.3775 | 0.44751428 |
imjosh-KH0MAeTotal:
Updated 2023-12-30
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 tb1 as ( select DISTINCT tx_id
from solana.core.fact_events
where program_id = 'SoLMAPutKhdpSSGpCCWioKfqqNQhsdaM8EEi41ummJM'
and block_timestamp::date >= '2023-12-20'
and succeeded = 'true')
,
tb2 as ( select block_timestamp,
purchaser as buyer,
tx_id,
mint_price,
MINT
from solana.nft.fact_nft_mints
where tx_id in (select tx_id from tb1)
and program_id = 'metaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s'
and succeeded = 'true' )
,
tb3 as (select a.value as ti,
tx_id,
REPLACE(value, 'Program log: Minting Solmap #')::string as solmap
from solana.core.fact_transactions , lateral flatten(input => LOG_MESSAGES) a
where tx_id in (select tx_id from tb1)
and block_timestamp::date >= '2023-12-20'
and a.value ilike '%Program log: Minting Solmap #%')
,
tb4 as ( select block_timestamp,
buyer,
mint_price,
a.MINT,
a.tx_id,
solmap
from tb2 a join tb3 b on a.tx_id = b.tx_id)
,
tb5 as ( select a.block_timestamp,
buyer,
b.MINT,
mint_price,
Last run: about 1 year ago
1
90B
263s