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 | strikenumeric | expiry |
|---|
| 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 |
|---|
| 2eab3632-18cc-4106-913c-1224000a38b0 | 2026-08-25 14:03 | 2026-08-25 14:03 | 2026-08-25 14:03 | XLU | XLU261016P00042000 | put | 42.0000 | 2026-10-16 | 0.5600 | 0.5500 | 0.6000 | 43.0000 | 50624.00 | 0.00 | 50624.00 | 904 | 11 | 1480 | 11966 | 0.123683770683604 | 0.186026642679046 | 0.186026642679046 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 21723451602.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1c69c9d9-db97-4f0f-af72-018f7a32a805 | 2026-08-27 15:46 | 2026-08-27 15:46 | 2026-08-27 15:46 | XLU | XLU261016P00042000 | put | 42.0000 | 2026-10-16 | 0.5500 | 0.3500 | 0.5700 | 43.2150 | 11000.00 | 2750.00 | 8250.00 | 200 | 5 | 2145 | 12373 | 0.173361351329508 | 0.179204403938986 | 0.179204403938986 | false | false | false | true | ||||||||||||||||
| c37568d7-867b-4003-8888-86ceaaadfc12 | 2026-08-31 09:45 | 2026-08-31 09:45 | 2026-08-31 09:45 | XLU | XLU261016P00042000 | put | 42.0000 | 2026-10-16 | 1.0100 | 0.9800 | 1.0200 | 41.9800 | 101927.00 | 2222.00 | 95665.00 | 1014 | 47 | 1036 | 13948 | 0.0742758818468598 | 0.185364835279444 | 0.183674489885116 | false | false | false | true | ||||||||||||||||
| fc5ff74f-c7da-4f3f-83c7-e077c0c483ca | 2026-09-08 13:08 | 2026-09-08 13:08 | 2026-09-08 13:08 | XLU | XLU261016P00042000 | put | 42.0000 | 2026-10-16 | 0.3600 | 0.3500 | 0.3600 | 43.5300 | 10692.00 | 10692.00 | 0.00 | 297 | 17 | 447 | 14125 | 0.031646017699115 | 0.179424429447272 | 0.179424429447272 | false | false | false | true | ||||||||||||||||
| 196c431e-53b0-4f41-8f5b-5476adc7831d | 2026-09-14 10:57 | 2026-09-14 10:57 | 2026-09-14 10:57 | XLU | XLU261016P00042000 | put | 42.0000 | 2026-10-16 | 0.9000 | 0.8600 | 0.9000 | 41.8550 | 14580.00 | 14580.00 | 0.00 | 162 | 31 | 792 | 15065 | 0.0525721871888483 | 0.182456832644157 | 0.182456832644157 | true | false | false | true | ||||||||||||||||
| 86c50395-dd9c-4abc-8e0a-abcdc3a8676d | 2026-09-14 10:58 | 2026-09-14 10:58 | 2026-09-14 10:58 | XLU | XLU261016P00042000 | put | 42.0000 | 2026-10-16 | 0.9300 | 0.9000 | 0.9300 | 41.8300 | 99882.00 | 99882.00 | 0.00 | 1074 | 29 | 2204 | 15065 | 0.14629936939927 | 0.186045921640067 | 0.186045921640067 | false | false | false | true | ||||||||||||||||
| ac99a6a8-104a-40d5-a193-cd1716229408 | 2026-09-16 13:33 | 2026-09-16 13:33 | 2026-09-16 13:33 | XLU | XLU261016P00042000 | put | 42.0000 | 2026-10-16 | 1.1800 | 1.1700 | 1.1800 | 41.4550 | 14750.00 | 14750.00 | 0.00 | 125 | 16 | 211 | 14486 | 0.0145657876570482 | 0.201796958178368 | 0.201796958178368 | true | false | false | true | ||||||||||||||||
| dcf0eef0-0649-486d-af15-6202a6da6f75 | 2026-09-16 13:33 | 2026-09-16 13:33 | 2026-09-16 13:33 | XLU | XLU261016P00042000 | put | 42.0000 | 2026-10-16 | 1.1800 | 1.1800 | 1.2100 | 41.4550 | 91922.00 | 0.00 | 91922.00 | 779 | 20 | 1006 | 14486 | 0.0694463620046942 | 0.201796958178368 | 0.201796958178368 | false | false | false | true | ||||||||||||||||
| 1e40583e-b321-43c3-a2a0-1f2a01fc2880 | 2026-09-25 09:49 | 2026-09-25 09:49 | 2026-09-25 09:49 | XLU | XLU261016P00042000 | put | 42.0000 | 2026-10-16 | 2.7200 | 2.7200 | 2.7600 | 39.2900 | 11152.00 | 0.00 | 11152.00 | 41 | 5 | 41 | 9241 | 0.00443674926955957 | 0.215367376248943 | 0.215367376248943 | true | false | false | true | ||||||||||||||||
| af2cd042-7073-4ec3-9d85-ffa4b396012f | 2026-09-30 10:01 | 2026-09-30 10:01 | 2026-09-30 10:01 | XLU | XLU261016P00042000 | put | 42.0000 | 2026-10-16 | 2.4000 | 2.0500 | 2.4000 | 39.6250 | 71520.00 | 71520.00 | 0.00 | 298 | 11 | 298 | 9167 | 0.0325079088033162 | 0.219596521177021 | 0.219596521177021 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 21723451602.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:52:49.177007Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 21723451602.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 21997526128.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T17:11:09.796111Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 21997526128.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 21997526128.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 21523085036.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 21523085036.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 20716567207.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:50:07.736084Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 21260882342.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:03:52.520300Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |