binhachonThe Rise of DeGods
Updated 2022-03-27
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 NFT_metadata as (
select
mint,
key,
value
from solana.dim_nft_metadata,
LATERAL flatten( input => token_metadata )
where token_name = 'DeGods'
),
sales_transaction as (
select
block_timestamp,
mint,
marketplace,
purchaser,
sales_amount
from solana.fact_nft_sales
where mint in (select distinct mint from NFT_metadata)
and marketplace like '%magic eden%'
)
select
date_trunc('week', block_timestamp) as time,
count(distinct purchaser) as number_of_unique_purchasers,
sum(sales_amount) as volume
from sales_transaction
group by time
-- select
-- tx_id,
-- block_timestamp,
-- s1.value:owner::string as owner,
-- s1.value:uiTokenAmount:uiAmount::float as amount,
-- s2.value:owner::string as owner1,
-- s2.value:uiTokenAmount:uiAmount::float as amount1,
-- row_number() over (partition by owner order by amount desc) as rank
Run a query to Download Data