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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| e98bc290-9057-4984-a2dd-8d2acb3fde6f | 2026-09-02 11:13 | 2026-09-02 11:13 | 2026-09-02 11:13 | NG | NG270319C00012000 | call | 12.0000 | 2027-03-19 | 0.8500 | 0.8500 | 1.0000 | 8.2200 | 211905.00 | 0.00 | 211905.00 | 2493 | 16 | 3003 | 1946 | 1.5431654676259 | 0.757176077469814 | 0.757176077469814 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T15:25:17.297093Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 818c03ab-8012-4e47-9258-9b304bf25482 | 2026-09-02 10:32 | 2026-09-02 10:32 | 2026-09-02 10:32 | NG | NG270319C00012000 | call | 12.0000 | 2027-03-19 | 0.8600 | 0.8500 | 1.0000 | 8.3150 | 43058.00 | 0.00 | 43058.00 | 500 | 9 | 510 | 1946 | 0.26207605344296 | 0.74651216600037 | 0.74651216600037 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b224d506-d3cb-4c00-b4e8-e6fbf25d91bd | 2026-09-02 10:25 | 2026-09-02 10:25 | 2026-09-02 10:25 | NG | NG270319P00008000 | put | 8.0000 | 2027-03-19 | 1.4600 | 1.4000 | 1.6000 | 8.3750 | 14648.00 | 2320.00 | 12328.00 | 100 | 5 | 100 | 607 | 0.164744645799012 | 0.728840230379867 | 0.737633395920131 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b2aa0168-b2a3-4556-b9e9-f63bc7d9c198 | 2026-08-31 14:48 | 2026-08-31 14:47 | 2026-08-31 14:47 | NG | NG270319C00011000 | call | 11.0000 | 2027-03-19 | 1.2400 | 1.1000 | 1.5500 | 8.5350 | 14852.00 | 0.00 | 14852.00 | 120 | 5 | 120 | 148 | 0.810810810810811 | 0.775825290335303 | 0.775825290335303 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T19:01:22.528333Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 33121486-ce20-45ca-aab5-5991601d66bb | 2026-08-28 14:44 | 2026-08-28 14:44 | 2026-08-28 14:44 | NG | NG261218C00008000 | call | 8.0000 | 2026-12-18 | 1.6500 | 1.6500 | 1.9500 | 8.6500 | 21450.00 | 0.00 | 21450.00 | 130 | 12 | 292 | 3107 | 0.0939813324750563 | 0.685158391107509 | 0.685158391107509 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T18:46:22.896033Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 24d1a485-da82-4c69-bf32-41ee231ef616 | 2026-08-28 12:35 | 2026-08-28 12:35 | 2026-08-28 12:35 | NG | NG261218C00010000 | call | 10.0000 | 2026-12-18 | 0.9500 | 0.9500 | 1.1000 | 8.7400 | 19014.00 | 0.00 | 19014.00 | 200 | 6 | 329 | 2992 | 0.109959893048128 | 0.721511312278726 | 0.721511312278726 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0ef7394f-d87e-465d-bb08-4b42dc76a893 | 2026-08-27 13:45 | 2026-08-27 13:45 | 2026-08-27 13:45 | NG | NG260918P00009000 | put | 9.0000 | 2026-09-18 | 0.5000 | 0.3500 | 0.5000 | 9.1850 | 10000.00 | 10000.00 | 0.00 | 200 | 9 | 257 | 258 | 0.996124031007752 | 0.672056391587161 | 0.672056391587161 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | 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 |
| 0ae5dba0-801d-4456-a0f1-fb00af4f3a7b | 2026-08-25 11:47 | 2026-08-25 11:47 | 2026-08-25 11:47 | NG | NG260918C00009000 | call | 9.0000 | 2026-09-18 | 1.1500 | 1.1000 | 1.2000 | 9.6900 | 72565.00 | 68195.00 | 4370.00 | 631 | 28 | 727 | 2774 | 0.262076423936554 | 0.776530860286601 | 0.776530860286601 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | 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 |
| 96e7b450-179a-4c1f-9459-eb4b78aaa928 | 2026-08-24 10:43 | 2026-08-24 10:43 | 2026-08-24 10:43 | NG | NG270319P00009000 | put | 9.0000 | 2027-03-19 | 1.7500 | 1.7000 | 1.7500 | 9.2800 | 17675.00 | 6650.00 | 0.00 | 101 | 15 | 305 | 19 | 16.0526315789474 | 0.739645837251802 | 0.739645837251802 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e73ade1e-704c-4c4c-9591-c9a5ac299332 | 2026-08-24 10:41 | 2026-08-24 10:41 | 2026-08-24 10:41 | NG | NG270319P00009000 | put | 9.0000 | 2027-03-19 | 1.7500 | 1.7000 | 1.7500 | 9.3198 | 27825.00 | 1750.00 | 0.00 | 159 | 23 | 159 | 19 | 8.36842105263158 | 0.745038547516659 | 0.745038547516659 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c8bccbc7-f167-41e1-a8b2-0f12dbd665a3 | 2026-08-24 10:35 | 2026-08-24 10:35 | 2026-08-24 10:35 | NG | NG261218P00009000 | put | 9.0000 | 2026-12-18 | 1.3000 | 1.2500 | 1.3000 | 9.3300 | 30420.00 | 11310.00 | 0.00 | 234 | 34 | 234 | 300 | 0.78 | 0.742662942344721 | 0.742662942344721 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 10dce224-bc4c-49ca-899e-5235caf1dbb7 | 2026-08-24 09:30 | 2026-08-24 09:30 | 2026-08-24 09:30 | NG | NG260918C00009000 | call | 9.0000 | 2026-09-18 | 0.7000 | 0.7000 | 1.0000 | 9.0100 | 105026.00 | 0.00 | 70026.00 | 1500 | 53 | 1502 | 1393 | 1.07824838478105 | 0.728678641608986 | 0.728678641608986 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:38:06.174043Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9ad8354c-8439-480b-9442-45b3a9c60f79 | 2026-08-21 12:50 | 2026-08-21 12:50 | 2026-08-21 12:50 | NG | NG261218C00011000 | call | 11.0000 | 2026-12-18 | 0.9000 | 0.8000 | 0.9000 | 8.7750 | 45000.00 | 45000.00 | 0.00 | 500 | 13 | 1501 | 1982 | 0.757315842583249 | 0.791610487442804 | 0.791610487442804 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d26721b4-c9aa-43ba-b867-49d84fe51160 | 2026-08-21 11:52 | 2026-08-21 11:51 | 2026-08-21 11:51 | NG | NG260918C00008000 | call | 8.0000 | 2026-09-18 | 1.1700 | 1.1000 | 1.2000 | 8.7500 | 29200.00 | 29200.00 | 0.00 | 250 | 5 | 1130 | 3125 | 0.3616 | 0.767165373352915 | 0.767165373352915 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | 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 |
| 229f6beb-89de-4bdf-92ee-a1e65699dcd5 | 2026-08-20 14:34 | 2026-08-20 14:34 | 2026-08-20 14:34 | NG | NG270319C00012000 | call | 12.0000 | 2027-03-19 | 1.0900 | 1.0500 | 1.1500 | 8.5100 | 10948.00 | 0.00 | 5668.00 | 100 | 5 | 130 | 1198 | 0.108514190317195 | 0.78614830693217 | 0.78614830693217 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T18:45:57.711481Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| af05c6cf-a5e0-4ae2-b8d4-2f6c332fdec1 | 2026-08-20 10:17 | 2026-08-20 10:17 | 2026-08-20 10:17 | NG | NG261218C00009000 | call | 9.0000 | 2026-12-18 | 1.2500 | 1.2500 | 1.4000 | 8.4599 | 30875.00 | 0.00 | 30875.00 | 247 | 5 | 288 | 3136 | 0.0918367346938776 | 0.738056739104303 | 0.738056739104303 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5823f180-dd33-4fcd-8692-6e62ba133e09 | 2026-08-19 15:54 | 2026-08-19 15:54 | 2026-08-19 15:54 | NG | NG261218C00009000 | call | 9.0000 | 2026-12-18 | 1.3500 | 1.2500 | 1.3500 | 8.4400 | 26998.00 | 26998.00 | 0.00 | 200 | 6 | 743 | 2285 | 0.325164113785558 | 0.781498536286689 | 0.781498536286689 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d8952a54-7d44-4502-8c4f-411923ef7438 | 2026-08-19 15:53 | 2026-08-19 15:53 | 2026-08-19 15:53 | NG | NG261218C00009000 | call | 9.0000 | 2026-12-18 | 1.3500 | 1.2500 | 1.3500 | 8.4310 | 40500.00 | 40500.00 | 0.00 | 300 | 9 | 543 | 2285 | 0.237636761487965 | 0.794433757174874 | 0.794433757174874 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 17c60393-40f7-4940-a5ae-3c6e5fa62f1e | 2026-08-19 15:52 | 2026-08-19 15:52 | 2026-08-19 15:52 | NG | NG260918C00008000 | call | 8.0000 | 2026-09-18 | 1.0000 | 0.8500 | 1.0000 | 8.4250 | 10000.00 | 10000.00 | 0.00 | 100 | 5 | 1193 | 3358 | 0.355270994639666 | 0.805760251472601 | 0.805760251472601 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e011435e-96c2-40bc-9471-ceb4557be6e3 | 2026-08-19 10:18 | 2026-08-19 10:18 | 2026-08-19 10:18 | NG | NG270319C00010000 | call | 10.0000 | 2027-03-19 | 1.3500 | 1.3000 | 1.4000 | 8.2350 | 13500.00 | 2025.00 | 11475.00 | 100 | 8 | 107 | 547 | 0.195612431444241 | 0.752126593643569 | 0.752126593643569 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 031f3cc9-5e97-40a9-ad40-cb780aae5d78 | 2026-08-17 12:15 | 2026-08-17 12:15 | 2026-08-17 12:15 | NG | NG270319C00010000 | call | 10.0000 | 2027-03-19 | 1.1600 | 1.0500 | 1.3500 | 7.9389 | 11562.00 | 7257.00 | 4305.00 | 100 | 5 | 111 | 617 | 0.179902755267423 | 0.683296747808942 | 0.757909908201313 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4bdb4976-5c2c-42bb-b441-adb251b11180 | 2026-08-17 10:11 | 2026-08-17 10:11 | 2026-08-17 10:11 | NG | NG260918C00008000 | call | 8.0000 | 2026-09-18 | 0.6500 | 0.6000 | 0.7000 | 7.9650 | 65000.00 | 52000.00 | 13000.00 | 1000 | 10 | 1013 | 2358 | 0.429601357082273 | 0.696139474753727 | 0.696139474753727 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 3172383839.00 | 2026-10-07 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |