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 | expirydate |
|---|
| 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 |
|---|
| 52da95b8-9afc-442e-8627-4af977eb001f | 2026-09-11 11:49 | 2026-09-11 11:49 | 2026-09-11 11:49 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 33.1500 | 32.8500 | 33.2000 | 238.3200 | 62980.00 | 56350.00 | 6630.00 | 19 | 9 | 26 | 1607 | 0.0161792159303049 | 0.661240591930461 | 0.661240591930461 | true | 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-09-11T15:53:19.427541Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4d58d58e-56f7-4f53-839d-6012f356d599 | 2026-09-17 15:53 | 2026-09-17 15:52 | 2026-09-17 15:52 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 30.0100 | 30.0000 | 30.4500 | 241.0000 | 849260.00 | 153255.00 | 696005.00 | 283 | 34 | 337 | 1654 | 0.203748488512697 | 0.645134093576538 | 0.648034387870468 | false | false | false | true | ||||||||||||||||
| 61be5249-fae0-449e-a3b6-92a2c836ed9a | 2026-09-21 11:00 | 2026-09-21 11:00 | 2026-09-21 11:00 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 25.3000 | 25.0000 | 25.3000 | 252.3337 | 101200.00 | 101200.00 | 0.00 | 40 | 17 | 211 | 1786 | 0.118141097424412 | 0.675358976907938 | 0.675358976907938 | true | false | false | true | ||||||||||||||||
| 11ab0e99-0d6f-4228-8049-81f849a0e7e5 | 2026-09-22 09:33 | 2026-09-22 09:32 | 2026-09-22 09:32 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 22.0400 | 22.0000 | 23.1000 | 259.6400 | 33058.00 | 8825.00 | 24233.00 | 15 | 11 | 213 | 2204 | 0.0966424682395644 | 0.670850718619148 | 0.67289062618973 | true | false | false | true | ||||||||||||||||
| 432462b4-d1b8-4e64-b754-3cd00258da98 | 2026-09-22 10:33 | 2026-09-22 10:33 | 2026-09-22 10:33 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 20.6800 | 20.6500 | 21.1500 | 262.6850 | 20680.00 | 2080.00 | 18600.00 | 10 | 9 | 257 | 2204 | 0.116606170598911 | 0.666318939902288 | 0.670095075868017 | true | false | false | true | ||||||||||||||||
| d9134f9d-60a6-4141-af11-3e3bc2bd41f7 | 2026-09-22 10:59 | 2026-09-22 10:59 | 2026-09-22 10:59 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 20.8500 | 20.8000 | 21.1500 | 262.2700 | 85485.00 | 56295.00 | 29190.00 | 41 | 5 | 347 | 2204 | 0.157441016333938 | 0.66752184916203 | 0.66752184916203 | true | false | false | true | ||||||||||||||||
| e26af58a-4a0a-4a5d-95a2-429d9674ed68 | 2026-09-22 11:31 | 2026-09-22 11:31 | 2026-09-22 11:31 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 20.9500 | 20.9500 | 21.4500 | 261.0000 | 16760.00 | 0.00 | 16760.00 | 8 | 6 | 365 | 2204 | 0.165607985480944 | 0.666417787532978 | 0.666417787532978 | true | false | false | true | ||||||||||||||||
| da34848f-63e5-4172-a538-1631ad8745ab | 2026-09-22 11:31 | 2026-09-22 11:31 | 2026-09-22 11:31 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 20.9800 | 20.9000 | 21.1500 | 261.0000 | 14685.00 | 4205.00 | 6290.00 | 7 | 7 | 372 | 2204 | 0.168784029038113 | 0.666789951402736 | 0.6680477501848 | true | false | false | true | ||||||||||||||||
| 067ed221-90ac-4797-a630-20fc2f1f4e8f | 2026-09-22 11:31 | 2026-09-22 11:31 | 2026-09-22 11:31 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 20.9000 | 20.8500 | 21.1500 | 262.0000 | 10450.00 | 0.00 | 6270.00 | 5 | 5 | 377 | 2204 | 0.171052631578947 | 0.667389865678946 | 0.667389865678946 | true | false | false | true | ||||||||||||||||
| fd37652a-8308-4195-aa73-63832d53a261 | 2026-09-22 11:31 | 2026-09-22 11:31 | 2026-09-22 11:31 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 20.9000 | 20.9000 | 21.1500 | 262.0000 | 10450.00 | 0.00 | 10450.00 | 5 | 5 | 388 | 2204 | 0.176043557168784 | 0.666415141132343 | 0.666415141132343 | true | false | false | true | ||||||||||||||||
| 77a47f0c-6b06-42d0-adca-0d50e368df85 | 2026-09-22 11:31 | 2026-09-22 11:31 | 2026-09-22 11:31 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 20.9000 | 20.8500 | 21.1500 | 261.0000 | 60620.00 | 45990.00 | 14630.00 | 29 | 7 | 422 | 2204 | 0.191470054446461 | 0.666510846659267 | 0.665253020487776 | true | false | false | true | ||||||||||||||||
| c9c98bc7-88ad-4c26-9007-70b0344a8b1f | 2026-09-22 12:07 | 2026-09-22 12:07 | 2026-09-22 12:07 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 20.3000 | 20.1000 | 20.3000 | 263.5850 | 294350.00 | 263900.00 | 0.00 | 145 | 54 | 640 | 2204 | 0.29038112522686 | 0.665737039674123 | 0.665737039674123 | true | false | false | true | ||||||||||||||||
| 2bd6685f-6d1d-4012-91c4-9173e57f4560 | 2026-09-22 12:07 | 2026-09-22 12:07 | 2026-09-22 12:07 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 20.3000 | 20.1500 | 20.3000 | 263.6300 | 81200.00 | 81200.00 | 0.00 | 40 | 16 | 683 | 2204 | 0.30989110707804 | 0.666146136408168 | 0.666146136408168 | true | false | false | true | ||||||||||||||||
| 56aade59-1192-4bf7-9892-11794e8c4f3f | 2026-09-22 12:07 | 2026-09-22 12:07 | 2026-09-22 12:07 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 20.3000 | 20.1500 | 20.3000 | 263.6000 | 26390.00 | 26390.00 | 0.00 | 13 | 12 | 696 | 2204 | 0.315789473684211 | 0.665873431069385 | 0.665873431069385 | false | false | false | true | ||||||||||||||||
| a5d9b0ba-625b-453b-8c7d-ffa70bed3d4c | 2026-09-22 12:08 | 2026-09-22 12:08 | 2026-09-22 12:08 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 20.3000 | 20.1500 | 20.4000 | 263.4500 | 18270.00 | 18270.00 | 0.00 | 9 | 9 | 705 | 2204 | 0.319872958257713 | 0.666146136408168 | 0.664508352815243 | false | false | false | true | ||||||||||||||||
| e7a35862-38f6-40c5-8ffb-b35d57f3a084 | 2026-09-23 12:46 | 2026-09-23 12:46 | 2026-09-23 12:46 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 21.6500 | 21.6000 | 22.0000 | 258.1400 | 110415.00 | 21650.00 | 88765.00 | 51 | 20 | 81 | 2625 | 0.0308571428571429 | 0.652081233656132 | 0.653466635113126 | true | false | false | true | ||||||||||||||||
| b851a7eb-7550-478f-922b-b0161da7e925 | 2026-09-23 12:46 | 2026-09-23 12:46 | 2026-09-23 12:46 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 21.6500 | 21.5500 | 21.8500 | 258.1400 | 19485.00 | 8660.00 | 10825.00 | 9 | 5 | 91 | 2625 | 0.0346666666666667 | 0.653466635113126 | 0.653466635113126 | true | false | false | true | ||||||||||||||||
| 7a09343e-31dc-4f8d-b63a-33d3e11910c1 | 2026-09-24 10:41 | 2026-09-24 10:41 | 2026-09-24 10:41 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 22.7700 | 22.4500 | 22.8000 | 255.1200 | 40990.00 | 36450.00 | 4540.00 | 18 | 12 | 42 | 2618 | 0.0160427807486631 | 0.654893220622985 | 0.65744765827329 | true | false | false | true | ||||||||||||||||
| aa73329b-5946-455d-a041-0698d4b06397 | 2026-09-25 10:02 | 2026-09-25 10:02 | 2026-09-25 10:02 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 20.3900 | 19.8500 | 20.4000 | 260.0000 | 28550.00 | 26515.00 | 2035.00 | 14 | 5 | 103 | 2655 | 0.0387947269303201 | 0.656370108593979 | 0.65488545295102 | false | false | false | true | ||||||||||||||||
| da8bee0b-9efd-4f30-8d31-da69b295d609 | 2026-09-25 10:08 | 2026-09-25 10:08 | 2026-09-25 10:08 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 20.7500 | 20.2000 | 20.8500 | 260.0000 | 47720.00 | 43575.00 | 2070.00 | 23 | 10 | 129 | 2655 | 0.0485875706214689 | 0.660081039979927 | 0.658791456385536 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 211122444000.00 |
| 2026-12-01 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 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:02:30.535242Z"} |
| 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:33:30.058722Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-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 |
| 230063484000.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:00:53.883267Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:34:09.835499Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 230063484000.00 |
| 2026-12-01 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:34:09.835499Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:34:09.835499Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:34:09.835499Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:34:09.835499Z"} |
| 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-22T16:12:44.237245Z"} |
| 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-22T16:12:44.237245Z"} |
| 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-22T16:12:44.237245Z"} |
| 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-22T16:12:44.237245Z"} |
| 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-23T16:47:02.093743Z"} |
| 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-23T16:47:02.093743Z"} |
| 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-24T14:44:10.025245Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-25T14:02:31.622340Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:09:41.700516Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |