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 | expirydate |
|---|
| 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 |
|---|
| 4e5e332c-5b7a-47de-996a-72ba7be6e564 | 2026-08-18 11:23 | 2026-08-18 11:23 | 2026-08-18 11:23 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 82.0000 | 81.5000 | 82.0000 | 939.7000 | 754400.00 | 754400.00 | 0.00 | 92 | 17 | 542 | 2958 | 0.183231913455037 | 0.703760714349475 | 0.703000564958608 | false | false | false | true | false | 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-18T15:49:10.773359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 380e9d43-b33c-4219-a028-ebdcd61bcd3d | 2026-09-04 10:00 | 2026-09-04 10:00 | 2026-09-04 10:00 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 39.8400 | 38.9000 | 39.8500 | 999.3650 | 143438.00 | 143438.00 | 0.00 | 36 | 7 | 121 | 4832 | 0.0250413907284768 | 0.635849075846005 | 0.6356704847474 | false | false | false | true | ||||||||||||||||
| 9c31627f-e0ae-4842-a929-84a5685cf39b | 2026-09-09 10:13 | 2026-09-09 10:13 | 2026-09-09 10:13 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 30.6500 | 30.2500 | 31.0500 | 1039.1900 | 165510.00 | 119535.00 | 6130.00 | 54 | 10 | 222 | 5202 | 0.0426758938869665 | 0.679788982068914 | 0.679493210229157 | false | false | false | true | ||||||||||||||||
| f208fa6b-852c-4624-9926-0255c02f8aa5 | 2026-09-11 13:06 | 2026-09-11 13:06 | 2026-09-11 13:06 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 36.5500 | 36.5500 | 37.1000 | 977.9150 | 127925.00 | 0.00 | 127925.00 | 35 | 5 | 844 | 5787 | 0.145844133402454 | 0.604298473067623 | 0.604298473067623 | true | false | false | true | ||||||||||||||||
| afc89319-3aad-4311-8624-7d0f8052a9a7 | 2026-09-16 09:30 | 2026-09-16 09:30 | 2026-09-16 09:30 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 45.3100 | 45.2000 | 46.1000 | 930.9400 | 299075.00 | 77145.00 | 212875.00 | 66 | 39 | 71 | 6380 | 0.011128526645768 | 0.584015740864147 | 0.580652357057957 | true | false | false | true | ||||||||||||||||
| 881998fb-cdec-41ad-899d-feca2f852b52 | 2026-09-21 11:59 | 2026-09-21 11:59 | 2026-09-21 11:59 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 16.6000 | 16.5500 | 16.7500 | 1035.6800 | 13280.00 | 1660.00 | 11620.00 | 8 | 5 | 1082 | 6688 | 0.161782296650718 | 0.625858980153151 | 0.625858980153151 | false | false | false | true | ||||||||||||||||
| 9adc534e-e5b0-4a67-bad4-32965b4ffb3c | 2026-09-21 15:02 | 2026-09-21 15:02 | 2026-09-21 15:02 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 15.2000 | 15.0000 | 15.2000 | 1045.0000 | 24312.00 | 24312.00 | 0.00 | 16 | 5 | 1659 | 6688 | 0.248056220095694 | 0.639514936843267 | 0.639514936843267 | false | false | false | true | ||||||||||||||||
| c5abce7b-658f-4c1f-b6bc-fb70ccca4654 | 2026-09-21 15:03 | 2026-09-21 15:03 | 2026-09-21 15:03 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 15.1500 | 15.0000 | 15.1500 | 1045.0000 | 121200.00 | 121200.00 | 0.00 | 80 | 5 | 1739 | 6688 | 0.260017942583732 | 0.63756642416668 | 0.63756642416668 | true | false | false | true | ||||||||||||||||
| 64c6dcb6-09cb-4648-a681-bd7af1cb12f2 | 2026-09-21 15:43 | 2026-09-21 15:43 | 2026-09-21 15:43 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 14.8100 | 14.7500 | 15.1500 | 1049.1750 | 22209.00 | 0.00 | 22209.00 | 15 | 7 | 2051 | 6688 | 0.306668660287081 | 0.631403960845993 | 0.631403960845993 | false | false | false | true | ||||||||||||||||
| ad7935cc-2dce-49cb-91e3-602c9a8b6e8b | 2026-09-22 10:33 | 2026-09-22 10:33 | 2026-09-22 10:33 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 11.0500 | 11.0500 | 11.2000 | 1081.6950 | 16575.00 | 0.00 | 16575.00 | 15 | 8 | 252 | 6161 | 0.0409024509008278 | 0.654069783225785 | 0.654069783225785 | false | false | false | true | ||||||||||||||||
| a81f2e4a-feec-4845-8a42-fa7068c64e49 | 2026-09-22 12:01 | 2026-09-22 12:01 | 2026-09-22 12:01 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 10.9000 | 10.8500 | 11.0500 | 1077.3911 | 54500.00 | 0.00 | 44690.00 | 50 | 11 | 2111 | 6161 | 0.342639181950982 | 0.642058345560437 | 0.642058345560437 | true | false | false | true | ||||||||||||||||
| 3be8aca5-fb29-4fea-82cc-f5b7a4318495 | 2026-09-22 12:01 | 2026-09-22 12:01 | 2026-09-22 12:01 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 10.9000 | 10.9000 | 11.0500 | 1077.3050 | 38150.00 | 0.00 | 38150.00 | 35 | 16 | 2061 | 6161 | 0.334523616296056 | 0.641872824737838 | 0.641872824737838 | true | false | false | true | ||||||||||||||||
| 75f02259-e1a0-4c58-a27a-14cc8c675912 | 2026-09-22 13:27 | 2026-09-22 13:27 | 2026-09-22 13:27 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 10.8500 | 10.8500 | 10.9500 | 1082.3950 | 40157.00 | 0.00 | 40157.00 | 37 | 17 | 2304 | 6161 | 0.373965265378997 | 0.65185549597268 | 0.65185549597268 | true | false | false | true | ||||||||||||||||
| 2bd46d01-d577-445f-8be8-8a8c809e565d | 2026-09-23 10:21 | 2026-09-23 10:21 | 2026-09-23 10:21 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 11.2000 | 11.0000 | 11.4000 | 1073.9700 | 11200.00 | 0.00 | 8960.00 | 10 | 8 | 198 | 5547 | 0.0356949702541915 | 0.653635300827921 | 0.653635300827921 | false | false | false | true | ||||||||||||||||
| bb96cf8f-2a65-46a4-858a-8741b8b5e141 | 2026-09-23 10:58 | 2026-09-23 10:58 | 2026-09-23 10:58 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 10.6400 | 10.4000 | 10.6500 | 1075.0000 | 19155.00 | 19155.00 | 0.00 | 18 | 6 | 383 | 5547 | 0.0690463313502794 | 0.655098247082028 | 0.655098247082028 | false | false | false | true | ||||||||||||||||
| 59f59a42-4bbd-4470-95de-f0ae71519461 | 2026-09-23 12:04 | 2026-09-23 12:04 | 2026-09-23 12:04 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 10.7500 | 10.7500 | 10.8000 | 1075.6900 | 24725.00 | 0.00 | 19350.00 | 23 | 6 | 503 | 5547 | 0.09067964665585 | 0.649029955919876 | 0.649029955919876 | false | false | false | true | ||||||||||||||||
| 380a493b-57fe-410e-aef2-5068d4f99ec9 | 2026-09-23 13:28 | 2026-09-23 13:28 | 2026-09-23 13:28 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 11.7500 | 11.7500 | 12.0000 | 1065.0000 | 17628.00 | 0.00 | 17628.00 | 15 | 10 | 602 | 5547 | 0.108527131782946 | 0.651760281683996 | 0.651760281683996 | false | false | false | true | ||||||||||||||||
| 0d683ce1-8cb8-45b8-956f-37a917fda09b | 2026-09-25 11:07 | 2026-09-25 11:07 | 2026-09-25 11:07 | MU | MU261016P00900000 | put | 900.0000 | 2026-10-16 | 8.3000 | 8.1500 | 8.5500 | 1085.9599 | 20752.00 | 0.00 | 20752.00 | 25 | 5 | 226 | 5676 | 0.0398167723749119 | 0.650653029906232 | 0.650653029906232 | false | false | false | true |
| 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-04T14:09:16.630592Z"} |
| 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-09T14:24:00.331334Z"} |
| 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-11T17:27:08.545704Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1046439224059.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:33:11.249350Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:00:04.115943Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:06:05.917319Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:06:05.917319Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:46:53.809312Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1237995596400.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:34:01.762519Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1237995596400.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:07:35.242191Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1237995596400.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:07:35.242191Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1237995596400.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:30:55.056187Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1210573930694.00 |
| 2026-09-30 |
| postmarket |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1210573930694.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:00:57.901243Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1210573930694.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:06:31.927382Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1210573930694.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:31:46.460740Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:08:32.454345Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |