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_alerts326,449 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 |
|---|
| 5143f86b-4154-48cd-9e97-fbf51b8c704d | 2026-09-22 13:36 | 2026-09-22 13:36 | 2026-09-22 13:36 | DASH | DASH290119C00270000 | call | 270.0000 | 2029-01-19 | 41.1500 | 40.9000 | 42.7500 | 193.0000 | 32920.00 | 12375.00 | 16440.00 | 8 | 7 | 352 | 0 | 0 | 0.48116077141832 | 0.482010644882356 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 78612528577.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T17:40:26.166069Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 884926f1-04e0-4b71-a9cc-1097ea5c2cef | 2026-09-21 13:18 | 2026-09-21 13:18 | 2026-09-21 13:18 | DASH | DASH261023C00225000 | call | 225.0000 | 2026-10-23 | 1.4900 | 1.4800 | 1.7400 | 193.0000 | 21484.00 | 312.00 | 21172.00 | 144 | 14 | 164 | 8 | 20.5 | 0.416720085399697 | 0.426403974738824 | false | false | false | true | ||||||||||||||||
| a29b2625-f823-4dc4-99d6-a5ebf2b5296e | 2026-09-18 11:25 | 2026-09-18 11:25 | 2026-09-18 11:25 | DASH | DASH261218P00150000 | put | 150.0000 | 2026-12-18 | 3.7100 | 2.8500 | 3.8500 | 193.1300 | 268720.00 | 233340.00 | 35380.00 | 724 | 79 | 1221 | 1174 | 1.04003407155026 | 0.523499560919784 | 0.532502341550982 | true | false | false | true | ||||||||||||||||
| a4c349ad-2225-4838-8614-ecdf2fc3ad59 | 2026-09-14 12:01 | 2026-09-14 12:01 | 2026-09-14 12:01 | DASH | DASH280121C00200000 | call | 200.0000 | 2028-01-21 | 52.4200 | 51.6000 | 53.8500 | 202.0000 | 99595.00 | 0.00 | 99595.00 | 19 | 5 | 30 | 351 | 0.0854700854700855 | 0.504469624515689 | 0.504469624515689 | false | false | false | true | ||||||||||||||||
| 4c05e137-b90c-468e-b35f-b07cca93ee48 | 2026-09-09 11:17 | 2026-09-09 11:17 | 2026-09-09 11:17 | DASH | DASH261120C00210000 | call | 210.0000 | 2026-11-20 | 11.5900 | 11.4500 | 11.6500 | 194.4200 | 81150.00 | 49965.00 | 1155.00 | 70 | 6 | 96 | 99 | 0.96969696969697 | 0.49599569425787 | 0.49599569425787 | false | false | false | true | ||||||||||||||||
| bf5b73c6-c589-4f0e-a743-660df4f13556 | 2026-09-02 12:45 | 2026-09-02 12:45 | 2026-09-02 12:45 | DASH | DASH260911C00217500 | call | 217.5000 | 2026-09-11 | 10.4500 | 10.4500 | 11.0000 | 225.7100 | 286342.00 | 0.00 | 286342.00 | 274 | 46 | 274 | 1 | 274 | 0.374310457037215 | 0.374310457037215 | false | false | false | true | ||||||||||||||||
| e115127c-8bdc-4d43-8526-00977f631373 | 2026-08-26 13:02 | 2026-08-26 13:02 | 2026-08-26 13:02 | DASH | DASH270319P00195000 | put | 195.0000 | 2027-03-19 | 11.8100 | 11.2000 | 12.0000 | 236.1000 | 147588.00 | 147588.00 | 0.00 | 125 | 17 | 130 | 785 | 0.165605095541401 | 0.457820218704177 | 0.457820218704177 | false | false | false | true | ||||||||||||||||
| adf90841-5920-4f1d-82bf-55b4554e44c0 | 2026-08-26 12:03 | 2026-08-26 12:03 | 2026-08-26 12:03 | DASH | DASH270115C00250000 | call | 250.0000 | 2027-01-15 | 19.4100 | 19.4000 | 20.8000 | 235.7300 | 190190.00 | 2005.00 | 188185.00 | 98 | 8 | 373 | 1828 | 0.204048140043764 | 0.405944008945039 | 0.417034566530563 | true | false | false | true | ||||||||||||||||
| 865eface-917d-41a4-be88-7057d1dbd487 | 2026-08-26 12:01 | 2026-08-26 12:01 | 2026-08-26 12:01 | DASH | DASH270115C00260000 | call | 260.0000 | 2027-01-15 | 16.5600 | 16.4000 | 17.1000 | 235.9100 | 208600.00 | 53500.00 | 155100.00 | 126 | 13 | 407 | 483 | 0.842650103519669 | 0.415171029448196 | 0.417327907168329 | true | false | false | true | ||||||||||||||||
| 7941744c-172e-43cf-93ab-84f31c279b41 | 2026-08-26 12:01 | 2026-08-26 12:01 | 2026-08-26 12:01 | DASH | DASH270115P00230000 | put | 230.0000 | 2027-01-15 | 19.8600 | 19.7000 | 20.4500 | 235.8700 | 71505.00 | 27945.00 | 43560.00 | 36 | 8 | 54 | 619 | 0.0872374798061389 | 0.421819848208391 | 0.424619572684866 | true | false | false | true | ||||||||||||||||
| 0f70e9fe-3c3c-4a78-b3e8-f036260c6ce9 | 2026-08-25 15:47 | 2026-08-25 15:47 | 2026-08-25 15:47 | DASH | DASH280121P00115000 | put | 115.0000 | 2028-01-21 | 5.9000 | 5.3000 | 5.9500 | 233.3800 | 297129.00 | 296544.00 | 585.00 | 504 | 24 | 1005 | 122 | 8.23770491803279 | 0.547392474219291 | 0.549917688395747 | false | false | false | true | ||||||||||||||||
| 29b2a34a-bd83-4f79-bf13-dc3584408feb | 2026-08-25 15:46 | 2026-08-25 15:46 | 2026-08-25 15:46 | DASH | DASH280121P00115000 | put | 115.0000 | 2028-01-21 | 6.2200 | 5.3000 | 6.2500 | 233.6100 | 311186.00 | 311186.00 | 0.00 | 500 | 21 | 501 | 122 | 4.10655737704918 | 0.555076706530168 | 0.560031959750172 | false | false | false | true | ||||||||||||||||
| 8966f2a1-6ca0-41ac-9d63-60e090e19667 | 2026-08-25 11:34 | 2026-08-25 11:34 | 2026-08-25 11:34 | DASH | DASH260904P00235000 | put | 235.0000 | 2026-09-04 | 7.1600 | 7.1000 | 7.7000 | 232.5000 | 68040.00 | 15800.00 | 52240.00 | 95 | 24 | 443 | 10 | 44.3 | 0.386011790773732 | 0.386011790773732 | false | false | false | true | ||||||||||||||||
| 966afb80-a6a2-447f-be26-6bd4576306cb | 2026-08-25 10:28 | 2026-08-25 10:28 | 2026-08-25 10:28 | DASH | DASH261120P00220000 | put | 220.0000 | 2026-11-20 | 13.5500 | 13.5500 | 14.1000 | 231.8250 | 189707.00 | 0.00 | 189707.00 | 140 | 31 | 141 | 85 | 1.65882352941176 | 0.450854408458848 | 0.450854408458848 | false | false | false | true | ||||||||||||||||
| 5dc4c673-1b68-4741-9fb2-a2584a871276 | 2026-08-21 14:54 | 2026-08-21 14:54 | 2026-08-21 14:54 | DASH | DASH270319P00220000 | put | 220.0000 | 2027-03-19 | 25.8000 | 25.3000 | 25.8000 | 223.2150 | 51599.00 | 51599.00 | 0.00 | 20 | 7 | 21 | 36 | 0.583333333333333 | 0.450378031038946 | 0.450532019020433 | false | false | false | true | ||||||||||||||||
| a7323a9c-9fab-47fe-964b-9830cc4df756 | 2026-08-18 12:15 | 2026-08-18 12:14 | 2026-08-18 12:14 | DASH | DASH260821C00215000 | call | 215.0000 | 2026-08-21 | 7.4500 | 7.4500 | 8.0500 | 221.2400 | 497674.00 | 0.00 | 497674.00 | 668 | 52 | 1088 | 630 | 1.72698412698413 | 0.432069691017392 | 0.432069691017392 | false | false | false | true | ||||||||||||||||
| 0fe06a2e-dd29-4708-ae93-8b46c8d0962f | 2026-08-17 10:56 | 2026-08-17 10:55 | 2026-08-17 10:55 | DASH | DASH260918C00220000 | call | 220.0000 | 2026-09-18 | 9.2100 | 8.9000 | 9.6500 | 217.4300 | 110520.00 | 47040.00 | 63480.00 | 120 | 7 | 146 | 1752 | 0.0833333333333333 | 0.391487219695629 | 0.391487219695629 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 79275097102.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:20:55.206028Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 78911093406.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:02:31.142849Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:29:26.424015Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:56:20.498446Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T17:27:57.423992Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T19:47:14.629482Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T19:47:14.629482Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T15:37:01.391907Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:42:01.576369Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:11:44.414359Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 83246418326.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |