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 | price |
|---|
| 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 |
|---|
| ee97bb6d-fb1a-49f7-b585-eb6e041e2b3e | 2026-08-17 13:10 | 2026-08-17 13:10 | 2026-08-17 13:10 | BNY | BNY260918C00155000 | call | 155.0000 | 2026-09-18 | 11.9000 | 11.9000 | 12.2000 | 165.5000 | 54740.00 | 0.00 | 54740.00 | 46 | 22 | 57 | 9667 | 0.00589634840177925 | 0.229641646542127 | 0.229641646542127 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 106972963028.00 | 2026-10-15 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 63aa9330-ec38-443a-acbe-b81a0a27c07a | 2026-08-21 10:00 | 2026-08-21 10:00 | 2026-08-21 10:00 | BNY | BNY261016C00170000 | call | 170.0000 | 2026-10-16 | 2.7000 | 1.2000 | 3.9000 | 159.5742 | 85590.00 | 5940.00 | 79650.00 | 317 | 6 | 317 | 2 | 158.5 | 0.24680187464655 | 0.24680187464655 | true | false | false | true | false | |||||||||||||||
| c4ffc166-1280-4bae-aaed-50cee834f6b4 | 2026-08-21 10:27 | 2026-08-21 10:27 | 2026-08-21 10:27 | BNY | BNY261016C00170000 | call | 170.0000 | 2026-10-16 | 2.8500 | 2.3500 | 2.9000 | 159.7550 | 293238.00 | 292953.00 | 285.00 | 1029 | 59 | 1346 | 2 | 673 | 0.251259553407499 | 0.251259553407499 | false | false | false | true | false | |||||||||||||||
| 577a2c1f-4fe8-42a4-8d08-904d77fb36c7 | 2026-08-21 13:32 | 2026-08-21 13:32 | 2026-08-21 13:32 | BNY | BNY270319P00140000 | put | 140.0000 | 2027-03-19 | 5.7000 | 5.7000 | 5.9000 | 158.4800 | 881790.00 | 0.00 | 881790.00 | 1547 | 10 | 2371 | 1571 | 1.50922978994271 | 0.313120498086886 | 0.313120498086886 | false | false | false | true | false | |||||||||||||||
| 9fdc5de1-5874-4002-8c04-65a8d50f9e80 | 2026-08-21 14:08 | 2026-08-21 14:07 | 2026-08-21 14:07 | BNY | BNY261016P00160000 | put | 160.0000 | 2026-10-16 | 6.5000 | 6.2000 | 6.5000 | 158.0000 | 85150.00 | 85150.00 | 0.00 | 131 | 30 | 144 | 1 | 144 | 0.258847103151049 | 0.258847103151049 | false | false | false | true | false | |||||||||||||||
| de7a96e6-cfd4-43d8-aed7-fd326ebfaade | 2026-08-21 14:18 | 2026-08-21 14:18 | 2026-08-21 14:18 | BNY | BNY261016P00160000 | put | 160.0000 | 2026-10-16 | 6.5000 | 6.1000 | 6.8000 | 158.0000 | 105310.00 | 5850.00 | 99460.00 | 162 | 30 | 309 | 1 | 309 | 0.25620715378318 | 0.25620715378318 | true | false | false | true | false | |||||||||||||||
| a092e9b0-88f5-4276-a404-7f8b64c036b2 | 2026-08-28 11:15 | 2026-08-28 11:15 | 2026-08-28 11:15 | BNY | BNY261016C00170000 | call | 170.0000 | 2026-10-16 | 3.5000 | 2.9000 | 3.5000 | 163.1000 | 50750.00 | 50750.00 | 0.00 | 145 | 6 | 147 | 1151 | 0.127715030408341 | 0.249002207922009 | 0.249002207922009 | false | false | false | true | false | |||||||||||||||
| ef51cf4a-3a35-4a4a-bb1a-68bd0ee8c402 | 2026-08-28 11:17 | 2026-08-28 11:17 | 2026-08-28 11:17 | BNY | BNY261016P00165000 | put | 165.0000 | 2026-10-16 | 6.4000 | 6.2000 | 7.6000 | 163.1700 | 138893.00 | 14080.00 | 124813.00 | 217 | 11 | 304 | 50 | 6.08 | 0.246404571086363 | 0.246404571086363 | false | false | false | true | false | |||||||||||||||
| 21b86394-be14-4747-b7a3-f21052961589 | 2026-08-31 12:41 | 2026-08-31 12:41 | 2026-08-31 12:41 | BNY | BNY261016C00165000 | call | 165.0000 | 2026-10-16 | 4.8000 | 4.4000 | 5.2000 | 162.1100 | 164640.00 | 9600.00 | 155040.00 | 343 | 7 | 354 | 222 | 1.59459459459459 | 0.250632100277247 | 0.25043063532678 | false | false | false | true | false | |||||||||||||||
| 9d34f3da-3564-47ff-b388-95a0f2181671 | 2026-09-15 10:30 | 2026-09-15 10:30 | 2026-09-15 10:30 | BNY | BNY261016C00155000 | call | 155.0000 | 2026-10-16 | 5.1000 | 4.9000 | 5.1000 | 154.0200 | 130035.00 | 130035.00 | 0.00 | 255 | 35 | 256 | 38 | 6.73684210526316 | 0.296767595429802 | 0.296767595429802 | false | false | false | true | false | |||||||||||||||
| cbbfff4c-3923-49e9-8476-da7869715dfb | 2026-09-15 10:45 | 2026-09-15 10:44 | 2026-09-15 10:44 | BNY | BNY261016C00155000 | call | 155.0000 | 2026-10-16 | 4.9000 | 4.7000 | 5.0000 | 153.6553 | 156800.00 | 156800.00 | 0.00 | 320 | 6 | 583 | 38 | 15.3421052631579 | 0.295747492749487 | 0.295747492749487 | false | false | false | true | false | |||||||||||||||
| 0fff9f37-8469-41ac-b969-ddef9707a356 | 2026-09-16 12:47 | 2026-09-16 12:47 | 2026-09-16 12:47 | BNY | BNY270115C00170000 | call | 170.0000 | 2027-01-15 | 4.7000 | 4.3000 | 4.7000 | 155.6600 | 99170.00 | 99170.00 | 0.00 | 211 | 21 | 213 | 132 | 1.61363636363636 | 0.256812711035214 | 0.256812711035214 | false | false | false | true | false | |||||||||||||||
| 936f44b6-844d-4d01-843e-1882f28ffc34 | 2026-09-21 10:36 | 2026-09-21 10:36 | 2026-09-21 10:36 | BNY | BNY270115P00150000 | put | 150.0000 | 2027-01-15 | 6.4000 | 5.9000 | 6.4000 | 154.0300 | 61440.00 | 61440.00 | 0.00 | 96 | 14 | 2623 | 15108 | 0.173616626952608 | 0.268291081643811 | 0.268291081643811 | false | false | false | true | false | |||||||||||||||
| 32002223-851b-4d5a-bb30-296ecea81011 | 2026-09-21 12:08 | 2026-09-21 12:08 | 2026-09-21 12:08 | BNY | BNY261016P00150000 | put | 150.0000 | 2026-10-16 | 2.7500 | 2.5500 | 3.0000 | 153.2850 | 127050.00 | 275.00 | 126775.00 | 462 | 25 | 465 | 388 | 1.19845360824742 | 0.275131383146967 | 0.275131383146967 | false | false | false | true | false | |||||||||||||||
| 0a3c338b-fde0-4406-84a4-11b83bd3cc98 | 2026-09-21 14:53 | 2026-09-21 14:53 | 2026-09-21 14:53 | BNY | BNY261016C00155000 | call | 155.0000 | 2026-10-16 | 4.1000 | 3.9000 | 4.1000 | 154.1800 | 24190.00 | 24190.00 | 0.00 | 59 | 6 | 115 | 645 | 0.178294573643411 | 0.266618254150663 | 0.266618254150663 | false | false | false | true | false | |||||||||||||||
| 8918e320-d62d-49d7-93e9-ba542ea4d478 | 2026-09-21 15:57 | 2026-09-21 15:57 | 2026-09-21 15:57 | BNY | BNY270115P00150000 | put | 150.0000 | 2027-01-15 | 6.3000 | 6.1000 | 6.3000 | 154.1300 | 20790.00 | 20790.00 | 0.00 | 33 | 12 | 2956 | 15108 | 0.195657929573736 | 0.266350311002402 | 0.266350311002402 | false | false | false | true | false | |||||||||||||||
| 47e1527c-f9cd-41e2-87b0-1a8610ec51c4 | 2026-09-22 10:13 | 2026-09-22 10:13 | 2026-09-22 10:13 | BNY | BNY261016P00160000 | put | 160.0000 | 2026-10-16 | 9.4400 | 9.0000 | 9.5000 | 150.6150 | 447644.00 | 138670.00 | 80974.00 | 474 | 29 | 476 | 802 | 0.593516209476309 | 0.160489476400438 | 0.160489476400438 | false | false | false | true | false | |||||||||||||||
| e44bcbed-3fbf-46fa-a213-fe0e26baad54 | 2026-09-22 11:13 | 2026-09-22 11:13 | 2026-09-22 11:13 | BNY | BNY270115P00150000 | put | 150.0000 | 2027-01-15 | 8.0000 | 7.7000 | 8.0000 | 149.6900 | 1020800.00 | 1020800.00 | 0.00 | 1276 | 6 | 4232 | 13864 | 0.305251009809579 | 0.264840757765928 | 0.264840757765928 | false | false | false | true | false | |||||||||||||||
| 5fbeb86f-31f7-4faf-b4f6-bba09258c9d0 | 2026-09-22 11:20 | 2026-09-22 11:20 | 2026-09-22 11:20 | BNY | BNY261218C00175000 | call | 175.0000 | 2026-12-18 | 0.9000 | 0.7000 | 1.2000 | 149.4250 | 15380.00 | 0.00 | 15380.00 | 171 | 5 | 201 | 615 | 0.326829268292683 | 0.238182435593094 | 0.230764136262021 | false | false | false | true | false | |||||||||||||||
| fa72531d-3888-4195-bf79-01b13f15cbb1 | 2026-09-22 11:56 | 2026-09-22 11:56 | 2026-09-22 11:56 | BNY | BNY261016P00160000 | put | 160.0000 | 2026-10-16 | 10.1000 | 10.1000 | 11.9000 | 150.5000 | 47470.00 | 0.00 | 47470.00 | 47 | 11 | 533 | 802 | 0.664588528678304 | 0.254220671301496 | 0.254220671301496 | false | false | false | true | false | |||||||||||||||
| 1c298bba-517a-4af3-91ff-b0276d3c5c17 | 2026-09-22 12:00 | 2026-09-22 12:00 | 2026-09-22 12:00 | BNY | BNY270115P00150000 | put | 150.0000 | 2027-01-15 | 7.6000 | 7.4000 | 7.8000 | 150.6700 | 775200.00 | 756960.00 | 18240.00 | 1020 | 9 | 5952 | 13864 | 0.42931332948644 | 0.265274799428053 | 0.265530366973433 | true | false | false | true | false | |||||||||||||||
| cf5456a4-2510-4a44-95b6-5c4d4178e64d | 2026-09-22 12:02 | 2026-09-22 12:02 | 2026-09-22 12:02 | BNY | BNY270115P00150000 | put | 150.0000 | 2027-01-15 | 7.5000 | 7.4000 | 8.5000 | 150.7800 | 230264.00 | 1500.00 | 228764.00 | 307 | 15 | 6743 | 13864 | 0.486367570686671 | 0.262892589966449 | 0.263911383758092 | true | false | false | true | false | |||||||||||||||
| 84839a9e-05be-4da9-a0a6-6a4392c00728 | 2026-09-22 12:59 | 2026-09-22 12:59 | 2026-09-22 12:59 | BNY | BNY261016C00155000 | call | 155.0000 | 2026-10-16 | 2.8000 | 2.5500 | 3.1000 | 151.0000 | 13160.00 | 0.00 | 13160.00 | 47 | 5 | 85 | 676 | 0.125739644970414 | 0.268036896277645 | 0.268036896277645 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 106972963028.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 106972963028.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 106972963028.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 106972963028.00 |
| 2026-10-15 |
| 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 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 106972963028.00 |
| 2026-10-15 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 106972963028.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:36:02.227679Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 106972963028.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:36:02.227679Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 106972963028.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:08:52.274087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Financial Services |
| 106972963028.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:36:37.058930Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 106972963028.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 104130030673.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 104415002412.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:37:14.719915Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 104415002412.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:10:34.961716Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 104415002412.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:53:27.633876Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 104415002412.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 101890967004.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:15:02.242582Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 101890967004.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:15:45.651673Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 101890967004.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:21:55.684470Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 101890967004.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:00:55.569269Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 101890967004.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:07:35.242191Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 101890967004.00 |
| 2026-10-15 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:07:35.242191Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 101890967004.00 |
| 2026-10-15 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:06:21.234354Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |