datavortexOverall
Updated 2024-09-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
COUNT(DISTINCT tx_id) AS nft_sales,
COUNT(DISTINCT CASE WHEN tx_succeeded = 'True' THEN tx_id END) AS successful_sales,
COUNT(DISTINCT CASE WHEN tx_succeeded = 'False' THEN tx_id END) AS unsuccessful_sales,
(COUNT(DISTINCT CASE WHEN tx_succeeded = 'True' THEN tx_id END) * 100.0 / COUNT(DISTINCT tx_id)) AS success_rate,
COUNT(DISTINCT CASE WHEN event_type = 'sale' THEN tx_id END) AS direct_sales_transactions,
COUNT(DISTINCT CASE WHEN event_type = 'bid_won' THEN tx_id END) AS bid_won_transactions,
COUNT(DISTINCT CASE WHEN event_type = 'redeem' THEN tx_id END) AS redeem_transactions,
COUNT(DISTINCT buyer_address) AS distinct_buyers,
COUNT(DISTINCT seller_address) AS distinct_sellers,
(COUNT(DISTINCT buyer_address) + COUNT(DISTINCT seller_address)) AS total_traders,
SUM(amount_usd) AS volume_traded,
COUNT(DISTINCT project_name) As total_assets
FROM
sei.nft.ez_nft_sales
WHERE
platform_name = 'pallet';
QueryRunArchived: QueryRun has been archived