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 = KORU260918C00020000×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 858d64cf-979c-4a68-ac64-6918f9e8b436 | 2026-09-18 15:59 | 2026-09-18 15:59 | 2026-09-18 15:59 | KORU | KORU260918C00020000 | call | 20.0000 | 2026-09-18 | 0.1000 | 0.0000 | 0.1000 | 20.0000 | 10500.00 | 10500.00 | 0.00 | 1050 | 25 | 23534 | 22674 | 1.03792890535415 | 10.0208825747242 | 10.0208825747242 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 1260286518.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 |
| 399edaa3-185b-4367-bfdc-bdbb7a092434 | 2026-09-18 10:40 | 2026-09-18 10:40 | 2026-09-18 10:40 | KORU | KORU260918C00020000 | call | 20.0000 | 2026-09-18 | 0.1000 | 0.0500 | 0.1000 | 19.2850 | 30000.00 | 30000.00 | 0.00 | 3000 | 38 | 21620 | 22674 | 0.953515039252007 | 1.79233216431006 | 1.79233216431006 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 1260286518.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 6bf22476-e9dd-41a1-a8a6-fce335b9e583 | 2026-09-18 10:40 | 2026-09-18 10:40 | 2026-09-18 10:40 | KORU | KORU260918C00020000 | call | 20.0000 | 2026-09-18 | 0.1000 | 0.0500 | 0.1000 | 19.2850 | 50000.00 | 50000.00 | 0.00 | 5000 | 53 | 18620 | 22674 | 0.821204904295669 | 1.7844550181272 | 1.79214490812225 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 1260286518.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 626f4fdd-b0bc-4a9c-b6b0-3991f89670b8 | 2026-09-18 10:40 | 2026-09-18 10:40 | 2026-09-18 10:40 | KORU | KORU260918C00020000 | call | 20.0000 | 2026-09-18 | 0.1000 | 0.0500 | 0.1000 | 19.3100 | 78226.00 | 78226.00 | 0.00 | 8000 | 49 | 13620 | 22674 | 0.600688012701773 | 1.66472948654078 | 1.60456587724507 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1260286518.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 09b22d58-516e-47a6-8be3-0a4441e69034 | 2026-09-18 10:40 | 2026-09-18 10:40 | 2026-09-18 10:40 | KORU | KORU260918C00020000 | call | 20.0000 | 2026-09-18 | 0.1000 | 0.0500 | 0.1000 | 19.3500 | 48308.00 | 48308.00 | 0.00 | 5000 | 107 | 5620 | 22674 | 0.247860986151539 | 1.6182826298688 | 1.68994978437419 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ETF | — | 1260286518.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| e747101b-d75a-43dc-b004-b9de2e0ed521 | 2026-08-24 09:50 | 2026-08-24 09:49 | 2026-08-24 09:49 | KORU | KORU260918C00020000 | call | 20.0000 | 2026-09-18 | 2.1000 | 2.1000 | 2.2500 | 18.2100 | 974820.00 | 0.00 | 974820.00 | 4637 | 33 | 10001 | 11943 | 0.837394289541991 | 1.47446067669211 | 1.45866531524216 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 1129027811.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5d5f50e9-466d-40b1-8de5-8004490faab0 | 2026-08-24 09:49 | 2026-08-24 09:49 | 2026-08-24 09:49 | KORU | KORU260918C00020000 | call | 20.0000 | 2026-09-18 | 2.1500 | 2.1000 | 2.1500 | 18.2050 | 78045.00 | 78045.00 | 0.00 | 363 | 5 | 5364 | 11943 | 0.449133383571967 | 1.48626289107444 | 1.48626289107444 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 1129027811.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e4af3fc2-343a-4b40-8bd8-3475e2eb914d | 2026-08-24 09:48 | 2026-08-24 09:48 | 2026-08-24 09:48 | KORU | KORU260918C00020000 | call | 20.0000 | 2026-09-18 | 2.2000 | 2.2000 | 2.4000 | 18.3199 | 424600.00 | 0.00 | 424600.00 | 1930 | 12 | 5001 | 11943 | 0.41873901029892 | 1.48314525577226 | 1.48314525577226 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 1129027811.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |