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_alerts474,253 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 |
|---|
| e045e1f8-b0d8-460f-ba2a-9ed4fd2f932c | 2026-08-17 10:44 | 2026-08-17 10:44 | 2026-08-17 10:44 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 26.1400 | 25.7500 | 26.2000 | 235.8000 | 67975.00 | 67975.00 | 0.00 | 26 | 7 | 35 | 822 | 0.0425790754257908 | 0.78646877149127 | 0.786277773800247 | true | false | false | true | 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-08-17T14:59:17.821734Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bba104e2-64af-4d8c-8e82-286a59860faa | 2026-09-17 09:49 | 2026-09-17 09:49 | 2026-09-17 09:49 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 18.8000 | 18.7000 | 19.2000 | 245.6500 | 60171.00 | 0.00 | 56421.00 | 32 | 6 | 139 | 1589 | 0.0874764002517306 | 0.670495752723969 | 0.668270226701259 | false | false | false | true | ||||||||||||||||
| 2fd39fad-7988-4ff1-aa1f-b38193620cc1 | 2026-09-18 10:01 | 2026-09-18 10:01 | 2026-09-18 10:01 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 16.0400 | 15.6000 | 16.0500 | 241.0000 | 65778.00 | 62588.00 | 3190.00 | 41 | 16 | 42 | 1815 | 0.0231404958677686 | 0.655729251302372 | 0.65438743274666 | true | false | false | |||||||||||||||||
| 699c7e99-471d-4e46-a61a-1e21e7d9d37b | 2026-09-21 10:56 | 2026-09-21 10:56 | 2026-09-21 10:56 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 20.9500 | 20.5500 | 21.0000 | 251.6950 | 10475.00 | 10475.00 | 0.00 | 5 | 5 | 247 | 2024 | 0.12203557312253 | 0.678735215233318 | 0.678735215233318 | false | false | false | true | ||||||||||||||||
| fb3a5106-5041-4394-a326-bbda24daddfb | 2026-09-21 11:29 | 2026-09-21 11:29 | 2026-09-21 11:29 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 22.9500 | 22.5500 | 22.9500 | 255.1400 | 16065.00 | 16065.00 | 0.00 | 7 | 7 | 351 | 2024 | 0.173418972332016 | 0.687738875763497 | 0.687738875763497 | false | false | false | true | ||||||||||||||||
| 638c9f2a-25db-4659-9104-bb06ed8aecfd | 2026-09-21 15:30 | 2026-09-21 15:30 | 2026-09-21 15:30 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 25.1600 | 25.1500 | 25.6500 | 259.2100 | 171057.00 | 0.00 | 171057.00 | 68 | 17 | 740 | 2024 | 0.365612648221344 | 0.692100017918574 | 0.692100017918574 | false | false | false | |||||||||||||||||
| 9f87cbfb-aa11-4e6e-a196-ff3a86efae01 | 2026-09-22 14:23 | 2026-09-22 14:23 | 2026-09-22 14:23 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 26.6000 | 26.2000 | 26.7500 | 263.7350 | 53200.00 | 39900.00 | 7980.00 | 20 | 18 | 388 | 2066 | 0.187802516940949 | 0.677908323207818 | 0.676841537355271 | false | false | false | |||||||||||||||||
| 2ec90754-d618-4b03-b8b9-dc8a846d314e | 2026-09-23 09:42 | 2026-09-23 09:42 | 2026-09-23 09:42 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 26.3000 | 25.8000 | 26.3000 | 263.2900 | 18410.00 | 18410.00 | 0.00 | 7 | 6 | 53 | 2185 | 0.0242562929061785 | 0.681442909783229 | 0.681442909783229 | false | false | false | true | ||||||||||||||||
| 6bca55d1-b665-47bf-8a47-50940f0cc66f | 2026-09-23 10:34 | 2026-09-23 10:34 | 2026-09-23 10:34 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 22.8000 | 22.3500 | 22.8000 | 258.0000 | 11400.00 | 11400.00 | 0.00 | 5 | 5 | 92 | 2185 | 0.0421052631578947 | 0.662138785373049 | 0.662138785373049 | false | false | false | true | ||||||||||||||||
| 399b8f61-44aa-465a-9bb7-e4826d66724c | 2026-09-23 12:09 | 2026-09-23 12:09 | 2026-09-23 12:09 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 23.5500 | 23.1500 | 23.6000 | 259.1350 | 58875.00 | 23550.00 | 35325.00 | 25 | 6 | 190 | 2185 | 0.0869565217391304 | 0.666647777160614 | 0.666647777160614 | false | false | false | |||||||||||||||||
| 3ce7c85f-bfe9-49cb-a74b-94c7cc6e5fc0 | 2026-09-24 09:32 | 2026-09-24 09:32 | 2026-09-24 09:32 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 20.6300 | 19.9500 | 21.4500 | 253.6501 | 20625.00 | 2080.00 | 18545.00 | 10 | 6 | 19 | 2222 | 0.00855085508550855 | 0.664197414813906 | 0.670469609421133 | true | false | false | |||||||||||||||||
| 5fd3e064-0283-4e46-8f74-5bbd0bd52cb3 | 2026-09-24 09:33 | 2026-09-24 09:32 | 2026-09-24 09:32 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 20.5100 | 20.2000 | 20.9000 | 253.3000 | 45121.00 | 6150.00 | 38971.00 | 22 | 19 | 41 | 2222 | 0.0184518451845185 | 0.669053389439972 | 0.664529083271859 | true | false | false | |||||||||||||||||
| 751d1190-8e96-4bd2-84bf-4fbc79d2c912 | 2026-09-24 09:39 | 2026-09-24 09:39 | 2026-09-24 09:39 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 23.1000 | 22.3500 | 23.1500 | 258.1200 | 55435.00 | 53130.00 | 2305.00 | 24 | 6 | 67 | 2222 | 0.0301530153015302 | 0.674085696312263 | 0.674085696312263 | false | false | false | |||||||||||||||||
| a568ec58-020f-45b9-b280-18c453976872 | 2026-09-24 10:39 | 2026-09-24 10:39 | 2026-09-24 10:39 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 21.1700 | 20.8500 | 21.6000 | 255.2100 | 10585.00 | 8460.00 | 2125.00 | 5 | 5 | 127 | 2222 | 0.0571557155715572 | 0.662173167411557 | 0.663300816553291 | true | false | false | |||||||||||||||||
| 187dff61-2426-414d-9611-52a7180940d2 | 2026-09-24 13:38 | 2026-09-24 13:37 | 2026-09-24 13:37 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 23.0000 | 23.0000 | 23.1000 | 258.8100 | 96600.00 | 0.00 | 96600.00 | 42 | 6 | 237 | 2222 | 0.106660666066607 | 0.663224359607524 | 0.663224359607524 | true | false | false | true | ||||||||||||||||
| a7c8fbd7-c41a-49f6-80cb-1f8f9ccf69ea | 2026-09-25 12:34 | 2026-09-25 12:34 | 2026-09-25 12:34 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 26.7000 | 26.6500 | 27.0000 | 266.9750 | 13350.00 | 5345.00 | 8005.00 | 5 | 5 | 180 | 2227 | 0.0808262236192187 | 0.655898751535965 | 0.65566331152907 | false | false | false | |||||||||||||||||
| dbe6f35f-506e-4f2b-bdc3-5ab7e576a284 | 2026-09-25 15:06 | 2026-09-25 15:06 | 2026-09-25 15:06 | MRVL | MRVL261120C00270000 | call | 270.0000 | 2026-11-20 | 25.1500 | 24.9000 | 25.4000 | 264.0000 | 95570.00 | 0.00 | 93055.00 | 38 | 6 | 311 | 2227 | 0.139649753030983 | 0.653312072381621 | 0.653312072381621 | false | false | false | true |
| false |
| 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-17T13:57:31.198579Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| 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-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:59:04.068372Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T15:32:21.239106Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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:29:55.439380Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-23T14:35:38.031989Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-23T16:13:15.432740Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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 |
| 228783210000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:40:59.800251Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T14:39:59.397883Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T17:43:31.900788Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:34:19.672703Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:10:45.993353Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |