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 | expiry |
|---|
| 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 |
|---|
| 84d8fe2f-2047-440b-82a8-cb5802fc6ed6 | 2026-08-18 12:59 | 2026-08-18 12:59 | 2026-08-18 12:59 | ORCL | ORCL270115P00130000 | put | 130.0000 | 2027-01-15 | 14.5500 | 14.5000 | 14.8000 | 143.7600 | 88755.00 | 0.00 | 88755.00 | 61 | 16 | 69 | 15166 | 0.00454965053408941 | 0.625365469456297 | 0.625365469456297 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 93dee614-5649-4bd4-b393-cc11915cb4d6 | 2026-09-01 14:40 | 2026-09-01 14:40 | 2026-09-01 14:40 | ORCL | ORCL270115P00130000 | put | 130.0000 | 2027-01-15 | 14.2500 | 14.2000 | 14.5000 | 140.1900 | 106875.00 | 0.00 | 106875.00 | 75 | 8 | 104 | 15341 | 0.00677921908610912 | 0.604662175714425 | 0.604662175714425 | false | false | false | |||||||||||||||||
| 1857c96a-2b3b-4c54-b8cc-38c901c37a89 | 2026-09-17 11:44 | 2026-09-17 11:44 | 2026-09-17 11:44 | ORCL | ORCL270115P00130000 | put | 130.0000 | 2027-01-15 | 8.5000 | 8.5000 | 8.7000 | 151.4500 | 84150.00 | 0.00 | 84150.00 | 99 | 13 | 147 | 15934 | 0.00922555541609138 | 0.558803279351393 | 0.558803279351393 | false | false | false | |||||||||||||||||
| dd02599b-bb42-4927-8c66-0acf4b50566c | 2026-09-18 10:56 | 2026-09-18 10:56 | 2026-09-18 10:56 | ORCL | ORCL270115P00130000 | put | 130.0000 | 2027-01-15 | 9.9000 | 9.9000 | 10.0000 | 145.0300 | 164340.00 | 0.00 | 164340.00 | 166 | 9 | 248 | 15986 | 0.0155135743775804 | 0.549146933547428 | 0.549146933547428 | false | false | false | |||||||||||||||||
| cc83c7b7-1f17-4238-b2b4-a19b7968775c | 2026-09-23 11:22 | 2026-09-23 11:22 | 2026-09-23 11:22 | ORCL | ORCL270115P00130000 | put | 130.0000 | 2027-01-15 | 9.2500 | 9.2500 | 9.4000 | 146.9550 | 33303.00 | 0.00 | 33303.00 | 36 | 11 | 52 | 16219 | 0.00320611628337135 | 0.556311369905583 | 0.556427160072625 | false | false | false | |||||||||||||||||
| f524e28e-d1a7-440b-8962-32b10258c915 | 2026-09-24 09:49 | 2026-09-24 09:49 | 2026-09-24 09:49 | ORCL | ORCL270115P00130000 | put | 130.0000 | 2027-01-15 | 13.0000 | 12.6000 | 13.1000 | 135.6450 | 10400.00 | 7800.00 | 2600.00 | 8 | 6 | 247 | 16186 | 0.0152601013221302 | 0.562992135545786 | 0.562992135545786 | true | false | false | |||||||||||||||||
| f9aaa547-bf9e-48e3-a609-b4fdb2501314 | 2026-09-24 10:42 | 2026-09-24 10:42 | 2026-09-24 10:42 | ORCL | ORCL270115P00130000 | put | 130.0000 | 2027-01-15 | 12.4000 | 12.2500 | 12.4000 | 137.2300 | 53320.00 | 53320.00 | 0.00 | 43 | 12 | 538 | 16186 | 0.0332386012603485 | 0.56206397186067 | 0.56206397186067 | false | false | false | |||||||||||||||||
| ed20cfa4-fb72-4b8e-bb51-724fe3cc2061 | 2026-09-24 15:06 | 2026-09-24 15:06 | 2026-09-24 15:06 | ORCL | ORCL270115P00130000 | put | 130.0000 | 2027-01-15 | 11.5000 | 11.5000 | 11.5500 | 139.5700 | 323150.00 | 0.00 | 323150.00 | 281 | 18 | 1206 | 16186 | 0.0745088347955023 | 0.558780783052645 | 0.558780783052645 | false | false | false | |||||||||||||||||
| 811c4a2e-bc0e-42fb-a8b4-3a9ae535d1aa | 2026-09-28 13:58 | 2026-09-28 13:58 | 2026-09-28 13:58 | ORCL | ORCL270115P00130000 | put | 130.0000 | 2027-01-15 | 13.5300 | 13.5000 | 13.6000 | 133.1600 | 16240.00 | 1355.00 | 12175.00 | 12 | 5 | 660 | 16432 | 0.0401655306718598 | 0.558150044099956 | 0.558150044099956 | true | false | false | |||||||||||||||||
| 31b2bfe3-a81e-4ea5-becc-b15849e5dcab | 2026-09-28 14:41 | 2026-09-28 14:41 | 2026-09-28 14:41 | ORCL | ORCL270115P00130000 | put | 130.0000 | 2027-01-15 | 13.4500 | 13.1500 | 13.6500 | 133.0000 | 67250.00 | 24210.00 | 43040.00 | 50 | 6 | 793 | 16432 | 0.0482594936708861 | 0.557372540365682 | 0.557372540365682 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T18:58:03.753197Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 455344404240.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:59:42.981722Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 446333670960.00 |
| 2026-12-09 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 437111276160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:23:47.442599Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 437111276160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:51:23.785124Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 437111276160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:44:10.025245Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 437111276160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:07:42.806014Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 400947393600.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:00:44.175376Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 400947393600.00 |
| 2026-12-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:44:38.153371Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |