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 | strike |
|---|
| expirydate |
|---|
| 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 |
|---|
| bf0cbdd1-4e83-4024-ad16-c5b7b448dfd4 | 2026-09-25 10:42 | 2026-09-25 10:42 | 2026-09-25 10:42 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 27.3200 | 27.3000 | 27.5500 | 1080.5100 | 218565.00 | 32820.00 | 180275.00 | 80 | 17 | 748 | 9379 | 0.0797526388740804 | 0.652918184931131 | 0.652347011157699 | true | false | false | true | false | 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-25T14:43:48.295772Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 186ac60a-7f6c-4110-b0dc-36b7f4abfc32 | 2026-09-22 15:56 | 2026-09-22 15:56 | 2026-09-22 15:56 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 38.7400 | 38.5000 | 38.7500 | 1094.7150 | 27119.00 | 27119.00 | 0.00 | 7 | 6 | 2819 | 9742 | 0.289365633340177 | 0.680608968878723 | 0.680315874109607 | false | false | false | |||||||||||||||||
| 3c6473b1-bdc3-47db-a174-6b94a6d899b1 | 2026-09-22 13:52 | 2026-09-22 13:52 | 2026-09-22 13:52 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 34.9700 | 34.7500 | 35.1000 | 1085.3900 | 59445.00 | 45490.00 | 13955.00 | 17 | 13 | 2373 | 9742 | 0.243584479572983 | 0.673804364048667 | 0.672522494179958 | false | false | false | |||||||||||||||||
| ee184922-6335-4c0e-9fc9-e7d9b78608e0 | 2026-09-22 09:51 | 2026-09-22 09:51 | 2026-09-22 09:51 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 29.6400 | 29.3000 | 29.6500 | 1068.1050 | 50390.00 | 47430.00 | 2960.00 | 17 | 7 | 640 | 9742 | 0.0656949291726545 | 0.671658107359532 | 0.671658107359532 | true | false | false | |||||||||||||||||
| aea41bad-902f-415e-820c-de8ab1fea732 | 2026-09-21 15:01 | 2026-09-21 15:01 | 2026-09-21 15:01 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 25.3000 | 25.0500 | 25.3500 | 1045.0000 | 126525.00 | 126525.00 | 0.00 | 50 | 35 | 4568 | 7343 | 0.622089064415089 | 0.66588346092282 | 0.665025425541745 | false | false | false | |||||||||||||||||
| 7711420e-9b64-4d21-a499-83c653dd0bcc | 2026-09-21 14:16 | 2026-09-21 14:16 | 2026-09-21 14:16 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 23.6200 | 23.5000 | 23.7000 | 1044.6100 | 87395.00 | 14185.00 | 28320.00 | 37 | 35 | 4173 | 7343 | 0.568296336647147 | 0.659895084660821 | 0.658297029668184 | false | false | false | |||||||||||||||||
| 81b91c76-cfd2-42ae-ba87-895ba548ef59 | 2026-09-21 14:16 | 2026-09-21 14:16 | 2026-09-21 14:16 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 23.5800 | 23.4000 | 23.7500 | 1044.7000 | 124995.00 | 2355.00 | 21200.00 | 53 | 37 | 4136 | 7343 | 0.563257524172681 | 0.65862905675399 | 0.657455388521315 | false | false | false | |||||||||||||||||
| 6ac75637-2820-4706-a2a0-5a2e4a4160ef | 2026-09-21 11:30 | 2026-09-21 11:30 | 2026-09-21 11:30 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 23.5300 | 23.3500 | 23.6500 | 1044.8700 | 68230.00 | 2355.00 | 51745.00 | 29 | 29 | 3191 | 7343 | 0.434563529892415 | 0.656571331669324 | 0.656974605505701 | false | false | false | |||||||||||||||||
| 1770e3b8-59be-4fbb-a4a5-6039cd227b2b | 2026-09-21 11:30 | 2026-09-21 11:29 | 2026-09-21 11:29 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 23.4300 | 23.2000 | 23.6000 | 1044.7550 | 70285.00 | 4685.00 | 37460.00 | 30 | 30 | 3146 | 7343 | 0.428435244450497 | 0.656712595615215 | 0.656125024995979 | false | false | false | |||||||||||||||||
| 51a0e334-eda1-488c-bc23-a6ca9922cb35 | 2026-09-21 10:31 | 2026-09-21 10:31 | 2026-09-21 10:31 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 21.0600 | 21.0500 | 21.2500 | 1036.4500 | 25270.00 | 0.00 | 25270.00 | 12 | 12 | 2514 | 7343 | 0.342366880021789 | 0.652821265489674 | 0.651049201949142 | true | false | false | |||||||||||||||||
| d908131d-7de2-4a74-bc8e-db96541dd816 | 2026-09-21 10:31 | 2026-09-21 10:31 | 2026-09-21 10:31 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 21.1800 | 21.1000 | 21.4500 | 1036.4700 | 99560.00 | 0.00 | 50815.00 | 47 | 35 | 2480 | 7343 | 0.337736619910118 | 0.653455327859474 | 0.652225476061835 | false | false | false | |||||||||||||||||
| adb6c84b-2f74-415e-871f-43b0c5da8226 | 2026-09-21 10:31 | 2026-09-21 10:31 | 2026-09-21 10:31 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 21.1000 | 20.9000 | 21.3500 | 1036.0650 | 46425.00 | 2115.00 | 33760.00 | 22 | 18 | 2502 | 7343 | 0.340732670570611 | 0.653330755826933 | 0.652728469473252 | false | false | false | |||||||||||||||||
| 74aec2f0-dc3d-4245-b6e5-e07fbf27c67e | 2026-09-21 10:31 | 2026-09-21 10:31 | 2026-09-21 10:31 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 21.2800 | 21.1000 | 21.5000 | 1036.5400 | 63835.00 | 4260.00 | 36145.00 | 30 | 30 | 2433 | 7343 | 0.331335966226338 | 0.653875928815031 | 0.653261707503135 | false | false | false | |||||||||||||||||
| 893d004b-fd20-469f-98e6-d9702b031b63 | 2026-09-21 10:30 | 2026-09-21 10:30 | 2026-09-21 10:30 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 21.6300 | 20.9000 | 21.7500 | 1037.9100 | 30275.00 | 25965.00 | 4310.00 | 14 | 10 | 2387 | 7343 | 0.325071496663489 | 0.654359623636118 | 0.653140126241576 | false | false | false | |||||||||||||||||
| 00f1a874-6558-4abe-9b13-5a84b0295250 | 2026-09-14 10:27 | 2026-09-14 10:27 | 2026-09-14 10:27 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 8.5500 | 8.2000 | 8.6000 | 916.5500 | 330040.00 | 330040.00 | 0.00 | 386 | 10 | 936 | 6791 | 0.137829480194375 | 0.668756240545713 | 0.667151122861395 | false | false | false | |||||||||||||||||
| 1b6de3db-46aa-46ed-bfd5-3e15c2925aa3 | 2026-09-08 10:17 | 2026-09-08 10:17 | 2026-09-08 10:17 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 36.3100 | 36.2500 | 36.5000 | 1019.4200 | 602665.00 | 0.00 | 246680.00 | 166 | 52 | 697 | 6119 | 0.11390750122569 | 0.709978204320086 | 0.709076462517788 | false | false | false | |||||||||||||||||
| 7a29b48d-bb0c-4231-8b51-5098dd5957bb | 2026-09-08 10:17 | 2026-09-08 10:17 | 2026-09-08 10:17 | MU | MU261016C01200000 | call | 1200.0000 | 2026-10-16 | 36.1900 | 36.1500 | 36.5500 | 1019.0200 | 206300.00 | 0.00 | 28940.00 | 57 | 26 | 508 | 6119 | 0.0830201013237457 | 0.709637965411376 | 0.709186433498859 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1237995596400.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:54:09.846029Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1237995596400.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:52:22.219586Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:20:26.028708Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:20:26.028708Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:32:21.239106Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:32:21.239106Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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-14T14:43:33.165845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-08T14:28:51.897139Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-08T14:28:51.897139Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |