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_alerts474,253 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 |
|---|
| 302ed14b-c083-455a-8aa1-c16f5ff53762 | 2026-08-18 10:35 | 2026-08-18 10:35 | 2026-08-18 10:35 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 2.9000 | 2.9000 | 3.2000 | 96.5400 | 12760.00 | 0.00 | 12760.00 | 44 | 5 | 1446 | 438 | 3.3013698630137 | 0.819650634382188 | 0.819650634382188 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 49926338507.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 16141b87-9b3a-4e8e-82ef-08c56c84c39b | 2026-08-20 09:35 | 2026-08-20 09:35 | 2026-08-20 09:35 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 6.2200 | 5.4000 | 6.3000 | 110.6620 | 14305.00 | 7440.00 | 6865.00 | 23 | 5 | 24 | 2239 | 0.0107190710138455 | 0.848394527595543 | 0.851142075479015 | false | false | false | true | ||||||||||||||||
| 6d1786b7-280a-46d4-96b5-072b4b6555a7 | 2026-08-20 11:04 | 2026-08-20 11:04 | 2026-08-20 11:04 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 6.5000 | 6.0000 | 6.5000 | 111.6200 | 12350.00 | 12350.00 | 0.00 | 19 | 5 | 76 | 2239 | 0.0339437248771773 | 0.852196651960469 | 0.850733400609199 | false | false | false | true | ||||||||||||||||
| 36461aea-7ee3-47f2-9cb2-1f8c953415b8 | 2026-08-25 12:53 | 2026-08-25 12:53 | 2026-08-25 12:53 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 10.2500 | 10.2000 | 10.7500 | 127.6900 | 10245.00 | 8200.00 | 2045.00 | 10 | 10 | 75 | 1478 | 0.050744248985115 | 0.810924411573148 | 0.808787377754872 | false | false | false | true | ||||||||||||||||
| 088f77cc-1536-43d7-b514-b00d08fa5be9 | 2026-08-27 13:19 | 2026-08-27 13:19 | 2026-08-27 13:19 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 14.4500 | 14.0500 | 14.4500 | 139.2900 | 10115.00 | 10115.00 | 0.00 | 7 | 5 | 157 | 1452 | 0.108126721763085 | 0.80210667157204 | 0.80210667157204 | false | false | false | true | ||||||||||||||||
| 1b06b9a6-7df6-4a85-b963-03695f9af937 | 2026-08-27 13:22 | 2026-08-27 13:22 | 2026-08-27 13:22 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 14.6300 | 14.2000 | 14.7000 | 139.6700 | 11705.00 | 5860.00 | 5845.00 | 8 | 6 | 236 | 1452 | 0.162534435261708 | 0.803604212312835 | 0.803269086813096 | true | false | false | true | ||||||||||||||||
| 925ff0e1-8a57-4387-91f2-3d1b89c864ff | 2026-09-03 09:33 | 2026-09-03 09:33 | 2026-09-03 09:33 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 9.0000 | 8.8500 | 9.3000 | 129.0400 | 17100.00 | 0.00 | 17100.00 | 19 | 5 | 19 | 1695 | 0.0112094395280236 | 0.780301411817096 | 0.780301411817096 | false | false | false | true | ||||||||||||||||
| 59d928c2-82a7-4373-84de-99565e1a499f | 2026-09-03 09:42 | 2026-09-03 09:42 | 2026-09-03 09:42 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 10.3000 | 10.3000 | 10.5500 | 132.0000 | 10300.00 | 0.00 | 10300.00 | 10 | 5 | 34 | 1695 | 0.0200589970501475 | 0.790641010569889 | 0.790641010569889 | true | false | false | true | ||||||||||||||||
| 122d4051-ec8a-46e7-9c94-8c757c49c69b | 2026-09-09 10:26 | 2026-09-09 10:26 | 2026-09-09 10:26 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 11.9000 | 11.5000 | 11.9500 | 137.0000 | 42830.00 | 11900.00 | 30930.00 | 36 | 11 | 64 | 2257 | 0.0283562250775366 | 0.806689306259986 | 0.806689306259986 | true | false | false | true | ||||||||||||||||
| 8fae3727-8e96-4626-a3ea-2f813011e6d1 | 2026-09-09 15:19 | 2026-09-09 15:19 | 2026-09-09 15:19 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 10.4300 | 10.1500 | 10.4500 | 133.8450 | 20865.00 | 20865.00 | 0.00 | 20 | 6 | 243 | 2257 | 0.107665042091272 | 0.798823898004111 | 0.795731644282763 | false | false | false | true | ||||||||||||||||
| 91a12d84-817a-4620-9333-e9fa0c8a8db0 | 2026-09-18 12:40 | 2026-09-18 12:40 | 2026-09-18 12:40 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 14.5500 | 14.4500 | 14.8000 | 149.6300 | 49470.00 | 1455.00 | 48015.00 | 34 | 10 | 373 | 2410 | 0.154771784232365 | 0.73792470965876 | 0.738802632320126 | true | false | false | true | ||||||||||||||||
| d6db9591-71df-4134-9495-702e57b0806b | 2026-09-18 13:58 | 2026-09-18 13:58 | 2026-09-18 13:58 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 15.6500 | 15.2500 | 15.7000 | 151.8800 | 128325.00 | 123630.00 | 4695.00 | 82 | 43 | 545 | 2410 | 0.226141078838174 | 0.738428375049562 | 0.738426287577212 | true | false | false | true | ||||||||||||||||
| 2b8ad44f-ae3d-4d5a-884e-9abff3969cb4 | 2026-09-18 14:07 | 2026-09-18 14:07 | 2026-09-18 14:07 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 15.3500 | 15.3000 | 15.6000 | 151.4500 | 46050.00 | 3070.00 | 42980.00 | 30 | 17 | 587 | 2410 | 0.24356846473029 | 0.735054950384917 | 0.735054950384917 | true | false | false | true | ||||||||||||||||
| 29dc01e8-f914-467e-b465-3b2c031ca683 | 2026-09-18 15:01 | 2026-09-18 15:00 | 2026-09-18 15:00 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 15.2500 | 15.2000 | 15.4500 | 151.6400 | 22875.00 | 3050.00 | 19825.00 | 15 | 8 | 633 | 2410 | 0.262655601659751 | 0.727301716725212 | 0.727301716725212 | false | false | false | true | ||||||||||||||||
| 4343c4ed-f8b0-4fc1-92d0-eb9f63b3477c | 2026-09-18 15:23 | 2026-09-18 15:23 | 2026-09-18 15:23 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 16.2500 | 16.2500 | 16.5500 | 153.5900 | 16250.00 | 0.00 | 16250.00 | 10 | 5 | 677 | 2410 | 0.280912863070539 | 0.727727971535832 | 0.727727971535832 | false | false | false | true | ||||||||||||||||
| 3013919b-fea7-475e-90ec-27ed2c51fd43 | 2026-09-21 13:03 | 2026-09-21 13:03 | 2026-09-21 13:03 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 24.1000 | 23.9500 | 24.1000 | 166.5300 | 19280.00 | 19280.00 | 0.00 | 8 | 5 | 514 | 2446 | 0.210139002452984 | 0.765666951895148 | 0.765666951895148 | false | false | false | true | ||||||||||||||||
| 2e7b4f9d-2fc9-42ac-af27-f5fefa37ba1b | 2026-09-22 10:13 | 2026-09-22 10:13 | 2026-09-22 10:13 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 26.5500 | 26.3000 | 26.6000 | 170.6450 | 58405.00 | 53100.00 | 5305.00 | 22 | 5 | 168 | 2349 | 0.0715197956577267 | 0.766084560714324 | 0.766084560714324 | true | false | false | true | ||||||||||||||||
| 13438ddc-9653-4a8a-9682-a4a3024c32e3 | 2026-09-23 10:22 | 2026-09-23 10:22 | 2026-09-23 10:22 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 20.7000 | 20.6500 | 21.0500 | 163.0999 | 10350.00 | 2070.00 | 8280.00 | 5 | 5 | 40 | 2346 | 0.0170502983802217 | 0.727270778179594 | 0.727270778179594 | false | false | false | true | ||||||||||||||||
| 45d8e7ec-548c-4100-80cf-7f10680066ad | 2026-09-25 10:06 | 2026-09-25 10:06 | 2026-09-25 10:06 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 17.0000 | 16.8500 | 17.0500 | 158.1860 | 171705.00 | 1705.00 | 170000.00 | 101 | 5 | 1410 | 2435 | 0.579055441478439 | 0.704097423432232 | 0.706134807260739 | false | false | false | true | ||||||||||||||||
| 212333c7-4523-42b4-8219-d8ad7cad87d4 | 2026-09-25 10:13 | 2026-09-25 10:13 | 2026-09-25 10:13 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 17.0500 | 16.9500 | 17.1500 | 158.3600 | 11935.00 | 10230.00 | 1705.00 | 7 | 7 | 1915 | 2435 | 0.786447638603696 | 0.702247328498243 | 0.702247328498243 | true | false | false | true | ||||||||||||||||
| d6da31f4-50d1-45ad-9572-6d8b7c7040d4 | 2026-09-25 11:36 | 2026-09-25 11:36 | 2026-09-25 11:36 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 16.7500 | 16.6000 | 16.8500 | 158.1200 | 266325.00 | 98825.00 | 167500.00 | 159 | 17 | 2115 | 2435 | 0.868583162217659 | 0.695381772699177 | 0.695381772699177 | true | false | false | true | ||||||||||||||||
| 72cb6c9e-0150-400c-86ea-a23bc99980de | 2026-09-25 15:18 | 2026-09-25 15:18 | 2026-09-25 15:18 | MSTR | MSTR261120C00160000 | call | 160.0000 | 2026-11-20 | 17.9300 | 17.9000 | 18.0000 | 159.9400 | 14340.00 | 3590.00 | 8955.00 | 8 | 5 | 2848 | 2435 | 1.16960985626283 | 0.70107742230879 | 0.703103596102015 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:16:49.821442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T16:59:46.608693Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T17:46:53.178792Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:35:49.066709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:45:03.310585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:40:24.011597Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 49926338507.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-18T16:45:45.480252Z"} |
| 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-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-18T18:22:45.408265Z"} |
| 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-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 |
| 61432656919.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:07:15.058898Z"} |
| 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-22T14:15:02.242582Z"} |
| 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 |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:22:47.791063Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-25T14:07:37.625722Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-25T14:14:35.986965Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 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-25T15:37:39.831939Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 57826906314.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:24:28.165724Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |