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_alerts523,327 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 |
|---|
| 036179db-aec6-4957-8ca1-af15d4a6244b | 2026-09-23 10:09 | 2026-09-23 10:09 | 2026-09-23 10:09 | HOOD | HOOD260925P00121000 | put | 121.0000 | 2026-09-25 | 1.3800 | 1.3400 | 1.4000 | 124.4200 | 15456.00 | 12972.00 | 2484.00 | 112 | 8 | 353 | 1156 | 0.305363321799308 | 0.769865245032184 | 0.764256014865964 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 97010329712.00 | 2026-11-04 | 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 |
| a15e1b09-2b1d-42f9-8317-df93ac1af907 | 2026-09-23 10:24 | 2026-09-23 10:23 | 2026-09-23 10:23 | HOOD | HOOD260925P00121000 | put | 121.0000 | 2026-09-25 | 1.4000 | 1.4000 | 1.4100 | 124.3900 | 33600.00 | 0.00 | 26600.00 | 240 | 40 | 876 | 1156 | 0.757785467128028 | 0.766746121344434 | 0.767677600375124 | false | false | false | |||||||||||||||||
| 4d88f486-e0c6-4f9d-8d9b-f8bdd0be342a | 2026-09-23 10:24 | 2026-09-23 10:23 | 2026-09-23 10:23 | HOOD | HOOD260925P00121000 | put | 121.0000 | 2026-09-25 | 1.3900 | 1.3500 | 1.3900 | 124.3950 | 26966.00 | 25437.00 | 0.00 | 194 | 32 | 636 | 1156 | 0.550173010380623 | 0.765031803076232 | 0.765031803076232 | true | false | false | true | ||||||||||||||||
| 6c7efc43-0aac-46ad-a668-22642261d1a5 | 2026-09-23 10:24 | 2026-09-23 10:24 | 2026-09-23 10:24 | HOOD | HOOD260925P00121000 | put | 121.0000 | 2026-09-25 | 1.4000 | 1.4000 | 1.4100 | 124.4100 | 16660.00 | 0.00 | 16660.00 | 119 | 17 | 1096 | 1156 | 0.948096885813149 | 0.769557632663606 | 0.769557632663606 | true | false | false | |||||||||||||||||
| 4aa1129e-6d6c-463f-b4b2-9c259e62abd4 | 2026-09-23 10:24 | 2026-09-23 10:24 | 2026-09-23 10:24 | HOOD | HOOD260925P00121000 | put | 121.0000 | 2026-09-25 | 1.4000 | 1.4000 | 1.4100 | 124.4100 | 24220.00 | 0.00 | 24220.00 | 173 | 16 | 1269 | 1156 | 1.0977508650519 | 0.769557632663606 | 0.769557632663606 | true | false | false | true | ||||||||||||||||
| dbce78f7-4905-42e8-b4be-835a174bdacf | 2026-09-23 10:24 | 2026-09-23 10:24 | 2026-09-23 10:24 | HOOD | HOOD260925P00121000 | put | 121.0000 | 2026-09-25 | 1.4000 | 1.4000 | 1.4100 | 124.4900 | 12740.00 | 0.00 | 12740.00 | 91 | 17 | 1360 | 1156 | 1.17647058823529 | 0.777054668250123 | 0.777054668250123 | false | false | false | true | ||||||||||||||||
| 0e087dec-f311-4ccf-9d8c-410324ce31c0 | 2026-09-23 10:31 | 2026-09-23 10:31 | 2026-09-23 10:31 | HOOD | HOOD260925P00121000 | put | 121.0000 | 2026-09-25 | 1.6300 | 1.6000 | 1.6400 | 123.6440 | 16300.00 | 16300.00 | 0.00 | 100 | 9 | 1576 | 1156 | 1.36332179930796 | 0.764892858039812 | 0.764892858039812 | false | false | false | true | ||||||||||||||||
| 4c45f7b3-4c6a-4df9-b0f1-cad0bd41470c | 2026-09-23 10:55 | 2026-09-23 10:55 | 2026-09-23 10:55 | HOOD | HOOD260925P00121000 | put | 121.0000 | 2026-09-25 | 1.0300 | 1.0300 | 1.0600 | 125.2900 | 12875.00 | 0.00 | 12875.00 | 125 | 13 | 1883 | 1156 | 1.62889273356401 | 0.728121604718012 | 0.728121604718012 | true | false | false | true | ||||||||||||||||
| 408e376f-dd8b-4862-9d2c-a8b2b6283a64 | 2026-09-24 09:58 | 2026-09-24 09:58 | 2026-09-24 09:58 | HOOD | HOOD260925P00121000 | put | 121.0000 | 2026-09-25 | 2.0300 | 1.9900 | 2.0600 | 120.9400 | 20300.00 | 15834.00 | 4466.00 | 100 | 11 | 640 | 1614 | 0.396530359355638 | 0.794435436817601 | 0.794435436817601 | false | false | false | |||||||||||||||||
| 833f085a-ccab-4cfc-8dde-177565be9cbb | 2026-09-24 09:58 | 2026-09-24 09:58 | 2026-09-24 09:58 | HOOD | HOOD260925P00121000 | put | 121.0000 | 2026-09-25 | 2.0300 | 2.0200 | 2.0800 | 120.8601 | 13398.00 | 6699.00 | 6699.00 | 66 | 6 | 783 | 1614 | 0.485130111524164 | 0.778650435172002 | 0.778650435172002 | false | false | false | |||||||||||||||||
| 60a849af-f60c-4a19-8288-3ba37f928811 | 2026-09-24 09:58 | 2026-09-24 09:58 | 2026-09-24 09:58 | HOOD | HOOD260925P00121000 | put | 121.0000 | 2026-09-25 | 2.0300 | 2.0200 | 2.1000 | 120.8500 | 33495.00 | 29029.00 | 4466.00 | 165 | 15 | 948 | 1614 | 0.587360594795539 | 0.778650435172002 | 0.776639084317425 | false | false | false | |||||||||||||||||
| dae8c3d1-21c0-44c2-8d60-6ddc1e6a0199 | 2026-09-24 09:58 | 2026-09-24 09:58 | 2026-09-24 09:58 | HOOD | HOOD260925P00121000 | put | 121.0000 | 2026-09-25 | 2.0300 | 2.0200 | 2.0800 | 120.8600 | 17864.00 | 13398.00 | 4466.00 | 88 | 8 | 1036 | 1614 | 0.641883519206939 | 0.778630538767013 | 0.778630538767013 | false | false | false | |||||||||||||||||
| 986c1865-4040-436a-879c-c07f467165f3 | 2026-09-24 10:25 | 2026-09-24 10:25 | 2026-09-24 10:25 | HOOD | HOOD260925P00121000 | put | 121.0000 | 2026-09-25 | 1.4400 | 1.3500 | 1.4400 | 122.3300 | 14400.00 | 14400.00 | 0.00 | 100 | 13 | 1347 | 1614 | 0.83457249070632 | 0.803749569608766 | 0.803749569608766 | false | false | false | |||||||||||||||||
| 55ce99c8-deb1-4410-b47e-5be8c44a9c19 | 2026-09-24 15:42 | 2026-09-24 15:42 | 2026-09-24 15:42 | HOOD | HOOD260925P00121000 | put | 121.0000 | 2026-09-25 | 1.8600 | 1.8600 | 1.9000 | 120.0000 | 10044.00 | 0.00 | 10044.00 | 54 | 21 | 3679 | 1614 | 2.27942998760843 | 0.705261629784946 | 0.705261629784946 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:24:55.903933Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:24:55.903933Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:24:55.903933Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:24:55.903933Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:24:55.903933Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:33:43.718875Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:57:22.994560Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:59:25.813942Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:59:25.813942Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:59:25.813942Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:59:25.813942Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:28:24.219175Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 97010329712.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |