Simplify AnalyticsOptions flow alerts (market-wide)
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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ef864057-2dd2-4065-a75f-308bf76843e3 | 2026-09-18 15:58 | 2026-09-18 15:58 | 2026-09-18 15:58 | GAP | GAP261218P00020000 | put | 20.0000 | 2026-12-18 | 1.6100 | 1.5800 | 1.8500 | 20.0000 | 17510.00 | 0.00 | 6579.00 | 109 | 74 | 110 | 5574 | 0.0197344815213491 | 0.492789359513304 | 0.482637442957389 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 7215088614.00 | 2026-11-19 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 3026c8c8-10b1-41a9-b66b-c11f6c7186fb | 2026-09-18 15:57 | 2026-09-18 15:57 | 2026-09-18 15:57 | GAP | GAP261218P00019000 | put | 19.0000 | 2026-12-18 | 1.1900 | 0.9900 | 1.6700 | 20.0000 | 20846.00 | 11368.00 | 974.00 | 175 | 108 | 177 | 473 | 0.374207188160677 | 0.50882352429565 | 0.49105014198033 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 7215088614.00 | 2026-11-19 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 5bf8437d-54de-41d8-b95e-d15ddb6755ae | 2026-09-16 13:35 | 2026-09-16 13:35 | 2026-09-16 13:35 | GAP | GAP261218C00022000 | call | 22.0000 | 2026-12-18 | 1.3200 | 1.2900 | 1.3400 | 20.5250 | 20306.00 | 18876.00 | 1430.00 | 154 | 6 | 159 | 2150 | 0.073953488372093 | 0.441526173070773 | 0.436629498242808 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 7085118663.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 3da7da6b-5c57-4ace-8c38-b39d9a0efbb8 | 2026-08-28 15:59 | 2026-08-28 15:59 | 2026-08-28 15:59 | GAP | GAP261218C00024000 | call | 24.0000 | 2026-12-18 | 2.0100 | 1.8200 | 2.2800 | 23.5050 | 20056.00 | 8200.00 | 11856.00 | 100 | 5 | 3651 | 546 | 6.68681318681319 | 0.405979746462957 | 0.404049539740059 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 7348571266.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T13:35:53.678596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5fd0a44c-f6d8-4bda-9f87-e780e0397375 | 2026-08-28 09:38 | 2026-08-28 09:38 | 2026-08-28 09:38 | GAP | GAP260828C00022000 | call | 22.0000 | 2026-08-28 | 2.7500 | 2.7400 | 2.8000 | 24.7500 | 12654.00 | 4400.00 | 0.00 | 46 | 7 | 991 | 5162 | 0.191979852770244 | 2.59160172281913 | 2.07695449159863 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 7348571266.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c2a1f2f8-8bb6-4a42-9546-c90185d5d8a2 | 2026-08-28 09:38 | 2026-08-28 09:38 | 2026-08-28 09:38 | GAP | GAP260828C00022000 | call | 22.0000 | 2026-08-28 | 2.8200 | 2.7900 | 2.8900 | 24.8200 | 12416.00 | 3671.00 | 566.00 | 44 | 13 | 443 | 5162 | 0.085819449825649 | 2.1563370804286 | 1.75236395015271 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 7348571266.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cd9ec3c5-6c92-4f43-88ed-90c3d5294465 | 2026-08-28 09:34 | 2026-08-28 09:34 | 2026-08-28 09:34 | GAP | GAP260918C00022000 | call | 22.0000 | 2026-09-18 | 3.9500 | 3.5500 | 4.9500 | 25.6300 | 84471.00 | 81455.00 | 3016.00 | 214 | 16 | 215 | 4523 | 0.0475348220207827 | 0.624045670744083 | 0.547410546303986 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 7348571266.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ea9dffbf-990c-4779-bdfe-aa2081b1fb17 | 2026-08-27 15:41 | 2026-08-27 15:41 | 2026-08-27 15:41 | GAP | GAP260918C00021000 | call | 21.0000 | 2026-09-18 | 1.5000 | 1.4900 | 1.5500 | 20.8150 | 27569.00 | 0.00 | 27569.00 | 184 | 18 | 2760 | 11709 | 0.235716115808353 | 0.767503968148841 | 0.76259031596864 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 7348571266.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T19:52:49.177007Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 164981e3-ac7f-4b0e-829c-91e7db506dbf | 2026-08-27 14:10 | 2026-08-27 14:10 | 2026-08-27 14:10 | GAP | GAP260904C00022000 | call | 22.0000 | 2026-09-04 | 1.1000 | 1.0200 | 1.1000 | 21.2850 | 10960.00 | 10960.00 | 0.00 | 100 | 12 | 260 | 881 | 0.295119182746879 | 1.11734084761717 | 1.10569338370851 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 7348571266.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T18:14:24.609292Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ad98f8d6-8b8a-4041-b648-848d9664cf25 | 2026-08-26 12:02 | 2026-08-26 12:02 | 2026-08-26 12:02 | GAP | GAP260904P00021000 | put | 21.0000 | 2026-09-04 | 1.2800 | 1.2000 | 1.3200 | 21.2650 | 18293.00 | 17013.00 | 1280.00 | 143 | 14 | 2211 | 6437 | 0.343482988970017 | 1.07107243158955 | 1.07272752474246 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 7348571266.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 84c89214-49b5-4a13-9283-a202758e4b64 | 2026-08-25 09:57 | 2026-08-25 09:57 | 2026-08-25 09:57 | GAP | GAP260828C00020500 | call | 20.5000 | 2026-08-28 | 0.9600 | 0.9600 | 1.0200 | 20.2000 | 31240.00 | 2910.00 | 28330.00 | 325 | 19 | 353 | 395 | 0.893670886075949 | 1.50376863435628 | 1.51042118798301 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 7348571266.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T14:12:03.649618Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d00b7df9-73fb-44a4-b4ad-18bfe798230d | 2026-08-18 10:18 | 2026-08-18 10:17 | 2026-08-18 10:17 | GAP | GAP280121C00020000 | call | 20.0000 | 2028-01-21 | 4.7100 | 4.7000 | 4.8500 | 20.1900 | 21179.00 | 0.00 | 21179.00 | 45 | 7 | 813 | 3037 | 0.26769838656569 | 0.436748559501449 | 0.434869736029716 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 7348571266.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |