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_alerts566,287 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 |
|---|
| de3a026a-a6c5-4823-a442-3695107b7eed | 2026-09-21 10:15 | 2026-09-21 10:15 | 2026-09-21 10:15 | MRVL | MRVL261016C00262500 | call | 262.5000 | 2026-10-16 | 13.5800 | 13.3000 | 13.6500 | 251.0000 | 10860.00 | 10860.00 | 0.00 | 8 | 7 | 18 | 0 | 0 | 0.690535325725523 | 0.68993888323315 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 225696522000.00 | 2026-12-01 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:16:37.999315Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 873b76d7-4552-4b48-9054-7fbcc68c1699 | 2026-09-21 11:57 | 2026-09-21 11:57 | 2026-09-21 11:57 | MRVL | MRVL261016C00262500 | call | 262.5000 | 2026-10-16 | 15.2500 | 15.2500 | 15.8000 | 253.6800 | 19825.00 | 0.00 | 19825.00 | 13 | 5 | 69 | 0 | 0 | 0.708235172149064 | 0.708235172149064 | false | false | false | true | ||||||||||||||||
| 2d0443b2-6e59-4565-a05b-156319083fcb | 2026-09-21 12:01 | 2026-09-21 12:01 | 2026-09-21 12:01 | MRVL | MRVL261016C00262500 | call | 262.5000 | 2026-10-16 | 15.2000 | 15.1500 | 15.6500 | 253.8000 | 19760.00 | 1520.00 | 18240.00 | 13 | 5 | 82 | 0 | 0 | 0.7042094069452 | 0.7042094069452 | false | false | false | true | ||||||||||||||||
| b9d6df91-055a-472b-9e78-7c8b99aa3b10 | 2026-09-21 12:18 | 2026-09-21 12:18 | 2026-09-21 12:18 | MRVL | MRVL261016C00262500 | call | 262.5000 | 2026-10-16 | 15.4500 | 15.4500 | 15.9500 | 254.0000 | 30900.00 | 0.00 | 30900.00 | 20 | 13 | 103 | 0 | 0 | 0.697752279706817 | 0.699546228619332 | false | false | false | true | ||||||||||||||||
| 638674af-0dcf-4b6e-9d72-54017c172153 | 2026-09-21 15:29 | 2026-09-21 15:29 | 2026-09-21 15:29 | MRVL | MRVL261016C00262500 | call | 262.5000 | 2026-10-16 | 18.0500 | 18.0500 | 18.1500 | 259.2950 | 37905.00 | 0.00 | 37905.00 | 21 | 9 | 162 | 0 | 0 | 0.709428661819217 | 0.709428661819217 | true | false | false | true | ||||||||||||||||
| 1dc082c2-f457-46ae-a9c1-a942c4d7efdc | 2026-09-23 09:59 | 2026-09-23 09:59 | 2026-09-23 09:59 | MRVL | MRVL261016C00262500 | call | 262.5000 | 2026-10-16 | 17.6500 | 17.6500 | 18.1500 | 261.5700 | 19415.00 | 0.00 | 19415.00 | 11 | 6 | 31 | 148 | 0.209459459459459 | 0.67948431344942 | 0.67948431344942 | true | false | false | true | ||||||||||||||||
| a9e0ceb8-1295-472c-895b-6f7ac4414a22 | 2026-09-23 10:27 | 2026-09-23 10:27 | 2026-09-23 10:27 | MRVL | MRVL261016C00262500 | call | 262.5000 | 2026-10-16 | 15.6000 | 15.1500 | 15.7000 | 257.7450 | 238680.00 | 115440.00 | 123240.00 | 153 | 13 | 193 | 148 | 1.30405405405405 | 0.676288224051835 | 0.676288224051835 | false | false | false | true | ||||||||||||||||
| e68897b9-e029-49cc-8c49-24bb7787aa80 | 2026-09-23 10:58 | 2026-09-23 10:58 | 2026-09-23 10:58 | MRVL | MRVL261016C00262500 | call | 262.5000 | 2026-10-16 | 16.7000 | 16.6500 | 17.1000 | 260.0000 | 11690.00 | 1670.00 | 10020.00 | 7 | 7 | 253 | 148 | 1.70945945945946 | 0.670218510299188 | 0.670218510299188 | true | false | false | true | ||||||||||||||||
| 4d1d652b-f959-40e1-83f0-a81b9ecd4e44 | 2026-09-23 15:10 | 2026-09-23 15:10 | 2026-09-23 15:10 | MRVL | MRVL261016C00262500 | call | 262.5000 | 2026-10-16 | 16.2500 | 16.0500 | 16.4500 | 259.0050 | 97500.00 | 73125.00 | 24375.00 | 60 | 19 | 347 | 148 | 2.34459459459459 | 0.676937094406546 | 0.676937094406546 | true | false | false | true | ||||||||||||||||
| 64f473e3-2963-49d8-917e-085c46b0fe09 | 2026-09-24 09:33 | 2026-09-24 09:33 | 2026-09-24 09:33 | MRVL | MRVL261016C00262500 | call | 262.5000 | 2026-10-16 | 13.0000 | 12.6500 | 13.5500 | 253.0000 | 10400.00 | 1300.00 | 9100.00 | 8 | 8 | 9 | 409 | 0.0220048899755501 | 0.677824394306402 | 0.677824394306402 | true | false | false | true | ||||||||||||||||
| a93f6fe7-c17c-4907-8d02-605d4180c7fa | 2026-09-29 09:48 | 2026-09-29 09:48 | 2026-09-29 09:48 | MRVL | MRVL261016C00262500 | call | 262.5000 | 2026-10-16 | 16.0500 | 16.0000 | 16.5500 | 261.7501 | 109170.00 | 12870.00 | 91485.00 | 68 | 20 | 75 | 489 | 0.153374233128834 | 0.718238964835565 | 0.718238964835565 | true | false | false | true | ||||||||||||||||
| 7f50a32f-66b4-451e-9ec1-138e8077db4d | 2026-09-29 09:57 | 2026-09-29 09:57 | 2026-09-29 09:57 | MRVL | MRVL261016C00262500 | call | 262.5000 | 2026-10-16 | 16.3100 | 16.2500 | 16.7500 | 262.0000 | 35875.00 | 3265.00 | 32610.00 | 22 | 10 | 100 | 489 | 0.204498977505112 | 0.707763326142182 | 0.705364034725 | true | false | false | true | ||||||||||||||||
| 08cd94f0-44c1-4431-84ae-7a5252912f5a | 2026-09-29 13:28 | 2026-09-29 13:28 | 2026-09-29 13:28 | MRVL | MRVL261016C00262500 | call | 262.5000 | 2026-10-16 | 16.0400 | 15.9500 | 16.3000 | 262.8700 | 27270.00 | 0.00 | 27270.00 | 17 | 6 | 342 | 489 | 0.699386503067485 | 0.691696191128507 | 0.689476630576298 | false | false | false | true | ||||||||||||||||
| 39943266-30b5-4544-ba97-4b01004e4c5b | 2026-09-29 15:57 | 2026-09-29 15:57 | 2026-09-29 15:57 | MRVL | MRVL261016C00262500 | call | 262.5000 | 2026-10-16 | 15.8500 | 15.5500 | 15.9500 | 262.0000 | 23775.00 | 11095.00 | 12680.00 | 15 | 5 | 402 | 489 | 0.822085889570552 | 0.688065085064157 | 0.688065085064157 | true | false | false | true |
| 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-21T16:00:04.115943Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T16:04:05.802260Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 225696522000.00 |
| 2026-12-01 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:21:14.001426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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:00:44.029710Z"} |
| 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-23T14:29:05.852425Z"} |
| 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-23T15:00:57.901243Z"} |
| 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-23T19:12:23.721983Z"} |
| 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-24T13:34:09.637313Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:48:49.550855Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-29T13:59:42.347553Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| 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-29T17:35:56.522795Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |