MadiLatest swaps in Orca Whirlpools
Updated 2023-01-12Copy Reference Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
with df as (select BLOCK_TIMESTAMP as date, TX_ID, SUCCEEDED, SWAPPER, SWAP_FROM_AMOUNT as amount_in, symbol as symbol_in,
SWAP_TO_AMOUNT as amount_to, SWAP_TO_MINT
from solana.core.fact_swaps a join solana.core.dim_tokens b on a.SWAP_FROM_MINT = b.TOKEN_ADDRESS
where SWAP_PROGRAM = 'orca whirlpool program')
select date, SWAPPER,
Case when SUCCEEDED != 'FALSE' then 'Succeded' else 'Failed' end as Status, round(amount_in,2) as "Amount in", upper(symbol_in) as "Token in", round(amount_to,2) as "Amount out", upper(symbol) as "Token out", concat ('https://solscan.io/tx/',tx_id) as "Link on Solscan.io"
from df a join solana.core.dim_tokens b on a.SWAP_TO_MINT = b.TOKEN_ADDRESS
order by 1 desc limit 100
Run a query to Download Data