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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8f746c3c-a239-4121-ad3d-02b0e2dc7de0 | 2026-08-19 10:32 | 2026-08-19 10:32 | 2026-08-19 10:32 | SSRM | SSRM260918C00037000 | call | 37.0000 | 2026-09-18 | 1.5000 | 0.8500 | 1.6000 | 34.7900 | 90029.00 | 89879.00 | 150.00 | 602 | 37 | 602 | 116 | 5.18965517241379 | 0.577689206817888 | 0.58729739340028 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 42a3b9e1-9994-489c-8cc9-ef905b6dc045 | 2026-08-19 12:09 | 2026-08-19 12:09 | 2026-08-19 12:09 | SSRM | SSRM261218C00046000 | call | 46.0000 | 2026-12-18 | 2.0500 | 1.9000 | 2.1000 | 35.3100 | 22754.00 | 22754.00 | 0.00 | 111 | 28 | 111 | 3 | 37 | 0.626613462563056 | 0.625760866606622 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:28:32.259187Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4ade4857-e423-4d2a-8543-cd7a8c823568 | 2026-08-19 14:35 | 2026-08-19 14:35 | 2026-08-19 14:35 | SSRM | SSRM260821C00035000 | call | 35.0000 | 2026-08-21 | 0.6500 | 0.4000 | 0.6500 | 34.6800 | 41655.00 | 41655.00 | 0.00 | 641 | 38 | 678 | 233 | 2.90987124463519 | 0.774469957591133 | 0.774469957591133 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T18:37:13.611011Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f7a01371-9b4d-4788-ad72-6d5fd8788ab9 | 2026-08-19 15:05 | 2026-08-19 15:05 | 2026-08-19 15:05 | SSRM | SSRM261218C00046000 | call | 46.0000 | 2026-12-18 | 1.9500 | 1.7500 | 2.0000 | 34.9300 | 31200.00 | 31200.00 | 0.00 | 160 | 12 | 273 | 3 | 91 | 0.628053185795586 | 0.627629670141827 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 915e2e3d-0664-4794-b629-9041c1ab5561 | 2026-08-20 11:17 | 2026-08-20 11:17 | 2026-08-20 11:17 | SSRM | SSRM270115P00030000 | put | 30.0000 | 2027-01-15 | 2.4000 | 2.3500 | 2.4000 | 36.3200 | 11040.00 | 11040.00 | 0.00 | 46 | 8 | 147 | 123 | 1.19512195121951 | 0.615011235776904 | 0.615011235776904 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| eb9a1023-c6e1-41b2-b741-1acf1d56890c | 2026-08-20 12:28 | 2026-08-20 12:28 | 2026-08-20 12:28 | SSRM | SSRM260918P00029000 | put | 29.0000 | 2026-09-18 | 0.2500 | 0.2500 | 0.3500 | 35.7000 | 10925.00 | 0.00 | 10925.00 | 437 | 15 | 440 | 267 | 1.64794007490637 | 0.583902306341537 | 0.583902306341537 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T16:44:56.732853Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0b1b4755-5fda-43eb-b776-d5dd450e0c02 | 2026-08-21 10:40 | 2026-08-21 10:39 | 2026-08-21 10:39 | SSRM | SSRM261016C00040000 | call | 40.0000 | 2026-10-16 | 2.2800 | 2.0000 | 2.4000 | 36.9700 | 56998.00 | 56998.00 | 0.00 | 250 | 6 | 253 | 0 | 0 | 0.580434353907192 | 0.580434353907192 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T14:50:41.871179Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 833f68c1-ea2e-4ef7-9dc3-7229cd1b5469 | 2026-08-25 11:19 | 2026-08-25 11:19 | 2026-08-25 11:19 | SSRM | SSRM270115C00043000 | call | 43.0000 | 2027-01-15 | 4.6000 | 4.5000 | 4.7000 | 38.6300 | 11960.00 | 11040.00 | 460.00 | 26 | 7 | 46 | 18 | 2.55555555555556 | 0.63021489596294 | 0.625688499851939 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b7387781-9b68-4d9e-829e-33b1f69fc45c | 2026-08-25 11:21 | 2026-08-25 11:20 | 2026-08-25 11:20 | SSRM | SSRM270115C00043000 | call | 43.0000 | 2027-01-15 | 4.7000 | 4.6000 | 4.8000 | 38.8000 | 10808.00 | 10338.00 | 470.00 | 23 | 9 | 123 | 18 | 6.83333333333333 | 0.627949063329134 | 0.627465545049529 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cfcced62-d34e-4d05-bee4-1b5c52734076 | 2026-08-25 12:32 | 2026-08-25 12:31 | 2026-08-25 12:31 | SSRM | SSRM261218C00055000 | call | 55.0000 | 2026-12-18 | 1.5500 | 1.3000 | 1.7500 | 38.9500 | 392150.00 | 392150.00 | 0.00 | 2530 | 1 | 2555 | 0 | 0 | 0.637658062706959 | 0.637658062706959 | false | true | false | true | true | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T16:59:46.608693Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 11e3f94a-2a4b-4578-9d16-7032fc7367a8 | 2026-08-26 15:39 | 2026-08-26 15:38 | 2026-08-26 15:38 | SSRM | SSRM261218C00055000 | call | 55.0000 | 2026-12-18 | 1.5000 | 1.4000 | 1.5000 | 38.3800 | 24740.00 | 24740.00 | 0.00 | 165 | 13 | 420 | 2963 | 0.141748228147148 | 0.653448737061089 | 0.652581860085125 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | 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 |
| 441a5d99-6660-47f0-b556-379240ab5af5 | 2026-08-28 11:56 | 2026-08-28 11:56 | 2026-08-28 11:56 | SSRM | SSRM261016P00033000 | put | 33.0000 | 2026-10-16 | 1.2000 | 1.1000 | 1.2000 | 37.0000 | 77640.00 | 77640.00 | 0.00 | 647 | 22 | 648 | 17 | 38.1176470588235 | 0.587122056748073 | 0.587122056748073 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6ce9f80f-42e9-4e9a-b097-7d84dde15220 | 2026-08-28 13:56 | 2026-08-28 13:56 | 2026-08-28 13:56 | SSRM | SSRM261016C00040000 | call | 40.0000 | 2026-10-16 | 2.3000 | 2.1500 | 2.3000 | 37.1700 | 17020.00 | 17020.00 | 0.00 | 74 | 6 | 260 | 302 | 0.860927152317881 | 0.615818764613238 | 0.615818764613238 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T18:18:32.282709Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1a596855-d954-4af3-8db3-2f6b1889d4e3 | 2026-09-02 09:45 | 2026-09-02 09:45 | 2026-09-02 09:45 | SSRM | SSRM270115C00043000 | call | 43.0000 | 2027-01-15 | 3.9000 | 3.1000 | 4.2000 | 37.5500 | 112320.00 | 10140.00 | 93600.00 | 288 | 6 | 288 | 159 | 1.81132075471698 | 0.623773713800055 | 0.623773713800055 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | 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 |
| 1a0d41c4-5ed5-475e-80c0-57c889af6769 | 2026-09-02 09:46 | 2026-09-02 09:46 | 2026-09-02 09:46 | SSRM | SSRM270115C00043000 | call | 43.0000 | 2027-01-15 | 3.8000 | 3.7000 | 4.0000 | 37.4000 | 60040.00 | 11400.00 | 44080.00 | 158 | 17 | 446 | 159 | 2.80503144654088 | 0.620102399543123 | 0.620102399543123 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | 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 |
| bb56289c-c36c-40ff-973f-b4108c48b42d | 2026-09-02 10:53 | 2026-09-02 10:53 | 2026-09-02 10:53 | SSRM | SSRM270115C00043000 | call | 43.0000 | 2027-01-15 | 3.6000 | 3.5000 | 3.8000 | 37.0800 | 144000.00 | 5040.00 | 76680.00 | 400 | 9 | 1000 | 159 | 6.28930817610063 | 0.613391647036646 | 0.613391647036646 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | 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 |
| 88f6694a-8448-451c-9698-470b687d2e2a | 2026-09-03 10:45 | 2026-09-03 10:45 | 2026-09-03 10:45 | SSRM | SSRM280121C00035000 | call | 35.0000 | 2028-01-21 | 13.1000 | 12.6000 | 13.3500 | 38.5750 | 13100.00 | 13100.00 | 0.00 | 10 | 5 | 403 | 834 | 0.483213429256595 | 0.622337537968058 | 0.622337537968058 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T14:57:35.447301Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b522f7d8-f848-4848-98fd-8949e08fcc25 | 2026-09-03 10:48 | 2026-09-03 10:48 | 2026-09-03 10:48 | SSRM | SSRM280121C00035000 | call | 35.0000 | 2028-01-21 | 13.0500 | 12.8000 | 13.8000 | 38.6500 | 35230.00 | 5200.00 | 30030.00 | 27 | 5 | 430 | 834 | 0.515587529976019 | 0.612382476448675 | 0.620805407027924 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T14:57:35.447301Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 793bdbed-eb09-40c0-b566-8ddccdb0c901 | 2026-09-11 10:02 | 2026-09-11 10:02 | 2026-09-11 10:02 | SSRM | SSRM270115C00035000 | call | 35.0000 | 2027-01-15 | 6.1400 | 5.9000 | 7.1000 | 36.9200 | 18420.00 | 0.00 | 18420.00 | 30 | 7 | 30 | 3110 | 0.00964630225080386 | 0.551583682413262 | 0.610945769877989 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T14:11:33.656123Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f0e2c164-e363-4cc1-bfc5-3339f788c61b | 2026-09-11 13:54 | 2026-09-11 13:54 | 2026-09-11 13:54 | SSRM | SSRM280121C00035000 | call | 35.0000 | 2028-01-21 | 11.3200 | 11.3000 | 12.0000 | 36.3700 | 56620.00 | 0.00 | 47580.00 | 50 | 6 | 50 | 647 | 0.0772797527047913 | 0.598342601200064 | 0.60727212975333 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T18:02:32.717866Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7856b62f-8053-452b-81dc-60ba9b9a77d3 | 2026-09-14 11:56 | 2026-09-14 11:56 | 2026-09-14 11:56 | SSRM | SSRM261218C00055000 | call | 55.0000 | 2026-12-18 | 0.7000 | 0.6500 | 0.7500 | 34.7700 | 16790.00 | 1530.00 | 15260.00 | 239 | 13 | 1004 | 3168 | 0.316919191919192 | 0.681740382662837 | 0.681740382662837 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T16:02:31.142849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4534e10b-aaea-4609-936f-25d970e0f709 | 2026-09-14 11:58 | 2026-09-14 11:58 | 2026-09-14 11:58 | SSRM | SSRM261218C00055000 | call | 55.0000 | 2026-12-18 | 0.7000 | 0.6500 | 0.7000 | 34.8800 | 16870.00 | 16870.00 | 0.00 | 241 | 6 | 3508 | 3168 | 1.10732323232323 | 0.677910148065381 | 0.677910148065381 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T16:02:31.142849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dfe9df12-8be5-448b-850f-8bb02c80dbba | 2026-09-18 11:51 | 2026-09-18 11:51 | 2026-09-18 11:51 | SSRM | SSRM280121C00035000 | call | 35.0000 | 2028-01-21 | 11.0100 | 11.0000 | 11.9000 | 36.0700 | 37450.00 | 0.00 | 29750.00 | 34 | 5 | 34 | 601 | 0.0565723793677205 | 0.596652608834387 | 0.600018478374563 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 7408025305.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |