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
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| a1412120-1621-48e5-8df1-78a03a675c88 | 2026-09-01 15:13 | 2026-09-01 15:13 | 2026-09-01 15:13 | RKT | RKT261016P00012000 | put | 12.0000 | 2026-10-16 | 0.4700 | 0.4500 | 0.4800 | 12.9850 | 16121.00 | 16121.00 | 0.00 | 343 | 29 | 457 | 1614 | 0.283147459727385 | 0.513488282742553 | 0.514417873764981 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-01T19:21:20.162349Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ec9b9939-9642-4d71-873c-4d764c67c1b6 | 2026-09-17 11:28 | 2026-09-17 11:28 | 2026-09-17 11:28 | RKT | RKT261016P00012000 | put | 12.0000 | 2026-10-16 | 0.5300 | 0.5300 | 0.5400 | 12.4750 | 17702.00 | 0.00 | 17702.00 | 334 | 19 | 737 | 2753 | 0.267707954958227 | 0.553008771449212 | 0.553008771449212 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 23963733037.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:37:51.418712Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| a9ad3509-03d5-4df7-b6aa-38f56d1e2a3c | 2026-09-17 11:28 | 2026-09-17 11:28 | 2026-09-17 11:28 | RKT | RKT261016P00012000 | put | 12.0000 | 2026-10-16 | 0.5300 | 0.5300 | 0.5400 | 12.4800 | 10441.00 | 0.00 | 10441.00 | 197 | 12 | 934 | 2753 | 0.339266254994551 | 0.554386364608979 | 0.554386364608979 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 23963733037.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:37:51.418712Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| e0c22442-4965-410d-bc37-28e2f4f02265 | 2026-09-17 11:29 | 2026-09-17 11:29 | 2026-09-17 11:29 | RKT | RKT261016P00012000 | put | 12.0000 | 2026-10-16 | 0.5300 | 0.5300 | 0.5400 | 12.4800 | 13409.00 | 0.00 | 13409.00 | 253 | 12 | 2206 | 2753 | 0.801307664366146 | 0.554386364608979 | 0.554386364608979 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 23963733037.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:37:51.418712Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 795e03f6-4931-4902-b5e7-85ccd790e618 | 2026-09-17 11:32 | 2026-09-17 11:32 | 2026-09-17 11:32 | RKT | RKT261016P00012000 | put | 12.0000 | 2026-10-16 | 0.5300 | 0.5300 | 0.5500 | 12.4550 | 13992.00 | 0.00 | 13992.00 | 264 | 7 | 2618 | 2753 | 0.950962586269524 | 0.54747295886193 | 0.54747295886193 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 23963733037.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:37:51.418712Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 510b6ca6-eefe-4926-83dd-a0d892b1312a | 2026-09-17 11:39 | 2026-09-17 11:38 | 2026-09-17 11:38 | RKT | RKT261016P00012000 | put | 12.0000 | 2026-10-16 | 0.5300 | 0.5300 | 0.5500 | 12.4500 | 14628.00 | 0.00 | 14628.00 | 276 | 12 | 3571 | 2753 | 1.29713040319651 | 0.546082565254478 | 0.546082565254478 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 23963733037.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:59:42.981722Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 8aa81a80-7cc5-4240-8391-cffb5ee693db | 2026-09-17 13:00 | 2026-09-17 13:00 | 2026-09-17 13:00 | RKT | RKT261016P00012000 | put | 12.0000 | 2026-10-16 | 0.5300 | 0.5300 | 0.5500 | 12.4250 | 11501.00 | 0.00 | 11501.00 | 217 | 10 | 4414 | 2753 | 1.60334180893571 | 0.539091123092351 | 0.539091123092351 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 23963733037.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 4c04d181-87f9-49e9-879a-02dd36db6dbd | 2026-09-17 13:00 | 2026-09-17 13:00 | 2026-09-17 13:00 | RKT | RKT261016P00012000 | put | 12.0000 | 2026-10-16 | 0.5300 | 0.5300 | 0.5500 | 12.4250 | 15794.00 | 0.00 | 15794.00 | 298 | 15 | 4712 | 2753 | 1.71158735924446 | 0.539091123092351 | 0.539091123092351 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 23963733037.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| fb93567c-42d4-4155-ae3f-9bfe7fca1fbf | 2026-09-17 13:00 | 2026-09-17 13:00 | 2026-09-17 13:00 | RKT | RKT261016P00012000 | put | 12.0000 | 2026-10-16 | 0.5300 | 0.5300 | 0.5400 | 12.4250 | 10123.00 | 0.00 | 10123.00 | 191 | 15 | 4903 | 2753 | 1.78096621867054 | 0.539091123092351 | 0.539091123092351 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 23963733037.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 3b5a83e4-3fc2-4322-b278-e4c36aa45f64 | 2026-09-18 09:40 | 2026-09-18 09:40 | 2026-09-18 09:40 | RKT | RKT261016P00012000 | put | 12.0000 | 2026-10-16 | 0.5300 | 0.4600 | 0.5550 | 12.4050 | 21094.00 | 21094.00 | 0.00 | 398 | 5 | 417 | 6978 | 0.0597592433361995 | 0.542490386698364 | 0.542490386698364 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-18T13:50:28.178058Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 8a320575-3863-4bdc-b95a-31cd9291bee3 | 2026-09-18 15:56 | 2026-09-18 15:56 | 2026-09-18 15:56 | RKT | RKT261016P00012000 | put | 12.0000 | 2026-10-16 | 0.5300 | 0.5300 | 0.6100 | 12.0000 | 58247.00 | 0.00 | 58247.00 | 1099 | 12 | 2243 | 6978 | 0.321438807681284 | 0.510360516180594 | 0.510360516180594 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 23429934688.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| efb4d81b-2e6e-4231-a951-d4c8e83e72e5 | 2026-09-18 15:56 | 2026-09-18 15:56 | 2026-09-18 15:56 | RKT | RKT261016P00012000 | put | 12.0000 | 2026-10-16 | 0.5400 | 0.5400 | 0.5800 | 12.0000 | 100764.00 | 0.00 | 100764.00 | 1866 | 18 | 4121 | 6978 | 0.590570364001146 | 0.519188041765852 | 0.519188041765852 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 23429934688.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 3143e8c8-fa66-4f86-9d5b-02fa72776b75 | 2026-09-18 15:56 | 2026-09-18 15:56 | 2026-09-18 15:56 | RKT | RKT261016P00012000 | put | 12.0000 | 2026-10-16 | 0.5300 | 0.5300 | 0.5700 | 12.0000 | 21783.00 | 0.00 | 21783.00 | 411 | 24 | 4599 | 6978 | 0.659071367153912 | 0.513069495706004 | 0.513069495706004 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 23429934688.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 65964e44-220e-4ca9-a35d-ee22076ed409 | 2026-09-18 15:57 | 2026-09-18 15:56 | 2026-09-18 15:56 | RKT | RKT261016P00012000 | put | 12.0000 | 2026-10-16 | 0.5300 | 0.5300 | 0.5500 | 12.0000 | 10759.00 | 0.00 | 10759.00 | 203 | 16 | 5079 | 6978 | 0.727858985382631 | 0.513069495706004 | 0.513069495706004 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 23429934688.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 0d46448f-4f97-4991-9595-9edea40860d2 | 2026-09-18 15:57 | 2026-09-18 15:57 | 2026-09-18 15:57 | RKT | RKT261016P00012000 | put | 12.0000 | 2026-10-16 | 0.5300 | 0.5300 | 0.5600 | 12.0000 | 41340.00 | 0.00 | 41340.00 | 780 | 6 | 6075 | 6978 | 0.870593293207223 | 0.508548599790794 | 0.508548599790794 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 23429934688.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |