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 | strike |
|---|
| 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 |
|---|
| af8cf84c-b397-4821-ad9c-b737c2f2f033 | 2026-09-25 15:11 | 2026-09-25 15:10 | 2026-09-25 15:10 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 28.6500 | 28.6500 | 28.8000 | 752.2740 | 17190.00 | 0.00 | 17190.00 | 6 | 6 | 719 | 328 | 2.19207317073171 | 0.390992379512151 | 0.390992379512151 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1657506895075.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T19:17:13.698421Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 30244203-cc94-48db-9524-bcebd38d7605 | 2026-09-25 11:54 | 2026-09-25 11:54 | 2026-09-25 11:54 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 30.5000 | 30.2500 | 30.6000 | 748.0000 | 88450.00 | 70170.00 | 18280.00 | 29 | 10 | 544 | 328 | 1.65853658536585 | 0.394141007414041 | 0.393012119249398 | true | false | false | |||||||||||||||||
| 19fa747a-dfd0-4f19-8b83-da7a5e816f35 | 2026-09-25 09:40 | 2026-09-25 09:40 | 2026-09-25 09:40 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 28.9500 | 28.9500 | 29.2500 | 754.7050 | 69480.00 | 0.00 | 69480.00 | 24 | 7 | 132 | 328 | 0.402439024390244 | 0.411351334103265 | 0.411351334103265 | true | false | false | |||||||||||||||||
| 8248a16b-fbaa-4cae-a257-9cafaa3a74b7 | 2026-09-25 09:31 | 2026-09-25 09:31 | 2026-09-25 09:31 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 26.6500 | 26.0000 | 26.7000 | 763.4100 | 45310.00 | 45310.00 | 0.00 | 17 | 6 | 54 | 328 | 0.164634146341463 | 0.433106925428441 | 0.434498338459248 | false | false | false | |||||||||||||||||
| ce8e7c6d-09b5-47e3-a1be-f30938f3c906 | 2026-09-25 09:30 | 2026-09-25 09:30 | 2026-09-25 09:30 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 26.3100 | 25.9000 | 26.5000 | 763.5000 | 26310.00 | 23680.00 | 2630.00 | 10 | 6 | 37 | 328 | 0.11280487804878 | 0.431369283684694 | 0.430859799249567 | false | false | false | |||||||||||||||||
| 2fdf47fb-c0c6-43ba-a56f-657f0c6fcead | 2026-09-25 09:30 | 2026-09-25 09:30 | 2026-09-25 09:30 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 25.3000 | 25.3000 | 25.8500 | 766.8684 | 55665.00 | 0.00 | 55665.00 | 22 | 5 | 26 | 328 | 0.0792682926829268 | 0.43463131216706 | 0.435226100297344 | true | false | false | |||||||||||||||||
| fa84197f-3915-40d0-ac6a-06e7fdf1f524 | 2026-09-24 12:29 | 2026-09-24 12:29 | 2026-09-24 12:29 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 25.6100 | 25.3500 | 25.9000 | 768.7200 | 25606.00 | 10232.00 | 15374.00 | 10 | 7 | 229 | 278 | 0.823741007194245 | 0.442823452182229 | 0.439540600315359 | false | false | false | |||||||||||||||||
| 1601e019-c447-4b5d-980c-776f8ca8b5ce | 2026-09-23 15:51 | 2026-09-23 15:51 | 2026-09-23 15:51 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 38.2000 | 37.9500 | 38.2000 | 745.0300 | 38200.00 | 38200.00 | 0.00 | 10 | 5 | 702 | 120 | 5.85 | 0.453560757369049 | 0.453560757369049 | false | false | false | |||||||||||||||||
| 76b4cd90-8094-4741-a198-bf776e61b280 | 2026-09-23 12:29 | 2026-09-23 12:29 | 2026-09-23 12:29 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 33.8500 | 33.8000 | 33.9000 | 756.2900 | 37235.00 | 33850.00 | 3385.00 | 11 | 6 | 588 | 120 | 4.9 | 0.468398638167105 | 0.468858672803216 | false | false | false | |||||||||||||||||
| 8ef540d7-dbc8-4a0b-8d3b-a88a3b3d622c | 2026-09-23 11:37 | 2026-09-23 11:37 | 2026-09-23 11:37 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 34.3700 | 34.0500 | 34.5000 | 754.7800 | 20620.00 | 13765.00 | 6855.00 | 6 | 6 | 500 | 120 | 4.16666666666667 | 0.469434817382119 | 0.467489437550135 | true | false | false | |||||||||||||||||
| 18a35386-165d-4f64-a0e9-ac187ddf8d9b | 2026-09-23 11:29 | 2026-09-23 11:28 | 2026-09-23 11:28 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 33.7500 | 33.5000 | 33.9500 | 755.0000 | 50625.00 | 33750.00 | 16875.00 | 15 | 5 | 465 | 120 | 3.875 | 0.465444001763577 | 0.465444001763577 | false | false | false | |||||||||||||||||
| 8426265c-d94c-479b-83f1-ff8f816520f0 | 2026-09-23 11:23 | 2026-09-23 11:23 | 2026-09-23 11:23 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 34.0100 | 33.9500 | 34.2000 | 754.1450 | 20408.00 | 10208.00 | 10200.00 | 6 | 5 | 324 | 120 | 2.7 | 0.458612398937595 | 0.457550572990762 | true | false | false | |||||||||||||||||
| 6131923e-3049-4408-8924-9ecddc755544 | 2026-09-23 10:03 | 2026-09-23 10:03 | 2026-09-23 10:03 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 33.9000 | 33.4000 | 33.9000 | 755.5700 | 74579.00 | 74579.00 | 0.00 | 22 | 8 | 206 | 120 | 1.71666666666667 | 0.465091015493116 | 0.465091015493116 | false | false | false | |||||||||||||||||
| 77c78c12-5082-48b5-94be-6ca38c648665 | 2026-09-23 09:59 | 2026-09-23 09:59 | 2026-09-23 09:59 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 31.4000 | 31.4000 | 31.6000 | 761.1690 | 31400.00 | 0.00 | 31400.00 | 10 | 5 | 177 | 120 | 1.475 | 0.46557852319361 | 0.46557852319361 | true | false | false | |||||||||||||||||
| 5727da1f-7024-4f5e-8b42-1a2d70ec50d5 | 2026-09-23 09:54 | 2026-09-23 09:53 | 2026-09-23 09:53 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 32.2700 | 32.0000 | 32.3500 | 756.8600 | 25815.00 | 12920.00 | 12895.00 | 8 | 6 | 136 | 120 | 1.13333333333333 | 0.450201659277203 | 0.451789675998326 | true | false | false | |||||||||||||||||
| 63b7f76a-273c-414d-a4b1-d8fd1f334a31 | 2026-09-23 09:46 | 2026-09-23 09:46 | 2026-09-23 09:46 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 34.8500 | 34.4500 | 34.8500 | 750.0000 | 59245.00 | 59245.00 | 0.00 | 17 | 8 | 65 | 120 | 0.541666666666667 | 0.44905189339985 | 0.447364053157149 | false | false | false | |||||||||||||||||
| 61dc5c6f-dcac-49b2-a961-0ae784c6c788 | 2026-09-22 12:00 | 2026-09-22 12:00 | 2026-09-22 12:00 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 33.7000 | 33.7000 | 34.4000 | 753.2850 | 121320.00 | 0.00 | 121320.00 | 36 | 11 | 101 | 85 | 1.18823529411765 | 0.439235877999941 | 0.439235877999941 | false | false | false | |||||||||||||||||
| 55f89f07-aaf7-41d6-9570-9e9825ad978e | 2026-09-21 15:58 | 2026-09-21 15:57 | 2026-09-21 15:57 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 40.8000 | 40.3000 | 40.9000 | 743.8999 | 134640.00 | 122400.00 | 12240.00 | 33 | 17 | 216 | 5 | 43.2 | 0.462201532663666 | 0.462200868114498 | true | false | false | |||||||||||||||||
| d9ac5dc8-84b2-40ab-9641-0506d7dc4493 | 2026-09-21 15:39 | 2026-09-21 15:39 | 2026-09-21 15:39 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 37.8000 | 37.6000 | 37.8000 | 749.2307 | 30240.00 | 30240.00 | 0.00 | 8 | 5 | 177 | 5 | 35.4 | 0.459763725194489 | 0.458192765638232 | true | false | false | |||||||||||||||||
| 056808bb-2cf2-4bf3-91d3-02c72291c18b | 2026-09-21 15:06 | 2026-09-21 15:06 | 2026-09-21 15:06 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 40.2000 | 40.1500 | 40.4500 | 744.6750 | 44220.00 | 16080.00 | 28140.00 | 11 | 8 | 158 | 5 | 31.6 | 0.459606998037185 | 0.459606998037185 | false | false | false | |||||||||||||||||
| 5a3a4bbe-ec12-4911-a418-bb525f616cb3 | 2026-09-21 12:21 | 2026-09-21 12:21 | 2026-09-21 12:21 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 49.3000 | 49.2000 | 49.6000 | 726.1600 | 266240.00 | 34510.00 | 231730.00 | 54 | 19 | 105 | 5 | 21 | 0.444883318778561 | 0.443875584280359 | false | false | false | |||||||||||||||||
| 835f6765-3fe9-4205-b346-bc9d1e050806 | 2026-09-21 12:16 | 2026-09-21 12:15 | 2026-09-21 12:16 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 48.9500 | 48.6500 | 48.9500 | 726.1600 | 48950.00 | 48950.00 | 0.00 | 10 | 5 | 47 | 5 | 9.4 | 0.439105691636981 | 0.439105691636981 | true | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:56:11.622901Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:41:37.814256Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:31:26.059584Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:31:26.059584Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1657506895075.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:31:26.059584Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:32:14.615877Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:31:43.812748Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:41:14.023510Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:31:00.015856Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:23:47.442599Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:04:12.048624Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:00:44.029710Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:55:29.867504Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:47:39.692401Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:00:55.569269Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:43:03.886437Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:25:44.384112Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:17:17.704519Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |