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 |
|---|
| 03790deb-eaea-4a22-828f-3444ab862f6a | 2026-08-17 10:04 | 2026-08-17 10:04 | 2026-08-17 10:04 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 11.4500 | 11.4500 | 11.6500 | 147.6400 | 187780.00 | 0.00 | 187780.00 | 164 | 19 | 491 | 2921 | 0.168093118794933 | 0.662004513759422 | 0.663294448525696 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 1140205907062.00 | 2026-11-03 | unknown | — | 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 |
| a6e627cc-8bdc-4ef9-acb4-2e34ea46a2e8 | 2026-08-20 09:40 | 2026-08-20 09:40 | 2026-08-20 09:40 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 15.2000 | 15.0000 | 15.2500 | 136.4650 | 112470.00 | 101835.00 | 10635.00 | 74 | 21 | 123 | 4174 | 0.0294681360804983 | 0.637104803586384 | 0.637104803586384 | false | false | false | true | ||||||||||||||||
| fd1b898b-9b7d-410f-a68a-86f9288665f5 | 2026-08-21 14:01 | 2026-08-21 14:01 | 2026-08-21 14:01 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 15.0000 | 14.7000 | 15.0000 | 135.4700 | 769332.00 | 769332.00 | 0.00 | 513 | 43 | 1517 | 4402 | 0.344616083598364 | 0.61062173934247 | 0.609917010575825 | false | false | false | true | ||||||||||||||||
| 84b8bb4f-e501-4f0b-99c8-239c3d4d34c4 | 2026-08-28 09:40 | 2026-08-28 09:40 | 2026-08-28 09:40 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 9.4500 | 9.3000 | 9.5000 | 142.3550 | 159705.00 | 158760.00 | 0.00 | 169 | 21 | 186 | 5213 | 0.0356800306924995 | 0.531177071218717 | 0.531177071218717 | true | false | false | true | ||||||||||||||||
| 495b3a5b-031d-4b99-b996-d6aea41d7b6d | 2026-09-11 13:24 | 2026-09-11 13:23 | 2026-09-11 13:23 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 4.8000 | 4.8000 | 4.9000 | 149.9500 | 131043.00 | 0.00 | 131043.00 | 273 | 39 | 769 | 8545 | 0.0899941486249269 | 0.509147777301818 | 0.509700563754558 | false | false | false | true | ||||||||||||||||
| de70bccd-7638-4fdd-8ac4-a6ab571e0852 | 2026-09-21 12:59 | 2026-09-21 12:59 | 2026-09-21 12:59 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 2.5000 | 2.5000 | 2.5300 | 154.3400 | 20000.00 | 0.00 | 20000.00 | 80 | 9 | 1939 | 10343 | 0.187469786328918 | 0.504576844429979 | 0.504576844429979 | true | false | false | true | ||||||||||||||||
| db3a04d6-632e-45ef-8b0a-6f510ba2f929 | 2026-09-21 14:41 | 2026-09-21 14:41 | 2026-09-21 14:41 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 3.0000 | 2.9900 | 3.0500 | 152.1300 | 15300.00 | 0.00 | 15300.00 | 51 | 11 | 2240 | 10343 | 0.216571594314996 | 0.505593397648845 | 0.505593397648845 | false | false | false | true | ||||||||||||||||
| e61aa984-6a97-406d-ada7-18dca6f06d00 | 2026-09-22 10:10 | 2026-09-22 10:10 | 2026-09-22 10:10 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 2.7000 | 2.7000 | 2.7300 | 152.7500 | 27000.00 | 0.00 | 27000.00 | 100 | 20 | 369 | 10731 | 0.0343863572826391 | 0.502418730300049 | 0.502418730300049 | false | false | false | true | ||||||||||||||||
| 5675fdd6-c4fd-4ebb-9313-e64ce6557ea0 | 2026-09-22 13:04 | 2026-09-22 13:03 | 2026-09-22 13:03 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 2.5400 | 2.5400 | 2.5700 | 153.0000 | 139446.00 | 0.00 | 139446.00 | 549 | 39 | 1622 | 10731 | 0.151150871307427 | 0.501061263560782 | 0.501061263560782 | false | false | false | true | ||||||||||||||||
| e847c981-c17d-431a-a78d-b504f5d4e63c | 2026-09-23 15:32 | 2026-09-23 15:31 | 2026-09-23 15:31 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 3.5000 | 3.4500 | 3.5500 | 148.3650 | 30094.00 | 29744.00 | 350.00 | 86 | 15 | 2355 | 11574 | 0.203473302229134 | 0.486723011148439 | 0.486723011148439 | false | false | false | true | ||||||||||||||||
| 1bb4048e-c3f4-4bdc-83df-fc2f9e3fa106 | 2026-09-23 15:44 | 2026-09-23 15:44 | 2026-09-23 15:44 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 3.5000 | 3.4500 | 3.5000 | 148.0000 | 20300.00 | 20300.00 | 0.00 | 58 | 5 | 2461 | 11574 | 0.212631760843269 | 0.489329541642878 | 0.489329541642878 | false | false | false | true | ||||||||||||||||
| 6f8f13db-a3ce-4d0f-b053-2850b0293863 | 2026-09-24 09:44 | 2026-09-24 09:43 | 2026-09-24 09:43 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 3.7500 | 3.7000 | 3.7500 | 147.1850 | 18750.00 | 18750.00 | 0.00 | 50 | 5 | 214 | 12946 | 0.0165302023791132 | 0.489117312686297 | 0.489117312686297 | true | false | false | true | ||||||||||||||||
| b2bb6272-9765-4ca1-b0c5-1a263f6e5a01 | 2026-09-24 09:44 | 2026-09-24 09:44 | 2026-09-24 09:44 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 3.8000 | 3.7500 | 3.8500 | 146.9200 | 16720.00 | 0.00 | 15200.00 | 44 | 19 | 259 | 12946 | 0.0200061795149081 | 0.486559354393619 | 0.486559354393619 | false | false | false | true | ||||||||||||||||
| 8408d309-0e66-44bb-ad93-e71ba1ea25d2 | 2026-09-24 14:42 | 2026-09-24 14:42 | 2026-09-24 14:42 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 3.2500 | 3.2000 | 3.3000 | 147.0000 | 269750.00 | 650.00 | 269100.00 | 830 | 55 | 2002 | 12946 | 0.154642360574695 | 0.460532705268625 | 0.460532705268625 | false | false | false | true | ||||||||||||||||
| 253c6354-914c-429c-97bb-a8d6c59bdf97 | 2026-09-24 15:48 | 2026-09-24 15:48 | 2026-09-24 15:48 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 3.2000 | 3.1500 | 3.2000 | 147.6900 | 32000.00 | 32000.00 | 0.00 | 100 | 9 | 2268 | 12946 | 0.17518924764406 | 0.457445049595915 | 0.457445049595915 | true | false | false | true | ||||||||||||||||
| 34e6b8f1-e29d-43f3-98b1-0a6d0560297d | 2026-09-25 10:09 | 2026-09-25 10:09 | 2026-09-25 10:09 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 3.0700 | 3.0000 | 3.1000 | 147.5650 | 12272.00 | 12272.00 | 0.00 | 40 | 7 | 117 | 13916 | 0.00840758838746766 | 0.453284434500618 | 0.453284434500618 | false | false | false | true | ||||||||||||||||
| ef9ca21b-bb22-4b55-8a75-b98550abcf4d | 2026-09-25 10:18 | 2026-09-25 10:17 | 2026-09-25 10:17 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 3.4500 | 3.4000 | 3.4500 | 146.3050 | 11385.00 | 11385.00 | 0.00 | 33 | 6 | 169 | 13916 | 0.0121442943374533 | 0.454095049518995 | 0.454095049518995 | false | false | false | true | ||||||||||||||||
| f66ea174-365e-4643-a68c-0ead6d07ddf4 | 2026-09-25 15:48 | 2026-09-25 15:48 | 2026-09-25 15:48 | SPCX | SPCX261016P00140000 | put | 140.0000 | 2026-10-16 | 2.7700 | 2.7400 | 2.7700 | 148.0000 | 132960.00 | 132960.00 | 0.00 | 480 | 47 | 1358 | 13916 | 0.0975855130784708 | 0.457655028424791 | 0.458107271462005 | true | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1140205907062.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 1140205907062.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:03:10.492596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1140205907062.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:45:11.106617Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1140205907062.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T17:27:08.545704Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1168682193638.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:02:00.389820Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1168682193638.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:42:48.011261Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1190770556468.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:11:50.316445Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1190770556468.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:06:21.234354Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1141822128733.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:37:14.904379Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1141822128733.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:47:37.737983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1141822128733.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:45:09.673618Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1141822128733.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:45:09.673618Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1141822128733.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:51:39.883666Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1141822128733.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:50:03.728318Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 1144284942707.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:11:57.153448Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1144284942707.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:19:54.895833Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 1144284942707.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:51:07.574812Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |