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.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| b1cb15b0-3156-41a1-949e-81edfe8c8e6a | 2026-09-18 15:14 | 2026-09-18 15:14 | 2026-09-18 15:14 | ESI | ESI261016C00034000 | call | 34.0000 | 2026-10-16 | 1.0400 | 1.0000 | 1.1500 | 32.7650 | 25994.00 | 0.00 | 25994.00 | 250 | 6 | 305 | 102 | 2.99019607843137 | 0.421802260625138 | 0.421802260625138 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7976003615.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 743eb0d8-4079-4077-8519-9ea91529fc1f | 2026-09-14 10:49 | 2026-09-14 10:48 | 2026-09-14 10:48 | ESI | ESI260918P00032000 | put | 32.0000 | 2026-09-18 | 0.9000 | 0.7000 | 0.9000 | 31.8100 | 15030.00 | 15030.00 | 0.00 | 167 | 36 | 192 | 2 | 96 | 0.607045184958769 | 0.607045184958769 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7d51cd36-3808-4268-975a-8e27a5882c9a | 2026-09-08 14:05 | 2026-09-08 14:05 | 2026-09-08 14:05 | ESI | ESI260918C00035000 | call | 35.0000 | 2026-09-18 | 1.8500 | 1.6000 | 2.1500 | 36.1900 | 13884.00 | 2256.00 | 11628.00 | 75 | 10 | 700 | 1573 | 0.445009535918627 | 0.496367212516158 | 0.496367212516158 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T18:15:47.972880Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a325a6ab-3eb9-42c4-832e-d1c6adbf399f | 2026-09-08 10:00 | 2026-09-08 10:00 | 2026-09-08 10:00 | ESI | ESI260918C00036000 | call | 36.0000 | 2026-09-18 | 1.5000 | 1.2500 | 1.6500 | 36.5200 | 15000.00 | 2400.00 | 9000.00 | 100 | 32 | 107 | 3494 | 0.0306239267315398 | 0.49940552136634 | 0.501918427868901 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T14:14:21.867252Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e701a592-4928-4cc5-85a6-cf07be06f37d | 2026-09-04 15:56 | 2026-09-04 15:56 | 2026-09-04 15:56 | ESI | ESI260918C00036000 | call | 36.0000 | 2026-09-18 | 1.3000 | 1.0000 | 1.3000 | 36.0700 | 32500.00 | 32500.00 | 0.00 | 250 | 6 | 250 | 3315 | 0.0754147812971342 | 0.440031483207569 | 0.440031483207569 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T20:00:02.053596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 901a3d32-ba55-47bc-9d91-7f09f6ed45e8 | 2026-09-04 15:54 | 2026-09-04 15:54 | 2026-09-04 15:54 | ESI | ESI260918C00035000 | call | 35.0000 | 2026-09-18 | 1.8200 | 1.4500 | 2.9000 | 36.0350 | 13639.00 | 0.00 | 13639.00 | 75 | 9 | 95 | 1573 | 0.0603941513032422 | 0.440362545942728 | 0.440362545942728 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T20:00:02.053596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1cc42b4e-f8e1-45c4-99e4-bbf260b76687 | 2026-09-04 15:43 | 2026-09-04 15:43 | 2026-09-04 15:43 | ESI | ESI260918P00034000 | put | 34.0000 | 2026-09-18 | 0.6000 | 0.5500 | 0.6000 | 36.0800 | 29991.00 | 29991.00 | 0.00 | 500 | 53 | 1173 | 1288 | 0.910714285714286 | 0.518575813239295 | 0.518575813239295 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T19:47:04.296573Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 32dd8c06-6934-45e9-8753-940f5d51d8ce | 2026-09-04 15:36 | 2026-09-04 15:36 | 2026-09-04 15:36 | ESI | ESI260918P00034000 | put | 34.0000 | 2026-09-18 | 0.5000 | 0.5000 | 0.6000 | 36.1000 | 18100.00 | 0.00 | 1550.00 | 362 | 43 | 363 | 1288 | 0.281832298136646 | 0.4773030517523 | 0.476210909980279 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T19:47:04.296573Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 52ef8071-3817-4d61-8656-2f4ace94996d | 2026-09-03 11:15 | 2026-09-03 11:15 | 2026-09-03 11:15 | ESI | ESI260918C00036000 | call | 36.0000 | 2026-09-18 | 0.5800 | 0.2000 | 0.6500 | 34.3200 | 116000.00 | 116000.00 | 0.00 | 2000 | 2 | 2015 | 1296 | 1.55478395061728 | 0.418901905664666 | 0.418901905664666 | false | true | false | true | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T15:27:44.291947Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ea47f3a1-96f2-4c06-ba0c-066d7680508f | 2026-09-02 12:55 | 2026-09-02 12:55 | 2026-09-02 12:55 | ESI | ESI260918C00035000 | call | 35.0000 | 2026-09-18 | 1.0000 | 1.0000 | 1.2000 | 34.5800 | 10001.00 | 0.00 | 9201.00 | 100 | 24 | 450 | 1122 | 0.401069518716578 | 0.403665880475044 | 0.403665880475044 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T16:56:20.498446Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 899c7156-c116-42c6-88be-04fd4e5492e1 | 2026-09-02 12:14 | 2026-09-02 12:14 | 2026-09-02 12:14 | ESI | ESI260918C00035000 | call | 35.0000 | 2026-09-18 | 1.1000 | 1.0500 | 1.3000 | 34.7500 | 11000.00 | 880.00 | 10120.00 | 100 | 21 | 250 | 1122 | 0.222816399286988 | 0.41003981587981 | 0.41003981587981 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T16:19:14.278097Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c3cc1b55-e21c-40f7-9b19-068d7ffe5b04 | 2026-09-01 14:45 | 2026-09-01 14:45 | 2026-09-01 14:45 | ESI | ESI270219C00035000 | call | 35.0000 | 2027-02-19 | 3.8000 | 3.6000 | 4.8000 | 34.1050 | 1841480.00 | 0.00 | 1841480.00 | 4846 | 1 | 4846 | 62 | 78.1612903225806 | 0.421096693611755 | 0.421096693611755 | false | true | false | true | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T18:58:03.753197Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cb430fe0-6f25-498d-b6cb-5a10a5ef4039 | 2026-09-01 14:05 | 2026-09-01 14:05 | 2026-09-01 14:05 | ESI | ESI260918C00035000 | call | 35.0000 | 2026-09-18 | 1.0000 | 0.9000 | 1.0500 | 34.1950 | 11975.00 | 11975.00 | 0.00 | 120 | 22 | 355 | 844 | 0.420616113744076 | 0.44996011072037 | 0.44996011072037 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T18:15:43.135015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5c4a656e-f0ec-428f-9801-87a9afdb83fe | 2026-08-28 12:16 | 2026-08-28 12:15 | 2026-08-28 12:15 | ESI | ESI260918P00035000 | put | 35.0000 | 2026-09-18 | 1.6000 | 1.2000 | 1.8500 | 34.5900 | 41120.00 | 10560.00 | 30560.00 | 257 | 19 | 315 | 4 | 78.75 | 0.429285401498347 | 0.429285401498347 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:25:17.992358Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 807ae3e6-c096-437b-89f0-e167725555b0 | 2026-08-28 10:43 | 2026-08-28 10:43 | 2026-08-28 10:43 | ESI | ESI260918C00037000 | call | 37.0000 | 2026-09-18 | 1.3000 | 1.0000 | 1.3500 | 36.5200 | 11180.00 | 4420.00 | 6760.00 | 86 | 11 | 1026 | 10 | 102.6 | 0.423837486024678 | 0.424522342843507 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:54:23.998586Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b147df59-bf83-499e-aabd-368488b63507 | 2026-08-28 10:41 | 2026-08-28 10:41 | 2026-08-28 10:41 | ESI | ESI260918C00037000 | call | 37.0000 | 2026-09-18 | 1.3500 | 1.3000 | 1.4000 | 36.6600 | 13500.00 | 0.00 | 12690.00 | 100 | 6 | 937 | 10 | 93.7 | 0.419409083043317 | 0.419409083043317 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:54:23.998586Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 00fe3c27-d7a3-4ab1-bbe6-17aa20f54323 | 2026-08-28 10:25 | 2026-08-28 10:25 | 2026-08-28 10:25 | ESI | ESI260918C00037000 | call | 37.0000 | 2026-09-18 | 1.3500 | 1.3000 | 1.3500 | 36.5550 | 13500.00 | 13500.00 | 0.00 | 100 | 31 | 737 | 10 | 73.7 | 0.434026721788117 | 0.434026721788117 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:38:22.875878Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4c38c4af-3c20-4d48-940a-d057fdca71a6 | 2026-08-28 10:22 | 2026-08-28 10:22 | 2026-08-28 10:22 | ESI | ESI260918C00037000 | call | 37.0000 | 2026-09-18 | 1.3000 | 1.3000 | 1.3500 | 36.5900 | 14690.00 | 0.00 | 14690.00 | 113 | 10 | 513 | 10 | 51.3 | 0.414888880302286 | 0.414888880302286 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:22:34.427319Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b6be5dc1-d667-430c-a082-995a647a9f03 | 2026-08-28 10:12 | 2026-08-28 10:12 | 2026-08-28 10:12 | ESI | ESI260918C00037000 | call | 37.0000 | 2026-09-18 | 1.3000 | 1.0000 | 1.3000 | 36.6600 | 30930.00 | 30930.00 | 0.00 | 238 | 34 | 400 | 10 | 40 | 0.40369783977941 | 0.405152768261394 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:22:34.427319Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 79c51f4a-7d42-4063-815a-467c27818437 | 2026-08-27 13:15 | 2026-08-27 13:15 | 2026-08-27 13:15 | ESI | ESI261120C00035000 | call | 35.0000 | 2026-11-20 | 3.9000 | 3.1000 | 4.6000 | 36.4000 | 587730.00 | 587730.00 | 0.00 | 1507 | 2 | 1507 | 1 | 1507 | 0.434243166570149 | 0.434243166570149 | false | true | true | false | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ae57578d-ff95-4d0a-bbb2-5f0f64a2d7f4 | 2026-08-20 12:13 | 2026-08-20 12:13 | 2026-08-20 12:13 | ESI | ESI260821C00035000 | call | 35.0000 | 2026-08-21 | 0.6500 | 0.6500 | 2.0000 | 35.4500 | 11050.00 | 0.00 | 11050.00 | 170 | 34 | 4670 | 2009 | 2.32453957192633 | 0.518034535768642 | 0.518034535768642 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |