MadiLatest swaps in Orca Whirlpools
    Updated 2023-01-12
    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