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_alerts566,287 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 |
|---|
| daa74cba-1026-4170-8b29-8695d1b40752 | 2026-09-29 15:16 | 2026-09-29 15:16 | 2026-09-29 15:16 | DGX | DGX261016P00240000 | put | 240.0000 | 2026-10-16 | 10.0400 | 9.8000 | 10.7000 | 231.6100 | 10040.00 | 8040.00 | 2000.00 | 10 | 5 | 378 | 904 | 0.418141592920354 | 0.256126581468677 | 0.250159697967196 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 25603308319.00 | 2026-10-22 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T19:19:47.796405Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 6ca356ed-7359-4732-8615-4849355b1efc | 2026-09-29 15:16 | 2026-09-29 15:16 | 2026-09-29 15:16 | DGX | DGX261016P00240000 | put | 240.0000 | 2026-10-16 | 10.1000 | 9.8000 | 10.7000 | 231.6100 | 10100.00 | 2020.00 | 8080.00 | 10 | 5 | 364 | 904 | 0.402654867256637 | 0.256126581468677 | 0.256126581468677 | false | false | false | true | ||||||||||||||||
| aeebd9aa-c2be-416b-89b0-567618f8d399 | 2026-09-29 15:10 | 2026-09-29 15:10 | 2026-09-29 15:10 | DGX | DGX261016P00240000 | put | 240.0000 | 2026-10-16 | 10.0100 | 9.9000 | 10.9000 | 231.6700 | 12010.00 | 7010.00 | 5000.00 | 12 | 8 | 344 | 904 | 0.380530973451327 | 0.252750425358051 | 0.252750425358051 | false | false | false | true | ||||||||||||||||
| 51c2fcd4-0e49-4fbe-89ef-bdeeed8e742e | 2026-09-29 15:07 | 2026-09-29 15:07 | 2026-09-29 15:07 | DGX | DGX261016P00240000 | put | 240.0000 | 2026-10-16 | 9.6000 | 9.2000 | 10.8000 | 231.8700 | 15360.00 | 7680.00 | 7680.00 | 16 | 8 | 269 | 904 | 0.297566371681416 | 0.237471596585619 | 0.237471596585619 | false | false | false | true | ||||||||||||||||
| 895cddd0-d1a1-4fb6-8a09-7209d2c996d5 | 2026-09-29 14:53 | 2026-09-29 14:53 | 2026-09-29 14:53 | DGX | DGX261016P00240000 | put | 240.0000 | 2026-10-16 | 9.2000 | 8.4000 | 9.8000 | 232.7650 | 11040.00 | 11040.00 | 0.00 | 12 | 6 | 135 | 904 | 0.149336283185841 | 0.251241322958783 | 0.251241322958783 | false | false | false | true | ||||||||||||||||
| c9bd0419-b77b-4e86-903a-d573e4430b29 | 2026-09-29 14:50 | 2026-09-29 14:50 | 2026-09-29 14:50 | DGX | DGX261016P00240000 | put | 240.0000 | 2026-10-16 | 9.2000 | 8.4000 | 10.4000 | 232.8250 | 11040.00 | 3680.00 | 7360.00 | 12 | 6 | 114 | 904 | 0.126106194690265 | 0.253581624776405 | 0.253581624776405 | false | false | false | true | ||||||||||||||||
| 62ecee48-b8ae-4936-9c0b-931659571a2f | 2026-09-25 11:47 | 2026-09-25 11:47 | 2026-09-25 11:47 | DGX | DGX261016P00240000 | put | 240.0000 | 2026-10-16 | 7.1000 | 6.1000 | 7.9000 | 237.4800 | 62479.00 | 61769.00 | 710.00 | 88 | 35 | 88 | 844 | 0.104265402843602 | 0.265872066476897 | 0.265872066476897 | false | false | false | true | ||||||||||||||||
| bf26faae-1775-4846-b3e8-4357fa3a6348 | 2026-09-23 11:25 | 2026-09-23 11:25 | 2026-09-23 11:25 | DGX | DGX261016P00240000 | put | 240.0000 | 2026-10-16 | 7.4000 | 6.9000 | 7.8000 | 237.3317 | 13320.00 | 8880.00 | 4440.00 | 18 | 5 | 19 | 333 | 0.0570570570570571 | 0.264462145566403 | 0.264462145566403 | false | false | false | true | ||||||||||||||||
| ceb25752-e8c0-4e26-b60c-933c7f593949 | 2026-09-22 11:36 | 2026-09-22 11:36 | 2026-09-22 11:36 | DGX | DGX261016P00240000 | put | 240.0000 | 2026-10-16 | 9.6100 | 9.5000 | 10.3000 | 233.0928 | 13450.00 | 960.00 | 12490.00 | 14 | 6 | 95 | 301 | 0.315614617940199 | 0.243272452553109 | 0.245728274136981 | true | false | false | true | ||||||||||||||||
| 03f7c025-26e9-466e-800c-26b5876b9181 | 2026-09-22 11:32 | 2026-09-22 11:32 | 2026-09-22 11:32 | DGX | DGX261016P00240000 | put | 240.0000 | 2026-10-16 | 10.5000 | 9.6000 | 11.4000 | 232.0000 | 15750.00 | 9450.00 | 0.00 | 15 | 5 | 71 | 301 | 0.235880398671096 | 0.255676088660636 | 0.255676088660636 | false | false | false | true | ||||||||||||||||
| 0f5a8634-e4ee-4c32-963c-c8331f4d89ff | 2026-09-22 10:19 | 2026-09-22 10:19 | 2026-09-22 10:19 | DGX | DGX261016P00240000 | put | 240.0000 | 2026-10-16 | 9.0000 | 8.3000 | 10.6000 | 235.7200 | 44100.00 | 28800.00 | 15300.00 | 49 | 10 | 51 | 301 | 0.169435215946844 | 0.285997308645764 | 0.288996926978134 | false | false | false | true | ||||||||||||||||
| 8309e23d-4d92-47d2-9959-51b881896caa | 2026-09-10 12:15 | 2026-09-10 12:15 | 2026-09-10 12:15 | DGX | DGX261016P00240000 | put | 240.0000 | 2026-10-16 | 12.5000 | 11.2000 | 13.6000 | 231.7600 | 725000.00 | 725000.00 | 0.00 | 580 | 2 | 580 | 581 | 0.998278829604131 | 0.282848745338839 | 0.282848745338839 | false | true | true | false | ||||||||||||||||
| e8658b12-aa93-42b8-bbb1-2a6ee72a2e93 | 2026-09-04 14:39 | 2026-09-04 14:39 | 2026-09-04 14:39 | DGX | DGX261016P00240000 | put | 240.0000 | 2026-10-16 | 8.5000 | 7.2000 | 8.5000 | 238.4440 | 53550.00 | 53550.00 | 0.00 | 63 | 10 | 330 | 251 | 1.31474103585657 | 0.255756211025381 | 0.255756211025381 | true | false | false | true | ||||||||||||||||
| f315dda9-99e0-498b-9cfe-caf333181466 | 2026-09-04 14:39 | 2026-09-04 14:38 | 2026-09-04 14:38 | DGX | DGX261016P00240000 | put | 240.0000 | 2026-10-16 | 8.4000 | 8.4000 | 8.5000 | 238.4440 | 10080.00 | 0.00 | 10080.00 | 12 | 12 | 267 | 251 | 1.06374501992032 | 0.252656572937267 | 0.252656572937267 | false | false | false | true | ||||||||||||||||
| b72ee3c4-e9a2-4501-b08f-d286a9436a03 | 2026-09-04 10:57 | 2026-09-04 10:57 | 2026-09-04 10:57 | DGX | DGX261016P00240000 | put | 240.0000 | 2026-10-16 | 7.8000 | 7.8000 | 8.4000 | 238.0800 | 30420.00 | 0.00 | 30420.00 | 39 | 5 | 159 | 251 | 0.633466135458167 | 0.228432508779634 | 0.228432508779634 | false | false | false | true | ||||||||||||||||
| 159e0e20-7bb6-4960-a1ca-19cf9ef1f697 | 2026-09-03 14:23 | 2026-09-03 14:23 | 2026-09-03 14:23 | DGX | DGX261016P00240000 | put | 240.0000 | 2026-10-16 | 8.2500 | 7.5000 | 9.0000 | 236.5600 | 167470.00 | 83830.00 | 83640.00 | 203 | 2 | 250 | 4 | 62.5 | 0.213200996401764 | 0.213200996401764 | false | true | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25603308319.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:19:47.796405Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25603308319.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:11:44.120733Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25603308319.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:11:44.120733Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25603308319.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:01:46.856083Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25603308319.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:53:35.621722Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 26083432435.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:51:49.898119Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25716992880.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:28:13.578365Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25911249994.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:38:41.762966Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25911249994.00 |
| 2026-10-20 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:34:09.835499Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 25911249994.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:20:22.518739Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Healthcare |
| 26256718610.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T16:37:06.868856Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 26256718610.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:05:15.166096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 26256718610.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:05:15.166096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 26256718610.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Healthcare |
| 26256718610.00 |
| 2026-10-20 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T18:47:01.806289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |