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_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 |
|---|
| dba90c20-819b-4cfb-a409-a1fde9f57866 | 2026-09-23 10:08 | 2026-09-23 10:08 | 2026-09-23 10:08 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 3.2100 | 3.2000 | 3.3000 | 383.6165 | 11895.00 | 0.00 | 11895.00 | 37 | 5 | 18919 | 396 | 47.7752525252525 | 0.599608200846142 | 0.618616987931418 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 1501301955407.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T14:09:27.878659Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 6df7c81e-59ae-4e1e-9150-4403905605e5 | 2026-09-23 10:09 | 2026-09-23 10:08 | 2026-09-23 10:08 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 3.4000 | 3.3500 | 3.4500 | 383.2200 | 10545.00 | 10545.00 | 0.00 | 31 | 11 | 19271 | 396 | 48.6641414141414 | 0.612433283663073 | 0.622395439765113 | false | false | false | true | ||||||||||||||||
| 746eddf3-34b4-41f7-ae07-7b4fe30d5361 | 2026-09-23 10:09 | 2026-09-23 10:09 | 2026-09-23 10:09 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 3.7600 | 3.6000 | 3.9000 | 382.5000 | 16180.00 | 8285.00 | 7895.00 | 43 | 12 | 19667 | 396 | 49.6641414141414 | 0.610994572255017 | 0.582742319621032 | true | false | false | true | ||||||||||||||||
| 1563faaa-ddff-43c2-8270-a01fae7de628 | 2026-09-23 10:09 | 2026-09-23 10:09 | 2026-09-23 10:09 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 4.0100 | 3.9000 | 4.0500 | 382.1900 | 53725.00 | 53725.00 | 0.00 | 134 | 13 | 19852 | 396 | 50.1313131313131 | 0.609720988150381 | 0.605811034429493 | true | false | false | true | ||||||||||||||||
| 993a407a-57c1-4bf8-b225-93a219b71f2f | 2026-09-23 10:09 | 2026-09-23 10:09 | 2026-09-23 10:09 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 4.1200 | 4.1000 | 4.2000 | 382.1300 | 14020.00 | 416.00 | 12774.00 | 34 | 8 | 20129 | 396 | 50.8308080808081 | 0.608628992397558 | 0.617129535479367 | false | false | false | true | ||||||||||||||||
| 6cd1853a-2512-466e-b6fa-eb7cf3b2b5e7 | 2026-09-23 10:10 | 2026-09-23 10:10 | 2026-09-23 10:10 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 4.0200 | 4.0000 | 4.2500 | 382.0250 | 11654.00 | 1248.00 | 10406.00 | 29 | 10 | 20494 | 396 | 51.7525252525253 | 0.626149824986514 | 0.59991205120947 | false | false | false | true | ||||||||||||||||
| db4eb987-e9b2-4ebd-9bd5-1d8a84feadb2 | 2026-09-23 10:10 | 2026-09-23 10:10 | 2026-09-23 10:10 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 4.2800 | 4.2500 | 4.4000 | 381.8800 | 19245.00 | 0.00 | 19245.00 | 45 | 5 | 20741 | 396 | 52.3762626262626 | 0.617267126596668 | 0.6114896502678 | true | false | false | true | ||||||||||||||||
| 4320298d-ce5e-478f-83ed-d7baf9de471a | 2026-09-23 10:10 | 2026-09-23 10:10 | 2026-09-23 10:10 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 4.0200 | 4.0000 | 4.2000 | 382.1450 | 12867.00 | 2039.00 | 10828.00 | 32 | 12 | 20831 | 396 | 52.6035353535354 | 0.607584309529303 | 0.609359315715692 | false | false | false | true | ||||||||||||||||
| 885e94eb-c031-45f8-b743-7c332f920d6c | 2026-09-23 10:10 | 2026-09-23 10:10 | 2026-09-23 10:10 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 4.2000 | 4.1000 | 4.2000 | 382.1550 | 10078.00 | 10078.00 | 0.00 | 24 | 5 | 20968 | 396 | 52.9494949494949 | 0.639503453336824 | 0.642304463750934 | false | false | false | true | ||||||||||||||||
| 4e97f43a-df92-43fc-93cf-ef75b17adf51 | 2026-09-23 10:10 | 2026-09-23 10:10 | 2026-09-23 10:10 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 4.2500 | 4.1500 | 4.3000 | 382.0100 | 12741.00 | 11495.00 | 1246.00 | 30 | 8 | 21054 | 396 | 53.1666666666667 | 0.630752990001431 | 0.643000645399602 | false | false | false | true | ||||||||||||||||
| de97bd7b-dd6f-4068-ae07-edb0cf2dd222 | 2026-09-23 10:11 | 2026-09-23 10:11 | 2026-09-23 10:11 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 4.7100 | 4.6500 | 4.8000 | 381.0000 | 101680.00 | 7680.00 | 94000.00 | 216 | 17 | 21434 | 396 | 54.1262626262626 | 0.645982658939109 | 0.636241036405715 | false | false | false | true | ||||||||||||||||
| 1c63f704-b2bf-4edd-8e7d-caf02346cb14 | 2026-09-23 10:11 | 2026-09-23 10:11 | 2026-09-23 10:11 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 4.8000 | 4.7000 | 4.8000 | 381.0000 | 11040.00 | 11040.00 | 0.00 | 23 | 5 | 21458 | 396 | 54.1868686868687 | 0.631871959055216 | 0.631871959055216 | false | false | false | true | ||||||||||||||||
| a9245206-6e76-4d2c-adb7-37acb56e4b74 | 2026-09-23 10:11 | 2026-09-23 10:11 | 2026-09-23 10:11 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 5.0000 | 4.7500 | 5.0000 | 381.0000 | 38000.00 | 38000.00 | 0.00 | 76 | 13 | 21689 | 396 | 54.770202020202 | 0.651274631825378 | 0.651274631825378 | false | false | false | true | ||||||||||||||||
| 2a8e84c0-6071-468d-97b9-24a39c8217dc | 2026-09-23 10:11 | 2026-09-23 10:11 | 2026-09-23 10:11 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 4.8700 | 4.7000 | 4.9000 | 381.0000 | 219335.00 | 106330.00 | 113005.00 | 450 | 13 | 22153 | 396 | 55.9419191919192 | 0.67101130689969 | 0.643123733809845 | false | false | false | true | ||||||||||||||||
| 2f7a1553-3b7c-4c0c-97c1-a175ee42b9f1 | 2026-09-23 10:12 | 2026-09-23 10:11 | 2026-09-23 10:11 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 4.3000 | 4.2500 | 4.4500 | 381.9200 | 14622.00 | 0.00 | 14622.00 | 34 | 10 | 22474 | 396 | 56.7525252525253 | 0.610731460335563 | 0.626744541223421 | false | false | false | true | ||||||||||||||||
| 96ece1bd-267e-4af2-8841-4533b72499db | 2026-09-23 10:12 | 2026-09-23 10:12 | 2026-09-23 10:12 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 4.5000 | 4.4000 | 4.5000 | 381.7000 | 89926.00 | 89926.00 | 0.00 | 200 | 30 | 22819 | 396 | 57.6237373737374 | 0.618603219246617 | 0.635432831354038 | false | false | false | true | ||||||||||||||||
| 07ded113-ada9-41f2-9306-ce1521fc7ead | 2026-09-23 10:14 | 2026-09-23 10:14 | 2026-09-23 10:14 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 4.6500 | 4.6500 | 4.7500 | 381.0000 | 56265.00 | 0.00 | 56265.00 | 121 | 7 | 23103 | 396 | 58.3409090909091 | 0.596908546446362 | 0.632067295510589 | true | false | false | true | ||||||||||||||||
| aba6fbba-b29f-46d1-a0b8-212897fc49ca | 2026-09-23 10:21 | 2026-09-23 10:21 | 2026-09-23 10:21 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 4.9000 | 4.9000 | 5.0000 | 380.8050 | 12250.00 | 0.00 | 12250.00 | 25 | 6 | 25119 | 396 | 63.4318181818182 | 0.568185925157428 | 0.568185925157428 | false | false | false | true | ||||||||||||||||
| 99c1ae9d-9b0c-4c9f-839e-f42dca961b8c | 2026-09-23 10:22 | 2026-09-23 10:21 | 2026-09-23 10:21 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 5.2300 | 5.1000 | 5.3000 | 380.3700 | 11495.00 | 11495.00 | 0.00 | 22 | 8 | 25175 | 396 | 63.5732323232323 | 0.571037252226821 | 0.589965514401146 | true | false | false | true | ||||||||||||||||
| e31f9c91-3cb2-4d55-8d6b-8967ca104c7b | 2026-09-23 10:36 | 2026-09-23 10:36 | 2026-09-23 10:36 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 5.9000 | 5.6500 | 5.9000 | 379.6000 | 28320.00 | 28320.00 | 0.00 | 48 | 9 | 26014 | 396 | 65.6919191919192 | 0.593814596722714 | 0.593814596722714 | true | false | false | true | ||||||||||||||||
| a853fed0-387b-4f47-b226-e64565a721cc | 2026-09-23 15:28 | 2026-09-23 15:28 | 2026-09-23 15:28 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 5.1000 | 5.0500 | 5.2000 | 379.0000 | 13260.00 | 2040.00 | 11220.00 | 26 | 5 | 28517 | 396 | 72.0126262626263 | 1.12073464056944 | 0.821857635684287 | false | false | false | true | ||||||||||||||||
| ab860831-1e03-4a9f-b6af-9d0df90b2095 | 2026-09-23 15:54 | 2026-09-23 15:53 | 2026-09-23 15:53 | TSLA | TSLA260923P00385000 | put | 385.0000 | 2026-09-23 | 4.8000 | 4.8000 | 5.1000 | 380.1550 | 16800.00 | 0.00 | 16800.00 | 35 | 17 | 28702 | 396 | 72.479797979798 | 3.22593618950183 | 3.22593618950183 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:09:27.878659Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:10:43.742349Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:10:43.742349Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:10:43.742349Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:10:43.742349Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:10:43.742349Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:10:43.742349Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:10:43.742349Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:10:43.742349Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:11:43.770446Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:11:43.770446Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:11:43.770446Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:11:43.770446Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:13:13.809395Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:13:13.809395Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:14:46.490149Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:21:45.775363Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:22:47.791063Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:37:43.750009Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:31:17.816750Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1501301955407.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:54:40.302966Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |