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_alerts566,287 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 |
|---|
| 4730d09d-965a-4963-9e5f-8b90fba53f71 | 2026-09-04 14:29 | 2026-09-04 14:29 | 2026-09-04 14:29 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 4.3500 | 4.2500 | 4.5000 | 1001.7800 | 109187.00 | 108750.00 | 437.00 | 251 | 5 | 114429 | 20793 | 5.50324628480739 | 0.647687201612141 | 0.643794838698209 | false | false | false | true | 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-04T18:34:11.376593Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f7649b14-45c9-4b8c-b146-3761d48719bc | 2026-09-04 13:25 | 2026-09-04 13:25 | 2026-09-04 13:25 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 4.8000 | 4.5500 | 4.8000 | 999.9900 | 174220.00 | 174220.00 | 0.00 | 363 | 28 | 101464 | 20793 | 4.87971913624778 | 0.702031071052477 | 0.702031071052477 | false | false | false | |||||||||||||||||
| 17da25b8-2a85-4ce9-a1e4-65bf68ba406e | 2026-09-04 12:59 | 2026-09-04 12:59 | 2026-09-04 12:59 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 9.4900 | 9.4500 | 9.7500 | 1007.2300 | 180249.00 | 0.00 | 180249.00 | 190 | 14 | 96081 | 20793 | 4.62083393449719 | 0.697675313062536 | 0.694528350343466 | true | false | false | |||||||||||||||||
| c30f9772-9342-488e-b575-8983e7997228 | 2026-09-04 12:32 | 2026-09-04 12:32 | 2026-09-04 12:32 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 10.0000 | 10.0000 | 10.1500 | 1006.7900 | 437003.00 | 0.00 | 437003.00 | 437 | 5 | 92882 | 20793 | 4.46698408118117 | 0.754667223599771 | 0.75327466392399 | false | false | false | |||||||||||||||||
| c5530d63-01eb-4059-8d6e-859cced2d620 | 2026-09-04 12:02 | 2026-09-04 12:02 | 2026-09-04 12:02 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 5.6000 | 5.5000 | 5.6500 | 999.5600 | 116995.00 | 72357.00 | 44638.00 | 209 | 17 | 83962 | 20793 | 4.03799355552349 | 0.683752645636908 | 0.684832302882979 | true | false | false | |||||||||||||||||
| c7d09bbc-91a0-4ad8-84b9-e563fb04a7e3 | 2026-09-04 09:33 | 2026-09-04 09:33 | 2026-09-04 09:33 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 4.3800 | 4.3500 | 4.6000 | 982.9820 | 176000.00 | 2268.00 | 173732.00 | 402 | 14 | 12166 | 20793 | 0.5851007550618 | 1.01389970955348 | 1.00544143450697 | false | false | false | |||||||||||||||||
| d4b6fc7d-6138-45b8-8950-67a5f9e99a63 | 2026-09-02 14:38 | 2026-09-02 14:37 | 2026-09-02 14:37 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 2.5000 | 2.5000 | 2.5500 | 948.6300 | 125421.00 | 0.00 | 125421.00 | 501 | 10 | 25304 | 8673 | 2.91756024443676 | 0.600424687616456 | 0.599724914611786 | false | false | false | |||||||||||||||||
| 1cf0d4e4-b039-40ec-bf61-bdb90cab1b7f | 2026-09-01 15:05 | 2026-09-01 15:05 | 2026-09-01 15:05 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 2.6600 | 2.5800 | 2.6700 | 931.9899 | 144643.00 | 89359.00 | 55284.00 | 544 | 42 | 26568 | 5381 | 4.93737223564393 | 0.613798476903391 | 0.613798476903391 | false | false | false | |||||||||||||||||
| 27eab484-2691-416e-9dda-f5861efac471 | 2026-09-01 14:24 | 2026-09-01 14:24 | 2026-09-01 14:24 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 2.4700 | 2.3600 | 2.4800 | 929.1500 | 127114.00 | 108365.00 | 3682.00 | 515 | 31 | 18186 | 5381 | 3.3796692064672 | 0.62157117306597 | 0.620891609554818 | true | false | false | |||||||||||||||||
| 7215d958-932a-43a7-890a-bc318c446421 | 2026-09-01 13:31 | 2026-09-01 13:31 | 2026-09-01 13:31 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 3.4200 | 3.2500 | 3.4500 | 941.2350 | 102551.00 | 102551.00 | 0.00 | 300 | 14 | 12384 | 5381 | 2.30143096078796 | 0.595567886078643 | 0.591708359210117 | false | false | false | |||||||||||||||||
| 08f4fbdc-ccbd-4d07-a8a1-6227152e2445 | 2026-09-01 13:31 | 2026-09-01 13:31 | 2026-09-01 13:31 | MU | MU260904C01000000 | call | 1000.0000 | 2026-09-04 | 3.4300 | 3.2000 | 3.4500 | 941.4100 | 102880.00 | 102880.00 | 0.00 | 300 | 11 | 12084 | 5381 | 2.24567924177662 | 0.592563923806012 | 0.59042860187439 | false | false | false |
| 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-04T17:34:11.817020Z"} |
| 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-04T17:07:55.847311Z"} |
| 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-04T16:50:32.806937Z"} |
| 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-04T16:13:56.145626Z"} |
| 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-04T13:37:16.307537Z"} |
| 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-02T18:39:55.300995Z"} |
| 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-01T19:21:20.162349Z"} |
| 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-01T18:40:09.958238Z"} |
| 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-01T17:48:11.364966Z"} |
| 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-01T17:48:11.364966Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |