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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5209a979-2431-4894-8538-1aa0c3e54417 | 2026-09-18 10:03 | 2026-09-18 10:03 | 2026-09-18 10:03 | SMR | SMR270219C00012000 | call | 12.0000 | 2027-02-19 | 1.0200 | 0.8600 | 1.1500 | 8.6050 | 10177.00 | 10075.00 | 0.00 | 100 | 7 | 100 | 430 | 0.232558139534884 | 0.875871199907666 | 0.871218630440925 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 3393921347.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:08:58.692787Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 3995006f-9b59-4f81-b607-fffd1aaaba43 | 2026-09-16 10:35 | 2026-09-16 10:35 | 2026-09-16 10:35 | SMR | SMR280121C00015000 | call | 15.0000 | 2028-01-21 | 2.0800 | 2.0000 | 2.0800 | 8.1200 | 15590.00 | 15590.00 | 0.00 | 75 | 5 | 91 | 5680 | 0.0160211267605634 | 0.927916129030585 | 0.925256361047562 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 3406233033.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 1967cadb-7ce4-4c3d-8821-741cf55a3290 | 2026-09-11 15:41 | 2026-09-11 15:41 | 2026-09-11 15:41 | SMR | SMR280121C00008000 | call | 8.0000 | 2028-01-21 | 3.9500 | 3.9500 | 4.0000 | 8.7850 | 36744.00 | 1194.00 | 35550.00 | 93 | 21 | 455 | 5466 | 0.0832418587632638 | 0.925704097496872 | 0.916521859463494 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 3492414832.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T19:55:36.907305Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5511b661-b784-4443-9a45-a2746eabca59 | 2026-09-09 09:38 | 2026-09-09 09:38 | 2026-09-09 09:38 | SMR | SMR261009C00011500 | call | 11.5000 | 2026-10-09 | 0.9400 | 0.9100 | 1.1600 | 11.0850 | 23524.00 | 0.00 | 23524.00 | 250 | 5 | 650 | 926 | 0.701943844492441 | 0.878248918087863 | 0.878248918087863 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 3492414832.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T13:46:31.810255Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7468ca11-edbf-41e2-8082-f42cc323515d | 2026-09-08 13:55 | 2026-09-08 13:55 | 2026-09-08 13:55 | SMR | SMR260911P00011000 | put | 11.0000 | 2026-09-11 | 0.3700 | 0.3600 | 0.3800 | 11.1200 | 18290.00 | 0.00 | 18253.00 | 500 | 26 | 6721 | 351 | 19.1481481481481 | 1.07277589607349 | 1.04757448239309 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 3492414832.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T18:15:47.972880Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 02a363c2-2142-4869-b444-498a6bd42993 | 2026-09-08 10:53 | 2026-09-08 10:53 | 2026-09-08 10:53 | SMR | SMR270115C00010000 | call | 10.0000 | 2027-01-15 | 2.7500 | 2.6300 | 2.7700 | 10.8750 | 275075.00 | 62501.00 | 128149.00 | 1001 | 20 | 1515 | 9525 | 0.159055118110236 | 0.907193750687368 | 0.904348397845174 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 3492414832.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b91173ca-70e3-4814-ade0-6aa926454c2a | 2026-09-08 09:47 | 2026-09-08 09:47 | 2026-09-08 09:47 | SMR | SMR260918C00009000 | call | 9.0000 | 2026-09-18 | 1.5900 | 1.5100 | 1.7500 | 10.4400 | 47850.00 | 39850.00 | 8000.00 | 300 | 11 | 405 | 2155 | 0.187935034802784 | 0.994340376142301 | 0.978143965865929 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 3492414832.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T13:49:15.511852Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 55a55c0e-3275-480f-8100-362f82a71a8d | 2026-09-04 11:37 | 2026-09-04 11:37 | 2026-09-04 11:37 | SMR | SMR280121P00008000 | put | 8.0000 | 2028-01-21 | 2.6000 | 2.5100 | 2.6000 | 9.5501 | 12990.00 | 12990.00 | 0.00 | 50 | 6 | 51 | 3430 | 0.014868804664723 | 0.92582878893653 | 0.922844278746299 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 3492414832.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T15:46:11.944585Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c7c03c40-41c3-4ed7-8563-b21f8d5fbad1 | 2026-08-31 14:51 | 2026-08-31 14:50 | 2026-08-31 14:50 | SMR | SMR261009C00012000 | call | 12.0000 | 2026-10-09 | 0.2300 | 0.2300 | 0.2800 | 9.2450 | 14926.00 | 0.00 | 14926.00 | 643 | 28 | 4032 | 5 | 806.4 | 0.804923005382847 | 0.792995336591837 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 3492414832.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T19:01:22.528333Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2b8621c0-38b0-4abd-8097-b2f00a1343c4 | 2026-08-31 14:50 | 2026-08-31 14:50 | 2026-08-31 14:50 | SMR | SMR261009C00012000 | call | 12.0000 | 2026-10-09 | 0.2500 | 0.2100 | 0.3000 | 9.2550 | 69985.00 | 0.00 | 69985.00 | 2852 | 22 | 3142 | 5 | 628.4 | 0.813116421754622 | 0.802562993451935 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 3492414832.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T19:01:22.528333Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 918b969f-350e-449d-ae22-b003e0ffc450 | 2026-08-25 13:30 | 2026-08-25 13:30 | 2026-08-25 13:30 | SMR | SMR261016P00011000 | put | 11.0000 | 2026-10-16 | 1.9800 | 1.9600 | 2.0200 | 9.7700 | 424300.00 | 10638.00 | 413465.00 | 2147 | 29 | 8057 | 12 | 671.416666666667 | 0.846191578267508 | 0.839261395030903 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 3492414832.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T17:31:01.749779Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7c94ca64-bc22-42be-ae6d-78c477c963b0 | 2026-08-25 13:23 | 2026-08-25 13:22 | 2026-08-25 13:22 | SMR | SMR261016P00011000 | put | 11.0000 | 2026-10-16 | 1.9800 | 1.9800 | 2.0200 | 9.7800 | 11881.00 | 0.00 | 11683.00 | 60 | 9 | 5601 | 12 | 466.75 | 0.853116087888969 | 0.850177899432577 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 3492414832.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T17:31:01.749779Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b3a30198-0f43-41d8-9b34-ce9ab5bf6aed | 2026-08-21 11:07 | 2026-08-21 11:07 | 2026-08-21 11:07 | SMR | SMR260828C00009000 | call | 9.0000 | 2026-08-28 | 0.6500 | 0.6500 | 0.7000 | 9.4350 | 19744.00 | 1518.00 | 18226.00 | 302 | 17 | 636 | 977 | 0.650972364380757 | 0.773512289150103 | 0.766841492227936 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 3492414832.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 38c273d8-8398-42d2-9237-df1e53ad23b7 | 2026-08-19 09:56 | 2026-08-19 09:56 | 2026-08-19 09:56 | SMR | SMR260904C00009500 | call | 9.5000 | 2026-09-04 | 0.2600 | 0.2400 | 0.3600 | 8.6700 | 13093.00 | 0.00 | 13093.00 | 500 | 5 | 546 | 315 | 1.73333333333333 | 0.779411330319045 | 0.779411330319045 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 3492414832.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |