theericstoneMoonbird Trait Explorer
Updated 2022-11-01
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
›
⌄
-- average median and number of sales by moonbird trait over time
with mb as (
SELECT
date_trunc('week',block_timestamp) as week,
platform_name,
meta.token_metadata,
meta.token_id,
price_usd
from flipside_prod_db.ethereum_core.ez_nft_sales sales
join ethereum.nft_metadata meta
on sales.tokenid = meta.token_id and sales.nft_address = meta.contract_address
where block_timestamp > '2022-04-25'
and nft_address = '0x23581767a106ae21c074b2276d25e5c3e136a68b' --moonbirds contract
and meta.project_name = 'Moonbirds'
)
SELECT
week,
--platform_name,
token_metadata:{{Trait}} as selected_trait,
avg(price_usd) as mean_price,
median(price_usd) as median_price,
count(1) as n_sales,
count( distinct token_id) as n_unique_tokens
from mb
where selected_trait IS NOT NULL
group by 1,2;
Run a query to Download Data