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 |
|---|
| 57fa2465-cecf-4e39-adac-5381ff47935b | 2026-09-18 09:52 | 2026-09-18 09:52 | 2026-09-18 09:52 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 1.4400 | 1.3600 | 1.4400 | 144.1400 | 28512.00 | 28512.00 | 0.00 | 198 | 32 | 323 | 126 | 2.56349206349206 | 0.844947214185083 | 0.845115021186689 | false | false | false | true | 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-18T13:59:27.968934Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| aba9b721-3f12-4c10-9e12-b8147b3f5375 | 2026-09-18 13:25 | 2026-09-18 13:25 | 2026-09-18 13:25 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 2.2300 | 2.1600 | 2.2600 | 150.4000 | 111498.00 | 110162.00 | 1336.00 | 500 | 42 | 1612 | 126 | 12.7936507936508 | 0.758652385890503 | 0.758652385890503 | true | false | false | |||||||||||||||||
| 420e3e85-495a-408e-9894-54f91339d035 | 2026-09-18 14:47 | 2026-09-18 14:47 | 2026-09-18 14:47 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 2.4600 | 2.3700 | 2.4600 | 151.8200 | 16236.00 | 16236.00 | 0.00 | 66 | 12 | 5335 | 126 | 42.3412698412698 | 0.738056022793584 | 0.738056022793584 | false | false | false | |||||||||||||||||
| d2ff2c0e-5044-4578-ad46-1cb97641856b | 2026-09-21 10:13 | 2026-09-21 10:13 | 2026-09-21 10:13 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 7.6500 | 7.5000 | 7.6500 | 165.1400 | 14535.00 | 14535.00 | 0.00 | 19 | 5 | 637 | 6255 | 0.101838529176659 | 0.906858590788683 | 0.906858590788683 | false | false | false | |||||||||||||||||
| 0eafaf72-422a-47fe-b896-6f7b912360d2 | 2026-09-21 12:32 | 2026-09-21 12:32 | 2026-09-21 12:32 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 8.2500 | 8.1000 | 8.2500 | 166.0000 | 24750.00 | 24750.00 | 0.00 | 30 | 6 | 1231 | 6255 | 0.196802557953637 | 0.889327293488347 | 0.889327293488347 | false | false | false | |||||||||||||||||
| 38c8badd-26e8-4b24-9cd1-460ff44a7b07 | 2026-09-21 15:09 | 2026-09-21 15:09 | 2026-09-21 15:09 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 8.4000 | 8.4000 | 8.5500 | 166.9700 | 26040.00 | 0.00 | 26040.00 | 31 | 7 | 1527 | 6255 | 0.244124700239808 | 0.851041620506014 | 0.851041620506014 | false | false | false | |||||||||||||||||
| 7486742a-f579-4893-99ea-b8eebf01ffc4 | 2026-09-22 09:31 | 2026-09-22 09:31 | 2026-09-22 09:31 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 8.5500 | 8.5500 | 8.8000 | 168.1799 | 11971.00 | 0.00 | 11971.00 | 14 | 14 | 15 | 6204 | 0.00241779497098646 | 0.867916381599861 | 0.867916381599861 | false | false | false | |||||||||||||||||
| f721229b-1c3b-464b-9f32-85b4db3800d2 | 2026-09-22 09:42 | 2026-09-22 09:42 | 2026-09-22 09:42 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 8.4500 | 8.2500 | 8.4500 | 167.9200 | 16055.00 | 16055.00 | 0.00 | 19 | 10 | 80 | 6204 | 0.0128949065119278 | 0.881987637559581 | 0.881987637559581 | false | false | false | |||||||||||||||||
| e67de73c-d777-4694-acc1-5988d455d95f | 2026-09-22 10:30 | 2026-09-22 10:30 | 2026-09-22 10:30 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 9.5000 | 9.5000 | 9.6500 | 169.8950 | 284050.00 | 0.00 | 284050.00 | 299 | 35 | 776 | 6204 | 0.1250805931657 | 0.815983769983934 | 0.815983769983934 | true | false | false | |||||||||||||||||
| d1ea80da-0516-45d6-9c05-170a2c1f0fbb | 2026-09-23 10:25 | 2026-09-23 10:25 | 2026-09-23 10:25 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 4.9500 | 4.8000 | 4.9500 | 163.0000 | 24750.00 | 24750.00 | 0.00 | 50 | 5 | 429 | 5759 | 0.0744920993227991 | 0.884521263425234 | 0.884521263425234 | false | false | false | |||||||||||||||||
| 47c7f2f3-10c5-4a24-b5cb-3c6a8a0f386e | 2026-09-23 13:18 | 2026-09-23 13:18 | 2026-09-23 13:18 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 4.2500 | 4.1000 | 4.2500 | 163.0000 | 13175.00 | 13175.00 | 0.00 | 31 | 10 | 1478 | 5759 | 0.256641778086473 | 0.822038891292508 | 0.797251256836302 | false | false | false | |||||||||||||||||
| 5bfe1f69-a5f2-4364-ac01-8339799aaf2d | 2026-09-23 15:54 | 2026-09-23 15:54 | 2026-09-23 15:54 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 4.0000 | 4.0000 | 4.1500 | 162.9204 | 17600.00 | 0.00 | 17600.00 | 44 | 12 | 2734 | 5759 | 0.474735197082827 | 0.784325094224358 | 0.784325094224358 | false | false | false | |||||||||||||||||
| 0e1d3d1d-9bcf-4268-8161-9738de4a95c8 | 2026-09-24 10:51 | 2026-09-24 10:51 | 2026-09-24 10:51 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 2.2900 | 2.2900 | 2.3600 | 160.8050 | 11679.00 | 0.00 | 11679.00 | 51 | 6 | 6143 | 6472 | 0.949165636588381 | 0.905369227900548 | 0.905369227900548 | true | false | false | |||||||||||||||||
| 9e65e2e5-28d6-4013-82a3-0dfe06320cb6 | 2026-09-24 10:54 | 2026-09-24 10:54 | 2026-09-24 10:54 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 1.8100 | 1.8000 | 1.8800 | 159.2950 | 12851.00 | 181.00 | 12670.00 | 71 | 18 | 6340 | 6472 | 0.979604449938195 | 0.937868033003561 | 0.937868033003561 | true | false | false | |||||||||||||||||
| 064de65c-6fb8-4773-8195-28d01d52d5b8 | 2026-09-24 11:18 | 2026-09-24 11:18 | 2026-09-24 11:18 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 2.1300 | 2.1300 | 2.1900 | 160.5000 | 30672.00 | 0.00 | 30672.00 | 144 | 32 | 7225 | 6472 | 1.11634734239802 | 0.895091276482416 | 0.895091276482416 | false | false | false | |||||||||||||||||
| 57aabc3d-7a4a-4a66-a1fc-58a954f70d58 | 2026-09-25 09:36 | 2026-09-25 09:35 | 2026-09-25 09:35 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 1.1600 | 1.0900 | 1.1600 | 160.4750 | 30130.00 | 29580.00 | 550.00 | 260 | 24 | 716 | 4992 | 0.143429487179487 | 1.15464242738255 | 1.15464242738255 | false | false | false |
| 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-18T17:36:08.685771Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 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-18T19:03:43.854590Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| 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-21T14:14:40.112451Z"} |
| 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-21T16:32:17.927421Z"} |
| 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 |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-22T13:32:27.895939Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T13:43:21.956551Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T14:31:31.654153Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:26:39.791719Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:20:19.861269Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:57:58.068578Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:53:28.868411Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:56:01.849843Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:21:44.336640Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 57826906314.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:37:30.150792Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |