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 = IWM261120P00270000×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4a1a5c02-8c84-4d8a-8bb7-0915224323f9 | 2026-09-18 15:56 | 2026-09-18 15:56 | 2026-09-18 15:56 | IWM | IWM261120P00270000 | put | 270.0000 | 2026-11-20 | 3.7800 | 3.7500 | 3.7800 | 283.0000 | 131035.00 | 81648.00 | 49387.00 | 347 | 31 | 2975 | 43558 | 0.0682997382799945 | 0.212200773833499 | 0.211930381218929 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 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 |
| 21646fe8-637f-4ab0-a4d4-cd6762284237 | 2026-09-09 11:10 | 2026-09-09 11:10 | 2026-09-09 11:10 | IWM | IWM261120P00270000 | put | 270.0000 | 2026-11-20 | 3.4800 | 3.4300 | 3.5000 | 291.5300 | 104400.00 | 104400.00 | 0.00 | 300 | 6 | 503 | 39381 | 0.0127726568649857 | 0.235979459339953 | 0.235979459339953 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 78377484640.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T15:13:56.572588Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 18be1806-beeb-407e-a6c1-d94d2d6adec7 | 2026-09-08 13:17 | 2026-09-08 13:17 | 2026-09-08 13:17 | IWM | IWM261120P00270000 | put | 270.0000 | 2026-11-20 | 2.7100 | 2.6900 | 2.7100 | 295.8750 | 165310.00 | 165310.00 | 0.00 | 610 | 9 | 1015 | 35290 | 0.0287616888637008 | 0.234343018017069 | 0.234343018017069 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 78377484640.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T17:42:35.153326Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 259c1ab6-18ef-4e9e-acdd-4c358f9643f2 | 2026-09-03 15:05 | 2026-09-03 15:04 | 2026-09-03 15:04 | IWM | IWM261120P00270000 | put | 270.0000 | 2026-11-20 | 2.8400 | 2.8100 | 2.8400 | 295.0100 | 136320.00 | 136320.00 | 0.00 | 480 | 8 | 699 | 34492 | 0.0202655688275542 | 0.227256086219584 | 0.227256086219584 | 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-09-03T19:09:41.417490Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fa498c62-6491-4d94-a92a-8b1f8139c5bc | 2026-09-01 14:49 | 2026-09-01 14:49 | 2026-09-01 14:49 | IWM | IWM261120P00270000 | put | 270.0000 | 2026-11-20 | 4.0100 | 3.9700 | 4.0200 | 290.2050 | 108270.00 | 21253.00 | 21654.00 | 270 | 6 | 967 | 32151 | 0.0300768249821156 | 0.231912353032265 | 0.231912353032265 | 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-09-01T18:58:03.753197Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9e4b4faf-1fab-4b98-bf3f-8bbbd9fbc14a | 2026-08-18 12:23 | 2026-08-18 12:22 | 2026-08-18 12:22 | IWM | IWM261120P00270000 | put | 270.0000 | 2026-11-20 | 3.3700 | 3.3300 | 3.3800 | 301.1500 | 316008.00 | 135828.00 | 175799.00 | 937 | 32 | 5072 | 11747 | 0.431769813569422 | 0.250106257964144 | 0.250648016131352 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 79887436077.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7eba2560-e079-4175-878e-9f0a598ab156 | 2026-08-18 12:23 | 2026-08-18 12:22 | 2026-08-18 12:22 | IWM | IWM261120P00270000 | put | 270.0000 | 2026-11-20 | 3.3400 | 3.3100 | 3.3600 | 301.1700 | 331119.00 | 3330.00 | 310369.00 | 991 | 12 | 1063 | 11747 | 0.0904911892398059 | 0.249548288447843 | 0.249920629441528 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 79887436077.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7319b161-f1dd-4071-92df-cfabedbec5a4 | 2026-08-18 12:23 | 2026-08-18 12:22 | 2026-08-18 12:22 | IWM | IWM261120P00270000 | put | 270.0000 | 2026-11-20 | 3.3700 | 3.3300 | 3.3700 | 301.1500 | 327988.00 | 254068.00 | 47376.00 | 974 | 24 | 4135 | 11747 | 0.352004767174598 | 0.250170519249671 | 0.25037726542616 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 79887436077.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 54815b8f-2f01-49a4-a69b-5ac04e96ff38 | 2026-08-18 12:23 | 2026-08-18 12:22 | 2026-08-18 12:22 | IWM | IWM261120P00270000 | put | 270.0000 | 2026-11-20 | 3.3600 | 3.3300 | 3.3600 | 301.1650 | 301728.00 | 301728.00 | 0.00 | 898 | 10 | 3159 | 11747 | 0.268919724184898 | 0.250170519249671 | 0.250170519249671 | 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-18T16:50:14.134420Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0c08410a-0b29-4f26-8cf8-92a801ee858d | 2026-08-18 12:23 | 2026-08-18 12:22 | 2026-08-18 12:22 | IWM | IWM261120P00270000 | put | 270.0000 | 2026-11-20 | 3.3500 | 3.3300 | 3.3600 | 301.1650 | 298825.00 | 196650.00 | 102175.00 | 892 | 23 | 2100 | 11747 | 0.178769047416362 | 0.249899221657546 | 0.250170519249671 | 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-18T16:50:14.134420Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |