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_alerts523,327 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 |
|---|
| 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 | false | 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 |
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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-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 |
| 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 |
| 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 |