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_alerts474,253 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 |
|---|
| da00ea76-3d52-4843-9924-75b7ae7b5557 | 2026-09-25 12:13 | 2026-09-25 12:13 | 2026-09-25 12:13 | WEAT | WEAT270115C00026000 | call | 26.0000 | 2027-01-15 | 1.4400 | 1.3000 | 1.5000 | 25.0000 | 14398.00 | 14398.00 | 0.00 | 100 | 5 | 141 | 2374 | 0.0593934288121314 | 0.276810628402171 | 0.276810628402171 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 137793270.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T16:14:10.282260Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 8587532f-048a-40e7-8e0f-9b4259cfd6f6 | 2026-09-25 11:34 | 2026-09-25 11:34 | 2026-09-25 11:34 | WEAT | WEAT270115C00022000 | call | 22.0000 | 2027-01-15 | 3.9300 | 3.8000 | 4.0000 | 25.3100 | 33002.00 | 33002.00 | 0.00 | 84 | 7 | 102 | 2159 | 0.047244094488189 | 0.280341087126168 | 0.280341087126168 | false | false | false | true | ||||||||||||||||
| aae18b11-041f-4724-bc8f-86dfa7b21b4d | 2026-09-25 11:33 | 2026-09-25 11:33 | 2026-09-25 11:33 | WEAT | WEAT261016P00028000 | put | 28.0000 | 2026-10-16 | 2.7800 | 2.6000 | 2.8000 | 25.0000 | 27756.00 | 27756.00 | 0.00 | 100 | 8 | 100 | 166 | 0.602409638554217 | 0.352327622822107 | 0.352327622822107 | false | false | false | true | ||||||||||||||||
| 133bb143-9607-4d8b-962f-009430d35a56 | 2026-09-24 12:10 | 2026-09-24 12:10 | 2026-09-24 12:10 | WEAT | WEAT261016C00027000 | call | 27.0000 | 2026-10-16 | 0.3000 | 0.2500 | 0.3000 | 25.0000 | 14724.00 | 14670.00 | 54.00 | 491 | 26 | 579 | 4416 | 0.131114130434783 | 0.302163155132303 | 0.31709259331966 | false | false | false | true | ||||||||||||||||
| 0576cf34-4107-49af-a173-1b594eaee212 | 2026-09-11 14:16 | 2026-09-11 14:16 | 2026-09-11 14:16 | WEAT | WEAT270115P00028000 | put | 28.0000 | 2027-01-15 | 2.5600 | 2.5500 | 3.0000 | 26.1900 | 10244.00 | 0.00 | 10244.00 | 40 | 16 | 52 | 214 | 0.242990654205607 | 0.277840495375453 | 0.296234648778399 | false | false | false | true | ||||||||||||||||
| 30bac04c-9ede-47d3-965a-3066b22d32ed | 2026-09-11 12:34 | 2026-09-11 12:34 | 2026-09-11 12:34 | WEAT | WEAT270115C00030000 | call | 30.0000 | 2027-01-15 | 0.7900 | 0.7500 | 0.8000 | 26.1819 | 23284.00 | 23284.00 | 0.00 | 296 | 5 | 1702 | 29580 | 0.0575388776200135 | 0.313908189318042 | 0.31773144046987 | false | false | false | true | ||||||||||||||||
| 2e098074-6673-46ed-9ac6-42f9b7d560ab | 2026-09-02 11:05 | 2026-09-02 11:05 | 2026-09-02 11:05 | WEAT | WEAT261016C00030000 | call | 30.0000 | 2026-10-16 | 0.7500 | 0.7000 | 1.0000 | 28.2300 | 26542.00 | 10440.00 | 16102.00 | 354 | 11 | 608 | 12460 | 0.0487961476725522 | 0.35010460307725 | 0.352873752856841 | true | false | false | true | ||||||||||||||||
| 1b954f4f-1017-4984-aaa7-9556427b0630 | 2026-09-01 14:45 | 2026-09-01 14:45 | 2026-09-01 14:45 | WEAT | WEAT270115C00030000 | call | 30.0000 | 2027-01-15 | 1.6500 | 1.5500 | 1.6500 | 28.0198 | 16332.00 | 16332.00 | 0.00 | 99 | 23 | 1055 | 29476 | 0.0357918306418781 | 0.329810362092287 | 0.334265266927639 | false | false | false | true | ||||||||||||||||
| 8bd89c7c-361e-4a84-ac77-da5c89479678 | 2026-09-01 14:20 | 2026-09-01 14:20 | 2026-09-01 14:20 | WEAT | WEAT270115C00028000 | call | 28.0000 | 2027-01-15 | 2.4000 | 2.2500 | 2.4000 | 28.0050 | 53997.00 | 53997.00 | 0.00 | 225 | 5 | 659 | 1158 | 0.569084628670121 | 0.320286424386033 | 0.320286424386033 | false | false | false | true | ||||||||||||||||
| f8a67191-00f2-40b1-8229-ce09b2bfdd67 | 2026-09-01 12:35 | 2026-09-01 12:35 | 2026-09-01 12:35 | WEAT | WEAT260918P00026000 | put | 26.0000 | 2026-09-18 | 0.1700 | 0.1000 | 0.2000 | 28.0950 | 15814.00 | 8376.00 | 7438.00 | 915 | 14 | 1007 | 355 | 2.83661971830986 | 0.331218555193772 | 0.375612521842073 | false | false | false | true | ||||||||||||||||
| b82d222a-35b9-404c-b63d-51bffdf11d5c | 2026-09-01 10:34 | 2026-09-01 10:34 | 2026-09-01 10:34 | WEAT | WEAT270115C00030000 | call | 30.0000 | 2027-01-15 | 1.7000 | 1.5000 | 1.7000 | 28.0100 | 33986.00 | 33986.00 | 0.00 | 200 | 5 | 353 | 29476 | 0.011975844755055 | 0.339353873230706 | 0.34232117524731 | false | false | false | true | ||||||||||||||||
| 078b340a-d09d-4bbe-8d96-2be10187615c | 2026-08-31 13:38 | 2026-08-31 13:37 | 2026-08-31 13:37 | WEAT | WEAT260918C00028000 | call | 28.0000 | 2026-09-18 | 0.7400 | 0.6500 | 0.7500 | 27.5350 | 29537.00 | 29537.00 | 0.00 | 400 | 9 | 1478 | 1061 | 1.39302544769086 | 0.370881729977573 | 0.370881729977573 | false | false | false | true | ||||||||||||||||
| cfe5e609-b5f7-4415-a46c-fded7d7dc3ad | 2026-08-28 12:51 | 2026-08-28 12:51 | 2026-08-28 12:51 | WEAT | WEAT270115C00030000 | call | 30.0000 | 2027-01-15 | 1.6000 | 1.5000 | 1.6000 | 28.0100 | 13759.00 | 13759.00 | 0.00 | 86 | 6 | 1348 | 29330 | 0.0459597681554722 | 0.320912792189762 | 0.322378568351172 | false | false | false | true | ||||||||||||||||
| 692e8790-b43a-4043-b403-33254c267264 | 2026-08-28 12:14 | 2026-08-28 12:14 | 2026-08-28 12:14 | WEAT | WEAT270115C00030000 | call | 30.0000 | 2027-01-15 | 1.6000 | 1.5500 | 1.6500 | 28.1500 | 20810.00 | 1600.00 | 19210.00 | 130 | 13 | 1140 | 29330 | 0.0388680531878623 | 0.313462488556127 | 0.313462488556127 | true | false | false | true | ||||||||||||||||
| 97c4cd12-4e16-42b3-90cb-68923b91b263 | 2026-08-27 11:20 | 2026-08-27 11:20 | 2026-08-27 11:20 | WEAT | WEAT270115C00024000 | call | 24.0000 | 2027-01-15 | 4.1900 | 4.0000 | 4.3000 | 27.3199 | 21790.00 | 12550.00 | 0.00 | 52 | 5 | 67 | 5305 | 0.0126295947219604 | 0.272357566059473 | 0.283673057642643 | false | false | false | true | ||||||||||||||||
| 4c7f63c8-692f-4777-a681-6b4b8ad40a9e | 2026-08-26 13:43 | 2026-08-26 13:43 | 2026-08-26 13:43 | WEAT | WEAT270115C00035000 | call | 35.0000 | 2027-01-15 | 0.4500 | 0.4000 | 0.5000 | 26.9750 | 26563.00 | 17203.00 | 9360.00 | 591 | 17 | 2609 | 39669 | 0.0657692404648466 | 0.348749889237766 | 0.353707837236562 | true | false | false | true | ||||||||||||||||
| 9803a220-99f1-4d67-9fa7-0346f1d9feea | 2026-08-26 12:45 | 2026-08-26 12:45 | 2026-08-26 12:45 | WEAT | WEAT270115C00035000 | call | 35.0000 | 2027-01-15 | 0.3700 | 0.3500 | 0.4500 | 26.7406 | 10127.00 | 117.00 | 9250.00 | 272 | 5 | 1580 | 39669 | 0.0398295898560589 | 0.342110441404274 | 0.350083648800977 | false | false | false | true | ||||||||||||||||
| 6e75c81f-3034-41b1-8b1e-a7038f8b7650 | 2026-08-20 10:45 | 2026-08-20 10:44 | 2026-08-20 10:44 | WEAT | WEAT260918C00025000 | call | 25.0000 | 2026-09-18 | 1.0700 | 1.0500 | 1.1500 | 25.4800 | 10662.00 | 0.00 | 10662.00 | 100 | 11 | 102 | 368 | 0.277173913043478 | 0.261091588017876 | 0.268467995686751 | false | false | false | true | ||||||||||||||||
| 2bc23fc7-5131-435f-9f4d-b093b83dc32d | 2026-08-19 10:09 | 2026-08-19 10:09 | 2026-08-19 10:09 | WEAT | WEAT270115C00030000 | call | 30.0000 | 2027-01-15 | 0.6300 | 0.6000 | 0.7000 | 25.3095 | 24470.00 | 8905.00 | 15500.00 | 388 | 5 | 907 | 29252 | 0.0310064269109804 | 0.299066321642885 | 0.299066321642885 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:37:39.831939Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:34:39.698780Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:13:55.044964Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T18:33:12.425630Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T16:54:27.741510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:25:17.297093Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T18:58:03.753197Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T18:40:09.958238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T16:48:42.201804Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T17:15:24.821907Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:25:17.992358Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T15:23:19.203737Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T18:03:36.899464Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:52:20.196728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 137793270.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |