BLOCK_TIMESTAMP | BLOCK_ID | TX_ID | SIGNERS | SUCCEEDED | INDEX | EVENT_TYPE | PROGRAM_ID | INSTRUCTION | INNER_INSTRUCTION | FACT_EVENTS_ID | INSERTED_TIMESTAMP | MODIFIED_TIMESTAMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-04-02 02:16:47.000 | 330716022 | 4CY5BLxxvLCToBYN6cdpe5S5dwnxs1N1HwHkywcZDFewqcPLALvQKdvFJLszHySotLPTJEVd... | [
"HkA4hZRGFbxjE3MvPLZGFrJZqTdf3tFjhg5uCC1qsApQ"
] | TRUE | 3 | closeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"BRXgoLJDWtuiTEncgWFEWZCCJJmL6tUHJ4zMNmQX73... | 67a8d689593c10fb6ac280d4c6a1032d | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
2 | 2025-04-02 02:19:44.000 | 330716470 | 3WvSYDxdSLCegWD23ftiYYoiZE3c4RHGN9fUGQpKmNaJVG9pNVRXRBiydTcmBkzVpxnqmzqV... | [
"GndKJXNA4BLsTgoZwC1oqktkS528SnhbUyUGcpV2xHUr",
"3yBTq5xjpiLZGLKNgyvRBNdfUrbgxyFqstYxKr1ThnB6"
] | TRUE | 3 | closeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"GjvF7V1LcdcC5G88zbQJQZWvfFQTMKP4r2hW4BYdKK... | 7430cd0d22fd1bfb00c9dbe2a8ca9da6 | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
3 | 2025-04-02 02:26:22.000 | 330717465 | 3dx6uNMzR7uhkUoyCcjzqRQfPAQKsTfsQCFWmRRTBhYngvZs2nAm3XMHaCfNVRZdRTU7nEoH... | [
"HXzkkswG8A2etA2nWWQg6NQKoy4zXrZP5JmXYFrYNRdz"
] | FALSE | 3 | closeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"9WAJMwHBoeZnGTxkyGBm6bMSSH3TVi1JEwSqdn8PJj... | 00fa8f0f82fe89d67f9cebaa6b03f8de | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
4 | 2025-04-02 02:08:44.000 | 330714808 | 2fxCzwsyWCVyZLVb6UGnDZ2fuanzknHsNp51e7ujDRFdUyUYhJ2VXwLaXwWSczSW6TGmfnso... | [
"GTn1X2vEyAUmVGsJvptTRSuHbJQQqwiUof8cxrxUqBbo",
"Eic5KByjsXQUkeRKLnGiSZjnmAfcWyVhTTr4yMvZFBDd"
] | TRUE | 4 | initializeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"Eic5KByjsXQUkeRKLnGiSZjnmAfcWyVhTTr4yMvZFB... | 443da8d21a54daa6fff094c0b53468ed | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
5 | 2025-04-02 02:15:31.000 | 330715833 | 2mnuaDzZSeB7fyXZfHC9k7Z4uR6tDyJhpkknziUxVwjVav3pdANkbx59ZSjL2qSoLXNUbsUf... | [
"8zpJSjPLg38hKLxZfKWeh4xr6jtESUGzrz3G7DjRUEpb"
] | TRUE | 7 | closeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"3JsvHgnw5ppqHv7pzaH1wUCvBcgFMXTawtsinWgVtv... | 4baab999d92241d622338ec383789253 | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
6 | 2025-04-02 02:15:29.000 | 330715828 | BM8ghf6nyoSmKUfRxYK32CY5AM7Avm7dbTTKyw1ifppdvqKyUmNJrEz51dgRSKMZYdxg9g9K... | [
"4UxFb6LXBfx4BuuuKi5tGK4SXaAEjqENRA9LbK5zJViH"
] | TRUE | 6 | closeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"FQHykNQu5e8H9ssr8Gftm6fvFeiv9uBBVVhDgMckSL... | c330e3021b49a2d6b99c63497f800312 | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
7 | 2025-04-02 02:20:20.000 | 330716560 | 56JCwseFmCYRAHCzT92xB1cv2DBBoox2Rr7bu1Sivieq7tx6PNuRJ82koQEsEgR3uzgSP7jJ... | [
"o7RY6P2vQMuGSu1TrLM81weuzgDjaCRTXYRaXJwWcvc"
] | FALSE | 2 | burn | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"AHMKmA7hrzwXqTHtmQMieRyVQ7QZCywa7pLJuhZd1n... | 6966d7bb3444bafeaaaf229de9da7837 | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
8 | 2025-04-02 02:02:04.000 | 330713803 | 2KKizkiU7CKSqtbCd6yGT8KPQbCarfmjGGWRVxMhtZmbiX27DZnokEYfP8fiKTCGc97n9rdt... | [
"8Rt2jhcjg37kPVwEg8WjUyJw8aU2d3GwzBYtF3V9WxfM"
] | TRUE | 1 | initializeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"EvB5sVdZuizEiF2beow859uABHnxwZM8KB5c1Wyyxb... | 8f5151726cacd9cef7f0bcd01a4bdb2f | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
9 | 2025-04-02 02:29:30.000 | 330717936 | 4bfkE2K4P2zm1pMpZjxnHQKhhwSf2b3N7F4xyChtgdgyKFS4JU1ZFZCKgv6FAnE1GsBndUVK... | [
"6TKkTYeDYe9Tp5xEUZLBtZRLwiVcyWSw5tX9HFk4UQ1j"
] | TRUE | 4 | initializeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"3bZ3QtCi54z86ZKPCjVHfJrS2bRgeU2o2YmKHedD3V... | 67fbfcdbbb8d2a52cb65cae92b49de67 | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
10 | 2025-04-02 02:31:32.000 | 330718246 | 3v5T5cuMYh822RoVNjXJ9gSNp9kcpPDYaZZ3bbEGTyhgq7XX9Mt5vPngJYbx75ESEXnLRoMt... | [
"4ehrtc7kpU3XjXdCCiVLaqPEkMHdzkg9h7MHJLAg2C3N"
] | TRUE | 5 | closeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"7FLex9DARYsKRcqvB2t1L2u4sSd95x2JhXRXNJrrgH... | 9db19dc0165b6296a5c1a9934b892c36 | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
11 | 2025-04-02 02:19:09.000 | 330716380 | 4PovZRQUiiiYMY7CMGjnqDZqTA3rJdJeoBeGdmqZopGNroqeYJ8Zxun6KQMZydhjTzDWBGvG... | [
"H46wBvv4U6acvSwkoWKZtQXn6Xkkg2z8Da7coL2ti5Sq"
] | TRUE | 7 | closeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"FacnujUY8fvrXrwTNrfRD3xdbsUYkjPzgwDKWKeEaz... | fe91ef6a10c3d3745e0f182fe1cbd030 | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
12 | 2025-04-02 02:30:13.000 | 330718045 | 5zVUiHN4MtB5g2WLWSzdnU9UXQbbipDpZ9APTZfuS5viTQrp4JNTgUayp26LFUNtYbtaFcfj... | [
"GHtYSmSK51s9NRL2X7GbeBC4PLvBYqhKw7L8CqTYHzd1",
"F3hoE7XHdsbQ6V5XynXMPjmfedoUD6B8HKLQbjedv8yp"
] | TRUE | 4 | closeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"EiohAepKyt9tTZe4SVqpb8yGbZzxjKDCoJ5s3xBA9m... | 8f7a9348be5aa77c59f51d7de4e01eb8 | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
13 | 2025-04-02 02:31:28.000 | 330718234 | mM9Pmb9GfsYteedqapHZ12fPtdDSscysfHuvmL1yJVa98LgJU9nYimeWzXdTPQRcMCC9dUez... | [
"FJTDNvyhGxeLax14zyF6LmTS9bVPoWSfQEc77CxXfdjc"
] | TRUE | 4 | closeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"8eAAZM4zbn9NCKw6LPi9JaifZ1UZV6joFNa9sxtq9M... | c51ec6b346c445d7ed6148491f3caf92 | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
14 | 2025-04-02 02:04:26.000 | 330714157 | 2QqmU1SVK7iNabzUYMWgNDkEycR4B8vVHbFxhztFc3vfYbJWpptQWm7SpUAzABvEbdMmRyuC... | [
"BeTph9hHRTJSFBYWQy4yuNibma1iKSsPzt95GNketH3s"
] | TRUE | 4 | closeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"21gx5wg8RugsJSbzeMWgMLfxxsCbpYgREA35PvHQc5... | d035265bd0cd89126d26f114d0e8e818 | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
15 | 2025-04-02 02:10:17.000 | 330715042 | 4BqoPrLDH2k8RwC2inmYm7Y1J2mqqnr7C3o6AikLrMnbqQXrn7RVruKJehBWSKnBSvTWrLn6... | [
"HXzkkswG8A2etA2nWWQg6NQKoy4zXrZP5JmXYFrYNRdz"
] | FALSE | 3 | closeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"GG2XNtKPBWtRHNK3LZhRQnnbwWzUG4RUbz1u7TZ35q... | 872e16acf9741f3e482ee007166bb1c0 | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
16 | 2025-04-02 02:25:17.000 | 330717304 | 46zuZy23Bp1aHrzu3ezDVdB1NwHkv35Bu4EZRiaLsxTysmXWmZXhHa1GQqUxEKxErQRXPBQr... | [
"AxiomRYAid8ZDhS1bJUAzEaNSr69aTWB9ATfdDLfUbnc",
"ArMRqSF3X6J24YPg4rFpDsi4ViTd5eyxTF7uVoMXTorN"
] | TRUE | 20 | closeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"GJmbJDCWRUBjt4dw4sLQ636mVxS9g4CVeUQrytjDwU... | 28526f0d51883288521313be07a2f7e2 | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
17 | 2025-04-02 02:15:07.000 | 330715770 | 4ogvR9VPf8zFYRHSosKSqFfMFJEiXpok4vv26MXbBZyaGBtffVZYB6c8wETQ1hJPx938ERgk... | [
"7hDtpfrghUnjyQ3e8EavtpGnzBNSqnudAntTyynEvinF",
"3yBTq5xjpiLZGLKNgyvRBNdfUrbgxyFqstYxKr1ThnB6"
] | TRUE | 1 | initializeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"52vzc7XoozSXB5S77CE6mNurouD7LyjgTMCdwb5pHV... | d5558df8988bcc9b2c6e747bc89d54e0 | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
18 | 2025-04-02 02:29:47.000 | 330717980 | 2FYdJGuU1uHFp5wk32sKK8c3qEbBUmdaMymTQFFCbJkdcQBXW6FaVaR88P97bMq5EiCbZc9R... | [
"HUwEY7HyAhnF8sgYi7pZyGnHxhXzMtshThmcU1XxKhsh"
] | TRUE | 3 | closeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"4tM7yXjEvXLxFBVscxSiMLHYW9usu2NTaPibD91oJK... | 4a3528b984ad933c20560ed92b292fe5 | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
19 | 2025-04-02 02:01:39.000 | 330713744 | DW5WZPkELSLCg1BMWAPzuqrZbWAsYbDFtBsYGCQZrRn4GcTNfpL55ZAD5fNed7HFzVmvcGpi... | [
"2jCauYSpRWSn1iGwhCwjUhGQxGpz1enAgmp96w7Hp3Gs"
] | TRUE | 1 | initializeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"2KFKFR36crC1bvHHcKuRgpL9zMwE25NWjzF5XHc3vq... | fd78ae39a34b1931c636621f5c27f9c0 | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 | |
20 | 2025-04-02 02:22:24.000 | 330716873 | 4CQc1fxLkFLczYPWTduGyKfxsVxz96Fa99WC6XM35BQSLXCzAaG3XhmwmQJVEmwT5wtzJVwW... | [
"J36m3HvxAc5JDYZ66rNTZts7DFK1z2PN94KdbNzheJid",
"3yBTq5xjpiLZGLKNgyvRBNdfUrbgxyFqstYxKr1ThnB6"
] | TRUE | 1 | initializeAccount | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | {"parsed":{"info":{"account":"HudPPLVT6UydDwiZ86qQUuPgJKWVDtuDNEn3Q978uC... | b0bbd6ea7a232c2c0fcacfd32f1486bc | 2025-04-02 02:52:12.314 | 2025-04-02 02:52:12.314 |
Flipside Communitysolana.core.fact_events
Updated 2025-04-03
9
1
2
3
4
5
6
7
›
⌄
-- the fact_events table has
SELECT *
FROM solana.core.fact_events
WHERE block_timestamp >= CURRENT_DATE - 1
LIMIT 100
Last run: 26 days ago
100
67KB
1s