MLDZMNph3
Updated 2023-09-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select *
from solana.core.fact_events
--where succeeded = True
-- and (program_id = 'PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY'
-- or ARRAY_CONTAINS('PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY'::VARIANT, instruction:accounts)) -- not all swaps done on Phoenix
where tx_id='p6pfkfNLAVLY33NbYYT1t9xajFeAwMyXePshjvpdf7P3TamxfbxckikWvgNYHbnHYVeC8y6SZ4P6NsmTMa7s9zn'
--and (tx_from='irWZsBWNZ8jbGncWgn7i4mu7bzXKKyW4QPsphtbosGQ' or tx_to='irWZsBWNZ8jbGncWgn7i4mu7bzXKKyW4QPsphtbosGQ')
--and (tx_from='8g4Z9d6PqGkgH31tMW6FwxGhwYJrXpxZHQrkikpLJKrG' or tx_to='8g4Z9d6PqGkgH31tMW6FwxGhwYJrXpxZHQrkikpLJKrG')
--and (tx_from='5vkFwKVxAmZWgQ2b4xYJBdBzjkFvPxSCTdLeEs48BsGf' or tx_to='5vkFwKVxAmZWgQ2b4xYJBdBzjkFvPxSCTdLeEs48BsGf')
--and (tx_from='J6vHZDKghn3dbTG7pcBLzHMnXFoqUEiHVaFfZxojMjXs' or tx_to='J6vHZDKghn3dbTG7pcBLzHMnXFoqUEiHVaFfZxojMjXs')
--and (tx_from='9Zdp9hUEfJ6wD4UbVrTKTbMhXtTzLqsvmAQrNzMCdNAF' or tx_to='9Zdp9hUEfJ6wD4UbVrTKTbMhXtTzLqsvmAQrNzMCdNAF')
--and (tx_from='51LAUnnqk8PTPribSTRb5rmF867dz5mEQbpxfk13Nu1C' or tx_to='51LAUnnqk8PTPribSTRb5rmF867dz5mEQbpxfk13Nu1C')
and BLOCK_TIMESTAMP>=current_date-5
Run a query to Download Data