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.
Simplify Analyticsuw_flow_alerts425,429 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 |
|---|
| 634f04d3-f885-429e-ad75-ad531b955177 | 2026-09-24 15:51 | 2026-09-24 15:51 | 2026-09-24 15:51 | HD | HD270319P00260000 | put | 260.0000 | 2027-03-19 | 10.0100 | 9.5000 | 10.0500 | 291.4200 | 10015.00 | 6015.00 | 2000.00 | 10 | 10 | 89 | 498 | 0.178714859437751 | 0.319005531045111 | 0.319807533815598 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 296034465827.00 | 2026-11-17 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T19:53:57.742588Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| bb4c66fc-d999-4b4a-8a1f-1ead2686469d | 2026-09-24 12:16 | 2026-09-24 12:16 | 2026-09-24 12:16 | HD | HD260925C00297500 | call | 297.5000 | 2026-09-25 | 0.9900 | 0.7900 | 1.0500 | 294.6600 | 10730.00 | 5498.00 | 5232.00 | 108 | 9 | 281 | 76 | 3.69736842105263 | 0.343772886277642 | 0.338184343420143 | true | false | false | true | ||||||||||||||||
| 95c8c60f-451d-4087-8623-832abd849d66 | 2026-09-24 10:39 | 2026-09-24 10:39 | 2026-09-24 10:39 | HD | HD281215C00340000 | call | 340.0000 | 2028-12-15 | 36.4200 | 35.2000 | 36.9000 | 292.5700 | 72832.00 | 65632.00 | 7200.00 | 20 | 6 | 20 | 55 | 0.363636363636364 | 0.237323895793159 | 0.237323895793159 | false | false | false | true | ||||||||||||||||
| 88407a7a-d0b0-43a1-b876-0a56c6eec247 | 2026-09-24 10:32 | 2026-09-24 10:32 | 2026-09-24 10:32 | HD | HD261030C00295000 | call | 295.0000 | 2026-10-30 | 8.9200 | 8.5500 | 9.3000 | 292.3450 | 12494.00 | 6237.00 | 4467.00 | 14 | 6 | 15 | 9 | 1.66666666666667 | 0.262183457815636 | 0.263275728717686 | false | false | false | true | ||||||||||||||||
| c9fd9217-9f69-43f4-a466-1636da75ac01 | 2026-09-23 15:55 | 2026-09-23 15:55 | 2026-09-23 15:55 | HD | HD270319P00260000 | put | 260.0000 | 2027-03-19 | 8.2700 | 7.7500 | 8.3000 | 297.2200 | 21500.00 | 10775.00 | 2475.00 | 26 | 16 | 55 | 452 | 0.121681415929204 | 0.310188848619174 | 0.311037900765881 | true | false | false | true | ||||||||||||||||
| c9c70bd7-6315-4583-9106-3dd0f930db52 | 2026-09-23 14:40 | 2026-09-23 14:40 | 2026-09-23 14:40 | HD | HD261023C00295000 | call | 295.0000 | 2026-10-23 | 11.3900 | 11.0500 | 11.5500 | 298.8100 | 56974.00 | 56974.00 | 0.00 | 50 | 12 | 52 | 5 | 10.4 | 0.258101802891248 | 0.258101802891248 | false | false | false | true | ||||||||||||||||
| 009fb57e-2e7c-4bb7-a2b3-cbe242929b98 | 2026-09-22 13:42 | 2026-09-22 13:42 | 2026-09-22 13:42 | HD | HD261016C00315000 | call | 315.0000 | 2026-10-16 | 3.8400 | 3.7500 | 3.9500 | 303.6750 | 23435.00 | 19635.00 | 3800.00 | 61 | 13 | 635 | 904 | 0.702433628318584 | 0.252464458292491 | 0.254280144384344 | false | false | false | true | ||||||||||||||||
| f938ea4e-d8ef-438d-a08b-a3cfde9162cf | 2026-09-22 12:28 | 2026-09-22 12:28 | 2026-09-22 12:28 | HD | HD280121C00300000 | call | 300.0000 | 2028-01-21 | 43.9700 | 42.5000 | 44.4500 | 301.6399 | 439720.00 | 439720.00 | 0.00 | 100 | 6 | 100 | 303 | 0.33003300330033 | 0.246385402309023 | 0.246385402309023 | false | false | false | true | ||||||||||||||||
| b19eb707-bc77-4fc5-a153-24e2b1088780 | 2026-09-21 15:58 | 2026-09-21 15:58 | 2026-09-21 15:58 | HD | HD270319P00320000 | put | 320.0000 | 2027-03-19 | 34.5000 | 34.5000 | 35.4000 | 297.6900 | 210464.00 | 0.00 | 210464.00 | 61 | 17 | 61 | 198 | 0.308080808080808 | 0.303923168615197 | 0.304065054456414 | false | false | false | true | ||||||||||||||||
| badcccce-f4f9-4228-8961-219d326979ee | 2026-09-21 11:09 | 2026-09-21 11:09 | 2026-09-21 11:09 | HD | HD280121C00340000 | call | 340.0000 | 2028-01-21 | 25.4100 | 25.1000 | 26.2500 | 297.0000 | 17790.00 | 2580.00 | 15210.00 | 7 | 6 | 58 | 224 | 0.258928571428571 | 0.247243439454395 | 0.252382166593365 | false | false | false | true | ||||||||||||||||
| 8a1aeec4-e6bb-47bb-ac50-f61bc51d0845 | 2026-09-14 11:09 | 2026-09-14 11:09 | 2026-09-14 11:09 | HD | HD260918C00315000 | call | 315.0000 | 2026-09-18 | 2.9700 | 2.9700 | 3.1000 | 312.4354 | 62406.00 | 300.00 | 62106.00 | 210 | 13 | 390 | 330 | 1.18181818181818 | 0.310699493150128 | 0.313055416150945 | true | false | false | true | ||||||||||||||||
| 9171dcf3-60ac-4190-a473-9d9917521270 | 2026-09-10 11:45 | 2026-09-10 11:45 | 2026-09-10 11:45 | HD | HD261009C00320000 | call | 320.0000 | 2026-10-09 | 3.9800 | 3.8500 | 4.0000 | 306.5855 | 53695.00 | 32740.00 | 19355.00 | 135 | 24 | 160 | 16 | 10 | 0.250545138102892 | 0.250545138102892 | false | false | false | true | ||||||||||||||||
| a8b3dc00-b8c5-466f-bac6-9c88e55395f2 | 2026-09-10 10:03 | 2026-09-10 10:03 | 2026-09-10 10:03 | HD | HD261016C00310000 | call | 310.0000 | 2026-10-16 | 8.4600 | 8.2500 | 9.4000 | 305.9100 | 162430.00 | 9320.00 | 153110.00 | 192 | 31 | 195 | 139 | 1.40287769784173 | 0.252944484896618 | 0.257897997152931 | false | false | false | true | ||||||||||||||||
| b522b883-bf4c-4e87-b57e-367a25a329a8 | 2026-09-10 10:00 | 2026-09-10 10:00 | 2026-09-10 10:00 | HD | HD261016C00320000 | call | 320.0000 | 2026-10-16 | 5.0600 | 5.0500 | 5.4500 | 306.7100 | 104680.00 | 13265.00 | 91415.00 | 207 | 54 | 218 | 265 | 0.822641509433962 | 0.253648374890299 | 0.255083375508079 | false | false | false | true | ||||||||||||||||
| 54366468-8eac-46d8-8b15-3391419f83a4 | 2026-09-03 15:49 | 2026-09-03 15:49 | 2026-09-03 15:49 | HD | HD260904C00325000 | call | 325.0000 | 2026-09-04 | 0.2500 | 0.1700 | 0.3000 | 318.5650 | 114694.00 | 31468.00 | 83226.00 | 4532 | 105 | 4957 | 218 | 22.7385321100917 | 0.311275484421382 | 0.301096394677942 | false | false | false | true | ||||||||||||||||
| 6eddeb2d-16c6-4c5d-bc63-a4c400ca6970 | 2026-08-27 15:28 | 2026-08-27 15:28 | 2026-08-27 15:28 | HD | HD261016P00320000 | put | 320.0000 | 2026-10-16 | 8.5200 | 8.0500 | 8.7000 | 328.0000 | 226565.00 | 226565.00 | 0.00 | 266 | 11 | 1393 | 445 | 3.13033707865169 | 0.269774889089648 | 0.269554913844072 | false | false | false | true | ||||||||||||||||
| 5c5526dc-524d-4594-8683-0c4f8ad4758f | 2026-08-27 15:28 | 2026-08-27 15:28 | 2026-08-27 15:28 | HD | HD261016P00320000 | put | 320.0000 | 2026-10-16 | 8.4800 | 8.0500 | 8.7000 | 328.0000 | 903135.00 | 879731.00 | 23404.00 | 1065 | 11 | 1127 | 445 | 2.53258426966292 | 0.266805815845782 | 0.266805815845782 | false | false | false | true | ||||||||||||||||
| 632d962b-4719-459f-9a9d-26f6077bd0cf | 2026-08-20 10:47 | 2026-08-20 10:47 | 2026-08-20 10:47 | HD | HD270115C00360000 | call | 360.0000 | 2027-01-15 | 13.6800 | 13.4500 | 13.9000 | 336.1725 | 251620.00 | 139690.00 | 6825.00 | 184 | 31 | 412 | 1895 | 0.217414248021108 | 0.245537252640051 | 0.246142411193156 | false | false | false | true | ||||||||||||||||
| b547f29a-71d2-4c46-915b-46cb78cde667 | 2026-08-18 10:12 | 2026-08-18 10:12 | 2026-08-18 10:12 | HD | HD260821P00330000 | put | 330.0000 | 2026-08-21 | 1.2200 | 1.2000 | 1.2500 | 340.4800 | 51138.00 | 11472.00 | 39666.00 | 418 | 40 | 1162 | 2251 | 0.516215015548645 | 0.391809691089439 | 0.391809691089439 | false | false | false | true | ||||||||||||||||
| db8e58f6-6ab7-453d-9768-73b5e2936df5 | 2026-08-18 09:59 | 2026-08-18 09:59 | 2026-08-18 09:59 | HD | HD260904C00340000 | call | 340.0000 | 2026-09-04 | 7.8800 | 7.3000 | 8.4000 | 339.1400 | 53565.00 | 26880.00 | 26685.00 | 68 | 10 | 273 | 27 | 10.1111111111111 | 0.271502689961278 | 0.27664057039394 | true | false | false | true | ||||||||||||||||
| 7f415e28-6757-402a-bb64-02bf5d699829 | 2026-08-18 09:37 | 2026-08-18 09:37 | 2026-08-18 09:37 | HD | HD260821C00340000 | call | 340.0000 | 2026-08-21 | 3.4400 | 3.2000 | 3.4500 | 336.3500 | 70590.00 | 70250.00 | 340.00 | 205 | 7 | 380 | 1180 | 0.322033898305085 | 0.396861558565269 | 0.406625627994692 | true | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 296034465827.00 |
| 2026-11-17 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:17:19.978572Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 296034465827.00 |
| 2026-11-17 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:39:59.397883Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 296034465827.00 |
| 2026-11-17 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:35:45.310206Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 296034465827.00 |
| 2026-11-17 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:57:58.068578Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 296034465827.00 |
| 2026-11-17 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T18:50:04.558688Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 304644527299.00 |
| 2026-11-17 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:49:14.593703Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 304644527299.00 |
| 2026-11-17 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:35:05.886735Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 296513356847.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 296513356847.00 |
| 2026-11-17 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:13:03.739619Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 310151774035.00 |
| 2026-11-17 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 310151774035.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T15:47:40.219521Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 310151774035.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:06:33.692120Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 310151774035.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:06:33.692120Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 310151774035.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 310151774035.00 |
| 2026-11-17 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:35:44.109119Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 310151774035.00 |
| 2026-11-17 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:35:44.109119Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 310151774035.00 |
| 2026-11-17 |
| unknown |
| — |
| 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 |
| Common Stock |
| Consumer Cyclical |
| 310151774035.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 310151774035.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 310151774035.00 |
| 2026-11-17 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |