BLOCK_TIMESTAMP | TYPE | SALE_TYPE | NFT_ITEM_ADDRESS | PAYMENT_ASSET | sale price | narketplace fee | min bid | max bid | MARKETPLACE_ADDRESS | sale time | AUCTION_MIN_STEP | FACT_NFT_EVENTS_ID | CONTENT | USERNAME | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2024-01-08 00:02:42.000 | sale | auction | 0:93C1ACE73E516B73CDD1F824E64C44D22872EA548F538AD6AB15C45EB4C7C65B | TON | 10 | 0.5 | 11 | 0 | 0:408DA3B28B6C065A593E10391269BAAA9C5F8CAEBC0C69D9F0AABBAB2A99256B | 2024-01-08 00:02:21.000 | 5 | 03534c0c3aa17c42867bb54fc2d7db78 | {"uri":"https://nft.fragment.com/username/kycapproval.json"} | kycapproval |
2 | 2024-08-04 14:16:26.000 | sale | auction | 0:93C1ACE73E516B73CDD1F824E64C44D22872EA548F538AD6AB15C45EB4C7C65B | TON | 0 | 0 | 5 | 0:408DA3B28B6C065A593E10391269BAAA9C5F8CAEBC0C69D9F0AABBAB2A99256B | 5 | cb08dc3a5f18f4be8b7bdf7fd908e643 | {"uri":"https://nft.fragment.com/username/kycapproval.json"} | kycapproval |
datavortexsales test
Updated 2025-04-26
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
›
⌄
SELECT
BLOCK_TIMESTAMP,
type,
sale_type,
nft_item_address,
payment_asset,
sale_price/1e9 AS "sale price",
marketplace_fee/1e9 AS "narketplace fee",
auction_min_bid/1e9 AS "min bid",
auction_max_bid/1e9 AS "max bid",
marketplace_address,
-- content_onchain,
TO_TIMESTAMP_NTZ(sale_end_time) AS "sale time",
auction_min_step,
fact_nft_events_id ,
PARSE_JSON(content_onchain) AS content,
TRIM(
REGEXP_REPLACE(
SPLIT_PART(content:uri::STRING, '/', 5),
'\.json$',
''
)
) AS username,
FROM ton.nft.fact_nft_events
where type = 'sale'
AND marketplace_address = '0:408DA3B28B6C065A593E10391269BAAA9C5F8CAEBC0C69D9F0AABBAB2A99256B'
AND CONTAINS(content:uri::STRING, 'fragment.com/username/')
and nft_item_address = '0:93C1ACE73E516B73CDD1F824E64C44D22872EA548F538AD6AB15C45EB4C7C65B'
limit 50;
Last run: about 2 months ago
2
657B
2s