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_alerts708,051 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 |
|---|
| 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 |
|---|
| 2217ba9d-6512-4aa4-ae12-22e5f08c02ae | 2026-09-14 10:22 | 2026-09-14 10:22 | 2026-09-14 10:22 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.7000 | 3.6500 | 3.7100 | 288.0000 | 1510201.00 | 1464469.00 | 45732.00 | 4084 | 42 | 4193 | 87696 | 0.0478128991060026 | 0.219289548039474 | 0.219659467867307 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 78377484640.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9d232394-056a-42f0-ada9-a3ec5f1f3c6a | 2026-09-23 09:43 | 2026-09-23 09:43 | 2026-09-23 09:43 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 2.9100 | 2.8800 | 2.9100 | 284.4000 | 107562.00 | 106692.00 | 870.00 | 370 | 28 | 3083 | 109979 | 0.0280326244101147 | 0.17875948264387 | 0.179143818400465 | false | false | false | |||||||||||||||||
| 4e4c5e8f-dcfe-45bd-90e1-990c3bff0291 | 2026-09-23 12:11 | 2026-09-23 12:11 | 2026-09-23 12:11 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.5500 | 3.5200 | 3.5600 | 283.0000 | 397534.00 | 397179.00 | 355.00 | 1120 | 71 | 12424 | 109979 | 0.112967020976732 | 0.184171069245784 | 0.184400804104095 | false | false | false | |||||||||||||||||
| b61c53cc-429d-4708-9eca-0a0da8be6bb6 | 2026-09-23 12:59 | 2026-09-23 12:59 | 2026-09-23 12:59 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.9200 | 3.8900 | 3.9200 | 282.4600 | 257609.00 | 249789.00 | 7820.00 | 658 | 25 | 20384 | 109979 | 0.18534447485429 | 0.189924671266608 | 0.190290305955593 | false | false | false | |||||||||||||||||
| 92c63ba5-c167-42fe-ab57-af15c05dae9c | 2026-09-23 15:44 | 2026-09-23 15:44 | 2026-09-23 15:44 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.9400 | 3.9100 | 3.9500 | 282.0000 | 591637.00 | 591637.00 | 0.00 | 1500 | 35 | 27247 | 109979 | 0.247747297211286 | 0.186184528192919 | 0.186548704640924 | true | false | false | |||||||||||||||||
| 9c162e1d-5cc8-4e59-9f86-14b3da0c8b56 | 2026-09-23 15:58 | 2026-09-23 15:58 | 2026-09-23 15:58 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.9900 | 3.9500 | 3.9900 | 282.0000 | 19948.00 | 19551.00 | 0.00 | 50 | 7 | 28253 | 109979 | 0.256894498040535 | 0.185795355088586 | 0.186522704201927 | true | false | false | |||||||||||||||||
| 21ab87fb-6634-4403-baf6-32eae5aa985f | 2026-09-23 15:59 | 2026-09-23 15:59 | 2026-09-23 15:59 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 4.0000 | 3.9600 | 4.0200 | 281.0000 | 21999.00 | 2399.00 | 19600.00 | 55 | 8 | 28401 | 109979 | 0.25824020949454 | 0.185927784397383 | 0.186291260739521 | false | false | false | |||||||||||||||||
| 62c40a8b-3c90-4fd6-a060-770df96c00df | 2026-09-24 09:42 | 2026-09-24 09:42 | 2026-09-24 09:42 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 4.5100 | 4.4600 | 4.5100 | 280.6700 | 43284.00 | 43284.00 | 0.00 | 96 | 7 | 607 | 119415 | 0.00508311351170289 | 0.187733504565193 | 0.187935461844655 | false | false | false | |||||||||||||||||
| 2eb88aea-9f1c-47c1-9d80-c723b84737ee | 2026-09-28 15:18 | 2026-09-28 15:18 | 2026-09-28 15:18 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 4.4300 | 4.4300 | 4.4500 | 280.1800 | 23944.00 | 1776.00 | 15064.00 | 54 | 15 | 9456 | 108626 | 0.0870509822694383 | 0.193227688399519 | 0.193631940645747 | true | false | false | |||||||||||||||||
| 6c5356a8-8ea1-4d62-aa15-557980d77540 | 2026-09-29 11:47 | 2026-09-29 11:47 | 2026-09-29 11:47 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 5.4000 | 5.3900 | 5.4600 | 277.9100 | 107915.00 | 0.00 | 107915.00 | 200 | 17 | 5163 | 106004 | 0.0487057092185201 | 0.190291954710265 | 0.191133440064532 | false | false | false | |||||||||||||||||
| 10edfc22-9381-4823-bd2b-e09580d84b30 | 2026-09-29 12:02 | 2026-09-29 12:02 | 2026-09-29 12:02 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 5.5100 | 5.4900 | 5.5300 | 277.7450 | 19295.00 | 11581.00 | 7714.00 | 35 | 6 | 5473 | 106004 | 0.0516301271650126 | 0.191531979453131 | 0.191953669259837 | false | false | false | |||||||||||||||||
| 7061eca9-f068-493e-94b9-cc600eea9897 | 2026-10-01 14:07 | 2026-10-01 14:07 | 2026-10-01 14:07 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 5.1600 | 5.1100 | 5.1700 | 278.3250 | 186358.00 | 173483.00 | 12875.00 | 361 | 10 | 5800 | 94582 | 0.0613224503605337 | 0.20028222247687 | 0.200728154705409 | false | false | false | |||||||||||||||||
| c115e32d-9133-4df7-8494-4188eddb0c39 | 2026-10-01 14:32 | 2026-10-01 14:32 | 2026-10-01 14:32 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 4.5900 | 4.5800 | 4.6200 | 279.2600 | 68827.00 | 0.00 | 68827.00 | 150 | 9 | 5966 | 94582 | 0.0630775411811973 | 0.196494198115952 | 0.196936977528017 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:13:15.432740Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:01:20.516262Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:47:37.737983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 77607608234.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:45:09.673618Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:23:02.177643Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:47:25.537370Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 77189908994.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:02:30.295749Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 78041729433.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T18:11:48.742897Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 78041729433.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T18:34:07.959250Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |