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 |
|---|
| 755412b3-b927-4e3a-99f2-96fe1323624c | 2026-09-30 15:36 | 2026-09-30 15:35 | 2026-09-30 15:35 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 3.4500 | 3.3500 | 3.4500 | 264.2600 | 16206.00 | 16206.00 | 0.00 | 47 | 19 | 1622 | 3062 | 0.529719137818419 | 0.742683685724359 | 0.741316613970372 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 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:37:24.384434Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| 46031337-6194-424a-8863-25a32ce5eccf | 2026-09-29 14:14 | 2026-09-29 14:14 | 2026-09-29 14:14 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 4.0000 | 3.9500 | 4.0000 | 262.0000 | 84400.00 | 84400.00 | 0.00 | 211 | 5 | 2689 | 2879 | 0.934004862799583 | 0.727668041639353 | 0.727668041639353 | false | false | false | true | ||||||||||||||||
| f94a3e63-e08f-47ec-957e-7bb9dff012bd | 2026-09-29 10:32 | 2026-09-29 10:32 | 2026-09-29 10:32 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 4.2500 | 4.2000 | 4.2500 | 262.5300 | 42925.00 | 42925.00 | 0.00 | 101 | 5 | 1527 | 2879 | 0.530392497394929 | 0.764472388618246 | 0.764472388618246 | true | false | false | true | ||||||||||||||||
| df623ce9-9810-4a58-87bb-65dfe22cf5c2 | 2026-09-29 09:40 | 2026-09-29 09:39 | 2026-09-29 09:39 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 4.0000 | 3.7500 | 4.0500 | 261.1200 | 11205.00 | 11205.00 | 0.00 | 28 | 7 | 661 | 2879 | 0.229593608891976 | 0.806199635300622 | 0.797458972159872 | false | false | false | true | ||||||||||||||||
| bbe4b431-8fe0-432d-a3b1-e26f1e63027d | 2026-09-28 12:14 | 2026-09-28 12:13 | 2026-09-28 12:13 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 1.8300 | 1.8000 | 1.8700 | 251.5300 | 18284.00 | 4600.00 | 3128.00 | 100 | 8 | 2127 | 1924 | 1.10550935550936 | 0.718476568820372 | 0.715620589753155 | false | false | false | true | ||||||||||||||||
| 28c91013-b172-459d-ac40-2aed3163c1fd | 2026-09-28 10:51 | 2026-09-28 10:50 | 2026-09-28 10:50 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 1.6300 | 1.6300 | 1.7200 | 249.1000 | 150776.00 | 164.00 | 150612.00 | 925 | 48 | 1716 | 1924 | 0.891891891891892 | 0.749997634148648 | 0.749997634148648 | false | false | false | true | ||||||||||||||||
| 58224a98-a4a9-41d7-89ac-bebd614dde6e | 2026-09-25 11:03 | 2026-09-25 11:03 | 2026-09-25 11:03 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 5.8000 | 5.6500 | 5.8500 | 262.1900 | 17400.00 | 10440.00 | 6960.00 | 30 | 8 | 564 | 1652 | 0.341404358353511 | 0.61950607134641 | 0.61950607134641 | false | false | false | true | ||||||||||||||||
| 0e07a5a8-ca7d-40d5-8c6b-971e0da62cc6 | 2026-09-25 11:03 | 2026-09-25 11:03 | 2026-09-25 11:03 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 5.8000 | 5.6500 | 5.8500 | 262.1800 | 23200.00 | 22620.00 | 580.00 | 40 | 11 | 533 | 1652 | 0.322639225181598 | 0.619783850623391 | 0.619783850623391 | false | false | false | true | ||||||||||||||||
| 90b072ab-c2f2-42c1-90b8-ea8920f16a08 | 2026-09-25 10:28 | 2026-09-25 10:28 | 2026-09-25 10:28 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 5.0500 | 5.0500 | 5.2500 | 259.8300 | 33330.00 | 0.00 | 33330.00 | 66 | 16 | 368 | 1652 | 0.222760290556901 | 0.628047200939244 | 0.628047200939244 | false | false | false | true | ||||||||||||||||
| 8d0ada33-533a-4fa9-a5d3-20a57b894dd1 | 2026-09-24 15:39 | 2026-09-24 15:39 | 2026-09-24 15:39 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 6.2500 | 6.0000 | 6.3000 | 260.0000 | 15625.00 | 12500.00 | 3125.00 | 25 | 5 | 446 | 1539 | 0.289798570500325 | 0.647879435953352 | 0.647879435953352 | false | false | false | true | ||||||||||||||||
| f62ec82b-0634-44e5-91f8-3b02c672326c | 2026-09-23 10:53 | 2026-09-23 10:53 | 2026-09-23 10:53 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 6.6500 | 6.4000 | 6.6500 | 259.7300 | 27265.00 | 27265.00 | 0.00 | 41 | 10 | 308 | 1610 | 0.191304347826087 | 0.659565324553639 | 0.659565324553639 | false | false | false | true | ||||||||||||||||
| 47f50080-f04b-4cfd-b4e6-70f0980ca64c | 2026-09-23 10:01 | 2026-09-23 10:01 | 2026-09-23 10:01 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 8.0000 | 7.6000 | 8.0500 | 263.0000 | 10395.00 | 8800.00 | 1595.00 | 13 | 7 | 194 | 1610 | 0.120496894409938 | 0.662096540551336 | 0.6607850620733 | false | false | false | true | ||||||||||||||||
| e0800482-8fd6-4c18-853d-95d0f75c44f5 | 2026-09-23 09:42 | 2026-09-23 09:42 | 2026-09-23 09:42 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 8.5300 | 8.2500 | 8.6500 | 263.2300 | 10235.00 | 9375.00 | 860.00 | 12 | 10 | 56 | 1610 | 0.0347826086956522 | 0.689918657786832 | 0.693020279915687 | false | false | false | true | ||||||||||||||||
| 7bb5da96-d869-48d5-8808-5e3c93be44c6 | 2026-09-22 15:49 | 2026-09-22 15:49 | 2026-09-22 15:49 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 10.1000 | 9.9500 | 10.1000 | 265.6600 | 12120.00 | 12120.00 | 0.00 | 12 | 12 | 707 | 1712 | 0.412967289719626 | 0.680121391039103 | 0.680121391039103 | false | false | false | true | ||||||||||||||||
| 4c0821ac-0591-469d-8b70-8f3f36532233 | 2026-09-22 09:32 | 2026-09-22 09:32 | 2026-09-22 09:32 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 7.1500 | 6.9500 | 7.8500 | 258.3850 | 148725.00 | 2865.00 | 145860.00 | 208 | 6 | 212 | 1712 | 0.123831775700935 | 0.690958671274605 | 0.686920242636365 | true | false | false | true | ||||||||||||||||
| caf13b97-2168-4cdd-bb76-fb9fd70bb4ce | 2026-09-21 11:25 | 2026-09-21 11:25 | 2026-09-21 11:25 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 6.0500 | 5.8500 | 6.1000 | 253.7500 | 30250.00 | 29645.00 | 605.00 | 50 | 6 | 372 | 1464 | 0.254098360655738 | 0.686019960772322 | 0.686019960772322 | true | false | false | true | ||||||||||||||||
| 19fe09d0-ec07-4ba9-b7e4-1ce92d9a4509 | 2026-09-21 11:25 | 2026-09-21 11:25 | 2026-09-21 11:25 | MRVL | MRVL261002C00270000 | call | 270.0000 | 2026-10-02 | 5.9900 | 5.8500 | 6.0000 | 253.6800 | 23956.00 | 23956.00 | 0.00 | 40 | 11 | 306 | 1464 | 0.209016393442623 | 0.683038578509529 | 0.68430161863241 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 230861463000.00 |
| 2026-12-01 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:21:06.128896Z"} |
| 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-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-29T13:42:07.664429Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 220891110000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:16:42.064656Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 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-28T14:52:34.097246Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 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-25T15:05:27.463808Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 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-25T15:05:27.463808Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 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-25T14:29:28.038338Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 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-24T19:43:34.515012Z"} |
| 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-23T14:54:01.895756Z"} |
| 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-23T14:02:33.967509Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 228783210000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-22T19:49:40.866869Z"} |
| 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-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 |
| 225696522000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:27:55.894324Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:27:55.894324Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |