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_alerts609,118 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 |
|---|
| 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 |
|---|
| 53c19316-efd4-4024-bb15-5c0331fb4d3e | 2026-09-30 15:55 | 2026-09-30 15:55 | 2026-09-30 15:55 | MU | MU261002C01070000 | call | 1070.0000 | 2026-10-02 | 35.8400 | 35.0000 | 37.7500 | 1065.3100 | 28670.00 | 7105.00 | 21565.00 | 8 | 8 | 17866 | 2154 | 8.29433611884865 | 1.22929972755073 | 1.19417664184281 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 1202894057267.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T19:56:14.102421Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| 59e1fd63-8500-4f30-bdab-34eb95c90a15 | 2026-09-30 15:39 | 2026-09-30 15:39 | 2026-09-30 15:39 | MU | MU261002C01070000 | call | 1070.0000 | 2026-10-02 | 38.5900 | 38.4500 | 38.7500 | 1068.1750 | 38585.00 | 7720.00 | 23145.00 | 10 | 6 | 16623 | 2154 | 7.71727019498607 | 1.24820394828476 | 1.24503237387398 | true | false | false | |||||||||||||||||
| ac7894a7-5ee0-4bd6-93ec-573e4706905e | 2026-09-30 10:01 | 2026-09-30 10:01 | 2026-09-30 10:01 | MU | MU261002C01070000 | call | 1070.0000 | 2026-10-02 | 38.4700 | 38.4000 | 38.7000 | 1067.0450 | 19235.00 | 0.00 | 11530.00 | 5 | 5 | 1171 | 2154 | 0.54363974001857 | 1.26489946101855 | 1.26331240578997 | true | false | false | |||||||||||||||||
| 9c72fcf4-277e-44a5-a299-cc0a47c66907 | 2026-09-30 09:33 | 2026-09-30 09:33 | 2026-09-30 09:33 | MU | MU261002C01070000 | call | 1070.0000 | 2026-10-02 | 40.2300 | 40.0000 | 40.6500 | 1071.7250 | 24135.00 | 12075.00 | 12060.00 | 6 | 6 | 132 | 2154 | 0.0612813370473538 | 1.23916615058108 | 1.23892390508503 | true | false | false | |||||||||||||||||
| 833aaa20-4f3c-46b9-9951-04023bafe2e8 | 2026-09-29 14:58 | 2026-09-29 14:58 | 2026-09-29 14:58 | MU | MU261002C01070000 | call | 1070.0000 | 2026-10-02 | 41.9900 | 41.8000 | 42.0500 | 1071.9900 | 314932.00 | 314932.00 | 0.00 | 75 | 12 | 6218 | 1065 | 5.83849765258216 | 1.0542976362851 | 1.0542976362851 | false | false | false | |||||||||||||||||
| 3ae6ded6-fb0f-4818-8cb0-ac099ec3f56b | 2026-09-29 14:18 | 2026-09-29 14:18 | 2026-09-29 14:18 | MU | MU261002C01070000 | call | 1070.0000 | 2026-10-02 | 42.9300 | 42.6500 | 42.9500 | 1070.0000 | 42925.00 | 30055.00 | 12870.00 | 10 | 5 | 5597 | 1065 | 5.25539906103286 | 1.06803889549343 | 1.06803889549343 | false | false | false | |||||||||||||||||
| 8eb3bc3e-c0f9-467a-9efd-00ce2c0a09a7 | 2026-09-29 14:06 | 2026-09-29 14:06 | 2026-09-29 14:06 | MU | MU261002C01070000 | call | 1070.0000 | 2026-10-02 | 41.3400 | 41.1000 | 41.3500 | 1069.8639 | 41340.00 | 37210.00 | 4130.00 | 10 | 7 | 5287 | 1065 | 4.96431924882629 | 1.06630877041527 | 1.06501496375848 | false | false | false | |||||||||||||||||
| 9c8df554-4c53-4d4d-b5f0-cebf5fc52c63 | 2026-09-29 11:52 | 2026-09-29 11:52 | 2026-09-29 11:52 | MU | MU261002C01070000 | call | 1070.0000 | 2026-10-02 | 39.0300 | 38.7500 | 39.1000 | 1064.6900 | 19515.00 | 11715.00 | 7800.00 | 5 | 5 | 2752 | 1065 | 2.58403755868545 | 1.07512180917868 | 1.07382336643197 | true | false | false | |||||||||||||||||
| f34f3067-c25c-45dc-8dd6-292039418529 | 2026-09-29 10:19 | 2026-09-29 10:19 | 2026-09-29 10:19 | MU | MU261002C01070000 | call | 1070.0000 | 2026-10-02 | 45.9300 | 45.8000 | 46.3500 | 1079.5150 | 45930.00 | 4590.00 | 41340.00 | 10 | 6 | 1856 | 1065 | 1.74272300469484 | 1.05212254349571 | 1.04953461124087 | false | false | false | |||||||||||||||||
| eeb7d973-ac87-4868-8005-1654ee4d2861 | 2026-09-29 09:55 | 2026-09-29 09:55 | 2026-09-29 09:55 | MU | MU261002C01070000 | call | 1070.0000 | 2026-10-02 | 43.0700 | 42.9500 | 43.3500 | 1074.0100 | 43069.00 | 0.00 | 43069.00 | 10 | 5 | 1126 | 1065 | 1.05727699530516 | 1.05443086676165 | 1.05443086676165 | false | false | false | |||||||||||||||||
| 921f2c95-9ec8-40d6-bd93-8c343b92dbe3 | 2026-09-29 09:47 | 2026-09-29 09:47 | 2026-09-29 09:47 | MU | MU261002C01070000 | call | 1070.0000 | 2026-10-02 | 38.9600 | 38.6000 | 39.0000 | 1065.9500 | 23375.00 | 15590.00 | 7785.00 | 6 | 6 | 590 | 1065 | 0.553990610328638 | 1.06085441387985 | 1.05738900226038 | false | false | false | |||||||||||||||||
| b2966a11-77ea-48c0-a114-562e85ca96a0 | 2026-09-28 13:11 | 2026-09-28 13:10 | 2026-09-28 13:10 | MU | MU261002C01070000 | call | 1070.0000 | 2026-10-02 | 35.1000 | 35.1000 | 35.2500 | 1052.5571 | 172010.00 | 14060.00 | 157950.00 | 49 | 19 | 1422 | 581 | 2.44750430292599 | 0.972094184494835 | 0.972028179140894 | true | false | false | |||||||||||||||||
| bf6a5d35-2ff0-406f-88c3-eeed34c33167 | 2026-09-25 15:30 | 2026-09-25 15:30 | 2026-09-25 15:30 | MU | MU261002C01070000 | call | 1070.0000 | 2026-10-02 | 53.3900 | 52.9000 | 53.5000 | 1084.0338 | 149496.00 | 149496.00 | 0.00 | 28 | 5 | 933 | 619 | 1.50726978998384 | 0.768500268912994 | 0.765274203897518 | false | false | false | |||||||||||||||||
| 8a367833-a221-4ac5-ac7b-b34ecf50d031 | 2026-09-24 12:58 | 2026-09-24 12:58 | 2026-09-24 12:58 | MU | MU261002C01070000 | call | 1070.0000 | 2026-10-02 | 51.5600 | 50.9500 | 52.3500 | 1065.0000 | 97973.00 | 0.00 | 87643.00 | 19 | 8 | 633 | 587 | 1.07836456558773 | 0.792817798662997 | 0.792817798662997 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:42:03.921497Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:01:58.194953Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:34:41.867394Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:01:46.856083Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:21:06.128896Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:07:24.158187Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:55:27.801272Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:20:45.817132Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:56:35.860979Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:48:49.550855Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1190357793291.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:11:31.612097Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-25T19:35:55.847824Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-24T16:59:44.374364Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |