Options flow alerts (market-wide)
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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 rowsrestricted — hover for the licence
active:option_symbol = IWM261120P00300000×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | 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 |
| 94a717df-e03d-4d6c-8c15-346e58da2527 | 2026-09-18 15:47 | 2026-09-18 15:47 | 2026-09-18 15:47 | IWM | IWM261120P00300000 | put | 300.0000 | 2026-11-20 | 17.4500 | 17.2800 | 17.4600 | 283.8200 | 139623.00 | 92535.00 | 47088.00 | 80 | 12 | 443 | 18189 | 0.0243553796250481 | 0.18029529877928 | 0.179690355022553 | true | false | false | true | 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-18T19:51:24.020322Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 68d24fdf-da17-4934-92bd-c1d4ebebf5e9 | 2026-09-18 09:48 | 2026-09-18 09:48 | 2026-09-18 09:48 | IWM | IWM261120P00300000 | put | 300.0000 | 2026-11-20 | 17.6000 | 17.4300 | 17.6200 | 283.7200 | 117902.00 | 102071.00 | 15831.00 | 67 | 8 | 186 | 18189 | 0.0102259607455055 | 0.182105747647555 | 0.181664201359967 | true | false | false | true | 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 |
| 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 | 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 |
| 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 |