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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ebd83a8e-6d19-4bae-8b7b-d57096f614d5 | 2026-08-25 09:30 | 2026-08-25 09:30 | 2026-08-25 09:30 | EXPE | EXPE270115P00300000 | put | 300.0000 | 2027-01-15 | 18.5400 | 17.4000 | 20.5000 | 335.2950 | 37082.00 | 0.00 | 37082.00 | 20 | 10 | 20 | 60 | 0.333333333333333 | 0.44647199444552 | 0.44647199444552 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 32958787183.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T13:32:26.163070Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a3d41003-b475-431d-a270-7b1f2f464570 | 2026-09-01 11:33 | 2026-09-01 11:33 | 2026-09-01 11:33 | EXPE | EXPE260904P00305000 | put | 305.0000 | 2026-09-04 | 2.8900 | 2.2000 | 3.3000 | 311.2300 | 58618.00 | 44413.00 | 9565.00 | 203 | 52 | 567 | 101 | 5.61386138613861 | 0.509919713525661 | 0.493091024155294 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 32958787183.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T15:45:30.323966Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f1e3b0a6-d257-417c-852e-c82c5d410980 | 2026-09-01 15:34 | 2026-09-01 15:34 | 2026-09-01 15:34 | EXPE | EXPE260918P00307500 | put | 307.5000 | 2026-09-18 | 12.0600 | 11.3000 | 12.1000 | 304.0800 | 44620.00 | 26620.00 | 18000.00 | 37 | 13 | 49 | 8 | 6.125 | 0.403254324334417 | 0.399426562927431 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 32958787183.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T19:44:53.190071Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1268b84e-8aba-4b90-89bb-fca2a918a107 | 2026-09-01 15:35 | 2026-09-01 15:35 | 2026-09-01 15:35 | EXPE | EXPE260918P00307500 | put | 307.5000 | 2026-09-18 | 12.2800 | 11.7000 | 12.3000 | 303.9750 | 49100.00 | 43050.00 | 6050.00 | 40 | 18 | 100 | 8 | 12.5 | 0.408796632566478 | 0.401137144914287 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 32958787183.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T19:44:53.190071Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0db26e01-cdb3-4918-9197-b033aab5eeae | 2026-09-02 09:32 | 2026-09-02 09:32 | 2026-09-02 09:32 | EXPE | EXPE260918P00317500 | put | 317.5000 | 2026-09-18 | 16.0600 | 14.4000 | 16.4000 | 307.6700 | 20880.00 | 16100.00 | 4780.00 | 13 | 8 | 96 | 203 | 0.472906403940887 | 0.427259955325108 | 0.40692468386479 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 32958787183.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T13:42:51.501101Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 257b6331-19e2-4461-8376-de3f88f1cde1 | 2026-09-02 09:32 | 2026-09-02 09:32 | 2026-09-02 09:32 | EXPE | EXPE260918P00317500 | put | 317.5000 | 2026-09-18 | 16.2200 | 14.4000 | 16.5000 | 307.6200 | 24330.00 | 14730.00 | 9600.00 | 15 | 13 | 115 | 203 | 0.566502463054187 | 0.430072373839411 | 0.409738207689662 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 32958787183.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T13:42:51.501101Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e52ce86f-78de-48f9-b266-9be690e8e2ed | 2026-09-02 09:53 | 2026-09-02 09:52 | 2026-09-02 09:52 | EXPE | EXPE260911P00305000 | put | 305.0000 | 2026-09-11 | 5.5100 | 4.7000 | 5.6000 | 311.0700 | 20940.00 | 13380.00 | 3780.00 | 38 | 13 | 159 | 15 | 10.6 | 0.435581343155562 | 0.424708825468187 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 32958787183.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T13:56:06.315925Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 466262e6-fd40-45bd-b73e-60b6a76c1dbb | 2026-09-03 14:09 | 2026-09-03 14:09 | 2026-09-03 14:09 | EXPE | EXPE260918P00280000 | put | 280.0000 | 2026-09-18 | 2.2500 | 2.0000 | 2.2500 | 306.0800 | 59394.00 | 59394.00 | 0.00 | 264 | 42 | 374 | 300 | 1.24666666666667 | 0.450036327426979 | 0.450036327426979 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 32958787183.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T18:16:35.526734Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 55ac3d1c-aeff-4fef-a60c-372f07010c05 | 2026-09-03 15:44 | 2026-09-03 15:44 | 2026-09-03 15:44 | EXPE | EXPE260918P00315000 | put | 315.0000 | 2026-09-18 | 16.7700 | 16.3000 | 16.8000 | 303.0800 | 35220.00 | 31900.00 | 1660.00 | 21 | 10 | 60 | 519 | 0.115606936416185 | 0.403545713847278 | 0.394645314960437 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 32958787183.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T19:48:49.580975Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 70c0570c-e1aa-4628-b339-2788694687d2 | 2026-09-04 10:43 | 2026-09-04 10:43 | 2026-09-04 10:43 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 17.4100 | 16.2000 | 17.6000 | 297.4400 | 12190.00 | 12190.00 | 0.00 | 7 | 7 | 598 | 1135 | 0.526872246696035 | 0.440946770243275 | 0.426805404315874 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 32958787183.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T14:44:26.340635Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4270059e-56b7-4f5e-b1d7-531b5ebb1448 | 2026-09-08 09:42 | 2026-09-08 09:42 | 2026-09-08 09:42 | EXPE | EXPE260918P00317500 | put | 317.5000 | 2026-09-18 | 32.8900 | 31.5000 | 35.6000 | 284.9900 | 46050.00 | 22880.00 | 23170.00 | 14 | 5 | 67 | 379 | 0.176781002638522 | 0.343178971358073 | 0.374442580095224 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 32958787183.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T13:49:15.511852Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5567b36d-0941-4e13-bc2b-19ffb93c41c8 | 2026-09-08 15:53 | 2026-09-08 15:53 | 2026-09-08 15:53 | EXPE | EXPE261016P00310000 | put | 310.0000 | 2026-10-16 | 37.4400 | 36.9000 | 37.6000 | 276.0250 | 18720.00 | 18720.00 | 0.00 | 5 | 5 | 293 | 1108 | 0.264440433212996 | 0.432426497788664 | 0.425636674156038 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 32958787183.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T13:30:57.501605Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ae777d46-0aaf-44dc-b978-9e5641aec044 | 2026-09-21 12:07 | 2026-09-21 12:07 | 2026-09-21 12:07 | EXPE | EXPE270319P00250000 | put | 250.0000 | 2027-03-19 | 20.4500 | 20.4000 | 21.9000 | 280.9700 | 47030.00 | 0.00 | 47030.00 | 23 | 9 | 91 | 40 | 2.275 | 0.489014369146795 | 0.487512859780511 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 32175635289.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:10:34.961716Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |