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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 60adbe65-b76b-4559-975a-9d7fcd7267da | 2026-09-18 15:01 | 2026-09-18 15:01 | 2026-09-18 15:01 | RKT | RKT261016P00010000 | put | 10.0000 | 2026-10-16 | 0.1000 | 0.0700 | 0.1100 | 12.3951 | 104500.00 | 55000.00 | 0.00 | 11000 | 2 | 11007 | 24016 | 0.458319453697535 | 0.633046342837432 | 0.633046342837432 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Financial Services | 23429934688.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 83b46216-f4de-42d5-a65e-3ecc7c8eb78f | 2026-09-14 15:21 | 2026-09-14 15:20 | 2026-09-14 15:20 | RKT | RKT261016C00014000 | call | 14.0000 | 2026-10-16 | 0.7500 | 0.7300 | 0.7500 | 13.6400 | 750000.00 | 750000.00 | 0.00 | 10000 | 3 | 37338 | 5007 | 7.45715997603355 | 0.553846659796931 | 0.550880949958909 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Financial Services | 25622320765.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7c405024-7823-4442-8e78-895107e78928 | 2026-09-14 10:15 | 2026-09-14 10:15 | 2026-09-14 10:15 | RKT | RKT261016C00014000 | call | 14.0000 | 2026-10-16 | 0.6000 | 0.5900 | 0.6000 | 13.0000 | 150000.00 | 150000.00 | 0.00 | 2500 | 1 | 21248 | 5007 | 4.2436588775714 | 0.562985008525452 | 0.562985008525452 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Financial Services | 25622320765.00 | 2026-10-29 | 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 |
| cc16a728-7d4b-4b93-987e-bbda74dc1052 | 2026-08-27 14:15 | 2026-08-27 14:15 | 2026-08-27 14:15 | RKT | RKT260918C00015000 | call | 15.0000 | 2026-09-18 | 0.4000 | 0.3900 | 0.4200 | 14.0150 | 40000.00 | 0.00 | 40000.00 | 1000 | 2 | 2002 | 36208 | 0.0552916482545294 | 0.554149423022236 | 0.554149423022236 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Financial Services | 25622320765.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 83853f84-61ef-4cc7-8adb-5208ed05d77c | 2026-08-20 15:37 | 2026-08-20 15:37 | 2026-08-20 15:37 | RKT | RKT260828C00014500 | call | 14.5000 | 2026-08-28 | 0.3100 | 0.2500 | 0.3100 | 14.0700 | 37200.00 | 37200.00 | 0.00 | 1200 | 1 | 8749 | 1075 | 8.13860465116279 | 0.582374830367073 | 0.582374830367073 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Financial Services | 25622320765.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |