Popex404mSOL from LPs
Updated 2022-12-23Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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