core.flow_alerts
Every UW flow alert, on every ticker - untracked ones included, which is the point. Keyed on the vendor's alert id. `ticker` is verbatim (SPX weeklies arrive as SPXW). Not exportable: each alert carries the contract's bid and ask.
uw_flow_alerts474,253 rowsrestricted — hover for the licence| iduuid | created_at ↑timestamp with time zone | start_timetimestamp with time zone | end_timetimestamp with time zone | tickertext | option_symboltext | option_typetext | strikenumeric | expiry |
|---|
| pricenumeric |
|---|
| bidnumeric |
|---|
| asknumeric |
|---|
| underlying_pricenumeric |
|---|
| total_premiumnumeric |
|---|
| total_ask_side_premnumeric |
|---|
| total_bid_side_premnumeric |
|---|
| total_sizebigint |
|---|
| trade_countinteger |
|---|
| volumebigint |
|---|
| open_interestbigint |
|---|
| volume_oi_rationumeric |
|---|
| iv_startnumeric |
|---|
| iv_endnumeric |
|---|
| has_sweepboolean |
|---|
| has_floorboolean |
|---|
| has_multilegboolean |
|---|
| has_singlelegboolean |
|---|
| all_opening_tradesboolean |
|---|
| alert_ruletext |
|---|
| rule_iduuid |
|---|
| expiry_countinteger |
|---|
| issue_typetext |
|---|
| sectortext |
|---|
| marketcapnumeric |
|---|
| next_earnings_datedate |
|---|
| er_timetext |
|---|
| missing_periscopeboolean |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| f9180631-23b6-478f-94ce-149d2a9c6320 | 2026-09-01 10:58 | 2026-09-01 10:58 | 2026-09-01 10:58 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 4.7500 | 4.7500 | 4.8000 | 62.0900 | 25675.00 | 2400.00 | 23275.00 | 54 | 5 | 274 | 1527 | 0.179436804191225 | 0.678606624203928 | 0.672849339868879 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 37426822649.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T14:59:17.018627Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 076cb1db-2e72-48a5-92c7-8b1bb4795246 | 2026-09-03 13:14 | 2026-09-03 13:14 | 2026-09-03 13:14 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 5.6000 | 5.4500 | 5.6000 | 63.9150 | 10640.00 | 10640.00 | 0.00 | 19 | 6 | 1091 | 1919 | 0.56852527357999 | 0.68193907195107 | 0.68193907195107 | false | false | false | true | ||||||||||||||||
| efefa3a8-a289-460e-84f2-444b34900f66 | 2026-09-09 14:27 | 2026-09-09 14:27 | 2026-09-09 14:27 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 5.4800 | 5.4500 | 5.6000 | 63.9100 | 21900.00 | 0.00 | 21900.00 | 40 | 6 | 1437 | 2793 | 0.514500537056928 | 0.722115323825692 | 0.722115323825692 | false | false | false | true | ||||||||||||||||
| 88a672ac-a0ae-473e-8566-0c58c71299c8 | 2026-09-11 13:27 | 2026-09-11 13:26 | 2026-09-11 13:26 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 5.3000 | 5.2500 | 5.3000 | 64.5500 | 13780.00 | 13780.00 | 0.00 | 26 | 6 | 322 | 3866 | 0.0832902224521469 | 0.67732277556161 | 0.67732277556161 | false | false | false | true | ||||||||||||||||
| 5904a46c-b40d-4b12-8bfd-c9674f6c32f0 | 2026-09-15 10:24 | 2026-09-15 10:24 | 2026-09-15 10:24 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 5.0400 | 4.8000 | 5.1000 | 64.3100 | 10072.00 | 10072.00 | 0.00 | 20 | 6 | 363 | 4311 | 0.0842032011134308 | 0.70216135457732 | 0.70216135457732 | false | false | false | true | ||||||||||||||||
| eb712877-ba0a-4cf1-8cf4-e85e42a39083 | 2026-09-15 13:18 | 2026-09-15 13:18 | 2026-09-15 13:18 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 4.9000 | 4.9000 | 4.9000 | 64.0600 | 49490.00 | 0.00 | 0.00 | 101 | 9 | 873 | 4311 | 0.202505219206681 | 0.702259722713326 | 0.702259722713326 | false | false | false | true | ||||||||||||||||
| 99dbf921-6054-47e8-a546-4bb3cb366665 | 2026-09-16 10:16 | 2026-09-16 10:16 | 2026-09-16 10:16 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 4.8500 | 4.8000 | 4.9500 | 64.0000 | 12616.00 | 0.00 | 6311.00 | 26 | 7 | 315 | 4343 | 0.07253050886484 | 0.71141805922703 | 0.71141805922703 | false | false | false | true | ||||||||||||||||
| bac02be7-3fc0-4dae-b028-c69fa20bfbf9 | 2026-09-16 10:18 | 2026-09-16 10:18 | 2026-09-16 10:18 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 4.7500 | 4.7500 | 4.8000 | 63.0000 | 45125.00 | 0.00 | 45125.00 | 95 | 27 | 473 | 4343 | 0.108910891089109 | 0.711799642361824 | 0.711799642361824 | false | false | false | true | ||||||||||||||||
| 40ce2981-5c37-4cd7-9103-8732fbbb1d12 | 2026-09-16 10:20 | 2026-09-16 10:20 | 2026-09-16 10:20 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 4.7500 | 4.7500 | 4.8500 | 63.0000 | 14725.00 | 0.00 | 14725.00 | 31 | 9 | 555 | 4343 | 0.127791848952337 | 0.711099232770977 | 0.711099232770977 | true | false | false | true | ||||||||||||||||
| 5ad83cb6-9254-4b14-a9ea-469b6bb3e93d | 2026-09-16 10:20 | 2026-09-16 10:20 | 2026-09-16 10:20 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 4.7000 | 4.7000 | 4.7500 | 63.0000 | 18800.00 | 0.00 | 18800.00 | 40 | 9 | 596 | 4343 | 0.137232327883951 | 0.713321896751618 | 0.713321896751618 | true | false | false | true | ||||||||||||||||
| 89899e79-569b-49bf-8b8a-43f8b1531f4f | 2026-09-16 13:49 | 2026-09-16 13:49 | 2026-09-16 13:49 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 4.0600 | 4.0500 | 4.1500 | 62.0000 | 16220.00 | 405.00 | 15815.00 | 40 | 16 | 1281 | 4343 | 0.294957402717016 | 0.696238897038728 | 0.690578042588306 | true | false | false | true | ||||||||||||||||
| daab6d66-e517-4eae-af63-002fed664044 | 2026-09-17 09:31 | 2026-09-17 09:30 | 2026-09-17 09:30 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 5.5000 | 5.4500 | 5.5500 | 65.6600 | 14294.00 | 3294.00 | 0.00 | 26 | 7 | 291 | 5272 | 0.0551972685887709 | 0.687677704425535 | 0.690423712231892 | false | false | false | true | ||||||||||||||||
| c77e939a-eeb1-4678-8f3a-6990aae1243a | 2026-09-17 09:31 | 2026-09-17 09:31 | 2026-09-17 09:31 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 5.5100 | 5.2000 | 5.5500 | 65.5500 | 32485.00 | 32485.00 | 0.00 | 59 | 18 | 432 | 5272 | 0.0819423368740516 | 0.685210105223318 | 0.705812238584491 | true | false | false | true | ||||||||||||||||
| b346ce8c-e3c6-431c-9b7b-bb2e24e32abb | 2026-09-17 09:31 | 2026-09-17 09:31 | 2026-09-17 09:31 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 5.6000 | 5.4500 | 5.6500 | 65.8800 | 19040.00 | 13440.00 | 0.00 | 34 | 11 | 497 | 5272 | 0.0942716236722307 | 0.686965889867672 | 0.686965889867672 | false | false | false | true | ||||||||||||||||
| 7b92925e-5853-4a52-8fdf-7d0e3b60ef11 | 2026-09-17 09:36 | 2026-09-17 09:36 | 2026-09-17 09:36 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 5.8000 | 5.6000 | 5.8000 | 66.2100 | 12180.00 | 12180.00 | 0.00 | 21 | 8 | 839 | 5272 | 0.159142640364188 | 0.688260960655047 | 0.688260960655047 | false | false | false | true | ||||||||||||||||
| 438851d5-31af-4036-aaa3-d81dba92c389 | 2026-09-17 09:36 | 2026-09-17 09:36 | 2026-09-17 09:36 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 5.9000 | 5.7500 | 5.9000 | 66.3800 | 20060.00 | 20060.00 | 0.00 | 34 | 5 | 938 | 5272 | 0.177921092564492 | 0.688334653442544 | 0.688334653442544 | false | false | false | true | ||||||||||||||||
| bac7aa43-8d8b-425a-a3be-37a8cdb8ce14 | 2026-09-17 09:42 | 2026-09-17 09:42 | 2026-09-17 09:42 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 6.1000 | 5.9000 | 6.1000 | 66.7200 | 31110.00 | 31110.00 | 0.00 | 51 | 9 | 1127 | 5272 | 0.213770864946889 | 0.688122739557044 | 0.688122739557044 | false | false | false | true | ||||||||||||||||
| 0b3973f2-e74e-43e7-9c69-6ed14b9ab120 | 2026-09-18 10:02 | 2026-09-18 10:02 | 2026-09-18 10:02 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 4.8000 | 4.8000 | 5.0000 | 64.6001 | 15840.00 | 0.00 | 15840.00 | 33 | 6 | 295 | 4653 | 0.0633999570169783 | 0.686492376737972 | 0.686492376737972 | true | false | false | true | ||||||||||||||||
| ac709a06-8858-4b1e-b5d3-987b59261196 | 2026-09-22 13:54 | 2026-09-22 13:54 | 2026-09-22 13:54 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 9.1000 | 8.7000 | 9.2000 | 71.7700 | 39130.00 | 39130.00 | 0.00 | 43 | 8 | 403 | 5182 | 0.0777692010806638 | 0.700074836352228 | 0.697560197147165 | false | false | false | true | ||||||||||||||||
| a5b5b66b-d131-4ec8-b983-e7ff63a17e62 | 2026-09-22 14:55 | 2026-09-22 14:55 | 2026-09-22 14:55 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 9.5000 | 9.2000 | 9.5000 | 72.1291 | 47500.00 | 47500.00 | 0.00 | 50 | 9 | 490 | 5182 | 0.0945580856812042 | 0.719896139065418 | 0.719896139065418 | false | false | false | true | ||||||||||||||||
| 666e3d66-df17-492d-b371-c341749dca22 | 2026-09-23 11:24 | 2026-09-23 11:24 | 2026-09-23 11:24 | RKLB | RKLB261016C00065000 | call | 65.0000 | 2026-10-16 | 9.4500 | 8.6500 | 9.4500 | 72.1300 | 28350.00 | 28350.00 | 0.00 | 30 | 6 | 142 | 5172 | 0.0274555297757154 | 0.7273743708029 | 0.7273743708029 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 37426822649.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T17:30:37.600118Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 37426822649.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:58:33.363095Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 37426822649.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T17:27:08.545704Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 37426822649.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:36:37.058930Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 37426822649.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T17:45:33.615815Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 38114925703.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 38114925703.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 38114925703.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 38114925703.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 38114925703.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:03:30.942669Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 40580129689.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:32:41.851557Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 40580129689.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:32:41.851557Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 40580129689.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:32:41.851557Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 40580129689.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 40580129689.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 40580129689.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:47:44.789077Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 38635490623.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:08:58.692787Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 43069267694.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:57:38.128984Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 43069267694.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:02:38.336545Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 42070022389.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:28:13.578365Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |