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:ticker = SKM×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ad04742b-426a-4583-a7cd-877c104e5701 | 2026-08-20 14:49 | 2026-08-20 14:48 | 2026-08-20 14:48 | SKM | SKM261218C00040000 | call | 40.0000 | 2026-12-18 | 5.4000 | 4.9000 | 5.4000 | 38.6100 | 14579.00 | 14579.00 | 0.00 | 27 | 14 | 213 | 1750 | 0.121714285714286 | 0.656626086965948 | 0.656626086965948 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:16:26.699237Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fd99e22a-6de7-4377-ad03-04ba87586767 | 2026-08-20 13:55 | 2026-08-20 13:55 | 2026-08-20 13:55 | SKM | SKM260821C00035000 | call | 35.0000 | 2026-08-21 | 3.7000 | 2.9000 | 3.7000 | 38.2400 | 135415.00 | 135415.00 | 0.00 | 366 | 23 | 391 | 6058 | 0.0645427533839551 | 2.06141327818017 | 2.06141327818017 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T18:14:08.178572Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b7c4c122-874e-4ac1-b3a6-fb8834d00ee4 | 2026-08-20 13:24 | 2026-08-20 13:24 | 2026-08-20 13:24 | SKM | SKM270115P00040000 | put | 40.0000 | 2027-01-15 | 7.2000 | 5.1500 | 8.6000 | 38.1200 | 15840.00 | 720.00 | 15120.00 | 22 | 5 | 22 | 332 | 0.0662650602409639 | 0.671473488547115 | 0.671473488547115 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 09dd159c-fb51-4bf0-8430-a697f313b036 | 2026-08-20 10:20 | 2026-08-20 10:20 | 2026-08-20 10:20 | SKM | SKM261016C00040000 | call | 40.0000 | 2026-10-16 | 3.0000 | 3.0000 | 3.4000 | 38.1800 | 78000.00 | 0.00 | 78000.00 | 260 | 24 | 265 | 0 | 0 | 0.609987694916109 | 0.609987694916109 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 367fe568-8cac-48cd-95e0-1c880245ff23 | 2026-08-19 14:45 | 2026-08-19 14:45 | 2026-08-19 14:45 | SKM | SKM260918P00035000 | put | 35.0000 | 2026-09-18 | 1.2500 | 1.2500 | 1.3000 | 38.5200 | 26625.00 | 0.00 | 26625.00 | 213 | 13 | 244 | 2854 | 0.0854940434477926 | 0.64050334642135 | 0.64050334642135 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 99822ce6-5751-4ae4-aeb3-76f8acba046a | 2026-08-19 13:27 | 2026-08-19 13:27 | 2026-08-19 13:27 | SKM | SKM260918P00040000 | put | 40.0000 | 2026-09-18 | 3.7000 | 3.7000 | 3.8000 | 38.5650 | 11100.00 | 0.00 | 11100.00 | 30 | 10 | 42 | 493 | 0.0851926977687627 | 0.669660556122266 | 0.669660556122266 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| eb978189-bb97-4475-ad48-d88ebabf8be9 | 2026-08-19 10:12 | 2026-08-19 10:12 | 2026-08-19 10:12 | SKM | SKM270115C00045000 | call | 45.0000 | 2027-01-15 | 4.6000 | 4.5000 | 4.8000 | 39.1050 | 23000.00 | 7820.00 | 15180.00 | 50 | 12 | 73 | 2956 | 0.0246955345060893 | 0.653004891395551 | 0.653004891395551 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 41b6e391-cbc9-49ec-93a1-aed63cefd7a3 | 2026-08-18 15:44 | 2026-08-18 15:44 | 2026-08-18 15:44 | SKM | SKM260918P00035000 | put | 35.0000 | 2026-09-18 | 1.3000 | 1.2500 | 1.3500 | 38.4900 | 34970.00 | 4550.00 | 30420.00 | 269 | 16 | 702 | 2222 | 0.315931593159316 | 0.641926620730209 | 0.641926620730209 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6f92bf88-8be3-4d82-92ee-3842bb703f69 | 2026-08-18 15:42 | 2026-08-18 15:42 | 2026-08-18 15:42 | SKM | SKM260918C00040000 | call | 40.0000 | 2026-09-18 | 2.1500 | 2.1000 | 2.3000 | 38.4800 | 59340.00 | 6665.00 | 52675.00 | 276 | 6 | 978 | 5775 | 0.169350649350649 | 0.613497295217851 | 0.613497295217851 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e602a9cb-8977-4ffc-be86-8850ac9de922 | 2026-08-18 13:36 | 2026-08-18 13:36 | 2026-08-18 13:36 | SKM | SKM260918C00050000 | call | 50.0000 | 2026-09-18 | 0.4000 | 0.3000 | 0.5500 | 38.4800 | 60000.00 | 36160.00 | 8800.00 | 1500 | 15 | 3478 | 7674 | 0.45321866041178 | 0.684828282422651 | 0.684828282422651 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d04626f2-ddf0-426f-b884-774bfead58b6 | 2026-08-18 12:40 | 2026-08-18 12:40 | 2026-08-18 12:40 | SKM | SKM260918C00040000 | call | 40.0000 | 2026-09-18 | 2.2500 | 2.2500 | 2.3000 | 38.5850 | 90000.00 | 0.00 | 90000.00 | 400 | 33 | 634 | 5775 | 0.10978354978355 | 0.625080217239825 | 0.625080217239825 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | 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 |
| a0a012f7-4959-4f30-b08b-2f1c755bdbee | 2026-08-18 12:03 | 2026-08-18 12:03 | 2026-08-18 12:03 | SKM | SKM261218P00040000 | put | 40.0000 | 2026-12-18 | 6.7000 | 6.7000 | 6.8000 | 38.6000 | 14071.00 | 0.00 | 14071.00 | 21 | 8 | 65 | 1691 | 0.0384387936132466 | 0.699194520401821 | 0.699194520401821 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 99f9dbde-9159-4d2b-aca7-12c720239215 | 2026-08-18 11:37 | 2026-08-18 11:37 | 2026-08-18 11:37 | SKM | SKM260918P00035000 | put | 35.0000 | 2026-09-18 | 1.3500 | 1.3500 | 1.5000 | 38.4300 | 12015.00 | 0.00 | 12015.00 | 89 | 8 | 191 | 2222 | 0.085958595859586 | 0.651035949271476 | 0.651035949271476 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 79c7cc79-3ebc-46bf-961a-8e26f44d70ca | 2026-08-18 11:37 | 2026-08-18 11:37 | 2026-08-18 11:37 | SKM | SKM260918C00040000 | call | 40.0000 | 2026-09-18 | 2.1500 | 2.1500 | 2.3500 | 38.4300 | 21500.00 | 0.00 | 21500.00 | 100 | 7 | 150 | 5775 | 0.025974025974026 | 0.618624107434123 | 0.618624107434123 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f85d8988-9697-4673-91bb-2aa398b40bb2 | 2026-08-18 10:22 | 2026-08-18 10:21 | 2026-08-18 10:21 | SKM | SKM261218C00045000 | call | 45.0000 | 2026-12-18 | 4.0400 | 3.8000 | 4.3000 | 38.7400 | 80825.00 | 30138.00 | 41777.00 | 200 | 17 | 609 | 2544 | 0.23938679245283 | 0.677131847472556 | 0.677131847472556 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 33ff6bec-2140-4508-a10f-7a59105e597c | 2026-08-18 10:19 | 2026-08-18 10:19 | 2026-08-18 10:19 | SKM | SKM261218C00045000 | call | 45.0000 | 2026-12-18 | 4.0900 | 3.8000 | 4.1000 | 38.8000 | 40937.00 | 40937.00 | 0.00 | 100 | 16 | 409 | 2544 | 0.160770440251572 | 0.686445724412701 | 0.67527910301677 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f593c44b-13a3-4de2-b3de-2c2993d37ce7 | 2026-08-18 10:16 | 2026-08-18 10:16 | 2026-08-18 10:16 | SKM | SKM261218C00045000 | call | 45.0000 | 2026-12-18 | 4.0300 | 3.7000 | 4.4000 | 38.6300 | 72061.00 | 0.00 | 72061.00 | 179 | 6 | 309 | 2544 | 0.121462264150943 | 0.684875646630984 | 0.684875646630984 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7924c947-c63a-4f81-9a59-67714c5a77e1 | 2026-08-18 10:12 | 2026-08-18 10:11 | 2026-08-18 10:11 | SKM | SKM260918C00050000 | call | 50.0000 | 2026-09-18 | 0.4500 | 0.4000 | 0.5000 | 38.5300 | 28935.00 | 0.00 | 24480.00 | 643 | 9 | 1121 | 7674 | 0.146077664842325 | 0.705194642508395 | 0.70438364080799 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a9738462-ae85-4587-973a-22ca87176aa5 | 2026-08-17 15:37 | 2026-08-17 15:37 | 2026-08-17 15:37 | SKM | SKM260918C00040000 | call | 40.0000 | 2026-09-18 | 2.9000 | 2.6500 | 2.9000 | 39.7000 | 49589.00 | 49589.00 | 0.00 | 171 | 24 | 1667 | 4667 | 0.357188772230555 | 0.635611383384033 | 0.635611383384033 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7f4152d4-96cf-476d-a58c-a368a326a420 | 2026-08-17 14:55 | 2026-08-17 14:55 | 2026-08-17 14:55 | SKM | SKM261218P00035000 | put | 35.0000 | 2026-12-18 | 3.5000 | 3.4000 | 3.8000 | 39.4600 | 24153.00 | 12950.00 | 11203.00 | 69 | 17 | 95 | 2339 | 0.0406156477126977 | 0.661111828893084 | 0.661111828893084 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d794d170-9801-4591-8962-e8f499d6bb76 | 2026-08-17 14:53 | 2026-08-17 14:52 | 2026-08-17 14:52 | SKM | SKM260918C00040000 | call | 40.0000 | 2026-09-18 | 2.8000 | 2.5500 | 2.8500 | 39.4600 | 56000.00 | 29120.00 | 0.00 | 200 | 8 | 1457 | 4667 | 0.312191986286694 | 0.64326700369215 | 0.641051160558231 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c27a1d74-d612-4a88-a78c-7aada05bf3c7 | 2026-08-17 14:53 | 2026-08-17 14:52 | 2026-08-17 14:52 | SKM | SKM260918C00040000 | call | 40.0000 | 2026-09-18 | 2.7400 | 2.5500 | 2.7500 | 39.4350 | 72970.00 | 72970.00 | 0.00 | 266 | 12 | 1228 | 4667 | 0.26312406256696 | 0.61160034697953 | 0.63307950766188 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8d64c030-0ab1-4ff2-8659-c3998370c6ec | 2026-08-17 14:52 | 2026-08-17 14:52 | 2026-08-17 14:52 | SKM | SKM260918C00040000 | call | 40.0000 | 2026-09-18 | 2.6000 | 2.5500 | 2.7000 | 39.4550 | 52000.00 | 0.00 | 52000.00 | 200 | 5 | 457 | 4667 | 0.0979215770302121 | 0.598665454306917 | 0.598665454306917 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Communication Services | 13923929210.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |