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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| da09e948-97a9-4fc4-a659-54689e3427b0 | 2026-08-17 10:06 | 2026-08-17 10:05 | 2026-08-17 10:05 | KORU | KORU260828C00030000 | call | 30.0000 | 2026-08-28 | 0.8000 | 0.7500 | 1.0000 | 24.1850 | 40180.00 | 0.00 | 40180.00 | 500 | 5 | 505 | 92 | 5.48913043478261 | 1.50386678446904 | 1.50386678446904 | 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-17T14:09:25.911404Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aae5e447-bdd5-4271-b7e9-2d6d7a9b96a0 | 2026-08-18 10:22 | 2026-08-18 10:22 | 2026-08-18 10:22 | KORU | KORU260828C00023000 | call | 23.0000 | 2026-08-28 | 0.9400 | 0.9000 | 1.1500 | 19.5150 | 94486.00 | 0.00 | 94486.00 | 1000 | 6 | 1004 | 96 | 10.4583333333333 | 1.65516996506424 | 1.65516996506424 | 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-18T14:32:52.256663Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2985295d-14fb-49b6-be77-8e557da775ac | 2026-08-18 10:22 | 2026-08-18 10:22 | 2026-08-18 10:22 | KORU | KORU260828C00023000 | call | 23.0000 | 2026-08-28 | 0.9800 | 0.9500 | 1.1500 | 19.5900 | 68702.00 | 0.00 | 68702.00 | 700 | 10 | 1704 | 96 | 17.75 | 1.65139321663047 | 1.65139321663047 | 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-18T14:32:52.256663Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1d00d0e1-3043-44bb-a0a7-749e1ef0adef | 2026-08-18 10:56 | 2026-08-18 10:56 | 2026-08-18 10:56 | KORU | KORU270319C00030000 | call | 30.0000 | 2027-03-19 | 4.7200 | 4.7000 | 5.2000 | 18.6400 | 343460.00 | 0.00 | 343460.00 | 727 | 8 | 4577 | 234 | 19.5598290598291 | 1.33049025387919 | 1.31285835778255 | 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-18T15:04:03.259366Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fcc2e2a6-d887-467c-adac-251e72c4b30c | 2026-08-18 13:00 | 2026-08-18 13:00 | 2026-08-18 13:00 | KORU | KORU260821C00020000 | call | 20.0000 | 2026-08-21 | 0.6100 | 0.6000 | 0.7500 | 18.4278 | 36564.00 | 0.00 | 36564.00 | 600 | 11 | 4714 | 9198 | 0.51250271798217 | 1.81845566767017 | 1.81845566767017 | 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-18T17:20:11.917066Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c8fc3825-4dc9-464e-8771-c70effcae941 | 2026-08-20 09:37 | 2026-08-20 09:37 | 2026-08-20 09:37 | KORU | KORU260828C00020000 | call | 20.0000 | 2026-08-28 | 2.1800 | 2.1500 | 2.5000 | 20.5500 | 35252.00 | 0.00 | 35252.00 | 162 | 6 | 1285 | 1700 | 0.755882352941176 | 1.57694426173748 | 1.57694426173748 | 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-20T13:45:25.718532Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 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 |
| 356277bb-12d9-4c57-8143-53024229df63 | 2026-08-31 10:03 | 2026-08-31 10:03 | 2026-08-31 10:03 | KORU | KORU260918P00018000 | put | 18.0000 | 2026-09-18 | 0.9700 | 0.9500 | 1.1500 | 21.3200 | 48424.00 | 0.00 | 48424.00 | 500 | 5 | 513 | 460 | 1.11521739130435 | 1.32861104905974 | 1.32861104905974 | 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-31T14:21:00.001261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aeeb7401-5ee1-4b63-a3f8-ae62fe6c0bc9 | 2026-09-01 12:49 | 2026-09-01 12:48 | 2026-09-01 12:48 | KORU | KORU270115C00055000 | call | 55.0000 | 2027-01-15 | 0.9800 | 0.9500 | 1.2500 | 19.7199 | 28226.00 | 495.00 | 27731.00 | 287 | 11 | 1663 | 696 | 2.38936781609195 | 1.24326721016773 | 1.22666662900305 | 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-09-01T17:20:15.685951Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5f3b5ca4-e726-48f0-a45f-311fed09954c | 2026-09-04 13:16 | 2026-09-04 13:15 | 2026-09-04 13:15 | KORU | KORU260911C00023500 | call | 23.5000 | 2026-09-11 | 1.1400 | 0.8000 | 1.1500 | 22.6100 | 51940.00 | 51940.00 | 0.00 | 456 | 12 | 1019 | 13 | 78.3846153846154 | 1.21686715725046 | 1.20069269509109 | 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-09-04T17:34:11.817020Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0a4e147c-2745-4644-8f6d-2205277aaf53 | 2026-09-11 10:31 | 2026-09-11 10:30 | 2026-09-11 10:30 | KORU | KORU260918P00025000 | put | 25.0000 | 2026-09-18 | 2.7000 | 2.7000 | 3.1000 | 23.2250 | 12152.00 | 0.00 | 12152.00 | 45 | 19 | 484 | 1015 | 0.476847290640394 | 1.27844366582376 | 1.27844366582376 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 1466063480.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |