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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 81ac6748-68a2-47d1-8971-b50daa56c54b | 2026-08-19 10:11 | 2026-08-19 10:11 | 2026-08-19 10:11 | FIX | FIX260918P01540000 | put | 1540.0000 | 2026-09-18 | 65.6300 | 65.6000 | 66.1000 | 1639.0900 | 354420.00 | 32950.00 | 45950.00 | 54 | 21 | 55 | 17 | 3.23529411764706 | 0.605878238490646 | 0.607659825320889 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 55705583941.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1f18f714-40ee-4dd5-91fd-abf77341e513 | 2026-09-03 11:27 | 2026-09-03 11:27 | 2026-09-03 11:27 | FIX | FIX260918P01680000 | put | 1680.0000 | 2026-09-18 | 115.8600 | 108.5000 | 122.3000 | 1597.0500 | 92690.00 | 46330.00 | 46360.00 | 8 | 5 | 8 | 19 | 0.421052631578947 | 0.515889852817642 | 0.516734205836518 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 55705583941.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T15:27:44.291947Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| afa227ce-1fb6-424c-9a5a-13e71e7d6f4a | 2026-09-04 12:29 | 2026-09-04 12:29 | 2026-09-04 12:29 | FIX | FIX270115C02070000 | call | 2070.0000 | 2027-01-15 | 87.9200 | 78.0000 | 87.9000 | 1610.7225 | 105500.00 | 105500.00 | 0.00 | 12 | 7 | 12 | 0 | 0 | 0.562891621224041 | 0.562891621224041 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 55705583941.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 781c9b95-d057-4116-b522-cda83beffcde | 2026-09-04 12:29 | 2026-09-04 12:29 | 2026-09-04 12:29 | FIX | FIX270115C02000000 | call | 2000.0000 | 2027-01-15 | 103.2400 | 93.4000 | 103.3000 | 1610.7225 | 82590.00 | 82590.00 | 0.00 | 8 | 6 | 8 | 72 | 0.111111111111111 | 0.565663580061802 | 0.565945258395716 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 55705583941.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 03d301e2-3baa-438a-a676-822a6cf65ad8 | 2026-09-04 12:29 | 2026-09-04 12:29 | 2026-09-04 12:29 | FIX | FIX270115C02060000 | call | 2060.0000 | 2027-01-15 | 89.9200 | 80.0000 | 89.9000 | 1610.7225 | 98910.00 | 98910.00 | 0.00 | 11 | 10 | 11 | 1 | 11 | 0.563113206337615 | 0.563113206337615 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 55705583941.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d5c4b9be-967c-4579-8fe9-de6823d1bd58 | 2026-09-04 12:30 | 2026-09-04 12:29 | 2026-09-04 12:29 | FIX | FIX270115C02050000 | call | 2050.0000 | 2027-01-15 | 93.9100 | 93.7000 | 94.0000 | 1610.7700 | 347460.00 | 178800.00 | 168660.00 | 37 | 16 | 38 | 2 | 19 | 0.569286297644002 | 0.569286297644002 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 55705583941.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c858855b-9986-4ceb-acde-a3863fb6d3e0 | 2026-09-04 12:30 | 2026-09-04 12:29 | 2026-09-04 12:29 | FIX | FIX270115C02010000 | call | 2010.0000 | 2027-01-15 | 103.5000 | 103.1000 | 103.6000 | 1610.7700 | 248410.00 | 248410.00 | 0.00 | 24 | 15 | 25 | 60 | 0.416666666666667 | 0.572339097748065 | 0.572903690002834 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 55705583941.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6b4ac8b9-71a7-425c-a279-925bb3d6235b | 2026-09-04 12:30 | 2026-09-04 12:29 | 2026-09-04 12:29 | FIX | FIX270115C02090000 | call | 2090.0000 | 2027-01-15 | 86.4200 | 86.4000 | 86.7000 | 1610.7700 | 293820.00 | 17340.00 | 17280.00 | 34 | 18 | 35 | 0 | 0 | 0.569547980100386 | 0.569547980100386 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 55705583941.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4100a637-741c-4cea-8707-bf1e2b3767ff | 2026-09-14 09:32 | 2026-09-14 09:31 | 2026-09-14 09:31 | FIX | FIX260918P01630000 | put | 1630.0000 | 2026-09-18 | 94.7900 | 84.5000 | 97.2000 | 1554.1100 | 66350.00 | 66350.00 | 0.00 | 7 | 7 | 7 | 13 | 0.538461538461538 | 0.719218926165256 | 0.726538421523667 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 55705583941.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |