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_alerts658,639 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 |
|---|
| 9d03cb93-58d0-4663-ab4b-82528af6a277 | 2026-09-21 11:10 | 2026-09-21 11:10 | 2026-09-21 11:10 | MSTR | MSTR260925C00175000 | call | 175.0000 | 2026-09-25 | 3.7500 | 3.7500 | 3.8500 | 167.0000 | 10125.00 | 0.00 | 10125.00 | 27 | 8 | 11731 | 3578 | 3.27864728898826 | 0.953536173347144 | 0.953536173347144 | true | false | false | true | 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-21T15:13:03.739619Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 82be1c86-dd8f-41f1-9680-cda4421c4056 | 2026-09-21 11:09 | 2026-09-21 11:09 | 2026-09-21 11:09 | MSTR | MSTR260925C00175000 | call | 175.0000 | 2026-09-25 | 3.7000 | 3.7000 | 3.8000 | 167.0000 | 19610.00 | 0.00 | 19610.00 | 53 | 13 | 11667 | 3578 | 3.26076020122974 | 0.946650817337402 | 0.946650817337402 | true | false | false | true | false | |||||||||||||||
| 4aece1c6-d53a-49e9-9f75-d6b952879e55 | 2026-09-21 11:04 | 2026-09-21 11:04 | 2026-09-21 11:04 | MSTR | MSTR260925C00175000 | call | 175.0000 | 2026-09-25 | 3.5000 | 3.5000 | 3.6000 | 167.0000 | 15750.00 | 0.00 | 15750.00 | 45 | 15 | 11602 | 3578 | 3.24259362772499 | 0.936717004765823 | 0.943589778071712 | true | false | false | true | false | |||||||||||||||
| fbccd147-a0cd-4a80-8e45-13a50d407716 | 2026-09-21 11:04 | 2026-09-21 11:04 | 2026-09-21 11:04 | MSTR | MSTR260925C00175000 | call | 175.0000 | 2026-09-25 | 3.5500 | 3.5500 | 3.6500 | 167.1050 | 14910.00 | 0.00 | 14910.00 | 42 | 7 | 11557 | 3578 | 3.23001676914477 | 0.945846761845973 | 0.945846761845973 | true | false | false | true | false | |||||||||||||||
| 8add11c1-c7e1-44b3-b3de-8723a9724ae2 | 2026-09-21 10:53 | 2026-09-21 10:53 | 2026-09-21 10:53 | MSTR | MSTR260925C00175000 | call | 175.0000 | 2026-09-25 | 3.7400 | 3.7000 | 3.7500 | 167.3900 | 25055.00 | 21350.00 | 3705.00 | 67 | 10 | 11043 | 3578 | 3.08636109558413 | 0.96162525455441 | 0.955454730328404 | false | false | false | true | ||||||||||||||||
| 745790f6-a401-4509-b91d-76e859d23e04 | 2026-09-21 10:31 | 2026-09-21 10:31 | 2026-09-21 10:31 | MSTR | MSTR260925C00175000 | call | 175.0000 | 2026-09-25 | 3.0800 | 3.1000 | 3.2000 | 165.6050 | 16950.00 | 0.00 | 16950.00 | 55 | 11 | 9788 | 3578 | 2.73560648406931 | 0.943452020235993 | 0.951653501425751 | true | false | false | true | false | |||||||||||||||
| 9f52d734-35ca-4022-8eae-409c69f3a88e | 2026-09-18 15:26 | 2026-09-18 15:26 | 2026-09-18 15:26 | MSTR | MSTR260925C00175000 | call | 175.0000 | 2026-09-25 | 1.2000 | 1.1900 | 1.2000 | 153.4701 | 11880.00 | 11880.00 | 0.00 | 99 | 7 | 6493 | 589 | 11.0237691001698 | 0.82944971930363 | 0.82944971930363 | false | false | false | true | false | |||||||||||||||
| 812b3e80-ab0a-45e1-b2e9-12dcb63049a5 | 2026-09-18 15:25 | 2026-09-18 15:25 | 2026-09-18 15:25 | MSTR | MSTR260925C00175000 | call | 175.0000 | 2026-09-25 | 1.2200 | 1.2000 | 1.2200 | 153.5450 | 11224.00 | 11224.00 | 0.00 | 92 | 5 | 6377 | 589 | 10.8268251273345 | 0.831431882974997 | 0.831431882974997 | false | false | false | true | false | |||||||||||||||
| 4d3e3e80-72e6-4083-954b-90b08a25c12f | 2026-09-18 15:19 | 2026-09-18 15:18 | 2026-09-18 15:18 | MSTR | MSTR260925C00175000 | call | 175.0000 | 2026-09-25 | 1.1900 | 1.1600 | 1.2000 | 153.3400 | 24003.00 | 24003.00 | 0.00 | 201 | 30 | 6213 | 589 | 10.5483870967742 | 0.831182797033425 | 0.831182797033425 | true | false | false | true | false | |||||||||||||||
| 24a25bfa-43b4-42a8-a5ce-7ff73a522ae5 | 2026-09-18 15:14 | 2026-09-18 15:14 | 2026-09-18 15:14 | MSTR | MSTR260925C00175000 | call | 175.0000 | 2026-09-25 | 1.0800 | 1.0600 | 1.0900 | 152.8000 | 21276.00 | 14688.00 | 6588.00 | 197 | 6 | 5961 | 589 | 10.1205432937182 | 0.822766338311842 | 0.82305673566659 | true | false | false | true | false | |||||||||||||||
| 72d210e3-9d8e-49db-b11e-d65bd98b182a | 2026-09-18 15:12 | 2026-09-18 15:12 | 2026-09-18 15:12 | MSTR | MSTR260925C00175000 | call | 175.0000 | 2026-09-25 | 1.0300 | 0.9900 | 1.0300 | 152.7143 | 13287.00 | 13287.00 | 0.00 | 129 | 11 | 5721 | 589 | 9.71307300509338 | 0.814244308501539 | 0.814244308501539 | false | false | false | true | ||||||||||||||||
| 68b1e2c1-632f-40ac-857f-68d627035565 | 2026-09-18 15:12 | 2026-09-18 15:12 | 2026-09-18 15:12 | MSTR | MSTR260925C00175000 | call | 175.0000 | 2026-09-25 | 1.0300 | 0.9900 | 1.0300 | 152.7300 | 16583.00 | 16583.00 | 0.00 | 161 | 26 | 5592 | 589 | 9.49405772495756 | 0.813792298028545 | 0.813792298028545 | false | false | false | true | ||||||||||||||||
| 95a8d116-d49c-4d26-a6f9-41a5250a8b05 | 2026-09-18 14:54 | 2026-09-18 14:54 | 2026-09-18 14:54 | MSTR | MSTR260925C00175000 | call | 175.0000 | 2026-09-25 | 0.9300 | 0.9000 | 0.9300 | 151.9400 | 27900.00 | 7905.00 | 0.00 | 300 | 27 | 5323 | 589 | 9.03735144312394 | 0.812818131344251 | 0.812818131344251 | true | false | false | true | false | |||||||||||||||
| 69276554-8a1c-4905-b21e-227218998f94 | 2026-09-18 13:59 | 2026-09-18 13:59 | 2026-09-18 13:59 | MSTR | MSTR260925C00175000 | call | 175.0000 | 2026-09-25 | 1.0000 | 0.9700 | 1.0000 | 151.9450 | 24800.00 | 24800.00 | 0.00 | 248 | 12 | 4601 | 589 | 7.81154499151104 | 0.829384290578028 | 0.829384290578028 | false | false | false | true | ||||||||||||||||
| e75045c5-fbdc-4fe4-b3a0-a53bd015a642 | 2026-09-18 11:39 | 2026-09-18 11:39 | 2026-09-18 11:39 | MSTR | MSTR260925C00175000 | call | 175.0000 | 2026-09-25 | 0.7100 | 0.7100 | 0.7400 | 147.7520 | 11999.00 | 0.00 | 11999.00 | 169 | 14 | 2854 | 589 | 4.84550084889643 | 0.869515896209342 | 0.869515896209342 | false | false | false | true | ||||||||||||||||
| 6fecedcd-9e19-4db5-a069-5fd7f0419e78 | 2026-09-18 10:23 | 2026-09-18 10:23 | 2026-09-18 10:23 | MSTR | MSTR260925C00175000 | call | 175.0000 | 2026-09-25 | 0.7500 | 0.7100 | 0.7500 | 146.6300 | 15675.00 | 15675.00 | 0.00 | 209 | 13 | 1822 | 589 | 3.09337860780985 | 0.912095669477693 | 0.912095669477693 | false | false | false | true |
| 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-21T15:13:03.739619Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:05:23.809831Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:05:23.809831Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:55:57.762099Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-18T19:37:13.545792Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| 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-18T19:37:13.545792Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 56117000314.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| 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-18T19:21:35.220831Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| 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-18T19:21:35.220831Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| 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-18T19:21:35.220831Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| 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-18T19:03:43.854590Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| 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-18T17:59:53.998874Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| 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-18T15:40:17.489597Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| 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:32:18.430939Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |