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 |
|---|
| 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 |
|---|
| a508a56a-f369-4dca-9b51-9230ae61cebe | 2026-09-23 12:00 | 2026-09-23 12:00 | 2026-09-23 12:00 | BSX | BSX280121P00030000 | put | 30.0000 | 2028-01-21 | 1.7800 | 1.7500 | 2.0000 | 44.7700 | 69815.00 | 0.00 | 69815.00 | 393 | 15 | 620 | 3672 | 0.168845315904139 | 0.451004072286663 | 0.446397844247717 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 64664621450.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T16:00:35.931587Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 6f84d84f-84b0-41dc-9021-a2ed9fb01cb9 | 2026-09-23 12:00 | 2026-09-23 12:00 | 2026-09-23 12:00 | BSX | BSX280121P00030000 | put | 30.0000 | 2028-01-21 | 1.7600 | 1.7500 | 2.0000 | 44.7750 | 97695.00 | 1480.00 | 94415.00 | 556 | 31 | 1200 | 3672 | 0.326797385620915 | 0.446515103869568 | 0.441694906774993 | false | false | false | |||||||||||||||||
| 0312d3ce-943d-4b94-a2a1-986ad7fec09a | 2026-09-22 14:37 | 2026-09-22 14:37 | 2026-09-22 14:37 | BSX | BSX280121C00075000 | call | 75.0000 | 2028-01-21 | 2.4000 | 2.4000 | 2.5000 | 44.6450 | 18971.00 | 490.00 | 18481.00 | 79 | 10 | 106 | 6033 | 0.0175700314934527 | 0.4174871163327 | 0.414986565483238 | false | false | false | |||||||||||||||||
| 4bdcad4e-7e37-4eb5-8637-f850886e3517 | 2026-09-21 15:38 | 2026-09-21 15:38 | 2026-09-21 15:38 | BSX | BSX261016P00038000 | put | 38.0000 | 2026-10-16 | 0.2000 | 0.1000 | 0.2000 | 43.6400 | 22506.00 | 22506.00 | 0.00 | 1126 | 47 | 1509 | 0 | 0 | 0.414326202294244 | 0.414326202294244 | false | false | false | |||||||||||||||||
| db22bb07-1297-408f-83d2-b3c784714a49 | 2026-09-10 10:22 | 2026-09-10 10:21 | 2026-09-10 10:21 | BSX | BSX261023P00042000 | put | 42.0000 | 2026-10-23 | 1.3200 | 1.1500 | 1.3500 | 44.3050 | 79374.00 | 79374.00 | 0.00 | 600 | 9 | 600 | 34 | 17.6470588235294 | 0.401970444617524 | 0.402260940245259 | true | false | false | |||||||||||||||||
| dd3f1b3c-a580-4a68-b6d2-8dd39ed94410 | 2026-09-04 13:49 | 2026-09-04 13:49 | 2026-09-04 13:49 | BSX | BSX261016C00050000 | call | 50.0000 | 2026-10-16 | 1.7000 | 1.6000 | 1.8000 | 47.7092 | 83315.00 | 0.00 | 81615.00 | 491 | 21 | 621 | 2304 | 0.26953125 | 0.395089459947049 | 0.387092764712791 | false | false | false | |||||||||||||||||
| 53381bfc-fd23-4d24-90f7-52eb59805797 | 2026-09-03 14:41 | 2026-09-03 14:41 | 2026-09-03 14:41 | BSX | BSX261218C00050000 | call | 50.0000 | 2026-12-18 | 3.5400 | 3.4000 | 3.6000 | 47.1000 | 71550.00 | 56690.00 | 700.00 | 202 | 12 | 406 | 24441 | 0.0166114316108179 | 0.4461950438998 | 0.4461950438998 | true | false | false | |||||||||||||||||
| 52c2c185-86b9-4fbd-b049-d9b05b957ab8 | 2026-09-03 11:36 | 2026-09-03 11:36 | 2026-09-03 11:36 | BSX | BSX260911P00047000 | put | 47.0000 | 2026-09-11 | 1.0500 | 0.8500 | 1.1000 | 47.3600 | 439156.00 | 438946.00 | 210.00 | 4186 | 74 | 4693 | 1036 | 4.52992277992278 | 0.445080942699291 | 0.445080942699291 | false | false | false | |||||||||||||||||
| f0011268-4bf6-496b-ba53-7700fdaeac3c | 2026-08-31 14:41 | 2026-08-31 14:41 | 2026-08-31 14:41 | BSX | BSX261218P00045000 | put | 45.0000 | 2026-12-18 | 2.7000 | 2.7000 | 2.8500 | 48.0550 | 270080.00 | 0.00 | 270080.00 | 1000 | 59 | 1034 | 1877 | 0.550879062333511 | 0.425979819389101 | 0.422811266560866 | false | false | false | |||||||||||||||||
| 3e1c7d11-4fa7-44bf-afee-cc874389a5a5 | 2026-08-31 10:03 | 2026-08-31 10:03 | 2026-08-31 10:03 | BSX | BSX260904C00048000 | call | 48.0000 | 2026-09-04 | 0.7500 | 0.6000 | 0.7500 | 47.5200 | 69512.00 | 69442.00 | 70.00 | 927 | 42 | 1720 | 92 | 18.695652173913 | 0.482695042035827 | 0.457128783959194 | false | false | false | |||||||||||||||||
| 53258cc8-9664-4dae-b6af-7e9d1be444db | 2026-08-31 09:52 | 2026-08-31 09:52 | 2026-08-31 09:52 | BSX | BSX260904C00047500 | call | 47.5000 | 2026-09-04 | 0.8000 | 0.6000 | 0.8000 | 47.2300 | 59333.00 | 59333.00 | 0.00 | 742 | 41 | 748 | 180 | 4.15555555555556 | 0.465034439650869 | 0.465034439650869 | false | false | false | |||||||||||||||||
| d67fc553-011c-4a41-8a02-2392858e1b1d | 2026-08-24 15:53 | 2026-08-24 15:53 | 2026-08-24 15:53 | BSX | BSX260918C00049000 | call | 49.0000 | 2026-09-18 | 2.0500 | 2.0000 | 2.1000 | 49.0800 | 116371.00 | 115551.00 | 410.00 | 569 | 38 | 683 | 0 | 0 | 0.380435267971668 | 0.380435267971668 | false | false | false | |||||||||||||||||
| 16e60c69-77aa-4ede-94fe-f6c2aeb56030 | 2026-08-24 13:51 | 2026-08-24 13:51 | 2026-08-24 13:51 | BSX | BSX260828C00049000 | call | 49.0000 | 2026-08-28 | 0.8500 | 0.7000 | 0.9500 | 49.0100 | 272896.00 | 272811.00 | 85.00 | 3216 | 52 | 3345 | 39 | 85.7692307692308 | 0.426579746512786 | 0.407967610692501 | false | false | false | |||||||||||||||||
| ec9e6054-12a0-4536-a0b1-b4344095a5f5 | 2026-08-24 10:08 | 2026-08-24 10:08 | 2026-08-24 10:08 | BSX | BSX280121C00045000 | call | 45.0000 | 2028-01-21 | 13.1900 | 13.0000 | 14.0000 | 49.2400 | 65932.00 | 0.00 | 65932.00 | 50 | 15 | 50 | 1450 | 0.0344827586206897 | 0.439131190633828 | 0.439131190633828 | false | false | false | |||||||||||||||||
| c37be401-0368-4689-a659-c0e294f12649 | 2026-08-21 14:10 | 2026-08-21 14:10 | 2026-08-21 14:10 | BSX | BSX260821C00045000 | call | 45.0000 | 2026-08-21 | 5.5000 | 5.3000 | 5.7000 | 50.0000 | 698490.00 | 319540.00 | 261250.00 | 1270 | 85 | 1476 | 3988 | 0.370110330992979 | 5.05828040101862 | 5.23937735158731 | true | false | false | |||||||||||||||||
| 243f456d-3adb-45dc-8924-7f129b27cbcf | 2026-08-19 15:31 | 2026-08-19 15:31 | 2026-08-19 15:31 | BSX | BSX260821C00051000 | call | 51.0000 | 2026-08-21 | 1.4300 | 1.3000 | 1.7500 | 52.2850 | 71631.00 | 0.00 | 71631.00 | 500 | 17 | 2073 | 2328 | 0.890463917525773 | 0.376503488909293 | 0.366558576531387 | false | false | false | |||||||||||||||||
| 5aaa91bd-6b44-460d-9b59-d83404f96884 | 2026-08-19 14:39 | 2026-08-19 14:39 | 2026-08-19 14:39 | BSX | BSX260821C00051000 | call | 51.0000 | 2026-08-21 | 1.5000 | 1.3500 | 1.6500 | 52.3500 | 74978.00 | 0.00 | 56378.00 | 500 | 17 | 1569 | 2328 | 0.673969072164949 | 0.382952992663198 | 0.382952992663198 | false | false | false | |||||||||||||||||
| 8856384d-5a7b-4cac-938f-bf337400acf9 | 2026-08-19 10:52 | 2026-08-19 10:52 | 2026-08-19 10:52 | BSX | BSX260821C00051000 | call | 51.0000 | 2026-08-21 | 1.5100 | 1.5000 | 1.6000 | 52.3900 | 75250.00 | 0.00 | 69825.00 | 500 | 31 | 556 | 2328 | 0.238831615120275 | 0.399975666307607 | 0.346920265895855 | true | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 64664621450.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:00:35.931587Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 65099390308.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:44:24.241276Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 63360314877.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 65287790146.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:36:53.026568Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 65287790146.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T18:01:17.201510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 65287790146.00 |
| 2026-10-28 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 65287790146.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 65287790146.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:01:22.528333Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 65287790146.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 65287790146.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:02:22.723941Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 65287790146.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T13:32:26.163070Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 65287790146.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 65287790146.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:21:20.397116Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 65287790146.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 65287790146.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 65287790146.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 65287790146.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |