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 | strike |
|---|
| 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 |
|---|
| 2de0b148-769f-4a63-b3fe-392992a86f3b | 2026-09-29 15:30 | 2026-09-29 15:29 | 2026-09-29 15:29 | NEE | NEE261009C00078000 | call | 78.0000 | 2026-10-09 | 0.4800 | 0.4200 | 0.4800 | 75.9700 | 23982.00 | 23136.00 | 846.00 | 500 | 43 | 510 | 109 | 4.67889908256881 | 0.238882025400939 | 0.238558829507699 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 158291604013.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T19:36:36.492519Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 3ffce90e-11dd-4c37-9dd6-3a371c45c383 | 2026-09-24 15:54 | 2026-09-24 15:53 | 2026-09-24 15:53 | NEE | NEE261218C00082500 | call | 82.5000 | 2026-12-18 | 1.0500 | 1.0300 | 1.1400 | 75.8500 | 45810.00 | 322.00 | 45488.00 | 438 | 19 | 684 | 1394 | 0.490674318507891 | 0.210285808628979 | 0.209423317146129 | true | false | ||||||||||||||||||
| 6e44e78c-4965-480d-a3db-fe93ce8fe4b3 | 2026-09-24 11:36 | 2026-09-24 11:36 | 2026-09-24 11:36 | NEE | NEE270917P00065000 | put | 65.0000 | 2027-09-17 | 2.6200 | 2.4600 | 2.6200 | 76.0000 | 52922.00 | 52922.00 | 0.00 | 202 | 12 | 1335 | 526 | 2.53802281368821 | 0.283158127917193 | 0.282674493204167 | false | false | ||||||||||||||||||
| f3e503b2-4403-4f49-ab5e-72f06d789bd8 | 2026-09-24 11:31 | 2026-09-24 11:31 | 2026-09-24 11:31 | NEE | NEE270917P00065000 | put | 65.0000 | 2027-09-17 | 2.5900 | 2.4300 | 2.5900 | 76.1850 | 49634.00 | 40346.00 | 0.00 | 192 | 25 | 193 | 526 | 0.366920152091255 | 0.280913863594627 | 0.280429395858171 | false | false | ||||||||||||||||||
| ef948160-d524-40fe-8716-7acf97d75af2 | 2026-09-24 11:14 | 2026-09-24 11:13 | 2026-09-24 11:13 | NEE | NEE260925P00077000 | put | 77.0000 | 2026-09-25 | 0.7800 | 0.6700 | 0.8100 | 76.0000 | 16746.00 | 990.00 | 15756.00 | 215 | 32 | 223 | 406 | 0.549261083743842 | 0.231325365916601 | 0.247184905397926 | false | false | ||||||||||||||||||
| a70b9d4d-5c48-4c92-b265-127410280e7e | 2026-09-24 11:13 | 2026-09-24 11:13 | 2026-09-24 11:13 | NEE | NEE261009C00077000 | call | 77.0000 | 2026-10-09 | 1.1000 | 1.0900 | 1.1200 | 76.0000 | 22965.00 | 0.00 | 22965.00 | 209 | 11 | 925 | 2 | 462.5 | 0.216351615906716 | 0.214718386259695 | true | false | ||||||||||||||||||
| eec37434-341e-4235-bd80-c1f5e4b5ab76 | 2026-09-23 14:19 | 2026-09-23 14:19 | 2026-09-23 14:19 | NEE | NEE270617P00080000 | put | 80.0000 | 2027-06-17 | 6.7500 | 6.7000 | 6.8500 | 77.4350 | 14165.00 | 0.00 | 14165.00 | 21 | 5 | 367 | 634 | 0.578864353312303 | 0.255692856482844 | 0.253789364477755 | false | false | ||||||||||||||||||
| fbc9fe78-849e-4f13-b071-ec6b3159247c | 2026-09-23 10:02 | 2026-09-23 10:01 | 2026-09-23 10:01 | NEE | NEE261002P00078000 | put | 78.0000 | 2026-10-02 | 0.9600 | 0.9400 | 0.9700 | 77.0000 | 16629.00 | 11834.00 | 4795.00 | 173 | 24 | 182 | 2190 | 0.0831050228310502 | 0.196311218726759 | 0.196311218726759 | true | false | ||||||||||||||||||
| fbf2be3d-5b49-421f-861b-74bf73654187 | 2026-09-21 15:01 | 2026-09-21 15:01 | 2026-09-21 15:01 | NEE | NEE270617P00085000 | put | 85.0000 | 2027-06-17 | 8.8000 | 8.6500 | 8.8000 | 79.0000 | 307098.00 | 307098.00 | 0.00 | 349 | 40 | 534 | 1442 | 0.370319001386963 | 0.269351234654461 | 0.269351234654461 | true | false | ||||||||||||||||||
| 23364727-432c-4899-9c65-8a3ee5cf8c95 | 2026-09-21 14:06 | 2026-09-21 14:06 | 2026-09-21 14:06 | NEE | NEE270319P00082500 | put | 82.5000 | 2027-03-19 | 5.9600 | 5.9500 | 6.1000 | 79.0000 | 25635.00 | 3025.00 | 22610.00 | 43 | 8 | 886 | 731 | 1.21203830369357 | 0.246562654485177 | 0.242075790777573 | false | false | ||||||||||||||||||
| 7b5d5595-7e22-4872-9683-56d8c1e8878a | 2026-09-21 12:30 | 2026-09-21 12:30 | 2026-09-21 12:30 | NEE | NEE270319C00082500 | call | 82.5000 | 2027-03-19 | 4.1500 | 4.1500 | 4.2500 | 80.0000 | 59356.00 | 420.00 | 58936.00 | 143 | 17 | 455 | 647 | 0.703245749613601 | 0.202272795094795 | 0.200038384679528 | false | false | ||||||||||||||||||
| 2405ae43-350e-4d66-addb-8580d14b3568 | 2026-09-18 10:50 | 2026-09-18 10:50 | 2026-09-18 10:50 | NEE | NEE261120P00077500 | put | 77.5000 | 2026-11-20 | 1.5400 | 1.5400 | 1.5500 | 80.6977 | 113364.00 | 3100.00 | 110264.00 | 736 | 8 | 770 | 329 | 2.34042553191489 | 0.234827340046473 | 0.234827340046473 | true | false | ||||||||||||||||||
| 0971ee4f-ed5c-4bf0-beaf-5157e259304c | 2026-09-18 10:50 | 2026-09-18 10:50 | 2026-09-18 10:50 | NEE | NEE261120P00082500 | put | 82.5000 | 2026-11-20 | 3.7900 | 3.7500 | 4.0000 | 80.6800 | 63590.00 | 35720.00 | 20370.00 | 168 | 24 | 737 | 860 | 0.856976744186047 | 0.23412888277217 | 0.233406750669137 | false | false | ||||||||||||||||||
| 308d6c99-2a76-417c-8632-4276acc71926 | 2026-09-17 10:30 | 2026-09-17 10:30 | 2026-09-17 10:30 | NEE | NEE261120P00082500 | put | 82.5000 | 2026-11-20 | 3.8500 | 3.8000 | 3.8500 | 80.5450 | 160521.00 | 160521.00 | 0.00 | 417 | 38 | 480 | 357 | 1.34453781512605 | 0.230328468831434 | 0.230328468831434 | false | false | ||||||||||||||||||
| 723e24e9-ceb5-40df-baab-0f380d6b9fac | 2026-09-16 12:18 | 2026-09-16 12:18 | 2026-09-16 12:18 | NEE | NEE270319P00082500 | put | 82.5000 | 2027-03-19 | 5.7500 | 5.7500 | 5.9000 | 80.9250 | 65555.00 | 580.00 | 64975.00 | 114 | 32 | 118 | 230 | 0.51304347826087 | 0.258964074214507 | 0.256569677629781 | false | false | ||||||||||||||||||
| bb5abd64-0fdf-4365-9867-2a8fa150532f | 2026-08-28 13:06 | 2026-08-28 13:06 | 2026-08-28 13:06 | NEE | NEE260918C00082500 | call | 82.5000 | 2026-09-18 | 1.1400 | 1.0000 | 1.3300 | 81.4700 | 123116.00 | 123005.00 | 111.00 | 1080 | 36 | 1091 | 675 | 1.6162962962963 | 0.197178325546329 | 0.191052697346486 | false | false | ||||||||||||||||||
| 67870c4a-211e-4d06-8507-ae3fec50fc5c | 2026-08-20 11:44 | 2026-08-20 11:44 | 2026-08-20 11:44 | NEE | NEE270917C00087500 | call | 87.5000 | 2027-09-17 | 7.8500 | 7.8500 | 8.0500 | 85.1950 | 117800.00 | 0.00 | 117800.00 | 150 | 6 | 166 | 5 | 33.2 | 0.202271788417845 | 0.201982927987796 | false | false | ||||||||||||||||||
| df59fc59-c485-435a-a904-c43a23c8242a | 2026-08-18 10:33 | 2026-08-18 10:33 | 2026-08-18 10:33 | NEE | NEE260918C00085000 | call | 85.0000 | 2026-09-18 | 2.9900 | 2.9700 | 3.0500 | 86.8200 | 82246.00 | 51129.00 | 31117.00 | 275 | 9 | 303 | 5220 | 0.0580459770114943 | 0.176235220406627 | 0.175111058384376 | true | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 160648561617.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:58:08.680508Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 160648561617.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:39:15.853086Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 160648561617.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 160648561617.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:14:35.650072Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 160648561617.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:14:35.650072Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 160648561617.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:19:20.444616Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 160648561617.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:02:33.967509Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 166092507940.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:06:05.917319Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 166092507940.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:09:57.736377Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 166092507940.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:32:17.927421Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 167844582619.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 167844582619.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 169534083202.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:33:58.839655Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 167636002300.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T16:35:37.886334Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 170264114318.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T17:15:24.821907Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 170264114318.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 170264114318.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |