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_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 | expirydate |
|---|
| 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 |
|---|
| f67a1f56-a1e8-4adf-b456-c8061c2ea048 | 2026-09-11 13:45 | 2026-09-11 13:45 | 2026-09-11 13:45 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 0.2500 | 0.2400 | 0.2500 | 765.8600 | 125000.00 | 125000.00 | 0.00 | 5000 | 43 | 609599 | 6030 | 101.094361525705 | 0.12005516238024 | 0.119382453806807 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 810275044553.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T18:02:32.717866Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 78883c7e-6249-494b-ad29-aaa7f05e53a1 | 2026-09-11 12:56 | 2026-09-11 12:55 | 2026-09-11 12:55 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 0.5000 | 0.5000 | 0.5100 | 765.4600 | 128655.00 | 255.00 | 128400.00 | 2573 | 5 | 509793 | 6030 | 84.5427860696517 | 0.124347075168247 | 0.126164135822146 | false | false | false | true | false | |||||||||||||||
| 7e2ed62a-c5dd-4828-aa72-6235ca206953 | 2026-09-11 12:45 | 2026-09-11 12:45 | 2026-09-11 12:45 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 0.5700 | 0.5600 | 0.5800 | 765.3805 | 114455.00 | 97299.00 | 17156.00 | 2002 | 41 | 488269 | 6030 | 80.9733001658375 | 0.127698518400091 | 0.129439368600665 | false | false | false | true | false | |||||||||||||||
| f01299a5-2949-4da2-949f-32aec2438f4c | 2026-09-11 12:40 | 2026-09-11 12:40 | 2026-09-11 12:40 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 0.8400 | 0.8300 | 0.8500 | 764.8800 | 128158.00 | 12070.00 | 0.00 | 1524 | 11 | 470971 | 6030 | 78.1046434494196 | 0.133445873652889 | 0.133445873652889 | true | false | false | true | false | |||||||||||||||
| 3058bcf6-be2c-4c8c-a352-cdaae8d6ec65 | 2026-09-11 12:30 | 2026-09-11 12:30 | 2026-09-11 12:30 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 0.8900 | 0.8400 | 0.9100 | 764.8500 | 102404.00 | 88436.00 | 13968.00 | 1157 | 71 | 433818 | 6030 | 71.9432835820895 | 0.141116311780132 | 0.135914312166236 | true | false | false | true | false | |||||||||||||||
| 41069621-e661-4a94-b8d9-f2934b34d991 | 2026-09-11 10:34 | 2026-09-11 10:34 | 2026-09-11 10:34 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 1.3000 | 1.2900 | 1.3100 | 764.8000 | 136631.00 | 136501.00 | 130.00 | 1051 | 9 | 180842 | 6030 | 29.9903814262023 | 0.15902848937519 | 0.158883610739857 | false | false | false | true | false | |||||||||||||||
| 521ebbd9-6a23-421d-87ab-b18601143868 | 2026-09-11 09:40 | 2026-09-11 09:40 | 2026-09-11 09:40 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 1.3400 | 1.2300 | 1.6500 | 765.6300 | 126264.00 | 41618.00 | 83019.00 | 945 | 111 | 29152 | 6030 | 4.83449419568823 | 0.197018416121689 | 0.195603449946344 | true | false | false | true | false | |||||||||||||||
| 86b44320-0440-44a6-a35e-168a64c11719 | 2026-09-11 09:31 | 2026-09-11 09:31 | 2026-09-11 09:31 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 1.9400 | 1.9300 | 1.9500 | 764.0000 | 176852.00 | 176659.00 | 193.00 | 910 | 61 | 3099 | 6030 | 0.513930348258706 | 0.194967023600353 | 0.196190098230163 | false | false | false | true | false | |||||||||||||||
| 116c37eb-23f6-42ab-8c05-0228ed655806 | 2026-09-08 15:48 | 2026-09-08 15:48 | 2026-09-08 15:48 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 2.8600 | 2.8600 | 2.8800 | 766.4199 | 144144.00 | 0.00 | 144144.00 | 504 | 11 | 13496 | 6541 | 2.06329307445345 | 0.131057995423334 | 0.131057995423334 | false | false | false | true | false | |||||||||||||||
| 8aec7519-faad-4775-9f3f-2f3956565f8e | 2026-09-02 13:01 | 2026-09-02 13:01 | 2026-09-02 13:01 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 4.8400 | 4.8400 | 4.8600 | 765.2500 | 121487.00 | 0.00 | 120032.00 | 251 | 11 | 4155 | 3128 | 1.32832480818414 | 0.111124257294929 | 0.110914957494958 | false | false | false | true | false | |||||||||||||||
| 32d9cbfb-a1ba-493c-be46-d1ad63da215a | 2026-09-02 10:59 | 2026-09-02 10:59 | 2026-09-02 10:59 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 5.0100 | 4.9900 | 5.0100 | 765.2450 | 125250.00 | 125250.00 | 0.00 | 250 | 6 | 2442 | 3128 | 0.780690537084399 | 0.114423791042522 | 0.114423791042522 | false | false | false | true | false | |||||||||||||||
| d51c2518-811c-4767-a56a-9d0936da052d | 2026-09-02 10:43 | 2026-09-02 10:43 | 2026-09-02 10:43 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 4.6200 | 4.6200 | 4.6500 | 766.0400 | 115500.00 | 0.00 | 115500.00 | 250 | 9 | 1486 | 3128 | 0.475063938618926 | 0.11376523927828 | 0.113858903703529 | false | false | false | true | false | |||||||||||||||
| 76371ad8-5d91-4145-a87b-cbe4b7804559 | 2026-09-01 09:31 | 2026-09-01 09:31 | 2026-09-01 09:31 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 7.2600 | 7.2600 | 7.4500 | 761.4500 | 145277.00 | 55979.00 | 89298.00 | 200 | 10 | 629 | 3542 | 0.177583286278938 | 0.114848386420085 | 0.114848386420085 | false | false | false | true | false | |||||||||||||||
| 03170402-cfc8-478b-bcff-0a315f2edb0d | 2026-08-31 16:11 | 2026-08-31 16:10 | 2026-08-31 16:10 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 4.3200 | 4.2900 | 4.3200 | 767.4900 | 216000.00 | 216000.00 | 0.00 | 500 | 7 | 3802 | 2812 | 1.35206258890469 | 0.110363728372897 | 0.110363728372897 | false | false | false | true | false | |||||||||||||||
| 9ee27afd-cfae-4039-8cf6-c79a761d098c | 2026-08-24 15:21 | 2026-08-24 15:21 | 2026-08-24 15:21 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 7.9200 | 7.9100 | 7.9500 | 764.1225 | 487789.00 | 0.00 | 487789.00 | 616 | 24 | 1469 | 1749 | 0.839908519153802 | 0.121094457883681 | 0.120946617658576 | true | false | false | true | false | |||||||||||||||
| b273b854-12d0-4079-98ab-68c37f30cd23 | 2026-08-24 09:30 | 2026-08-24 09:30 | 2026-08-24 09:30 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 8.2000 | 8.2000 | 8.2400 | 763.9200 | 210744.00 | 0.00 | 210744.00 | 257 | 19 | 258 | 1749 | 0.147512864493997 | 0.123927116247306 | 0.12377928899287 | false | false | false | true | false | |||||||||||||||
| e694bced-ba61-49f8-a91f-a86c432b0ce5 | 2026-08-21 09:39 | 2026-08-21 09:39 | 2026-08-21 09:39 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 8.2700 | 8.2600 | 8.3100 | 764.8500 | 124050.00 | 0.00 | 124050.00 | 150 | 5 | 201 | 1351 | 0.148778682457439 | 0.1232309420879 | 0.1232309420879 | false | false | false | true | false | |||||||||||||||
| 870dbb47-619f-48a3-af80-ac877b566a6b | 2026-08-17 16:08 | 2026-08-17 16:06 | 2026-08-17 16:06 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 6.2500 | 6.2400 | 6.2600 | 772.4500 | 214375.00 | 54375.00 | 137500.00 | 343 | 8 | 1245 | 1197 | 1.04010025062657 | 0.128327024813679 | 0.128327024813679 | false | false | false | true | false | |||||||||||||||
| d89a52f9-6694-4fe9-8bc5-9de88fa9b2aa | 2026-08-17 13:36 | 2026-08-17 13:35 | 2026-08-17 13:35 | SPY | SPY260911P00765000 | put | 765.0000 | 2026-09-11 | 6.2000 | 6.1200 | 6.2000 | 773.3900 | 381920.00 | 381920.00 | 0.00 | 616 | 24 | 710 | 1197 | 0.593149540517962 | 0.13201830102819 | 0.13201830102819 | false | false | false | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 810275044553.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T17:27:08.545704Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 810275044553.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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 810275044553.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 |
| — |
| 810275044553.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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 810275044553.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 810275044553.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:46:58.036194Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 810275044553.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:37:33.609039Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 810275044553.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T17:36:40.694178Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:04:15.415728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:34:32.417809Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:34:32.417809Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:38:06.174043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:43:10.748747Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 802935622223.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |