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_alerts326,449 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 |
|---|
| 081aab36-f655-43a3-8302-7850b8ee77e7 | 2026-08-25 11:14 | 2026-08-25 11:14 | 2026-08-25 11:14 | KDP | KDP270416C00035000 | call | 35.0000 | 2027-04-16 | 1.6000 | 1.6000 | 1.7500 | 31.9950 | 16000.00 | 0.00 | 16000.00 | 100 | 5 | 100 | 0 | 0 | 0.238720541921058 | 0.238720541921058 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 42974886280.00 | 2026-10-26 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:21:33.843586Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 04d2fee0-445f-4d7a-80f3-fecbc3906a30 | 2026-08-25 12:23 | 2026-08-25 12:23 | 2026-08-25 12:23 | KDP | KDP270115P00030000 | put | 30.0000 | 2027-01-15 | 1.1500 | 1.1500 | 1.2500 | 31.9950 | 61985.00 | 0.00 | 61985.00 | 539 | 23 | 539 | 429 | 1.25641025641026 | 0.281635505118821 | 0.281635505118821 | false | false | false | true | ||||||||||||||||
| 9f21f63b-75de-49fe-8909-2ee8896ab60c | 2026-08-25 12:32 | 2026-08-25 12:32 | 2026-08-25 12:32 | KDP | KDP270115C00034000 | call | 34.0000 | 2027-01-15 | 1.3500 | 1.2500 | 1.3500 | 32.0400 | 16470.00 | 16470.00 | 0.00 | 122 | 12 | 340 | 132 | 2.57575757575758 | 0.243081711411378 | 0.243081711411378 | false | false | false | true | ||||||||||||||||
| b2ce54b5-f775-4cdf-bcb2-eca76fa19187 | 2026-08-26 10:06 | 2026-08-26 10:06 | 2026-08-26 10:06 | KDP | KDP270115P00034000 | put | 34.0000 | 2027-01-15 | 3.3000 | 3.2000 | 3.4000 | 31.8750 | 21450.00 | 13200.00 | 8250.00 | 65 | 7 | 114 | 1 | 114 | 0.297123138470883 | 0.297123138470883 | false | false | false | true | ||||||||||||||||
| 013de2a1-cc05-4928-aff2-2bfdb626a274 | 2026-08-26 11:42 | 2026-08-26 11:42 | 2026-08-26 11:42 | KDP | KDP261016C00033000 | call | 33.0000 | 2026-10-16 | 0.7000 | 0.6500 | 0.7500 | 31.9600 | 18690.00 | 70.00 | 14630.00 | 267 | 8 | 268 | 3162 | 0.0847564832384567 | 0.223203972894013 | 0.223203972894013 | false | false | false | true | ||||||||||||||||
| 8db7c11d-d27a-446a-974d-de93a54f0664 | 2026-08-28 10:56 | 2026-08-28 10:56 | 2026-08-28 10:56 | KDP | KDP270416C00034000 | call | 34.0000 | 2027-04-16 | 2.0000 | 1.7500 | 2.1000 | 32.2700 | 31600.00 | 11600.00 | 20000.00 | 158 | 7 | 158 | 0 | 0 | 0.232601837943652 | 0.232601837943652 | false | false | false | true | ||||||||||||||||
| e53be9c7-5e40-4090-81d0-1ca0fb9e76c2 | 2026-08-28 11:24 | 2026-08-28 11:24 | 2026-08-28 11:24 | KDP | KDP260918C00033000 | call | 33.0000 | 2026-09-18 | 0.4500 | 0.4000 | 0.5000 | 32.4350 | 10170.00 | 0.00 | 10125.00 | 226 | 8 | 778 | 2291 | 0.339589698821475 | 0.213512686761385 | 0.213512686761385 | false | false | false | true | ||||||||||||||||
| 772dd1bf-bb49-4569-9d4b-4b82a8f0e769 | 2026-09-01 10:23 | 2026-09-01 10:23 | 2026-09-01 10:23 | KDP | KDP261218P00032000 | put | 32.0000 | 2026-12-18 | 1.7000 | 1.6500 | 1.9000 | 32.1650 | 10200.00 | 5610.00 | 4590.00 | 60 | 7 | 60 | 34 | 1.76470588235294 | 0.28303919008629 | 0.28303919008629 | false | false | false | true | ||||||||||||||||
| 557ceeb9-7cc6-4c56-b1ad-618363b97c19 | 2026-09-01 10:49 | 2026-09-01 10:49 | 2026-09-01 10:49 | KDP | KDP270115P00032000 | put | 32.0000 | 2027-01-15 | 2.0000 | 1.9500 | 2.0500 | 32.0050 | 12000.00 | 6400.00 | 5600.00 | 60 | 9 | 60 | 53 | 1.13207547169811 | 0.288714922509852 | 0.288714922509852 | false | false | false | true | ||||||||||||||||
| 9b9b35a5-8467-4205-8f4c-1290aa030f73 | 2026-09-03 15:10 | 2026-09-03 15:10 | 2026-09-03 15:10 | KDP | KDP260918C00034000 | call | 34.0000 | 2026-09-18 | 0.2500 | 0.2500 | 0.3000 | 33.0550 | 29675.00 | 0.00 | 29675.00 | 1187 | 46 | 5396 | 306 | 17.6339869281046 | 0.216200827298072 | 0.21854452422105 | false | false | false | true | ||||||||||||||||
| 224f0241-ca1e-454b-8182-a50e3af2b680 | 2026-09-03 15:19 | 2026-09-03 15:19 | 2026-09-03 15:19 | KDP | KDP260918C00034000 | call | 34.0000 | 2026-09-18 | 0.2500 | 0.2000 | 0.3000 | 33.0150 | 14450.00 | 0.00 | 13900.00 | 578 | 11 | 8489 | 306 | 27.7418300653595 | 0.223505990963587 | 0.223505990963587 | false | false | false | true | ||||||||||||||||
| ca348ea2-55b8-4389-9e0e-e3587cb77d4c | 2026-09-03 15:26 | 2026-09-03 15:25 | 2026-09-03 15:25 | KDP | KDP260918C00034000 | call | 34.0000 | 2026-09-18 | 0.2000 | 0.2000 | 0.2500 | 33.0000 | 53200.00 | 0.00 | 53200.00 | 2660 | 53 | 11171 | 306 | 36.5065359477124 | 0.20249317708608 | 0.20249317708608 | false | false | false | true | ||||||||||||||||
| 69e717ad-a747-46c4-8051-f8d537a74527 | 2026-09-03 15:38 | 2026-09-03 15:38 | 2026-09-03 15:38 | KDP | KDP260918C00034000 | call | 34.0000 | 2026-09-18 | 0.2000 | 0.2000 | 0.2500 | 32.9700 | 14480.00 | 0.00 | 14480.00 | 719 | 6 | 14432 | 306 | 47.1633986928105 | 0.206025491635113 | 0.210719268987067 | false | false | false | true | ||||||||||||||||
| b1749cdf-f2cf-4f0f-9fc8-81cc102a798e | 2026-09-03 15:42 | 2026-09-03 15:42 | 2026-09-03 15:42 | KDP | KDP260918C00034000 | call | 34.0000 | 2026-09-18 | 0.2000 | 0.2000 | 0.2500 | 32.9250 | 10000.00 | 0.00 | 10000.00 | 500 | 6 | 16088 | 306 | 52.5751633986928 | 0.211292882140757 | 0.211292882140757 | false | false | false | true | ||||||||||||||||
| 5041956e-eff4-4889-97cf-82745ed1ef3d | 2026-09-08 09:31 | 2026-09-08 09:31 | 2026-09-08 09:31 | KDP | KDP261218C00034000 | call | 34.0000 | 2026-12-18 | 1.2000 | 1.1250 | 1.5000 | 32.5650 | 67080.00 | 0.00 | 26760.00 | 559 | 51 | 559 | 468 | 1.19444444444444 | 0.241680227012581 | 0.241680227012581 | true | false | false | true | ||||||||||||||||
| 8c70fcbf-db51-4eeb-9ec6-1b39e4247968 | 2026-09-08 09:32 | 2026-09-08 09:32 | 2026-09-08 09:32 | KDP | KDP261218C00034000 | call | 34.0000 | 2026-12-18 | 1.2000 | 1.1000 | 1.5000 | 32.5950 | 52920.00 | 40680.00 | 12240.00 | 441 | 33 | 1000 | 468 | 2.13675213675214 | 0.239777658502637 | 0.239777658502637 | false | false | false | true | ||||||||||||||||
| 906b5f0c-d48b-49fe-bea5-1341e89982e6 | 2026-09-08 09:34 | 2026-09-08 09:33 | 2026-09-08 09:33 | KDP | KDP261218C00034000 | call | 34.0000 | 2026-12-18 | 1.2000 | 1.1000 | 1.2000 | 32.5950 | 15000.00 | 9000.00 | 0.00 | 125 | 10 | 1126 | 468 | 2.40598290598291 | 0.239777658502637 | 0.239777658502637 | true | false | false | true | ||||||||||||||||
| 391ed049-9d93-4cf1-aabd-9357baf9a50b | 2026-09-08 09:34 | 2026-09-08 09:34 | 2026-09-08 09:34 | KDP | KDP261218C00034000 | call | 34.0000 | 2026-12-18 | 1.2000 | 1.1500 | 1.3500 | 32.6100 | 92040.00 | 82080.00 | 3000.00 | 767 | 19 | 1894 | 468 | 4.04700854700855 | 0.2388245021907 | 0.2388245021907 | true | false | false | true | ||||||||||||||||
| 4756e1c5-f70d-406a-bcb9-83eb0f91c88a | 2026-09-08 10:28 | 2026-09-08 10:28 | 2026-09-08 10:28 | KDP | KDP261218C00034000 | call | 34.0000 | 2026-12-18 | 1.2000 | 1.1000 | 1.2500 | 32.6800 | 12840.00 | 6480.00 | 2400.00 | 107 | 18 | 2002 | 468 | 4.27777777777778 | 0.234359379644068 | 0.234359379644068 | true | false | false | true | ||||||||||||||||
| a915ae0f-80fd-482f-a965-d273a9966af0 | 2026-09-08 10:53 | 2026-09-08 10:53 | 2026-09-08 10:53 | KDP | KDP261218C00034000 | call | 34.0000 | 2026-12-18 | 1.2500 | 1.2000 | 1.2500 | 32.7650 | 250000.00 | 250000.00 | 0.00 | 2000 | 17 | 4004 | 468 | 8.55555555555556 | 0.236252606183716 | 0.236252606183716 | false | false | false | true | ||||||||||||||||
| 53459497-8dfc-4957-b21c-c2e589f3ae97 | 2026-09-18 09:30 | 2026-09-18 09:30 | 2026-09-18 09:30 | KDP | KDP270115P00030000 | put | 30.0000 | 2027-01-15 | 1.2000 | 1.2000 | 2.3500 | 31.3100 | 12000.00 | 0.00 | 12000.00 | 100 | 9 | 200 | 1094 | 0.182815356489945 | 0.280100747962082 | 0.280100747962082 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:29:52.792110Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:59:46.608693Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:48:55.759300Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:11:58.135920Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:36:02.227679Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:59:17.018627Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:48:49.580975Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:48:49.580975Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:33:29.575205Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:33:29.575205Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:39:51.680537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:39:51.680537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42974886280.00 |
| 2026-10-26 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Defensive |
| 42131174136.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:31:27.885359Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |