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_alerts658,639 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 |
|---|
| ab84d7db-9c3b-47f3-bb9a-4c76d14d2077 | 2026-09-23 14:11 | 2026-09-23 14:11 | 2026-09-23 14:11 | RKLB | RKLB270115C00075000 | call | 75.0000 | 2027-01-15 | 10.5000 | 10.2000 | 10.5000 | 70.6150 | 52480.00 | 48300.00 | 4180.00 | 50 | 5 | 228 | 3643 | 0.0625857809497667 | 0.757597248002149 | 0.757597248002149 | false | false | false | true | false | 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-23T18:11:21.793472Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 41c27bf5-2bbc-4a13-af8c-ae5d17e107f3 | 2026-09-18 12:45 | 2026-09-18 12:45 | 2026-09-18 12:45 | RKLB | RKLB270115C00075000 | call | 75.0000 | 2027-01-15 | 7.4000 | 7.4000 | 7.5000 | 64.1600 | 105840.00 | 0.00 | 105840.00 | 143 | 14 | 409 | 3510 | 0.116524216524217 | 0.747705123290371 | 0.747705123290371 | true | false | false | true | ||||||||||||||||
| 905c0487-e590-4375-90d8-ea6d7fb7dd93 | 2026-09-16 14:30 | 2026-09-16 14:29 | 2026-09-16 14:29 | RKLB | RKLB270115C00075000 | call | 75.0000 | 2027-01-15 | 7.0900 | 6.9500 | 7.4500 | 63.0800 | 24800.00 | 0.00 | 24800.00 | 35 | 5 | 56 | 3742 | 0.0149652592196686 | 0.753327406172189 | 0.753327406172189 | false | false | false | true | ||||||||||||||||
| b8ec3264-aa6b-4ead-b86f-6d7707eb1439 | 2026-09-10 10:01 | 2026-09-10 10:01 | 2026-09-10 10:01 | RKLB | RKLB270115C00075000 | call | 75.0000 | 2027-01-15 | 8.0500 | 7.9000 | 8.0500 | 63.9100 | 10465.00 | 10465.00 | 0.00 | 13 | 6 | 386 | 3863 | 0.0999223401501424 | 0.774557621464961 | 0.774557621464961 | false | false | false | true | ||||||||||||||||
| 9c806eae-2600-438d-9376-f47da829bd61 | 2026-09-10 09:50 | 2026-09-10 09:49 | 2026-09-10 09:49 | RKLB | RKLB270115C00075000 | call | 75.0000 | 2027-01-15 | 8.2000 | 8.1000 | 8.2000 | 64.1500 | 11480.00 | 11480.00 | 0.00 | 14 | 5 | 121 | 3863 | 0.0313228061092415 | 0.777105442802912 | 0.777105442802912 | false | false | false | true | ||||||||||||||||
| e686bb7c-6f86-466c-8df2-9deb47da3141 | 2026-09-10 09:49 | 2026-09-10 09:49 | 2026-09-10 09:49 | RKLB | RKLB270115C00075000 | call | 75.0000 | 2027-01-15 | 8.2000 | 7.9500 | 8.3250 | 64.1100 | 20500.00 | 15580.00 | 0.00 | 25 | 11 | 53 | 3863 | 0.0137199068081802 | 0.783947343252504 | 0.778348736627578 | false | false | false | true | ||||||||||||||||
| 5870cb0e-9e1a-4ed1-8251-375fdd1f5eb1 | 2026-09-09 12:19 | 2026-09-09 12:19 | 2026-09-09 12:19 | RKLB | RKLB270115C00075000 | call | 75.0000 | 2027-01-15 | 8.1000 | 8.0000 | 8.2500 | 63.8400 | 332100.00 | 0.00 | 332100.00 | 410 | 1 | 1303 | 4183 | 0.311498924217069 | 0.776906757638347 | 0.776906757638347 | false | true | false | true | ||||||||||||||||
| 42428994-1a09-4abf-843d-fcf884526b46 | 2026-09-09 10:23 | 2026-09-09 10:23 | 2026-09-09 10:23 | RKLB | RKLB270115C00075000 | call | 75.0000 | 2027-01-15 | 8.4600 | 8.3000 | 8.5000 | 64.0000 | 15235.00 | 4250.00 | 10985.00 | 18 | 5 | 584 | 4183 | 0.139612718144872 | 0.777562708954559 | 0.774283721757955 | false | false | false | true | ||||||||||||||||
| 369236d5-5635-4481-ad5b-9c1c0983e079 | 2026-09-09 10:23 | 2026-09-09 10:23 | 2026-09-09 10:23 | RKLB | RKLB270115C00075000 | call | 75.0000 | 2027-01-15 | 8.5000 | 8.4000 | 8.5000 | 64.7400 | 10200.00 | 10200.00 | 0.00 | 12 | 5 | 539 | 4183 | 0.128854888835764 | 0.775379887555493 | 0.775379887555493 | false | false | false | true | ||||||||||||||||
| 1bb8a37b-3752-4294-a7e3-52ec7252a881 | 2026-09-09 10:01 | 2026-09-09 10:01 | 2026-09-09 10:01 | RKLB | RKLB270115C00075000 | call | 75.0000 | 2027-01-15 | 9.0000 | 8.8000 | 9.1000 | 65.4600 | 28800.00 | 18000.00 | 10800.00 | 32 | 5 | 414 | 4183 | 0.0989720296437963 | 0.782807097366645 | 0.785332647871567 | false | false | false | true | ||||||||||||||||
| 4eec3d59-ebc4-4ac0-88ff-be0e56105886 | 2026-09-08 12:54 | 2026-09-08 12:54 | 2026-09-08 12:54 | RKLB | RKLB270115C00075000 | call | 75.0000 | 2027-01-15 | 9.6000 | 9.6000 | 9.6500 | 66.6900 | 13440.00 | 0.00 | 5760.00 | 14 | 6 | 1173 | 3001 | 0.390869710096634 | 0.781578372781003 | 0.781578372781003 | false | false | false | true | ||||||||||||||||
| 53c3a9d3-9ae3-4df2-8035-d319c1998bc8 | 2026-09-08 11:49 | 2026-09-08 11:49 | 2026-09-08 11:49 | RKLB | RKLB270115C00075000 | call | 75.0000 | 2027-01-15 | 9.7000 | 9.6000 | 9.7000 | 66.9100 | 10670.00 | 2910.00 | 0.00 | 11 | 9 | 1004 | 3001 | 0.334555148283905 | 0.780873982261483 | 0.780873982261483 | false | false | false | true | ||||||||||||||||
| 647a9448-8e4a-422f-bea8-ee1846fc7825 | 2026-09-08 11:03 | 2026-09-08 11:03 | 2026-09-08 11:03 | RKLB | RKLB270115C00075000 | call | 75.0000 | 2027-01-15 | 9.5000 | 9.3000 | 9.5000 | 66.6738 | 22800.00 | 22800.00 | 0.00 | 24 | 6 | 859 | 3001 | 0.286237920693102 | 0.775770441075531 | 0.775770441075531 | false | false | false | true | ||||||||||||||||
| 95f7ab8a-5f50-4129-b522-571ab2e9ac37 | 2026-09-08 10:01 | 2026-09-08 10:01 | 2026-09-08 10:01 | RKLB | RKLB270115C00075000 | call | 75.0000 | 2027-01-15 | 9.1000 | 9.1000 | 9.2000 | 66.0300 | 20930.00 | 0.00 | 20930.00 | 23 | 7 | 413 | 3001 | 0.137620793068977 | 0.770707767709393 | 0.770707767709393 | false | false | false | true | ||||||||||||||||
| 2d9d20f0-2f5a-4781-87cc-2d00a6c2c302 | 2026-09-08 10:00 | 2026-09-08 10:00 | 2026-09-08 10:00 | RKLB | RKLB270115C00075000 | call | 75.0000 | 2027-01-15 | 9.1000 | 9.1000 | 9.2000 | 66.1200 | 20020.00 | 0.00 | 20020.00 | 22 | 5 | 314 | 3001 | 0.104631789403532 | 0.767876107224587 | 0.767876107224587 | false | false | false | true | ||||||||||||||||
| 16fb3e6c-de01-4ddc-8ced-424357f015e1 | 2026-09-08 09:33 | 2026-09-08 09:33 | 2026-09-08 09:33 | RKLB | RKLB270115C00075000 | call | 75.0000 | 2027-01-15 | 8.8900 | 8.4500 | 9.0000 | 65.9600 | 177720.00 | 177720.00 | 0.00 | 200 | 14 | 202 | 3001 | 0.0673108963678774 | 0.756925325461321 | 0.756925325461321 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 38635490623.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:45:45.480252Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 38114925703.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:44:45.237115Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 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-10T14:06:33.692120Z"} |
| 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-10T13:52:43.061304Z"} |
| 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-10T13:52:43.061304Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| Common Stock |
| Industrials |
| 37426822649.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T16:21:26.040266Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:40:24.011597Z"} |
| 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-09T14:24:00.331334Z"} |
| 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-09T14:11:22.686371Z"} |
| 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-08T17:11:09.796111Z"} |
| 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-08T16:00:45.446709Z"} |
| 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-08T15:14:28.726538Z"} |
| 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-08T14:14:21.867252Z"} |
| 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-08T14:14:21.867252Z"} |
| 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-08T13:39:51.680537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |