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_alerts658,639 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 |
|---|
| 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 |
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| c1b66e2c-2114-411a-a7f2-cd0f64b26dd4 | 2026-09-29 09:52 | 2026-09-29 09:52 | 2026-09-29 09:52 | MRVL | MRVL261120P00250000 | put | 250.0000 | 2026-11-20 | 19.2000 | 18.9000 | 19.6500 | 261.8000 | 19200.00 | 9600.00 | 1920.00 | 10 | 5 | 36 | 2952 | 0.0121951219512195 | 0.660136445496712 | 0.660136445496712 | false | false | false |
| 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:02:30.535242Z"} |
| 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-22T15:00:53.883267Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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 |
| false |
| 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 |
| false |
| 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 |
| 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-22T16:12:44.237245Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T16:12:44.237245Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T16:12:44.237245Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T16:12:44.237245Z"} |
| 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-23T16:47:02.093743Z"} |
| 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:47:02.093743Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-25T14:09:41.700516Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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:54:00.139875Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |