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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 81a3a9bc-1af6-4b77-9c21-f6a4947b847f | 2026-08-20 15:46 | 2026-08-20 15:45 | 2026-08-20 15:45 | KRE | KRE260828P00074000 | put | 74.0000 | 2026-08-28 | 0.6700 | 0.5000 | 0.7000 | 74.7250 | 137350.00 | 137350.00 | 0.00 | 2050 | 1 | 2084 | 96 | 21.7083333333333 | 0.231208238344702 | 0.231208238344702 | false | true | false | true | true | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | ETF | — | 4184240026.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:59:19.634890Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 33c1beb9-4dcb-443e-9e8e-51a9d222384f | 2026-08-28 10:34 | 2026-08-28 10:34 | 2026-08-28 10:34 | KRE | KRE260930C00080000 | call | 80.0000 | 2026-09-30 | 0.2900 | 0.2600 | 0.4500 | 74.1600 | 87000.00 | 0.00 | 87000.00 | 3000 | 1 | 3000 | 3129 | 0.958772770853308 | 0.207061708046421 | 0.207061708046421 | false | true | false | true | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | ETF | — | 4184240026.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:38:22.875878Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1885580d-f48a-41ff-9de5-9a1753ac0457 | 2026-09-02 11:33 | 2026-09-02 11:33 | 2026-09-02 11:33 | KRE | KRE270319P00074000 | put | 74.0000 | 2027-03-19 | 4.8000 | 4.8000 | 5.1500 | 74.1050 | 240000.00 | 0.00 | 240000.00 | 500 | 1 | 2500 | 345 | 7.2463768115942 | 0.262477230467282 | 0.262477230467282 | false | true | false | true | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | ETF | — | 4184240026.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 85228341-1ad7-4151-9c24-12d0a9f7ec5d | 2026-09-10 14:36 | 2026-09-10 14:36 | 2026-09-10 14:36 | KRE | KRE260918P00080000 | put | 80.0000 | 2026-09-18 | 6.5000 | 6.4500 | 7.5000 | 73.4150 | 200200.00 | 0.00 | 200200.00 | 308 | 2 | 308 | 263 | 1.17110266159696 | 0.719141345317223 | 0.719141345317223 | false | true | true | false | true | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 2 | ETF | — | 4198168381.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T18:37:18.479310Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d483f8b8-6f6f-4be5-96bf-746bf3427436 | 2026-09-11 10:43 | 2026-09-11 10:43 | 2026-09-11 10:43 | KRE | KRE260930P00074000 | put | 74.0000 | 2026-09-30 | 1.9600 | 1.7600 | 2.1500 | 73.3650 | 137200.00 | 137200.00 | 0.00 | 700 | 2 | 1500 | 11124 | 0.134843581445523 | 0.254790561614701 | 0.254790561614701 | false | true | true | false | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 2 | ETF | — | 4198168381.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 |
| b1eb4f5f-3328-4d9e-9ad8-abbd36821d79 | 2026-09-17 14:35 | 2026-09-17 14:34 | 2026-09-17 14:34 | KRE | KRE260918P00078000 | put | 78.0000 | 2026-09-18 | 5.6000 | 4.4000 | 5.6500 | 73.0450 | 1672160.00 | 1672160.00 | 0.00 | 2986 | 2 | 2986 | 1991 | 1.49974886991462 | 1.48537601930746 | 1.48537601930746 | false | true | true | false | true | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | ETF | — | 4130496583.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 0954ea7c-b943-4226-a440-59ed881ddcb0 | 2026-09-17 14:35 | 2026-09-17 14:34 | 2026-09-17 14:34 | KRE | KRE260918P00077000 | put | 77.0000 | 2026-09-18 | 4.0000 | 3.6500 | 4.0000 | 73.0450 | 808000.00 | 808000.00 | 0.00 | 2020 | 2 | 2180 | 1347 | 1.61841128433556 | 0.619048053238621 | 0.619048053238621 | false | true | true | false | true | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | ETF | — | 4130496583.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |