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_alerts281,039 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 |
|---|
| e1f6c6f1-b32d-42f7-85af-8740b5aa7871 | 2026-09-18 15:46 | 2026-09-18 15:46 | 2026-09-18 15:46 | DAL | DAL260918P00085000 | put | 85.0000 | 2026-09-18 | 5.1000 | 5.0000 | 5.1000 | 79.9200 | 257550.00 | 248880.00 | 0.00 | 505 | 10 | 1369 | 2869 | 0.477169745555943 | 5.62412800600596 | 6.001774180982 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 52359945649.00 | 2026-10-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 9320cd7e-2329-4230-be5d-23e7890de86f | 2026-09-21 10:06 | 2026-09-21 10:06 | 2026-09-21 10:06 | DAL | DAL261120P00085000 | put | 85.0000 | 2026-11-20 | 7.9000 | 7.9000 | 8.1000 | 79.9750 | 15800.00 | 0.00 | 15800.00 | 20 | 8 | 20 | 192 | 0.104166666666667 | 0.405359820775606 | 0.405359820775606 | true | false | false | true | false | |||||||||||||||
| 724f9a69-cb66-42f9-be68-8c3fc8c2445e | 2026-09-21 10:15 | 2026-09-21 10:15 | 2026-09-21 10:15 | DAL | DAL261120C00090000 | call | 90.0000 | 2026-11-20 | 1.9700 | 1.9000 | 1.9700 | 80.0000 | 23837.00 | 23837.00 | 0.00 | 121 | 21 | 363 | 18710 | 0.0194013896312133 | 0.392892911703928 | 0.392892911703928 | false | false | false | true | false | |||||||||||||||
| daa4579d-f602-426a-96d7-be2382083740 | 2026-09-21 10:25 | 2026-09-21 10:24 | 2026-09-21 10:24 | DAL | DAL261009P00081000 | put | 81.0000 | 2026-10-09 | 3.7000 | 3.7000 | 3.9500 | 80.4600 | 37000.00 | 0.00 | 37000.00 | 100 | 6 | 114 | 15 | 7.6 | 0.49091695049732 | 0.49091695049732 | false | false | false | true | false | |||||||||||||||
| 704ffa17-e4b7-435a-a628-656d59b993d0 | 2026-09-21 10:25 | 2026-09-21 10:25 | 2026-09-21 10:25 | DAL | DAL261009C00082000 | call | 82.0000 | 2026-10-09 | 2.9100 | 2.8600 | 2.9100 | 80.6400 | 27936.00 | 27936.00 | 0.00 | 96 | 11 | 232 | 364 | 0.637362637362637 | 0.483328816586305 | 0.483328816586305 | true | false | false | true | false | |||||||||||||||
| 96229a05-a00b-4312-bb3d-77e8e0e1e5e8 | 2026-09-21 10:26 | 2026-09-21 10:26 | 2026-09-21 10:26 | DAL | DAL261009P00081000 | put | 81.0000 | 2026-10-09 | 3.6500 | 3.6000 | 3.9500 | 80.5700 | 36500.00 | 0.00 | 21900.00 | 100 | 7 | 214 | 15 | 14.2666666666667 | 0.491510765031125 | 0.491510765031125 | false | false | false | true | false | |||||||||||||||
| f7d00b49-f6f5-4406-a78c-1659a8113d26 | 2026-09-21 10:32 | 2026-09-21 10:32 | 2026-09-21 10:32 | DAL | DAL270115C00090000 | call | 90.0000 | 2027-01-15 | 4.0000 | 3.9500 | 4.0000 | 80.6900 | 12400.00 | 12400.00 | 0.00 | 31 | 5 | 70 | 7720 | 0.00906735751295337 | 0.386862137666232 | 0.386862137666232 | false | false | false | true | false | |||||||||||||||
| 09892d94-3c06-4f3c-9b57-606865d2bbc9 | 2026-09-21 10:46 | 2026-09-21 10:46 | 2026-09-21 10:46 | DAL | DAL261030C00083000 | call | 83.0000 | 2026-10-30 | 3.6000 | 3.6000 | 3.8000 | 80.8900 | 18000.00 | 0.00 | 18000.00 | 50 | 6 | 50 | 2 | 25 | 0.414754139702752 | 0.414754139702752 | false | false | false | true | false | |||||||||||||||
| 4d9a0b8c-600f-4049-a380-9b5952735089 | 2026-09-21 11:29 | 2026-09-21 11:29 | 2026-09-21 11:29 | DAL | DAL261030C00086000 | call | 86.0000 | 2026-10-30 | 2.5600 | 2.5600 | 2.7500 | 80.8300 | 51200.00 | 0.00 | 51200.00 | 200 | 7 | 225 | 92 | 2.44565217391304 | 0.420771967649635 | 0.420771967649635 | false | false | false | true | false | |||||||||||||||
| 3799a6cd-2eb3-4765-a3da-ddb60229f60d | 2026-09-21 11:39 | 2026-09-21 11:39 | 2026-09-21 11:39 | DAL | DAL261030C00086000 | call | 86.0000 | 2026-10-30 | 2.4100 | 2.4100 | 2.5200 | 80.6900 | 67721.00 | 0.00 | 67721.00 | 281 | 9 | 506 | 92 | 5.5 | 0.410650845682854 | 0.410650845682854 | false | false | false | true | false | |||||||||||||||
| 8ad9ef7b-4413-4b1f-848d-908ba3c25b2a | 2026-09-21 12:19 | 2026-09-21 12:19 | 2026-09-21 12:19 | DAL | DAL261009C00085000 | call | 85.0000 | 2026-10-09 | 2.1000 | 1.9800 | 2.1000 | 81.0000 | 66780.00 | 66780.00 | 0.00 | 318 | 34 | 431 | 289 | 1.49134948096886 | 0.487584790484843 | 0.483794216911833 | false | false | false | true | false | |||||||||||||||
| 26940814-dd03-4db8-9bc6-26f35b5ac185 | 2026-09-21 12:19 | 2026-09-21 12:19 | 2026-09-21 12:19 | DAL | DAL261009C00082000 | call | 82.0000 | 2026-10-09 | 3.2500 | 3.1500 | 3.3500 | 81.0000 | 95225.00 | 93925.00 | 1300.00 | 293 | 8 | 541 | 364 | 1.48626373626374 | 0.485012507299609 | 0.485012507299609 | false | false | false | true | false | |||||||||||||||
| c9f13a0b-0676-463d-9e84-0381108abeac | 2026-09-21 13:15 | 2026-09-21 13:14 | 2026-09-21 13:14 | DAL | DAL270115P00062500 | put | 62.5000 | 2027-01-15 | 1.1100 | 1.1100 | 1.2000 | 81.5300 | 88024.00 | 0.00 | 88024.00 | 793 | 44 | 819 | 1647 | 0.497267759562842 | 0.436347558714777 | 0.437549157512678 | false | false | false | true | false | |||||||||||||||
| fa432ba2-b967-412a-b7ec-f3201589d5bc | 2026-09-21 14:03 | 2026-09-21 14:03 | 2026-09-21 14:03 | DAL | DAL280121C00130000 | call | 130.0000 | 2028-01-21 | 4.1500 | 3.4000 | 4.2000 | 81.0000 | 84333.00 | 84333.00 | 0.00 | 203 | 36 | 203 | 30 | 6.76666666666667 | 0.375238900035218 | 0.375238900035218 | false | false | false | true | false | |||||||||||||||
| a70cdef8-c1d1-421f-aedd-091908404699 | 2026-09-21 14:04 | 2026-09-21 14:04 | 2026-09-21 14:04 | DAL | DAL261218C00085000 | call | 85.0000 | 2026-12-18 | 5.3500 | 5.3000 | 5.3500 | 81.0000 | 83460.00 | 79180.00 | 0.00 | 156 | 7 | 182 | 1180 | 0.154237288135593 | 0.393254674094467 | 0.393254674094467 | false | false | false | true | false | |||||||||||||||
| 4646a2c2-9ff3-4209-9645-89af6d8b75f2 | 2026-09-21 14:27 | 2026-09-21 14:27 | 2026-09-21 14:27 | DAL | DAL270115P00065000 | put | 65.0000 | 2027-01-15 | 1.4000 | 1.3500 | 1.4500 | 82.0650 | 26321.00 | 141.00 | 26180.00 | 188 | 29 | 234 | 2221 | 0.105357946870779 | 0.42886411958586 | 0.429901510850903 | false | false | false | true | false | |||||||||||||||
| 12496437-246e-4935-aca2-c8ef6a685c64 | 2026-09-21 14:51 | 2026-09-21 14:51 | 2026-09-21 14:51 | DAL | DAL261009C00085000 | call | 85.0000 | 2026-10-09 | 2.4500 | 2.4500 | 2.5400 | 82.1300 | 28910.00 | 0.00 | 28910.00 | 118 | 19 | 862 | 289 | 2.98269896193772 | 0.492906942894328 | 0.492906942894328 | false | false | false | true | false | |||||||||||||||
| 35a26b92-075d-4510-821b-89a76f86c135 | 2026-09-21 14:54 | 2026-09-21 14:54 | 2026-09-21 14:54 | DAL | DAL261016C00090000 | call | 90.0000 | 2026-10-16 | 1.3500 | 1.3200 | 1.3500 | 82.1100 | 67500.00 | 270.00 | 0.00 | 500 | 65 | 705 | 2481 | 0.28415961305925 | 0.455749748980966 | 0.455749748980966 | false | false | false | true | false | |||||||||||||||
| 313ca6c9-eba0-4703-8254-bf5fc6772acf | 2026-09-21 14:55 | 2026-09-21 14:55 | 2026-09-21 14:55 | DAL | DAL261016C00090000 | call | 90.0000 | 2026-10-16 | 1.3700 | 1.3200 | 1.3700 | 82.0900 | 68500.00 | 68500.00 | 0.00 | 500 | 36 | 1207 | 2481 | 0.486497380088674 | 0.45942694347501 | 0.45942694347501 | false | false | false | true | false | |||||||||||||||
| 677c2333-3a99-4e19-98fb-2acee83d2c1f | 2026-09-21 15:18 | 2026-09-21 15:18 | 2026-09-21 15:18 | DAL | DAL261002C00083000 | call | 83.0000 | 2026-10-02 | 2.0400 | 2.0300 | 2.1200 | 82.5400 | 24481.00 | 2244.00 | 22032.00 | 120 | 28 | 471 | 578 | 0.814878892733564 | 0.386831417215813 | 0.386831417215813 | true | false | false | true | false | |||||||||||||||
| c9025865-fa8d-44a9-8900-2a41b7247133 | 2026-09-21 15:53 | 2026-09-21 15:53 | 2026-09-21 15:53 | DAL | DAL261120C00085000 | call | 85.0000 | 2026-11-20 | 4.6000 | 4.6000 | 4.9000 | 82.0000 | 12880.00 | 0.00 | 12880.00 | 28 | 5 | 592 | 987 | 0.599797365754813 | 0.402223667912407 | 0.402223667912407 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:06:26.378716Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:26:48.053449Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:26:48.053449Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:26:48.053449Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:34:41.643622Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:47:49.730853Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:32:21.239106Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:43:39.846801Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:16:02.178873Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:05:09.858972Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:05:09.858972Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:28:37.842583Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:53:27.633876Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:56:46.399450Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:56:46.399450Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 54253899975.00 |
| 2026-10-09 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:56:16.128848Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |