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_alerts326,449 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 |
|---|
| 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 |
|---|
| ade65c6a-9c56-4983-a137-dc5335787b3c | 2026-09-17 15:45 | 2026-09-17 15:45 | 2026-09-17 15:45 | DVA | DVA261016C00180000 | call | 180.0000 | 2026-10-16 | 8.5000 | 7.5000 | 8.5000 | 183.1900 | 19550.00 | 19550.00 | 0.00 | 23 | 13 | 23 | 278 | 0.0827338129496403 | 0.326299902508278 | 0.316419990989772 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 11681142000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 92d968e5-e8d7-46b3-becc-ccd99846587f | 2026-09-17 15:45 | 2026-09-17 15:45 | 2026-09-17 15:45 | DVA | DVA261016C00175000 | call | 175.0000 | 2026-10-16 | 11.7000 | 10.3000 | 11.7000 | 183.1900 | 46800.00 | 46800.00 | 0.00 | 40 | 19 | 40 | 19 | 2.10526315789474 | 0.331916039363674 | 0.318628725036575 | true | false | false | true | ||||||||||||||||
| 4d986888-d28b-4709-911d-1a78cb1781d0 | 2026-09-17 15:45 | 2026-09-17 15:45 | 2026-09-17 15:45 | DVA | DVA261016C00185000 | call | 185.0000 | 2026-10-16 | 5.9000 | 4.9000 | 5.9000 | 183.1900 | 33630.00 | 33630.00 | 0.00 | 57 | 12 | 63 | 59 | 1.06779661016949 | 0.322040963890038 | 0.314388563660464 | true | false | false | true | ||||||||||||||||
| a01bff08-c041-4364-b354-dd0454ab7025 | 2026-09-17 14:59 | 2026-09-17 14:59 | 2026-09-17 14:59 | DVA | DVA261016C00210000 | call | 210.0000 | 2026-10-16 | 1.0000 | 0.7000 | 1.3500 | 185.7000 | 49800.00 | 14800.00 | 35000.00 | 498 | 8 | 540 | 1233 | 0.437956204379562 | 0.344450120210513 | 0.344450120210513 | false | false | false | true | ||||||||||||||||
| a784ce22-7091-4231-b3ba-300d0949130a | 2026-09-17 14:49 | 2026-09-17 14:49 | 2026-09-17 14:49 | DVA | DVA261016P00190000 | put | 190.0000 | 2026-10-16 | 8.4000 | 6.2000 | 8.4000 | 186.2000 | 32758.00 | 32758.00 | 0.00 | 39 | 12 | 41 | 76 | 0.539473684210526 | 0.316258333843144 | 0.316258333843144 | false | false | false | true | ||||||||||||||||
| 89376b48-b784-4434-a71f-08d0f37620bf | 2026-09-17 14:49 | 2026-09-17 14:49 | 2026-09-17 14:49 | DVA | DVA261016P00185000 | put | 185.0000 | 2026-10-16 | 5.6900 | 5.0000 | 6.0000 | 186.2000 | 10250.00 | 9680.00 | 570.00 | 18 | 8 | 23 | 43 | 0.534883720930233 | 0.314531936222255 | 0.314531936222255 | true | false | false | true | ||||||||||||||||
| 64306bcf-a614-42a8-87f4-d84e8e751131 | 2026-09-17 14:09 | 2026-09-17 14:09 | 2026-09-17 14:09 | DVA | DVA261120C00190000 | call | 190.0000 | 2026-11-20 | 13.2000 | 12.8000 | 14.1000 | 187.9500 | 62040.00 | 30360.00 | 31680.00 | 47 | 12 | 63 | 266 | 0.236842105263158 | 0.430901175445383 | 0.430901175445383 | false | false | false | true | ||||||||||||||||
| 63cf6f8e-594d-4a05-accb-250e06a23c5d | 2026-09-15 15:32 | 2026-09-15 15:32 | 2026-09-15 15:32 | DVA | DVA261016C00210000 | call | 210.0000 | 2026-10-16 | 1.7000 | 1.1000 | 1.7000 | 191.3000 | 34000.00 | 34000.00 | 0.00 | 200 | 33 | 974 | 231 | 4.21645021645022 | 0.322328904124093 | 0.322328904124093 | true | false | false | true | ||||||||||||||||
| 86bb2d4d-e622-48e4-8d48-60da237f7d35 | 2026-09-15 15:31 | 2026-09-15 15:31 | 2026-09-15 15:31 | DVA | DVA261016C00210000 | call | 210.0000 | 2026-10-16 | 1.7000 | 1.1000 | 1.7000 | 191.0500 | 65620.00 | 65620.00 | 0.00 | 386 | 33 | 774 | 231 | 3.35064935064935 | 0.325413780582084 | 0.325413780582084 | true | false | false | true | ||||||||||||||||
| 0475739f-b9b3-4a9c-9fbe-f3fe15eb8afc | 2026-09-14 13:08 | 2026-09-14 13:08 | 2026-09-14 13:08 | DVA | DVA270820C00260000 | call | 260.0000 | 2027-08-20 | 9.9000 | 9.1000 | 10.3000 | 188.4700 | 40590.00 | 11880.00 | 28710.00 | 41 | 7 | 42 | 19 | 2.21052631578947 | 0.377749112295505 | 0.377749112295505 | false | false | false | true | ||||||||||||||||
| 9ab5ab01-b758-4d5b-9d0d-5a5c84adbe79 | 2026-09-02 12:50 | 2026-09-02 12:50 | 2026-09-02 12:50 | DVA | DVA270820P00195000 | put | 195.0000 | 2027-08-20 | 32.4000 | 30.8000 | 33.5000 | 179.2100 | 100440.00 | 25920.00 | 74520.00 | 31 | 10 | 31 | 2 | 15.5 | 0.394937732528514 | 0.394937732528514 | false | false | false | true | ||||||||||||||||
| b2ba45fc-288e-4a1c-aa36-f3d27c3042b6 | 2026-09-01 13:36 | 2026-09-01 13:36 | 2026-09-01 13:36 | DVA | DVA270115P00180000 | put | 180.0000 | 2027-01-15 | 16.0000 | 15.0000 | 16.5000 | 177.0750 | 153600.00 | 35200.00 | 118400.00 | 96 | 14 | 96 | 56 | 1.71428571428571 | 0.368418818923997 | 0.368418818923997 | false | false | false | true | ||||||||||||||||
| 7f12ece5-c28a-4cce-b8ff-247bb3075ef8 | 2026-08-28 09:50 | 2026-08-28 09:50 | 2026-08-28 09:50 | DVA | DVA261120C00190000 | call | 190.0000 | 2026-11-20 | 10.0000 | 9.7000 | 10.7000 | 180.0450 | 23000.00 | 16000.00 | 7000.00 | 23 | 6 | 78 | 69 | 1.1304347826087 | 0.390601981940254 | 0.390601981940254 | false | false | false | true | ||||||||||||||||
| 04528313-6139-41a0-87a7-ee47c484cd63 | 2026-08-28 09:50 | 2026-08-28 09:50 | 2026-08-28 09:50 | DVA | DVA261120C00190000 | call | 190.0000 | 2026-11-20 | 9.7000 | 9.7000 | 12.0000 | 180.0450 | 26190.00 | 0.00 | 8730.00 | 27 | 7 | 55 | 69 | 0.797101449275362 | 0.381796888695514 | 0.381796888695514 | false | false | false | true | ||||||||||||||||
| 8eeda0c2-2462-48d6-822e-69dda5b095c1 | 2026-08-28 09:50 | 2026-08-28 09:50 | 2026-08-28 09:50 | DVA | DVA261120C00190000 | call | 190.0000 | 2026-11-20 | 10.4000 | 8.8000 | 11.3000 | 180.0450 | 29120.00 | 11440.00 | 5200.00 | 28 | 6 | 28 | 69 | 0.405797101449275 | 0.402327172444017 | 0.402327172444017 | false | false | false | true | ||||||||||||||||
| 638b9caf-a72c-4c9a-a315-9fa127a6af8f | 2026-08-25 12:37 | 2026-08-25 12:37 | 2026-08-25 12:37 | DVA | DVA261218P00175000 | put | 175.0000 | 2026-12-18 | 13.1000 | 13.1000 | 13.5000 | 176.9500 | 301300.00 | 0.00 | 301300.00 | 230 | 36 | 253 | 7 | 36.1428571428571 | 0.385157508263348 | 0.385157508263348 | false | false | false | true | ||||||||||||||||
| 471c9957-31d6-4b08-a7a8-560400586f95 | 2026-08-25 12:37 | 2026-08-25 12:37 | 2026-08-25 12:37 | DVA | DVA261218C00185000 | call | 185.0000 | 2026-12-18 | 12.7000 | 12.2000 | 13.0000 | 176.9500 | 12700.00 | 2540.00 | 10160.00 | 10 | 5 | 10 | 241 | 0.04149377593361 | 0.383728109457295 | 0.383728109457295 | false | false | false | true | ||||||||||||||||
| e19b87af-f694-41c1-a280-d5649a4263c2 | 2026-08-24 14:47 | 2026-08-24 14:46 | 2026-08-24 14:46 | DVA | DVA261218P00180000 | put | 180.0000 | 2026-12-18 | 17.6000 | 17.6000 | 18.1000 | 173.5700 | 52800.00 | 0.00 | 52800.00 | 30 | 9 | 31 | 21 | 1.47619047619048 | 0.390633330936868 | 0.390633330936868 | false | false | false | true | ||||||||||||||||
| 50f5cc65-3699-4b71-b588-910f871e6ab4 | 2026-08-21 11:54 | 2026-08-21 11:53 | 2026-08-21 11:53 | DVA | DVA260918P00175000 | put | 175.0000 | 2026-09-18 | 5.2000 | 5.2000 | 5.5000 | 175.6500 | 72280.00 | 0.00 | 72280.00 | 139 | 18 | 149 | 136 | 1.09558823529412 | 0.297905184807056 | 0.297905184807056 | false | false | false | true | ||||||||||||||||
| 2d468ece-ac3b-49dc-b1c1-0edbcd1d8d19 | 2026-08-20 12:48 | 2026-08-20 12:48 | 2026-08-20 12:48 | DVA | DVA261016C00180000 | call | 180.0000 | 2026-10-16 | 7.6000 | 7.6000 | 8.0000 | 176.4100 | 38000.00 | 0.00 | 38000.00 | 50 | 18 | 50 | 348 | 0.14367816091954 | 0.31450840422544 | 0.31450840422544 | false | false | false | true | ||||||||||||||||
| ba2eaea2-8269-4389-aafc-ae0c0bf602d0 | 2026-08-19 10:35 | 2026-08-19 10:34 | 2026-08-19 10:34 | DVA | DVA260918P00180000 | put | 180.0000 | 2026-09-18 | 6.1000 | 6.1000 | 6.4000 | 179.8800 | 31110.00 | 0.00 | 31110.00 | 51 | 20 | 56 | 486 | 0.11522633744856 | 0.307508914287352 | 0.307508914287352 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11681142000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11681142000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11681142000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11681142000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11681142000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11681142000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T18:13:15.605683Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 12078616000.00 |
| 2026-11-04 |
| 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 |
| 12078616000.00 |
| 2026-11-04 |
| 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 |
| 12078616000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:17:14.116635Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 12078616000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:56:20.498446Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 12078616000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T17:48:11.364966Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 12078616000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:57:11.446067Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 12078616000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:57:11.446067Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 12078616000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:57:11.446067Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 12078616000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:59:46.608693Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 12078616000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:59:46.608693Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 12078616000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:49:58.488781Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 12078616000.00 |
| 2026-11-04 |
| 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 |
| 12078616000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 12078616000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |