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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cea5dfd8-4c42-43d7-9e00-8f6f7702b211 | 2026-08-19 13:43 | 2026-08-19 13:43 | 2026-08-19 13:43 | CENX | CENX261016P00045000 | put | 45.0000 | 2026-10-16 | 4.4000 | 3.9000 | 4.4000 | 46.0150 | 36959.00 | 32120.00 | 439.00 | 84 | 12 | 187 | 72 | 2.59722222222222 | 0.697664691309165 | 0.697664691309165 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c338249d-2612-401e-ae3d-72d913a92ef6 | 2026-08-19 13:43 | 2026-08-19 13:43 | 2026-08-19 13:43 | CENX | CENX261120P00045000 | put | 45.0000 | 2026-11-20 | 5.9000 | 5.4000 | 5.9000 | 46.0150 | 185839.00 | 185839.00 | 0.00 | 315 | 23 | 316 | 114 | 2.7719298245614 | 0.728222584708285 | 0.728222584708285 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 049c7584-7d3b-4b8a-882b-94dddeb12b4f | 2026-08-19 13:43 | 2026-08-19 13:43 | 2026-08-19 13:43 | CENX | CENX260918P00046000 | put | 46.0000 | 2026-09-18 | 3.5000 | 3.0000 | 3.5000 | 46.0150 | 44082.00 | 20282.00 | 0.00 | 126 | 17 | 126 | 143 | 0.881118881118881 | 0.682164623391939 | 0.682164623391939 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3005abb7-dbd1-41c9-ae92-0bcf3a77108c | 2026-08-19 13:45 | 2026-08-19 13:45 | 2026-08-19 13:45 | CENX | CENX261120P00030000 | put | 30.0000 | 2026-11-20 | 0.9500 | 0.6500 | 1.5500 | 44.4800 | 40850.00 | 40470.00 | 380.00 | 430 | 8 | 540 | 88 | 6.13636363636364 | 0.752500407907272 | 0.738351305252596 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aa4159ce-0a52-4fc3-90f8-acc040ebd549 | 2026-08-19 15:38 | 2026-08-19 15:38 | 2026-08-19 15:38 | CENX | CENX261120P00045000 | put | 45.0000 | 2026-11-20 | 6.9000 | 6.7000 | 6.9000 | 42.9200 | 48300.00 | 48300.00 | 0.00 | 70 | 11 | 390 | 114 | 3.42105263157895 | 0.689994065482468 | 0.689994065482468 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 33e3efc1-1688-48e4-a3f3-1855649854a5 | 2026-08-20 11:25 | 2026-08-20 11:25 | 2026-08-20 11:25 | CENX | CENX261016P00045000 | put | 45.0000 | 2026-10-16 | 5.2000 | 5.1000 | 5.7000 | 43.5250 | 51950.00 | 0.00 | 51950.00 | 100 | 10 | 102 | 231 | 0.441558441558442 | 0.651580503552068 | 0.658869245610755 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | 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 |
| ed800669-3c52-46cf-95a5-b0ff6192751a | 2026-08-20 13:37 | 2026-08-20 13:37 | 2026-08-20 13:37 | CENX | CENX261016P00040000 | put | 40.0000 | 2026-10-16 | 2.9900 | 2.8500 | 3.5000 | 42.5800 | 29900.00 | 4425.00 | 25475.00 | 100 | 5 | 105 | 279 | 0.376344086021505 | 0.650574123680746 | 0.663450814604304 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6fd37b58-1c7f-4fc4-9267-06670b6075ba | 2026-08-21 13:51 | 2026-08-21 13:51 | 2026-08-21 13:51 | CENX | CENX261218C00045000 | call | 45.0000 | 2026-12-18 | 6.6000 | 6.2000 | 6.6000 | 43.5500 | 50820.00 | 50820.00 | 0.00 | 77 | 23 | 79 | 36 | 2.19444444444444 | 0.70664408479884 | 0.70664408479884 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:03:10.492596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 394a614c-3aea-4c27-8d4d-af54055a045d | 2026-08-24 09:50 | 2026-08-24 09:50 | 2026-08-24 09:50 | CENX | CENX260918C00050000 | call | 50.0000 | 2026-09-18 | 1.9500 | 1.7000 | 2.0500 | 45.9900 | 91455.00 | 89505.00 | 1950.00 | 469 | 28 | 500 | 868 | 0.576036866359447 | 0.726662854661022 | 0.712525697003677 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 60493974-8a0a-4049-96bf-efe30381d6e5 | 2026-08-24 10:02 | 2026-08-24 10:01 | 2026-08-24 10:01 | CENX | CENX261120C00060000 | call | 60.0000 | 2026-11-20 | 2.3500 | 1.9000 | 2.3500 | 45.7900 | 10340.00 | 10340.00 | 0.00 | 44 | 9 | 46 | 239 | 0.192468619246862 | 0.707212122549157 | 0.707212122549157 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 00a6ddb5-e1a7-499d-8d23-d41994be7b47 | 2026-08-24 11:10 | 2026-08-24 11:09 | 2026-08-24 11:09 | CENX | CENX261120P00035000 | put | 35.0000 | 2026-11-20 | 2.1500 | 1.9000 | 2.1500 | 45.0100 | 56545.00 | 56545.00 | 0.00 | 263 | 44 | 263 | 76 | 3.46052631578947 | 0.770228068916472 | 0.770228068916472 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T15:29:12.492303Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7ee8a28c-322e-4309-aaf9-5f34b5222675 | 2026-08-24 13:25 | 2026-08-24 13:25 | 2026-08-24 13:25 | CENX | CENX261016C00045000 | call | 45.0000 | 2026-10-16 | 4.4000 | 4.1000 | 4.4000 | 44.1100 | 48400.00 | 48400.00 | 0.00 | 110 | 19 | 148 | 31 | 4.7741935483871 | 0.700026744603953 | 0.700026744603953 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T17:47:44.554262Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8539a3ae-5251-4099-98c4-33d7287789f1 | 2026-08-24 15:10 | 2026-08-24 15:10 | 2026-08-24 15:10 | CENX | CENX261120C00045000 | call | 45.0000 | 2026-11-20 | 5.9000 | 5.3000 | 5.9000 | 43.6700 | 27730.00 | 27730.00 | 0.00 | 47 | 16 | 49 | 8 | 6.125 | 0.738126725006341 | 0.738126725006341 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 705588bc-d167-44e2-a856-315028a83ca7 | 2026-08-25 09:55 | 2026-08-25 09:54 | 2026-08-25 09:54 | CENX | CENX260918P00045000 | put | 45.0000 | 2026-09-18 | 3.8000 | 3.2000 | 3.9000 | 43.8771 | 17850.00 | 17090.00 | 760.00 | 47 | 16 | 47 | 176 | 0.267045454545455 | 0.721215929633373 | 0.721215929633373 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 067dc128-7546-4a0f-a022-14a3e9f03eb1 | 2026-08-25 09:55 | 2026-08-25 09:54 | 2026-08-25 09:54 | CENX | CENX260918P00045000 | put | 45.0000 | 2026-09-18 | 3.8000 | 3.2000 | 3.8000 | 43.8771 | 23928.00 | 23928.00 | 0.00 | 63 | 11 | 110 | 176 | 0.625 | 0.721215929633373 | 0.721215929633373 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 975f658f-d98c-4b5e-baba-c3983fce9e91 | 2026-08-26 14:23 | 2026-08-26 14:23 | 2026-08-26 14:23 | CENX | CENX260918C00048000 | call | 48.0000 | 2026-09-18 | 1.4200 | 1.4000 | 1.5000 | 43.9300 | 13656.00 | 0.00 | 9306.00 | 96 | 10 | 151 | 340 | 0.444117647058824 | 0.659198285253814 | 0.659198285253814 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T18:39:51.047298Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8792774e-9a26-4aca-a2ac-8e6b492282f2 | 2026-08-27 10:40 | 2026-08-27 10:40 | 2026-08-27 10:40 | CENX | CENX261016C00045000 | call | 45.0000 | 2026-10-16 | 4.1000 | 4.1000 | 4.2000 | 44.3100 | 17630.00 | 0.00 | 17630.00 | 43 | 13 | 43 | 156 | 0.275641025641026 | 0.659203556381153 | 0.659203556381153 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T14:49:52.356548Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 96ef5a78-cac0-40bc-808b-a77810bc81f5 | 2026-08-31 12:06 | 2026-08-31 12:06 | 2026-08-31 12:06 | CENX | CENX261120C00050000 | call | 50.0000 | 2026-11-20 | 4.4000 | 4.3000 | 4.4000 | 45.6050 | 11000.00 | 11000.00 | 0.00 | 25 | 16 | 25 | 138 | 0.181159420289855 | 0.694604780356267 | 0.694604780356267 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c2dc31a5-923f-4f3b-85b8-6a290e1e1c24 | 2026-08-31 13:01 | 2026-08-31 13:01 | 2026-08-31 13:01 | CENX | CENX261016P00040000 | put | 40.0000 | 2026-10-16 | 1.7500 | 1.5500 | 2.3000 | 45.6700 | 12075.00 | 700.00 | 11375.00 | 69 | 6 | 85 | 441 | 0.192743764172336 | 0.666737103659223 | 0.666737103659223 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T17:08:52.274087Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 41d7ef5b-64f3-4734-a7c4-d7795f649c23 | 2026-09-02 11:35 | 2026-09-02 11:34 | 2026-09-02 11:34 | CENX | CENX261016C00055000 | call | 55.0000 | 2026-10-16 | 1.7000 | 1.5000 | 1.7000 | 47.3300 | 16830.00 | 1190.00 | 0.00 | 99 | 17 | 99 | 1844 | 0.0536876355748373 | 0.633352688848021 | 0.633352688848021 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d124ce08-244e-4508-b6ed-49a31d684378 | 2026-09-10 13:00 | 2026-09-10 12:59 | 2026-09-10 12:59 | CENX | CENX270319P00025000 | put | 25.0000 | 2027-03-19 | 1.1000 | 1.1000 | 1.3000 | 44.0000 | 19690.00 | 0.00 | 19690.00 | 179 | 19 | 184 | 5 | 36.8 | 0.730952648689744 | 0.730952648689744 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T17:02:16.286608Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5b5c6599-ad92-4fa2-b57f-71639d66226e | 2026-09-15 13:15 | 2026-09-15 13:15 | 2026-09-15 13:15 | CENX | CENX261120C00080000 | call | 80.0000 | 2026-11-20 | 0.2500 | 0.1000 | 0.6000 | 40.3300 | 55250.00 | 0.00 | 41450.00 | 2210 | 14 | 2210 | 2392 | 0.923913043478261 | 0.856917198500465 | 0.856917198500465 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 4112181474.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T17:17:02.017770Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 64610de4-9647-49aa-ad90-2703f940ae84 | 2026-09-18 10:28 | 2026-09-18 10:28 | 2026-09-18 10:28 | CENX | CENX260918P00046000 | put | 46.0000 | 2026-09-18 | 5.4000 | 5.4000 | 5.6000 | 40.6050 | 34020.00 | 0.00 | 540.00 | 63 | 19 | 64 | 128 | 0.5 | 2.06968981586003 | 2.06968981586003 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3861728438.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |