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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| b90dd0c1-c26a-45ff-b683-89cc96af0807 | 2026-09-18 15:10 | 2026-09-18 15:10 | 2026-09-18 15:10 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 2.7100 | 2.7100 | 2.7300 | 719.2950 | 189700.00 | 0.00 | 189700.00 | 700 | 7 | 2579 | 52489 | 0.0491341042885176 | 0.230913085612148 | 0.230913085612148 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 485431540564.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 58828402-701c-4b72-ab2f-bfc7c44956cf | 2026-08-28 10:19 | 2026-08-28 10:19 | 2026-08-28 10:19 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 5.9600 | 5.9600 | 6.0300 | 719.2600 | 186550.00 | 1194.00 | 185356.00 | 313 | 22 | 345 | 51204 | 0.00673775486290134 | 0.23193084518491 | 0.232078418950675 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:22:34.427319Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ea5c518c-e47d-463f-806a-8755c985a2af | 2026-08-27 15:08 | 2026-08-27 15:07 | 2026-08-27 15:07 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 6.2000 | 6.1800 | 6.2100 | 718.5400 | 183548.00 | 183548.00 | 0.00 | 296 | 8 | 9566 | 43366 | 0.220587557072361 | 0.231556340931406 | 0.231412434256361 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d2285a84-6571-4205-9c17-50482fdae526 | 2026-08-27 15:08 | 2026-08-27 15:07 | 2026-08-27 15:07 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 6.2000 | 6.1900 | 6.2500 | 718.4500 | 1440260.00 | 215760.00 | 897140.00 | 2323 | 27 | 11944 | 43366 | 0.275423142554075 | 0.231180845012404 | 0.231180845012404 | 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-08-27T19:12:42.953166Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d898451a-2fb9-4b18-8bcd-22f337840ebd | 2026-08-27 13:14 | 2026-08-27 13:14 | 2026-08-27 13:14 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 5.9800 | 5.9400 | 6.0000 | 720.4200 | 164450.00 | 10166.00 | 154284.00 | 275 | 18 | 8881 | 43366 | 0.204791772356224 | 0.233011907957255 | 0.233011907957255 | 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-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6069cb8e-929d-4e96-a791-9b67587a3869 | 2026-08-27 13:13 | 2026-08-27 13:13 | 2026-08-27 13:13 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 5.9700 | 5.9500 | 5.9800 | 720.4700 | 531330.00 | 289545.00 | 105072.00 | 890 | 13 | 8369 | 43366 | 0.192985288013651 | 0.23299153237172 | 0.23299153237172 | 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-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 15116da8-6091-4416-8b26-c4c778ec7b01 | 2026-08-27 13:13 | 2026-08-27 13:13 | 2026-08-27 13:13 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 5.9600 | 5.9600 | 5.9800 | 720.4600 | 655004.00 | 0.00 | 309920.00 | 1099 | 12 | 7479 | 43366 | 0.172462297652539 | 0.232819188563787 | 0.232819188563787 | 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-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 63a0d74e-2c74-4cb5-8be4-1c44e5c86808 | 2026-08-27 13:08 | 2026-08-27 13:08 | 2026-08-27 13:08 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 6.0000 | 5.9500 | 6.0000 | 720.3600 | 1200000.00 | 1200000.00 | 0.00 | 2000 | 50 | 6379 | 43366 | 0.147096803947793 | 0.233102813617818 | 0.233153503834089 | 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-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e49e346b-828b-434c-9ab3-5da130a1a854 | 2026-08-27 13:08 | 2026-08-27 13:08 | 2026-08-27 13:08 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 6.0000 | 5.9900 | 6.0200 | 720.2100 | 102600.00 | 14400.00 | 73800.00 | 171 | 29 | 4379 | 43366 | 0.100977724484619 | 0.232773202991251 | 0.232773202991251 | 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-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c7808be1-686c-4ee6-a901-ce49ec8df5be | 2026-08-27 13:08 | 2026-08-27 13:08 | 2026-08-27 13:08 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 6.0000 | 5.9700 | 6.0100 | 720.1800 | 110400.00 | 8400.00 | 21600.00 | 184 | 12 | 4208 | 43366 | 0.0970345431905179 | 0.23257025850269 | 0.232697108387561 | 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-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 709ead9b-db72-4831-97bc-723232d09ca7 | 2026-08-27 13:07 | 2026-08-27 13:07 | 2026-08-27 13:07 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 6.0000 | 5.9500 | 6.0100 | 720.0900 | 1508999.00 | 1395000.00 | 113999.00 | 2515 | 41 | 4024 | 43366 | 0.0927915878799059 | 0.232468755586102 | 0.232468755586102 | 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-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c838031b-6dcb-45f0-aa0b-defc0a150a59 | 2026-08-26 14:31 | 2026-08-26 14:31 | 2026-08-26 14:31 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 7.9300 | 7.8900 | 7.9400 | 710.9200 | 1586000.00 | 130052.00 | 1101477.00 | 2000 | 19 | 11309 | 25170 | 0.449304727850616 | 0.232440330647392 | 0.232440330647392 | 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-08-26T18:39:51.047298Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a2505ac0-bba5-41ad-af6b-05d2fabf9d6e | 2026-08-26 14:31 | 2026-08-26 14:31 | 2026-08-26 14:31 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 7.9100 | 7.8800 | 7.9200 | 710.9000 | 2448051.00 | 2095358.00 | 278339.00 | 3095 | 121 | 9295 | 25170 | 0.369288835915773 | 0.232127719693029 | 0.232127719693029 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 477296689505.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T18:39:51.047298Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 627b85e0-1714-408a-89d2-8ccc14af10f6 | 2026-08-26 12:35 | 2026-08-26 12:35 | 2026-08-26 12:35 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 8.3800 | 8.3300 | 8.4000 | 709.3500 | 419000.00 | 74582.00 | 49442.00 | 500 | 24 | 5429 | 25170 | 0.215693285657529 | 0.233770972055762 | 0.233770972055762 | 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-08-26T16:52:20.196728Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bfcea4c6-2261-415a-82e8-65b7191f7cec | 2026-08-26 12:29 | 2026-08-26 12:29 | 2026-08-26 12:29 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 8.4200 | 8.4200 | 8.4400 | 709.2899 | 1370776.00 | 0.00 | 1370776.00 | 1628 | 18 | 4927 | 25170 | 0.19574890742948 | 0.234104509125281 | 0.234104509125281 | 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-08-26T16:52:20.196728Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9d42e105-8494-4556-a347-66144611df59 | 2026-08-26 12:29 | 2026-08-26 12:29 | 2026-08-26 12:29 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 8.4200 | 8.3900 | 8.4300 | 709.2400 | 671916.00 | 211342.00 | 82516.00 | 798 | 20 | 3225 | 25170 | 0.128128724672229 | 0.234133083454728 | 0.233963309327707 | 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-08-26T16:52:20.196728Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0fe2b00b-77d6-4db4-9485-d0b87c9864a3 | 2026-08-26 12:28 | 2026-08-26 12:28 | 2026-08-26 12:28 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 8.4200 | 8.3600 | 8.4300 | 709.2900 | 1680632.00 | 1428874.00 | 228182.00 | 1996 | 108 | 2423 | 25170 | 0.0962653953118792 | 0.234104792047993 | 0.234104792047993 | 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-08-26T16:52:20.196728Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 204fcea2-38fa-492b-81ae-c6f04db891af | 2026-08-20 14:11 | 2026-08-20 14:10 | 2026-08-20 14:10 | QQQ | QQQ261016P00670000 | put | 670.0000 | 2026-10-16 | 10.6800 | 10.6100 | 10.6900 | 708.8800 | 533782.00 | 533782.00 | 0.00 | 500 | 5 | 6736 | 18545 | 0.363224588837962 | 0.247706410067323 | 0.247706410067323 | 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-08-20T18:14:08.178572Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |