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 | 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 |
|---|
| 97de431f-cd6e-4d55-80cd-92192131c043 | 2026-09-21 14:12 | 2026-09-21 14:12 | 2026-09-21 14:12 | IWM | IWM260921C00285000 | call | 285.0000 | 2026-09-21 | 0.9800 | 0.9800 | 1.0200 | 285.9650 | 22050.00 | 0.00 | 22050.00 | 225 | 14 | 30601 | 3501 | 8.74064552984862 | 0.144632664316365 | 0.144632664316365 | 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-21T18:15:35.599753Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 95b2869e-9dd7-480f-835e-5f3ef6ba1201 | 2026-09-21 13:47 | 2026-09-21 13:47 | 2026-09-21 13:47 | IWM | IWM260921C00285000 | call | 285.0000 | 2026-09-21 | 0.5200 | 0.5200 | 0.5400 | 285.4000 | 22360.00 | 0.00 | 22360.00 | 430 | 30 | 27254 | 3501 | 7.78463296201085 | 0.150956058928744 | 0.150956058928744 | false | false | false | true | ||||||||||||||||
| 5a79fe03-e6fb-4aa9-883f-3a451d033ac9 | 2026-09-21 13:44 | 2026-09-21 13:43 | 2026-09-21 13:43 | IWM | IWM260921C00285000 | call | 285.0000 | 2026-09-21 | 0.5100 | 0.5000 | 0.5200 | 285.0000 | 12750.00 | 11322.00 | 0.00 | 250 | 5 | 26034 | 3501 | 7.43616109682948 | 0.146979723307288 | 0.146979723307288 | false | false | false | true | ||||||||||||||||
| 85775eff-6aae-4194-a035-953a613ef23c | 2026-09-21 13:42 | 2026-09-21 13:42 | 2026-09-21 13:42 | IWM | IWM260921C00285000 | call | 285.0000 | 2026-09-21 | 0.4700 | 0.4600 | 0.4800 | 285.3500 | 16967.00 | 8037.00 | 4324.00 | 361 | 25 | 25445 | 3501 | 7.26792345044273 | 0.138822045460859 | 0.138822045460859 | true | false | false | true | ||||||||||||||||
| a3952430-7090-4c29-853f-3c4793e5686d | 2026-09-21 13:38 | 2026-09-21 13:38 | 2026-09-21 13:38 | IWM | IWM260921C00285000 | call | 285.0000 | 2026-09-21 | 0.4600 | 0.4600 | 0.4800 | 285.0000 | 17066.00 | 0.00 | 17066.00 | 371 | 30 | 24669 | 3501 | 7.04627249357327 | 0.137153707993855 | 0.137153707993855 | false | false | false | true | ||||||||||||||||
| 45297146-0644-4547-af8d-22887a72b8e8 | 2026-09-21 13:38 | 2026-09-21 13:38 | 2026-09-21 13:38 | IWM | IWM260921C00285000 | call | 285.0000 | 2026-09-21 | 0.4600 | 0.4600 | 0.4800 | 285.0000 | 10672.00 | 0.00 | 10672.00 | 232 | 13 | 24298 | 3501 | 6.94030277063696 | 0.137153707993855 | 0.137153707993855 | false | false | false | true | ||||||||||||||||
| 723fff64-2aaa-4859-bce0-27973fcfdcbe | 2026-09-21 12:54 | 2026-09-21 12:54 | 2026-09-21 12:54 | IWM | IWM260921C00285000 | call | 285.0000 | 2026-09-21 | 0.8300 | 0.8200 | 0.8400 | 285.0000 | 12455.00 | 6894.00 | 5561.00 | 150 | 5 | 22389 | 3501 | 6.39502999143102 | 0.161559719936632 | 0.168147307673191 | false | false | false | true | ||||||||||||||||
| 6b3d061e-7899-4b12-8e37-9e1d54692e90 | 2026-09-21 12:52 | 2026-09-21 12:52 | 2026-09-21 12:52 | IWM | IWM260921C00285000 | call | 285.0000 | 2026-09-21 | 0.7900 | 0.7900 | 0.8200 | 285.0000 | 27176.00 | 0.00 | 27176.00 | 344 | 31 | 22198 | 3501 | 6.34047415024279 | 0.144668147507253 | 0.144668147507253 | true | false | false | true | ||||||||||||||||
| dbcabd3b-8c07-4b1c-8466-44b202c43a97 | 2026-09-21 11:14 | 2026-09-21 11:14 | 2026-09-21 11:14 | IWM | IWM260921C00285000 | call | 285.0000 | 2026-09-21 | 1.1300 | 1.1300 | 1.1500 | 286.0350 | 22600.00 | 0.00 | 22600.00 | 200 | 8 | 18448 | 3501 | 5.26935161382462 | 0.157858482995198 | 0.157858482995198 | false | false | false | true | ||||||||||||||||
| c0cb81a0-37cf-41a2-a0ce-d101d2df3b73 | 2026-09-21 11:00 | 2026-09-21 11:00 | 2026-09-21 11:00 | IWM | IWM260921C00285000 | call | 285.0000 | 2026-09-21 | 0.6700 | 0.6700 | 0.6800 | 285.4500 | 20100.00 | 0.00 | 20100.00 | 300 | 27 | 16515 | 3501 | 4.7172236503856 | 0.147646267846937 | 0.147646267846937 | true | false | false | true | ||||||||||||||||
| 223ce343-765f-4893-89ea-89e7dcff8e46 | 2026-09-21 10:26 | 2026-09-21 10:26 | 2026-09-21 10:26 | IWM | IWM260921C00285000 | call | 285.0000 | 2026-09-21 | 1.0000 | 0.9900 | 1.0100 | 285.8100 | 10015.00 | 1515.00 | 0.00 | 100 | 5 | 13626 | 3501 | 3.89203084832905 | 0.173809256660255 | 0.169466874928066 | false | false | false | true | ||||||||||||||||
| 507722cd-84eb-4900-9ee4-f9eb7576ec85 | 2026-09-21 10:25 | 2026-09-21 10:25 | 2026-09-21 10:25 | IWM | IWM260921C00285000 | call | 285.0000 | 2026-09-21 | 1.0500 | 1.0400 | 1.0500 | 285.8600 | 10815.00 | 10815.00 | 0.00 | 103 | 5 | 13055 | 3501 | 3.72893459011711 | 0.17452425405461 | 0.17452425405461 | false | false | false | true | ||||||||||||||||
| 010d829d-3f99-4000-bfe2-bae174852ad9 | 2026-09-21 10:19 | 2026-09-21 10:19 | 2026-09-21 10:19 | IWM | IWM260921C00285000 | call | 285.0000 | 2026-09-21 | 1.0000 | 0.9900 | 1.0000 | 285.8200 | 15300.00 | 15300.00 | 0.00 | 153 | 12 | 12185 | 3501 | 3.48043416166809 | 0.164284372052808 | 0.164284372052808 | false | false | false | true | ||||||||||||||||
| 59da09c9-35ec-4c6a-b5ab-a77ed716c6eb | 2026-09-21 10:17 | 2026-09-21 10:17 | 2026-09-21 10:17 | IWM | IWM260921C00285000 | call | 285.0000 | 2026-09-21 | 0.8800 | 0.8800 | 0.8900 | 285.6701 | 17601.00 | 89.00 | 17512.00 | 200 | 5 | 11553 | 3501 | 3.29991431019709 | 0.157107204117158 | 0.16410809670606 | false | false | false | true | ||||||||||||||||
| 493510b6-1eaf-4d3b-a2d1-048669512840 | 2026-09-21 10:16 | 2026-09-21 10:16 | 2026-09-21 10:16 | IWM | IWM260921C00285000 | call | 285.0000 | 2026-09-21 | 0.8600 | 0.8400 | 0.8600 | 285.6200 | 17200.00 | 17200.00 | 0.00 | 200 | 6 | 11116 | 3501 | 3.17509283061982 | 0.165952158463469 | 0.165952158463469 | false | false | false | true | ||||||||||||||||
| ca46b089-3a68-4406-98bf-4f1bfde9bc40 | 2026-09-21 10:04 | 2026-09-21 10:04 | 2026-09-21 10:04 | IWM | IWM260921C00285000 | call | 285.0000 | 2026-09-21 | 0.7700 | 0.7700 | 0.7800 | 285.4500 | 13783.00 | 0.00 | 13783.00 | 179 | 7 | 9115 | 3501 | 2.60354184518709 | 0.171999536879038 | 0.171999536879038 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:50:05.863152Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:46:19.788598Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:43:51.748700Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:39:31.841992Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:39:31.841992Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:56:43.151057Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:56:43.151057Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:16:13.769524Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:02:30.535242Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:26:48.053449Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:26:48.053449Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:20:57.602674Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:18:27.541285Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:18:27.541285Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:04:59.983035Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |