ChiefHadesswap Volume
Updated 2023-01-21
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
›
⌄
-- number of traded collections on Hadeswap, does Hadeswap trade fewer collections overall than Magic Eden (ie are small collections only popular on ME)?
WITH collections AS (
SELECT
block_timestamp,
program_id as program_id_label,
marketplace as marketplace_label,
token_name as collection_name,
sales_amount
FROM SOLANA.CORE.FACT_NFT_SALES s
LEFT JOIN SOLANA.CORE.DIM_NFT_METADATA m
ON s.mint = m.Mint
WHERE 1=1
AND block_timestamp > '2022-09-01'
AND succeeded = 'TRUE'
AND sales_amount > 0
AND marketplace_label = 'hadeswap'
-- AND collection_name > 0
-- GROUP BY 1,2
)
SELECT
date_trunc('day', block_timestamp) as date,
collection_name,
-- sum(sales_amount) as trade_volume,
sum(sales_amount) as volume_traded,
-- (volume_traded/collection_count) as volume_per_collection,
count(distinct case when marketplace_label = 'hadeswap' then collection_name END) as hadeswap_collection_count
-- count(distinct purchaser) as distinct_buyers,
-- count(purchaser) as buyers_count,
-- (trade_volume / buyers_count) as avg_nft_trade_price,
-- count(distinct seller) as distinct_sellers -- would like to examine total unique sellers and traders as one rather than seperately
-- count(seller) as sellers_count,
-- count(distinct tx_id) as sales_count, -- this wildly wrong, buyers count is accurate
-- distinct_buyers/ buyers_count as buy_ratio
FROM collections
Run a query to Download Data