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_alerts658,639 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 |
|---|
| 1959511c-5893-476c-bf85-72fcc5243e5f | 2026-10-01 10:30 | 2026-10-01 10:30 | 2026-10-01 10:30 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 25.9400 | 25.9000 | 27.1000 | 1034.8600 | 77811.00 | 0.00 | 77811.00 | 30 | 6 | 1524 | 8062 | 0.189034978913421 | 0.50730501283419 | 0.50730501283419 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 1239384749976.00 | 2026-12-16 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-10-01T14:33:19.556143Z"} | 2026-10-01 | 2026-10-01 21:15 | 2026-10-01 21:15 |
| b16bae4d-0698-48b2-ac44-a9ce44b4c712 | 2026-10-01 09:57 | 2026-10-01 09:57 | 2026-10-01 09:57 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 22.2300 | 22.0000 | 22.6500 | 1049.0050 | 24455.00 | 13350.00 | 8885.00 | 11 | 10 | 761 | 8062 | 0.0943934507566361 | 0.518585598831908 | 0.517909634970315 | false | false | false | |||||||||||||||||
| 91545759-21ef-4132-9893-110039a8dd90 | 2026-10-01 09:45 | 2026-10-01 09:45 | 2026-10-01 09:45 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 22.7600 | 22.1000 | 23.0500 | 1051.4646 | 11380.00 | 6835.00 | 4545.00 | 5 | 5 | 527 | 8062 | 0.065368394939221 | 0.535976199336737 | 0.535298951198902 | true | false | false | |||||||||||||||||
| 6c18ff2f-3683-4ac4-871f-1d82a3fce2fb | 2026-09-30 15:58 | 2026-09-30 15:58 | 2026-09-30 15:58 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 27.8500 | 27.6000 | 27.9000 | 1064.2200 | 13925.00 | 8360.00 | 5565.00 | 5 | 5 | 2364 | 7054 | 0.33512900481996 | 0.635466414250581 | 0.634812842048919 | false | false | false | |||||||||||||||||
| 99ed6896-dcd8-49cf-b133-1a9c71a80b26 | 2026-09-30 15:58 | 2026-09-30 15:57 | 2026-09-30 15:57 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 27.3400 | 27.1000 | 27.4000 | 1065.6150 | 57404.00 | 43769.00 | 13635.00 | 21 | 7 | 2341 | 7054 | 0.331868443436348 | 0.633824574824739 | 0.632905170861174 | false | false | false | |||||||||||||||||
| db1f6c23-2cfc-49d3-b426-4be1cb46ccdc | 2026-09-30 15:52 | 2026-09-30 15:51 | 2026-09-30 15:51 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 27.3700 | 27.3250 | 27.6500 | 1060.0000 | 13685.00 | 0.00 | 13685.00 | 5 | 5 | 2077 | 7054 | 0.294442869294018 | 0.635750474567653 | 0.634564305642562 | true | false | false | |||||||||||||||||
| 09abd7c4-6c3c-4b39-a43a-99713c2ef2af | 2026-09-30 09:31 | 2026-09-30 09:31 | 2026-09-30 09:31 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 24.1700 | 24.1000 | 24.7000 | 1080.8300 | 58020.00 | 7265.00 | 50755.00 | 24 | 13 | 33 | 7054 | 0.00467819676779132 | 0.647373853079266 | 0.646124521916893 | true | false | false | |||||||||||||||||
| 85edf653-fb60-4201-9d18-64941ac31fdf | 2026-09-29 10:22 | 2026-09-29 10:22 | 2026-09-29 10:22 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 24.6100 | 24.3000 | 24.7000 | 1079.6311 | 49215.00 | 46755.00 | 2460.00 | 20 | 6 | 245 | 7070 | 0.0346534653465347 | 0.629815799985203 | 0.629153184489619 | false | false | false | |||||||||||||||||
| 1d762781-dcae-4838-839f-0b423b742900 | 2026-09-28 11:37 | 2026-09-28 11:37 | 2026-09-28 11:37 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 38.3300 | 38.0500 | 38.9500 | 1042.0801 | 34500.00 | 7670.00 | 26830.00 | 9 | 9 | 417 | 7093 | 0.0587903566896941 | 0.639444664478399 | 0.638863536545219 | true | false | false | |||||||||||||||||
| 5877079a-3d9f-4746-bac9-a7786850f428 | 2026-09-24 12:33 | 2026-09-24 12:33 | 2026-09-24 12:33 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 35.4500 | 35.2500 | 35.5500 | 1066.1000 | 17725.00 | 10655.00 | 7070.00 | 5 | 5 | 545 | 6415 | 0.0849571317225253 | 0.634723276571337 | 0.634179512689661 | true | false | false | |||||||||||||||||
| 5f847663-0f4e-4e77-8bcd-a604b678da7c | 2026-09-24 09:59 | 2026-09-24 09:58 | 2026-09-24 09:58 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 42.2900 | 42.1500 | 42.5500 | 1047.6800 | 76116.00 | 21135.00 | 54981.00 | 18 | 7 | 140 | 6415 | 0.0218238503507405 | 0.642674781384499 | 0.641308003863388 | true | false | false | |||||||||||||||||
| 7a05ad1a-c4b4-4f46-914e-fd2801a86aba | 2026-08-27 15:25 | 2026-08-27 15:25 | 2026-08-27 15:25 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 134.7200 | 133.7000 | 135.1500 | 918.0000 | 242490.00 | 121275.00 | 121215.00 | 18 | 10 | 119 | 3546 | 0.0335589396503102 | 0.650522601465848 | 0.650522601465848 | true | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1239384749976.00 |
| 2026-12-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:59:25.903362Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1239384749976.00 |
| 2026-12-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:46:30.544917Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 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-30T19:59:18.109572Z"} |
| 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-30T19:59:18.109572Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:52:25.570899Z"} |
| 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:32:13.617209Z"} |
| 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-29T14:23:29.656550Z"} |
| 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-28T15:37:38.003662Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1210573930694.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:36:42.025876Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1210573930694.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:59:25.813942Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:35:44.109119Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |