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.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47c3f7ec-59ec-4a7b-8876-aabf42957ded | 2026-08-17 10:03 | 2026-08-17 10:03 | 2026-08-17 10:03 | MP | MP261218C00055000 | call | 55.0000 | 2026-12-18 | 9.8000 | 9.8000 | 10.3000 | 56.7550 | 176414.00 | 0.00 | 176414.00 | 180 | 21 | 189 | 901 | 0.20976692563818 | 0.665475187880321 | 0.665475187880321 | 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-17T14:09:25.911404Z"} | 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 |
| 0c39525f-1f13-4705-a176-dc3b347596dd | 2026-08-21 10:06 | 2026-08-21 10:05 | 2026-08-21 10:05 | MP | MP260828C00063000 | call | 63.0000 | 2026-08-28 | 1.0100 | 0.8200 | 1.0500 | 58.7500 | 50498.00 | 50498.00 | 0.00 | 500 | 6 | 630 | 785 | 0.802547770700637 | 0.762672297501457 | 0.762672297501457 | 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-21T14:12:36.432845Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cf0b2f33-6afa-4cfd-8507-cc8d8e602461 | 2026-08-21 10:28 | 2026-08-21 10:28 | 2026-08-21 10:28 | MP | MP270115C00070000 | call | 70.0000 | 2027-01-15 | 6.8600 | 6.3000 | 6.9500 | 58.7799 | 20582.00 | 20582.00 | 0.00 | 30 | 7 | 93 | 10232 | 0.00908913213448006 | 0.699417803240579 | 0.699417803240579 | 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-21T14:36:46.143381Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2c94d414-8ceb-42cd-8ba0-73c9ebdf3054 | 2026-08-21 11:32 | 2026-08-21 11:32 | 2026-08-21 11:32 | MP | MP260828C00060000 | call | 60.0000 | 2026-08-28 | 2.2700 | 2.0300 | 2.3200 | 59.6400 | 57170.00 | 57170.00 | 0.00 | 252 | 6 | 1378 | 1062 | 1.29755178907721 | 0.722162520955338 | 0.722162520955338 | 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-21T15:38:28.521674Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b92727c6-967f-4159-9633-c3ff2e429be2 | 2026-08-25 10:24 | 2026-08-25 10:24 | 2026-08-25 10:24 | MP | MP260918C00060000 | call | 60.0000 | 2026-09-18 | 2.9800 | 2.9800 | 3.1500 | 57.2250 | 12528.00 | 2990.00 | 9538.00 | 42 | 20 | 52 | 6025 | 0.00863070539419087 | 0.696006975088743 | 0.697737679772381 | 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-25T14:28:24.156188Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d28a416c-f605-48dc-9706-b4c580477d2e | 2026-08-26 10:52 | 2026-08-26 10:52 | 2026-08-26 10:52 | MP | MP261016C00070000 | call | 70.0000 | 2026-10-16 | 3.2100 | 3.1000 | 3.4000 | 60.2750 | 16030.00 | 6400.00 | 9630.00 | 50 | 5 | 286 | 552 | 0.518115942028985 | 0.715581760527023 | 0.714990504910925 | 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-26T15:02:19.815281Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 70cfb6b9-53a8-4127-8aef-b88e62059c84 | 2026-08-27 09:54 | 2026-08-27 09:53 | 2026-08-27 09:53 | MP | MP270115C00120000 | call | 120.0000 | 2027-01-15 | 1.1800 | 1.0000 | 1.2000 | 57.9013 | 23418.00 | 23418.00 | 0.00 | 199 | 7 | 200 | 1584 | 0.126262626262626 | 0.770925439948112 | 0.770925439948112 | 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-27T14:00:28.149501Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 875a362e-1188-49ae-9184-1f51a02f7789 | 2026-08-28 09:43 | 2026-08-28 09:43 | 2026-08-28 09:43 | MP | MP260904P00055000 | put | 55.0000 | 2026-09-04 | 0.8800 | 0.6500 | 1.0000 | 58.6200 | 11860.00 | 11860.00 | 0.00 | 135 | 6 | 135 | 344 | 0.392441860465116 | 0.7146080661742 | 0.7146080661742 | 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-28T13:45:11.106617Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 98cf24aa-8fbc-4653-b7b6-87fd69166922 | 2026-08-28 14:53 | 2026-08-28 14:52 | 2026-08-28 14:52 | MP | MP270617C00055000 | call | 55.0000 | 2027-06-17 | 14.2100 | 14.2000 | 15.1000 | 55.8900 | 35536.00 | 1426.00 | 34110.00 | 25 | 9 | 27 | 831 | 0.0324909747292419 | 0.672813097382036 | 0.672813097382036 | 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-28T19:10:32.565799Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 065207e8-5f40-4d08-9a57-e5ebab699940 | 2026-09-04 09:33 | 2026-09-04 09:33 | 2026-09-04 09:33 | MP | MP260918C00057000 | call | 57.0000 | 2026-09-18 | 3.1000 | 2.8300 | 3.1000 | 57.4300 | 29444.00 | 29444.00 | 0.00 | 95 | 6 | 208 | 275 | 0.756363636363636 | 0.628486080694138 | 0.635232631344124 | 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-04T13:37:16.307537Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a707d6b1-a03a-4463-97c0-c36cc674277c | 2026-09-04 15:39 | 2026-09-04 15:38 | 2026-09-04 15:38 | MP | MP270115C00070000 | call | 70.0000 | 2027-01-15 | 4.3600 | 4.2500 | 4.6000 | 54.4500 | 26146.00 | 0.00 | 26146.00 | 60 | 8 | 193 | 10175 | 0.018968058968059 | 0.679496900021821 | 0.679496900021821 | 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-04T19:47:04.296573Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 57948ffd-b645-4360-8b2a-87a967495191 | 2026-09-04 15:55 | 2026-09-04 15:55 | 2026-09-04 15:55 | MP | MP261009C00055000 | call | 55.0000 | 2026-10-09 | 3.9900 | 3.8500 | 4.7000 | 54.5500 | 399468.00 | 0.00 | 399468.00 | 1000 | 6 | 1017 | 11 | 92.4545454545455 | 0.608080394752885 | 0.608080394752885 | true | 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-04T20:00:02.053596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b0151faa-5325-463a-b246-7a214cdfc5d4 | 2026-09-09 10:31 | 2026-09-09 10:31 | 2026-09-09 10:31 | MP | MP261009P00050000 | put | 50.0000 | 2026-10-09 | 1.5600 | 1.5500 | 1.9300 | 55.0000 | 23383.00 | 0.00 | 23383.00 | 150 | 8 | 156 | 37 | 4.21621621621622 | 0.61428066828537 | 0.616282561047111 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T14:40:24.011597Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f6c1ae89-aa63-483d-88b5-82f251411ddc | 2026-09-10 10:31 | 2026-09-10 10:31 | 2026-09-10 10:31 | MP | MP270319C00080000 | call | 80.0000 | 2027-03-19 | 4.0000 | 3.8500 | 4.0000 | 52.7700 | 11990.00 | 11990.00 | 0.00 | 30 | 5 | 46 | 345 | 0.133333333333333 | 0.699189278698411 | 0.702971067668248 | 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-10T14:36:53.026568Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c98fd698-d3bc-497a-aa89-0c575750ca32 | 2026-09-10 12:34 | 2026-09-10 12:34 | 2026-09-10 12:34 | MP | MP260918C00054000 | call | 54.0000 | 2026-09-18 | 1.2100 | 1.1600 | 1.3400 | 51.9100 | 120747.00 | 1071.00 | 119676.00 | 1001 | 50 | 2011 | 258 | 7.79457364341085 | 0.641957126466289 | 0.656844433315976 | true | 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-10T16:37:06.868856Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 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 |
| 55bcbf92-1723-4ad0-878e-6d3ec7c0ba6a | 2026-09-16 15:31 | 2026-09-16 15:31 | 2026-09-16 15:31 | MP | MP270115C00065000 | call | 65.0000 | 2027-01-15 | 2.6800 | 2.6700 | 2.7800 | 48.1600 | 28410.00 | 538.00 | 27872.00 | 106 | 18 | 134 | 5500 | 0.0243636363636364 | 0.653393197750823 | 0.654904521158857 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 8725196796.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:45:47.974261Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |