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_alerts728,802 rows| iduuid | created_at ↓timestamp with time zone | start_timetimestamp with time zone | end_timetimestamp with time zone | tickertext | option_symboltext | option_typetext | strikenumeric |
|---|
| 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 |
|---|
| 2ec656df-8a46-4a8d-ad77-d3f9f40afa9a | 2026-10-02 12:11 | 2026-10-02 12:10 | 2026-10-02 12:10 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 4.2500 | 4.0000 | 4.2500 | 729.4700 | 31875.00 | 31875.00 | 0.00 | 75 | 19 | 5432 | 442 | 12.289592760181 | 0.422610437326609 | 0.402741199834556 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1605509964833.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-10-02T16:12:03.837742Z"} | 2026-10-02 | 2026-10-02 21:15 | 2026-10-02 21:15 |
| 509cc7ae-9a69-45e4-a8d0-733f61b246f6 | 2026-10-02 11:04 | 2026-10-02 11:04 | 2026-10-02 11:04 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 3.8000 | 3.6000 | 3.8500 | 731.0000 | 13300.00 | 11400.00 | 1900.00 | 35 | 16 | 4817 | 442 | 10.8981900452489 | 0.459837407709788 | 0.459837407709788 | true | false | false | |||||||||||||||||
| 66676560-344b-4d1f-86d7-b59bb9920be9 | 2026-10-02 10:47 | 2026-10-02 10:47 | 2026-10-02 10:47 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 2.5600 | 2.3900 | 2.7200 | 733.8500 | 21766.00 | 20992.00 | 264.00 | 85 | 20 | 4272 | 442 | 9.66515837104072 | 0.469376476243812 | 0.459906437699237 | true | false | false | |||||||||||||||||
| 9cfe501e-27a7-4bc6-9dbb-4a12003b7a29 | 2026-10-02 10:39 | 2026-10-02 10:38 | 2026-10-02 10:38 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 3.3000 | 3.3000 | 3.5000 | 732.5573 | 106590.00 | 0.00 | 106590.00 | 323 | 54 | 3317 | 442 | 7.50452488687783 | 0.441787831972995 | 0.462077328817667 | false | false | false | |||||||||||||||||
| cc73417c-b0aa-4899-b0b5-56cc44f6e67a | 2026-10-01 15:32 | 2026-10-01 15:32 | 2026-10-01 15:32 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 8.7500 | 8.7500 | 8.9500 | 728.2500 | 13125.00 | 0.00 | 13125.00 | 15 | 6 | 1325 | 421 | 3.14726840855107 | 0.423084148892101 | 0.423084148892101 | false | false | false | |||||||||||||||||
| 27ad74bb-c769-4045-878f-e74d380b4c7d | 2026-10-01 12:25 | 2026-10-01 12:25 | 2026-10-01 12:25 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 8.9000 | 8.8000 | 9.0500 | 729.0000 | 11570.00 | 0.00 | 10680.00 | 13 | 11 | 890 | 421 | 2.11401425178147 | 0.470981439093546 | 0.470981439093546 | true | false | false | |||||||||||||||||
| c0711923-044f-4451-9840-bdd4799d1306 | 2026-10-01 12:24 | 2026-10-01 12:24 | 2026-10-01 12:24 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 9.3000 | 9.2000 | 9.4000 | 728.0000 | 46500.00 | 9300.00 | 37200.00 | 50 | 5 | 877 | 421 | 2.08313539192399 | 0.46066661554616 | 0.46066661554616 | true | false | false | |||||||||||||||||
| 9e16bb80-f889-44f7-a004-e72d19b28d4a | 2026-10-01 12:18 | 2026-10-01 12:17 | 2026-10-01 12:17 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 9.4000 | 9.3500 | 9.5500 | 728.3201 | 14100.00 | 0.00 | 14100.00 | 15 | 7 | 815 | 421 | 1.93586698337292 | 0.469780174501487 | 0.469780174501487 | false | false | false | |||||||||||||||||
| f1164497-3b9d-4a31-9242-b5127c446649 | 2026-10-01 11:20 | 2026-10-01 11:20 | 2026-10-01 11:20 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 9.0500 | 8.8000 | 9.0500 | 729.9000 | 13575.00 | 13575.00 | 0.00 | 15 | 10 | 713 | 421 | 1.69358669833729 | 0.505985772350623 | 0.505985772350623 | false | false | false | |||||||||||||||||
| 09e41e2d-27ed-44a9-885e-c9465b3fb86f | 2026-09-30 15:08 | 2026-09-30 15:08 | 2026-09-30 15:08 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 8.9500 | 8.7500 | 8.9500 | 734.4800 | 102028.00 | 102028.00 | 0.00 | 114 | 38 | 1472 | 387 | 3.80361757105943 | 0.460704845617097 | 0.46102410434239 | true | false | false | |||||||||||||||||
| 331de632-1273-4ce9-9f40-f6b9d062d5de | 2026-09-30 11:37 | 2026-09-30 11:36 | 2026-09-30 11:36 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 9.7500 | 9.2500 | 9.7500 | 733.5250 | 19500.00 | 19500.00 | 0.00 | 20 | 5 | 630 | 387 | 1.62790697674419 | 0.477414062658918 | 0.477414062658918 | false | false | false | |||||||||||||||||
| b558ac01-d5a5-48cb-82ed-6a96320a8800 | 2026-09-30 09:40 | 2026-09-30 09:39 | 2026-09-30 09:39 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 13.2500 | 13.2500 | 13.7000 | 727.9900 | 33125.00 | 0.00 | 33125.00 | 25 | 5 | 217 | 387 | 0.560723514211886 | 0.507339654002258 | 0.507339654002258 | true | false | false | |||||||||||||||||
| deb4a4d7-6c7a-44e1-a29a-90bae55a5136 | 2026-09-29 15:54 | 2026-09-29 15:54 | 2026-09-29 15:54 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 10.0500 | 10.0500 | 10.1500 | 736.8241 | 15075.00 | 0.00 | 15075.00 | 15 | 6 | 825 | 258 | 3.19767441860465 | 0.455968675738075 | 0.459171109131607 | false | false | false | |||||||||||||||||
| c80b88c9-c61e-4ac3-82bd-f408f02f625c | 2026-09-29 15:26 | 2026-09-29 15:26 | 2026-09-29 15:26 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 12.1500 | 12.0500 | 12.2000 | 732.0000 | 15795.00 | 14580.00 | 1215.00 | 13 | 8 | 693 | 258 | 2.68604651162791 | 0.467159572362267 | 0.467159572362267 | false | false | false | |||||||||||||||||
| 168a8629-e1fc-4bfb-915e-7cee31052140 | 2026-09-29 13:47 | 2026-09-29 13:47 | 2026-09-29 13:47 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 15.0500 | 15.0500 | 15.4000 | 727.0550 | 10535.00 | 0.00 | 10535.00 | 7 | 6 | 278 | 258 | 1.07751937984496 | 0.465136659130659 | 0.465136659130659 | true | false | false | |||||||||||||||||
| 362cc33f-f60b-4234-be43-c04dc9308a2a | 2026-09-29 12:56 | 2026-09-29 12:56 | 2026-09-29 12:56 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 18.9000 | 18.9000 | 19.3000 | 720.0000 | 34020.00 | 0.00 | 34020.00 | 18 | 5 | 167 | 258 | 0.647286821705426 | 0.4670984363747 | 0.4670984363747 | false | false | false | |||||||||||||||||
| 4f84606a-a6e9-4ab0-a103-b8869c7188cc | 2026-09-25 15:35 | 2026-09-25 15:35 | 2026-09-25 15:35 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 8.5500 | 8.5500 | 8.7000 | 751.1900 | 59850.00 | 0.00 | 59850.00 | 70 | 16 | 440 | 104 | 4.23076923076923 | 0.40064560481844 | 0.40064560481844 | true | false | false | true | ||||||||||||||||
| 0dea7c71-f1b2-4f42-9971-b6aae59ec4b7 | 2026-09-25 13:44 | 2026-09-25 13:44 | 2026-09-25 13:44 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 9.2000 | 9.2000 | 9.6000 | 748.8201 | 29440.00 | 0.00 | 29440.00 | 32 | 13 | 336 | 104 | 3.23076923076923 | 0.397748087338732 | 0.397748087338732 | false | false | false | |||||||||||||||||
| 41e40ef3-b0be-47b0-be4e-144843fea6f3 | 2026-09-25 12:16 | 2026-09-25 12:16 | 2026-09-25 12:16 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 8.9000 | 8.8000 | 8.9000 | 750.2200 | 13345.00 | 12460.00 | 0.00 | 15 | 9 | 227 | 104 | 2.18269230769231 | 0.401865903713075 | 0.401865903713075 | true | false | false | |||||||||||||||||
| 9e2bdb78-237c-4524-afad-a80cd9f714ee | 2026-09-25 09:53 | 2026-09-25 09:52 | 2026-09-25 09:52 | META | META261002P00732500 | put | 732.5000 | 2026-10-02 | 8.0000 | 8.0000 | 8.2000 | 756.7350 | 12800.00 | 0.00 | 12800.00 | 16 | 7 | 70 | 104 | 0.673076923076923 | 0.430639473783124 | 0.430639473783124 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1605509964833.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T15:06:05.796781Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1605509964833.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T14:49:11.588051Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1605509964833.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T14:42:10.052390Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1600768938538.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T19:36:48.028615Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1600768938538.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T16:26:23.818189Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1600768938538.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T16:26:23.818189Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1600768938538.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T16:19:31.014528Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1600768938538.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T15:23:18.156629Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:08:45.785033Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T15:39:24.450847Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:41:13.731534Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:57:26.018295Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:28:18.151130Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:52:12.020508Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1629126891164.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:01:16.214882Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 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-25T19:35:55.847824Z"} |
| 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-25T17:50:01.932714Z"} |
| 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-25T16:18:06.291601Z"} |
| 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:54:35.682199Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |