yasminPlatform Metrics Overview 1
Updated 2024-09-11Copy Reference Fork
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
›
⌄
-- forked from Platform Metrics Overview @ https://flipsidecrypto.xyz/edit/queries/bfc7520b-546f-4889-bbc6-b449a15c67f2
WITH sales_data AS (
SELECT
seller_address AS seller,
buyer_address AS buyer,
TX_HASH,
PLATFORM_FEE_USD,
CREATOR_FEE_USD,
TOTAL_PRICE,
TOTAL_PRICE_USD
FROM
aptos.nft.ez_nft_sales
WHERE
EVENT_TYPE = 'sale'
AND platform_name in (
'{{platform_name}}')
AND block_timestamp::date >= '{{Start_Date}}' AND block_timestamp::date <= '{{End_Date}}'
)
SELECT
COUNT(DISTINCT CASE WHEN seller IS NOT NULL THEN seller
WHEN buyer IS NOT NULL THEN buyer
END) AS n_traders,
COUNT(DISTINCT TX_HASH) AS transactions,
SUM(PLATFORM_FEE_USD) AS PLATFORM_FEE_USD,
SUM(CREATOR_FEE_USD) AS CREATOR_FEE_USD,
SUM(TOTAL_PRICE) AS volume_APT,
SUM(TOTAL_PRICE_USD) AS volume_usd
FROM
sales_data;
-- SELECT
-- avg(price) AS price
-- FROM
QueryRunArchived: QueryRun has been archived