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 | 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 |
|---|
| 11b13e7b-61ea-42ca-963a-60cb0029a01c | 2026-09-16 10:21 | 2026-09-16 10:21 | 2026-09-16 10:21 | DELL | DELL261016P00490000 | put | 490.0000 | 2026-10-16 | 11.0100 | 11.0000 | 11.8000 | 570.0000 | 101289.00 | 2225.00 | 99064.00 | 92 | 18 | 111 | 560 | 0.198214285714286 | 0.647200959430431 | 0.648933953711575 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 177680360469.00 | 2026-11-24 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 43920e43-1a65-44aa-b02a-6a087726b76b | 2026-09-22 13:58 | 2026-09-22 13:58 | 2026-09-22 13:58 | DELL | DELL261016P00490000 | put | 490.0000 | 2026-10-16 | 10.2000 | 9.7000 | 10.2500 | 552.7400 | 205040.00 | 194900.00 | 2020.00 | 201 | 40 | 669 | 682 | 0.980938416422287 | 0.610453374883882 | 0.613020057041355 | true | false | false | true | ||||||||||||||||
| 6b16bf29-dd78-443d-8452-9f5e27aea277 | 2026-09-22 14:03 | 2026-09-22 14:03 | 2026-09-22 14:03 | DELL | DELL261016P00490000 | put | 490.0000 | 2026-10-16 | 10.3400 | 9.9500 | 10.5500 | 551.1201 | 11369.00 | 11369.00 | 0.00 | 11 | 6 | 751 | 682 | 1.10117302052786 | 0.610254076161347 | 0.610254076161347 | false | false | false | true | ||||||||||||||||
| 5ef48292-49a7-414b-a7af-e2507063b199 | 2026-09-22 14:28 | 2026-09-22 14:28 | 2026-09-22 14:28 | DELL | DELL261016P00490000 | put | 490.0000 | 2026-10-16 | 10.0300 | 9.9000 | 10.2000 | 553.5200 | 17052.00 | 0.00 | 17052.00 | 17 | 6 | 1005 | 682 | 1.47360703812317 | 0.614327358906314 | 0.614327358906314 | false | false | false | true | ||||||||||||||||
| 452e3bf8-bb27-4ec7-b806-5720211710a1 | 2026-09-22 14:29 | 2026-09-22 14:29 | 2026-09-22 14:29 | DELL | DELL261016P00490000 | put | 490.0000 | 2026-10-16 | 9.9000 | 9.9000 | 10.2000 | 554.0425 | 17820.00 | 0.00 | 17820.00 | 18 | 6 | 1023 | 682 | 1.5 | 0.614330036119237 | 0.614330036119237 | true | false | false | true | ||||||||||||||||
| 345e68bc-2693-440a-8f9a-592a51cd604a | 2026-09-22 14:38 | 2026-09-22 14:38 | 2026-09-22 14:38 | DELL | DELL261016P00490000 | put | 490.0000 | 2026-10-16 | 9.9600 | 9.7000 | 10.0500 | 553.5300 | 24902.00 | 24902.00 | 0.00 | 25 | 8 | 1109 | 682 | 1.62609970674487 | 0.613345815049589 | 0.613345815049589 | false | false | false | true | ||||||||||||||||
| 4c716032-b5ed-4a97-895e-c1e16d9280a8 | 2026-09-22 14:40 | 2026-09-22 14:40 | 2026-09-22 14:40 | DELL | DELL261016P00490000 | put | 490.0000 | 2026-10-16 | 9.9000 | 9.6500 | 10.1500 | 554.4050 | 24750.00 | 0.00 | 12870.00 | 25 | 5 | 1134 | 682 | 1.66275659824047 | 0.616117736722633 | 0.616117736722633 | true | false | false | true | ||||||||||||||||
| d56d5015-2ca2-4569-9221-e7023caee4bf | 2026-09-22 14:51 | 2026-09-22 14:51 | 2026-09-22 14:51 | DELL | DELL261016P00490000 | put | 490.0000 | 2026-10-16 | 9.6400 | 9.4500 | 9.9000 | 555.0301 | 22177.00 | 0.00 | 22177.00 | 23 | 8 | 1232 | 682 | 1.80645161290323 | 0.612159527671878 | 0.612943592456668 | false | false | false | true | ||||||||||||||||
| b8de34bb-0e58-4745-820a-09bdfefccea2 | 2026-09-22 14:56 | 2026-09-22 14:56 | 2026-09-22 14:56 | DELL | DELL261016P00490000 | put | 490.0000 | 2026-10-16 | 9.8900 | 9.5000 | 10.0000 | 553.8450 | 17800.00 | 17800.00 | 0.00 | 18 | 6 | 1282 | 682 | 1.87976539589443 | 0.612060954456655 | 0.613354699890584 | false | false | false | true | ||||||||||||||||
| 77050ba6-5bdd-4fb8-8638-d1990fbafc5f | 2026-09-22 14:56 | 2026-09-22 14:56 | 2026-09-22 14:56 | DELL | DELL261016P00490000 | put | 490.0000 | 2026-10-16 | 10.1400 | 9.6500 | 10.2000 | 552.7100 | 203859.00 | 203859.00 | 0.00 | 201 | 33 | 1484 | 682 | 2.17595307917889 | 0.610304073758823 | 0.614151283137879 | true | false | false | true | ||||||||||||||||
| 1e94d152-3408-41f3-9b6f-47013f958dd2 | 2026-09-22 14:58 | 2026-09-22 14:58 | 2026-09-22 14:58 | DELL | DELL261016P00490000 | put | 490.0000 | 2026-10-16 | 10.1600 | 9.7500 | 10.3000 | 552.8000 | 20328.00 | 20328.00 | 0.00 | 20 | 8 | 1505 | 682 | 2.20674486803519 | 0.614856252843489 | 0.614856252843489 | false | false | false | true | ||||||||||||||||
| 3dc59b11-cb0d-4a55-aceb-e5a217176cc7 | 2026-09-22 15:02 | 2026-09-22 15:01 | 2026-09-22 15:01 | DELL | DELL261016P00490000 | put | 490.0000 | 2026-10-16 | 10.3700 | 9.8500 | 10.5000 | 551.3000 | 144092.00 | 144092.00 | 0.00 | 139 | 11 | 1683 | 682 | 2.46774193548387 | 0.612934890234963 | 0.613442944261677 | true | false | false | true | ||||||||||||||||
| 38a128a7-5eb5-45f9-b41c-19ac313820e1 | 2026-09-22 15:02 | 2026-09-22 15:02 | 2026-09-22 15:02 | DELL | DELL261016P00490000 | put | 490.0000 | 2026-10-16 | 10.6100 | 10.0500 | 10.8500 | 550.8800 | 425631.00 | 421479.00 | 4152.00 | 401 | 56 | 2085 | 682 | 3.05718475073314 | 0.61837121209243 | 0.620139031778481 | false | false | false | |||||||||||||||||
| af974f02-11e4-42b7-bf5e-45a591d995cd | 2026-09-22 15:02 | 2026-09-22 15:02 | 2026-09-22 15:02 | DELL | DELL261016P00490000 | put | 490.0000 | 2026-10-16 | 10.7700 | 10.2500 | 11.0500 | 550.0850 | 107732.00 | 107732.00 | 0.00 | 100 | 10 | 2186 | 682 | 3.20527859237537 | 0.616589820598204 | 0.616839969542712 | false | false | false | true | ||||||||||||||||
| 53fcabd1-6010-4daf-aecf-2b5775448bb1 | 2026-09-29 10:07 | 2026-09-29 10:07 | 2026-09-29 10:07 | DELL | DELL261016P00490000 | put | 490.0000 | 2026-10-16 | 7.3600 | 7.1500 | 7.4000 | 547.0000 | 53005.00 | 22120.00 | 30885.00 | 72 | 30 | 93 | 2413 | 0.0385412349772068 | 0.608041730546914 | 0.604305057520637 | true | false | false | true |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 173147585557.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 173147585557.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:10:48.215993Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 173147585557.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:29:55.439380Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 173147585557.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:29:55.439380Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 173147585557.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:44:24.241276Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 173147585557.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:44:24.241276Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 173147585557.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:55:20.077577Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 173147585557.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:02:38.336545Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 173147585557.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:02:38.336545Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 173147585557.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:02:38.336545Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 173147585557.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:02:38.336545Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 173147585557.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:02:38.336545Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 173147585557.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:10:39.996631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 170204593913.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:10:17.656675Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |