KaskoazulGraph visualization
    Updated 2022-10-30
    select case marketplace
    when 'magic eden v1' then 'magic eden'
    when 'magic eden v2' then 'magic eden'
    else marketplace
    end as source,
    purchaser as target,
    project_name
    --block_timestamp
    from solana.core.fact_nft_sales s
    left join solana.core.dim_nft_metadata m
    on s.mint = m.mint
    where block_timestamp >= '2022-10-01' and block_timestamp < CURRENT_DATE - 1--project_name = 'ABC'
    and source in ('coral cube', 'hyperspace', 'hadeswap')
    and project_name != ''
    and succeeded = True
    order by 1 desc

    Run a query to Download Data