binhachonThe Rise of DeGods - Metadata key and value
    Updated 2022-03-27
    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