binhachonThe Rise of DeGods - Metadata key and value
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'
and value != 'None'
and key in ('Clothes', 'Head', 'Background', 'Skin')
),
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%'
),
sales_with_metadata as (
select
sales_transaction.*,
key,
value
from sales_transaction
left join NFT_metadata on (sales_transaction.mint = NFT_metadata.mint)
),
summarize_table as (
select
date_trunc('week', block_timestamp) as time,
key,
value,
-- count(*) as number_of_unique_purchasers,
Run a query to Download Data