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
active:option_symbol = SPX261016C07700000×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4cf53751-4ac5-4242-809e-3b546b4e7c51 | 2026-09-18 16:33 | 2026-09-18 16:31 | 2026-09-18 16:31 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 85.3000 | 84.7000 | 86.0000 | 7630.0000 | 127950.00 | 51180.00 | 76770.00 | 15 | 9 | 4147 | 18831 | 0.220221974403908 | 0.115488591363406 | 0.115488591363406 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 3918ccf6-3d4e-4b5c-be9b-6e81315228db | 2026-09-18 15:59 | 2026-09-18 15:59 | 2026-09-18 15:59 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 79.4700 | 79.0000 | 79.6000 | 7625.0000 | 333790.00 | 294060.00 | 39730.00 | 42 | 31 | 4102 | 18831 | 0.217832297806808 | 0.10985862773905 | 0.109924655765105 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | — | — | — | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| c93b46be-ad48-41ed-b177-306dbb57e80e | 2026-09-18 14:55 | 2026-09-18 14:55 | 2026-09-18 14:55 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 77.9000 | 78.2000 | 78.8000 | 7642.9100 | 1776120.00 | 0.00 | 0.00 | 228 | 6 | 3928 | 18831 | 0.208592214964686 | 0.11080445840841 | 0.11080445840841 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | 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 |
| 0e64555c-addf-4931-81ac-6e87163d3f9b | 2026-09-16 14:54 | 2026-09-16 14:54 | 2026-09-16 14:54 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 63.5000 | 60.4000 | 61.7000 | 7563.9500 | 717550.00 | 0.00 | 0.00 | 113 | 10 | 2701 | 14765 | 0.182932610904165 | 0.12658061336414 | 0.12658061336414 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | 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 |
| a9a574a0-315b-4754-b9ce-a140add6e7fc | 2026-09-16 13:20 | 2026-09-16 13:20 | 2026-09-16 13:20 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 79.2000 | 78.8000 | 79.4000 | 7609.3100 | 1742400.00 | 1338480.00 | 403920.00 | 220 | 15 | 2518 | 14765 | 0.170538435489333 | 0.124685573654266 | 0.124685573654266 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 8ed34034-0730-47a7-ae21-1477a57fae4b | 2026-09-16 11:48 | 2026-09-16 11:48 | 2026-09-16 11:48 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 84.8700 | 82.3000 | 84.9000 | 7622.3100 | 1697380.00 | 1697380.00 | 0.00 | 200 | 10 | 1080 | 14765 | 0.0731459532678632 | 0.124949801055961 | 0.124833322146188 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T16:04:58.541898Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 10991493-4d3b-43eb-9b48-cdb309159bae | 2026-09-16 09:30 | 2026-09-16 09:30 | 2026-09-16 09:30 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 78.8000 | 0.0000 | 0.0000 | 7606.1700 | 409760.00 | 409760.00 | 0.00 | 52 | 25 | 52 | 14765 | 0.0035218421943786 | 0.125731796770519 | 0.125731796770519 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T13:33:11.249350Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| c6b12276-2cb9-4818-916c-821472fef1a2 | 2026-09-10 10:11 | 2026-09-10 10:10 | 2026-09-10 10:10 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 87.7000 | 86.4000 | 87.3000 | 7582.0600 | 1315450.00 | 0.00 | 0.00 | 150 | 6 | 771 | 13187 | 0.0584666717221506 | 0.132850405143255 | 0.132861283135318 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T14:21:23.599560Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ddaaa952-a5e8-41e0-9619-44d819346d89 | 2026-09-09 12:06 | 2026-09-09 12:05 | 2026-09-09 12:05 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 108.0100 | 107.6000 | 108.2000 | 7638.2100 | 799300.00 | 799300.00 | 0.00 | 74 | 9 | 1172 | 12593 | 0.0930675772254427 | 0.126560749088939 | 0.126664163810559 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T16:21:26.040266Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| df94804d-74cf-4a2f-bf9d-f20d4124bb43 | 2026-09-08 11:13 | 2026-09-08 11:13 | 2026-09-08 11:13 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 134.8900 | 137.9000 | 138.5000 | 7698.6400 | 202335.00 | 0.00 | 0.00 | 15 | 7 | 186 | 12561 | 0.0148077382374015 | 0.120703542875244 | 0.120703542875244 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:14:28.726538Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 81a198b7-f3c1-4312-9575-61cf79791d37 | 2026-09-03 14:56 | 2026-09-03 14:56 | 2026-09-03 14:56 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 180.0000 | 178.8000 | 179.5000 | 7751.4100 | 1584000.00 | 0.00 | 0.00 | 88 | 5 | 968 | 10841 | 0.0892906558435569 | 0.126157349625226 | 0.126157349625226 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T19:09:41.417490Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f2cb5836-122e-419a-9120-211d79fc6883 | 2026-08-27 12:18 | 2026-08-27 12:18 | 2026-08-27 12:18 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 178.0000 | 177.6000 | 178.2000 | 7724.2000 | 534000.00 | 0.00 | 0.00 | 30 | 6 | 1788 | 8090 | 0.221013597033375 | 0.126476102308433 | 0.126476102308433 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | 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 |
| ee105c2e-e7de-433e-b201-d38f8cc42e0c | 2026-08-25 10:02 | 2026-08-25 10:02 | 2026-08-25 10:02 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 157.9500 | 157.4000 | 158.2000 | 7674.7600 | 2337720.00 | 205270.00 | 2132450.00 | 148 | 6 | 407 | 5259 | 0.0773911389998098 | 0.129680220697139 | 0.129593489746871 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T14:12:03.649618Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e81e8303-b946-4801-940e-bc6c9efae589 | 2026-08-25 10:02 | 2026-08-25 10:02 | 2026-08-25 10:02 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 157.8000 | 157.8000 | 158.2000 | 7674.7600 | 1088820.00 | 0.00 | 1088820.00 | 69 | 6 | 476 | 5259 | 0.0905115040882297 | 0.129506758721219 | 0.129506758721219 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T14:12:03.649618Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2a3e9908-b30e-454a-88dc-96b3421bed1c | 2026-08-25 10:02 | 2026-08-25 10:02 | 2026-08-25 10:02 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 158.1900 | 158.1000 | 158.7000 | 7674.7600 | 2198870.00 | 110740.00 | 2088130.00 | 139 | 19 | 207 | 5259 | 0.0393610952652596 | 0.129881109908364 | 0.129766951572265 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T14:12:03.649618Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6f2f223d-2cbb-466d-9ebd-4554c6d0cd5c | 2026-08-25 10:01 | 2026-08-25 10:01 | 2026-08-25 10:01 | SPX | SPX261016C07700000 | call | 7700.0000 | 2026-10-16 | 158.2000 | 158.2000 | 158.6000 | 7674.6700 | 996660.00 | 0.00 | 996660.00 | 63 | 8 | 68 | 5259 | 0.0129302148697471 | 0.129894822373099 | 0.129894822373099 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T14:12:03.649618Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |