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_alerts375,978 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 |
|---|
| 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 |
|---|
| 422762be-5e72-42e2-8646-6adf45359ac9 | 2026-09-02 11:28 | 2026-09-02 11:28 | 2026-09-02 11:28 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 0.9500 | 0.8500 | 0.9500 | 7.7950 | 28500.00 | 28500.00 | 0.00 | 300 | 9 | 304 | 388 | 0.783505154639175 | 0.700923394227285 | 0.700923394227285 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 8870829605.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 67251868-ce58-4073-a670-eb2c98c73baf | 2026-09-02 15:59 | 2026-09-02 15:59 | 2026-09-02 15:59 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 1.1000 | 0.9000 | 1.1500 | 7.9600 | 44000.00 | 21560.00 | 16610.00 | 400 | 12 | 1109 | 388 | 2.85824742268041 | 0.756596514396801 | 0.738038869371059 | false | false | false | true | ||||||||||||||||
| af9655cd-7933-42b8-9320-cca063419462 | 2026-09-02 15:59 | 2026-09-02 15:59 | 2026-09-02 15:59 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 1.1000 | 0.9000 | 1.1500 | 7.9605 | 43950.00 | 43950.00 | 0.00 | 400 | 8 | 1509 | 388 | 3.88917525773196 | 0.737095271837384 | 0.713839356635836 | false | false | false | true | ||||||||||||||||
| bb4f5a6c-0043-4408-8e41-04ac6e5717e5 | 2026-09-02 15:59 | 2026-09-02 15:59 | 2026-09-02 15:59 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 1.1000 | 0.9000 | 1.1500 | 7.9600 | 21976.00 | 17576.00 | 4400.00 | 200 | 12 | 1709 | 388 | 4.40463917525773 | 0.747390830430443 | 0.738038869371059 | false | false | false | true | ||||||||||||||||
| 33991677-737e-4657-8611-e7228cfd2d67 | 2026-09-03 10:42 | 2026-09-03 10:42 | 2026-09-03 10:42 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 1.1000 | 0.9500 | 1.2000 | 7.9550 | 12430.00 | 5610.00 | 4400.00 | 113 | 5 | 735 | 2288 | 0.321241258741259 | 0.773599560029598 | 0.773599560029598 | false | false | false | true | ||||||||||||||||
| 4c2b4d89-7430-4a6c-a792-f3a6defbc8fe | 2026-09-03 11:12 | 2026-09-03 11:12 | 2026-09-03 11:12 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 1.1000 | 1.0000 | 1.2000 | 8.0200 | 11000.00 | 9900.00 | 1100.00 | 100 | 5 | 1300 | 2288 | 0.568181818181818 | 0.631282741154648 | 0.631797302540308 | false | false | false | true | ||||||||||||||||
| 9f654601-ee65-4644-8376-95507b55e441 | 2026-09-08 15:41 | 2026-09-08 15:41 | 2026-09-08 15:41 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 1.2000 | 1.0500 | 1.4000 | 8.1300 | 48000.00 | 42240.00 | 5760.00 | 400 | 16 | 1580 | 5679 | 0.278217996126079 | 0.797330581765911 | 0.797330581765911 | true | false | false | true | ||||||||||||||||
| 294299d3-57b0-40f7-bb3b-a0b1d0e68655 | 2026-09-08 15:42 | 2026-09-08 15:42 | 2026-09-08 15:42 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 1.2400 | 1.0500 | 1.2500 | 8.1650 | 12400.00 | 12400.00 | 0.00 | 100 | 5 | 1880 | 5679 | 0.331044197922169 | 0.831818756647853 | 0.831818756647853 | false | false | false | true | ||||||||||||||||
| 986ab668-3141-47b9-b8e9-f52be8ed924e | 2026-09-08 15:45 | 2026-09-08 15:45 | 2026-09-08 15:45 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 1.2500 | 1.1000 | 1.4500 | 8.1900 | 56250.00 | 47750.00 | 8500.00 | 450 | 22 | 2630 | 5679 | 0.463109702412397 | 0.782757249312765 | 0.782757249312765 | true | false | false | true | ||||||||||||||||
| cc31ba13-d1a8-4d3e-8690-4fb88023b0af | 2026-09-10 13:51 | 2026-09-10 13:51 | 2026-09-10 13:51 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 0.7500 | 0.7000 | 0.9000 | 7.6850 | 22500.00 | 2250.00 | 20250.00 | 300 | 8 | 924 | 9207 | 0.100358422939068 | 0.642553965690551 | 0.642553965690551 | false | false | false | true | ||||||||||||||||
| d5d43274-bb67-4501-a924-6ce67480942f | 2026-09-11 09:37 | 2026-09-11 09:37 | 2026-09-11 09:37 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 1.2000 | 0.9500 | 1.4250 | 8.1750 | 12000.00 | 3600.00 | 8400.00 | 100 | 6 | 100 | 8394 | 0.0119132713843221 | 0.726879783927454 | 0.726879783927454 | false | false | false | true | ||||||||||||||||
| 60ec6ef8-b010-4ac9-95da-d505f0e375ab | 2026-09-11 09:49 | 2026-09-11 09:48 | 2026-09-11 09:48 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 1.1500 | 1.1000 | 1.3000 | 8.0000 | 115000.00 | 1150.00 | 97750.00 | 1000 | 7 | 3001 | 8394 | 0.357517274243507 | 0.648988467697263 | 1.22496289318019 | false | false | false | true | ||||||||||||||||
| c15e8d29-083a-4363-acae-0dbd91e8c18c | 2026-09-11 10:29 | 2026-09-11 10:29 | 2026-09-11 10:29 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 1.2000 | 1.2000 | 1.3500 | 8.2250 | 120000.00 | 0.00 | 120000.00 | 1000 | 28 | 5012 | 8394 | 0.597093161782225 | 1.2379869773866 | 1.2379869773866 | false | false | false | true | ||||||||||||||||
| 41654835-456d-4fa4-9786-b7340ae68b17 | 2026-09-11 10:31 | 2026-09-11 10:31 | 2026-09-11 10:31 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 1.1600 | 1.1500 | 1.2500 | 8.1700 | 10171.00 | 0.00 | 10171.00 | 88 | 10 | 5300 | 8394 | 0.631403383369073 | 1.00789613243953 | 1.02731930664987 | false | false | false | true | ||||||||||||||||
| 7098d850-87ac-40ed-9c3c-141744d33a1f | 2026-09-11 10:31 | 2026-09-11 10:31 | 2026-09-11 10:31 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 1.1300 | 1.1000 | 1.2500 | 8.1674 | 10985.00 | 0.00 | 10985.00 | 97 | 7 | 5412 | 8394 | 0.644746247319514 | 1.03717441853684 | 1.03717441853684 | false | false | false | true | ||||||||||||||||
| ece398bc-f43e-4160-974b-8961d1e254f3 | 2026-09-11 10:32 | 2026-09-11 10:31 | 2026-09-11 10:31 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 1.1000 | 1.1000 | 1.2500 | 8.0850 | 66000.00 | 0.00 | 66000.00 | 600 | 10 | 6012 | 8394 | 0.716225875625447 | 1.16495193120606 | 0.59611471781546 | false | false | false | true | ||||||||||||||||
| 173a7f08-e1f6-413a-b4f2-bf1e7bdd27d0 | 2026-09-11 10:33 | 2026-09-11 10:33 | 2026-09-11 10:33 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 1.1000 | 1.1000 | 1.2000 | 8.0900 | 104500.00 | 0.00 | 92400.00 | 950 | 8 | 7012 | 8394 | 0.835358589468668 | 0.53009731189237 | 0.53009731189237 | false | false | false | true | ||||||||||||||||
| 33a3ea5f-ae78-4777-a26b-508b564bf97f | 2026-09-11 10:37 | 2026-09-11 10:37 | 2026-09-11 10:37 | IBRX | IBRX260918C00007000 | call | 7.0000 | 2026-09-18 | 1.0500 | 1.0000 | 1.1500 | 8.0310 | 84000.00 | 0.00 | 84000.00 | 800 | 7 | 8062 | 8394 | 0.960447939004051 | 1.02819598749177 | 0.613605457124602 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:35:49.066709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:35:49.066709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:35:49.066709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:57:35.447301Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:12:38.137640Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:09:00.187388Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:46:58.036194Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:59:42.234161Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 8870829605.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |