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_alerts566,287 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 |
|---|
| bc17fce3-80e7-44a5-a910-2a8ee39c9717 | 2026-09-29 13:58 | 2026-09-29 13:58 | 2026-09-29 13:58 | IOVA | IOVA270115P00010000 | put | 10.0000 | 2027-01-15 | 1.1000 | 1.0000 | 1.3000 | 14.7300 | 90199.00 | 84699.00 | 5500.00 | 820 | 22 | 24695 | 5637 | 4.38087635266986 | 1.1182476430176 | 1.1198954828419 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 6545437192.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T18:00:33.837310Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 624a80e1-04a3-4be1-912c-30f057f444a8 | 2026-09-29 13:57 | 2026-09-29 13:57 | 2026-09-29 13:57 | IOVA | IOVA270115P00010000 | put | 10.0000 | 2027-01-15 | 1.1000 | 1.0500 | 1.2000 | 14.7400 | 510831.00 | 506981.00 | 3850.00 | 4644 | 56 | 21121 | 5637 | 3.74685116196558 | 1.11784046453288 | 1.12073021300535 | false | false | false | |||||||||||||||||
| 6d99de20-5f99-4e27-91a8-f2f3fc90ed7c | 2026-09-29 13:56 | 2026-09-29 13:56 | 2026-09-29 13:56 | IOVA | IOVA270115P00010000 | put | 10.0000 | 2027-01-15 | 1.0500 | 1.0000 | 1.2000 | 14.8000 | 295249.00 | 276034.00 | 19215.00 | 2812 | 66 | 15452 | 5637 | 2.74117438353734 | 1.09821932774729 | 1.10076573310616 | false | false | false | |||||||||||||||||
| 13d85eda-97c6-414f-ad58-d83b5fc88207 | 2026-09-29 13:56 | 2026-09-29 13:56 | 2026-09-29 13:56 | IOVA | IOVA270115P00010000 | put | 10.0000 | 2027-01-15 | 1.0000 | 0.7000 | 1.1000 | 14.8450 | 456515.00 | 445395.00 | 9500.00 | 4567 | 92 | 5090 | 5637 | 0.902962568742239 | 1.03464671996804 | 1.07928853952383 | false | false | false | |||||||||||||||||
| 602acad9-8dc4-4f5f-9122-6fd690473541 | 2026-09-29 13:22 | 2026-09-29 13:21 | 2026-09-29 13:21 | IOVA | IOVA270115C00015000 | call | 15.0000 | 2027-01-15 | 3.3200 | 3.2000 | 3.6000 | 15.0750 | 16582.00 | 1650.00 | 14932.00 | 50 | 5 | 1077 | 7203 | 0.149521032902957 | 0.987949527197872 | 0.99434951148125 | false | false | false | |||||||||||||||||
| 6e5d002d-5b3f-423f-b9ce-81a1395463ed | 2026-09-29 12:55 | 2026-09-29 12:55 | 2026-09-29 12:55 | IOVA | IOVA270115C00015000 | call | 15.0000 | 2027-01-15 | 3.1100 | 3.0000 | 3.2000 | 14.0000 | 12435.00 | 10885.00 | 1550.00 | 40 | 5 | 961 | 7203 | 0.133416631958906 | 0.980419880652151 | 0.983647077384725 | false | false | false | |||||||||||||||||
| 29d73fbe-3586-4f00-a139-5d1a2fec0cca | 2026-09-29 12:01 | 2026-09-29 12:01 | 2026-09-29 12:01 | IOVA | IOVA270115C00012000 | call | 12.0000 | 2027-01-15 | 3.9100 | 3.5000 | 4.0000 | 14.0700 | 10949.00 | 10949.00 | 0.00 | 28 | 5 | 714 | 6053 | 0.117958037336858 | 0.948139985597848 | 0.952040363327209 | false | false | false | |||||||||||||||||
| fc4068d8-a677-4278-83ef-cfa890348703 | 2026-09-29 09:33 | 2026-09-29 09:33 | 2026-09-29 09:33 | IOVA | IOVA270115C00012000 | call | 12.0000 | 2027-01-15 | 2.9300 | 2.6000 | 3.3000 | 13.1100 | 29250.00 | 4845.00 | 24405.00 | 100 | 11 | 113 | 6053 | 0.0186684288782422 | 0.80476170346543 | 0.863108800490703 | false | false | false | |||||||||||||||||
| c6691b2e-d6b5-4929-a0f0-ce17f124c329 | 2026-09-23 11:27 | 2026-09-23 11:27 | 2026-09-23 11:27 | IOVA | IOVA270115C00020000 | call | 20.0000 | 2027-01-15 | 0.3600 | 0.3500 | 0.4500 | 10.3850 | 10787.00 | 0.00 | 10787.00 | 300 | 7 | 330 | 17395 | 0.0189709686691578 | 0.909318014898811 | 0.916463168947662 | false | false | false | |||||||||||||||||
| 8fdf9da3-fe2d-4d75-b02a-3e41910b3343 | 2026-09-22 15:17 | 2026-09-22 15:17 | 2026-09-22 15:17 | IOVA | IOVA261016C00010500 | call | 10.5000 | 2026-10-16 | 1.0900 | 0.9500 | 1.1000 | 10.6900 | 12806.00 | 12806.00 | 0.00 | 118 | 6 | 655 | 3 | 218.333333333333 | 0.895766219932866 | 0.895766219932866 | false | false | false | |||||||||||||||||
| 6e845823-e331-4d55-94eb-b447a98aced2 | 2026-09-22 10:50 | 2026-09-22 10:50 | 2026-09-22 10:50 | IOVA | IOVA270115C00010000 | call | 10.0000 | 2027-01-15 | 2.3900 | 2.2000 | 2.4500 | 10.3200 | 45320.00 | 45320.00 | 0.00 | 190 | 8 | 530 | 32768 | 0.01617431640625 | 0.963972728605162 | 0.97024865173383 | false | false | false | |||||||||||||||||
| 35de9704-3355-42ec-858e-f5f3952c3751 | 2026-09-21 10:46 | 2026-09-21 10:46 | 2026-09-21 10:46 | IOVA | IOVA280121C00010000 | call | 10.0000 | 2028-01-21 | 4.5000 | 4.3000 | 4.7000 | 10.4100 | 13500.00 | 13500.00 | 0.00 | 30 | 7 | 275 | 8330 | 0.0330132052821128 | 0.885467206415903 | 0.961767976324022 | false | false | false | |||||||||||||||||
| 1e93bf24-8e73-4a0d-9778-4ba72491e618 | 2026-09-11 14:48 | 2026-09-11 14:48 | 2026-09-11 14:48 | IOVA | IOVA260911C00008000 | call | 8.0000 | 2026-09-11 | 0.6400 | 0.5500 | 0.7000 | 8.6650 | 31827.00 | 2700.00 | 12552.00 | 500 | 9 | 1082 | 2101 | 0.514992860542599 | 3.53708048642748 | 5.89025135090267 | false | false | false | |||||||||||||||||
| a4f7ece4-3603-48ab-827e-350f7ce8d363 | 2026-09-09 15:42 | 2026-09-09 15:42 | 2026-09-09 15:42 | IOVA | IOVA260918C00008000 | call | 8.0000 | 2026-09-18 | 0.8000 | 0.5500 | 0.8000 | 8.4650 | 15994.00 | 15994.00 | 0.00 | 200 | 6 | 351 | 908 | 0.386563876651982 | 0.989160436390244 | 1.03073731903165 | false | false | false | |||||||||||||||||
| 1cd1e093-f807-412f-b451-f4202b170b56 | 2026-08-26 12:42 | 2026-08-26 12:42 | 2026-08-26 12:42 | IOVA | IOVA270115C00010000 | call | 10.0000 | 2027-01-15 | 1.4900 | 1.4000 | 1.5000 | 8.1950 | 14894.00 | 14894.00 | 0.00 | 100 | 6 | 162 | 26455 | 0.00612360612360612 | 1.00274071763886 | 1.00274071763886 | false | false | false | |||||||||||||||||
| b1cf3af9-1c60-4374-bb9b-4491c6e88491 | 2026-08-25 14:12 | 2026-08-25 14:12 | 2026-08-25 14:12 | IOVA | IOVA280121C00010000 | call | 10.0000 | 2028-01-21 | 3.3400 | 3.1000 | 3.4000 | 8.0000 | 150456.00 | 150456.00 | 0.00 | 450 | 12 | 504 | 7524 | 0.0669856459330144 | 0.954191854430004 | 0.954191854430004 | false | false | false | |||||||||||||||||
| 85bcd348-b94c-4e85-84d7-680e2897c2a8 | 2026-08-21 14:26 | 2026-08-21 14:26 | 2026-08-21 14:26 | IOVA | IOVA261218C00010000 | call | 10.0000 | 2026-12-18 | 1.5000 | 1.4000 | 1.5000 | 8.2419 | 34196.00 | 34196.00 | 0.00 | 228 | 23 | 397 | 1628 | 0.243857493857494 | 1.0918828901494 | 1.09721076555431 | false | false | false | |||||||||||||||||
| 8f434560-3897-4526-9839-1bf3916c8cb4 | 2026-08-19 15:19 | 2026-08-19 15:18 | 2026-08-19 15:18 | IOVA | IOVA260911C00008000 | call | 8.0000 | 2026-09-11 | 0.8000 | 0.4000 | 0.8000 | 7.9250 | 23660.00 | 23660.00 | 0.00 | 296 | 22 | 301 | 0 | 0 | 0.918994221811761 | 1.04218550901041 | false | false | false | |||||||||||||||||
| a75bdc53-b9dc-43f7-8671-cb4b7fd40cc6 | 2026-08-19 09:36 | 2026-08-19 09:36 | 2026-08-19 09:36 | IOVA | IOVA260918C00007500 | call | 7.5000 | 2026-09-18 | 0.7500 | 0.7000 | 0.8000 | 7.5300 | 12090.00 | 7725.00 | 1440.00 | 162 | 6 | 517 | 12701 | 0.0407054562632864 | 0.809383128295632 | 0.844603207227377 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 6545437192.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:58:05.042752Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 6545437192.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:58:05.042752Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 6545437192.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:58:05.042752Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 6545437192.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:23:13.824260Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 6545437192.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:01:16.214882Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 6545437192.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:02:30.295749Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 6545437192.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:33:34.031299Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 4615778892.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:28:13.578365Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 4819616036.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:23:17.824277Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 4819616036.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:51:29.790694Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 4615778892.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:47:49.730853Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 4194515460.00 |
| 2026-11-05 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 4194515460.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:53:17.072904Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 4194515460.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:52:20.196728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 4194515460.00 |
| 2026-11-05 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 4194515460.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 4194515460.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 4194515460.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |