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_alerts566,287 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 |
|---|
| 586549aa-a605-40bb-92f9-b7bf291268dd | 2026-09-22 11:06 | 2026-09-22 11:06 | 2026-09-22 11:06 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 8.7900 | 8.7200 | 8.7900 | 286.0000 | 72957.00 | 72957.00 | 0.00 | 83 | 9 | 222 | 300 | 0.74 | 0.180523403172699 | 0.180147884175229 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 75910909701.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T15:10:39.659738Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| c0f7524a-4315-43f7-bd46-13976c3ad1e0 | 2026-09-22 11:43 | 2026-09-22 11:43 | 2026-09-22 11:43 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 8.5800 | 8.5200 | 8.5800 | 286.2950 | 42900.00 | 42900.00 | 0.00 | 50 | 9 | 348 | 300 | 1.16 | 0.178743151461277 | 0.178743151461277 | false | false | false | true | ||||||||||||||||
| 23cf1d8a-a185-44e5-af56-0ba12117fae0 | 2026-09-22 12:58 | 2026-09-22 12:58 | 2026-09-22 12:58 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 9.1500 | 9.0900 | 9.1500 | 287.0301 | 63135.00 | 63135.00 | 0.00 | 69 | 9 | 440 | 300 | 1.46666666666667 | 0.179688743366189 | 0.179688743366189 | false | false | false | true | ||||||||||||||||
| 425d9f26-d12e-4a96-9cde-41c139a01576 | 2026-09-24 12:13 | 2026-09-24 12:13 | 2026-09-24 12:13 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 4.0200 | 3.9700 | 4.0200 | 279.0000 | 10050.00 | 10050.00 | 0.00 | 25 | 5 | 167 | 623 | 0.268057784911718 | 0.184512223728874 | 0.184512223728874 | false | false | false | true | ||||||||||||||||
| 8cc4bf1c-3fad-45e4-8459-9be70a073bb1 | 2026-09-28 11:58 | 2026-09-28 11:58 | 2026-09-28 11:58 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 3.4300 | 3.4000 | 3.4400 | 279.1300 | 33957.00 | 20923.00 | 13034.00 | 99 | 6 | 375 | 786 | 0.477099236641221 | 0.19063569366841 | 0.19063569366841 | true | false | false | true | ||||||||||||||||
| 3300eaa7-6a4c-483a-86a7-e996614fa123 | 2026-09-28 12:01 | 2026-09-28 12:01 | 2026-09-28 12:01 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 3.4500 | 3.4500 | 3.4700 | 279.2000 | 20700.00 | 0.00 | 16560.00 | 60 | 6 | 435 | 786 | 0.553435114503817 | 0.189912845880382 | 0.189912845880382 | true | false | false | true | ||||||||||||||||
| 4dcaf55e-9842-4867-9eca-be7438560ed7 | 2026-09-28 12:02 | 2026-09-28 12:02 | 2026-09-28 12:02 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 3.4700 | 3.4400 | 3.4800 | 279.2000 | 32271.00 | 19779.00 | 12492.00 | 93 | 9 | 528 | 786 | 0.67175572519084 | 0.190947735024694 | 0.190947735024694 | true | false | false | true | ||||||||||||||||
| 9e2d24dd-64b5-4c92-862c-cfa18f4b4112 | 2026-09-28 12:06 | 2026-09-28 12:06 | 2026-09-28 12:06 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 3.4800 | 3.4500 | 3.4900 | 279.2150 | 32712.00 | 10092.00 | 20532.00 | 94 | 17 | 622 | 786 | 0.791348600508906 | 0.191087049723994 | 0.191087049723994 | true | false | false | true | ||||||||||||||||
| 2da4aa92-4894-41cd-9091-a2b14253fddf | 2026-09-28 12:09 | 2026-09-28 12:09 | 2026-09-28 12:09 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 3.5100 | 3.4700 | 3.5100 | 279.2800 | 28080.00 | 28080.00 | 0.00 | 80 | 12 | 702 | 786 | 0.893129770992366 | 0.190995082743123 | 0.190995082743123 | false | false | false | true | ||||||||||||||||
| b1d09665-72d8-4a15-8d61-a33ede9154b6 | 2026-09-28 12:26 | 2026-09-28 12:26 | 2026-09-28 12:26 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 4.3700 | 4.2600 | 4.3700 | 280.8600 | 79534.00 | 79534.00 | 0.00 | 182 | 7 | 1053 | 786 | 1.33969465648855 | 0.192644526210738 | 0.192644526210738 | false | false | false | true | ||||||||||||||||
| b4130470-8cff-40ea-9022-d19150097863 | 2026-09-28 12:28 | 2026-09-28 12:28 | 2026-09-28 12:28 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 4.5800 | 4.5800 | 4.6500 | 281.2200 | 38014.00 | 0.00 | 32976.00 | 83 | 6 | 1158 | 786 | 1.47328244274809 | 0.192986796947944 | 0.192986796947944 | true | false | false | true | ||||||||||||||||
| cbb451d3-76ab-4c8d-8927-286aa01b33c8 | 2026-09-28 12:30 | 2026-09-28 12:30 | 2026-09-28 12:30 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 4.3900 | 4.3900 | 4.4400 | 280.0000 | 39071.00 | 0.00 | 39071.00 | 89 | 6 | 1318 | 786 | 1.67684478371501 | 0.19252307138679 | 0.19252307138679 | true | false | false | true | ||||||||||||||||
| e26df373-4f99-41d4-bcce-89ef7a7a2bef | 2026-09-28 12:38 | 2026-09-28 12:38 | 2026-09-28 12:38 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 4.0700 | 4.0300 | 4.0900 | 280.3250 | 28083.00 | 17094.00 | 10989.00 | 69 | 6 | 1462 | 786 | 1.86005089058524 | 0.192244804440506 | 0.192244804440506 | true | false | false | true | ||||||||||||||||
| d69b197e-0b5e-481e-898e-c3155d23bd70 | 2026-09-28 12:46 | 2026-09-28 12:46 | 2026-09-28 12:46 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 4.0600 | 4.0100 | 4.0600 | 280.0000 | 15428.00 | 15428.00 | 0.00 | 38 | 5 | 1622 | 786 | 2.06361323155216 | 0.193520868360034 | 0.193520868360034 | false | false | false | true | ||||||||||||||||
| 66e3a274-cb89-472b-bd4b-ea596639b7b4 | 2026-09-29 15:22 | 2026-09-29 15:22 | 2026-09-29 15:22 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 3.1300 | 3.1100 | 3.1300 | 278.0000 | 10955.00 | 10955.00 | 0.00 | 35 | 5 | 729 | 2036 | 0.358055009823183 | 0.190123088667574 | 0.190123088667574 | false | false | false | true | ||||||||||||||||
| 079696d3-b0e6-4eac-8528-99a144d05a3c | 2026-09-29 15:55 | 2026-09-29 15:55 | 2026-09-29 15:55 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 3.1300 | 3.1000 | 3.1300 | 278.9050 | 12833.00 | 12833.00 | 0.00 | 41 | 9 | 812 | 2036 | 0.398821218074656 | 0.190507415531205 | 0.190251244594052 | false | false | false | true | ||||||||||||||||
| b5ceb762-663b-43fd-80fb-1f4d67ac9678 | 2026-09-29 15:57 | 2026-09-29 15:57 | 2026-09-29 15:57 | IWM | IWM261009C00280000 | call | 280.0000 | 2026-10-09 | 3.1800 | 3.1600 | 3.1800 | 279.0000 | 33072.00 | 33072.00 | 0.00 | 104 | 10 | 936 | 2036 | 0.459724950884086 | 0.190398322978016 | 0.190139772417353 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:49:01.734970Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:59:26.444099Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77607608234.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:13:55.044964Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:05:35.930466Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:05:35.930466Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:05:35.930466Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:11:09.473635Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:11:09.473635Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:26:41.677786Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:28:39.612628Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:31:36.529249Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:39:53.834597Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:49:03.667640Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |