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_alerts523,327 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 |
|---|
| 24f51a47-4b42-4ac5-8cde-7b67749a3104 | 2026-08-19 11:35 | 2026-08-19 11:35 | 2026-08-19 11:35 | MRVL | MRVL261120C00240000 | call | 240.0000 | 2026-11-20 | 34.5400 | 33.4500 | 34.6500 | 233.4799 | 69085.00 | 38010.00 | 31075.00 | 20 | 7 | 206 | 1193 | 0.172673931265717 | 0.776360002193256 | 0.777435649860053 | false | false | false | true | false | 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-19T15:49:41.153087Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fadc2838-016e-443d-9795-ce9c4d40caf1 | 2026-08-28 11:35 | 2026-08-28 11:34 | 2026-08-28 11:34 | MRVL | MRVL261120C00240000 | call | 240.0000 | 2026-11-20 | 21.4500 | 20.8000 | 21.4500 | 222.0700 | 100815.00 | 100815.00 | 0.00 | 47 | 12 | 454 | 1270 | 0.35748031496063 | 0.65425560826311 | 0.65425560826311 | false | false | false | true | ||||||||||||||||
| dd14f6a7-c051-4677-a157-d0197361b9a0 | 2026-08-28 12:35 | 2026-08-28 12:35 | 2026-08-28 12:35 | MRVL | MRVL261120C00240000 | call | 240.0000 | 2026-11-20 | 18.9500 | 18.5500 | 19.3000 | 216.6800 | 81485.00 | 64430.00 | 17055.00 | 43 | 8 | 684 | 1270 | 0.538582677165354 | 0.653710986665198 | 0.653710986665198 | true | false | false | |||||||||||||||||
| e1c0f69d-2a44-4edb-8431-d1b7700c3ddb | 2026-09-04 09:50 | 2026-09-04 09:50 | 2026-09-04 09:50 | MRVL | MRVL261120C00240000 | call | 240.0000 | 2026-11-20 | 15.9300 | 15.4000 | 16.5000 | 216.2000 | 434940.00 | 17566.00 | 414184.00 | 273 | 9 | 324 | 1733 | 0.186959030582804 | 0.613072692909273 | 0.613072692909273 | false | false | false | |||||||||||||||||
| 1e7ddec9-d3e1-4ce9-b05d-8b804c2e7f45 | 2026-09-04 12:51 | 2026-09-04 12:51 | 2026-09-04 12:51 | MRVL | MRVL261120C00240000 | call | 240.0000 | 2026-11-20 | 19.0000 | 18.8500 | 19.0000 | 221.5350 | 127300.00 | 127300.00 | 0.00 | 67 | 11 | 693 | 1733 | 0.399884593190998 | 0.630325466665545 | 0.630325466665545 | false | false | false | |||||||||||||||||
| 682caac7-0929-4d04-94b8-e0caba457d01 | 2026-09-10 09:48 | 2026-09-10 09:48 | 2026-09-10 09:48 | MRVL | MRVL261120C00240000 | call | 240.0000 | 2026-11-20 | 23.6500 | 23.0000 | 24.3000 | 230.3000 | 54395.00 | 2365.00 | 52030.00 | 23 | 9 | 30 | 1659 | 0.0180831826401447 | 0.667348523954837 | 0.667348523954837 | false | false | false | |||||||||||||||||
| 72f1539e-eecb-467a-9e1a-8e7eb74ae10a | 2026-09-18 10:01 | 2026-09-18 10:01 | 2026-09-18 10:01 | MRVL | MRVL261120C00240000 | call | 240.0000 | 2026-11-20 | 26.9500 | 26.4000 | 27.1000 | 241.0000 | 78155.00 | 75460.00 | 2695.00 | 29 | 16 | 48 | 1818 | 0.0264026402640264 | 0.647752175906831 | 0.645869249252165 | true | false | false | |||||||||||||||||
| 679ea11b-f072-452c-b930-174041c6f0c9 | 2026-09-21 10:38 | 2026-09-21 10:38 | 2026-09-21 10:38 | MRVL | MRVL261120C00240000 | call | 240.0000 | 2026-11-20 | 33.2500 | 33.2250 | 33.7500 | 251.2900 | 53200.00 | 0.00 | 53200.00 | 16 | 5 | 113 | 1835 | 0.0615803814713896 | 0.666196631498778 | 0.666196631498778 | false | false | false | true | ||||||||||||||||
| 1b6cc884-8e77-4484-b4ac-fe4ab686f730 | 2026-09-24 09:32 | 2026-09-24 09:32 | 2026-09-24 09:32 | MRVL | MRVL261120C00240000 | call | 240.0000 | 2026-11-20 | 33.8600 | 32.5000 | 34.8000 | 254.0000 | 54170.00 | 10165.00 | 44005.00 | 16 | 10 | 16 | 1860 | 0.00860215053763441 | 0.654544891919296 | 0.654544891919296 | true | false | false | |||||||||||||||||
| 9036a8cf-1317-4b74-829c-04ea977c4661 | 2026-09-24 09:33 | 2026-09-24 09:32 | 2026-09-24 09:32 | MRVL | MRVL261120C00240000 | call | 240.0000 | 2026-11-20 | 33.8100 | 32.4000 | 34.2500 | 253.6501 | 111580.00 | 54025.00 | 57555.00 | 33 | 7 | 49 | 1860 | 0.0263440860215054 | 0.659240947473126 | 0.657903349020174 | true | false | false | |||||||||||||||||
| 91f3d60e-1a45-4e03-b8c9-b7374e8e03a8 | 2026-09-25 11:04 | 2026-09-25 11:04 | 2026-09-25 11:04 | MRVL | MRVL261120C00240000 | call | 240.0000 | 2026-11-20 | 39.0000 | 38.5000 | 39.0000 | 262.5000 | 39000.00 | 39000.00 | 0.00 | 10 | 6 | 46 | 1884 | 0.024416135881104 | 0.645493423433348 | 0.645493423433348 | false | false | false | true | ||||||||||||||||
| 9a4003d5-8edb-420b-aa57-fa16d4e36a70 | 2026-09-25 15:51 | 2026-09-25 15:51 | 2026-09-25 15:51 | MRVL | MRVL261120C00240000 | call | 240.0000 | 2026-11-20 | 39.5000 | 39.3500 | 39.5000 | 263.0900 | 47400.00 | 47400.00 | 0.00 | 12 | 5 | 108 | 1884 | 0.0573248407643312 | 0.647987808060742 | 0.647987808060742 | false | false | false |
| false |
| 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-28T15:36:02.227679Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-28T16:48:38.038469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 191883258000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:56:18.493427Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-04T17:07:55.847311Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-10T13:52:43.061304Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-18T14:08:58.692787Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| 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-21T14:39:35.705687Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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-24T13:34:09.637313Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| 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-24T13:34:09.637313Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| 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 |
| false |
| 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-25T19:54:56.567521Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |