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 | expirydate |
|---|
| 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 |
|---|
| 82dfbda2-4b91-44c3-86a3-e1a9b04cc633 | 2026-09-30 15:26 | 2026-09-30 15:26 | 2026-09-30 15:26 | OLED | OLED261016C00080000 | call | 80.0000 | 2026-10-16 | 1.8000 | 1.4000 | 1.9500 | 76.4600 | 44278.00 | 41938.00 | 2340.00 | 246 | 31 | 249 | 2367 | 0.105196451204056 | 0.49318475801958 | 0.49318475801958 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 3500834154.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T19:31:21.867797Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| 2f88f562-e93e-46ae-88ee-ebf61c876aab | 2026-09-14 15:32 | 2026-09-14 15:32 | 2026-09-14 15:32 | OLED | OLED261016C00080000 | call | 80.0000 | 2026-10-16 | 3.5000 | 3.2000 | 3.6000 | 77.0400 | 19600.00 | 9450.00 | 700.00 | 56 | 5 | 2050 | 614 | 3.33876221498371 | 0.510118040850431 | 0.510118040850431 | false | false | false | true | false | |||||||||||||||
| 96dd605a-8db5-4325-8ff2-5d7f19245b51 | 2026-09-14 15:01 | 2026-09-14 15:00 | 2026-09-14 15:00 | OLED | OLED261016C00080000 | call | 80.0000 | 2026-10-16 | 3.4300 | 3.0000 | 3.5000 | 76.9093 | 38472.00 | 38472.00 | 0.00 | 112 | 14 | 1708 | 614 | 2.78175895765472 | 0.506164171868004 | 0.516499517046649 | false | false | false | true | false | |||||||||||||||
| 0a36ce0d-8e79-4f01-8cd7-8f3f23ed28db | 2026-09-14 15:00 | 2026-09-14 15:00 | 2026-09-14 15:00 | OLED | OLED261016C00080000 | call | 80.0000 | 2026-10-16 | 3.3000 | 3.3000 | 3.5000 | 76.7400 | 36960.00 | 0.00 | 36960.00 | 112 | 15 | 1474 | 614 | 2.40065146579805 | 0.502329627242974 | 0.502329627242974 | false | false | false | true | false | |||||||||||||||
| dec91d24-2619-4859-900d-3de0b2766833 | 2026-09-14 15:00 | 2026-09-14 15:00 | 2026-09-14 15:00 | OLED | OLED261016C00080000 | call | 80.0000 | 2026-10-16 | 3.2000 | 3.2000 | 3.3000 | 76.6675 | 34240.00 | 0.00 | 23360.00 | 107 | 12 | 1362 | 614 | 2.21824104234528 | 0.494564361484605 | 0.494564361484605 | false | false | false | true | false | |||||||||||||||
| b85c1369-7527-4b46-8238-281ebdfb0a40 | 2026-09-14 14:14 | 2026-09-14 14:14 | 2026-09-14 14:14 | OLED | OLED261016C00080000 | call | 80.0000 | 2026-10-16 | 3.1800 | 2.7500 | 3.2000 | 76.3200 | 17190.00 | 15020.00 | 2170.00 | 54 | 20 | 1120 | 614 | 1.82410423452769 | 0.511040022444361 | 0.499685418348432 | false | false | false | true | false | |||||||||||||||
| adcd4b63-275b-4fe5-87d4-789d78721f15 | 2026-09-14 12:40 | 2026-09-14 12:40 | 2026-09-14 12:40 | OLED | OLED261016C00080000 | call | 80.0000 | 2026-10-16 | 4.2000 | 3.8000 | 4.2000 | 78.4950 | 17640.00 | 17640.00 | 0.00 | 42 | 14 | 951 | 614 | 1.54885993485342 | 0.512679638402738 | 0.512679638402738 | false | false | false | true | false | |||||||||||||||
| aa907d16-2fa6-45bc-8198-fceae83b20f0 | 2026-09-14 12:22 | 2026-09-14 12:21 | 2026-09-14 12:21 | OLED | OLED261016C00080000 | call | 80.0000 | 2026-10-16 | 4.0000 | 3.1000 | 4.2000 | 78.3750 | 65600.00 | 48400.00 | 16400.00 | 164 | 10 | 604 | 614 | 0.98371335504886 | 0.49738652829433 | 0.49738652829433 | false | false | false | true | false | |||||||||||||||
| 60000da0-e307-4827-87a3-fee733e20f95 | 2026-09-14 12:21 | 2026-09-14 12:21 | 2026-09-14 12:21 | OLED | OLED261016C00080000 | call | 80.0000 | 2026-10-16 | 3.8000 | 3.2000 | 4.0000 | 77.7850 | 166058.00 | 148958.00 | 5700.00 | 437 | 43 | 440 | 614 | 0.716612377850163 | 0.506040916518647 | 0.506040916518647 | false | false | false | true | ||||||||||||||||
| 19640bfa-7cfe-4c01-ae51-afa7a984468c | 2026-09-10 11:35 | 2026-09-10 11:35 | 2026-09-10 11:35 | OLED | OLED261016C00080000 | call | 80.0000 | 2026-10-16 | 4.9000 | 4.4000 | 5.1000 | 79.7200 | 61739.00 | 42139.00 | 19600.00 | 126 | 22 | 654 | 48 | 13.625 | 0.489679378714633 | 0.489679378714633 | false | false | false | true | false | |||||||||||||||
| 5bdaa1ee-bb83-48e9-9935-e8835d893c08 | 2026-09-10 11:35 | 2026-09-10 11:35 | 2026-09-10 11:35 | OLED | OLED261016C00080000 | call | 80.0000 | 2026-10-16 | 4.9000 | 4.4000 | 4.9000 | 79.7400 | 21070.00 | 21070.00 | 0.00 | 43 | 15 | 528 | 48 | 11 | 0.488611036594282 | 0.488611036594282 | false | false | false | true | false | |||||||||||||||
| 3640627b-2b15-40a3-a3a6-6281dc46eb5a | 2026-09-10 11:34 | 2026-09-10 11:34 | 2026-09-10 11:34 | OLED | OLED261016C00080000 | call | 80.0000 | 2026-10-16 | 4.7000 | 4.4000 | 5.2000 | 79.2350 | 185978.00 | 185508.00 | 470.00 | 396 | 25 | 458 | 48 | 9.54166666666667 | 0.499020988121393 | 0.495123406839021 | true | false | false | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T18:18:53.599003Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:49:37.903150Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:23:59.234542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:23:59.234542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T15:47:40.219521Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T15:47:40.219521Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3521978898.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T15:47:40.219521Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |