SALES | DISTINCT_NFT_SOLD | BUYERS | SEI_VOLUME | AVG_NFT_PRICE | |
|---|---|---|---|---|---|
1 | 175 | 175 | 150 | 3325 | 19 |
omer93wetrump on sei 2nd sales
Updated 2025-05-07
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 info AS (
SELECT
tx_hash,
block_timestamp,
from_address AS buyer,
to_address AS collection,
value AS attribute_value
FROM
sei.core_evm.fact_transactions
WHERE
block_timestamp > '2025-01-01'
and origin_function_signature in ('0xa22cb465') and to_address='0x47b724277e72d0985927a58246035c436b93df90'
--GROUP BY
--tx_hash, block_timestamp, buyer, collection, attribute_value
),
info2 AS (
SELECT
*,
attribute_value as prices,
19 AS sei_price,
(sei_price) AS sei_volume
FROM
info
)
select
count(distinct tx_hash) as sales,
count(distinct tx_hash) as distinct_nft_sold,
count(distinct buyer) as buyers,
sum(sei_volume) as sei_volume,
avg(sei_price) as avg_nft_price
from info2
Last run: 26 days ago
1
23B
3s