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_alerts609,118 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 |
|---|
| 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 |
|---|
| be024923-d5c0-496b-82d7-dd2b324cfa01 | 2026-09-15 16:00 | 2026-09-15 15:59 | 2026-09-15 15:59 | UHS | UHS270115C00175000 | call | 175.0000 | 2027-01-15 | 15.5000 | 14.7000 | 15.5000 | 176.0000 | 10850.00 | 1550.00 | 0.00 | 7 | 5 | 207 | 921 | 0.224755700325733 | 0.327581745495464 | 0.327581745495464 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 8954906153.00 | 2026-10-26 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 7f586ed8-01ce-4ac7-873b-51b89f1067fb | 2026-09-15 15:44 | 2026-09-15 15:44 | 2026-09-15 15:44 | UHS | UHS270115C00175000 | call | 175.0000 | 2027-01-15 | 15.7000 | 15.5000 | 15.7000 | 177.5300 | 10990.00 | 10990.00 | 0.00 | 7 | 6 | 107 | 921 | 0.116178067318132 | 0.324254620647778 | 0.324254620647778 | false | false | false | true | false | |||||||||||||||
| ff1f5c94-65d1-4b3b-b431-fedf19612995 | 2026-09-15 15:40 | 2026-09-15 15:40 | 2026-09-15 15:40 | UHS | UHS270115C00175000 | call | 175.0000 | 2027-01-15 | 16.0000 | 14.2000 | 16.6000 | 177.8600 | 158400.00 | 1600.00 | 14400.00 | 99 | 10 | 100 | 921 | 0.1085776330076 | 0.326834335035895 | 0.326834335035895 | false | false | false | true | false | |||||||||||||||
| 88124401-e31b-437d-84ea-68f273cf2d8e | 2026-09-11 15:43 | 2026-09-11 15:43 | 2026-09-11 15:43 | UHS | UHS270115C00175000 | call | 175.0000 | 2027-01-15 | 14.5000 | 14.5000 | 15.0000 | 174.9750 | 131950.00 | 0.00 | 131950.00 | 91 | 26 | 300 | 622 | 0.482315112540193 | 0.325909242660619 | 0.325979338871699 | false | false | false | true | false | |||||||||||||||
| 181bdfc6-369a-43e2-977b-4690100e37b5 | 2026-09-11 15:42 | 2026-09-11 15:42 | 2026-09-11 15:42 | UHS | UHS270115C00175000 | call | 175.0000 | 2027-01-15 | 14.6000 | 14.2000 | 14.6000 | 175.1100 | 13140.00 | 1460.00 | 0.00 | 9 | 7 | 209 | 622 | 0.336012861736334 | 0.326557181095958 | 0.326557181095958 | false | false | false | true | false | |||||||||||||||
| b9fbc544-2a5c-4be4-a4d6-15e806c6a032 | 2026-09-11 15:29 | 2026-09-11 15:29 | 2026-09-11 15:29 | UHS | UHS270115C00175000 | call | 175.0000 | 2027-01-15 | 14.4000 | 14.2000 | 14.5000 | 174.7800 | 144000.00 | 144000.00 | 0.00 | 100 | 12 | 200 | 622 | 0.321543408360129 | 0.326234436583121 | 0.326234436583121 | false | false | false | true | false | |||||||||||||||
| 8f0e1580-443a-4891-9134-2f29b616cde5 | 2026-09-11 15:13 | 2026-09-11 15:12 | 2026-09-11 15:12 | UHS | UHS270115C00175000 | call | 175.0000 | 2027-01-15 | 14.4000 | 14.3000 | 14.7000 | 174.3600 | 128160.00 | 126720.00 | 1440.00 | 89 | 10 | 100 | 622 | 0.160771704180064 | 0.332076694692235 | 0.332076694692235 | false | false | false | true | false | |||||||||||||||
| 9fac86a6-38cf-4219-b2af-9d3fd7a46444 | 2026-09-11 15:04 | 2026-09-11 15:04 | 2026-09-11 15:04 | UHS | UHS270115C00175000 | call | 175.0000 | 2027-01-15 | 14.7000 | 14.3000 | 14.7000 | 174.9700 | 16170.00 | 16170.00 | 0.00 | 11 | 9 | 11 | 622 | 0.0176848874598071 | 0.330995682520803 | 0.330995682520803 | false | false | false | true | false | |||||||||||||||
| bf7b9db5-c7cb-4145-8c6b-b379870db965 | 2026-08-21 15:58 | 2026-08-21 15:58 | 2026-08-21 15:58 | UHS | UHS270115C00175000 | call | 175.0000 | 2027-01-15 | 16.8000 | 16.3000 | 17.6000 | 177.2200 | 168000.00 | 3360.00 | 151200.00 | 100 | 10 | 600 | 15 | 40 | 0.320973601043381 | 0.320973601043381 | false | false | false | true | false | |||||||||||||||
| fb144b71-96fa-4da0-a021-b936e757d970 | 2026-08-21 15:50 | 2026-08-21 15:50 | 2026-08-21 15:50 | UHS | UHS270115C00175000 | call | 175.0000 | 2027-01-15 | 16.4000 | 15.7000 | 17.4000 | 176.0000 | 137760.00 | 136120.00 | 1640.00 | 84 | 11 | 500 | 15 | 33.3333333333333 | 0.32827598912448 | 0.32827598912448 | false | false | false | true | false | |||||||||||||||
| 09ff462c-3c43-4eba-b1a3-5e1cc2cc08b3 | 2026-08-21 12:35 | 2026-08-21 12:35 | 2026-08-21 12:35 | UHS | UHS270115C00175000 | call | 175.0000 | 2027-01-15 | 16.7000 | 16.1000 | 16.7000 | 176.4600 | 13360.00 | 3340.00 | 0.00 | 8 | 7 | 416 | 15 | 27.7333333333333 | 0.328987712312433 | 0.328987712312433 | false | false | false | true | false | |||||||||||||||
| 0a22dcde-ec78-4bb7-9740-834e94711e7c | 2026-08-21 12:16 | 2026-08-21 12:16 | 2026-08-21 12:16 | UHS | UHS270115C00175000 | call | 175.0000 | 2027-01-15 | 16.9000 | 16.4000 | 16.9000 | 176.7800 | 13520.00 | 13520.00 | 0.00 | 8 | 7 | 408 | 15 | 27.2 | 0.329253209551629 | 0.329253209551629 | false | false | false | true | false | |||||||||||||||
| 6b557e22-ea50-460c-895d-a8e1c93fcff0 | 2026-08-21 12:13 | 2026-08-21 12:13 | 2026-08-21 12:13 | UHS | UHS270115C00175000 | call | 175.0000 | 2027-01-15 | 16.9000 | 16.4000 | 17.4000 | 176.6500 | 169000.00 | 165620.00 | 0.00 | 100 | 10 | 400 | 15 | 26.6666666666667 | 0.331011740221634 | 0.331011740221634 | false | false | false | true | false | |||||||||||||||
| e2d9c1b5-eed9-4fd1-8643-ef52cda88d06 | 2026-08-21 11:50 | 2026-08-21 11:50 | 2026-08-21 11:50 | UHS | UHS270115C00175000 | call | 175.0000 | 2027-01-15 | 16.8000 | 16.4000 | 17.8000 | 176.5300 | 168000.00 | 164640.00 | 3360.00 | 100 | 10 | 300 | 15 | 20 | 0.33033789981048 | 0.33033789981048 | false | false | false | true | false | |||||||||||||||
| 88e0e3b0-944d-45a0-8717-2e5d024bf017 | 2026-08-21 11:42 | 2026-08-21 11:42 | 2026-08-21 11:42 | UHS | UHS270115C00175000 | call | 175.0000 | 2027-01-15 | 16.8000 | 16.4000 | 17.3500 | 176.7200 | 168000.00 | 161280.00 | 1680.00 | 100 | 10 | 200 | 15 | 13.3333333333333 | 0.327771841269691 | 0.327771841269691 | false | false | false | true | false | |||||||||||||||
| 390a82cd-bd88-4d19-95aa-bfb57e0e708f | 2026-08-21 11:02 | 2026-08-21 11:02 | 2026-08-21 11:02 | UHS | UHS270115C00175000 | call | 175.0000 | 2027-01-15 | 17.0000 | 16.0000 | 17.9000 | 176.7200 | 168300.00 | 168300.00 | 0.00 | 99 | 9 | 100 | 15 | 6.66666666666667 | 0.332358847684998 | 0.332358847684998 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8954906153.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:44:55.237483Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8954906153.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:44:55.237483Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8954906153.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:55:36.907305Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8954906153.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:55:36.907305Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8954906153.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8954906153.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8954906153.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:04:54.864587Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8954906153.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8954906153.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8954906153.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:43:46.028086Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8954906153.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8954906153.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8954906153.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8954906153.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8954906153.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |