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 |
|---|
| 8e00c1a7-bb68-4073-b703-38a9959691fd | 2026-09-01 09:52 | 2026-09-01 09:52 | 2026-09-01 09:52 | DELL | DELL261016C00580000 | call | 580.0000 | 2026-10-16 | 8.8500 | 8.8500 | 9.7000 | 442.8400 | 54010.00 | 905.00 | 53105.00 | 61 | 26 | 61 | 332 | 0.183734939759036 | 0.699860309622848 | 0.704929504984934 | true | 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-01T14:00:27.391289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1bb0e9e5-68f1-4e22-a85b-d50ae9bee0fe | 2026-09-14 11:26 | 2026-09-14 11:26 | 2026-09-14 11:26 | DELL | DELL261016C00580000 | call | 580.0000 | 2026-10-16 | 22.1500 | 21.8500 | 22.1500 | 533.3000 | 64235.00 | 64235.00 | 0.00 | 29 | 12 | 62 | 584 | 0.106164383561644 | 0.620254309957407 | 0.620254309957407 | false | false | false | true | ||||||||||||||||
| 0e068073-f3cd-4f40-aa04-bd87870dc4bd | 2026-09-15 15:56 | 2026-09-15 15:56 | 2026-09-15 15:56 | DELL | DELL261016C00580000 | call | 580.0000 | 2026-10-16 | 24.8500 | 24.6500 | 24.9500 | 542.0000 | 99400.00 | 99400.00 | 0.00 | 40 | 8 | 134 | 621 | 0.215780998389694 | 0.615535875064337 | 0.611439530104236 | false | false | false | true | ||||||||||||||||
| f749b7eb-1ea0-4ad6-8e20-3a1d5a766043 | 2026-09-17 14:17 | 2026-09-17 14:17 | 2026-09-17 14:17 | DELL | DELL261016C00580000 | call | 580.0000 | 2026-10-16 | 44.8600 | 44.6000 | 45.0500 | 587.1700 | 704265.00 | 49455.00 | 654810.00 | 157 | 16 | 718 | 910 | 0.789010989010989 | 0.614220134153034 | 0.616527243369002 | true | false | false | true | ||||||||||||||||
| 3b9e2d1d-ed32-4327-86b1-feebe6fe4671 | 2026-09-21 10:30 | 2026-09-21 10:30 | 2026-09-21 10:30 | DELL | DELL261016C00580000 | call | 580.0000 | 2026-10-16 | 36.8000 | 36.3000 | 36.8000 | 578.2100 | 33120.00 | 33120.00 | 0.00 | 9 | 6 | 107 | 1057 | 0.101229895931883 | 0.611895776562934 | 0.611895776562934 | false | false | false | true | ||||||||||||||||
| 5d1f5aae-9ba2-48b2-8ddd-8dca0717acbd | 2026-09-21 10:31 | 2026-09-21 10:31 | 2026-09-21 10:31 | DELL | DELL261016C00580000 | call | 580.0000 | 2026-10-16 | 36.8000 | 36.5500 | 36.8000 | 578.5200 | 22080.00 | 22080.00 | 0.00 | 6 | 6 | 114 | 1057 | 0.107852412488174 | 0.609158248229858 | 0.609158248229858 | false | false | false | true | ||||||||||||||||
| b02e1987-e69f-4d1c-8c35-87087424a98d | 2026-09-21 10:49 | 2026-09-21 10:49 | 2026-09-21 10:49 | DELL | DELL261016C00580000 | call | 580.0000 | 2026-10-16 | 35.3000 | 35.1500 | 35.3000 | 576.2500 | 45890.00 | 45890.00 | 0.00 | 13 | 7 | 174 | 1057 | 0.164616840113529 | 0.604112815768631 | 0.604112815768631 | false | false | false | true | ||||||||||||||||
| b47936d8-c667-45de-8261-876290174bf0 | 2026-09-25 10:35 | 2026-09-25 10:35 | 2026-09-25 10:35 | DELL | DELL261016C00580000 | call | 580.0000 | 2026-10-16 | 25.1700 | 24.9500 | 25.3000 | 561.0101 | 15100.00 | 2520.00 | 12580.00 | 6 | 5 | 38 | 1091 | 0.0348304307974335 | 0.610997622404823 | 0.610057288785415 | false | false | false | true | ||||||||||||||||
| d3cb4d64-c8eb-4cf2-b446-1b9e394629aa | 2026-09-25 15:56 | 2026-09-25 15:56 | 2026-09-25 15:56 | DELL | DELL261016C00580000 | call | 580.0000 | 2026-10-16 | 24.5000 | 24.4500 | 24.5500 | 562.3400 | 26953.00 | 17153.00 | 0.00 | 11 | 9 | 168 | 1091 | 0.153987167736022 | 0.586714179491341 | 0.586714179491341 | true | 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-14T15:39:52.032222Z"} |
| 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} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 185600887819.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 181471867388.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 181471867388.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 181471867388.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:51:11.587541Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 177554187193.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:37:32.022295Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 177554187193.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:58:21.779683Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |