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_alerts609,118 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 |
|---|
| 980cfec9-9252-455c-a2fb-ad9663922c07 | 2026-09-21 11:19 | 2026-09-21 11:18 | 2026-09-21 11:18 | MRVL | MRVL261002C00265000 | call | 265.0000 | 2026-10-02 | 7.4000 | 7.3500 | 7.4500 | 253.4601 | 20720.00 | 6660.00 | 14060.00 | 28 | 11 | 159 | 487 | 0.326488706365503 | 0.680398811870652 | 0.680398811870652 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 225696522000.00 | 2026-12-01 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:19:12.034191Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 7faba206-a197-4f5b-9fe1-96c610cc6620 | 2026-09-21 15:10 | 2026-09-21 15:10 | 2026-09-21 15:10 | MRVL | MRVL261002C00265000 | call | 265.0000 | 2026-10-02 | 9.9000 | 9.8500 | 10.3500 | 259.2000 | 38615.00 | 1980.00 | 35645.00 | 39 | 9 | 822 | 487 | 1.68788501026694 | 0.686711185619106 | 0.686711185619106 | true | false | false | true | ||||||||||||||||
| fa875b0c-8ce3-42d5-8e3c-d551af30cd5f | 2026-09-21 15:30 | 2026-09-21 15:29 | 2026-09-21 15:29 | MRVL | MRVL261002C00265000 | call | 265.0000 | 2026-10-02 | 9.8500 | 9.8500 | 9.9000 | 259.2000 | 35460.00 | 0.00 | 35460.00 | 36 | 15 | 880 | 487 | 1.80698151950719 | 0.683906909504787 | 0.683906909504787 | true | false | false | true | ||||||||||||||||
| 91c04ed7-6006-4a05-993d-3af643b396c5 | 2026-09-22 09:32 | 2026-09-22 09:32 | 2026-09-22 09:32 | MRVL | MRVL261002C00265000 | call | 265.0000 | 2026-10-02 | 8.8800 | 8.6000 | 9.6500 | 258.3850 | 12435.00 | 2660.00 | 9775.00 | 14 | 12 | 16 | 786 | 0.0203562340966921 | 0.680351817926456 | 0.680351817926456 | true | false | false | true | ||||||||||||||||
| 394852da-6b2c-4c37-83e2-ff2d871e1e3d | 2026-09-22 10:32 | 2026-09-22 10:32 | 2026-09-22 10:32 | MRVL | MRVL261002C00265000 | call | 265.0000 | 2026-10-02 | 10.7000 | 10.4000 | 10.7500 | 262.5700 | 14980.00 | 13910.00 | 1070.00 | 14 | 5 | 160 | 786 | 0.203562340966921 | 0.674725556557773 | 0.674725556557773 | false | false | false | true | ||||||||||||||||
| d11dfe71-11b5-4c5c-b419-cc5f807c4ea6 | 2026-09-23 10:35 | 2026-09-23 10:35 | 2026-09-23 10:35 | MRVL | MRVL261002C00265000 | call | 265.0000 | 2026-10-02 | 7.9000 | 7.6000 | 7.9000 | 258.5450 | 10270.00 | 10270.00 | 0.00 | 13 | 6 | 139 | 932 | 0.149141630901288 | 0.65398680319627 | 0.65398680319627 | false | false | false | true | ||||||||||||||||
| 8e8e0e61-53bf-4f93-aa54-7536b9fa4312 | 2026-09-23 11:24 | 2026-09-23 11:24 | 2026-09-23 11:24 | MRVL | MRVL261002C00265000 | call | 265.0000 | 2026-10-02 | 8.5000 | 8.1500 | 8.5500 | 260.3250 | 36549.00 | 36549.00 | 0.00 | 43 | 14 | 242 | 932 | 0.259656652360515 | 0.642454495681909 | 0.642454495681909 | true | false | false | true | ||||||||||||||||
| c8fd11a4-70d6-406e-83bd-c90cdd5790b6 | 2026-09-23 12:41 | 2026-09-23 12:41 | 2026-09-23 12:41 | MRVL | MRVL261002C00265000 | call | 265.0000 | 2026-10-02 | 7.5500 | 7.5000 | 7.8500 | 258.0000 | 13590.00 | 2265.00 | 11325.00 | 18 | 10 | 278 | 932 | 0.298283261802575 | 0.642528395046476 | 0.642528395046476 | true | false | false | true | ||||||||||||||||
| 02f12844-b36e-44e3-ab8e-d76295bf90cc | 2026-09-24 10:07 | 2026-09-24 10:06 | 2026-09-24 10:06 | MRVL | MRVL261002C00265000 | call | 265.0000 | 2026-10-02 | 6.0000 | 5.8000 | 6.2000 | 255.9150 | 30005.00 | 15605.00 | 14400.00 | 50 | 10 | 107 | 988 | 0.1082995951417 | 0.637433795639133 | 0.640906893033438 | false | false | false | true | ||||||||||||||||
| 40167107-f4b8-41f2-aeec-5c3e3db5dd02 | 2026-09-24 10:07 | 2026-09-24 10:07 | 2026-09-24 10:07 | MRVL | MRVL261002C00265000 | call | 265.0000 | 2026-10-02 | 6.1000 | 5.8500 | 6.3000 | 256.0000 | 30500.00 | 15250.00 | 15250.00 | 50 | 8 | 157 | 988 | 0.158906882591093 | 0.64214250372203 | 0.64214250372203 | false | false | false | true | ||||||||||||||||
| d57f3619-174b-4e64-9c39-634fc0f7558b | 2026-09-25 12:16 | 2026-09-25 12:15 | 2026-09-25 12:15 | MRVL | MRVL261002C00265000 | call | 265.0000 | 2026-10-02 | 9.5000 | 9.3500 | 9.5000 | 265.4950 | 20900.00 | 20900.00 | 0.00 | 22 | 10 | 708 | 1384 | 0.511560693641618 | 0.624580430109753 | 0.624580430109753 | false | false | false | true | ||||||||||||||||
| 6090b59c-00fd-49c7-9167-1e352fb16a4a | 2026-09-28 14:37 | 2026-09-28 14:37 | 2026-09-28 14:37 | MRVL | MRVL261002C00265000 | call | 265.0000 | 2026-10-02 | 2.8500 | 2.7500 | 2.8500 | 251.5150 | 11399.00 | 11115.00 | 284.00 | 40 | 10 | 604 | 1835 | 0.329155313351499 | 0.721168838800908 | 0.721168838800908 | false | false | false | true | ||||||||||||||||
| d511e2a7-6d18-46e5-acc1-8ffedc2dc61b | 2026-09-29 10:32 | 2026-09-29 10:32 | 2026-09-29 10:32 | MRVL | MRVL261002C00265000 | call | 265.0000 | 2026-10-02 | 6.0500 | 5.7500 | 6.0500 | 262.2150 | 12092.00 | 12092.00 | 0.00 | 20 | 11 | 1020 | 2009 | 0.507715281234445 | 0.768011272983637 | 0.768011272983637 | false | false | false | true | ||||||||||||||||
| 453eef44-695b-40d2-ac02-e70cffb0297b | 2026-09-30 15:15 | 2026-09-30 15:15 | 2026-09-30 15:15 | MRVL | MRVL261002C00265000 | call | 265.0000 | 2026-10-02 | 4.9500 | 4.8500 | 4.9500 | 263.4000 | 28690.00 | 28690.00 | 0.00 | 58 | 20 | 1764 | 2377 | 0.742111905763568 | 0.729137313995636 | 0.729137313995636 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 225696522000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 225696522000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 230063484000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:32:27.895939Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 230063484000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:34:01.762519Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 228783210000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:37:43.750009Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 228783210000.00 |
| 2026-12-01 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 228783210000.00 |
| 2026-12-01 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:43:49.845741Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 228783210000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:08:54.070178Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 228783210000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:08:54.070178Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 229690801500.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:18:06.291601Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 220891110000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:38:54.071675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 230861463000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:32:52.206353Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 230861463000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:16:05.592005Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |