Simplify AnalyticsOptions 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
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9539cc1d-0b6f-4536-84c5-851564280a28 | 2026-09-11 15:59 | 2026-09-11 15:59 | 2026-09-11 15:59 | RUM | RUM270115C00010000 | call | 10.0000 | 2027-01-15 | 0.6500 | 0.6000 | 0.7000 | 7.1750 | 14950.00 | 8645.00 | 4225.00 | 230 | 8 | 921 | 8283 | 0.111191597247374 | 0.846156361381264 | 0.846156361381264 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2210628776.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T13:31:50.503893Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 056fb13a-d50c-45d8-b82d-604425031cf7 | 2026-09-14 09:38 | 2026-09-14 09:38 | 2026-09-14 09:38 | RUM | RUM260918C00009000 | call | 9.0000 | 2026-09-18 | 0.3500 | 0.3000 | 0.3500 | 8.4700 | 17500.00 | 17500.00 | 0.00 | 500 | 7 | 1069 | 14443 | 0.074015093817074 | 1.57933143898168 | 1.57933143898168 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2210628776.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 765223b7-d902-4a4f-8768-ee25cd08e63c | 2026-09-14 09:57 | 2026-09-14 09:57 | 2026-09-14 09:57 | RUM | RUM280121P00005000 | put | 5.0000 | 2028-01-21 | 1.0000 | 0.8500 | 1.0000 | 8.2310 | 16900.00 | 16900.00 | 0.00 | 169 | 27 | 250 | 175 | 1.42857142857143 | 0.844990970736426 | 0.838488441372181 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2210628776.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:00:07.512367Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e941ff67-80b0-4de8-bca1-6d364698956e | 2026-09-14 10:19 | 2026-09-14 10:19 | 2026-09-14 10:19 | RUM | RUM270115C00010000 | call | 10.0000 | 2027-01-15 | 1.2000 | 1.1500 | 1.3000 | 8.0000 | 17760.00 | 16440.00 | 1320.00 | 148 | 7 | 1524 | 8778 | 0.173615857826384 | 0.866504250511382 | 0.865256527641136 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2210628776.00 | 2026-11-09 | unknown | 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 |
| 49a23a3f-9f37-4cf7-92d4-0c534b2ba289 | 2026-09-14 10:20 | 2026-09-14 10:20 | 2026-09-14 10:20 | RUM | RUM270115C00010000 | call | 10.0000 | 2027-01-15 | 1.2500 | 1.2000 | 1.3000 | 8.0000 | 109499.00 | 109375.00 | 124.00 | 876 | 37 | 2452 | 8778 | 0.279334700387332 | 0.887073460745347 | 0.86965133282296 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2210628776.00 | 2026-11-09 | unknown | 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 |
| f12562d8-f941-451e-89ed-82ccbf470f4d | 2026-09-14 10:26 | 2026-09-14 10:26 | 2026-09-14 10:26 | RUM | RUM270115C00010000 | call | 10.0000 | 2027-01-15 | 1.2500 | 1.2000 | 1.3000 | 8.0000 | 26750.00 | 20250.00 | 6500.00 | 214 | 28 | 3022 | 8778 | 0.344269765322397 | 0.889549183865802 | 0.889549183865802 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2210628776.00 | 2026-11-09 | unknown | 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 |
| c295e433-4e8c-479f-849e-9fd284fd6e0e | 2026-09-14 15:51 | 2026-09-14 15:51 | 2026-09-14 15:51 | RUM | RUM260918C00008000 | call | 8.0000 | 2026-09-18 | 0.4000 | 0.3500 | 0.4500 | 8.0000 | 10640.00 | 0.00 | 9040.00 | 266 | 7 | 1355 | 6564 | 0.20642900670323 | 1.09640496091921 | 1.09640496091921 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2210628776.00 | 2026-11-09 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| df3160bb-a7e9-4462-a4ce-93670ea668e5 | 2026-09-15 09:30 | 2026-09-15 09:30 | 2026-09-15 09:30 | RUM | RUM280121P00005000 | put | 5.0000 | 2028-01-21 | 1.0000 | 0.9000 | 1.0000 | 7.6720 | 10000.00 | 3800.00 | 0.00 | 100 | 8 | 200 | 967 | 0.206825232678387 | 0.800383902306482 | 0.800383902306482 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2210628776.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T13:35:39.189623Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 8b6cb147-612d-4e07-975e-f6fc7e25d7e9 | 2026-09-15 09:30 | 2026-09-15 09:30 | 2026-09-15 09:30 | RUM | RUM280121P00005000 | put | 5.0000 | 2028-01-21 | 1.0000 | 0.9000 | 1.2500 | 7.7000 | 18800.00 | 6800.00 | 1700.00 | 188 | 17 | 388 | 967 | 0.40124095139607 | 0.802444858902125 | 0.802444858902125 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2210628776.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T13:35:39.189623Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 1da2f68e-818d-4e7d-b8e9-28f52c92a4d6 | 2026-09-15 09:41 | 2026-09-15 09:41 | 2026-09-15 09:41 | RUM | RUM260918P00008000 | put | 8.0000 | 2026-09-18 | 0.4000 | 0.4000 | 0.4500 | 7.9100 | 12000.00 | 0.00 | 12000.00 | 300 | 5 | 330 | 1194 | 0.276381909547739 | 1.23325598209159 | 1.23325598209159 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2210628776.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 29ce7c53-c59f-4799-b607-ae724e0085dd | 2026-09-15 09:51 | 2026-09-15 09:51 | 2026-09-15 09:51 | RUM | RUM270115C00010000 | call | 10.0000 | 2027-01-15 | 0.9000 | 0.8500 | 1.0500 | 7.7200 | 90000.00 | 900.00 | 89100.00 | 1000 | 7 | 1011 | 10987 | 0.0920178392645854 | 0.886044667115363 | 0.886044667115363 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2210628776.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| ce6b5e6b-6553-4fcf-9f57-a806dd8426e0 | 2026-09-15 09:52 | 2026-09-15 09:52 | 2026-09-15 09:52 | RUM | RUM270115C00010000 | call | 10.0000 | 2027-01-15 | 0.8500 | 0.8000 | 1.0000 | 7.6800 | 168116.00 | 3910.00 | 164206.00 | 1977 | 57 | 2988 | 10987 | 0.271957768271594 | 0.859517228952005 | 0.837318943274308 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 2210628776.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 2fc92e9c-45e9-4888-9f96-aabed49155b6 | 2026-09-15 13:10 | 2026-09-15 13:10 | 2026-09-15 13:10 | RUM | RUM261016C00009000 | call | 9.0000 | 2026-10-16 | 0.6000 | 0.6000 | 0.6500 | 8.3450 | 11460.00 | 0.00 | 11460.00 | 191 | 7 | 551 | 1157 | 0.476231633535004 | 0.873981810992339 | 0.873981810992339 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2210628776.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T17:17:02.017770Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| bb5a2183-6614-4d09-8495-b7c0cf4795f0 | 2026-09-16 11:32 | 2026-09-16 11:32 | 2026-09-16 11:32 | RUM | RUM270115C00010000 | call | 10.0000 | 2027-01-15 | 1.1400 | 1.0500 | 1.2000 | 8.2800 | 25905.00 | 21190.00 | 4715.00 | 227 | 9 | 241 | 8563 | 0.0281443419362373 | 0.894448829955207 | 0.870867023658959 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 2293527355.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T15:39:18.643032Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| d7a74dda-4501-477f-af53-92dd378121e5 | 2026-09-16 12:24 | 2026-09-16 12:24 | 2026-09-16 12:24 | RUM | RUM261009C00008000 | call | 8.0000 | 2026-10-09 | 0.8500 | 0.8000 | 0.8500 | 8.2650 | 25500.00 | 25500.00 | 0.00 | 300 | 8 | 302 | 15204 | 0.0198631938963431 | 0.86032004098475 | 0.86032004098475 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2293527355.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T16:35:37.886334Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| fb445b54-6c03-4ef0-a905-26dd58698d17 | 2026-09-17 10:25 | 2026-09-17 10:25 | 2026-09-17 10:25 | RUM | RUM260925C00009000 | call | 9.0000 | 2026-09-25 | 0.4000 | 0.3500 | 0.4500 | 8.7350 | 14320.00 | 2240.00 | 12000.00 | 358 | 62 | 467 | 346 | 1.34971098265896 | 0.991358019582674 | 0.991358019582674 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2456561227.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:33:58.839655Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| d888b4e0-9a31-4549-b5d7-5be00edb0d65 | 2026-09-18 09:46 | 2026-09-18 09:46 | 2026-09-18 09:46 | RUM | RUM260925C00009000 | call | 9.0000 | 2026-09-25 | 0.5500 | 0.4500 | 0.5500 | 9.2036 | 13530.00 | 4070.00 | 0.00 | 246 | 12 | 274 | 1166 | 0.234991423670669 | 0.869396798278303 | 0.869396798278303 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2511826947.00 | 2026-11-09 | unknown | — | 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 |
| 63833f39-ff3b-44f2-9c53-7ca059665aa3 | 2026-09-18 09:57 | 2026-09-18 09:57 | 2026-09-18 09:57 | RUM | RUM260925C00009000 | call | 9.0000 | 2026-09-25 | 0.6000 | 0.5500 | 0.6000 | 9.2900 | 19020.00 | 13560.00 | 0.00 | 317 | 91 | 827 | 1166 | 0.70926243567753 | 0.86302892204894 | 0.86302892204894 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2511826947.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| b8489981-36c7-4f56-a356-a5cd9b723a6a | 2026-09-18 11:35 | 2026-09-18 11:35 | 2026-09-18 11:35 | RUM | RUM261016C00011000 | call | 11.0000 | 2026-10-16 | 0.3000 | 0.3000 | 0.3500 | 9.0300 | 16140.00 | 0.00 | 16140.00 | 538 | 23 | 614 | 7203 | 0.0852422601693739 | 0.89036726354707 | 0.89036726354707 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2511826947.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 1fce6cd5-99ca-4e28-b947-0748931d8918 | 2026-09-18 12:07 | 2026-09-18 12:06 | 2026-09-18 12:06 | RUM | RUM261016C00011000 | call | 11.0000 | 2026-10-16 | 0.2800 | 0.2500 | 0.3000 | 9.0000 | 14868.00 | 14868.00 | 0.00 | 531 | 12 | 1285 | 7203 | 0.178397889768152 | 0.852697235829089 | 0.848032626258156 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2511826947.00 | 2026-11-09 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T16:25:30.671610Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 40d90aed-49f2-4113-9bf9-57247268faba | 2026-09-18 13:28 | 2026-09-18 13:28 | 2026-09-18 13:28 | RUM | RUM261016C00010000 | call | 10.0000 | 2026-10-16 | 0.5000 | 0.5000 | 0.5500 | 9.0650 | 31500.00 | 0.00 | 31500.00 | 630 | 13 | 706 | 9425 | 0.0749071618037135 | 0.838616161116988 | 0.838616161116988 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2511826947.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 93cb5d27-ad3a-4c9e-adc5-8c097194c609 | 2026-09-18 15:43 | 2026-09-18 15:43 | 2026-09-18 15:43 | RUM | RUM270115C00009000 | call | 9.0000 | 2027-01-15 | 1.6500 | 1.6500 | 1.9000 | 9.0500 | 30360.00 | 0.00 | 30360.00 | 184 | 7 | 434 | 2488 | 0.17443729903537 | 0.771148566602205 | 0.771148566602205 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2511826947.00 | 2026-11-09 | unknown | — | 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 |
| 403fc5f1-e244-45e7-a85c-f3f66127468a | 2026-09-18 15:45 | 2026-09-18 15:45 | 2026-09-18 15:45 | RUM | RUM270115C00010000 | call | 10.0000 | 2027-01-15 | 1.3000 | 1.3000 | 1.5500 | 9.0450 | 28860.00 | 0.00 | 28860.00 | 222 | 6 | 285 | 8741 | 0.0326049651069672 | 0.7859200248733 | 0.7859200248733 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2511826947.00 | 2026-11-09 | unknown | — | 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 |
| 147c28da-a9f3-46d4-96cb-200f52a9a90a | 2026-09-18 15:46 | 2026-09-18 15:46 | 2026-09-18 15:46 | RUM | RUM260925C00009500 | call | 9.5000 | 2026-09-25 | 0.2500 | 0.2000 | 0.3000 | 9.0200 | 20400.00 | 250.00 | 475.00 | 816 | 24 | 1152 | 429 | 2.68531468531469 | 0.875182315115947 | 0.875182315115947 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2511826947.00 | 2026-11-09 | unknown | — | 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 |