jackguyStaking SOL on Marinade
Updated 2022-03-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
-- date_trunc('day', block_timestamp),
CASE WHEN (CASE WHEN swap_from_mint LIKE 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_to_mint ELSE swap_from_mint END) LIKE 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'USDC'
WHEN (CASE WHEN swap_from_mint LIKE 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_to_mint ELSE swap_from_mint END) LIKE 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' THEN 'USDT'
WHEN (CASE WHEN swap_from_mint LIKE 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_to_mint ELSE swap_from_mint END) LIKE 'So11111111111111111111111111111111111111112' THEN 'Wrapped SOL'
WHEN (CASE WHEN swap_from_mint LIKE 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_to_mint ELSE swap_from_mint END) LIKE '9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' THEN 'Wrapped Bitcoin'
WHEN (CASE WHEN swap_from_mint LIKE 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_to_mint ELSE swap_from_mint END) LIKE 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' THEN 'Token Marinade' END as token,
COUNT(*) as amt
FROM solana.swaps
WHERE ( swap_from_mint LIKE 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
OR swap_to_mint LIKE 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' )
AND not token is NULL
GROUP BY 1
ORDER BY 2
DESC LIMIT 5
Run a query to Download Data