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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25d9318c-45a0-4004-9a65-c877752a723f | 2026-09-18 14:21 | 2026-09-18 14:21 | 2026-09-18 14:21 | KMX | KMX270416P00062500 | put | 62.5000 | 2027-04-16 | 11.0800 | 10.6000 | 11.9000 | 56.6100 | 22153.00 | 0.00 | 22153.00 | 20 | 5 | 91 | 37 | 2.45945945945946 | 0.494305427353569 | 0.494305427353569 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 8118733802.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 7a1e96cb-8672-4429-9b11-92d3c3c7684e | 2026-09-17 13:40 | 2026-09-17 13:40 | 2026-09-17 13:40 | KMX | KMX260918C00055000 | call | 55.0000 | 2026-09-18 | 3.5900 | 2.8500 | 3.9000 | 58.5000 | 10784.00 | 10784.00 | 0.00 | 30 | 6 | 40 | 349 | 0.114613180515759 | 0.82553575236314 | 0.82553575236314 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 8284769784.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 1ccca147-be79-4a2c-bc2a-cf20cecaca77 | 2026-09-14 12:09 | 2026-09-14 12:09 | 2026-09-14 12:09 | KMX | KMX280121C00090000 | call | 90.0000 | 2028-01-21 | 6.5200 | 5.7000 | 7.0000 | 61.8200 | 65171.00 | 10400.00 | 54771.00 | 100 | 15 | 102 | 557 | 0.183123877917415 | 0.466101050896132 | 0.472417066312764 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T16:23:59.234542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fb9cdddb-7dde-45b8-acb7-1c91c4335f80 | 2026-09-11 14:50 | 2026-09-11 14:50 | 2026-09-11 14:50 | KMX | KMX261218P00062500 | put | 62.5000 | 2026-12-18 | 6.9000 | 6.3000 | 7.0000 | 61.3400 | 11040.00 | 4830.00 | 6210.00 | 16 | 5 | 16 | 0 | 0 | 0.524849526991237 | 0.524849526991237 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T19:04:54.864587Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2b41ac50-0308-4e55-ba15-342dd7edd740 | 2026-09-11 12:55 | 2026-09-11 12:55 | 2026-09-11 12:55 | KMX | KMX260918C00062500 | call | 62.5000 | 2026-09-18 | 1.1000 | 1.0500 | 1.1500 | 61.8900 | 11660.00 | 5170.00 | 5720.00 | 106 | 24 | 265 | 1883 | 0.14073287307488 | 0.394266589730656 | 0.396900591811053 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T17:27:08.545704Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 67d79871-aed0-4607-b9fe-a199c33d58ea | 2026-09-11 09:39 | 2026-09-11 09:39 | 2026-09-11 09:39 | KMX | KMX261016P00045000 | put | 45.0000 | 2026-10-16 | 0.2000 | 0.2000 | 0.3500 | 61.5700 | 10300.00 | 0.00 | 10300.00 | 515 | 5 | 515 | 1558 | 0.330551989730424 | 0.616354737522002 | 0.616354737522002 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T13:46:58.036194Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0af0da98-3379-4e39-8d26-00045a19fc16 | 2026-09-11 09:39 | 2026-09-11 09:39 | 2026-09-11 09:39 | KMX | KMX261016P00045000 | put | 45.0000 | 2026-10-16 | 0.2000 | 0.2000 | 0.3500 | 61.5700 | 11520.00 | 0.00 | 11520.00 | 576 | 16 | 1500 | 1558 | 0.962772785622593 | 0.616354737522002 | 0.616354737522002 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T13:46:58.036194Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e4f23b48-d90a-4d92-8821-d2d87afb5220 | 2026-09-10 12:18 | 2026-09-10 12:18 | 2026-09-10 12:18 | KMX | KMX261016P00060000 | put | 60.0000 | 2026-10-16 | 4.0000 | 3.9000 | 4.0000 | 60.3800 | 40000.00 | 40000.00 | 0.00 | 100 | 6 | 112 | 103 | 1.0873786407767 | 0.571961108009464 | 0.571961108009464 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T16:37:06.868856Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c59fbb07-0796-4356-9c7c-c167dc49a3f4 | 2026-09-10 11:06 | 2026-09-10 11:06 | 2026-09-10 11:06 | KMX | KMX261016P00045000 | put | 45.0000 | 2026-10-16 | 0.3500 | 0.2000 | 0.3500 | 60.5800 | 26250.00 | 26250.00 | 0.00 | 750 | 20 | 1500 | 109 | 13.7614678899083 | 0.659701556080078 | 0.659701556080078 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T15:21:12.723015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 020d7d8a-4fe1-419c-89e5-728cee2e8206 | 2026-09-04 10:44 | 2026-09-04 10:44 | 2026-09-04 10:44 | KMX | KMX270416P00062500 | put | 62.5000 | 2027-04-16 | 8.6500 | 8.3000 | 8.9000 | 62.7650 | 43230.00 | 43230.00 | 0.00 | 50 | 9 | 150 | 2 | 75 | 0.495238670268681 | 0.495238670268681 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 72a47ad7-ba4f-4356-8010-62a7bb08a224 | 2026-09-04 10:42 | 2026-09-04 10:42 | 2026-09-04 10:42 | KMX | KMX270416P00062500 | put | 62.5000 | 2027-04-16 | 8.6100 | 8.3000 | 8.9000 | 62.8800 | 43030.00 | 20690.00 | 17180.00 | 50 | 10 | 100 | 2 | 50 | 0.495511425820174 | 0.495511425820174 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | 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 |
| c8b74da0-2a96-4b7b-9353-eb7d3932fa3c | 2026-09-04 10:41 | 2026-09-04 10:41 | 2026-09-04 10:41 | KMX | KMX270416P00062500 | put | 62.5000 | 2027-04-16 | 8.5800 | 8.3000 | 9.0000 | 62.8301 | 34334.00 | 0.00 | 34334.00 | 40 | 8 | 50 | 2 | 25 | 0.493420125503457 | 0.493420125503457 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | 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 |
| 650ad52a-f8c3-453e-a157-d91495f021c1 | 2026-09-01 12:04 | 2026-09-01 12:04 | 2026-09-01 12:04 | KMX | KMX260918C00062500 | call | 62.5000 | 2026-09-18 | 1.5500 | 1.4000 | 1.5500 | 60.8400 | 25265.00 | 25265.00 | 0.00 | 163 | 21 | 409 | 1542 | 0.265239948119326 | 0.422314444903642 | 0.422314444903642 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T16:07:53.122506Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2f643cf3-0f97-4375-8e6a-111beb49332d | 2026-08-28 11:40 | 2026-08-28 11:40 | 2026-08-28 11:40 | KMX | KMX270115C00075000 | call | 75.0000 | 2027-01-15 | 3.7800 | 3.6000 | 3.9000 | 62.0000 | 22676.00 | 19731.00 | 2945.00 | 60 | 12 | 60 | 244 | 0.245901639344262 | 0.482735339839908 | 0.484130763514156 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T15:52:06.240394Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 21f0e205-7d4f-497a-82c1-c8e3a59cc451 | 2026-08-28 11:40 | 2026-08-28 11:40 | 2026-08-28 11:40 | KMX | KMX261016C00055000 | call | 55.0000 | 2026-10-16 | 9.7200 | 9.4000 | 9.8000 | 62.0000 | 17494.00 | 14590.00 | 2904.00 | 18 | 6 | 19 | 203 | 0.0935960591133005 | 0.52849402030381 | 0.549375643220503 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T15:52:06.240394Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c97959ed-d72f-4a4c-8c73-10cf50f96320 | 2026-08-27 13:39 | 2026-08-27 13:39 | 2026-08-27 13:39 | KMX | KMX260918P00060000 | put | 60.0000 | 2026-09-18 | 1.2500 | 1.2000 | 1.3000 | 62.8250 | 12500.00 | 4750.00 | 0.00 | 100 | 5 | 107 | 109 | 0.981651376146789 | 0.408308003306497 | 0.408308003306497 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T17:46:53.178792Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 905b94de-ae3f-47d6-8884-0e94bd0badc5 | 2026-08-26 15:20 | 2026-08-26 15:20 | 2026-08-26 15:20 | KMX | KMX261120P00067500 | put | 67.5000 | 2026-11-20 | 7.8000 | 7.5000 | 7.9000 | 63.9100 | 12480.00 | 3120.00 | 9360.00 | 16 | 5 | 24 | 15 | 1.6 | 0.490559337150073 | 0.490559337150073 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T19:41:15.773512Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 05b9e5e9-609a-482d-b324-cb0998a1dc48 | 2026-08-26 12:21 | 2026-08-26 12:21 | 2026-08-26 12:21 | KMX | KMX261120P00070000 | put | 70.0000 | 2026-11-20 | 9.4000 | 9.2000 | 9.6000 | 63.9700 | 15980.00 | 4700.00 | 11280.00 | 17 | 9 | 28 | 0 | 0 | 0.492512897022464 | 0.492512897022464 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T16:52:20.196728Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 506450d8-0abc-4d3b-a3f4-cdb267e906f4 | 2026-08-25 11:49 | 2026-08-25 11:49 | 2026-08-25 11:49 | KMX | KMX280121C00090000 | call | 90.0000 | 2028-01-21 | 8.3000 | 7.8000 | 8.3000 | 64.0200 | 62240.00 | 62240.00 | 0.00 | 75 | 12 | 75 | 515 | 0.145631067961165 | 0.482731190231926 | 0.482731190231926 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bd64dc65-40a7-4da4-8b79-0d6ed89d155b | 2026-08-21 11:38 | 2026-08-21 11:38 | 2026-08-21 11:38 | KMX | KMX260918C00067500 | call | 67.5000 | 2026-09-18 | 1.2200 | 1.1500 | 1.2500 | 62.5500 | 13914.00 | 9594.00 | 4200.00 | 114 | 9 | 2339 | 463 | 5.05183585313175 | 0.423116249358513 | 0.423116249358513 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d011b9cf-7067-4cea-a2d3-4cefa6f7cff1 | 2026-08-21 11:06 | 2026-08-21 11:06 | 2026-08-21 11:06 | KMX | KMX261016C00065000 | call | 65.0000 | 2026-10-16 | 3.9000 | 3.9000 | 4.5000 | 62.9600 | 54600.00 | 0.00 | 54600.00 | 140 | 6 | 140 | 551 | 0.254083484573503 | 0.470648190491965 | 0.470648190491965 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3fde96bd-cc7f-468f-a933-c141ac872882 | 2026-08-21 11:04 | 2026-08-21 11:04 | 2026-08-21 11:04 | KMX | KMX260918C00067500 | call | 67.5000 | 2026-09-18 | 1.3000 | 1.2500 | 1.3000 | 62.9250 | 14940.00 | 14940.00 | 0.00 | 115 | 6 | 735 | 463 | 1.58747300215983 | 0.414816288006844 | 0.416468596360938 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 70e86166-54e6-4e79-a9b3-8c13f1a2f3c7 | 2026-08-19 13:01 | 2026-08-19 13:01 | 2026-08-19 13:01 | KMX | KMX260918C00060000 | call | 60.0000 | 2026-09-18 | 2.4000 | 2.3500 | 2.5500 | 59.0600 | 13435.00 | 0.00 | 13435.00 | 56 | 21 | 490 | 1164 | 0.420962199312715 | 0.404185418911086 | 0.398909311852556 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 8754495512.00 | 2026-09-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:16:43.855599Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |