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 |
|---|
| 4002f9e9-59f3-45fd-9652-0aced923d25a | 2026-09-23 13:44 | 2026-09-23 13:44 | 2026-09-23 13:44 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 10.8000 | 10.5500 | 11.2500 | 43.0000 | 79920.00 | 20520.00 | 59400.00 | 74 | 17 | 190 | 2118 | 0.0897072710103872 | 0.618633773959735 | 0.618633773959735 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 19407921945.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T17:45:14.864344Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| fa49a93d-34ff-40e8-8481-e5a3ce1d0f32 | 2026-09-23 13:30 | 2026-09-23 13:30 | 2026-09-23 13:30 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 10.9000 | 10.8000 | 11.3500 | 43.0000 | 109000.00 | 27250.00 | 81750.00 | 100 | 6 | 115 | 2118 | 0.0542965061378659 | 0.62257418057865 | 0.62257418057865 | false | false | false | true | ||||||||||||||||
| d1e61944-af32-43d0-815a-263391edf026 | 2026-09-18 15:07 | 2026-09-18 15:07 | 2026-09-18 15:07 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 9.7000 | 9.5500 | 9.8000 | 40.8000 | 10665.00 | 1950.00 | 7740.00 | 11 | 9 | 132 | 1991 | 0.0662983425414365 | 0.635907268985589 | 0.630522851351475 | false | false | false | true | ||||||||||||||||
| b3469325-32af-4f97-8ff6-50e2bd679c72 | 2026-09-18 15:07 | 2026-09-18 15:07 | 2026-09-18 15:07 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 9.6500 | 9.6500 | 9.8500 | 40.8150 | 51145.00 | 0.00 | 51145.00 | 53 | 29 | 121 | 1991 | 0.0607734806629834 | 0.630063887440512 | 0.630063887440512 | false | false | false | true | ||||||||||||||||
| ec5320ca-e471-48ab-b676-d0d28120343c | 2026-09-18 15:07 | 2026-09-18 15:06 | 2026-09-18 15:06 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 9.7100 | 9.6000 | 10.1000 | 40.8150 | 55365.00 | 0.00 | 55365.00 | 57 | 43 | 68 | 1991 | 0.0341536916122551 | 0.632294815317728 | 0.627374288681811 | false | false | false | true | ||||||||||||||||
| b678230a-8daf-42c2-a0ef-fe6a36a20c01 | 2026-09-09 10:26 | 2026-09-09 10:25 | 2026-09-09 10:25 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 11.3000 | 11.0500 | 11.3500 | 42.0000 | 14690.00 | 11300.00 | 2260.00 | 13 | 5 | 128 | 2146 | 0.059645852749301 | 0.650257688647073 | 0.650257688647073 | false | false | false | true | ||||||||||||||||
| ba13c7c4-3076-4586-8f90-f8777de0f76e | 2026-08-27 12:35 | 2026-08-27 12:35 | 2026-08-27 12:35 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 11.6000 | 11.5500 | 12.0000 | 43.5310 | 12760.00 | 4640.00 | 8120.00 | 11 | 9 | 286 | 2039 | 0.140264835703776 | 0.637372950373087 | 0.637372950373087 | true | false | false | true | ||||||||||||||||
| e7b30cad-1d1d-4e0f-a90f-d94fe962ce32 | 2026-08-27 12:07 | 2026-08-27 12:06 | 2026-08-27 12:06 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 11.8500 | 11.8500 | 12.1000 | 43.9200 | 20145.00 | 0.00 | 20145.00 | 17 | 6 | 271 | 2039 | 0.132908288376655 | 0.638022970323947 | 0.638022970323947 | false | false | false | true | ||||||||||||||||
| 58511377-8e8f-4b06-929e-e8508d3bda1b | 2026-08-27 11:55 | 2026-08-27 11:55 | 2026-08-27 11:55 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 12.0500 | 11.7000 | 12.0500 | 44.0400 | 24100.00 | 24100.00 | 0.00 | 20 | 10 | 163 | 2039 | 0.079941147621383 | 0.644363172689616 | 0.644363172689616 | false | false | false | true | ||||||||||||||||
| 00457da7-9ebc-4788-a9d3-1928bd98bd9e | 2026-08-27 10:19 | 2026-08-27 10:19 | 2026-08-27 10:19 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 11.9000 | 11.9000 | 12.0500 | 43.6900 | 29750.00 | 0.00 | 29750.00 | 25 | 10 | 100 | 2039 | 0.0490436488474743 | 0.647617312071135 | 0.647617312071135 | false | false | false | true | ||||||||||||||||
| 7bbf40cd-158a-403e-bb65-e8d68bf3198f | 2026-08-27 10:19 | 2026-08-27 10:19 | 2026-08-27 10:19 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 11.9500 | 11.9500 | 12.3000 | 43.7300 | 14340.00 | 0.00 | 14340.00 | 12 | 12 | 43 | 2039 | 0.0210887690044139 | 0.648903701441719 | 0.648903701441719 | false | false | false | true | ||||||||||||||||
| 343de9f7-ee71-4cdd-8571-6e4bf1cbacfe | 2026-08-26 13:03 | 2026-08-26 13:03 | 2026-08-26 13:03 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 12.2000 | 12.2000 | 12.3000 | 44.1400 | 10980.00 | 0.00 | 10980.00 | 9 | 8 | 513 | 1873 | 0.273892151628404 | 0.646742635128362 | 0.648287713465003 | false | false | false | true | ||||||||||||||||
| be0a064a-5df4-4905-92b7-6af205e06776 | 2026-08-26 12:51 | 2026-08-26 12:51 | 2026-08-26 12:51 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 12.2000 | 12.2000 | 12.5000 | 44.1500 | 14640.00 | 0.00 | 14640.00 | 12 | 9 | 62 | 1873 | 0.0331019754404698 | 0.647978598038558 | 0.647978598038558 | false | false | false | true | ||||||||||||||||
| a0f47849-fa46-4095-8ac8-7d72b9dbb87f | 2026-08-26 12:23 | 2026-08-26 12:23 | 2026-08-26 12:23 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 12.3000 | 12.2500 | 12.9000 | 44.2050 | 43050.00 | 13530.00 | 2460.00 | 35 | 5 | 45 | 1873 | 0.0240256273358249 | 0.651283501100898 | 0.651283501100898 | true | false | false | true | ||||||||||||||||
| ed6632b2-b9c2-4c05-9560-58cd3749946a | 2026-08-21 09:46 | 2026-08-21 09:46 | 2026-08-21 09:46 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 13.7000 | 13.7000 | 14.4000 | 46.1300 | 13700.00 | 0.00 | 13700.00 | 10 | 5 | 40 | 1845 | 0.021680216802168 | 0.656643300904779 | 0.656643300904779 | false | false | false | true | ||||||||||||||||
| 1924bd33-e9f7-46ee-8aaa-9aca5bcc70cf | 2026-08-21 09:45 | 2026-08-21 09:45 | 2026-08-21 09:45 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 13.6500 | 13.6000 | 14.4000 | 46.2900 | 32762.00 | 16380.00 | 15017.00 | 24 | 9 | 24 | 1845 | 0.0130081300813008 | 0.650148022394375 | 0.649212381645287 | true | false | false | true | ||||||||||||||||
| 2afc0e5d-a3c5-46ec-8fe8-2e990d315a46 | 2026-08-18 13:27 | 2026-08-18 13:26 | 2026-08-18 13:26 | U | U280121C00050000 | call | 50.0000 | 2028-01-21 | 14.5000 | 13.9500 | 14.5000 | 46.9950 | 11600.00 | 11600.00 | 0.00 | 8 | 8 | 10 | 1825 | 0.00547945205479452 | 0.666082907447167 | 0.666082907447167 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19407921945.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:31:46.460740Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 18219681826.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 18219681826.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 18219681826.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19121864139.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:40:24.011597Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19121864139.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:57:23.365599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19121864139.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:07:33.804891Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19121864139.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:07:33.804891Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19121864139.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19121864139.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19121864139.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T17:27:57.423992Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19121864139.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:52:20.196728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19121864139.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:52:20.196728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19121864139.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:52:23.943774Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19121864139.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:52:23.943774Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 19121864139.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |