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_alerts658,639 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 |
|---|
| 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 |
|---|
| 82d16e83-809a-4e81-a1d8-11a8e1f1f515 | 2026-10-01 15:54 | 2026-10-01 15:54 | 2026-10-01 15:54 | IWM | IWM261120C00282000 | call | 282.0000 | 2026-11-20 | 7.4200 | 7.4200 | 7.4600 | 279.0400 | 12614.00 | 0.00 | 12614.00 | 17 | 5 | 1174 | 421 | 2.78859857482185 | 0.195394899747915 | 0.195691085463607 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 78041729433.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-10-01T19:55:17.865094Z"} | 2026-10-01 | 2026-10-01 21:15 | 2026-10-01 21:15 |
| 63e33ccd-8c0d-4151-9d60-7d19364ea4b5 | 2026-10-01 13:57 | 2026-10-01 13:57 | 2026-10-01 13:57 | IWM | IWM261120C00282000 | call | 282.0000 | 2026-11-20 | 7.5500 | 7.5500 | 7.5800 | 279.0800 | 30955.00 | 0.00 | 30955.00 | 41 | 5 | 1075 | 421 | 2.55344418052257 | 0.198016759272506 | 0.198373096600304 | false | false | false | |||||||||||||||||
| cbe85768-541f-4262-bbd3-88866a9f0ad7 | 2026-10-01 12:51 | 2026-10-01 12:51 | 2026-10-01 12:51 | IWM | IWM261120C00282000 | call | 282.0000 | 2026-11-20 | 7.4900 | 7.4900 | 7.5100 | 278.9600 | 35952.00 | 0.00 | 35952.00 | 48 | 6 | 710 | 421 | 1.68646080760095 | 0.198337787258587 | 0.198337787258587 | true | false | false | |||||||||||||||||
| a1ce59e4-184c-4623-8e44-eda882b7d7a1 | 2026-10-01 12:35 | 2026-10-01 12:35 | 2026-10-01 12:35 | IWM | IWM261120C00282000 | call | 282.0000 | 2026-11-20 | 7.5300 | 7.5100 | 7.5700 | 278.9700 | 38403.00 | 2259.00 | 36144.00 | 51 | 9 | 578 | 421 | 1.3729216152019 | 0.199191135776231 | 0.199191135776231 | false | false | false | |||||||||||||||||
| 9088ddd0-ddd0-40c9-ab13-10bebbc150d7 | 2026-10-01 12:28 | 2026-10-01 12:27 | 2026-10-01 12:27 | IWM | IWM261120C00282000 | call | 282.0000 | 2026-11-20 | 7.2900 | 7.2900 | 7.3300 | 278.5300 | 50301.00 | 0.00 | 50301.00 | 69 | 9 | 501 | 421 | 1.19002375296912 | 0.198520063910357 | 0.198520063910357 | false | false | false | |||||||||||||||||
| c302fc3a-be99-47f2-86c8-85af9f6891c7 | 2026-10-01 10:37 | 2026-10-01 10:37 | 2026-10-01 10:37 | IWM | IWM261120C00282000 | call | 282.0000 | 2026-11-20 | 6.3100 | 6.3100 | 6.3200 | 276.6600 | 24609.00 | 0.00 | 24609.00 | 39 | 9 | 297 | 421 | 0.705463182897862 | 0.195563860895163 | 0.195563860895163 | false | false | false | |||||||||||||||||
| 2da47672-d751-4809-a0e0-9088e70b7108 | 2026-10-01 10:25 | 2026-10-01 10:25 | 2026-10-01 10:25 | IWM | IWM261120C00282000 | call | 282.0000 | 2026-11-20 | 6.2900 | 6.2900 | 6.3400 | 276.3940 | 55352.00 | 0.00 | 55352.00 | 88 | 6 | 257 | 421 | 0.610451306413302 | 0.197959997413072 | 0.197959997413072 | false | false | false | |||||||||||||||||
| 163dbd3f-cc49-4aa9-8d43-fb15b4fa2eb7 | 2026-10-01 09:59 | 2026-10-01 09:59 | 2026-10-01 09:59 | IWM | IWM261120C00282000 | call | 282.0000 | 2026-11-20 | 6.3500 | 6.3500 | 6.3900 | 276.7350 | 15240.00 | 0.00 | 15240.00 | 24 | 6 | 157 | 421 | 0.3729216152019 | 0.195734329103209 | 0.195734329103209 | false | false | false | |||||||||||||||||
| 28970119-2a23-4e62-a505-ce5a6e704f1f | 2026-10-01 09:54 | 2026-10-01 09:54 | 2026-10-01 09:54 | IWM | IWM261120C00282000 | call | 282.0000 | 2026-11-20 | 6.5100 | 6.5100 | 6.5600 | 277.1800 | 61194.00 | 0.00 | 61194.00 | 94 | 8 | 129 | 421 | 0.306413301662708 | 0.194780231125199 | 0.194780231125199 | false | false | false | |||||||||||||||||
| 6e7a0fe7-24cf-470c-851e-b353b6d78c57 | 2026-09-29 09:30 | 2026-09-29 09:30 | 2026-09-29 09:30 | IWM | IWM261120C00282000 | call | 282.0000 | 2026-11-20 | 8.0900 | 8.0900 | 8.2600 | 280.3100 | 23462.00 | 0.00 | 23462.00 | 29 | 6 | 29 | 350 | 0.0828571428571429 | 0.191795936256229 | 0.191795936256229 | true | false | false | |||||||||||||||||
| 2462c9b7-0a3c-4fad-b569-97ed4219a912 | 2026-09-28 11:46 | 2026-09-28 11:46 | 2026-09-28 11:46 | IWM | IWM261120C00282000 | call | 282.0000 | 2026-11-20 | 7.4400 | 7.4400 | 7.4800 | 278.8900 | 38688.00 | 0.00 | 38688.00 | 52 | 16 | 64 | 304 | 0.210526315789474 | 0.190824537211367 | 0.19105569202477 | true | false | false | |||||||||||||||||
| 2eb59929-cb15-4950-8c4a-c93cc2f8e49c | 2026-09-24 12:24 | 2026-09-24 12:24 | 2026-09-24 12:24 | IWM | IWM261120C00282000 | call | 282.0000 | 2026-11-20 | 9.1100 | 9.0100 | 9.1300 | 281.2100 | 18220.00 | 18220.00 | 0.00 | 20 | 10 | 35 | 0 | 0 | 0.194735833305199 | 0.193830296579382 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78041729433.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T17:57:58.010467Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78041729433.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T16:54:14.233260Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78041729433.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T16:38:56.603549Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78041729433.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T16:32:04.219379Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78041729433.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T14:39:17.807457Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78041729433.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T14:26:19.726349Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78041729433.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:59:25.903362Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78041729433.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:54:23.923373Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:31:03.669649Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:53:41.284908Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 77607608234.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:27:48.650295Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |