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.
uw_flow_alerts474,253 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 | expiry |
|---|
| 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 |
|---|
| 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 |
| a109423c-ba1d-458b-ae8e-ff707328ccf2 | 2026-08-17 11:21 | 2026-08-17 11:21 | 2026-08-17 11:21 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.7000 | 5.7000 | 5.7500 | 39.3350 | 57035.00 | 4025.00 | 53010.00 | 100 | 6 | 1050 | 3827 | 0.274366344395088 | 0.38383205737346 | 0.380254167393971 | false | false | false | true | ||||||||||||||||
| cc4b7c4d-dd90-40b8-8436-5e3748ef59e3 | 2026-08-17 12:53 | 2026-08-17 12:52 | 2026-08-17 12:52 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.5500 | 5.5500 | 5.7500 | 38.9600 | 23865.00 | 0.00 | 23865.00 | 43 | 5 | 1882 | 3827 | 0.491769009668147 | 0.384326556958899 | 0.385156436864623 | false | false | false | true | ||||||||||||||||
| 7447ec97-3391-4b9a-9633-fc93db398dc8 | 2026-08-25 09:48 | 2026-08-25 09:48 | 2026-08-25 09:48 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.7500 | 5.5500 | 5.8000 | 39.3500 | 10350.00 | 4600.00 | 5750.00 | 18 | 6 | 154 | 3738 | 0.0411985018726592 | 0.389257163102213 | 0.388831078127789 | false | false | false | true | ||||||||||||||||
| 2cfd690f-4a04-46c4-9d3b-f5bc8048b658 | 2026-08-25 14:24 | 2026-08-25 14:24 | 2026-08-25 14:24 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.6500 | 5.6500 | 5.7500 | 39.0000 | 169500.00 | 0.00 | 169500.00 | 300 | 6 | 1018 | 3738 | 0.272338148742643 | 0.376258035931385 | 0.376258035931385 | false | false | false | true | ||||||||||||||||
| 6d1349e1-db08-45fd-93a1-f252ac6312dc | 2026-08-25 14:32 | 2026-08-25 14:32 | 2026-08-25 14:32 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.7000 | 5.6000 | 5.7000 | 39.4800 | 114000.00 | 114000.00 | 0.00 | 200 | 6 | 1537 | 3738 | 0.411182450508293 | 0.379662628348173 | 0.379662628348173 | false | false | false | true | ||||||||||||||||
| 2e450336-9b9a-4ca6-8616-9d585acd3936 | 2026-08-25 15:14 | 2026-08-25 15:14 | 2026-08-25 15:14 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.6000 | 5.5000 | 5.6500 | 39.4350 | 38080.00 | 38080.00 | 0.00 | 68 | 6 | 1811 | 3738 | 0.484483681112895 | 0.37434517239713 | 0.37434517239713 | false | false | false | true | ||||||||||||||||
| f55f3319-bc09-4711-9ae3-a3f7cc9796be | 2026-08-26 11:20 | 2026-08-26 11:20 | 2026-08-26 11:20 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.2000 | 5.1000 | 5.2000 | 38.6050 | 26000.00 | 26000.00 | 0.00 | 50 | 8 | 1644 | 4841 | 0.339599256351993 | 0.380718068199209 | 0.381131201641763 | false | false | false | true | ||||||||||||||||
| 17c764fe-36da-4041-abab-4ad4df3928c3 | 2026-08-26 11:20 | 2026-08-26 11:20 | 2026-08-26 11:20 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.2000 | 5.1000 | 5.2000 | 38.6000 | 20800.00 | 20800.00 | 0.00 | 40 | 6 | 1734 | 4841 | 0.358190456517249 | 0.380924646468453 | 0.381337733792931 | false | false | false | true | ||||||||||||||||
| eb6a495d-b7c4-48fe-a1aa-975c479cbc5b | 2026-08-26 11:20 | 2026-08-26 11:20 | 2026-08-26 11:20 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.2000 | 5.1000 | 5.2000 | 38.6000 | 88920.00 | 88920.00 | 0.00 | 171 | 8 | 2416 | 4841 | 0.499070439991737 | 0.381131201641763 | 0.381337733792931 | false | false | false | true | ||||||||||||||||
| e4807b3c-1980-4b47-8566-bbb65ad0c9c0 | 2026-08-26 11:20 | 2026-08-26 11:20 | 2026-08-26 11:20 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.2000 | 5.1000 | 5.2000 | 38.6000 | 100360.00 | 100360.00 | 0.00 | 193 | 20 | 1939 | 4841 | 0.400537079115885 | 0.38154424299559 | 0.381337733792931 | false | false | false | true | ||||||||||||||||
| 5c4959e8-b571-4a0b-a376-71ac470129e9 | 2026-08-26 11:20 | 2026-08-26 11:20 | 2026-08-26 11:20 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.2000 | 5.1000 | 5.2000 | 38.6100 | 159120.00 | 159120.00 | 0.00 | 306 | 17 | 2245 | 4841 | 0.463747159677753 | 0.380924646468453 | 0.380924646468453 | false | false | false | |||||||||||||||||
| b8646392-bad4-4299-8d85-ad2cd1701ceb | 2026-08-27 13:47 | 2026-08-27 13:47 | 2026-08-27 13:47 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.0200 | 5.0000 | 5.0500 | 38.3050 | 50224.00 | 12072.00 | 38152.00 | 100 | 5 | 301 | 6426 | 0.0468409586056645 | 0.380930117966618 | 0.380930117966618 | false | false | false | |||||||||||||||||
| bc245cd7-4009-4b3c-98c9-2f272bd17d46 | 2026-08-28 15:56 | 2026-08-28 15:56 | 2026-08-28 15:56 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.7000 | 5.6000 | 5.7000 | 39.7300 | 142500.00 | 142500.00 | 0.00 | 250 | 5 | 759 | 7179 | 0.105725031341412 | 0.371258121091963 | 0.371258121091963 | false | false | false | true | ||||||||||||||||
| ee7a8977-9467-457a-be4e-ff0688fa80fd | 2026-08-28 15:58 | 2026-08-28 15:57 | 2026-08-28 15:57 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.7000 | 5.6000 | 5.9000 | 39.5950 | 40470.00 | 0.00 | 40470.00 | 71 | 5 | 1576 | 7179 | 0.219529182337373 | 0.377083336845206 | 0.377083336845206 | false | false | false | true | ||||||||||||||||
| 45caa7e6-5da1-43c5-9451-9a2e1bcc30e4 | 2026-09-01 09:30 | 2026-09-01 09:30 | 2026-09-01 09:30 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.1500 | 5.0000 | 5.4000 | 38.2700 | 10300.00 | 0.00 | 10300.00 | 20 | 5 | 20 | 6952 | 0.00287686996547756 | 0.394646510421734 | 0.394646510421734 | false | false | false | true | ||||||||||||||||
| bb4afdf5-716b-4037-b0f7-003f83253c5d | 2026-09-01 13:47 | 2026-09-01 13:47 | 2026-09-01 13:47 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.0300 | 5.0000 | 5.0500 | 38.1300 | 226396.00 | 226396.00 | 0.00 | 450 | 5 | 945 | 6952 | 0.135932105868815 | 0.392984280621891 | 0.392984280621891 | false | false | false | true | ||||||||||||||||
| a4190f3b-fea7-414a-834e-275c9e5fffd7 | 2026-09-01 13:50 | 2026-09-01 13:50 | 2026-09-01 13:50 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 5.0000 | 4.9500 | 5.0500 | 38.1350 | 334500.00 | 0.00 | 234500.00 | 669 | 6 | 1614 | 6952 | 0.232163406214039 | 0.38905290954031 | 0.38905290954031 | false | false | false | true | ||||||||||||||||
| f567ab6c-b9fb-4245-a40a-c5e31ec5f130 | 2026-09-01 15:02 | 2026-09-01 15:02 | 2026-09-01 15:02 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 4.9500 | 4.9000 | 5.0500 | 38.0350 | 17820.00 | 0.00 | 17820.00 | 36 | 5 | 2228 | 6952 | 0.3204833141542 | 0.389428584082671 | 0.389428584082671 | false | false | false | true | ||||||||||||||||
| bb38e44b-de06-4b58-90df-d97f4db24368 | 2026-09-09 12:58 | 2026-09-09 12:58 | 2026-09-09 12:58 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 4.4000 | 4.3000 | 4.4000 | 37.0000 | 217360.00 | 217360.00 | 0.00 | 494 | 12 | 614 | 8969 | 0.0684580220760397 | 0.394005731711609 | 0.394005731711609 | false | false | false | |||||||||||||||||
| 1cdf5b99-9f19-4d30-9578-ccaa55440509 | 2026-09-10 15:30 | 2026-09-10 15:30 | 2026-09-10 15:30 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 4.2000 | 4.1000 | 4.2000 | 36.6350 | 31920.00 | 31920.00 | 0.00 | 76 | 9 | 261 | 9540 | 0.0273584905660377 | 0.395806795529725 | 0.395806795529725 | false | false | false | true | ||||||||||||||||
| 46bfc035-4d83-4e63-8f2c-738c9a751ff6 | 2026-09-16 13:33 | 2026-09-16 13:33 | 2026-09-16 13:33 | NKE | NKE270617C00040000 | call | 40.0000 | 2027-06-17 | 3.9000 | 3.8000 | 3.9000 | 36.3135 | 55770.00 | 55770.00 | 0.00 | 143 | 6 | 166 | 9957 | 0.0166716882595159 | 0.387942817768953 | 0.387942817768953 | false | false | false | true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-17T16:56:51.972483Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-25T13:56:08.271417Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 44538210735.00 |
| 2026-10-01 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-25T18:54:14.733334Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-25T19:21:53.483381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-26T15:22:15.766686Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-26T15:22:15.766686Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-26T15:22:15.766686Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-26T15:22:15.766686Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-26T15:22:15.766686Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-27T18:14:24.609292Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-28T19:57:19.773601Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-31T13:35:53.678596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-01T13:34:32.417809Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-01T17:48:11.364966Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-01T18:15:43.135015Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-01T19:21:20.162349Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 44538210735.00 |
| 2026-10-01 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-10T19:48:54.834059Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 43011529827.00 |
| 2026-10-01 |
| postmarket |
| — |
| 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 |