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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| b14ca645-e63b-483e-82fd-8ff4b1c4ed60 | 2026-09-18 15:56 | 2026-09-18 15:56 | 2026-09-18 15:56 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 11.5200 | 11.4700 | 11.5200 | 721.0000 | 259200.00 | 259200.00 | 0.00 | 225 | 15 | 3054 | 22695 | 0.134567085261071 | 0.219544707720068 | 0.219544707720068 | 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 |
| 8cdf1434-7f39-4f3d-9175-f115402a997a | 2026-09-18 14:50 | 2026-09-18 14:50 | 2026-09-18 14:50 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 11.9400 | 11.8800 | 11.9400 | 718.9300 | 293724.00 | 293724.00 | 0.00 | 246 | 17 | 2438 | 22695 | 0.107424542850848 | 0.217902657326399 | 0.217902657326399 | 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:03:43.854590Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| fb9f0b9f-4f43-4537-b0f2-c9874926a726 | 2026-09-18 14:08 | 2026-09-18 14:08 | 2026-09-18 14:08 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 12.4200 | 12.3900 | 12.4200 | 717.5100 | 309258.00 | 309258.00 | 0.00 | 249 | 17 | 2145 | 22695 | 0.0945142101784534 | 0.218639969984011 | 0.218634288497268 | 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-18T18:22:45.408265Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| f1790e64-9e56-42bd-8af8-55bee0062f08 | 2026-09-17 15:49 | 2026-09-17 15:49 | 2026-09-17 15:49 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 12.9000 | 12.8400 | 12.9200 | 717.0000 | 206393.00 | 198659.00 | 2578.00 | 160 | 8 | 5611 | 18193 | 0.308415324575386 | 0.220521357575277 | 0.220618009249195 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 475294104921.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 256280dc-14b8-4004-b7bc-d4cd8b566325 | 2026-09-17 15:49 | 2026-09-17 15:49 | 2026-09-17 15:49 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 12.9000 | 12.8700 | 12.9000 | 717.0000 | 199881.00 | 110940.00 | 88941.00 | 155 | 6 | 5766 | 18193 | 0.316935084922773 | 0.220521357575277 | 0.220618009249195 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 475294104921.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 997af472-a5ad-45cf-b019-c4718883a75a | 2026-09-17 15:17 | 2026-09-17 15:17 | 2026-09-17 15:17 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 12.9500 | 12.9300 | 12.9600 | 716.7150 | 152810.00 | 34965.00 | 117845.00 | 118 | 6 | 5049 | 18193 | 0.277524322541637 | 0.220118340307058 | 0.220118340307058 | 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-17T19:28:01.580099Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 2054cf03-7ce3-4b20-a47f-9fd4f2ececb7 | 2026-09-17 12:57 | 2026-09-17 12:57 | 2026-09-17 12:57 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 13.3000 | 13.2900 | 13.3200 | 716.0696 | 134330.00 | 0.00 | 117040.00 | 101 | 14 | 4775 | 18193 | 0.262463584895289 | 0.221635864131353 | 0.221635864131353 | 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-17T17:10:56.508407Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 7e04e3d3-0fb5-4266-bc3c-27b4d7349a59 | 2026-09-17 12:57 | 2026-09-17 12:57 | 2026-09-17 12:57 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 13.2900 | 13.2700 | 13.3300 | 716.0700 | 239241.00 | 3990.00 | 235251.00 | 180 | 14 | 4557 | 18193 | 0.250480954213159 | 0.221541100311601 | 0.221637015292667 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 475294104921.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 5ab6f615-1693-49d8-b905-2cd4da073892 | 2026-09-17 12:57 | 2026-09-17 12:57 | 2026-09-17 12:57 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 13.3000 | 13.2850 | 13.3300 | 716.0700 | 121030.00 | 0.00 | 118370.00 | 91 | 10 | 4377 | 18193 | 0.240587038971033 | 0.221637015292667 | 0.221637015292667 | 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-17T17:10:56.508407Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 6829d19c-187a-42a0-8289-6cec01604267 | 2026-09-17 12:34 | 2026-09-17 12:33 | 2026-09-17 12:33 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 13.3000 | 13.2500 | 13.3200 | 716.1500 | 180880.00 | 5320.00 | 175560.00 | 136 | 11 | 3935 | 18193 | 0.216291980432034 | 0.221867179203195 | 0.221867179203195 | 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-17T16:46:55.190867Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 3b465562-206f-4d69-bce4-098d20f02e4b | 2026-09-17 12:33 | 2026-09-17 12:33 | 2026-09-17 12:33 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 13.2900 | 13.2700 | 13.3100 | 716.1510 | 268526.00 | 2660.00 | 224662.00 | 202 | 8 | 3342 | 18193 | 0.183697026328808 | 0.221774112782779 | 0.22187005539197 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 475294104921.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T16:46:55.190867Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| f156f25c-c67c-4782-9532-2914d8ddfb7a | 2026-09-17 11:42 | 2026-09-17 11:42 | 2026-09-17 11:42 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 13.3000 | 13.2500 | 13.3500 | 716.4000 | 133000.00 | 79800.00 | 26600.00 | 100 | 5 | 3099 | 18193 | 0.170340240751938 | 0.222585567473649 | 0.222585567473649 | 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-17T15:59:42.981722Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| e917e3e3-564f-4082-a128-b1ea55be209f | 2026-09-17 11:41 | 2026-09-17 11:40 | 2026-09-17 11:40 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 13.3600 | 13.2800 | 13.3600 | 716.3200 | 418168.00 | 418168.00 | 0.00 | 313 | 11 | 2485 | 18193 | 0.13659099653713 | 0.22293163024259 | 0.22293163024259 | 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-17T15:59:42.981722Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 5a77c54e-f8a4-4980-951d-90be51fe838f | 2026-09-17 11:41 | 2026-09-17 11:40 | 2026-09-17 11:40 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 13.3400 | 13.2600 | 13.3600 | 716.3400 | 2285318.00 | 2269298.00 | 16020.00 | 1713 | 74 | 2172 | 18193 | 0.119386577254988 | 0.222797208468875 | 0.222989118824217 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 475294104921.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:59:42.981722Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| e3d22381-fb11-4357-8f01-58d294409238 | 2026-09-17 10:22 | 2026-09-17 10:22 | 2026-09-17 10:22 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 13.5400 | 13.4400 | 13.5600 | 715.7600 | 203036.00 | 203036.00 | 0.00 | 150 | 5 | 394 | 18193 | 0.0216566811410982 | 0.222849317018736 | 0.222849317018736 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 475294104921.00 | — | — | — | 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 |
| 695f75f1-aab0-4f58-b720-216a00d286b4 | 2026-09-16 15:16 | 2026-09-16 15:16 | 2026-09-16 15:16 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 19.0000 | 18.9900 | 19.0000 | 701.4840 | 378100.00 | 378100.00 | 0.00 | 199 | 5 | 1375 | 17714 | 0.0776222197132212 | 0.226658380091152 | 0.226658380091152 | 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-16T19:16:52.058969Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 476a59fc-dc54-4cd6-b028-2b1e2f3c6388 | 2026-09-15 10:11 | 2026-09-15 10:11 | 2026-09-15 10:11 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 16.9000 | 16.8600 | 16.9600 | 707.0801 | 169000.00 | 57460.00 | 111540.00 | 100 | 8 | 224 | 17705 | 0.0126517932787348 | 0.22481481358549 | 0.22481481358549 | 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:18:51.832385Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| a7e2acc4-fc79-4b07-90ed-e52ffc11a5c7 | 2026-09-02 09:33 | 2026-09-02 09:33 | 2026-09-02 09:33 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 18.3000 | 18.3000 | 18.4000 | 706.6200 | 183000.00 | 0.00 | 183000.00 | 100 | 8 | 145 | 16228 | 0.00893517377372443 | 0.217908807610645 | 0.217908807610645 | 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-02T13:42:51.501101Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b437128a-1b32-43ce-80eb-febcbae5f889 | 2026-09-01 15:05 | 2026-09-01 15:05 | 2026-09-01 15:05 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 18.0000 | 17.9100 | 18.0900 | 706.9400 | 199800.00 | 122400.00 | 7200.00 | 111 | 5 | 1145 | 15820 | 0.0723767383059419 | 0.215214843799503 | 0.215214843799503 | 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-01T19:21:20.162349Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ef8869ed-db2f-4fa7-b23b-d1d22be1f8c4 | 2026-08-21 12:26 | 2026-08-21 12:26 | 2026-08-21 12:26 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 19.4000 | 19.3500 | 19.4200 | 713.5700 | 721680.00 | 644080.00 | 77600.00 | 372 | 12 | 2725 | 8084 | 0.337085601187531 | 0.232189153503006 | 0.232189153503006 | 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-21T16:43:46.028086Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8c988dca-3135-4f06-8da9-79f26f0f32a0 | 2026-08-21 12:26 | 2026-08-21 12:26 | 2026-08-21 12:26 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 19.4000 | 19.3500 | 19.4100 | 713.5601 | 166840.00 | 126100.00 | 1940.00 | 86 | 5 | 2811 | 8084 | 0.347723899059871 | 0.232163686363561 | 0.232163686363561 | 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-21T16:43:46.028086Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3e38b760-f5a1-4653-a50e-712efb562ffc | 2026-08-21 12:26 | 2026-08-21 12:26 | 2026-08-21 12:26 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 19.4200 | 19.3800 | 19.4300 | 713.5400 | 194200.00 | 38840.00 | 155360.00 | 100 | 5 | 2931 | 8084 | 0.362568035625928 | 0.232266365412266 | 0.232266365412266 | 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-21T16:43:46.028086Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5687e9c4-9f16-4b20-874b-f466a1b84f3d | 2026-08-21 12:26 | 2026-08-21 12:26 | 2026-08-21 12:26 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 19.4000 | 19.3500 | 19.4100 | 713.5616 | 1181439.00 | 822559.00 | 320080.00 | 609 | 24 | 2353 | 8084 | 0.291068777832756 | 0.232063587647833 | 0.232167545135716 | 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-21T16:43:46.028086Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e9eb1e05-1e87-4aec-9dac-219394f20b32 | 2026-08-21 12:26 | 2026-08-21 12:26 | 2026-08-21 12:26 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 19.3400 | 19.2800 | 19.3600 | 713.6300 | 1164277.00 | 1007562.00 | 156715.00 | 602 | 27 | 1704 | 8084 | 0.210786739238001 | 0.231802872397471 | 0.231957344030736 | 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-21T16:43:46.028086Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4fa6d502-4d31-4fc6-a12f-351f301e4ce3 | 2026-08-21 12:26 | 2026-08-21 12:26 | 2026-08-21 12:26 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 19.3000 | 19.2400 | 19.3100 | 713.7100 | 804810.00 | 598300.00 | 129310.00 | 417 | 21 | 1102 | 8084 | 0.136318654131618 | 0.23177663808793 | 0.23177663808793 | 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-21T16:43:46.028086Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fab0b428-731d-4c52-80e8-6a1b616a07ba | 2026-08-21 12:26 | 2026-08-21 12:26 | 2026-08-21 12:26 | QQQ | QQQ261120P00690000 | put | 690.0000 | 2026-11-20 | 19.2500 | 19.1750 | 19.2700 | 713.7100 | 583275.00 | 544775.00 | 38500.00 | 303 | 8 | 620 | 8084 | 0.0766947055912914 | 0.231390272344657 | 0.231390272344657 | 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-21T16:43:46.028086Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |