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 |
|---|
| dc00d149-df66-4ef4-80b6-892c652888d6 | 2026-09-22 15:40 | 2026-09-22 15:40 | 2026-09-22 15:40 | MDT | MDT261002C00091000 | call | 91.0000 | 2026-10-02 | 1.2000 | 1.1200 | 1.2500 | 90.8800 | 12000.00 | 1560.00 | 6960.00 | 100 | 7 | 191 | 673 | 0.283803863298663 | 0.201720297221479 | 0.201720297221479 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 116107346275.00 | 2026-11-17 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 74d1d2ad-8396-4718-a8e0-e4f491e699aa | 2026-09-22 15:40 | 2026-09-22 15:40 | 2026-09-22 15:40 | MDT | MDT261002C00091000 | call | 91.0000 | 2026-10-02 | 1.2200 | 1.2200 | 1.2400 | 90.8800 | 10492.00 | 0.00 | 3050.00 | 86 | 6 | 377 | 673 | 0.560178306092125 | 0.205053173329586 | 0.205053173329586 | false | false | false | true | ||||||||||||||||
| 7382beec-2ae8-439e-b35b-8c6fe1d929ed | 2026-09-22 15:40 | 2026-09-22 15:40 | 2026-09-22 15:40 | MDT | MDT261002C00091000 | call | 91.0000 | 2026-10-02 | 1.2200 | 1.1600 | 1.2500 | 90.8800 | 12200.00 | 1708.00 | 5002.00 | 100 | 7 | 291 | 673 | 0.432392273402675 | 0.205053173329586 | 0.205053173329586 | false | false | false | true | ||||||||||||||||
| ebeb199b-561d-4637-8d2b-533ce05e1ada | 2026-09-22 15:40 | 2026-09-22 15:40 | 2026-09-22 15:40 | MDT | MDT261002C00091000 | call | 91.0000 | 2026-10-02 | 1.2200 | 1.0500 | 1.2500 | 90.8500 | 12200.00 | 1708.00 | 5002.00 | 100 | 7 | 791 | 673 | 1.17533432392273 | 0.207563896804198 | 0.207563896804198 | false | false | false | true | ||||||||||||||||
| a0b1238a-26f5-4ee1-a8ec-1cc84d13d949 | 2026-09-22 15:40 | 2026-09-22 15:40 | 2026-09-22 15:40 | MDT | MDT261002C00091000 | call | 91.0000 | 2026-10-02 | 1.2200 | 1.0500 | 1.2500 | 90.8500 | 12200.00 | 1464.00 | 5124.00 | 100 | 8 | 691 | 673 | 1.02674591381872 | 0.207563896804198 | 0.207563896804198 | false | false | false | true | ||||||||||||||||
| 8d54dbc9-5ff8-40e5-a7e0-dc98bbb36c8c | 2026-09-22 15:40 | 2026-09-22 15:40 | 2026-09-22 15:40 | MDT | MDT261002C00091000 | call | 91.0000 | 2026-10-02 | 1.2200 | 1.0500 | 1.2500 | 90.8700 | 12200.00 | 3660.00 | 3782.00 | 100 | 7 | 491 | 673 | 0.729569093610698 | 0.205892072356487 | 0.205892072356487 | false | false | false | true | ||||||||||||||||
| 1f67fb6c-ab4b-4719-b8a9-38244065755f | 2026-09-22 15:40 | 2026-09-22 15:40 | 2026-09-22 15:40 | MDT | MDT261002C00091000 | call | 91.0000 | 2026-10-02 | 1.2200 | 1.0500 | 1.2500 | 90.8500 | 12200.00 | 1586.00 | 6832.00 | 100 | 7 | 591 | 673 | 0.87815750371471 | 0.207563896804198 | 0.207563896804198 | false | false | false | true | ||||||||||||||||
| b08d84f9-3985-4f48-b2fc-da9fb8fcbb6e | 2026-09-22 15:41 | 2026-09-22 15:41 | 2026-09-22 15:41 | MDT | MDT261002C00091000 | call | 91.0000 | 2026-10-02 | 1.2200 | 1.2200 | 1.2400 | 90.8500 | 11346.00 | 0.00 | 11346.00 | 93 | 8 | 1148 | 673 | 1.70579494799406 | 0.208396870725658 | 0.207563896804198 | false | false | false | true | ||||||||||||||||
| 8cd99453-412d-4556-91ad-a68c399fd73e | 2026-09-22 15:41 | 2026-09-22 15:41 | 2026-09-22 15:41 | MDT | MDT261002C00091000 | call | 91.0000 | 2026-10-02 | 1.2200 | 1.2200 | 1.2400 | 90.8400 | 12200.00 | 0.00 | 12200.00 | 100 | 7 | 1055 | 673 | 1.56760772659733 | 0.208396870725658 | 0.208396870725658 | false | false | false | true | ||||||||||||||||
| 7b1f6e58-946b-4957-8375-28b5163cf62f | 2026-09-22 15:41 | 2026-09-22 15:41 | 2026-09-22 15:41 | MDT | MDT261002C00091000 | call | 91.0000 | 2026-10-02 | 1.2200 | 0.9900 | 1.2400 | 90.8600 | 12200.00 | 1586.00 | 10614.00 | 100 | 7 | 955 | 673 | 1.41901931649331 | 0.20672897201669 | 0.20672897201669 | false | false | false | true | ||||||||||||||||
| a3d7aba6-e4e6-4c19-9516-681f8cf0940d | 2026-09-22 15:41 | 2026-09-22 15:41 | 2026-09-22 15:41 | MDT | MDT261002C00091000 | call | 91.0000 | 2026-10-02 | 1.2100 | 1.1000 | 1.2300 | 90.8400 | 12100.00 | 1573.00 | 1815.00 | 100 | 7 | 1348 | 673 | 2.00297176820208 | 0.206729774908116 | 0.206729774908116 | false | false | false | true | ||||||||||||||||
| 7f763c33-e6ac-4c2f-91d0-65781e11460c | 2026-09-22 15:41 | 2026-09-22 15:41 | 2026-09-22 15:41 | MDT | MDT261002C00091000 | call | 91.0000 | 2026-10-02 | 1.2100 | 1.1400 | 1.2400 | 90.8400 | 12100.00 | 1573.00 | 6655.00 | 100 | 7 | 1248 | 673 | 1.85438335809807 | 0.206729774908116 | 0.206729774908116 | false | false | false | true | ||||||||||||||||
| da3de1df-ce1b-4aa1-9802-41b4b412bebb | 2026-09-22 15:42 | 2026-09-22 15:42 | 2026-09-22 15:42 | MDT | MDT261002C00091000 | call | 91.0000 | 2026-10-02 | 1.2100 | 1.1300 | 1.2400 | 90.7800 | 12100.00 | 1815.00 | 4961.00 | 100 | 7 | 1528 | 673 | 2.2704309063893 | 0.21168649326983 | 0.21168649326983 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 116107346275.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 116107346275.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 116107346275.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 116107346275.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 116107346275.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 116107346275.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 116107346275.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 116107346275.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 116107346275.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 116107346275.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 116107346275.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 116107346275.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |