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_alerts609,118 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 |
|---|
| 14922655-06fc-4a3a-b67c-dab69f8a4d32 | 2026-09-22 09:57 | 2026-09-22 09:57 | 2026-09-22 09:57 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 14.2000 | 14.1000 | 14.3000 | 7770.2100 | 34080.00 | 26980.00 | 0.00 | 24 | 6 | 262 | 260 | 1.00769230769231 | 0.118555814524223 | 0.118555814524223 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | — | — | — | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T13:58:41.675080Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 44735cc9-b7da-4514-8395-ea2a5080686f | 2026-09-22 10:19 | 2026-09-22 10:18 | 2026-09-22 10:18 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 15.1000 | 15.1000 | 15.2000 | 7767.7000 | 10570.00 | 0.00 | 10570.00 | 7 | 5 | 475 | 260 | 1.82692307692308 | 0.117617239236144 | 0.117617239236144 | false | false | false | |||||||||||||||||
| f6250de5-d729-4235-9f81-82bd3548bcf4 | 2026-09-22 10:26 | 2026-09-22 10:26 | 2026-09-22 10:26 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 14.1000 | 14.0000 | 14.3000 | 7745.0000 | 194580.00 | 193170.00 | 1410.00 | 138 | 11 | 790 | 260 | 3.03846153846154 | 0.114514240250884 | 0.114514240250884 | false | false | false | |||||||||||||||||
| 372d8032-510b-42f2-9a6e-9ae7ee6b9116 | 2026-09-22 10:54 | 2026-09-22 10:54 | 2026-09-22 10:54 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 15.7000 | 15.6000 | 15.7000 | 7764.9000 | 105190.00 | 105190.00 | 0.00 | 67 | 26 | 1384 | 260 | 5.32307692307692 | 0.113699259342517 | 0.113699259342517 | false | false | false | |||||||||||||||||
| 2e87ff0a-e6e9-45bc-b0c9-e93197d76b20 | 2026-09-22 10:54 | 2026-09-22 10:54 | 2026-09-22 10:54 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 15.7000 | 15.6000 | 15.7000 | 7764.4900 | 185260.00 | 185260.00 | 0.00 | 118 | 17 | 1512 | 260 | 5.81538461538462 | 0.11255038908388 | 0.11255038908388 | false | false | false | |||||||||||||||||
| a5330576-b454-428a-b379-c6e5fb10f214 | 2026-09-22 11:39 | 2026-09-22 11:39 | 2026-09-22 11:39 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 18.4000 | 18.2000 | 18.4000 | 7757.0900 | 55200.00 | 55200.00 | 0.00 | 30 | 5 | 1864 | 260 | 7.16923076923077 | 0.107074826311449 | 0.107074826311449 | false | false | false | |||||||||||||||||
| 0fca70ca-c921-4486-bf5b-da5d28c51396 | 2026-09-22 13:30 | 2026-09-22 13:30 | 2026-09-22 13:30 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 13.7000 | 13.5000 | 13.7000 | 7765.3800 | 20550.00 | 20550.00 | 0.00 | 15 | 5 | 3388 | 260 | 13.0307692307692 | 0.102573617562444 | 0.102573617562444 | false | false | false | |||||||||||||||||
| 2adf91ca-4f39-4614-90f6-bf7a0572329b | 2026-09-22 14:01 | 2026-09-22 14:01 | 2026-09-22 14:01 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 12.0000 | 12.0000 | 12.2000 | 7769.1700 | 30000.00 | 0.00 | 30000.00 | 25 | 5 | 3599 | 260 | 13.8423076923077 | 0.101929293904297 | 0.101929293904297 | false | false | false | |||||||||||||||||
| a4c0dcfd-ca94-417c-aa99-c8e092a6426a | 2026-09-22 14:28 | 2026-09-22 14:28 | 2026-09-22 14:28 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 10.6000 | 10.7000 | 10.8000 | 7771.6400 | 15900.00 | 0.00 | 15900.00 | 15 | 3 | 3779 | 260 | 14.5346153846154 | 0.0991394222212788 | 0.0991394222212788 | false | true | false | |||||||||||||||||
| f0d67245-f836-4bbf-80e4-5c7fc0e97741 | 2026-09-22 15:42 | 2026-09-22 15:42 | 2026-09-22 15:42 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 9.4000 | 9.3000 | 9.4000 | 7773.3200 | 10340.00 | 10340.00 | 0.00 | 11 | 11 | 4447 | 260 | 17.1038461538462 | 0.0953308819647133 | 0.0953308819647133 | false | false | false | |||||||||||||||||
| 62730d23-7a88-4233-9830-859f72cd436d | 2026-09-22 15:56 | 2026-09-22 15:56 | 2026-09-22 15:56 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 11.4000 | 11.1000 | 11.4000 | 7768.2300 | 33060.00 | 33060.00 | 0.00 | 29 | 6 | 4716 | 260 | 18.1384615384615 | 0.0957063856885344 | 0.0957063856885344 | false | false | false | |||||||||||||||||
| d7e98ebc-51c4-4616-9d91-db8fff8b59d0 | 2026-09-23 09:43 | 2026-09-23 09:43 | 2026-09-23 09:43 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 14.6000 | 14.5000 | 14.6000 | 7750.9700 | 14600.00 | 14600.00 | 0.00 | 10 | 5 | 3828 | 2246 | 1.70436331255565 | 0.115377153074898 | 0.115377153074898 | false | false | false | |||||||||||||||||
| 7aaef887-1137-4c0d-bf25-98c623eb019e | 2026-09-23 09:45 | 2026-09-23 09:45 | 2026-09-23 09:45 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 15.4300 | 15.2000 | 15.5000 | 7725.0000 | 16970.00 | 15440.00 | 1530.00 | 11 | 7 | 4034 | 2246 | 1.79608192341941 | 0.0964275438347491 | 0.104844512313791 | false | false | false | |||||||||||||||||
| a152b242-e059-4d44-8c45-a96f3545ec35 | 2026-09-23 09:45 | 2026-09-23 09:45 | 2026-09-23 09:45 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 15.9000 | 15.7000 | 16.0000 | 7725.0000 | 63600.00 | 15900.00 | 47700.00 | 40 | 10 | 4182 | 2246 | 1.8619768477293 | 0.107620270429241 | 0.107620270429241 | false | false | false | |||||||||||||||||
| f673e657-8339-49fe-b703-66cf21a5eb72 | 2026-09-23 09:52 | 2026-09-23 09:51 | 2026-09-23 09:51 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 22.6000 | 22.6000 | 22.8000 | 7740.0600 | 33900.00 | 0.00 | 33900.00 | 15 | 5 | 4866 | 2246 | 2.16651825467498 | 0.118733041078037 | 0.118733041078037 | false | false | false | |||||||||||||||||
| d2c343c6-2bda-42ff-83e6-9083bd296e8e | 2026-09-23 09:53 | 2026-09-23 09:53 | 2026-09-23 09:53 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 21.6000 | 21.5000 | 21.9000 | 7741.2500 | 129600.00 | 99360.00 | 30240.00 | 60 | 9 | 5053 | 2246 | 2.24977738201247 | 0.117889737949274 | 0.117889737949274 | false | false | false | |||||||||||||||||
| b08d5f97-960a-4347-8f5b-3217845fb4ce | 2026-09-23 11:05 | 2026-09-23 11:04 | 2026-09-23 11:04 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 33.2000 | 33.2000 | 33.4000 | 7728.0200 | 26560.00 | 0.00 | 26560.00 | 8 | 5 | 7259 | 2246 | 3.2319679430098 | 0.141787326217192 | 0.141787326217192 | false | false | false | |||||||||||||||||
| cf4cdbda-3ac3-42d2-a232-199fed362b7e | 2026-09-23 11:59 | 2026-09-23 11:59 | 2026-09-23 11:59 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 44.7000 | 44.7000 | 44.9000 | 7715.6100 | 44700.00 | 0.00 | 44700.00 | 10 | 6 | 7688 | 2246 | 3.42297417631345 | 0.155638783645546 | 0.155638783645546 | false | false | false | |||||||||||||||||
| 7ea55f36-df37-4613-ba5f-592cf5d56612 | 2026-09-23 12:16 | 2026-09-23 12:16 | 2026-09-23 12:16 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 44.7000 | 44.5000 | 44.7000 | 7716.3500 | 22350.00 | 22350.00 | 0.00 | 5 | 5 | 7735 | 2246 | 3.44390026714159 | 0.196516389168162 | 0.196516389168162 | false | false | false | |||||||||||||||||
| 5b00c99d-0fdb-45e0-adea-dddb0c2006d2 | 2026-09-23 13:11 | 2026-09-23 13:11 | 2026-09-23 13:11 | SPXW | SPXW260923P07760000 | put | 7760.0000 | 2026-09-23 | 59.2000 | 58.9000 | 59.6000 | 7680.0000 | 29600.00 | 0.00 | 29600.00 | 5 | 5 | 7978 | 2246 | 3.55209260908281 | 0.223648909704428 | 0.223648909704428 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:20:22.518739Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:27:42.600893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:42:55.952799Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:30:55.056187Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:03:20.556132Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:29:55.439380Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:45:53.710169Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:45:53.710169Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:52:21.829557Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| 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 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:09:03.866421Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:00:35.931587Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:19:07.705108Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| — |
| — |
| — |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:17:19.986908Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |