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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| b19e84d3-0f8f-4a5b-8856-5e1d6c2fa66e | 2026-09-18 15:41 | 2026-09-18 15:41 | 2026-09-18 15:41 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 7.0000 | 6.9800 | 7.0200 | 719.3700 | 4133500.00 | 4103400.00 | 30100.00 | 5905 | 15 | 10696 | 37943 | 0.281896529004032 | 0.131561085555032 | 0.131561085555032 | 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:51:24.020322Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 82ecc71a-b029-4ec4-b78b-6f5089f57cbe | 2026-09-18 13:33 | 2026-09-18 13:33 | 2026-09-18 13:33 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 5.8600 | 5.8600 | 5.8900 | 716.9500 | 173456.00 | 0.00 | 173456.00 | 296 | 31 | 3590 | 37943 | 0.0946156076219593 | 0.132158704063084 | 0.132158704063084 | 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-18T17:36:08.685771Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 261c9da1-a512-44f0-b945-87d1b2a86dff | 2026-09-18 11:40 | 2026-09-18 11:40 | 2026-09-18 11:40 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 5.8200 | 5.8200 | 5.8600 | 716.4250 | 157722.00 | 0.00 | 157722.00 | 271 | 8 | 2007 | 37943 | 0.0528951321719421 | 0.135981037855443 | 0.135981037855443 | 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-18T16:02:16.049420Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| d334dfb2-6cb7-4d58-912d-b13ee88067a4 | 2026-09-17 14:03 | 2026-09-17 14:03 | 2026-09-17 14:03 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 6.5700 | 6.5400 | 6.5700 | 716.6101 | 146511.00 | 146511.00 | 0.00 | 223 | 7 | 4241 | 33240 | 0.127587244283995 | 0.14247181485534 | 0.14247181485534 | 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-17T18:13:15.605683Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 481d14d5-9253-4186-b448-34d5e7161fa8 | 2026-09-17 14:03 | 2026-09-17 14:03 | 2026-09-17 14:03 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 6.5400 | 6.5200 | 6.5500 | 716.5800 | 105948.00 | 30738.00 | 15696.00 | 162 | 6 | 3992 | 33240 | 0.120096269554753 | 0.142168314211648 | 0.142168314211648 | 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-17T18:13:15.605683Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 2571e8bc-9325-4e48-9eb4-bedf9a05b0fd | 2026-09-17 14:03 | 2026-09-17 14:03 | 2026-09-17 14:03 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 6.5400 | 6.5100 | 6.5400 | 716.5600 | 159576.00 | 159576.00 | 0.00 | 244 | 7 | 3826 | 33240 | 0.115102286401925 | 0.142338213892381 | 0.142338213892381 | 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-17T18:13:15.605683Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| b245d0a4-bba5-48e1-b027-f6f882d6f3bf | 2026-09-17 10:35 | 2026-09-17 10:34 | 2026-09-17 10:34 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 6.8900 | 6.8400 | 6.8900 | 716.4900 | 107484.00 | 107484.00 | 0.00 | 156 | 6 | 2217 | 33240 | 0.0666967509025271 | 0.149461192281396 | 0.149461192281396 | 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:48:09.438351Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| efe070d5-b0e7-49c5-be95-678e73821ed5 | 2026-09-16 16:09 | 2026-09-16 16:09 | 2026-09-16 16:09 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 3.6700 | 3.6700 | 3.7400 | 704.0000 | 183500.00 | 0.00 | 183500.00 | 500 | 21 | 12272 | 34154 | 0.35931369678515 | 0.161997332541397 | 0.161997332541397 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| d6abfdb8-c311-46dc-98cd-33eca10d6a9d | 2026-09-16 16:07 | 2026-09-16 16:07 | 2026-09-16 16:07 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 3.7200 | 3.7200 | 3.7900 | 705.0000 | 186000.00 | 0.00 | 186000.00 | 500 | 33 | 11769 | 34154 | 0.344586285647362 | 0.161305138462771 | 0.161305138462771 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| a3ba1c0f-e4aa-46e8-8891-4fb4eb525dcf | 2026-09-16 16:07 | 2026-09-16 16:07 | 2026-09-16 16:07 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 3.7400 | 3.7400 | 3.8000 | 705.0000 | 187000.00 | 0.00 | 187000.00 | 500 | 16 | 11269 | 34154 | 0.329946711951748 | 0.161253368344685 | 0.161253368344685 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 477296689505.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 12292a59-9669-41d9-9b19-e9605871bd26 | 2026-09-16 16:07 | 2026-09-16 16:06 | 2026-09-16 16:06 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 3.7600 | 3.7500 | 3.8000 | 705.0000 | 188021.00 | 0.00 | 188021.00 | 500 | 5 | 10769 | 34154 | 0.315307138256134 | 0.161542117260678 | 0.161542117260678 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 477296689505.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| ac12c56c-b544-4724-9cf8-8f5b5ac52edd | 2026-09-16 15:55 | 2026-09-16 15:54 | 2026-09-16 15:54 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 3.5100 | 3.4900 | 3.5500 | 704.0000 | 170020.00 | 0.00 | 122148.00 | 484 | 5 | 10217 | 34154 | 0.299145048896176 | 0.160766595119181 | 0.160766595119181 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 477296689505.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 32a5c5af-0533-422f-903d-639b39a25fb5 | 2026-09-16 14:59 | 2026-09-16 14:59 | 2026-09-16 14:59 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 3.9200 | 3.8400 | 3.9200 | 705.2850 | 195011.00 | 195011.00 | 0.00 | 497 | 36 | 5585 | 34154 | 0.163524038180008 | 0.164798392349679 | 0.164798392349679 | 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-09-16T19:03:15.749073Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 31ab7119-c521-4270-8ba6-926ab74a78f4 | 2026-09-16 14:58 | 2026-09-16 14:58 | 2026-09-16 14:58 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 3.7700 | 3.7000 | 3.7700 | 704.6900 | 218538.00 | 201663.00 | 16875.00 | 580 | 38 | 4617 | 34154 | 0.1351818235053 | 0.164910996056333 | 0.165128732827495 | 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-09-16T19:03:15.749073Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 1247053c-4b4e-492c-9cfe-83e857a1b684 | 2026-09-16 14:58 | 2026-09-16 14:58 | 2026-09-16 14:58 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 3.7700 | 3.7300 | 3.7900 | 704.7300 | 124703.00 | 124703.00 | 0.00 | 331 | 16 | 4948 | 34154 | 0.144873221291796 | 0.164672791974256 | 0.165107911128947 | 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-09-16T19:03:15.749073Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| fc6c421b-ce29-410b-b3f9-59f93bf46f50 | 2026-09-14 11:46 | 2026-09-14 11:46 | 2026-09-14 11:46 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 5.9000 | 5.8900 | 5.9100 | 710.2050 | 144470.00 | 0.00 | 144470.00 | 245 | 7 | 4152 | 31389 | 0.132275637962343 | 0.160468540200741 | 0.160289944892536 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 482508363106.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T16:02:31.142849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c26985e3-adf7-48cc-82a5-d17a2fb3ede6 | 2026-09-14 11:46 | 2026-09-14 11:46 | 2026-09-14 11:46 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 5.9100 | 5.9100 | 5.9200 | 710.1850 | 179664.00 | 0.00 | 179664.00 | 304 | 5 | 5488 | 31389 | 0.174838319156392 | 0.16077823018399 | 0.16077823018399 | 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-14T16:02:31.142849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bf5cbb9c-2b2f-4797-980c-b8158733d8d5 | 2026-09-14 11:46 | 2026-09-14 11:46 | 2026-09-14 11:46 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 5.9000 | 5.9000 | 5.9100 | 710.1950 | 197060.00 | 0.00 | 197060.00 | 334 | 6 | 4486 | 31389 | 0.142916308260856 | 0.160534086992009 | 0.160534086992009 | 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-14T16:02:31.142849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 98c5beba-a324-4c4d-988c-4e77d92e181f | 2026-09-14 11:46 | 2026-09-14 11:46 | 2026-09-14 11:46 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 5.9100 | 5.9100 | 5.9200 | 710.1850 | 156615.00 | 0.00 | 156615.00 | 265 | 5 | 5184 | 31389 | 0.165153397687088 | 0.16077823018399 | 0.16077823018399 | 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-14T16:02:31.142849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8228bc23-45fe-4b90-8181-1b548498d90d | 2026-09-14 11:46 | 2026-09-14 11:46 | 2026-09-14 11:46 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 5.9000 | 5.8500 | 5.9200 | 710.2000 | 135700.00 | 135700.00 | 0.00 | 230 | 9 | 3906 | 31389 | 0.12443849756284 | 0.160501314979679 | 0.160501314979679 | 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-14T16:02:31.142849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5bd0687e-834a-4e8a-b871-69818181b528 | 2026-09-09 09:33 | 2026-09-09 09:33 | 2026-09-09 09:33 | QQQ | QQQ260930C00720000 | call | 720.0000 | 2026-09-30 | 10.9200 | 10.8500 | 10.9200 | 716.0000 | 109200.00 | 109200.00 | 0.00 | 100 | 10 | 115 | 21208 | 0.00542248208223312 | 0.176217746302791 | 0.176217746302791 | 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-09T13:36:21.128731Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |