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_alerts474,253 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 |
|---|
| e73576ea-71ab-4436-b559-a8006af72a73 | 2026-08-26 11:09 | 2026-08-26 11:09 | 2026-08-26 11:09 | VEEV | VEEV260918P00240000 | put | 240.0000 | 2026-09-18 | 11.5000 | 11.1000 | 11.7000 | 245.6600 | 18400.00 | 3450.00 | 8050.00 | 16 | 6 | 34 | 323 | 0.105263157894737 | 0.593519577976713 | 0.593519577976713 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 43014324180.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T15:22:15.766686Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6dcb6589-c703-47b8-87f2-4a925cbacd03 | 2026-08-26 11:09 | 2026-08-26 11:09 | 2026-08-26 11:09 | VEEV | VEEV260918P00240000 | put | 240.0000 | 2026-09-18 | 11.4000 | 11.1000 | 11.8000 | 245.6600 | 14820.00 | 0.00 | 14820.00 | 13 | 5 | 18 | 323 | 0.0557275541795666 | 0.589328547741695 | 0.589328547741695 | false | false | false | true | ||||||||||||||||
| 9e968085-c273-47bf-8676-79a20d3a455b | 2026-08-26 11:06 | 2026-08-26 11:06 | 2026-08-26 11:06 | VEEV | VEEV260918P00230000 | put | 230.0000 | 2026-09-18 | 7.2000 | 6.8000 | 7.4000 | 245.8800 | 15840.00 | 15840.00 | 0.00 | 22 | 11 | 277 | 378 | 0.732804232804233 | 0.584633429697901 | 0.584633429697901 | false | false | false | true | ||||||||||||||||
| 75ab6a84-5725-4415-a565-91eb8ea258dc | 2026-08-26 11:04 | 2026-08-26 11:04 | 2026-08-26 11:04 | VEEV | VEEV260918P00220000 | put | 220.0000 | 2026-09-18 | 4.5000 | 4.0000 | 4.5000 | 246.1550 | 14850.00 | 14850.00 | 0.00 | 33 | 11 | 100 | 378 | 0.264550264550265 | 0.600434914560596 | 0.600434914560596 | false | false | false | true | ||||||||||||||||
| e9563d46-8285-4668-a71e-92c2067f8a68 | 2026-08-26 09:47 | 2026-08-26 09:46 | 2026-08-26 09:46 | VEEV | VEEV260918C00270000 | call | 270.0000 | 2026-09-18 | 6.5000 | 5.0000 | 6.5000 | 245.4650 | 43550.00 | 43550.00 | 0.00 | 67 | 19 | 151 | 275 | 0.549090909090909 | 0.607173154243678 | 0.607173154243678 | false | false | false | true | ||||||||||||||||
| c0785e0e-6a6b-40f4-b298-5f19f9129a4c | 2026-08-26 09:39 | 2026-08-26 09:39 | 2026-08-26 09:39 | VEEV | VEEV260918P00250000 | put | 250.0000 | 2026-09-18 | 16.8000 | 16.8000 | 17.8000 | 244.0391 | 11760.00 | 0.00 | 6720.00 | 7 | 7 | 17 | 178 | 0.0955056179775281 | 0.565253521485573 | 0.565253521485573 | false | false | false | true | ||||||||||||||||
| f559e8f6-3be4-4a66-a2e9-94a5b4aa85b1 | 2026-08-26 09:32 | 2026-08-26 09:32 | 2026-08-26 09:32 | VEEV | VEEV260918P00250000 | put | 250.0000 | 2026-09-18 | 17.2000 | 17.2000 | 19.5000 | 243.6650 | 10320.00 | 0.00 | 10320.00 | 6 | 6 | 6 | 178 | 0.0337078651685393 | 0.573478949590882 | 0.573478949590882 | true | false | false | true | ||||||||||||||||
| d5c3f51d-3854-4f63-b6c6-8d28384a9568 | 2026-08-25 14:07 | 2026-08-25 14:07 | 2026-08-25 14:07 | VEEV | VEEV270115P00260000 | put | 260.0000 | 2027-01-15 | 34.5100 | 34.5000 | 37.2000 | 244.0000 | 34510.00 | 0.00 | 34510.00 | 10 | 6 | 14 | 34 | 0.411764705882353 | 0.454139324443794 | 0.455778964834607 | false | false | false | true | ||||||||||||||||
| affb6b6c-31b6-4345-89f7-283f7a694f6d | 2026-08-25 12:34 | 2026-08-25 12:34 | 2026-08-25 12:34 | VEEV | VEEV270319C00230000 | call | 230.0000 | 2027-03-19 | 45.2000 | 44.6000 | 46.3000 | 245.2600 | 45200.00 | 9040.00 | 36160.00 | 10 | 5 | 10 | 33 | 0.303030303030303 | 0.485705914593244 | 0.485705914593244 | false | false | false | true | ||||||||||||||||
| 18b77bea-874f-4e64-84f4-1739aeb0324f | 2026-08-25 12:18 | 2026-08-25 12:18 | 2026-08-25 12:18 | VEEV | VEEV260918C00250000 | call | 250.0000 | 2026-09-18 | 12.0000 | 11.2000 | 12.0000 | 244.4200 | 48000.00 | 48000.00 | 0.00 | 40 | 8 | 79 | 865 | 0.0913294797687861 | 0.568384322730714 | 0.568384322730714 | false | false | false | true | ||||||||||||||||
| 906dcd8a-a28f-4ac5-b8b5-c82197d6009a | 2026-08-21 15:34 | 2026-08-21 15:34 | 2026-08-21 15:34 | VEEV | VEEV270115C00270000 | call | 270.0000 | 2027-01-15 | 22.2000 | 21.4000 | 22.2000 | 247.4950 | 77700.00 | 77700.00 | 0.00 | 35 | 8 | 41 | 50 | 0.82 | 0.470783270962252 | 0.470783270962252 | false | false | false | true | ||||||||||||||||
| ab581154-6dc3-47c4-b02c-12e3280b2806 | 2026-08-21 15:33 | 2026-08-21 15:33 | 2026-08-21 15:33 | VEEV | VEEV270115C00290000 | call | 290.0000 | 2027-01-15 | 15.9000 | 15.3000 | 17.3000 | 247.3445 | 20670.00 | 0.00 | 19080.00 | 13 | 6 | 61 | 167 | 0.365269461077844 | 0.467043418594987 | 0.467043418594987 | true | false | false | true | ||||||||||||||||
| 28257cac-ec22-41d2-ac45-4b9bec5ca659 | 2026-08-21 15:31 | 2026-08-21 15:31 | 2026-08-21 15:31 | VEEV | VEEV270115C00290000 | call | 290.0000 | 2027-01-15 | 16.1000 | 15.7000 | 17.0000 | 247.7721 | 45080.00 | 16100.00 | 28980.00 | 28 | 9 | 48 | 167 | 0.287425149700599 | 0.467747322872641 | 0.467747322872641 | true | false | false | true | ||||||||||||||||
| f6f521e8-3469-4f78-8ceb-7e5aa49c360b | 2026-08-21 11:32 | 2026-08-21 11:32 | 2026-08-21 11:32 | VEEV | VEEV260918P00250000 | put | 250.0000 | 2026-09-18 | 15.1000 | 14.8000 | 15.9000 | 249.2250 | 52850.00 | 51340.00 | 1510.00 | 35 | 5 | 41 | 144 | 0.284722222222222 | 0.5479451972241 | 0.5479451972241 | false | false | false | true | ||||||||||||||||
| 40b33452-530d-481b-a0d5-77e527f744e0 | 2026-08-20 14:30 | 2026-08-20 14:30 | 2026-08-20 14:30 | VEEV | VEEV260918C00250000 | call | 250.0000 | 2026-09-18 | 16.0000 | 14.8000 | 16.0000 | 251.6600 | 14400.00 | 14400.00 | 0.00 | 9 | 9 | 93 | 638 | 0.14576802507837 | 0.524729556600008 | 0.524729556600008 | false | false | false | true | ||||||||||||||||
| 57c9edbc-4e6c-4272-9aed-96adf7b77deb | 2026-08-19 12:53 | 2026-08-19 12:53 | 2026-08-19 12:53 | VEEV | VEEV281215C00300000 | call | 300.0000 | 2028-12-15 | 64.5000 | 63.1000 | 66.5000 | 249.9450 | 32250.00 | 6450.00 | 25800.00 | 5 | 5 | 31 | 1 | 31 | 0.483721937802389 | 0.483721937802389 | false | false | false | true | ||||||||||||||||
| 4647e3bc-dc44-4656-b6e5-dfa87a1ac1bf | 2026-08-19 11:29 | 2026-08-19 11:29 | 2026-08-19 11:29 | VEEV | VEEV270115C00280000 | call | 280.0000 | 2027-01-15 | 20.0000 | 20.0000 | 21.0000 | 249.5200 | 40000.00 | 0.00 | 40000.00 | 20 | 7 | 190 | 107 | 1.77570093457944 | 0.469917466657797 | 0.469917466657797 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 43014324180.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:22:15.766686Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 43014324180.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:22:15.766686Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 43014324180.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:22:15.766686Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 43014324180.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 43014324180.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 43014324180.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 43014324180.00 |
| 2026-11-19 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 43014324180.00 |
| 2026-11-19 |
| 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 |
| 43014324180.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:29:52.792110Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 43014324180.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:48:47.460535Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 43014324180.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:48:47.460535Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 43014324180.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:32:44.160800Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 43014324180.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:38:28.521674Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 43014324180.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:45:57.711481Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 43014324180.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:16:43.855599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 43014324180.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |