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_alerts523,327 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 |
|---|
| d01067c9-7932-44ee-bae1-a0d5247d9d55 | 2026-09-24 11:33 | 2026-09-24 11:32 | 2026-09-24 11:32 | MSFT | MSFT260925P00485000 | put | 485.0000 | 2026-09-25 | 0.5700 | 0.5500 | 0.5700 | 494.8000 | 19494.00 | 19494.00 | 0.00 | 342 | 23 | 5315 | 3257 | 1.6318698188517 | 0.34124081261515 | 0.34124081261515 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 3717153817340.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T15:34:38.323653Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| 7b433184-1283-4728-9088-88fb05778c0f | 2026-09-24 10:58 | 2026-09-24 10:58 | 2026-09-24 10:58 | MSFT | MSFT260925P00485000 | put | 485.0000 | 2026-09-25 | 0.6500 | 0.6500 | 0.6700 | 494.0100 | 20670.00 | 0.00 | 20670.00 | 318 | 22 | 4358 | 3257 | 1.33804114215536 | 0.336361540030496 | 0.336361540030496 | false | false | false | true | ||||||||||||||||
| 96394ef5-bca8-4e09-80c9-f9b481e47ddf | 2026-09-23 15:19 | 2026-09-23 15:19 | 2026-09-23 15:19 | MSFT | MSFT260925P00485000 | put | 485.0000 | 2026-09-25 | 0.4600 | 0.4600 | 0.4900 | 500.0800 | 18400.00 | 0.00 | 18400.00 | 400 | 52 | 2705 | 2354 | 1.14910790144435 | 0.308282553146259 | 0.308579181990206 | true | false | false | true | ||||||||||||||||
| 585076b8-9109-4cd9-a80e-f2f3e6131450 | 2026-09-23 12:39 | 2026-09-23 12:39 | 2026-09-23 12:39 | MSFT | MSFT260925P00485000 | put | 485.0000 | 2026-09-25 | 0.6800 | 0.6400 | 0.6800 | 498.0000 | 44540.00 | 44540.00 | 0.00 | 655 | 54 | 1730 | 2354 | 0.734919286321155 | 0.317015193554511 | 0.316530343994355 | false | false | false | true | ||||||||||||||||
| 75712516-9184-439d-b05e-c8ea2b3073d8 | 2026-09-22 09:57 | 2026-09-22 09:57 | 2026-09-22 09:57 | MSFT | MSFT260925P00485000 | put | 485.0000 | 2026-09-25 | 1.5400 | 1.5400 | 1.6400 | 496.4499 | 16786.00 | 0.00 | 16786.00 | 109 | 7 | 562 | 2185 | 0.25720823798627 | 0.309842787224647 | 0.310108993918677 | false | false | false | true | ||||||||||||||||
| 3e1f72f9-d1c9-4924-a6ea-889690534b78 | 2026-09-22 09:43 | 2026-09-22 09:43 | 2026-09-22 09:43 | MSFT | MSFT260925P00485000 | put | 485.0000 | 2026-09-25 | 1.3000 | 1.2500 | 1.4000 | 498.0000 | 12646.00 | 6016.00 | 6630.00 | 97 | 7 | 257 | 2185 | 0.117620137299771 | 0.319498277802156 | 0.320605745691704 | false | false | false | true | ||||||||||||||||
| 4a60d11b-66a9-4593-8ee6-56425204c5ab | 2026-09-21 12:08 | 2026-09-21 12:08 | 2026-09-21 12:08 | MSFT | MSFT260925P00485000 | put | 485.0000 | 2026-09-25 | 2.0000 | 1.9000 | 2.0000 | 494.1400 | 57400.00 | 57400.00 | 0.00 | 287 | 34 | 969 | 1794 | 0.540133779264214 | 0.268498626071241 | 0.266403499659322 | true | false | false | true | ||||||||||||||||
| 4d4dbd16-72a2-4613-94aa-8bc655d0bfe5 | 2026-09-21 11:04 | 2026-09-21 11:03 | 2026-09-21 11:03 | MSFT | MSFT260925P00485000 | put | 485.0000 | 2026-09-25 | 2.2100 | 2.2100 | 2.3900 | 493.2000 | 27846.00 | 0.00 | 27846.00 | 126 | 11 | 544 | 1794 | 0.303232998885173 | 0.264747657697339 | 0.264747657697339 | true | false | false | true | ||||||||||||||||
| 03515265-9af9-4075-bf22-fb48347ec072 | 2026-09-17 15:45 | 2026-09-17 15:45 | 2026-09-17 15:45 | MSFT | MSFT260925P00485000 | put | 485.0000 | 2026-09-25 | 2.4400 | 2.4100 | 2.5600 | 497.1700 | 123018.00 | 10045.00 | 112973.00 | 504 | 50 | 891 | 758 | 1.1754617414248 | 0.240997662213289 | 0.242217725596761 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:58:33.796895Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:25:57.460829Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:43:49.845741Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3697921654518.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:58:41.675080Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3697921654518.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:45:11.876123Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:10:34.961716Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:05:23.809831Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3696065268145.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |