BLOCK_TIMESTAMP | BLOCK_ID | TX_ID | SIGNERS | INDEX | INNER_INDEX | PROGRAM_ID | EVENT_TYPE | DECODED_INSTRUCTION | FACT_DECODED_INSTRUCTIONS_ID | INSERTED_TIMESTAMP | MODIFIED_TIMESTAMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-04-02 02:19:42.000 | 330716462 | 4V2ZpkEQ1kbQ7cFFeAYWKpaKg1csn7TeJcHBVk2nWhNigK1YUvi7dhNQpZ1exG1u9o4rw5qV... | [
"EjwYJMj7wyP9w29WttYBSfh4dfFSuCFiSpAmjhiU72yp"
] | 4 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | CancelUpToWithFreeFunds | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | a8955680a688bd04a3c7997ad5dbc94b | 2025-04-02 04:05:23.712 | 2025-04-02 05:03:56.526 | |
2 | 2025-04-02 00:02:38.000 | 330695891 | 4CPsaaqHwmmUxsCYEvRjkqXrjS8X7oVkjfkMzLWduL3fP5UJeWnnsuSwqbjmqmgdBUdWgRjk... | [
"btc3jyYcTGNtnzs5y6uKtZnL12tHCyfgnj3wFjqFRrF"
] | 5 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | PlaceLimitOrder | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | c248d9d8e5118bb2fab92666dd1c385c | 2025-04-02 02:04:08.423 | 2025-04-02 03:04:52.310 | |
3 | 2025-04-02 01:21:39.000 | 330707771 | 4hxsPhZZ7sXPSjgTufJ3BT1SYzSp8vpUJQ836k8gdanQX6kvwuJu1n8nr5RBb2SXJm6Pf67H... | [
"EjwYJMj7wyP9w29WttYBSfh4dfFSuCFiSpAmjhiU72yp"
] | 4 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | CancelUpToWithFreeFunds | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | 9558d9fc7f5def0b18e3d1f49123be8c | 2025-04-02 03:04:52.310 | 2025-04-02 04:05:23.712 | |
4 | 2025-04-02 08:08:02.000 | 330768687 | 5SVmqAUASzrhwG1xtTj9CzucwxQuqrwTpZTqSK3ooZy8Tb8upCiDNJppCLXpqafoc5kyySgD... | [
"EjwYJMj7wyP9w29WttYBSfh4dfFSuCFiSpAmjhiU72yp"
] | 3 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | CancelUpToWithFreeFunds | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | c2fb81fc713b9fcb400c9b4c9c1656a6 | 2025-04-02 10:03:39.620 | 2025-04-02 11:03:15.550 | |
5 | 2025-04-02 03:09:06.000 | 330723866 | 5PVeSpLD8DKpKuSATvrnhzDwau1jMYMkhgHyKkMTFGWkVaLHuh7ZxdtH7KNM24aeov9T59hU... | [
"EjwYJMj7wyP9w29WttYBSfh4dfFSuCFiSpAmjhiU72yp"
] | 3 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | CancelUpToWithFreeFunds | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | 3ff45a832a86660b885f75be2ec5c5e4 | 2025-04-02 05:03:56.526 | 2025-04-02 06:03:58.799 | |
6 | 2025-04-02 04:34:26.000 | 330736649 | 5Woytv3Q1uPVgQkTbFXdiAKbXPFtY25Qaug8LffFjktHhJj8JD76QwBQRz5Dq5DjqtMwu1P8... | [
"LUKAzPV8dDbVykTVT14pCGKzFfNcgZgRbAXB8AGdKx3"
] | 3 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | CancelUpToWithFreeFunds | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | 44d5312444682ca57a5ecf94c628202c | 2025-04-02 06:03:58.799 | 2025-04-02 07:03:33.788 | |
7 | 2025-04-02 04:47:16.000 | 330738568 | 5S8KWtRAfYUdtWxzeGRqrxzsMeasyZmF7THxw6LmjcV8uUEXSYTcpDtunM9o7UJz3yWibMsw... | [
"wowK1ivqmU9WhHnghiJQ4UUySndzvrUAJinjMUw54eX"
] | 3 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | CancelAllOrdersWithFreeFunds | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | 416c2c9ee510cebe1ece827b8d2a53e1 | 2025-04-02 06:03:58.799 | 2025-04-02 08:06:24.022 | |
8 | 2025-04-02 07:49:47.000 | 330765943 | 5kVBX5rpMut1pjRoxumuDxtw6pWTbBavRStxCxGG3qxZfNtdEWFFEVnWZJo3Sw4oxKzkwMiF... | [
"6kntKawNmZNKZqUHvRVGKMwp8LQU5upyhht7w1PL7dde"
] | 5 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | PlaceMultiplePostOnlyOrders | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | 65db4d92baa2c10fe0ae2299e51552bc | 2025-04-02 10:03:39.620 | 2025-04-02 11:03:15.550 | |
9 | 2025-04-02 04:30:55.000 | 330736116 | 3zoyTaApNJutpXjcXomSMQgHm7yVD95LCyaPd5gpCxBMVZLCci3aBJ9f2egUjM7nvMPBYGJz... | [
"LUKAzPV8dDbVykTVT14pCGKzFfNcgZgRbAXB8AGdKx3"
] | 5 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | PlaceLimitOrder | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | d153efd26f1a4fce5028ea213cb9c3b7 | 2025-04-02 06:03:58.799 | 2025-04-02 08:06:24.022 | |
10 | 2025-04-02 04:18:04.000 | 330734189 | 3shs8Gwe9HnmJeVmpftz9TPFeAquheQ4SQZpFs4iQHHELGSLRPa2DjJ7UuPQF2KnuABqjPEZ... | [
"EjwYJMj7wyP9w29WttYBSfh4dfFSuCFiSpAmjhiU72yp"
] | 4 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | CancelUpToWithFreeFunds | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | 33382ca415ec66e48af6c6e66ccf13ff | 2025-04-02 06:03:58.799 | 2025-04-02 07:03:33.788 | |
11 | 2025-04-02 03:34:11.000 | 330727618 | 3VgoZM8EekSPktaUQvP1iA1ctU9a27Y4iQHkxczWYv6ReLu2Z2x8cy6wfwMyRbETKhup2oLB... | [
"cbtcHew3efHiGJs828eW6bmsZdkifypydoqFdhWvg29"
] | 3 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | CancelAllOrdersWithFreeFunds | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | 6b2a0eb415ab7d52fb66ed53e6ad2ab3 | 2025-04-02 05:03:56.526 | 2025-04-02 06:03:58.799 | |
12 | 2025-04-02 04:31:38.000 | 330736224 | fdLasBzzJK4R8KUuvRvFbLLpwqdy9rrB5ETG9RnF2c6hrysrFMXmn9JGSSR8fDo2Q65ck6n5... | [
"EjwYJMj7wyP9w29WttYBSfh4dfFSuCFiSpAmjhiU72yp"
] | 4 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | CancelUpToWithFreeFunds | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | aeb7e24d53f5a8ce9a0d8f662d82fa65 | 2025-04-02 06:03:58.799 | 2025-04-02 08:06:24.022 | |
13 | 2025-04-02 02:13:21.000 | 330715504 | 5uyJcxrYUKLWDXuqqYTuLFqRAR9dAs9UUtZmPsenf3DPMuwvvp3eoPVWH4Vn94n4SjyeanUC... | [
"EjwYJMj7wyP9w29WttYBSfh4dfFSuCFiSpAmjhiU72yp"
] | 5 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | PlaceMultiplePostOnlyOrders | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | c4815a2a2f909125671aeb45dd14d902 | 2025-04-02 04:05:23.712 | 2025-04-02 05:03:56.526 | |
14 | 2025-04-02 02:52:07.000 | 330721314 | 2vNwbfJo8J1pgyu4dULpkoPb2a748wzp5VgVFbq3iJg98ShJL2nDtfoq9u81C3F6FeG32dsk... | [
"6kntKawNmZNKZqUHvRVGKMwp8LQU5upyhht7w1PL7dde"
] | 4 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | CancelUpToWithFreeFunds | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | ebd7b628025afda4dd8161acb468ddaa | 2025-04-02 04:05:23.712 | 2025-04-02 05:03:56.526 | |
15 | 2025-04-02 08:34:13.000 | 330772617 | 48RcnnhnBvNHa3XtR7KYTBCxcSmT8ZYRCVMCGFpdD1k4qCkGfe1ik5ch8KoFVfWvxEUTiWHc... | [
"6kntKawNmZNKZqUHvRVGKMwp8LQU5upyhht7w1PL7dde"
] | 4 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | CancelUpToWithFreeFunds | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | aa92bc28b335a02b913308db6d168890 | 2025-04-02 10:03:39.620 | 2025-04-02 11:03:15.550 | |
16 | 2025-04-02 01:11:20.000 | 330706216 | 4TcpYhbPMAhZSwHq9JFodvEJnBaq5sGKVzKtx7ck6Uz8azNbXLPo76Uwv1xX7gBitiCdhCUF... | [
"catRTq7nwGpmMMz4ZgbexqejYAYQKuXh7swMS54QfY8"
] | 4 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | PlaceLimitOrder | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | be878192daec49ed09d937d583546ba8 | 2025-04-02 03:04:52.310 | 2025-04-02 04:05:23.712 | |
17 | 2025-04-02 03:58:43.000 | 330731295 | 3inqg5QGjR2MkXHpLWi7oeq8vcFPUmMgpQ8KyMR6R3Lt2EovDD5mgnn412nmbocCyVf2HxkJ... | [
"6kntKawNmZNKZqUHvRVGKMwp8LQU5upyhht7w1PL7dde"
] | 3 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | CancelUpToWithFreeFunds | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | a78c038abc7363c4cff192dbef9458d4 | 2025-04-02 06:03:58.799 | 2025-04-02 07:03:33.788 | |
18 | 2025-04-02 03:44:58.000 | 330729232 | 5N4su1HHyA7REpj7ggeqjidk9Uxuhbv7PQDiK3KWUAL7EWpMuW2dMQvUtDN3TJMpbsVX3uFX... | [
"3ACp4T3ptTdayzWryEhT65NKZSKLjwXviBjWEy54aFdW"
] | 4 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | CancelUpToWithFreeFunds | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | ca661bae3d2e8bd6c312062a7b8c0e52 | 2025-04-02 05:03:56.526 | 2025-04-02 06:03:58.799 | |
19 | 2025-04-02 04:43:24.000 | 330737992 | 5FeLCUMyEPf1nie7tTTPj4bC7zE3KZcqsT44zVVDKPaJAspAHjTTZJCyg6NrweMHgwZp9woT... | [
"wowK1ivqmU9WhHnghiJQ4UUySndzvrUAJinjMUw54eX"
] | 3 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | CancelAllOrdersWithFreeFunds | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | bd763c3da1e8818d36730ede3221f273 | 2025-04-02 06:03:58.799 | 2025-04-02 07:03:33.788 | |
20 | 2025-04-02 02:29:45.000 | 330717974 | 3UGBPCpgwbP4NWNmVsNAnTZ8WrrWbCbaTXmVSmegzeRdVVpHBC1fAJUaWfD6ucVCG3khPZxk... | [
"btc3jyYcTGNtnzs5y6uKtZnL12tHCyfgnj3wFjqFRrF"
] | 3 | PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY | CancelAllOrdersWithFreeFunds | {"accounts":[{"name":"phoenixProgram","pubkey":"PhoeNiXZ8ByJGLkxNfZRnkUf... | 3222128d1e44ed704dc15b44ab254961 | 2025-04-02 04:05:23.712 | 2025-04-02 05:03:56.526 |
Flipside Communitysolana.core.fact_decoded_instructions
Updated 6 days ago
9
1
2
3
4
5
6
7
8
9
›
⌄
-- the fact_decoded_instructions table has decoded instructions
-- you can add IDLs at https://science.flipsidecrypto.xyz/idl-requestor/
SELECT *
FROM solana.core.fact_decoded_instructions
WHERE block_timestamp >= CURRENT_DATE - 1
LIMIT 100
Last run: 6 days ago
100
158KB
2s