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 | 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 |
|---|
| fb87d263-8634-43b3-b6f6-aa746ddfa71f | 2026-09-21 10:07 | 2026-09-21 10:07 | 2026-09-21 10:07 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 4.1000 | 4.0000 | 4.1000 | 374.7400 | 39360.00 | 39360.00 | 0.00 | 96 | 9 | 948 | 765 | 1.23921568627451 | 0.465150611848753 | 0.464917474000705 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 1482265136968.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:08:15.762043Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 2bb69a7a-de07-45e4-a396-1459664f455b | 2026-09-22 10:58 | 2026-09-22 10:58 | 2026-09-22 10:58 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 2.4500 | 2.4500 | 2.4800 | 376.5000 | 12250.00 | 0.00 | 12250.00 | 50 | 11 | 1493 | 1386 | 1.07720057720058 | 0.440640572902176 | 0.440640572902176 | false | false | false | true | ||||||||||||||||
| adf804a2-236e-44f0-b0bc-792542ca74e2 | 2026-09-22 15:47 | 2026-09-22 15:47 | 2026-09-22 15:47 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.6100 | 1.6100 | 1.6400 | 379.5850 | 31395.00 | 0.00 | 31395.00 | 195 | 7 | 3944 | 1386 | 2.84559884559885 | 0.427400442990291 | 0.427400442990291 | false | false | false | true | ||||||||||||||||
| be642fe7-bbc9-4337-8db2-2c3628263f6d | 2026-09-23 14:44 | 2026-09-23 14:44 | 2026-09-23 14:44 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.0100 | 1.0000 | 1.0100 | 380.0899 | 20112.00 | 11312.00 | 8800.00 | 200 | 15 | 5126 | 1597 | 3.20976831559173 | 0.450463394555168 | 0.449629039622989 | false | false | false | |||||||||||||||||
| 150624f6-d7ed-4fd8-8c98-1dce85ab4f86 | 2026-09-23 14:57 | 2026-09-23 14:57 | 2026-09-23 14:57 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.0200 | 1.0000 | 1.0200 | 379.8700 | 20400.00 | 20400.00 | 0.00 | 200 | 9 | 5671 | 1597 | 3.55103318722605 | 0.447605001374729 | 0.447605001374729 | false | false | false | true | ||||||||||||||||
| 52a9c4f0-e567-4fb4-9406-166a3088cd01 | 2026-09-23 15:09 | 2026-09-23 15:09 | 2026-09-23 15:09 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 0.9800 | 0.9600 | 0.9800 | 380.2300 | 15778.00 | 15778.00 | 0.00 | 161 | 5 | 6221 | 1597 | 3.89542892924233 | 0.449763522760393 | 0.449763522760393 | false | false | false | true | ||||||||||||||||
| b8b3ac25-0feb-4107-9112-68bb613d047d | 2026-09-23 15:22 | 2026-09-23 15:22 | 2026-09-23 15:22 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 0.9900 | 0.9700 | 0.9900 | 379.9995 | 19800.00 | 19800.00 | 0.00 | 200 | 5 | 6740 | 1597 | 4.22041327489042 | 0.446037559901279 | 0.446037559901279 | false | false | false | true | ||||||||||||||||
| 6c3260e6-3339-4222-8324-e5d531d67eb4 | 2026-09-24 15:52 | 2026-09-24 15:52 | 2026-09-24 15:52 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 0.3000 | 0.3000 | 0.3100 | 380.0499 | 17940.00 | 0.00 | 17940.00 | 598 | 28 | 20256 | 1979 | 10.2354724608388 | 0.44934767317139 | 0.44934767317139 | false | false | false | true | ||||||||||||||||
| abb4bdb8-c48d-407a-a8d0-c3c9c3ee0110 | 2026-09-25 09:34 | 2026-09-25 09:34 | 2026-09-25 09:34 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.1200 | 1.0800 | 1.1300 | 373.0000 | 16800.00 | 16800.00 | 0.00 | 150 | 9 | 3751 | 4129 | 0.908452409784451 | 0.783873959094127 | 0.783873959094127 | false | false | false | |||||||||||||||||
| 185ca59b-6a1e-411c-a58f-04b78faeee99 | 2026-09-25 09:36 | 2026-09-25 09:36 | 2026-09-25 09:36 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.5000 | 1.3300 | 1.5200 | 371.9200 | 21899.00 | 18999.00 | 2900.00 | 146 | 13 | 4862 | 4129 | 1.17752482441269 | 0.787314012819331 | 0.782238254048966 | false | false | false | |||||||||||||||||
| 2cc1411f-5abb-4091-9495-bb056e06c5e5 | 2026-09-25 09:50 | 2026-09-25 09:50 | 2026-09-25 09:50 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 0.7500 | 0.7500 | 0.7850 | 373.3400 | 31450.00 | 0.00 | 31450.00 | 418 | 8 | 15856 | 4129 | 3.84015500121095 | 0.694816161613526 | 0.702068871249219 | false | false | false | |||||||||||||||||
| 5580d96a-51f7-4e22-86c9-90b66ba1e349 | 2026-09-25 09:51 | 2026-09-25 09:51 | 2026-09-25 09:51 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.0600 | 1.0400 | 1.0700 | 371.8000 | 11557.00 | 535.00 | 11022.00 | 109 | 5 | 17133 | 4129 | 4.14943085492855 | 0.687413201156849 | 0.680703670319034 | false | false | false | |||||||||||||||||
| 92612549-f509-4c38-89d3-e1f514365001 | 2026-09-25 10:04 | 2026-09-25 10:04 | 2026-09-25 10:04 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.2900 | 1.2600 | 1.2900 | 370.0000 | 12899.00 | 12899.00 | 0.00 | 100 | 6 | 25480 | 4129 | 6.17098571082587 | 0.681805268155155 | 0.675234901435357 | false | false | false | |||||||||||||||||
| aad66ff9-63c3-4afd-8426-879f947536f3 | 2026-09-25 10:08 | 2026-09-25 10:08 | 2026-09-25 10:08 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 0.5000 | 0.5000 | 0.5200 | 374.0000 | 13552.00 | 52.00 | 13500.00 | 271 | 5 | 28150 | 4129 | 6.81763138774522 | 0.67009880465409 | 0.678976554050149 | false | false | false | |||||||||||||||||
| afc643e1-d824-4649-9bad-d7c7cf787428 | 2026-09-25 10:18 | 2026-09-25 10:18 | 2026-09-25 10:18 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 0.8200 | 0.8100 | 0.8200 | 372.2700 | 16400.00 | 16400.00 | 0.00 | 200 | 5 | 34283 | 4129 | 8.30297892952289 | 0.670086902753909 | 0.670086902753909 | false | false | false | |||||||||||||||||
| 6b53f6d4-58d9-45d4-b051-8f9686e35506 | 2026-09-25 10:35 | 2026-09-25 10:35 | 2026-09-25 10:35 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.5700 | 1.5400 | 1.5800 | 369.3150 | 12876.00 | 787.00 | 11932.00 | 82 | 7 | 42125 | 4129 | 10.2022281424074 | 0.645281052592844 | 0.649072346367558 | false | false | false | |||||||||||||||||
| dd3b997f-177d-4537-9778-207c310c2080 | 2026-09-25 10:40 | 2026-09-25 10:40 | 2026-09-25 10:40 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.1800 | 1.1800 | 1.2000 | 370.0400 | 10148.00 | 0.00 | 10148.00 | 86 | 14 | 44596 | 4129 | 10.8006781302979 | 0.613298335393515 | 0.613298335393515 | false | false | false | |||||||||||||||||
| 5c45fad1-42bb-4c2b-a6dc-7d1a2dc143c2 | 2026-09-25 10:42 | 2026-09-25 10:41 | 2026-09-25 10:41 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.4500 | 1.4400 | 1.4700 | 369.2501 | 13518.00 | 4818.00 | 8700.00 | 93 | 5 | 45405 | 4129 | 10.9966093485105 | 0.622245467929698 | 0.613931194596395 | false | false | false | |||||||||||||||||
| cb4b6377-01b4-41a4-8bd9-e80f1d6f747d | 2026-09-25 10:43 | 2026-09-25 10:43 | 2026-09-25 10:43 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.8700 | 1.8500 | 1.8800 | 368.2601 | 19635.00 | 8602.00 | 11033.00 | 105 | 7 | 48397 | 4129 | 11.7212400096876 | 0.620088451478775 | 0.620088451478775 | false | false | false | |||||||||||||||||
| 9de0d971-7633-42cf-9737-1c772c194c22 | 2026-09-25 10:44 | 2026-09-25 10:44 | 2026-09-25 10:44 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 2.0400 | 2.0100 | 2.0700 | 367.9100 | 34674.00 | 2648.00 | 32026.00 | 170 | 12 | 50804 | 4129 | 12.3041898764834 | 0.623426479562468 | 0.621304940653182 | false | false | false | |||||||||||||||||
| e5615407-f22f-4d00-9b28-bb4c222a59d2 | 2026-09-25 10:46 | 2026-09-25 10:46 | 2026-09-25 10:46 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 1.9200 | 1.8800 | 1.9200 | 368.2800 | 38784.00 | 38784.00 | 0.00 | 202 | 6 | 52865 | 4129 | 12.803342213611 | 0.639511418539881 | 0.639511418539881 | true | false | false | true | ||||||||||||||||
| 9a90029f-379c-4210-9a2b-c83032710cd4 | 2026-09-25 12:23 | 2026-09-25 12:23 | 2026-09-25 12:23 | TSLA | TSLA260925P00367500 | put | 367.5000 | 2026-09-25 | 0.4000 | 0.3400 | 0.4000 | 371.3000 | 36200.00 | 36200.00 | 0.00 | 905 | 10 | 86429 | 4129 | 20.9321869702107 | 0.551941120966839 | 0.551941120966839 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1496483507587.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:00:53.883267Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1496483507587.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:49:40.866869Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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-23T18:50:04.558688Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| 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-23T18:58:18.142602Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| 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:12:23.721983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| 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:25:57.460829Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| 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-24T19:53:57.742588Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:35:49.891887Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:37:30.150792Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:52:56.276610Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:52:56.276610Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:05:23.720155Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:09:41.700516Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:19:54.895833Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:37:32.022295Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:40:21.587562Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:43:48.295772Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:43:48.295772Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:47:41.799650Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:47:41.799650Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 1469666080781.00 |
| 2026-10-28 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:27:03.681802Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |