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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 68fcf952-b2fe-4bb6-879f-16587bb7de7a | 2026-09-18 15:55 | 2026-09-18 15:55 | 2026-09-18 15:55 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 3.9600 | 3.9600 | 3.9900 | 721.0000 | 198000.00 | 0.00 | 198000.00 | 500 | 41 | 2869 | 11357 | 0.252619529805406 | 0.212636760397387 | 0.212569515126082 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 485431540564.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 5b6b1f7a-c74d-47d0-b97d-3ed100d58c4e | 2026-09-17 14:52 | 2026-09-17 14:52 | 2026-09-17 14:52 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 5.0800 | 5.0700 | 5.0900 | 716.2507 | 120396.00 | 6604.00 | 113792.00 | 237 | 23 | 11013 | 19372 | 0.56850092917613 | 0.212885541411825 | 0.212885541411825 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 475294104921.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| d4212f3d-d0bf-4dfd-952b-434971737d03 | 2026-09-17 10:00 | 2026-09-17 10:00 | 2026-09-17 10:00 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 5.3000 | 5.3000 | 5.3200 | 715.3500 | 199280.00 | 0.00 | 199280.00 | 376 | 16 | 10026 | 19372 | 0.517551104687177 | 0.213418977416593 | 0.213455187485694 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 475294104921.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:07:38.635762Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 9695d79e-cee2-454a-9ba0-3ae545549956 | 2026-09-17 09:57 | 2026-09-17 09:57 | 2026-09-17 09:57 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 5.4000 | 5.4000 | 5.4200 | 714.7999 | 111240.00 | 0.00 | 111240.00 | 206 | 18 | 9116 | 19372 | 0.470576089200909 | 0.213164451875389 | 0.213164451875389 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 475294104921.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T13:57:31.198579Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 2b9851e2-01c2-4d2b-b5d2-172e8ca975b7 | 2026-09-17 09:57 | 2026-09-17 09:57 | 2026-09-17 09:57 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 5.4100 | 5.4000 | 5.4200 | 714.7999 | 113610.00 | 0.00 | 113069.00 | 210 | 12 | 8761 | 19372 | 0.45225067107165 | 0.21324804123208 | 0.213334535505138 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 475294104921.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T13:57:31.198579Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 87be505e-d20a-463b-89f1-8e26522dea66 | 2026-09-17 09:50 | 2026-09-17 09:50 | 2026-09-17 09:50 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 5.4100 | 5.4100 | 5.4400 | 714.7050 | 541000.00 | 0.00 | 541000.00 | 1000 | 11 | 7478 | 19372 | 0.386021061325625 | 0.212938432962056 | 0.212988100461774 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 475294104921.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T13:57:31.198579Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| ba77760c-bf7d-43b4-99ab-f8fe50728efb | 2026-09-15 10:47 | 2026-09-15 10:47 | 2026-09-15 10:47 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 8.8500 | 8.8400 | 8.8700 | 705.7100 | 261075.00 | 54870.00 | 193815.00 | 295 | 7 | 1802 | 18823 | 0.0957339425171333 | 0.224257156893368 | 0.224236402853925 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 759c98e2-f02f-4587-ba8c-85d1fec06966 | 2026-09-15 10:47 | 2026-09-15 10:47 | 2026-09-15 10:47 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 8.8400 | 8.8000 | 8.8500 | 705.7100 | 315588.00 | 315588.00 | 0.00 | 357 | 10 | 1114 | 18823 | 0.0591829145194709 | 0.224136786966216 | 0.22409528771337 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 036c2b16-4438-4786-aad0-b17d31e2c4d0 | 2026-09-15 10:47 | 2026-09-15 10:47 | 2026-09-15 10:47 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 8.7900 | 8.7800 | 8.8100 | 705.7700 | 158221.00 | 158221.00 | 0.00 | 180 | 9 | 735 | 18823 | 0.0390479732242469 | 0.223638067480786 | 0.223779345036529 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| f8d74bf6-ae15-4c11-899f-117d25388f6e | 2026-09-14 15:27 | 2026-09-14 15:27 | 2026-09-14 15:27 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 7.4100 | 7.3900 | 7.4100 | 711.1450 | 512031.00 | 512031.00 | 0.00 | 691 | 19 | 14925 | 10883 | 1.37140494348985 | 0.221747547894716 | 0.221747547894716 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 482508363106.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f1fdb00b-50f6-47da-9ccd-210449bc5a8b | 2026-09-14 15:27 | 2026-09-14 15:27 | 2026-09-14 15:27 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 7.4100 | 7.3900 | 7.4100 | 711.1100 | 104481.00 | 104481.00 | 0.00 | 141 | 11 | 13218 | 10883 | 1.21455481025453 | 0.221615416845885 | 0.221615416845885 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 482508363106.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cfb6c12d-5c1a-4338-a7c4-3f0a727a7439 | 2026-09-14 15:27 | 2026-09-14 15:27 | 2026-09-14 15:27 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 7.4100 | 7.3900 | 7.4100 | 711.1100 | 303069.00 | 303069.00 | 0.00 | 409 | 9 | 13627 | 10883 | 1.25213635945971 | 0.221615416845885 | 0.221615416845885 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 482508363106.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 87c4ce46-030e-4cd1-8b1a-82a9b6db4981 | 2026-09-14 15:27 | 2026-09-14 15:27 | 2026-09-14 15:27 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 7.4000 | 7.3900 | 7.4000 | 711.1450 | 143560.00 | 143560.00 | 0.00 | 194 | 9 | 14057 | 10883 | 1.29164752366076 | 0.221599771287712 | 0.221599771287712 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 482508363106.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 66468f85-a343-46d7-a864-e434882c3e88 | 2026-09-14 15:27 | 2026-09-14 15:27 | 2026-09-14 15:27 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 7.4000 | 7.3900 | 7.4000 | 711.1450 | 130980.00 | 130980.00 | 0.00 | 177 | 6 | 14234 | 10883 | 1.30791142148305 | 0.221599771287712 | 0.221599771287712 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 482508363106.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 28a61b11-60e9-47a6-827a-89f5083f73a5 | 2026-09-14 15:26 | 2026-09-14 15:26 | 2026-09-14 15:26 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 7.4100 | 7.4100 | 7.4200 | 711.0250 | 466830.00 | 0.00 | 466830.00 | 630 | 6 | 13019 | 10883 | 1.19626941100799 | 0.221294368602061 | 0.221294368602061 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 482508363106.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 87b3dec1-51af-4b18-a011-dde28b3967b1 | 2026-09-14 15:26 | 2026-09-14 15:26 | 2026-09-14 15:26 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 7.4100 | 7.4000 | 7.4200 | 711.0199 | 185250.00 | 138567.00 | 46683.00 | 250 | 13 | 12315 | 10883 | 1.13158136543233 | 0.221275098554049 | 0.221275098554049 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 482508363106.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f420b52b-9fd4-4ea2-aa74-15a2dd0dab80 | 2026-09-14 13:39 | 2026-09-14 13:39 | 2026-09-14 13:39 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 7.0700 | 7.0700 | 7.0900 | 712.3700 | 106050.00 | 0.00 | 106050.00 | 150 | 11 | 7135 | 10883 | 0.655609666452265 | 0.221264060701737 | 0.221264060701737 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 482508363106.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dfedd073-4a5e-4cb4-8d3e-ed6b85a06cce | 2026-09-14 11:05 | 2026-09-14 11:05 | 2026-09-14 11:05 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 8.8000 | 8.8000 | 8.8800 | 705.6100 | 1182720.00 | 0.00 | 1182720.00 | 1344 | 54 | 3944 | 10883 | 0.362400073509143 | 0.219909683776957 | 0.219909683776957 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 482508363106.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9ebf3561-5f9b-429b-9a0d-20d8d5519fa3 | 2026-09-14 10:12 | 2026-09-14 10:12 | 2026-09-14 10:12 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 8.4700 | 8.4600 | 8.4900 | 707.4800 | 277813.00 | 0.00 | 277813.00 | 328 | 40 | 881 | 10883 | 0.0809519433979601 | 0.222831000340531 | 0.222689718874833 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 482508363106.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:14:09.812180Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2087e560-bee1-401e-9d4c-642f38e11543 | 2026-09-09 10:07 | 2026-09-09 10:07 | 2026-09-09 10:07 | QQQ | QQQ261016P00685000 | put | 685.0000 | 2026-10-16 | 7.0100 | 7.0100 | 7.0600 | 719.2951 | 100944.00 | 0.00 | 100944.00 | 144 | 5 | 4319 | 7563 | 0.571069681343382 | 0.229169718510151 | 0.229169718510151 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 482508363106.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T14:11:22.686371Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |