Popex404mSOL from LPs
    Updated 2022-12-23
    with cte as (select
    case when swap_program ilike '%jupiter%' then 'Jupiter'
    when swap_program ilike '%orca%' then 'Orca'
    when swap_program ilike '%raydium%' then 'Raydium'
    when swap_program ilike '%saber%' then 'Saber'
    else swap_program end as "DEX",
    'mSOL' || ' → ' || address_name as "Assets Swapped"
    from solana.core.fact_swaps join solana.core.dim_labels on swap_to_mint = address
    where swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
    and block_timestamp >= '2022-11-01'
    and SUCCEEDED = true)
    select "DEX", count(distinct "Assets Swapped") as "Liquidity Pools" from cte group by 1

    Run a query to Download Data