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
active:option_symbol = MP261218C00050000×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3785b66c-cf92-44f0-9718-69a9f6a1be85 | 2026-09-18 14:45 | 2026-09-18 14:45 | 2026-09-18 14:45 | MP | MP261218C00050000 | call | 50.0000 | 2026-12-18 | 5.0500 | 4.9000 | 5.2000 | 47.7600 | 138875.00 | 2525.00 | 136350.00 | 275 | 29 | 742 | 9153 | 0.0810663170545176 | 0.607476877802773 | 0.608293676448495 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 8417081049.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 21c3cf44-ce30-4686-bfad-40a9b26d1459 | 2026-09-17 11:00 | 2026-09-17 10:59 | 2026-09-17 10:59 | MP | MP261218C00050000 | call | 50.0000 | 2026-12-18 | 6.1500 | 6.1500 | 6.2500 | 49.5250 | 55350.00 | 0.00 | 55350.00 | 90 | 19 | 284 | 9069 | 0.031315470283383 | 0.619995513800653 | 0.619995513800653 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 8794656415.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:02:25.509626Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 6ca2b11a-8405-4ab5-a3fa-a36343bf76eb | 2026-09-17 10:08 | 2026-09-17 10:08 | 2026-09-17 10:08 | MP | MP261218C00050000 | call | 50.0000 | 2026-12-18 | 6.4500 | 6.1000 | 6.4500 | 49.6200 | 49020.00 | 49020.00 | 0.00 | 76 | 5 | 185 | 9069 | 0.0203991619803727 | 0.645139754132254 | 0.645139754132254 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 8794656415.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| d1f49160-0600-4bf0-a7ab-7d4fbbe115fd | 2026-09-15 15:24 | 2026-09-15 15:24 | 2026-09-15 15:24 | MP | MP261218C00050000 | call | 50.0000 | 2026-12-18 | 6.2000 | 6.1500 | 6.2000 | 49.3800 | 15500.00 | 15500.00 | 0.00 | 25 | 6 | 1899 | 8285 | 0.229209414604707 | 0.626491410166994 | 0.626491410166994 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T19:44:55.237483Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| d56fa07b-4ee0-430d-ae8a-e6c9073fc526 | 2026-09-15 15:23 | 2026-09-15 15:23 | 2026-09-15 15:23 | MP | MP261218C00050000 | call | 50.0000 | 2026-12-18 | 6.2000 | 6.1500 | 6.2000 | 49.3600 | 11160.00 | 11160.00 | 0.00 | 18 | 6 | 1831 | 8285 | 0.221001810500905 | 0.627626852733738 | 0.627626852733738 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 255ef900-abec-4d48-b684-285a78e728da | 2026-09-10 14:49 | 2026-09-10 14:49 | 2026-09-10 14:49 | MP | MP261218C00050000 | call | 50.0000 | 2026-12-18 | 7.8400 | 7.6000 | 7.8500 | 51.1916 | 39181.00 | 39181.00 | 0.00 | 50 | 8 | 72 | 8192 | 0.0087890625 | 0.665791001284008 | 0.666766927036337 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T19:03:59.290358Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2e367224-34d5-4fe5-916f-c4ead5495e14 | 2026-09-04 11:48 | 2026-09-04 11:47 | 2026-09-04 11:47 | MP | MP261218C00050000 | call | 50.0000 | 2026-12-18 | 9.8500 | 9.8500 | 10.1000 | 54.4400 | 137914.00 | 0.00 | 137914.00 | 140 | 15 | 384 | 8183 | 0.046926555053159 | 0.63926058617406 | 0.63926058617406 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:13:56.145626Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e2a35efa-beee-46d2-be8c-9d3bd8606820 | 2026-08-20 11:39 | 2026-08-20 11:38 | 2026-08-20 11:38 | MP | MP261218C00050000 | call | 50.0000 | 2026-12-18 | 10.0800 | 9.7500 | 10.6500 | 53.4850 | 50388.00 | 0.00 | 50388.00 | 50 | 6 | 323 | 8225 | 0.0392705167173252 | 0.670860229226356 | 0.670860229226356 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |