Simplify AnalyticsOptions 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| fb3e8743-8b96-4807-8b48-5cfa35e05ee2 | 2026-09-17 13:13 | 2026-09-17 13:13 | 2026-09-17 13:13 | NKE | NKE290119P00035000 | put | 35.0000 | 2029-01-19 | 7.1000 | 7.0500 | 7.2500 | 35.8800 | 607050.00 | 0.00 | 607050.00 | 855 | 1 | 859 | 2544 | 0.337657232704403 | 0.458337933435488 | 0.458337933435488 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Consumer Cyclical | 43708754178.00 | 2026-10-01 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 4ae2473f-09a7-4657-a0d5-d5846ad0c74b | 2026-09-10 09:54 | 2026-09-10 09:54 | 2026-09-10 09:54 | NKE | NKE281215P00035000 | put | 35.0000 | 2028-12-15 | 6.6800 | 6.6000 | 6.8000 | 36.9450 | 133600.00 | 0.00 | 133600.00 | 200 | 2 | 202 | 2872 | 0.0703342618384401 | 0.450148741668592 | 0.450148741668592 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 2 | Common Stock | Consumer Cyclical | 44538210735.00 | 2026-10-01 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T14:06:33.692120Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 59d069d8-253d-4144-9543-2e1613196de9 | 2026-09-03 12:09 | 2026-09-03 12:08 | 2026-09-03 12:08 | NKE | NKE281215P00040000 | put | 40.0000 | 2028-12-15 | 9.0500 | 9.0000 | 9.2500 | 38.3200 | 271500.00 | 0.00 | 271500.00 | 300 | 1 | 331 | 2077 | 0.159364467982667 | 0.457947116521487 | 0.457947116521487 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Consumer Cyclical | 44538210735.00 | 2026-10-01 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:31:32.213825Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 31d1e91b-a19f-4475-a1b5-67e3dd5fb3fe | 2026-08-27 14:59 | 2026-08-27 14:59 | 2026-08-27 14:59 | NKE | NKE260828P00042000 | put | 42.0000 | 2026-08-28 | 3.6300 | 3.4500 | 3.6500 | 38.4250 | 1126389.00 | 1126389.00 | 0.00 | 3103 | 2 | 3884 | 2371 | 1.6381273724167 | 1.09216997387113 | 1.09216997387113 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Consumer Cyclical | 44538210735.00 | 2026-10-01 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d0dadcea-d219-4458-8bb5-c9ca2dc50536 | 2026-08-20 14:56 | 2026-08-20 14:56 | 2026-08-20 14:56 | NKE | NKE260821P00043000 | put | 43.0000 | 2026-08-21 | 2.4800 | 2.4600 | 2.7200 | 40.4100 | 1920016.00 | 0.00 | 1920016.00 | 7742 | 2 | 7749 | 5161 | 1.50145320674288 | 1.01882275149857 | 1.01882275149857 | false | true | true | false | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Consumer Cyclical | 44538210735.00 | 2026-10-01 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:16:26.699237Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 60a28dee-0846-4581-9a50-2f4ef51d40ad | 2026-08-20 14:56 | 2026-08-20 14:56 | 2026-08-20 14:56 | NKE | NKE260821P00045000 | put | 45.0000 | 2026-08-21 | 4.5500 | 4.5500 | 4.8500 | 40.4150 | 1371370.00 | 0.00 | 1371370.00 | 3014 | 2 | 3170 | 2009 | 1.57789945246391 | 1.83189458309246 | 1.83189458309246 | false | true | true | false | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Consumer Cyclical | 44538210735.00 | 2026-10-01 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:16:26.699237Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d92182b3-2fb1-49f5-a535-dc3e106a3391 | 2026-08-17 13:15 | 2026-08-17 13:15 | 2026-08-17 13:15 | NKE | NKE281215P00025000 | put | 25.0000 | 2028-12-15 | 2.6300 | 1.6500 | 2.9000 | 38.8750 | 139390.00 | 139390.00 | 0.00 | 530 | 1 | 552 | 19 | 29.0526315789474 | 0.465253074389517 | 0.465253074389517 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Consumer Cyclical | 44538210735.00 | 2026-10-01 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fffcb63b-976d-472e-bb82-657dd2101758 | 2026-08-17 10:07 | 2026-08-17 10:07 | 2026-08-17 10:07 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.9000 | 5.8500 | 5.9500 | 39.6150 | 177000.00 | 0.00 | 0.00 | 300 | 1 | 334 | 3827 | 0.0872746276456755 | 0.382711881946801 | 0.382711881946801 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Consumer Cyclical | 44538210735.00 | 2026-10-01 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |