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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4f818ddc-bc13-42c4-ba2f-aae6c4f8bbd3 | 2026-09-21 14:52 | 2026-09-21 14:52 | 2026-09-21 14:52 | APH | APH261016C00082500 | call | 82.5000 | 2026-10-16 | 2.8000 | 2.7500 | 2.8500 | 80.8900 | 101080.00 | 8680.00 | 91840.00 | 361 | 47 | 894 | 2379 | 0.37578814627995 | 0.403119757145091 | 0.405082207968468 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 199052849298.00 | 2026-10-28 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:53:27.633876Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 1486113b-9e4c-4f02-966b-c2f59a030e95 | 2026-09-21 14:52 | 2026-09-21 14:52 | 2026-09-21 14:52 | APH | APH261016C00082500 | call | 82.5000 | 2026-10-16 | 2.8500 | 2.8000 | 2.9000 | 80.9600 | 76095.00 | 0.00 | 71250.00 | 267 | 32 | 532 | 2379 | 0.223623371164355 | 0.407207263745388 | 0.407207263745388 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 199052849298.00 | 2026-10-28 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:53:27.633876Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| f730d320-77b1-416a-be8e-7e4548f2b4b2 | 2026-09-21 14:09 | 2026-09-21 14:08 | 2026-09-21 14:08 | APH | APH261218C00087500 | call | 87.5000 | 2026-12-18 | 4.8000 | 4.6000 | 5.0000 | 80.0000 | 18720.00 | 4800.00 | 13920.00 | 39 | 6 | 43 | 920 | 0.0467391304347826 | 0.452022042061757 | 0.452022042061757 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 199052849298.00 | 2026-10-28 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:09:57.736377Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 265b3e8d-7801-4c8d-be84-9eb5f53f87fd | 2026-09-21 13:53 | 2026-09-21 13:52 | 2026-09-21 13:52 | APH | APH261016C00090000 | call | 90.0000 | 2026-10-16 | 0.7500 | 0.7000 | 0.8000 | 80.7700 | 28350.00 | 9300.00 | 12000.00 | 378 | 11 | 1135 | 4408 | 0.257486388384755 | 0.403496585273824 | 0.403496585273824 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 199052849298.00 | 2026-10-28 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:55:32.885478Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| edaf362b-3fdf-4280-a0d5-01082aee38f2 | 2026-09-21 11:08 | 2026-09-21 11:07 | 2026-09-21 11:07 | APH | APH270917C00097500 | call | 97.5000 | 2027-09-17 | 9.5000 | 8.6000 | 10.1000 | 80.5100 | 22800.00 | 5700.00 | 17100.00 | 24 | 5 | 24 | 25 | 0.96 | 0.440514121800332 | 0.440514121800332 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 199052849298.00 | 2026-10-28 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:08:57.828180Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 4aeaecd1-9c79-43d3-bc8c-fcca0f842329 | 2026-09-21 11:07 | 2026-09-21 11:07 | 2026-09-21 11:07 | APH | APH270416C00085000 | call | 85.0000 | 2027-04-16 | 9.4000 | 8.5000 | 9.9000 | 80.5100 | 13160.00 | 6580.00 | 6580.00 | 14 | 7 | 14 | 14 | 1 | 0.431567967697886 | 0.431567967697886 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 199052849298.00 | 2026-10-28 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:08:57.828180Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 038a5c05-0f3c-4827-98be-31cc9e89f4b1 | 2026-09-21 10:57 | 2026-09-21 10:56 | 2026-09-21 10:56 | APH | APH261016P00070000 | put | 70.0000 | 2026-10-16 | 0.5000 | 0.4500 | 0.5500 | 79.9928 | 17050.00 | 17000.00 | 50.00 | 341 | 16 | 400 | 1381 | 0.289645184648805 | 0.440032394000693 | 0.440032394000693 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 199052849298.00 | 2026-10-28 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:59:04.068372Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 1c19af2b-e079-44ba-875d-6c6d45b52d1b | 2026-09-15 14:46 | 2026-09-15 14:46 | 2026-09-15 14:46 | APH | APH261016C00080000 | call | 80.0000 | 2026-10-16 | 2.7500 | 2.7500 | 2.9500 | 77.6700 | 78650.00 | 0.00 | 78650.00 | 286 | 8 | 371 | 1220 | 0.304098360655738 | 0.4041780935302 | 0.4041780935302 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 193701701095.00 | 2026-10-28 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T18:59:21.919987Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 9864fcc5-bbdd-4afd-9194-4182078b0c04 | 2026-09-15 12:28 | 2026-09-15 12:27 | 2026-09-15 12:27 | APH | APH270416P00062500 | put | 62.5000 | 2027-04-16 | 3.6700 | 3.3000 | 4.3000 | 77.0000 | 53950.00 | 0.00 | 53950.00 | 147 | 2 | 147 | 1 | 147 | 0.464905514614349 | 0.464905514614349 | false | true | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 193701701095.00 | 2026-10-28 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T16:48:10.363261Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| ea2ee779-b9b6-4c11-98d9-28cb5a5175b1 | 2026-09-15 10:59 | 2026-09-15 10:58 | 2026-09-15 10:58 | APH | APH261016P00065000 | put | 65.0000 | 2026-10-16 | 0.3700 | 0.3500 | 0.5000 | 77.0000 | 407000.00 | 0.00 | 407000.00 | 11000 | 2 | 11001 | 3387 | 3.24800708591674 | 0.442080045719856 | 0.457330642655934 | false | true | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 193701701095.00 | 2026-10-28 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T15:09:54.469160Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| d7491107-49e7-4893-8509-dffee098ce03 | 2026-09-15 09:56 | 2026-09-15 09:56 | 2026-09-15 09:56 | APH | APH261218C00067500 | call | 67.5000 | 2026-12-18 | 14.0000 | 13.8000 | 14.0000 | 78.2100 | 77000.00 | 77000.00 | 0.00 | 55 | 18 | 301 | 434 | 0.693548387096774 | 0.471436878293015 | 0.471436878293015 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 193701701095.00 | 2026-10-28 | premarket | — | 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 |
| bec7c648-1731-41bd-9da8-c93303b32078 | 2026-09-15 09:56 | 2026-09-15 09:56 | 2026-09-15 09:56 | APH | APH261218C00067500 | call | 67.5000 | 2026-12-18 | 14.0000 | 13.5000 | 14.0000 | 78.1300 | 291200.00 | 291200.00 | 0.00 | 208 | 35 | 213 | 434 | 0.490783410138249 | 0.476733467357249 | 0.476733467357249 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 193701701095.00 | 2026-10-28 | premarket | — | 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 |