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 |
|---|
| 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 |
|---|
| 23f7bc95-392a-47b0-9be7-581553f7be7d | 2026-09-29 14:40 | 2026-09-29 14:39 | 2026-09-29 14:39 | MSTR | MSTR261023C00165000 | call | 165.0000 | 2026-10-23 | 6.6000 | 6.6000 | 6.7000 | 154.0000 | 23100.00 | 0.00 | 23100.00 | 35 | 10 | 4753 | 1041 | 4.56580211335255 | 0.674199083576684 | 0.674199083576684 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 56390439440.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T18:41:07.734173Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 2d33a69c-4149-41d2-8f56-2fc6438890a7 | 2026-09-29 14:34 | 2026-09-29 14:34 | 2026-09-29 14:34 | MSTR | MSTR261023C00165000 | call | 165.0000 | 2026-10-23 | 6.6500 | 6.4500 | 6.7000 | 154.0000 | 165585.00 | 161595.00 | 3990.00 | 249 | 21 | 2747 | 1041 | 2.6388088376561 | 0.677626228062592 | 0.675577089656801 | true | false | false | |||||||||||||||||
| 03c7011a-0c1e-4cd4-9554-1f491a9fb81a | 2026-09-29 14:34 | 2026-09-29 14:34 | 2026-09-29 14:34 | MSTR | MSTR261023C00165000 | call | 165.0000 | 2026-10-23 | 6.6000 | 6.4000 | 6.6500 | 154.0000 | 165568.00 | 165568.00 | 0.00 | 251 | 38 | 2498 | 1041 | 2.39961575408261 | 0.676882568382484 | 0.673155599646128 | true | false | false | |||||||||||||||||
| 8e7e7072-dd29-4c29-952c-8a9a55759065 | 2026-09-29 14:34 | 2026-09-29 14:34 | 2026-09-29 14:34 | MSTR | MSTR261023C00165000 | call | 165.0000 | 2026-10-23 | 6.5600 | 6.4000 | 6.6000 | 154.0000 | 327818.00 | 327818.00 | 0.00 | 500 | 7 | 2247 | 1041 | 2.15850144092219 | 0.673170696593477 | 0.673170696593477 | false | false | false | |||||||||||||||||
| 45007510-04f8-4d7d-9c55-7d3c355596a4 | 2026-09-29 14:34 | 2026-09-29 14:34 | 2026-09-29 14:34 | MSTR | MSTR261023C00165000 | call | 165.0000 | 2026-10-23 | 6.4000 | 6.2500 | 6.4000 | 153.0000 | 321234.00 | 321234.00 | 0.00 | 502 | 7 | 1246 | 1041 | 1.1969260326609 | 0.671000452281764 | 0.670335337148117 | false | false | false | |||||||||||||||||
| d3f24a3f-362c-4fbe-89ef-ec0f11ccf352 | 2026-09-29 14:34 | 2026-09-29 14:34 | 2026-09-29 14:34 | MSTR | MSTR261023C00165000 | call | 165.0000 | 2026-10-23 | 6.3700 | 6.2500 | 6.4000 | 153.0000 | 318281.00 | 318281.00 | 0.00 | 500 | 9 | 744 | 1041 | 0.714697406340058 | 0.670201639884165 | 0.669535206390328 | false | false | false | |||||||||||||||||
| 0115017c-76c8-4888-9a05-b20907ea46b3 | 2026-09-28 13:27 | 2026-09-28 13:27 | 2026-09-28 13:27 | MSTR | MSTR261023C00165000 | call | 165.0000 | 2026-10-23 | 9.3500 | 9.3500 | 9.5500 | 160.2500 | 12155.00 | 0.00 | 12155.00 | 13 | 5 | 70 | 1005 | 0.0696517412935323 | 0.671372625175952 | 0.671372625175952 | false | false | false | |||||||||||||||||
| 9f33fb96-5d8c-4f22-8084-5191539569ff | 2026-09-22 14:30 | 2026-09-22 14:30 | 2026-09-22 14:30 | MSTR | MSTR261023C00165000 | call | 165.0000 | 2026-10-23 | 15.8500 | 15.7000 | 16.1000 | 168.5700 | 15850.00 | 0.00 | 15850.00 | 10 | 5 | 682 | 459 | 1.48583877995643 | 0.703279347987279 | 0.70790506611412 | false | false | false | |||||||||||||||||
| a5177c01-f392-438f-b1d4-bd813847a894 | 2026-09-21 15:05 | 2026-09-21 15:05 | 2026-09-21 15:05 | MSTR | MSTR261023C00165000 | call | 165.0000 | 2026-10-23 | 15.6500 | 15.4500 | 15.7500 | 166.0000 | 12520.00 | 10955.00 | 1565.00 | 8 | 5 | 240 | 327 | 0.73394495412844 | 0.738169687003564 | 0.738169687003564 | false | false | false | |||||||||||||||||
| 293ea4ab-cad2-4ecd-acbc-8ec374979816 | 2026-09-21 15:05 | 2026-09-21 15:05 | 2026-09-21 15:05 | MSTR | MSTR261023C00165000 | call | 165.0000 | 2026-10-23 | 15.6500 | 15.4500 | 15.7500 | 166.0000 | 12520.00 | 10955.00 | 0.00 | 8 | 7 | 232 | 327 | 0.709480122324159 | 0.738463341680871 | 0.738463341680871 | false | false | false | |||||||||||||||||
| 6429dcf4-eec9-4fcd-b11f-3f39c6a6273e | 2026-09-18 10:38 | 2026-09-18 10:38 | 2026-09-18 10:38 | MSTR | MSTR261023C00165000 | call | 165.0000 | 2026-10-23 | 6.3500 | 6.3500 | 6.4000 | 145.8200 | 20320.00 | 0.00 | 20320.00 | 32 | 12 | 65 | 267 | 0.243445692883895 | 0.714275530685073 | 0.715494920667106 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56390439440.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:39:05.555740Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 56390439440.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:39:05.555740Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 56390439440.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:39:05.555740Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 56390439440.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:39:05.555740Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 56390439440.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:39:05.555740Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 57290965627.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:33:20.125658Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61006091882.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:36:42.386317Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 56117000314.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |