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 |
|---|
| 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 |
|---|
| 67ca94f7-dc67-4800-a859-edd2d1a5f4d3 | 2026-09-15 10:40 | 2026-09-15 10:40 | 2026-09-15 10:40 | IWM | IWM261016P00271000 | put | 271.0000 | 2026-10-16 | 2.3400 | 2.3100 | 2.3400 | 284.7700 | 291947.00 | 291947.00 | 0.00 | 1249 | 5 | 8108 | 6138 | 1.32095144998371 | 0.2329621846564 | 0.2329621846564 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 79887436077.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| f03eeeb7-d820-4881-b1ff-191aacbd90cf | 2026-09-16 09:47 | 2026-09-16 09:47 | 2026-09-16 09:47 | IWM | IWM261016P00271000 | put | 271.0000 | 2026-10-16 | 1.9100 | 1.9100 | 1.9400 | 286.5900 | 635558.00 | 0.00 | 635558.00 | 3327 | 24 | 4828 | 42684 | 0.113110298941055 | 0.233215074734402 | 0.232749622972672 | false | false | false | |||||||||||||||||
| a7d528dc-b36d-437a-ac4c-b412810dfa00 | 2026-09-16 13:51 | 2026-09-16 13:51 | 2026-09-16 13:51 | IWM | IWM261016P00271000 | put | 271.0000 | 2026-10-16 | 1.8400 | 1.8400 | 1.8700 | 286.0000 | 131759.00 | 0.00 | 131759.00 | 715 | 14 | 22048 | 42684 | 0.516540155561803 | 0.228448639547103 | 0.228020825400159 | false | false | false | |||||||||||||||||
| 9cf4ab83-bf87-4709-8f75-c365ad584546 | 2026-09-16 13:51 | 2026-09-16 13:51 | 2026-09-16 13:51 | IWM | IWM261016P00271000 | put | 271.0000 | 2026-10-16 | 1.8400 | 1.8400 | 1.8600 | 286.0000 | 373255.00 | 0.00 | 354200.00 | 2028 | 7 | 24076 | 42684 | 0.564052103832818 | 0.228697702901587 | 0.228228171713995 | false | false | false | |||||||||||||||||
| 95a57038-0629-4043-ab2f-dedb79018b80 | 2026-09-16 13:51 | 2026-09-16 13:51 | 2026-09-16 13:51 | IWM | IWM261016P00271000 | put | 271.0000 | 2026-10-16 | 1.8500 | 1.8500 | 1.8800 | 286.0000 | 352117.00 | 0.00 | 352117.00 | 1899 | 44 | 16473 | 42684 | 0.385929153781276 | 0.228750900424588 | 0.228282533465183 | false | false | false | |||||||||||||||||
| 9c21cfef-149e-4d59-a8cf-513dd65f6bf3 | 2026-09-18 09:44 | 2026-09-18 09:44 | 2026-09-18 09:44 | IWM | IWM261016P00271000 | put | 271.0000 | 2026-10-16 | 1.7400 | 1.7400 | 1.7700 | 283.8800 | 364885.00 | 0.00 | 364885.00 | 2097 | 30 | 4606 | 68770 | 0.06697687945325 | 0.209114370382047 | 0.208643092064956 | false | false | false | |||||||||||||||||
| fd9919cb-100c-435c-8316-775dac4907e5 | 2026-09-21 16:07 | 2026-09-21 16:07 | 2026-09-21 16:07 | IWM | IWM261016P00271000 | put | 271.0000 | 2026-10-16 | 1.1600 | 1.1600 | 1.1800 | 285.0000 | 40136.00 | 0.00 | 26564.00 | 345 | 7 | 25673 | 57263 | 0.448334875923371 | 0.205805938629922 | 0.20521709337318 | false | false | false | |||||||||||||||||
| 210384a9-a424-4785-ad43-b6748bfa7fe5 | 2026-09-21 16:07 | 2026-09-21 16:07 | 2026-09-21 16:07 | IWM | IWM261016P00271000 | put | 271.0000 | 2026-10-16 | 1.1700 | 1.1600 | 1.1900 | 285.0000 | 892626.00 | 0.00 | 892626.00 | 7655 | 72 | 25328 | 57263 | 0.44231004313431 | 0.205805938629922 | 0.20521709337318 | false | false | false | |||||||||||||||||
| b44eeca7-a749-42b7-85f8-50ccf825131d | 2026-09-23 12:35 | 2026-09-23 12:35 | 2026-09-23 12:35 | IWM | IWM261016P00271000 | put | 271.0000 | 2026-10-16 | 1.5100 | 1.5000 | 1.5300 | 283.0500 | 392909.00 | 0.00 | 392909.00 | 2598 | 64 | 61044 | 59578 | 1.02460639833496 | 0.209005961353389 | 0.208475023650724 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 78788792160.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 78788792160.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:03:30.942669Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 78788792160.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:03:30.942669Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 78788792160.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:03:30.942669Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:50:28.178058Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:39:09.093031Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |