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 |
|---|
| c4ca1f83-dba9-4761-a42a-b645ae4db0ed | 2026-09-18 15:48 | 2026-09-18 15:48 | 2026-09-18 15:48 | MU | MU260918C01005000 | call | 1005.0000 | 2026-09-18 | 4.6500 | 4.6000 | 4.6500 | 1007.1899 | 191095.00 | 189255.00 | 1840.00 | 411 | 10 | 56743 | 5426 | 10.4576115001843 | 1.81895988385153 | 1.84665795249021 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1147237562786.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| e80b1898-fbd5-4306-8e6a-1e308f15fac7 | 2026-09-18 14:05 | 2026-09-18 14:05 | 2026-09-18 14:05 | MU | MU260918C01005000 | call | 1005.0000 | 2026-09-18 | 3.9600 | 3.8000 | 4.0500 | 1004.5500 | 136079.00 | 135295.00 | 389.00 | 344 | 26 | 32091 | 5426 | 5.91430151124217 | 0.703698998367777 | 0.693607596855783 | true | false | false | true | ||||||||||||||||
| 5a0521e0-6671-498c-b85a-c0083c6c83ef | 2026-09-18 09:43 | 2026-09-18 09:43 | 2026-09-18 09:43 | MU | MU260918C01005000 | call | 1005.0000 | 2026-09-18 | 3.6000 | 3.4000 | 3.6000 | 993.2950 | 144350.00 | 144000.00 | 350.00 | 401 | 7 | 1974 | 5426 | 0.363803907113896 | 0.750302362695639 | 0.763426588370474 | false | false | false | true | ||||||||||||||||
| 6ebc1069-af21-4138-8e6e-6c130cb4d4d2 | 2026-09-10 15:54 | 2026-09-10 15:54 | 2026-09-10 15:54 | MU | MU260918C01005000 | call | 1005.0000 | 2026-09-18 | 23.0500 | 22.8000 | 23.0500 | 981.8833 | 110640.00 | 110640.00 | 0.00 | 48 | 12 | 546 | 484 | 1.12809917355372 | 0.562713008599335 | 0.562834174431557 | true | false | false | true | ||||||||||||||||
| 3bb7eb9a-77d7-493d-83da-cd570141c3e1 | 2026-09-10 09:36 | 2026-09-10 09:36 | 2026-09-10 09:36 | MU | MU260918C01005000 | call | 1005.0000 | 2026-09-18 | 28.6000 | 28.3000 | 28.7000 | 989.5600 | 171570.00 | 171570.00 | 0.00 | 60 | 10 | 120 | 484 | 0.247933884297521 | 0.602386540312307 | 0.603575557335789 | true | false | false | true | ||||||||||||||||
| 2274ed8e-fe14-4441-8d54-92ffa5a7752d | 2026-09-09 10:21 | 2026-09-09 10:21 | 2026-09-09 10:21 | MU | MU260918C01005000 | call | 1005.0000 | 2026-09-18 | 57.0600 | 56.9000 | 57.4500 | 1034.7200 | 176875.00 | 85595.00 | 91280.00 | 31 | 13 | 680 | 480 | 1.41666666666667 | 0.624482262315372 | 0.624482262315372 | true | false | false | true | ||||||||||||||||
| 2a4cfa47-e1e0-4e5b-9d58-9826633007d2 | 2026-09-09 09:53 | 2026-09-09 09:53 | 2026-09-09 09:53 | MU | MU260918C01005000 | call | 1005.0000 | 2026-09-18 | 49.7600 | 49.7000 | 50.1000 | 1023.0600 | 129374.00 | 9975.00 | 119399.00 | 26 | 12 | 588 | 480 | 1.225 | 0.622803396461102 | 0.622000317234602 | true | false | false | true | ||||||||||||||||
| dcfc507d-37e7-4c8c-a918-c023ee141b4e | 2026-09-09 09:47 | 2026-09-09 09:46 | 2026-09-09 09:46 | MU | MU260918C01005000 | call | 1005.0000 | 2026-09-18 | 43.9200 | 43.8000 | 44.3000 | 1014.2500 | 144930.00 | 8820.00 | 136110.00 | 33 | 13 | 538 | 480 | 1.12083333333333 | 0.616368221452543 | 0.615488946831964 | false | false | false | true | ||||||||||||||||
| e10f1d8a-daa7-4df0-808d-4f74ec91be49 | 2026-09-09 09:46 | 2026-09-09 09:46 | 2026-09-09 09:46 | MU | MU260918C01005000 | call | 1005.0000 | 2026-09-18 | 42.6000 | 42.1500 | 42.6000 | 1011.2600 | 213000.00 | 213000.00 | 0.00 | 50 | 7 | 505 | 480 | 1.05208333333333 | 0.616419160975028 | 0.616419160975028 | true | false | false | true | ||||||||||||||||
| f5319dcf-ef30-4474-a488-e3374c39868d | 2026-09-09 09:35 | 2026-09-09 09:35 | 2026-09-09 09:35 | MU | MU260918C01005000 | call | 1005.0000 | 2026-09-18 | 35.7300 | 34.7000 | 36.0500 | 997.4950 | 289385.00 | 143015.00 | 146370.00 | 81 | 6 | 356 | 480 | 0.741666666666667 | 0.620624413677831 | 0.620663834664934 | true | false | false | true | ||||||||||||||||
| d37c83de-61b7-4a00-b1b0-9e97e4a7741a | 2026-09-09 09:35 | 2026-09-09 09:35 | 2026-09-09 09:35 | MU | MU260918C01005000 | call | 1005.0000 | 2026-09-18 | 35.4700 | 35.1000 | 35.5500 | 996.5357 | 106415.00 | 99325.00 | 7090.00 | 30 | 6 | 274 | 480 | 0.570833333333333 | 0.624199522867637 | 0.625000755773758 | true | false | false | true | ||||||||||||||||
| 6d5460ed-1ce7-432c-a0e2-eca50b1daad8 | 2026-09-09 09:35 | 2026-09-09 09:35 | 2026-09-09 09:35 | MU | MU260918C01005000 | call | 1005.0000 | 2026-09-18 | 35.3900 | 35.1000 | 36.0000 | 996.3700 | 283085.00 | 187640.00 | 95445.00 | 80 | 9 | 244 | 480 | 0.508333333333333 | 0.625497127905001 | 0.626298526635958 | true | false | false | true | ||||||||||||||||
| 0bb19f72-4615-4284-b78e-1f94985b82fc | 2026-09-09 09:33 | 2026-09-09 09:33 | 2026-09-09 09:33 | MU | MU260918C01005000 | call | 1005.0000 | 2026-09-18 | 37.7800 | 37.7500 | 37.9500 | 1000.9750 | 188925.00 | 0.00 | 188925.00 | 50 | 8 | 91 | 480 | 0.189583333333333 | 0.625624650311678 | 0.626422150440289 | false | false | false | true | ||||||||||||||||
| 62f4da94-bae7-4899-a096-24425ceddece | 2026-09-08 09:34 | 2026-09-08 09:34 | 2026-09-08 09:34 | MU | MU260918C01005000 | call | 1005.0000 | 2026-09-18 | 51.1000 | 50.3500 | 51.7500 | 1018.3769 | 194180.00 | 97470.00 | 96710.00 | 38 | 12 | 54 | 413 | 0.130750605326877 | 0.648937889685765 | 0.654990030632815 | true | false | false | true | ||||||||||||||||
| db39e029-4480-4f8b-b050-d6f56884466b | 2026-08-27 15:56 | 2026-08-27 15:56 | 2026-08-27 15:56 | MU | MU260918C01005000 | call | 1005.0000 | 2026-09-18 | 28.0500 | 27.6000 | 28.0500 | 934.2124 | 457215.00 | 345015.00 | 0.00 | 163 | 5 | 282 | 25 | 11.28 | 0.588300958040782 | 0.588300958040782 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1147237562786.00 |
| 2026-09-30 |
| postmarket |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1147237562786.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:50:28.178058Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:30:31.573730Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:42:34.192825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:24:00.331334Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:57:31.693440Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:57:31.693440Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:57:31.693440Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:36:21.128731Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:36:21.128731Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:36:21.128731Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:36:21.128731Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:39:51.680537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:32:48.312014Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |