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_alerts375,978 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 |
|---|
| d131f4ea-4c6c-442e-850b-4db46e8b454b | 2026-08-25 14:12 | 2026-08-25 14:12 | 2026-08-25 14:12 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 6.2500 | 6.1000 | 6.3000 | 111.0000 | 310000.00 | 3750.00 | 306250.00 | 496 | 7 | 1006 | 5285 | 0.19035004730369 | 0.645852754227559 | 0.645852754227559 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 90392754653.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aaf074ac-8780-40a8-ae05-e88fbed14e71 | 2026-08-26 10:00 | 2026-08-26 10:00 | 2026-08-26 10:00 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 6.5200 | 6.5000 | 6.7500 | 110.5900 | 163680.00 | 35370.00 | 128310.00 | 251 | 16 | 659 | 5313 | 0.12403538490495 | 0.632664988947401 | 0.632256310819945 | true | false | false | true | ||||||||||||||||
| 73315222-33c3-4f9b-ae61-5a841c7086de | 2026-08-26 10:00 | 2026-08-26 10:00 | 2026-08-26 10:00 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 6.4700 | 6.4500 | 6.6500 | 110.6800 | 100275.00 | 39000.00 | 61275.00 | 155 | 12 | 818 | 5313 | 0.153961980048937 | 0.626417139902424 | 0.631375342218236 | false | false | false | true | ||||||||||||||||
| 6285a070-ec13-4792-9b5a-06a653a3321e | 2026-08-26 10:00 | 2026-08-26 10:00 | 2026-08-26 10:00 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 6.6000 | 6.6000 | 6.8000 | 110.4950 | 89760.00 | 0.00 | 89760.00 | 136 | 9 | 276 | 5313 | 0.051948051948052 | 0.632915561438114 | 0.632915561438114 | false | false | false | true | ||||||||||||||||
| d5c39438-40a4-4a7b-9abe-c12d59725b5a | 2026-08-26 10:00 | 2026-08-26 10:00 | 2026-08-26 10:00 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 6.4500 | 6.4000 | 6.6000 | 110.6600 | 185220.00 | 54930.00 | 130290.00 | 287 | 18 | 1406 | 5313 | 0.26463391680783 | 0.627434376459425 | 0.626009864851894 | false | false | false | true | ||||||||||||||||
| 03a2804c-222a-472a-8b9d-6ee98433faa8 | 2026-08-26 10:00 | 2026-08-26 10:00 | 2026-08-26 10:00 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 6.5100 | 6.4500 | 6.7000 | 110.6100 | 126250.00 | 122380.00 | 3870.00 | 194 | 6 | 1600 | 5313 | 0.301148127235084 | 0.623970211704159 | 0.633073449026363 | false | false | false | true | ||||||||||||||||
| c9fe78c5-c8e4-4af9-9271-b2be5a668d17 | 2026-08-26 10:00 | 2026-08-26 10:00 | 2026-08-26 10:00 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 6.4500 | 6.4000 | 6.7000 | 110.6200 | 95460.00 | 645.00 | 94170.00 | 148 | 34 | 2136 | 5313 | 0.402032749858837 | 0.6227437828863 | 0.624378580734903 | false | false | false | true | ||||||||||||||||
| cf412797-1c2c-4607-b254-a988c253bb91 | 2026-08-26 10:00 | 2026-08-26 10:00 | 2026-08-26 10:00 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 6.4200 | 6.4000 | 6.6500 | 110.6200 | 125255.00 | 58050.00 | 67205.00 | 195 | 17 | 2740 | 5313 | 0.515716167890081 | 0.626009864851894 | 0.624378580734903 | true | false | false | true | ||||||||||||||||
| 5e017083-49da-4da0-93b7-c4fc4016d037 | 2026-08-26 10:00 | 2026-08-26 10:00 | 2026-08-26 10:00 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 6.4500 | 6.4000 | 6.6500 | 110.5950 | 202530.00 | 32895.00 | 169635.00 | 314 | 11 | 2543 | 5313 | 0.478637304724261 | 0.619874352598931 | 0.623357245503031 | false | false | false | true | ||||||||||||||||
| 2043bdbe-aeb3-48ca-8cac-143aa3fccee2 | 2026-08-26 10:00 | 2026-08-26 10:00 | 2026-08-26 10:00 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 6.4000 | 6.4000 | 6.6000 | 110.6600 | 60800.00 | 0.00 | 60800.00 | 95 | 7 | 2835 | 5313 | 0.533596837944664 | 0.62145871830803 | 0.62145871830803 | false | false | false | true | ||||||||||||||||
| 4f36f690-ad05-47da-94fe-f687f850b50c | 2026-08-26 13:30 | 2026-08-26 13:30 | 2026-08-26 13:30 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 6.9500 | 6.8500 | 7.0000 | 109.1250 | 52820.00 | 9730.00 | 43090.00 | 76 | 6 | 4587 | 5313 | 0.863354037267081 | 0.606410558983556 | 0.606410558983556 | false | false | false | true | ||||||||||||||||
| 1f33d26a-92b7-4651-bf9d-4793c28d957c | 2026-08-26 13:30 | 2026-08-26 13:30 | 2026-08-26 13:30 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 6.9500 | 6.8500 | 7.0000 | 109.1250 | 302325.00 | 217535.00 | 84790.00 | 435 | 6 | 4511 | 5313 | 0.849049501223414 | 0.605744972395034 | 0.606410558983556 | false | false | false | true | ||||||||||||||||
| 6a198919-245c-4ec8-9c28-dbfebe84cbf8 | 2026-08-28 12:30 | 2026-08-28 12:30 | 2026-08-28 12:30 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 8.2300 | 8.2000 | 8.5500 | 105.7600 | 57628.00 | 29700.00 | 27928.00 | 70 | 12 | 122 | 7844 | 0.0155532891381948 | 0.581352931847165 | 0.593433166833208 | false | false | false | true | ||||||||||||||||
| e39423f5-6765-4ca8-b8ee-6c6e724aaab0 | 2026-09-01 10:13 | 2026-09-01 10:13 | 2026-09-01 10:13 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 8.2000 | 8.0500 | 8.2000 | 105.4300 | 508400.00 | 508400.00 | 0.00 | 620 | 26 | 631 | 7769 | 0.0812202342643841 | 0.621236657697265 | 0.621236657697265 | false | false | false | true | ||||||||||||||||
| 7f9b0e3d-8b98-4868-b6b5-6259537979bc | 2026-09-14 15:16 | 2026-09-14 15:16 | 2026-09-14 15:16 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 1.8300 | 1.7800 | 1.8300 | 114.2300 | 55807.00 | 55807.00 | 0.00 | 305 | 62 | 2007 | 9531 | 0.210576015108593 | 0.763257703050089 | 0.762533412025603 | true | false | false | true | ||||||||||||||||
| de811fdc-b165-43ea-8904-f7ce71c49ae4 | 2026-09-15 10:09 | 2026-09-15 10:09 | 2026-09-15 10:09 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 3.0000 | 3.0000 | 3.1500 | 110.0550 | 147418.00 | 0.00 | 126718.00 | 491 | 67 | 1515 | 9836 | 0.154026026840179 | 0.765477780761475 | 0.765477780761475 | true | false | false | true | ||||||||||||||||
| ffbe7678-2c1b-4eec-a5b2-7b369a324e36 | 2026-09-15 15:08 | 2026-09-15 15:08 | 2026-09-15 15:08 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 3.2000 | 3.1500 | 3.2500 | 109.7400 | 160320.00 | 2240.00 | 2880.00 | 501 | 6 | 6766 | 9836 | 0.687881252541684 | 0.777006495025179 | 0.777006495025179 | true | false | false | true | ||||||||||||||||
| 1cd6ed25-ba2f-47ea-879f-2590c04cd84c | 2026-09-16 11:58 | 2026-09-16 11:58 | 2026-09-16 11:58 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 5.8500 | 5.8500 | 5.9500 | 104.8616 | 52066.00 | 0.00 | 52066.00 | 89 | 16 | 1116 | 9701 | 0.115039686630244 | 0.789791152497873 | 0.789791152497873 | false | false | false | true | ||||||||||||||||
| 341247b2-76c2-45fa-bbe1-16c1adf9a850 | 2026-09-17 09:34 | 2026-09-17 09:34 | 2026-09-17 09:34 | HOOD | HOOD260918P00110000 | put | 110.0000 | 2026-09-18 | 2.5000 | 2.4100 | 2.5000 | 109.3001 | 59750.00 | 59750.00 | 0.00 | 239 | 6 | 348 | 9291 | 0.0374556021956732 | 0.934093809776302 | 0.934093809776302 | true | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:20:43.057745Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| 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 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:20:18.853903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 90392754653.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 82557609034.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T16:04:58.541898Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 86819105996.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |