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
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0eca8c32-b184-4407-88fe-7a0ea9a4dbf9 | 2026-09-18 12:19 | 2026-09-18 12:19 | 2026-09-18 12:19 | ALB | ALB280121C00130000 | call | 130.0000 | 2028-01-21 | 21.2100 | 21.1000 | 22.4500 | 110.0000 | 50895.00 | 4240.00 | 46655.00 | 24 | 8 | 24 | 296 | 0.0810810810810811 | 0.499221890275982 | 0.500205597000575 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13087940872.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T16:25:30.671610Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| fd9741b0-eaee-4b7e-9930-cfb76b5f4fff | 2026-09-18 11:35 | 2026-09-18 11:35 | 2026-09-18 11:35 | ALB | ALB261016P00120000 | put | 120.0000 | 2026-10-16 | 11.4300 | 11.3500 | 12.0500 | 110.6500 | 11430.00 | 0.00 | 6855.00 | 10 | 10 | 20 | 643 | 0.031104199066874 | 0.459628135664138 | 0.469105218584973 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13087940872.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| b217aaab-08fa-4fd7-9a1b-a52e05bc7080 | 2026-09-17 10:21 | 2026-09-17 10:21 | 2026-09-17 10:21 | ALB | ALB271217P00080000 | put | 80.0000 | 2027-12-17 | 8.0100 | 8.0000 | 9.2000 | 113.8300 | 17630.00 | 1620.00 | 13610.00 | 22 | 13 | 22 | 95 | 0.231578947368421 | 0.539267823744209 | 0.542463664953844 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13576481808.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:33:58.839655Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 26228ff7-44c1-44a3-84a5-a980cdfb4ca9 | 2026-09-16 11:00 | 2026-09-16 11:00 | 2026-09-16 11:00 | ALB | ALB261120P00115000 | put | 115.0000 | 2026-11-20 | 11.3700 | 11.2500 | 11.7500 | 111.2400 | 22740.00 | 3420.00 | 19320.00 | 20 | 19 | 200 | 882 | 0.226757369614512 | 0.515834999208033 | 0.518639586098866 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 12918013590.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 977198ec-6b70-4f20-ac67-b047893c5603 | 2026-09-16 10:55 | 2026-09-16 10:55 | 2026-09-16 10:55 | ALB | ALB261120P00115000 | put | 115.0000 | 2026-11-20 | 11.1900 | 11.1000 | 11.8000 | 111.5800 | 17910.00 | 3360.00 | 14550.00 | 16 | 15 | 180 | 882 | 0.204081632653061 | 0.517057226477946 | 0.517057226477946 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 12918013590.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 36f853ee-6b7a-4b0b-abbf-ba2791883c57 | 2026-09-16 10:53 | 2026-09-16 10:53 | 2026-09-16 10:53 | ALB | ALB261120P00115000 | put | 115.0000 | 2026-11-20 | 11.1500 | 11.1000 | 11.9000 | 111.6600 | 52410.00 | 5600.00 | 46810.00 | 47 | 20 | 158 | 882 | 0.179138321995465 | 0.515986065877418 | 0.521835020401572 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 12918013590.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 1ad17eb0-acf6-4cd0-8704-09ba5c8e29a5 | 2026-09-16 10:50 | 2026-09-16 10:50 | 2026-09-16 10:50 | ALB | ALB261120P00115000 | put | 115.0000 | 2026-11-20 | 11.1600 | 11.0000 | 11.8500 | 111.7400 | 24550.00 | 6705.00 | 17845.00 | 22 | 21 | 99 | 882 | 0.112244897959184 | 0.516972459135149 | 0.521284513375119 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 12918013590.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 07abeeb1-c71e-45c6-9c72-a2041e496a16 | 2026-09-16 10:44 | 2026-09-16 10:44 | 2026-09-16 10:44 | ALB | ALB261120P00115000 | put | 115.0000 | 2026-11-20 | 11.2500 | 11.1500 | 11.8500 | 111.5350 | 63020.00 | 7930.00 | 55090.00 | 56 | 54 | 57 | 882 | 0.0646258503401361 | 0.518126377132663 | 0.518524980048224 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 12918013590.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| a5c61efa-b0df-4038-ab73-b364a3b6b87b | 2026-09-11 09:36 | 2026-09-11 09:35 | 2026-09-11 09:35 | ALB | ALB260911P00126000 | put | 126.0000 | 2026-09-11 | 6.7900 | 5.6500 | 8.3500 | 118.0000 | 31902.00 | 0.00 | 31902.00 | 47 | 11 | 47 | 120 | 0.391666666666667 | 2.91010874039867 | 2.91010874039867 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T13:37:33.609039Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1fb72060-ec87-425d-8ca4-ebb62cd9b27f | 2026-09-08 15:51 | 2026-09-08 15:51 | 2026-09-08 15:51 | ALB | ALB260918C00132000 | call | 132.0000 | 2026-09-18 | 3.6600 | 2.9800 | 3.8000 | 130.1500 | 183122.00 | 183122.00 | 0.00 | 500 | 10 | 509 | 58 | 8.77586206896552 | 0.493966738654478 | 0.493966738654478 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T13:30:57.501605Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f4862f60-b7c8-4d2e-b76e-fa72dfef5fa5 | 2026-09-01 10:50 | 2026-09-01 10:50 | 2026-09-01 10:50 | ALB | ALB270319P00130000 | put | 130.0000 | 2027-03-19 | 15.8400 | 15.7500 | 15.9500 | 135.7800 | 22170.00 | 4770.00 | 11060.00 | 14 | 5 | 23 | 194 | 0.118556701030928 | 0.515871190228841 | 0.517207018439939 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T14:59:17.018627Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d04b4797-947a-4252-9465-2926fb5bb76d | 2026-08-31 11:12 | 2026-08-31 11:12 | 2026-08-31 11:12 | ALB | ALB270319P00125000 | put | 125.0000 | 2027-03-19 | 13.9000 | 13.6000 | 13.9000 | 135.4750 | 34745.00 | 34745.00 | 0.00 | 25 | 5 | 53 | 100 | 0.53 | 0.523813919635289 | 0.525203148077325 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fedfa5c8-842a-4892-9741-27bc8d3f1ac5 | 2026-08-31 11:01 | 2026-08-31 11:01 | 2026-08-31 11:01 | ALB | ALB261218C00130000 | call | 130.0000 | 2026-12-18 | 18.1800 | 17.8000 | 18.9500 | 135.4100 | 18176.00 | 0.00 | 18176.00 | 10 | 6 | 22 | 236 | 0.0932203389830508 | 0.503723032373593 | 0.503723032373593 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T15:07:09.972110Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c0b84bda-14bd-45bf-9da0-6b2b6ebd1d94 | 2026-08-28 10:56 | 2026-08-28 10:56 | 2026-08-28 10:56 | ALB | ALB261016P00135000 | put | 135.0000 | 2026-10-16 | 7.6800 | 7.4500 | 8.3500 | 138.2800 | 33030.00 | 15410.00 | 17620.00 | 43 | 14 | 43 | 62 | 0.693548387096774 | 0.469947425827101 | 0.480184257583772 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T15:11:58.135920Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3cfa54fb-18f2-44f4-a242-e807fbc8f1d6 | 2026-08-27 13:25 | 2026-08-27 13:25 | 2026-08-27 13:25 | ALB | ALB261120C00140000 | call | 140.0000 | 2026-11-20 | 12.3800 | 11.8000 | 12.7500 | 136.2800 | 17325.00 | 3715.00 | 13610.00 | 14 | 14 | 36 | 39 | 0.923076923076923 | 0.513115935395967 | 0.515024221206269 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | 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 |
| bf0e41ea-2643-467f-a021-1c42407d0815 | 2026-08-27 12:27 | 2026-08-27 12:27 | 2026-08-27 12:27 | ALB | ALB261120C00140000 | call | 140.0000 | 2026-11-20 | 11.6600 | 11.2000 | 12.4500 | 134.9631 | 17485.00 | 1165.00 | 15150.00 | 15 | 15 | 22 | 39 | 0.564102564102564 | 0.51215715643456 | 0.514081636283707 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T16:30:57.923324Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4e51dd67-4e9c-4f72-adf5-cbbc4102595a | 2026-08-26 11:16 | 2026-08-26 11:16 | 2026-08-26 11:16 | ALB | ALB271119C00115000 | call | 115.0000 | 2027-11-19 | 40.5100 | 40.5000 | 41.3000 | 133.1700 | 32410.00 | 0.00 | 32410.00 | 8 | 6 | 8 | 5 | 1.6 | 0.508480832142226 | 0.508480832142226 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T15:22:15.766686Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aac3a8cb-f3fd-4c35-9c2e-b7fa4e143bf3 | 2026-08-24 13:48 | 2026-08-24 13:48 | 2026-08-24 13:48 | ALB | ALB260828C00144000 | call | 144.0000 | 2026-08-28 | 2.1000 | 2.0000 | 2.8400 | 140.7100 | 10714.00 | 212.00 | 10502.00 | 51 | 9 | 132 | 25 | 5.28 | 0.581455343120745 | 0.585430477512737 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1caa74f5-7be7-47bc-bfd5-5b8d3ebc0658 | 2026-08-24 12:44 | 2026-08-24 12:44 | 2026-08-24 12:44 | ALB | ALB270219C00140000 | call | 140.0000 | 2027-02-19 | 22.4200 | 22.4000 | 22.8000 | 141.9150 | 11210.00 | 2245.00 | 8965.00 | 5 | 5 | 68 | 330 | 0.206060606060606 | 0.515990421108604 | 0.515990421108604 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T17:17:38.633077Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4f33c913-b7e3-4f9c-bcee-9796017d58b2 | 2026-08-21 13:16 | 2026-08-21 13:16 | 2026-08-21 13:16 | ALB | ALB261218C00145000 | call | 145.0000 | 2026-12-18 | 16.8500 | 16.4500 | 16.9500 | 143.3850 | 35390.00 | 13520.00 | 13445.00 | 21 | 9 | 26 | 59 | 0.440677966101695 | 0.514927238732453 | 0.513378678888738 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3d9505dc-5e79-4167-89ea-a93a41a11287 | 2026-08-20 11:47 | 2026-08-20 11:47 | 2026-08-20 11:47 | ALB | ALB270820P00095000 | put | 95.0000 | 2027-08-20 | 7.9800 | 7.9000 | 8.5000 | 135.2800 | 42310.00 | 2400.00 | 35140.00 | 53 | 14 | 73 | 60 | 1.21666666666667 | 0.53704066321268 | 0.540095216133928 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | 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 |
| d57fe99f-7e24-47fb-99e8-f7122597fa21 | 2026-08-19 11:01 | 2026-08-19 11:01 | 2026-08-19 11:01 | ALB | ALB260828C00135000 | call | 135.0000 | 2026-08-28 | 4.6700 | 4.2000 | 4.8000 | 135.5650 | 11676.00 | 11676.00 | 0.00 | 25 | 6 | 52 | 83 | 0.626506024096386 | 0.508446833733426 | 0.508446833733426 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 23341bde-ba56-439b-ae7d-d9bd9d6ae5ed | 2026-08-19 10:41 | 2026-08-19 10:41 | 2026-08-19 10:41 | ALB | ALB260828C00135000 | call | 135.0000 | 2026-08-28 | 4.0900 | 3.6000 | 4.3500 | 134.6450 | 10232.00 | 10232.00 | 0.00 | 25 | 5 | 27 | 83 | 0.325301204819277 | 0.496883443612177 | 0.496883443612177 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:50:22.027850Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 796207a1-af32-42e8-855b-cd51458da561 | 2026-08-18 15:47 | 2026-08-18 15:47 | 2026-08-18 15:47 | ALB | ALB280121P00125000 | put | 125.0000 | 2028-01-21 | 25.4500 | 25.4000 | 26.9000 | 132.0000 | 35632.00 | 20360.00 | 15272.00 | 14 | 7 | 159 | 95 | 1.67368421052632 | 0.550919644800318 | 0.550919644800318 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:30:09.852702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| de7d0682-493f-4536-a44e-38084aeac59c | 2026-08-17 11:02 | 2026-08-17 11:02 | 2026-08-17 11:02 | ALB | ALB270115C00125000 | call | 125.0000 | 2027-01-15 | 22.1400 | 22.1000 | 22.5500 | 133.4000 | 11068.00 | 2215.00 | 8853.00 | 5 | 5 | 5 | 391 | 0.0127877237851662 | 0.499830844093207 | 0.502376714893345 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 13574121707.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |