theericstoneMoonbird Trait Explorer
    Updated 2022-11-01
    -- 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