UNIQUE_BUYERS | TOTAL_TRANSACTIONS | TOTAL_VOLUME_USD | TOTAL_COLLECTIONS | AVERAGE_TRANSACTION_VALUE_USD | MEDIAN_TRANSACTION_VALUE_USD | HIGHEST_TRANSACTION_VALUE_USD | |
|---|---|---|---|---|---|---|---|
1 | 11725 | 848098 | 5715256.66385727 | 128 | 6.738910673 | 0.33 | 60000 |
HadisehTotal Sale
Updated 2025-01-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
32
33
34
35
36
›
⌄
WITH event_filter AS (
SELECT
*
FROM
flow.core.fact_events
WHERE
event_type IN ('OfferCompleted', 'ListingCompleted')
AND event_contract IN (
'A.3cdbb3d569211ff3.NFTStorefrontV2',
'A.b8ea91944fd51c43.OffersV2'
)
AND tx_succeeded = 'true'
AND event_data:purchased = 'true'
),
offer_events AS (
SELECT
EVENT_DATA:offerAddress :: STRING AS purchaser,
EVENT_DATA:offerAmount :: FLOAT AS transaction_value,
EVENT_DATA:offerType :: STRING AS collection_name,
EVENT_DATA:nftId :: INTEGER AS nft_identifier,
EVENT_DATA:paymentVaultType AS currency_used,
tx_id,
TRUNC(block_timestamp, 'day') AS transaction_day
FROM
event_filter
WHERE
event_type = 'OfferCompleted'
AND event_data :: STRING LIKE '%0x6590f8918060ef13%'
),
listing_events AS (
SELECT
EVENT_DATA:buyer :: STRING AS purchaser,
EVENT_DATA:salePrice :: FLOAT AS transaction_value,
EVENT_DATA:nftType :: STRING AS collection_name,
EVENT_DATA:nftID :: INTEGER AS nft_identifier,
EVENT_DATA:salePaymentVaultType :: STRING AS currency_used,
Last run: about 2 months ago
1
60B
108s