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 |
|---|
| 224628d6-4e57-455f-9ba6-9e8d898cf52d | 2026-09-23 14:50 | 2026-09-23 14:50 | 2026-09-23 14:50 | MRVL | MRVL261016P00220000 | put | 220.0000 | 2026-10-16 | 3.5500 | 3.5000 | 3.6000 | 258.9600 | 23075.00 | 8165.00 | 6745.00 | 65 | 5 | 501 | 4733 | 0.105852524825692 | 0.677886253349508 | 0.677886253349508 | false | false | false | true | false | 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-23T18:58:18.142602Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 87019915-1fed-4931-ad4f-14c03a22b54b | 2026-09-22 14:03 | 2026-09-22 14:03 | 2026-09-22 14:03 | MRVL | MRVL261016P00220000 | put | 220.0000 | 2026-10-16 | 3.3500 | 3.3500 | 3.4500 | 263.2500 | 15075.00 | 0.00 | 15075.00 | 45 | 16 | 1006 | 4481 | 0.224503459049319 | 0.691200420654224 | 0.690514591997306 | false | false | false | true | ||||||||||||||||
| 14a52129-8435-43bf-b4d4-a227cac028c0 | 2026-09-22 09:32 | 2026-09-22 09:32 | 2026-09-22 09:32 | MRVL | MRVL261016P00220000 | put | 220.0000 | 2026-10-16 | 4.1000 | 4.0500 | 4.3500 | 259.2400 | 50045.00 | 410.00 | 49635.00 | 122 | 8 | 127 | 4481 | 0.0283418879714349 | 0.705088936716191 | 0.702115947950892 | true | false | false | true | ||||||||||||||||
| 293a6125-3988-489c-b9c6-accb50e358c6 | 2026-09-21 15:30 | 2026-09-21 15:30 | 2026-09-21 15:30 | MRVL | MRVL261016P00220000 | put | 220.0000 | 2026-10-16 | 4.4000 | 4.4000 | 4.5000 | 259.0000 | 17600.00 | 0.00 | 17600.00 | 40 | 5 | 1372 | 4014 | 0.341803687095167 | 0.707878585583246 | 0.707878585583246 | false | false | false | true | ||||||||||||||||
| 770bdedd-f5f0-449b-b7b7-33fe352ffd31 | 2026-09-21 15:30 | 2026-09-21 15:30 | 2026-09-21 15:30 | MRVL | MRVL261016P00220000 | put | 220.0000 | 2026-10-16 | 4.4000 | 4.4000 | 4.5000 | 259.0000 | 20240.00 | 0.00 | 20240.00 | 46 | 6 | 1265 | 4014 | 0.315146985550573 | 0.708459229174958 | 0.708168946425388 | false | false | false | true | ||||||||||||||||
| 164db4a8-cd69-44c7-8309-439941ee7f86 | 2026-09-21 15:10 | 2026-09-21 15:10 | 2026-09-21 15:10 | MRVL | MRVL261016P00220000 | put | 220.0000 | 2026-10-16 | 4.4500 | 4.3500 | 4.5000 | 259.0700 | 19135.00 | 18690.00 | 445.00 | 43 | 13 | 1063 | 4014 | 0.264823119083209 | 0.708623859231965 | 0.707991997514911 | false | false | false | true | ||||||||||||||||
| 1908dd3e-6911-4b74-9a5d-a3048532b5cd | 2026-09-21 10:36 | 2026-09-21 10:36 | 2026-09-21 10:36 | MRVL | MRVL261016P00220000 | put | 220.0000 | 2026-10-16 | 5.5000 | 5.4500 | 5.6500 | 251.3300 | 85800.00 | 55000.00 | 30800.00 | 156 | 6 | 345 | 4014 | 0.085949177877429 | 0.688552120400193 | 0.688552120400193 | false | false | false | true | ||||||||||||||||
| d9b2eda5-d7d9-4403-8780-e01980075e51 | 2026-09-18 13:09 | 2026-09-18 13:09 | 2026-09-18 13:09 | MRVL | MRVL261016P00220000 | put | 220.0000 | 2026-10-16 | 9.1500 | 9.0500 | 9.2000 | 236.5800 | 57645.00 | 38430.00 | 0.00 | 63 | 11 | 507 | 3511 | 0.144403303902022 | 0.650194376489375 | 0.650194376489375 | false | false | false | true | ||||||||||||||||
| fed07cfc-c550-4cff-892c-5c316e1a8708 | 2026-09-18 13:09 | 2026-09-18 13:09 | 2026-09-18 13:09 | MRVL | MRVL261016P00220000 | put | 220.0000 | 2026-10-16 | 9.1400 | 8.8500 | 9.1500 | 236.6150 | 169179.00 | 168269.00 | 910.00 | 185 | 41 | 423 | 3511 | 0.120478496154942 | 0.650659247871001 | 0.648479469209203 | true | false | false | true | ||||||||||||||||
| 0ae8f610-e12c-4dfc-821f-24e6ceb18dbe | 2026-09-17 15:17 | 2026-09-17 15:16 | 2026-09-17 15:16 | MRVL | MRVL261016P00220000 | put | 220.0000 | 2026-10-16 | 8.4500 | 8.1500 | 8.5000 | 241.0100 | 81952.00 | 81112.00 | 840.00 | 97 | 31 | 648 | 3609 | 0.179551122194514 | 0.664560061090583 | 0.664560061090583 | false | false | false | true | ||||||||||||||||
| d2f16c61-4668-424f-986f-1f66ffbff670 | 2026-09-11 13:55 | 2026-09-11 13:55 | 2026-09-11 13:55 | MRVL | MRVL261016P00220000 | put | 220.0000 | 2026-10-16 | 9.7500 | 9.6500 | 9.7500 | 239.5800 | 96525.00 | 96525.00 | 0.00 | 99 | 7 | 263 | 3534 | 0.0744199207696661 | 0.64254139105823 | 0.64254139105823 | false | false | false | true | ||||||||||||||||
| 2d637701-4ae8-4e04-94b9-1640c3418de0 | 2026-09-10 14:50 | 2026-09-10 14:50 | 2026-09-10 14:50 | MRVL | MRVL261016P00220000 | put | 220.0000 | 2026-10-16 | 13.3000 | 13.0000 | 13.3500 | 230.0500 | 71820.00 | 70490.00 | 1330.00 | 54 | 10 | 317 | 3625 | 0.087448275862069 | 0.649239110183672 | 0.649239110183672 | false | false | false | true | ||||||||||||||||
| c6808dc0-2fb3-4125-9d69-879f69dbfc99 | 2026-09-08 15:15 | 2026-09-08 15:15 | 2026-09-08 15:15 | MRVL | MRVL261016P00220000 | put | 220.0000 | 2026-10-16 | 14.9000 | 14.7500 | 15.2000 | 227.6056 | 78971.00 | 2980.00 | 75991.00 | 53 | 14 | 802 | 3025 | 0.265123966942149 | 0.656738893757418 | 0.656738893757418 | true | false | false | true | ||||||||||||||||
| d7c670b0-1112-4a3c-b8cc-ee54ffd53aa8 | 2026-09-08 14:34 | 2026-09-08 14:34 | 2026-09-08 14:34 | MRVL | MRVL261016P00220000 | put | 220.0000 | 2026-10-16 | 14.6000 | 14.5500 | 14.6500 | 228.6522 | 80300.00 | 78840.00 | 1460.00 | 55 | 11 | 720 | 3025 | 0.23801652892562 | 0.660348739133468 | 0.660348739133468 | false | false | false | true | ||||||||||||||||
| 7aec7659-2f3e-4d56-b079-51b5e6db3e91 | 2026-09-08 10:50 | 2026-09-08 10:50 | 2026-09-08 10:50 | MRVL | MRVL261016P00220000 | put | 220.0000 | 2026-10-16 | 15.1000 | 15.0500 | 15.3000 | 226.9000 | 617604.00 | 4530.00 | 613074.00 | 409 | 61 | 518 | 3025 | 0.171239669421488 | 0.654057478862954 | 0.654057478862954 | false | false | false | true | ||||||||||||||||
| 3a17c4d9-01fe-4a48-adbf-d257575fa899 | 2026-08-17 11:02 | 2026-08-17 11:01 | 2026-08-17 11:01 | MRVL | MRVL261016P00220000 | put | 220.0000 | 2026-10-16 | 20.8400 | 19.5500 | 20.8500 | 239.0707 | 83375.00 | 83375.00 | 0.00 | 40 | 6 | 84 | 2061 | 0.0407569141193595 | 0.813845021167914 | 0.813845021167914 | false | false | false | true |
| 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-22T18:10:48.215993Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:33:30.058722Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 225696522000.00 |
| 2026-12-01 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} |
| 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: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-21T14:37:14.719915Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 214182825000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:09:50.881001Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 214182825000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:09:50.881001Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 211122444000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:28:01.580099Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 191883258000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T18:02:32.717866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 191883258000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T19:03:59.290358Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 191883258000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:30:09.198364Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 191883258000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:43:21.019108Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 191883258000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 191883258000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |