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_alerts425,429 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 77c44ec0-f686-4760-beab-cfa0e6e4dce1 | 2026-09-22 10:30 | 2026-09-22 10:30 | 2026-09-22 10:30 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 9.5500 | 9.5000 | 9.7500 | 169.8950 | 165175.00 | 0.00 | 165175.00 | 173 | 12 | 477 | 6204 | 0.0768858800773694 | 0.807797167609424 | 0.82596705901937 | true | false | false | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 11afa929-ef5d-403a-9628-c4b3c851d7be | 2026-09-23 14:22 | 2026-09-23 14:22 | 2026-09-23 14:22 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 3.7900 | 3.7000 | 3.8000 | 162.0000 | 12875.00 | 12875.00 | 0.00 | 34 | 6 | 1874 | 5759 | 0.325403715922903 | 0.787458434511119 | 0.793714333941027 | false | false | false | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| dc5650f8-6cfa-47a4-9f3b-c23595fd68a1 | 2026-09-24 11:02 | 2026-09-24 11:02 | 2026-09-24 11:02 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 1.8100 | 1.7700 | 1.8200 | 159.3600 | 27192.00 | 27192.00 | 0.00 | 150 | 22 | 6680 | 6472 | 1.03213844252163 | 0.933681325418184 | 0.933681325418184 | false | false | false | true | ||||||||||||||||
| 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 | true | ||||||||||||||||
| 2ebc5d91-9995-40fc-a685-7ef332fd04f1 | 2026-09-24 13:00 | 2026-09-24 13:00 | 2026-09-24 13:00 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 2.6300 | 2.6300 | 2.7200 | 161.9700 | 26305.00 | 0.00 | 26041.00 | 100 | 14 | 10355 | 6472 | 1.59996909765142 | 0.852871510758569 | 0.84991135813545 | false | false | false | true | ||||||||||||||||
| 470e6006-75d9-4d41-8151-a6c141ed344e | 2026-09-24 13:37 | 2026-09-24 13:37 | 2026-09-24 13:37 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 2.4300 | 2.4200 | 2.5600 | 161.7150 | 24806.00 | 1728.00 | 20162.00 | 102 | 23 | 10640 | 6472 | 1.64400494437577 | 0.83812844169996 | 0.829327622830359 | false | false | false | true | ||||||||||||||||
| 6ae07b29-bdf6-4863-b8d1-a8b9bd259e7a | 2026-09-24 14:50 | 2026-09-24 14:50 | 2026-09-24 14:50 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 2.6200 | 2.5500 | 2.6300 | 161.0000 | 26681.00 | 26157.00 | 524.00 | 102 | 17 | 11521 | 6472 | 1.78012978986403 | 0.845412102460755 | 0.851333277271224 | false | false | false | true | ||||||||||||||||
| 76a1c9c0-eb04-4366-abf3-d7c7a67b8a11 | 2026-09-24 14:51 | 2026-09-24 14:51 | 2026-09-24 14:51 | MSTR | MSTR260925C00162500 | call | 162.5000 | 2026-09-25 | 2.6800 | 2.6300 | 2.6800 | 162.0000 | 26787.00 | 26787.00 | 0.00 | 100 | 28 | 11630 | 6472 | 1.79697156983931 | 0.841756578549127 | 0.838801728570903 | false | false | false | true |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| 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 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-23T18:27:32.623000Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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 |
| 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 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:05:25.664270Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:03:43.722265Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 59135768262.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:43:31.900788Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-24T18:51:39.883666Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-24T18:51:39.883666Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |