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 |
|---|
| 833c67c0-9789-42ef-ab20-e18d1dfb207c | 2026-08-28 14:15 | 2026-08-28 14:15 | 2026-08-28 14:15 | LRCX | LRCX280121C00500000 | call | 500.0000 | 2028-01-21 | 46.0300 | 45.8000 | 48.0000 | 305.3650 | 69048.00 | 13820.00 | 55228.00 | 15 | 11 | 21 | 557 | 0.0377019748653501 | 0.620832589961573 | 0.620832589961573 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 342223780290.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T18:18:32.282709Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 992995a9-da0b-4cc2-a2ea-5c2081425501 | 2026-08-28 11:41 | 2026-08-28 11:41 | 2026-08-28 11:41 | LRCX | LRCX260918C00335000 | call | 335.0000 | 2026-09-18 | 7.5100 | 7.2000 | 9.2500 | 310.0000 | 102935.00 | 43245.00 | 59690.00 | 137 | 26 | 137 | 109 | 1.25688073394495 | 0.531739130627942 | 0.547052731626492 | true | false | false | true | ||||||||||||||||
| f702bb16-27ac-4d60-901f-b842e6ecc26f | 2026-08-28 11:14 | 2026-08-28 11:14 | 2026-08-28 11:14 | LRCX | LRCX270319P00260000 | put | 260.0000 | 2027-03-19 | 27.8300 | 26.9000 | 28.3000 | 313.3550 | 211480.00 | 119825.00 | 91655.00 | 76 | 22 | 91 | 495 | 0.183838383838384 | 0.625117308196473 | 0.626470275922344 | false | false | false | true | ||||||||||||||||
| 2a7370c5-aff6-4678-be21-0c79c7b429e4 | 2026-08-27 11:13 | 2026-08-27 11:13 | 2026-08-27 11:13 | LRCX | LRCX261120P00280000 | put | 280.0000 | 2026-11-20 | 20.7800 | 20.1500 | 22.1000 | 315.1650 | 168280.00 | 79040.00 | 89240.00 | 81 | 7 | 213 | 752 | 0.283244680851064 | 0.643103656752811 | 0.6440697566919 | false | false | false | true | ||||||||||||||||
| 7a6b0741-1892-4c88-b222-fba9c8c8e218 | 2026-08-26 11:30 | 2026-08-26 11:30 | 2026-08-26 11:30 | LRCX | LRCX260918C00300000 | call | 300.0000 | 2026-09-18 | 26.0000 | 25.3000 | 27.0500 | 313.0600 | 156020.00 | 0.00 | 156020.00 | 60 | 22 | 72 | 1211 | 0.0594549958711808 | 0.596238571829407 | 0.596238571829407 | false | false | false | true | ||||||||||||||||
| 3d08adac-e771-47f9-8a76-3e82988e56f0 | 2026-08-24 12:02 | 2026-08-24 12:02 | 2026-08-24 12:02 | LRCX | LRCX260918C00320000 | call | 320.0000 | 2026-09-18 | 14.3300 | 14.0000 | 14.9500 | 306.6700 | 63055.00 | 10045.00 | 53010.00 | 44 | 10 | 62 | 1320 | 0.046969696969697 | 0.61070381216799 | 0.61228801333517 | false | false | false | true | ||||||||||||||||
| 712605d6-912b-4814-92a6-3b5ae3e8e779 | 2026-08-20 14:15 | 2026-08-20 14:14 | 2026-08-20 14:14 | LRCX | LRCX270319P00250000 | put | 250.0000 | 2027-03-19 | 28.8900 | 28.2000 | 29.0000 | 305.7700 | 57785.00 | 57785.00 | 0.00 | 20 | 6 | 58 | 497 | 0.116700201207243 | 0.657681535304826 | 0.659057880357247 | false | false | false | true | ||||||||||||||||
| b66e3db4-65b1-49e7-a323-3fbe02aaae49 | 2026-08-19 13:59 | 2026-08-19 13:59 | 2026-08-19 13:59 | LRCX | LRCX261218C00400000 | call | 400.0000 | 2026-12-18 | 19.2500 | 19.2500 | 19.8000 | 307.8200 | 292603.00 | 0.00 | 292603.00 | 152 | 36 | 262 | 536 | 0.488805970149254 | 0.644780861136342 | 0.644780861136342 | false | false | false | true | ||||||||||||||||
| 279d7cc7-b1dc-424a-b9a2-a84dcff98467 | 2026-08-19 12:35 | 2026-08-19 12:35 | 2026-08-19 12:35 | LRCX | LRCX261218C00410000 | call | 410.0000 | 2026-12-18 | 18.1100 | 18.1000 | 18.6500 | 308.8650 | 155715.00 | 1855.00 | 153860.00 | 86 | 28 | 90 | 271 | 0.33210332103321 | 0.651126633489881 | 0.651126633489881 | false | false | false | true | ||||||||||||||||
| a09d7a47-b3c1-459e-8296-f43e2315da38 | 2026-08-19 09:47 | 2026-08-19 09:47 | 2026-08-19 09:47 | LRCX | LRCX260821P00317500 | put | 317.5000 | 2026-08-21 | 5.7300 | 5.5500 | 6.4000 | 321.0500 | 96220.00 | 48645.00 | 47575.00 | 168 | 13 | 185 | 1769 | 0.104578858111928 | 0.770742045995824 | 0.786969905848099 | true | false | false | true | ||||||||||||||||
| 9bdb2126-84f6-406f-8dc0-7cef92bc38d4 | 2026-08-18 14:51 | 2026-08-18 14:51 | 2026-08-18 14:51 | LRCX | LRCX280121C00600000 | call | 600.0000 | 2028-01-21 | 45.4800 | 44.5000 | 47.2500 | 324.7450 | 54581.00 | 9105.00 | 45476.00 | 12 | 7 | 254 | 1035 | 0.245410628019324 | 0.656342959923409 | 0.656342959923409 | true | false | false | true | ||||||||||||||||
| d075fdc5-6f38-49a9-b2d0-e3b012e5958f | 2026-08-18 11:52 | 2026-08-18 11:52 | 2026-08-18 11:52 | LRCX | LRCX260828P00320000 | put | 320.0000 | 2026-08-28 | 12.2500 | 12.2000 | 12.9000 | 322.5950 | 79631.00 | 75955.00 | 3676.00 | 65 | 6 | 555 | 308 | 1.80194805194805 | 0.644659306682174 | 0.647029191045457 | false | false | false | true | ||||||||||||||||
| c79a96c3-9ae1-4fa9-9809-a714322ad114 | 2026-08-17 15:14 | 2026-08-17 15:14 | 2026-08-17 15:14 | LRCX | LRCX261120P00310000 | put | 310.0000 | 2026-11-20 | 28.5100 | 27.8500 | 28.5500 | 341.5700 | 54160.00 | 54160.00 | 0.00 | 19 | 5 | 73 | 466 | 0.156652360515021 | 0.665560026741546 | 0.666369033738935 | true | false | false | true | ||||||||||||||||
| 1c7f1aac-3968-4d8e-9cee-560724640a6f | 2026-08-17 14:48 | 2026-08-17 14:48 | 2026-08-17 14:48 | LRCX | LRCX261120C00450000 | call | 450.0000 | 2026-11-20 | 17.0300 | 16.6500 | 17.4500 | 344.1800 | 86870.00 | 42800.00 | 44070.00 | 51 | 11 | 66 | 236 | 0.279661016949153 | 0.664644275731879 | 0.664644275731879 | false | false | false | true | ||||||||||||||||
| 38ea13fa-3272-42f5-a1ae-935f6124a9bc | 2026-08-17 10:45 | 2026-08-17 10:45 | 2026-08-17 10:45 | LRCX | LRCX260918P00320000 | put | 320.0000 | 2026-09-18 | 15.2500 | 15.2500 | 16.3000 | 337.1500 | 332464.00 | 3060.00 | 329404.00 | 218 | 46 | 237 | 1249 | 0.189751801441153 | 0.600458160507283 | 0.600458160507283 | false | false | false | true | ||||||||||||||||
| 230c6ab5-20a1-4eaa-853c-5f17ff924e6e | 2026-08-17 10:33 | 2026-08-17 10:33 | 2026-08-17 10:33 | LRCX | LRCX261120P00330000 | put | 330.0000 | 2026-11-20 | 38.6500 | 38.6500 | 39.2000 | 337.2011 | 545013.00 | 3895.00 | 541118.00 | 141 | 40 | 301 | 446 | 0.674887892376682 | 0.649960498049049 | 0.654483917937819 | false | false | false | true | ||||||||||||||||
| 5bdd8481-2805-4cdb-bd56-404f79e90725 | 2026-08-17 09:46 | 2026-08-17 09:46 | 2026-08-17 09:46 | LRCX | LRCX260821C00325000 | call | 325.0000 | 2026-08-21 | 18.5400 | 17.4500 | 19.1000 | 338.7799 | 87155.00 | 48125.00 | 39030.00 | 47 | 9 | 48 | 250 | 0.192 | 0.747712338708415 | 0.733663172715722 | true | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 342223780290.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:52:06.240394Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 342223780290.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:36:02.227679Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 342223780290.00 |
| 2026-10-28 |
| unknown |
| — |
| 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 |
| Common Stock |
| Technology |
| 342223780290.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:48:55.759300Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 342223780290.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T16:14:40.561585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 342223780290.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:45:57.711481Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 342223780290.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 342223780290.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:52:36.966336Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 342223780290.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 342223780290.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 342223780290.00 |
| 2026-10-28 |
| 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 |
| Technology |
| 342223780290.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 342223780290.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 342223780290.00 |
| 2026-10-28 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 342223780290.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 342223780290.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |