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_alerts658,639 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 | expirydate |
|---|
| 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 |
|---|
| 00eedbff-e120-451a-bd07-ab87d391ab0b | 2026-09-16 15:08 | 2026-09-16 15:08 | 2026-09-16 15:08 | DELL | DELL260918P00550000 | put | 550.0000 | 2026-09-18 | 9.3500 | 9.0000 | 9.6000 | 554.9693 | 93490.00 | 91630.00 | 1860.00 | 100 | 5 | 3378 | 1246 | 2.71107544141252 | 0.715301497133804 | 0.718414047590755 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 177680360469.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:16:52.058969Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 79001fe4-9ff5-46ea-86dc-68f9a96d7cde | 2026-09-15 12:17 | 2026-09-15 12:17 | 2026-09-15 12:17 | DELL | DELL260918P00550000 | put | 550.0000 | 2026-09-18 | 15.5400 | 15.3500 | 15.8500 | 547.8500 | 352779.00 | 6199.00 | 346580.00 | 227 | 36 | 2455 | 1045 | 2.34928229665072 | 0.722489216734563 | 0.727710107122227 | true | false | false | true | ||||||||||||||||
| 1114ba0e-99a4-4731-809c-ddcf1644bd18 | 2026-09-15 09:54 | 2026-09-15 09:54 | 2026-09-15 09:54 | DELL | DELL260918P00550000 | put | 550.0000 | 2026-09-18 | 9.2000 | 9.1500 | 9.2000 | 564.5300 | 92000.00 | 92000.00 | 0.00 | 100 | 5 | 485 | 1045 | 0.464114832535885 | 0.767035846768603 | 0.767035846768603 | false | false | false | true | false | |||||||||||||||
| f184eefd-6e6c-404b-b2c7-e856b5952445 | 2026-09-15 09:54 | 2026-09-15 09:54 | 2026-09-15 09:54 | DELL | DELL260918P00550000 | put | 550.0000 | 2026-09-18 | 9.0000 | 9.0000 | 9.0500 | 565.3450 | 90000.00 | 0.00 | 90000.00 | 100 | 5 | 384 | 1045 | 0.367464114832536 | 0.770982310093853 | 0.770982310093853 | false | false | false | true | false | |||||||||||||||
| c30afedc-0d05-457c-880c-8b4cf48b5505 | 2026-09-14 09:32 | 2026-09-14 09:31 | 2026-09-14 09:31 | DELL | DELL260918P00550000 | put | 550.0000 | 2026-09-18 | 30.0000 | 28.8500 | 30.0000 | 528.9000 | 318000.00 | 318000.00 | 0.00 | 106 | 7 | 393 | 1559 | 0.252084669660039 | 0.783497068526031 | 0.783497068526031 | false | false | false | true | ||||||||||||||||
| 5f805f6f-b7ab-4442-a202-403fab9723de | 2026-09-14 09:31 | 2026-09-14 09:31 | 2026-09-14 09:31 | DELL | DELL260918P00550000 | put | 550.0000 | 2026-09-18 | 22.5000 | 21.8500 | 23.0000 | 540.2400 | 101250.00 | 101250.00 | 0.00 | 45 | 6 | 188 | 1559 | 0.120590121872996 | 0.761324146462783 | 0.761324146462783 | false | false | false | true | ||||||||||||||||
| f8836df0-eafc-4e37-acdb-b456bed1ed93 | 2026-09-09 14:13 | 2026-09-09 14:12 | 2026-09-09 14:12 | DELL | DELL260918P00550000 | put | 550.0000 | 2026-09-18 | 26.2200 | 26.1000 | 26.4000 | 540.5000 | 91785.00 | 0.00 | 15660.00 | 35 | 5 | 1265 | 140 | 9.03571428571429 | 0.624370000217935 | 0.628831199276693 | false | false | false | true | false | |||||||||||||||
| 1e59e832-d7ad-4ed5-8e95-7259095f37a4 | 2026-09-09 12:53 | 2026-09-09 12:52 | 2026-09-09 12:52 | DELL | DELL260918P00550000 | put | 550.0000 | 2026-09-18 | 23.8500 | 23.7000 | 24.2000 | 545.0000 | 224190.00 | 2385.00 | 219420.00 | 94 | 13 | 1173 | 140 | 8.37857142857143 | 0.634100836077941 | 0.634100836077941 | true | false | false | true | ||||||||||||||||
| 763b68a4-7ed7-45fd-a627-d076b846b6e4 | 2026-09-09 11:46 | 2026-09-09 11:45 | 2026-09-09 11:45 | DELL | DELL260918P00550000 | put | 550.0000 | 2026-09-18 | 25.2500 | 25.0000 | 25.4500 | 544.6901 | 95944.00 | 90894.00 | 5050.00 | 38 | 6 | 826 | 140 | 5.9 | 0.664782677848026 | 0.664782677848026 | false | false | false | true | false | |||||||||||||||
| 8d59795c-ed0d-43a6-8ae4-a2eddca8dcd7 | 2026-09-08 09:45 | 2026-09-08 09:45 | 2026-09-08 09:45 | DELL | DELL260918P00550000 | put | 550.0000 | 2026-09-18 | 39.1200 | 38.0500 | 39.6000 | 523.1400 | 54765.00 | 46965.00 | 7800.00 | 14 | 6 | 24 | 128 | 0.1875 | 0.670413426213189 | 0.665731567793061 | true | false | false | true | false | |||||||||||||||
| 089396eb-3409-4dab-ad28-32f905940970 | 2026-09-04 13:53 | 2026-09-04 13:53 | 2026-09-04 13:53 | DELL | DELL260918P00550000 | put | 550.0000 | 2026-09-18 | 38.1500 | 38.1500 | 38.4000 | 527.0900 | 68670.00 | 0.00 | 68670.00 | 18 | 5 | 65 | 112 | 0.580357142857143 | 0.609177111330479 | 0.609177111330479 | false | false | false | true | false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T13:31:50.503893Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:51:30.246262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:49:15.511852Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 168529643685.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T18:01:17.201510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |