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 |
|---|
| 91830de9-1470-4649-a97c-8089def50113 | 2026-09-21 15:56 | 2026-09-21 15:56 | 2026-09-21 15:56 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 7.1200 | 7.0200 | 7.1200 | 285.7100 | 41296.00 | 41296.00 | 0.00 | 58 | 12 | 78 | 1 | 78 | 0.175179646796335 | 0.175179646796335 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 78247032269.00 | — | — | — | 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 |
| 4fe97c4a-7fd2-4fdb-aeb6-59e6c047324d | 2026-09-22 13:45 | 2026-09-22 13:45 | 2026-09-22 13:45 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 8.1600 | 8.0700 | 8.1600 | 287.2000 | 23664.00 | 23664.00 | 0.00 | 29 | 13 | 43 | 71 | 0.605633802816901 | 0.173761950444239 | 0.173761950444239 | false | false | false | true | ||||||||||||||||
| 21a5b3ba-2cef-46da-9b18-dcaa00d307c6 | 2026-09-28 10:13 | 2026-09-28 10:13 | 2026-09-28 10:13 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 2.3900 | 2.3800 | 2.4300 | 280.4900 | 10516.00 | 0.00 | 10516.00 | 44 | 7 | 227 | 240 | 0.945833333333333 | 0.205797629611666 | 0.205797629611666 | false | false | false | true | ||||||||||||||||
| b5917932-8e18-472b-9573-6935f8c267a2 | 2026-09-28 10:47 | 2026-09-28 10:47 | 2026-09-28 10:47 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 1.9600 | 1.9300 | 1.9600 | 279.5900 | 18620.00 | 18620.00 | 0.00 | 95 | 11 | 382 | 240 | 1.59166666666667 | 0.209012001227556 | 0.209012001227556 | true | false | false | true | ||||||||||||||||
| e862ec25-320b-499f-8bd3-37ec441debbf | 2026-09-29 15:27 | 2026-09-29 15:27 | 2026-09-29 15:27 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 1.2100 | 1.1800 | 1.2100 | 278.0000 | 12100.00 | 12100.00 | 0.00 | 100 | 9 | 1618 | 238 | 6.79831932773109 | 0.206156621239801 | 0.206156621239801 | true | false | false | true | ||||||||||||||||
| 332a5cd8-ae87-43dd-a493-8d53873ee92d | 2026-09-29 16:10 | 2026-09-29 16:10 | 2026-09-29 16:10 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 1.2700 | 1.2400 | 1.2700 | 279.0000 | 25527.00 | 25527.00 | 0.00 | 201 | 10 | 2188 | 238 | 9.19327731092437 | 0.201065852952693 | 0.201065852952693 | false | false | false | true | ||||||||||||||||
| a193ff60-3726-4290-a1df-361e8bd5e43b | 2026-09-30 09:46 | 2026-09-30 09:46 | 2026-09-30 09:46 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 1.1600 | 1.1400 | 1.1600 | 279.5700 | 14808.00 | 14693.00 | 0.00 | 128 | 21 | 749 | 1628 | 0.46007371007371 | 0.229384182628498 | 0.231107975662102 | true | false | false | true | ||||||||||||||||
| dab1331a-251e-490a-ba32-efcc383b2eb9 | 2026-09-30 10:03 | 2026-09-30 10:03 | 2026-09-30 10:03 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 1.0500 | 1.0400 | 1.0600 | 279.5238 | 11235.00 | 5775.00 | 0.00 | 107 | 11 | 1265 | 1628 | 0.777027027027027 | 0.215715885146772 | 0.215715885146772 | true | false | false | true | ||||||||||||||||
| 5666fe96-51fd-4186-98ff-72ff23f7d405 | 2026-09-30 10:53 | 2026-09-30 10:53 | 2026-09-30 10:53 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 1.3000 | 1.2800 | 1.3000 | 280.0000 | 64810.00 | 64681.00 | 0.00 | 500 | 34 | 3735 | 1628 | 2.29422604422604 | 0.213189462921073 | 0.214900382848328 | false | false | false | true | ||||||||||||||||
| 3dc00c68-fde0-4976-9cf0-c2b2f3c84542 | 2026-09-30 10:54 | 2026-09-30 10:54 | 2026-09-30 10:54 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 1.3000 | 1.2900 | 1.3000 | 280.0000 | 37050.00 | 37050.00 | 0.00 | 285 | 6 | 4021 | 1628 | 2.46990171990172 | 0.214461132705382 | 0.214461132705382 | false | false | false | true | ||||||||||||||||
| 65ab35c4-5293-4f30-b162-95f9cda222b4 | 2026-09-30 11:48 | 2026-09-30 11:48 | 2026-09-30 11:48 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 0.9400 | 0.9300 | 0.9400 | 279.4450 | 18706.00 | 18706.00 | 0.00 | 199 | 5 | 5554 | 1628 | 3.41154791154791 | 0.202645492470389 | 0.202645492470389 | false | false | false | true | ||||||||||||||||
| b6679331-4494-4ae7-9dca-47f50b264730 | 2026-09-30 13:07 | 2026-09-30 13:07 | 2026-09-30 13:07 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 0.8400 | 0.8400 | 0.8600 | 279.4200 | 23520.00 | 0.00 | 23520.00 | 280 | 9 | 7758 | 1628 | 4.76535626535627 | 0.187079331868178 | 0.187079331868178 | false | false | false | true | ||||||||||||||||
| 397ad87e-19b0-4d48-aef6-abd97f6ddd50 | 2026-09-30 13:26 | 2026-09-30 13:26 | 2026-09-30 13:26 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 0.5900 | 0.5800 | 0.6000 | 278.0000 | 11151.00 | 0.00 | 7906.00 | 189 | 13 | 8501 | 1628 | 5.22174447174447 | 0.192966838162145 | 0.192966838162145 | false | false | false | true | ||||||||||||||||
| f985ce74-ce73-4833-839c-1a471a123d4b | 2026-09-30 13:31 | 2026-09-30 13:31 | 2026-09-30 13:31 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 0.6100 | 0.6100 | 0.6200 | 278.7650 | 24400.00 | 0.00 | 24400.00 | 400 | 10 | 9300 | 1628 | 5.71253071253071 | 0.190215072322146 | 0.190215072322146 | false | false | false | true | ||||||||||||||||
| 534696d3-6c0d-48ac-aa47-fe3c11c06150 | 2026-09-30 15:35 | 2026-09-30 15:35 | 2026-09-30 15:35 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 0.6800 | 0.6700 | 0.6800 | 279.1300 | 17000.00 | 17000.00 | 0.00 | 250 | 43 | 12749 | 1628 | 7.83108108108108 | 0.17926166038263 | 0.17926166038263 | false | false | false | true | ||||||||||||||||
| a9eb027d-60f0-4057-8047-948fb3f09bf0 | 2026-09-30 15:46 | 2026-09-30 15:46 | 2026-09-30 15:46 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 0.6000 | 0.5900 | 0.6000 | 278.9100 | 15000.00 | 15000.00 | 0.00 | 250 | 15 | 13355 | 1628 | 8.20331695331695 | 0.179134008372436 | 0.179134008372436 | false | false | false | true | ||||||||||||||||
| cbb32f60-f407-4bcd-8f97-f1b1d61fdc1d | 2026-09-30 15:57 | 2026-09-30 15:57 | 2026-09-30 15:57 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 0.5100 | 0.4900 | 0.5100 | 278.3950 | 24378.00 | 24378.00 | 0.00 | 478 | 8 | 15679 | 1628 | 9.63083538083538 | 0.193210833593315 | 0.193210833593315 | false | false | false | true | ||||||||||||||||
| 0a67fd31-3444-403b-8216-301343c6ec3c | 2026-09-30 15:59 | 2026-09-30 15:59 | 2026-09-30 15:59 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 0.5100 | 0.5000 | 0.5200 | 278.4050 | 10117.00 | 204.00 | 9862.00 | 200 | 25 | 16191 | 1628 | 9.9453316953317 | 0.192337478919147 | 0.190623887531832 | false | false | false | true | ||||||||||||||||
| e19f73d9-f9d7-4b15-868c-1784fb2942e0 | 2026-09-30 16:00 | 2026-09-30 16:00 | 2026-09-30 16:00 | IWM | IWM261001C00280000 | call | 280.0000 | 2026-10-01 | 0.3900 | 0.3700 | 0.3900 | 277.0000 | 11661.00 | 11661.00 | 0.00 | 299 | 7 | 16794 | 1628 | 10.3157248157248 | 0.195295993228672 | 0.195295993228672 | 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-22T17:49:14.593703Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-28T14:13:51.758637Z"} |
| 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-28T14:48:11.739629Z"} |
| 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 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 77646580500.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:48:29.727743Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77646580500.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:03:52.520300Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 77646580500.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:54:10.101725Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77646580500.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:54:10.101725Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77646580500.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T15:49:50.007553Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77646580500.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T17:09:03.599351Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77646580500.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T17:28:38.119398Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77646580500.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T17:35:36.166637Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77646580500.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:37:24.384434Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77646580500.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:46:40.965849Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77646580500.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:59:18.109572Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 77646580500.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:59:18.109572Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77646580500.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |