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_alerts609,118 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 |
|---|
| b1a83dcc-6842-4632-9451-e2d570d6d834 | 2026-09-03 15:39 | 2026-09-03 15:38 | 2026-09-03 15:38 | DELL | DELL260918C00540000 | call | 540.0000 | 2026-09-18 | 14.5500 | 14.5500 | 14.9000 | 512.7450 | 74216.00 | 1465.00 | 72751.00 | 51 | 26 | 617 | 309 | 1.99676375404531 | 0.602837957809945 | 0.605400871749063 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 168529643685.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T19:48:49.580975Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7a8e328a-1031-4483-8966-ffc69063998b | 2026-09-04 15:00 | 2026-09-04 15:00 | 2026-09-04 15:00 | DELL | DELL260918C00540000 | call | 540.0000 | 2026-09-18 | 15.8500 | 15.7500 | 15.9500 | 519.0550 | 50720.00 | 31700.00 | 19020.00 | 32 | 8 | 504 | 575 | 0.876521739130435 | 0.596059703966059 | 0.596059703966059 | false | false | false | true | ||||||||||||||||
| 87964cc5-0a22-496a-a6f0-502cf39c26e6 | 2026-09-11 09:31 | 2026-09-11 09:31 | 2026-09-11 09:31 | DELL | DELL260918C00540000 | call | 540.0000 | 2026-09-18 | 10.9100 | 10.1000 | 11.4000 | 524.0000 | 65465.00 | 60005.00 | 5460.00 | 60 | 15 | 65 | 798 | 0.081453634085213 | 0.602701788928432 | 0.596641116755746 | true | false | false | true | ||||||||||||||||
| cc04f25d-3375-4c6f-849f-6ba2fabb3e3e | 2026-09-11 09:37 | 2026-09-11 09:37 | 2026-09-11 09:37 | DELL | DELL260918C00540000 | call | 540.0000 | 2026-09-18 | 19.8500 | 19.4000 | 19.8500 | 540.9450 | 63510.00 | 61530.00 | 1980.00 | 32 | 11 | 288 | 798 | 0.360902255639098 | 0.642460429079387 | 0.642371708551348 | true | false | false | true | ||||||||||||||||
| cafdb51b-aca8-4af4-904d-9ebdf345149c | 2026-09-11 11:34 | 2026-09-11 11:33 | 2026-09-11 11:33 | DELL | DELL260918C00540000 | call | 540.0000 | 2026-09-18 | 33.0500 | 33.0500 | 33.2500 | 563.0260 | 85930.00 | 0.00 | 85930.00 | 26 | 6 | 866 | 798 | 1.08521303258145 | 0.627072103909429 | 0.627072103909429 | false | false | false | true | ||||||||||||||||
| 7876a60a-4c37-4b8e-8aad-6cb08b1a1bc1 | 2026-09-11 11:34 | 2026-09-11 11:33 | 2026-09-11 11:33 | DELL | DELL260918C00540000 | call | 540.0000 | 2026-09-18 | 33.1000 | 32.7500 | 33.1500 | 563.0550 | 165499.00 | 82749.00 | 82750.00 | 50 | 16 | 935 | 798 | 1.17167919799499 | 0.630521955123475 | 0.62816936546294 | false | false | false | true | ||||||||||||||||
| 088e7d57-2db9-4d2b-9676-6b54e09899d6 | 2026-09-11 11:34 | 2026-09-11 11:34 | 2026-09-11 11:34 | DELL | DELL260918C00540000 | call | 540.0000 | 2026-09-18 | 33.0700 | 32.7500 | 33.1500 | 563.0050 | 56225.00 | 29770.00 | 26455.00 | 17 | 7 | 984 | 798 | 1.23308270676692 | 0.629827473565647 | 0.629470135437543 | false | false | false | true | ||||||||||||||||
| 7ee4fe13-e376-40f7-8114-8c53b2d49b28 | 2026-09-14 10:14 | 2026-09-14 10:14 | 2026-09-14 10:14 | DELL | DELL260918C00540000 | call | 540.0000 | 2026-09-18 | 16.7700 | 16.3500 | 17.2500 | 540.0000 | 167675.00 | 77050.00 | 90625.00 | 100 | 5 | 529 | 942 | 0.561571125265393 | 0.731486827031231 | 0.732374364454696 | false | false | false | true | ||||||||||||||||
| bd93b0aa-4b85-496f-806b-75367d6df49c | 2026-09-14 11:10 | 2026-09-14 11:10 | 2026-09-14 11:10 | DELL | DELL260918C00540000 | call | 540.0000 | 2026-09-18 | 10.5000 | 10.0000 | 11.2000 | 527.6700 | 52500.00 | 50400.00 | 2100.00 | 50 | 5 | 1120 | 942 | 1.18895966029724 | 0.709852527657656 | 0.709852527657656 | false | false | false | true | ||||||||||||||||
| fefda110-af6f-4e3c-92fe-531a2c7f8933 | 2026-09-14 12:15 | 2026-09-14 12:15 | 2026-09-14 12:15 | DELL | DELL260918C00540000 | call | 540.0000 | 2026-09-18 | 14.4000 | 13.4500 | 14.4000 | 536.1760 | 77760.00 | 77760.00 | 0.00 | 54 | 11 | 1300 | 942 | 1.38004246284501 | 0.718196311574778 | 0.718196311574778 | false | false | false | true | ||||||||||||||||
| a9ee604a-e600-459c-bfdf-15f87e6fc74d | 2026-09-14 12:49 | 2026-09-14 12:49 | 2026-09-14 12:49 | DELL | DELL260918C00540000 | call | 540.0000 | 2026-09-18 | 16.0000 | 16.0000 | 16.6500 | 540.2100 | 320000.00 | 0.00 | 320000.00 | 200 | 5 | 1796 | 942 | 1.90658174097665 | 0.699783875306251 | 0.699783875306251 | false | false | false | true | ||||||||||||||||
| 9e88b55c-25bc-4772-9617-15eadc60264a | 2026-09-14 13:18 | 2026-09-14 13:18 | 2026-09-14 13:18 | DELL | DELL260918C00540000 | call | 540.0000 | 2026-09-18 | 16.4900 | 16.0000 | 16.5000 | 540.7901 | 141850.00 | 125400.00 | 16450.00 | 86 | 28 | 1943 | 942 | 2.06263269639066 | 0.70853217061597 | 0.70853217061597 | false | false | false | true | ||||||||||||||||
| b49d8573-1868-46cb-b2c1-0205f458fdcc | 2026-09-15 09:48 | 2026-09-15 09:47 | 2026-09-15 09:47 | DELL | DELL260918C00540000 | call | 540.0000 | 2026-09-18 | 26.2000 | 26.1000 | 26.6500 | 558.5000 | 70740.00 | 52400.00 | 18340.00 | 27 | 5 | 479 | 1343 | 0.356664184661206 | 0.758248650119119 | 0.758248650119119 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:05:15.166096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:37:33.609039Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:46:58.036194Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:53:19.427541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:53:19.427541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:53:19.427541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:23:59.234542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:17:14.116635Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |