Options 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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0c587fdc-8890-4e7f-b0aa-73bdfb55d834 | 2026-09-08 13:02 | 2026-09-08 13:02 | 2026-09-08 13:02 | OWL | OWL270115P00008000 | put | 8.0000 | 2027-01-15 | 0.2000 | 0.1500 | 0.2000 | 11.4650 | 12000.00 | 12000.00 | 0.00 | 600 | 35 | 630 | 24981 | 0.0252191665665906 | 0.555248362928637 | 0.555248362928637 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T17:11:09.796111Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3915d9b6-233d-4963-8b69-080dd4a38b8a | 2026-09-09 10:24 | 2026-09-09 10:24 | 2026-09-09 10:24 | OWL | OWL270219P00010000 | put | 10.0000 | 2027-02-19 | 0.9500 | 0.9000 | 0.9500 | 10.0000 | 23750.00 | 23750.00 | 0.00 | 250 | 14 | 250 | 8197 | 0.0304989630352568 | 0.527184123515045 | 0.527184123515045 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | 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 |
| 699dbdc3-6bd2-46cf-a48e-afde9da47f5f | 2026-09-09 10:49 | 2026-09-09 10:49 | 2026-09-09 10:49 | OWL | OWL270115P00008000 | put | 8.0000 | 2027-01-15 | 0.2500 | 0.2000 | 0.2500 | 10.9350 | 25000.00 | 25000.00 | 0.00 | 1000 | 27 | 1000 | 25461 | 0.0392757550763913 | 0.550287205863896 | 0.549355740257988 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T14:59:53.339088Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ae4b47bb-7348-4e20-bacc-98780c5ed4cb | 2026-09-09 11:28 | 2026-09-09 11:28 | 2026-09-09 11:28 | OWL | OWL261120C00011000 | call | 11.0000 | 2026-11-20 | 0.9000 | 0.8000 | 0.9500 | 10.8750 | 134981.00 | 127061.00 | 1350.00 | 1500 | 29 | 1510 | 1351 | 1.11769059955588 | 0.480144556471589 | 0.477358111117458 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T15:29:26.424015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5806587c-c955-4340-92ec-8fa6802fc9c9 | 2026-09-09 13:02 | 2026-09-09 13:02 | 2026-09-09 13:02 | OWL | OWL270219C00013000 | call | 13.0000 | 2027-02-19 | 0.5500 | 0.5500 | 0.6000 | 10.0000 | 20426.00 | 0.00 | 20426.00 | 371 | 10 | 1120 | 2388 | 0.469011725293132 | 0.415482154832792 | 0.411657441986159 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3f317612-24c1-427c-969f-b645839dbfd5 | 2026-09-09 13:02 | 2026-09-09 13:02 | 2026-09-09 13:02 | OWL | OWL270219C00013000 | call | 13.0000 | 2027-02-19 | 0.5600 | 0.5500 | 0.6000 | 10.0000 | 17776.00 | 0.00 | 17776.00 | 316 | 6 | 652 | 2388 | 0.273031825795645 | 0.419295403003525 | 0.419295403003525 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ba55bc3f-ab4b-4aeb-bdf9-e2ca2093b448 | 2026-09-10 15:20 | 2026-09-10 15:20 | 2026-09-10 15:20 | OWL | OWL280121C00013000 | call | 13.0000 | 2028-01-21 | 1.3500 | 1.2500 | 1.3500 | 10.4900 | 13480.00 | 13480.00 | 0.00 | 100 | 7 | 118 | 26732 | 0.00441418524614694 | 0.403332078413538 | 0.398746168739347 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T19:25:57.950009Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2687b107-1c0c-458d-b41a-f06a2e76df14 | 2026-09-11 14:25 | 2026-09-11 14:25 | 2026-09-11 14:25 | OWL | OWL270219P00010000 | put | 10.0000 | 2027-02-19 | 1.0500 | 1.0500 | 1.1000 | 10.5350 | 78750.00 | 0.00 | 78750.00 | 750 | 14 | 757 | 8227 | 0.0920140999149143 | 0.512699374507743 | 0.512699374507743 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T18:33:12.425630Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| de8bfd76-9c38-4037-b075-5a52d6e92da7 | 2026-09-14 11:05 | 2026-09-14 11:05 | 2026-09-14 11:05 | OWL | OWL290119C00010000 | call | 10.0000 | 2029-01-19 | 2.9500 | 2.5500 | 2.9500 | 10.4850 | 34220.00 | 34220.00 | 0.00 | 116 | 6 | 1364 | 0 | 0 | 0.378478664015048 | 0.378478664015048 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cb760409-7485-4122-bb5a-1ed0a2813388 | 2026-09-15 14:19 | 2026-09-15 14:19 | 2026-09-15 14:19 | OWL | OWL261002P00010000 | put | 10.0000 | 2026-10-02 | 0.2500 | 0.2000 | 0.3000 | 10.2850 | 12500.00 | 0.00 | 10500.00 | 500 | 6 | 501 | 369 | 1.35772357723577 | 0.438837212371817 | 0.438837212371817 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 7133166656.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T18:42:39.046957Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| a7cb563f-076f-4871-8e11-7af5aef30d88 | 2026-09-16 15:29 | 2026-09-16 15:29 | 2026-09-16 15:29 | OWL | OWL270115P00010000 | put | 10.0000 | 2027-01-15 | 1.1500 | 1.1000 | 1.1500 | 9.8900 | 11500.00 | 11500.00 | 0.00 | 100 | 8 | 111 | 43273 | 0.00256510988376124 | 0.514796573535453 | 0.514796573535453 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 6921154992.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:45:47.974261Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 71a6f3a0-4b13-4f23-b24b-9f9130d9c804 | 2026-09-17 12:35 | 2026-09-17 12:35 | 2026-09-17 12:35 | OWL | OWL270115P00010000 | put | 10.0000 | 2027-01-15 | 1.0500 | 1.0000 | 1.0500 | 10.1391 | 94500.00 | 94500.00 | 0.00 | 900 | 11 | 2400 | 43178 | 0.0555838621520219 | 0.519353145867366 | 0.519353145867366 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 6811729616.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T16:46:55.190867Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 948ff282-9f0a-4f9b-ac8f-170eeaefc72d | 2026-09-18 12:35 | 2026-09-18 12:35 | 2026-09-18 12:35 | OWL | OWL261002P00010000 | put | 10.0000 | 2026-10-02 | 0.3500 | 0.3500 | 0.4500 | 9.8750 | 17500.00 | 0.00 | 17500.00 | 500 | 16 | 519 | 1085 | 0.478341013824885 | 0.376232816506913 | 0.376232816506913 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 6729660585.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T16:45:45.480252Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| f8780d9b-4c01-47ab-ac9a-c69c1b3fec4a | 2026-09-18 15:58 | 2026-09-18 15:58 | 2026-09-18 15:58 | OWL | OWL260925P00010000 | put | 10.0000 | 2026-09-25 | 0.3000 | 0.3000 | 0.3500 | 9.0000 | 13500.00 | 0.00 | 13500.00 | 450 | 7 | 972 | 674 | 1.44213649851632 | 0.375537162017862 | 0.375537162017862 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 6729660585.00 | 2026-10-29 | 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 |
| dfad9a0a-3955-4a50-a25b-9112bc6ed934 | 2026-09-21 10:27 | 2026-09-21 10:27 | 2026-09-21 10:27 | OWL | OWL270115P00008000 | put | 8.0000 | 2027-01-15 | 0.3000 | 0.3000 | 0.3500 | 9.9800 | 33000.00 | 0.00 | 33000.00 | 1100 | 5 | 1200 | 27067 | 0.0443344293789485 | 0.51257765509 | 0.51257765509 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 6852764132.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:29:33.809340Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| d79b240a-e444-4344-a55d-af484f671dda | 2026-09-21 10:35 | 2026-09-21 10:35 | 2026-09-21 10:35 | OWL | OWL290119C00010000 | call | 10.0000 | 2029-01-19 | 2.3500 | 2.3500 | 2.4000 | 9.9750 | 14100.00 | 0.00 | 14100.00 | 60 | 6 | 344 | 2156 | 0.159554730983302 | 0.313964859642553 | 0.313964859642553 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 6852764132.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:37:14.719915Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| b2195d2e-c9ef-4f1f-9c6b-364eb89d512d | 2026-09-21 10:59 | 2026-09-21 10:59 | 2026-09-21 10:59 | OWL | OWL270521P00009000 | put | 9.0000 | 2027-05-21 | 1.1000 | 1.0500 | 1.1500 | 9.9550 | 110000.00 | 12100.00 | 97900.00 | 1000 | 6 | 2048 | 185 | 11.0702702702703 | 0.544750328905149 | 0.544215429581693 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 6852764132.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:02:30.535242Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |