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 | 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 |
|---|
| 526dd505-2630-4bb2-b3fa-6e0304bda987 | 2026-08-21 12:10 | 2026-08-21 12:10 | 2026-08-21 12:10 | IWM | IWM261120P00300000 | put | 300.0000 | 2026-11-20 | 10.7600 | 10.7500 | 10.8400 | 299.5000 | 105448.00 | 40888.00 | 64560.00 | 98 | 6 | 1131 | 5235 | 0.216045845272206 | 0.200616385882544 | 0.200616385882544 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 79887436077.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d6630cb5-8e69-41c9-96db-8f5d060da155 | 2026-08-27 13:44 | 2026-08-27 13:44 | 2026-08-27 13:44 | IWM | IWM261120P00300000 | put | 300.0000 | 2026-11-20 | 9.8800 | 9.7700 | 9.8800 | 300.1250 | 366548.00 | 366548.00 | 0.00 | 371 | 7 | 1855 | 14111 | 0.131457728013606 | 0.195269817842399 | 0.195269817842399 | false | false | false | true | ||||||||||||||||
| 5bc57673-87b9-48d4-aa85-663d13359e3f | 2026-09-18 15:56 | 2026-09-18 15:56 | 2026-09-18 15:56 | IWM | IWM261120P00300000 | put | 300.0000 | 2026-11-20 | 17.3800 | 17.1800 | 17.3800 | 283.0000 | 104280.00 | 104280.00 | 0.00 | 60 | 5 | 511 | 18189 | 0.0280939029083512 | 0.180203069841254 | 0.180203069841254 | true | false | false | true | ||||||||||||||||
| d97aa1b9-095c-45f3-a35c-7324f5b5daaa | 2026-09-21 11:52 | 2026-09-21 11:52 | 2026-09-21 11:52 | IWM | IWM261120P00300000 | put | 300.0000 | 2026-11-20 | 15.5900 | 15.5900 | 15.7300 | 286.0600 | 38975.00 | 0.00 | 38975.00 | 25 | 9 | 43 | 18472 | 0.00232784755305327 | 0.175789794015911 | 0.175789794015911 | false | false | false | true | ||||||||||||||||
| e434c69c-7224-4993-99d6-9e5ec4b2a451 | 2026-09-23 10:18 | 2026-09-23 10:18 | 2026-09-23 10:18 | IWM | IWM261120P00300000 | put | 300.0000 | 2026-11-20 | 17.2800 | 17.1200 | 17.3100 | 284.0000 | 112320.00 | 110592.00 | 1728.00 | 65 | 7 | 203 | 16865 | 0.0120367625259413 | 0.182921883780546 | 0.18282297806737 | true | false | false | true | ||||||||||||||||
| 3b44ba26-4619-4d53-9319-bc9ef0861f7e | 2026-09-23 10:22 | 2026-09-23 10:22 | 2026-09-23 10:22 | IWM | IWM261120P00300000 | put | 300.0000 | 2026-11-20 | 17.5900 | 17.4400 | 17.5900 | 283.6400 | 26385.00 | 26385.00 | 0.00 | 15 | 8 | 251 | 16865 | 0.014882893566558 | 0.184036577147382 | 0.184036577147382 | false | false | false | true | ||||||||||||||||
| 1f8da49b-d7b9-45fc-8ab8-797f8ffbeac4 | 2026-09-23 10:38 | 2026-09-23 10:38 | 2026-09-23 10:38 | IWM | IWM261120P00300000 | put | 300.0000 | 2026-11-20 | 17.9000 | 17.7400 | 17.9000 | 283.2200 | 55489.00 | 53700.00 | 1789.00 | 31 | 7 | 342 | 16865 | 0.0202786836643937 | 0.18399254846188 | 0.18399254846188 | false | false | false | true | ||||||||||||||||
| 57ff2584-1800-470b-b6db-aeba288ef5fe | 2026-09-23 10:47 | 2026-09-23 10:47 | 2026-09-23 10:47 | IWM | IWM261120P00300000 | put | 300.0000 | 2026-11-20 | 18.2900 | 18.1400 | 18.2900 | 282.7400 | 42067.00 | 42067.00 | 0.00 | 23 | 7 | 375 | 16865 | 0.0222353987548177 | 0.185163951533041 | 0.184848602160335 | true | false | false | true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T17:46:53.178792Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 78247032269.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| 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-21T15:52:20.515056Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:18:11.787457Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:22:47.791063Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:39:41.777134Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 75910909701.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:51:34.694161Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |