Query editor
withlsts as (--s/o ashpool https://x.com/solanobahn/status/1706340214699159859?s=20SELECT*FROM (values('mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So','mSOL'),('7dHbWXmci3dT8UFYWYZweBLXgycu7Y3iL6trKn1Y7ARj','stSOL'),('J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn','jito'),('bSo13r4TkiE4KumL71LsHTPpL2euBYLFx6h9HP3piy1','bSOL'),('7Q2afV64in6N6SeZsAAB81TJzwDoD6zpqmHkzi9Dcavn','jSOL'),('5oVNBeEEQvYi1cX3ir8Dx5n1P7pdxydbGF2X4TxVusJm','scnSOL'),('LSTxxxnJzKDFSLr4dUkPcmCf5VyryEqzPLz5j4bpxFp','mrgnLST')) as v(token_mint_address, lst)), transfers as (SELECTtr.call_block_time, action, lsts.lst, amount/1e9 as amount, get_href(get_chain_explorer('solana') || '/account/' || tr.call_outer_executing_account, caseWHEN tr.call_outer_executing_account = 'JUP6i4ozu5ydDCnLiMogSckDPpbtr7BJ4FtzYWkb5Rk'OR tr.call_outer_executing_account = 'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo'OR tr.call_outer_executing_account ='JUP3c2Uh3WA4Ng34tw6kPd2G4C5BB21Xo36Je1s32Ph'OR tr.call_outer_executing_account ='JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB'OR tr.call_outer_executing_account = 'JUP5pEAZeHdHrLxh5UCwAbpjGwYKKoquCpda2hfP4u8'OR tr.call_outer_executing_account = 'JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4'OR tr.call_outer_executing_account = 'jupoNjAxXgZ4rjzxzPMP4oxduvQsQtZzyknqvzYNrNu'OR tr.call_outer_executing_account = 'DCA265Vj8a9CEuX1eb1LWRnDT7uK6q1xMipnNyatn23M'OR tr.call_outer_executing_account = 'PERPHjGBqRHArX4DySjwM6UJHiR3sWAatqfdBS2qQJu'OR p.namespace LIKE 'jupiter%'THEN 'jupiter'when tr.call_outer_executing_account = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA' then 'marginfi'when tr.call_outer_executing_account = 'So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo' then 'solend'when tr.call_outer_executing_account = 'SPoo1Ku8WFXoNDMHPsrGSTSG1Y47rzgn41SLUNakuHy' then 'stake_pool'when tr.call_outer_executing_account = 'MR2LqxoSbw831bNy68utpu5n4YqBH3AzDmddkgk9LQv' then 'marinade'when tr.call_outer_executing_account = 'CrX7kMhLC3cSsXJdT7JDgqrRVWGnUpX3gfEfxxU2NVLi' then 'lido'when tr.call_outer_executing_account = '5ocnV1qiCgaQR8Jb8xWnVbApfaygJ8tNoZfgPwsgx9kx' then 'socean'when p.namespace is not null then namespaceelse substring(tr.call_outer_executing_account,1,8) || '...'end) as program_invoked, COALESCE(get_href(get_chain_explorer('solana') || '/account/' || tk_s.token_balance_owner,COALESCE(sns_s.favorite_domain, sns_s.domains_owned[1], substring(COALESCE(tk_s.token_balance_owner, account_source),1,8) || '...')), '---') as from_owner, COALESCE(get_href(get_chain_explorer('solana') || '/account/' || tk_d.token_balance_owner,COALESCE(sns_d.favorite_domain, sns_d.domains_owned[1], substring(COALESCE(tk_d.token_balance_owner, account_destination) ,1,8) || '...')), '---') as to_owner, get_href(get_chain_explorer('solana') || '/account/' || tr.call_tx_signer,COALESCE(sns_signer.favorite_domain, sns_signer.domains_owned[1], substring(tr.call_tx_signer,1,8) || '...')) as tx_signer, COALESCE(tk_s.token_balance_owner, account_source) as from_owner_raw