LittlerDatasolana - metadata de tokens
    Updated 2022-07-10
    SELECT
    date_trunc(hour, block_timestamp) as date,
    sales_amount,
    -- sales_amount > 0,
    token_metadata:Type,
    token_metadata:"Attribute Count",
    token_metadata:Hat,
    token_metadata:Eyes
    FROM solana.core.dim_nft_metadata
    JOIN solana.core.fact_nft_sales
    ON solana.core.dim_nft_metadata.mint = solana.core.fact_nft_sales.mint
    JOIN ethereum.core.fact_hourly_token_prices
    ON ethereum.core.fact_hourly_token_prices.Hour = solana.core.fact_nft_sales.block_timestamp


    Run a query to Download Data