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.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74991efe-850b-47d4-85b6-ef8128504cbc | 2026-08-21 10:15 | 2026-08-21 10:15 | 2026-08-21 10:15 | COF | COF260828P00217500 | put | 217.5000 | 2026-08-28 | 2.8500 | 2.4500 | 2.8500 | 218.1660 | 98030.00 | 98030.00 | 0.00 | 344 | 43 | 382 | 262 | 1.45801526717557 | 0.269798053957771 | 0.269798053957771 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 126795045904.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6198c7d9-2187-4167-bede-c1b3151b2c24 | 2026-08-24 13:16 | 2026-08-24 13:16 | 2026-08-24 13:16 | COF | COF281215P00185000 | put | 185.0000 | 2028-12-15 | 22.1000 | 22.1000 | 22.8000 | 216.8300 | 95034.00 | 0.00 | 95034.00 | 43 | 7 | 50 | 61 | 0.819672131147541 | 0.368596122848882 | 0.368596122848882 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 126795045904.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T17:17:38.633077Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dae703d2-d56f-49f5-ac2f-4da8a9561398 | 2026-09-01 10:29 | 2026-09-01 10:29 | 2026-09-01 10:29 | COF | COF261016P00220000 | put | 220.0000 | 2026-10-16 | 10.5000 | 10.1000 | 10.5000 | 215.2000 | 149090.00 | 149090.00 | 0.00 | 142 | 40 | 142 | 64 | 2.21875 | 0.279442478169158 | 0.279442478169158 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 126795045904.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d2268e1f-60be-4c80-9862-c20e4a96a9ef | 2026-09-01 10:42 | 2026-09-01 10:41 | 2026-09-01 10:41 | COF | COF280121C00300000 | call | 300.0000 | 2028-01-21 | 10.7100 | 9.8000 | 10.7000 | 214.0150 | 53570.00 | 53570.00 | 0.00 | 50 | 7 | 50 | 496 | 0.100806451612903 | 0.307174692365764 | 0.307174692365764 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 126795045904.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T14:59:17.018627Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 795cf46d-6235-486b-a3e1-5354ffd39246 | 2026-09-02 10:58 | 2026-09-02 10:58 | 2026-09-02 10:58 | COF | COF260918C00227500 | call | 227.5000 | 2026-09-18 | 2.4000 | 1.7500 | 2.4500 | 220.4700 | 79190.00 | 78230.00 | 960.00 | 330 | 47 | 415 | 23 | 18.0434782608696 | 0.269764475634938 | 0.269764475634938 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 126795045904.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T15:04:15.415728Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 770d2f85-1d83-4bb5-b279-f872f5822212 | 2026-09-02 15:22 | 2026-09-02 15:22 | 2026-09-02 15:22 | COF | COF260918C00220000 | call | 220.0000 | 2026-09-18 | 3.9000 | 3.7000 | 3.9000 | 216.7400 | 60446.00 | 60446.00 | 0.00 | 155 | 27 | 313 | 3019 | 0.103676714143756 | 0.286355602663203 | 0.286355602663203 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 126795045904.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:37:03.508091Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6adc32e5-1a32-4748-9429-c6d7cdd54249 | 2026-09-04 12:14 | 2026-09-04 12:14 | 2026-09-04 12:14 | COF | COF270319C00260000 | call | 260.0000 | 2027-03-19 | 7.8000 | 7.5000 | 7.8000 | 220.6300 | 152088.00 | 152088.00 | 0.00 | 195 | 40 | 197 | 482 | 0.408713692946058 | 0.294407820280333 | 0.294407820280333 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 126795045904.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 77d078ae-915e-40ec-9e41-8234d7ffc552 | 2026-09-21 11:55 | 2026-09-21 11:55 | 2026-09-21 11:55 | COF | COF270115C00230000 | call | 230.0000 | 2027-01-15 | 5.6900 | 5.6000 | 5.9000 | 203.7500 | 17056.00 | 0.00 | 17056.00 | 30 | 6 | 46 | 2193 | 0.0209758321933425 | 0.298142672758419 | 0.298142672758419 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 125715312593.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:56:02.019393Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| cf550e46-cb29-4706-99f7-cfeeea2c2da0 | 2026-09-21 13:46 | 2026-09-21 13:46 | 2026-09-21 13:46 | COF | COF261120C00220000 | call | 220.0000 | 2026-11-20 | 5.4000 | 5.3000 | 5.7000 | 205.0000 | 48020.00 | 0.00 | 48020.00 | 89 | 10 | 306 | 78 | 3.92307692307692 | 0.314571150816927 | 0.311264468976741 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 125715312593.00 | 2026-10-20 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:46:19.788598Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |