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_alerts425,429 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 |
|---|
| 68ca16fb-d281-409a-bd71-f19a0f932bab | 2026-09-24 15:31 | 2026-09-24 15:31 | 2026-09-24 15:31 | LOW | LOW270319P00180000 | put | 180.0000 | 2027-03-19 | 11.4000 | 11.4000 | 11.9000 | 187.8900 | 190384.00 | 0.00 | 190384.00 | 167 | 7 | 1501 | 127 | 11.8188976377953 | 0.329200225985808 | 0.329200225985808 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 107363297076.00 | 2026-11-18 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T19:37:02.882742Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| 1ae6c243-4df7-4b7a-b4fb-50b37ee4297a | 2026-09-24 10:36 | 2026-09-24 10:36 | 2026-09-24 10:36 | LOW | LOW270319C00195000 | call | 195.0000 | 2027-03-19 | 14.1500 | 14.1000 | 16.0000 | 189.0500 | 18400.00 | 0.00 | 18400.00 | 13 | 5 | 14 | 36 | 0.388888888888889 | 0.288282950801961 | 0.28637126525129 | true | false | false | true | ||||||||||||||||
| 81038917-6534-4a85-8a41-aa293349e710 | 2026-09-24 10:05 | 2026-09-24 10:05 | 2026-09-24 10:05 | LOW | LOW261002C00192500 | call | 192.5000 | 2026-10-02 | 2.5000 | 2.3000 | 2.4500 | 190.1800 | 27735.00 | 27735.00 | 0.00 | 111 | 5 | 135 | 15 | 9 | 0.307239485437341 | 0.302672291294321 | false | false | false | true | ||||||||||||||||
| 7a489c8e-7749-48d0-b0d5-6ea5fc2fc7a9 | 2026-09-23 15:58 | 2026-09-23 15:58 | 2026-09-23 15:58 | LOW | LOW261002P00187500 | put | 187.5000 | 2026-10-02 | 1.6700 | 1.6500 | 1.7000 | 191.0000 | 34757.00 | 15287.00 | 19470.00 | 208 | 20 | 224 | 11 | 20.3636363636364 | 0.28304021674306 | 0.28304021674306 | false | false | false | true | ||||||||||||||||
| 6b28a5a2-dde1-4143-9533-54a599681320 | 2026-09-23 15:58 | 2026-09-23 15:58 | 2026-09-23 15:58 | LOW | LOW261002P00185000 | put | 185.0000 | 2026-10-02 | 1.0100 | 1.0000 | 1.0500 | 191.0000 | 41625.00 | 11025.00 | 30600.00 | 411 | 25 | 432 | 51 | 8.47058823529412 | 0.285879596550953 | 0.285879596550953 | false | false | false | true | ||||||||||||||||
| 3b9198d5-bc18-4210-ad82-b1c635d3b492 | 2026-09-23 10:38 | 2026-09-23 10:38 | 2026-09-23 10:38 | LOW | LOW261016P00180000 | put | 180.0000 | 2026-10-16 | 1.2000 | 1.1500 | 1.2000 | 192.7250 | 22859.00 | 22859.00 | 0.00 | 191 | 19 | 202 | 3059 | 0.0660346518470088 | 0.2910617922257 | 0.2910617922257 | false | false | false | true | ||||||||||||||||
| 09dcd6e2-fe30-4f6a-adf8-42d933de05f1 | 2026-09-21 15:33 | 2026-09-21 15:32 | 2026-09-21 15:32 | LOW | LOW280121C00240000 | call | 240.0000 | 2028-01-21 | 12.8200 | 12.8000 | 13.6000 | 192.0000 | 230832.00 | 0.00 | 230832.00 | 180 | 26 | 1185 | 231 | 5.12987012987013 | 0.274584262580776 | 0.272428748524608 | false | false | false | true | ||||||||||||||||
| 2987173c-419c-4306-8682-a8cd33e74965 | 2026-09-21 14:21 | 2026-09-21 14:21 | 2026-09-21 14:21 | LOW | LOW280121C00250000 | call | 250.0000 | 2028-01-21 | 10.7500 | 10.7000 | 11.4000 | 192.3450 | 64513.00 | 0.00 | 64513.00 | 60 | 16 | 65 | 815 | 0.0797546012269939 | 0.274947173986554 | 0.273309931632152 | false | false | false | true | ||||||||||||||||
| 314eebea-4f2b-47c6-a36d-f29834a7d400 | 2026-09-18 12:51 | 2026-09-18 12:51 | 2026-09-18 12:51 | LOW | LOW261218C00190000 | call | 190.0000 | 2026-12-18 | 13.4800 | 13.3000 | 15.4000 | 192.8100 | 66047.00 | 0.00 | 66047.00 | 49 | 18 | 50 | 81 | 0.617283950617284 | 0.28926312403381 | 0.28926312403381 | false | false | false | true | ||||||||||||||||
| c21439b2-afc1-4337-9de1-b84355f5fe7c | 2026-09-16 10:44 | 2026-09-16 10:44 | 2026-09-16 10:44 | LOW | LOW280121P00145000 | put | 145.0000 | 2028-01-21 | 6.4600 | 6.3000 | 7.3000 | 196.3100 | 60690.00 | 6500.00 | 54190.00 | 94 | 25 | 178 | 5 | 35.6 | 0.348192713479793 | 0.344250900208792 | false | false | false | true | ||||||||||||||||
| 8b470af8-b631-493c-992b-7273c0b0d914 | 2026-09-15 10:14 | 2026-09-15 10:14 | 2026-09-15 10:14 | LOW | LOW270319P00190000 | put | 190.0000 | 2027-03-19 | 13.1000 | 13.1000 | 13.5000 | 194.9900 | 115304.00 | 0.00 | 115304.00 | 88 | 9 | 1002 | 1766 | 0.567383918459796 | 0.313892194738099 | 0.313892194738099 | false | false | false | true | ||||||||||||||||
| a5c991ff-86ed-4f69-a65c-83007cbeb8b6 | 2026-09-15 10:14 | 2026-09-15 10:13 | 2026-09-15 10:13 | LOW | LOW270319P00190000 | put | 190.0000 | 2027-03-19 | 13.1100 | 13.1000 | 13.5000 | 194.9900 | 115396.00 | 0.00 | 115396.00 | 88 | 5 | 914 | 1766 | 0.517553793884485 | 0.313892194738099 | 0.313892194738099 | false | false | false | true | ||||||||||||||||
| 36134521-d1e6-4cde-8150-9704b1fc34d1 | 2026-09-15 10:13 | 2026-09-15 10:12 | 2026-09-15 10:12 | LOW | LOW270319P00190000 | put | 190.0000 | 2027-03-19 | 13.2700 | 12.9000 | 13.4000 | 194.7250 | 61028.00 | 61028.00 | 0.00 | 46 | 20 | 646 | 1766 | 0.365798414496036 | 0.315769776645862 | 0.315769776645862 | false | false | false | true | ||||||||||||||||
| 188d58b0-da3c-4a69-861a-777dc1fe3cdd | 2026-09-15 09:55 | 2026-09-15 09:55 | 2026-09-15 09:55 | LOW | LOW270319P00190000 | put | 190.0000 | 2027-03-19 | 13.1900 | 13.2000 | 13.5000 | 194.8900 | 65927.00 | 0.00 | 65927.00 | 50 | 5 | 489 | 1766 | 0.276896942242356 | 0.314688037879476 | 0.314688037879476 | false | false | false | true | ||||||||||||||||
| 6d6c7043-0046-48df-b4d3-0baa8b920c31 | 2026-08-25 10:45 | 2026-08-25 10:45 | 2026-08-25 10:45 | LOW | LOW261218C00230000 | call | 230.0000 | 2026-12-18 | 8.8000 | 8.4000 | 8.8000 | 214.3375 | 399478.00 | 397738.00 | 0.00 | 454 | 49 | 473 | 332 | 1.42469879518072 | 0.290035652744393 | 0.287870095685816 | false | false | false | true | ||||||||||||||||
| 440dd77d-8ad7-4c94-963c-006c5ff745c1 | 2026-08-24 11:42 | 2026-08-24 11:42 | 2026-08-24 11:42 | LOW | LOW280121C00220000 | call | 220.0000 | 2028-01-21 | 32.8000 | 32.8000 | 33.7000 | 216.3800 | 265690.00 | 0.00 | 265690.00 | 81 | 5 | 86 | 88 | 0.977272727272727 | 0.281164360405597 | 0.280145325850178 | true | false | false | true | ||||||||||||||||
| 98cc271b-96cd-4700-b9ed-c6688099afbe | 2026-08-20 11:26 | 2026-08-20 11:26 | 2026-08-20 11:26 | LOW | LOW260821P00222500 | put | 222.5000 | 2026-08-21 | 3.9000 | 3.3000 | 4.0000 | 220.0000 | 83065.00 | 82675.00 | 390.00 | 213 | 45 | 368 | 395 | 0.931645569620253 | 0.533834739438996 | 0.533834739438996 | false | false | false | true | ||||||||||||||||
| 9ba2f48d-d3e0-4978-a455-3e5057f9d981 | 2026-08-19 14:50 | 2026-08-19 14:50 | 2026-08-19 14:50 | LOW | LOW270115C00200000 | call | 200.0000 | 2027-01-15 | 31.3300 | 31.0000 | 32.5000 | 221.9900 | 62660.00 | 0.00 | 62660.00 | 20 | 16 | 22 | 144 | 0.152777777777778 | 0.294497398294784 | 0.294497398294784 | false | false | false | true | ||||||||||||||||
| 61329b59-cc77-45d1-a7f9-c8388a26cd6d | 2026-08-18 10:46 | 2026-08-18 10:46 | 2026-08-18 10:46 | LOW | LOW260918P00230000 | put | 230.0000 | 2026-09-18 | 14.9900 | 14.5000 | 16.4000 | 219.1600 | 143869.00 | 122769.00 | 21100.00 | 96 | 12 | 96 | 838 | 0.114558472553699 | 0.352507469105755 | 0.344453120060582 | true | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 107363297076.00 |
| 2026-11-18 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:39:59.397883Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 107363297076.00 |
| 2026-11-18 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:06:35.686187Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 107363297076.00 |
| 2026-11-18 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 107363297076.00 |
| 2026-11-18 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 107363297076.00 |
| 2026-11-18 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:39:41.777134Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 107150096549.00 |
| 2026-11-18 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 107150096549.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:23:56.707397Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 107997288117.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:09:50.881001Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 108900585088.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 111184074945.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 111184074945.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 111184074945.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 111184074945.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 111184074945.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:00:40.665909Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 111184074945.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:49:37.820281Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 111184074945.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 111184074945.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 111184074945.00 |
| 2026-11-18 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |