binhachonThe Rise of DeGods
    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'
    ),
    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%'
    )
    select
    date_trunc('week', block_timestamp) as time,
    count(distinct purchaser) as number_of_unique_purchasers,
    sum(sales_amount) as volume
    from sales_transaction
    group by time


    -- select
    -- tx_id,
    -- block_timestamp,
    -- s1.value:owner::string as owner,
    -- s1.value:uiTokenAmount:uiAmount::float as amount,
    -- s2.value:owner::string as owner1,
    -- s2.value:uiTokenAmount:uiAmount::float as amount1,
    -- row_number() over (partition by owner order by amount desc) as rank
    Run a query to Download Data