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 | strikenumeric | expirydate |
|---|
| 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 |
|---|
| 7fde6a3a-0b13-405e-b64a-afc1eb8f31ca | 2026-09-29 10:32 | 2026-09-29 10:32 | 2026-09-29 10:32 | WDC | WDC270115C00660000 | call | 660.0000 | 2027-01-15 | 20.5500 | 19.6500 | 21.4000 | 457.0000 | 10275.00 | 6165.00 | 4110.00 | 5 | 5 | 31 | 2328 | 0.0133161512027491 | 0.714278362715961 | 0.714278362715961 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 163498107285.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T14:37:12.234330Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| ce72ad44-af2b-4bf7-8115-1d50f645d92d | 2026-09-24 14:50 | 2026-09-24 14:50 | 2026-09-24 14:50 | WDC | WDC270115C00660000 | call | 660.0000 | 2027-01-15 | 21.4500 | 19.9000 | 21.4500 | 453.0000 | 47190.00 | 47190.00 | 0.00 | 22 | 6 | 261 | 2333 | 0.111873124732105 | 0.720886477448884 | 0.720886477448884 | false | false | false | true | false | |||||||||||||||
| 4b57707d-8bd8-4a95-a791-58d8275fc0d1 | 2026-09-24 14:50 | 2026-09-24 14:50 | 2026-09-24 14:50 | WDC | WDC270115C00660000 | call | 660.0000 | 2027-01-15 | 21.4300 | 19.9000 | 21.7500 | 453.0000 | 10715.00 | 6430.00 | 4285.00 | 5 | 5 | 266 | 2333 | 0.114016288041149 | 0.71816667907229 | 0.718802392193792 | false | false | false | true | false | |||||||||||||||
| 05e97137-19c0-42dc-8bb0-f8e567928379 | 2026-09-22 15:52 | 2026-09-22 15:52 | 2026-09-22 15:52 | WDC | WDC270115C00660000 | call | 660.0000 | 2027-01-15 | 27.5000 | 24.8000 | 28.4500 | 465.6700 | 13750.00 | 13750.00 | 0.00 | 5 | 5 | 169 | 2345 | 0.0720682302771855 | 0.74802985253087 | 0.74802985253087 | false | false | false | true | false | |||||||||||||||
| 92beda4c-9efa-44cc-a871-c1ea18bf8384 | 2026-09-08 15:02 | 2026-09-08 15:02 | 2026-09-08 15:02 | WDC | WDC270115C00660000 | call | 660.0000 | 2027-01-15 | 41.1000 | 40.0000 | 41.1000 | 488.2000 | 86305.00 | 86305.00 | 0.00 | 21 | 5 | 3554 | 3457 | 1.02805901070292 | 0.772609406472935 | 0.772609406472935 | true | false | false | true | false | |||||||||||||||
| 0851efba-eb31-4227-8ea5-9c43ec88f9ed | 2026-09-08 14:46 | 2026-09-08 14:46 | 2026-09-08 14:46 | WDC | WDC270115C00660000 | call | 660.0000 | 2027-01-15 | 41.2500 | 40.0000 | 41.2500 | 488.5500 | 86624.00 | 86624.00 | 0.00 | 21 | 10 | 3533 | 3457 | 1.02198437951981 | 0.772788440572065 | 0.772881828742409 | false | false | false | true | false | |||||||||||||||
| 267fb694-022b-4671-b9fa-44bd927e87c8 | 2026-09-08 14:06 | 2026-09-08 14:06 | 2026-09-08 14:06 | WDC | WDC270115C00660000 | call | 660.0000 | 2027-01-15 | 40.8000 | 40.0000 | 40.8000 | 487.0600 | 97920.00 | 97920.00 | 0.00 | 24 | 9 | 3467 | 3457 | 1.00289268151577 | 0.773474979481436 | 0.773474979481436 | false | false | false | true | false | |||||||||||||||
| a31ef819-360f-480f-bc2d-6603caea4177 | 2026-09-08 13:55 | 2026-09-08 13:55 | 2026-09-08 13:55 | WDC | WDC270115C00660000 | call | 660.0000 | 2027-01-15 | 41.0000 | 41.0000 | 41.5500 | 486.7201 | 1230000.00 | 0.00 | 680600.00 | 300 | 6 | 3419 | 3457 | 0.989007810240093 | 0.776449979980458 | 0.776449979980458 | false | false | false | true | false | |||||||||||||||
| 06463106-63ad-4c67-8f08-0f4d8b647f52 | 2026-09-08 11:19 | 2026-09-08 11:19 | 2026-09-08 11:19 | WDC | WDC270115C00660000 | call | 660.0000 | 2027-01-15 | 35.0000 | 32.9500 | 35.8000 | 476.6800 | 1046405.00 | 69905.00 | 777000.00 | 299 | 14 | 684 | 3457 | 0.197859415678334 | 0.751685669682487 | 0.75058721035076 | false | false | false | true | ||||||||||||||||
| fef3c051-83e0-4756-8fb2-f7fc523c2092 | 2026-09-08 10:41 | 2026-09-08 10:41 | 2026-09-08 10:41 | WDC | WDC270115C00660000 | call | 660.0000 | 2027-01-15 | 35.7000 | 33.1500 | 35.7000 | 476.1400 | 981750.00 | 981750.00 | 0.00 | 275 | 5 | 284 | 3457 | 0.0821521550477292 | 0.759217085589655 | 0.759217085589655 | false | false | false | true | false | |||||||||||||||
| 7083c45e-6b16-44d4-8747-50f67ad980a6 | 2026-09-04 12:30 | 2026-09-04 12:30 | 2026-09-04 12:30 | WDC | WDC270115C00660000 | call | 660.0000 | 2027-01-15 | 28.7500 | 28.6000 | 28.7500 | 464.6300 | 51744.00 | 48874.00 | 2870.00 | 18 | 5 | 477 | 2999 | 0.159053017672558 | 0.710804590060886 | 0.710804590060886 | false | false | false | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 170784639763.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:51:39.883666Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 170784639763.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:51:39.883666Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 167507322582.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:03:39.512328Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:03:39.512328Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:15:47.972880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:15:47.972880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:26:49.659255Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:47:12.085652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 153929350631.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |