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.
uw_flow_alerts658,639 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 | expiry |
|---|
| 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 |
|---|
| 7f73739f-f862-48b9-9df6-ce91017af768 | 2026-09-22 10:42 | 2026-09-22 10:42 | 2026-09-22 10:42 | RKT | RKT261016C00012500 | call | 12.5000 | 2026-10-16 | 0.8000 | 0.7800 | 0.8300 | 12.6100 | 28560.00 | 9920.00 | 18640.00 | 357 | 9 | 357 | 307 | 1.1628664495114 | 0.56471177115761 | 0.566909180957874 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 24287824892.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T14:42:44.065275Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 2320aff6-5187-4037-806f-eed7cdf5cf06 | 2026-09-22 11:01 | 2026-09-22 11:01 | 2026-09-22 11:01 | RKT | RKT261016C00012500 | call | 12.5000 | 2026-10-16 | 0.8500 | 0.8400 | 0.8800 | 12.7000 | 38080.00 | 3400.00 | 34680.00 | 448 | 6 | 1578 | 307 | 5.1400651465798 | 0.565917086946338 | 0.565917086946338 | false | false | false | true | ||||||||||||||||
| a6b2bd7d-7821-4f96-b9a7-f11f027e184d | 2026-09-24 14:07 | 2026-09-24 14:07 | 2026-09-24 14:07 | RKT | RKT261016C00012500 | call | 12.5000 | 2026-10-16 | 0.4900 | 0.4500 | 0.4900 | 11.9850 | 14700.00 | 14700.00 | 0.00 | 300 | 5 | 1140 | 3074 | 0.37085230969421 | 0.590227421046059 | 0.590227421046059 | false | false | false | true | ||||||||||||||||
| c37838cc-1c79-4d53-a8ca-11648c4dac08 | 2026-09-28 14:33 | 2026-09-28 14:33 | 2026-09-28 14:33 | RKT | RKT261016C00012500 | call | 12.5000 | 2026-10-16 | 0.4000 | 0.3700 | 0.4000 | 11.8100 | 63640.00 | 63640.00 | 0.00 | 1591 | 43 | 2904 | 3497 | 0.830426079496711 | 0.634242341708047 | 0.634242341708047 | false | false | false | true | ||||||||||||||||
| 0830de6a-005c-44d7-a510-f64859cf4889 | 2026-09-28 14:33 | 2026-09-28 14:33 | 2026-09-28 14:33 | RKT | RKT261016C00012500 | call | 12.5000 | 2026-10-16 | 0.3800 | 0.3700 | 0.3800 | 11.7950 | 35340.00 | 35340.00 | 0.00 | 930 | 33 | 1175 | 3497 | 0.33600228767515 | 0.619675588371126 | 0.619675588371126 | false | false | false | true | ||||||||||||||||
| 954b9c21-86bb-4f87-862c-e37e244c8cce | 2026-09-28 14:33 | 2026-09-28 14:33 | 2026-09-28 14:33 | RKT | RKT261016C00012500 | call | 12.5000 | 2026-10-16 | 0.4000 | 0.3700 | 0.4000 | 11.8250 | 10680.00 | 10680.00 | 0.00 | 267 | 14 | 3171 | 3497 | 0.906777237632256 | 0.628579864387086 | 0.628579864387086 | false | false | false | true | ||||||||||||||||
| 444278d1-a80b-4d13-b062-0ece9760df15 | 2026-09-28 14:36 | 2026-09-28 14:36 | 2026-09-28 14:36 | RKT | RKT261016C00012500 | call | 12.5000 | 2026-10-16 | 0.4000 | 0.3400 | 0.4000 | 11.7950 | 91400.00 | 91400.00 | 0.00 | 2285 | 47 | 6745 | 3497 | 1.92879611095224 | 0.639892726939056 | 0.639892726939056 | false | false | false | true | ||||||||||||||||
| 8a3829ee-099e-40a0-99c9-96c020ba262c | 2026-09-28 14:38 | 2026-09-28 14:38 | 2026-09-28 14:38 | RKT | RKT261016C00012500 | call | 12.5000 | 2026-10-16 | 0.3900 | 0.3700 | 0.4000 | 11.8010 | 18096.00 | 15756.00 | 2340.00 | 464 | 20 | 7210 | 3497 | 2.06176722905347 | 0.627549633507274 | 0.627549633507274 | true | false | false | true | ||||||||||||||||
| 072571ee-3daf-450f-a849-159ac93ed4d3 | 2026-09-29 15:30 | 2026-09-29 15:30 | 2026-09-29 15:30 | RKT | RKT261016C00012500 | call | 12.5000 | 2026-10-16 | 0.3600 | 0.3500 | 0.3600 | 11.7750 | 54000.00 | 21456.00 | 0.00 | 1500 | 11 | 1812 | 10772 | 0.168213887857408 | 0.624747297809703 | 0.624747297809703 | false | false | false | true | ||||||||||||||||
| a83a0b37-f9af-420c-82c0-5c59c117aaf7 | 2026-09-30 10:12 | 2026-09-30 10:12 | 2026-09-30 10:12 | RKT | RKT261016C00012500 | call | 12.5000 | 2026-10-16 | 0.3200 | 0.2800 | 0.3400 | 11.0000 | 25600.00 | 22528.00 | 3072.00 | 800 | 27 | 846 | 12172 | 0.0695037791652974 | 0.634716920179528 | 0.634716920179528 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 24287824892.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:05:44.724527Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 23163035513.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:09:26.312126Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22190759949.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:38:54.071675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22190759949.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:38:54.071675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22190759949.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:38:54.071675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22190759949.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:38:54.071675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22190759949.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:38:54.071675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22286081082.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:36:36.492519Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Financial Services |
| 22286081082.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:14:21.800901Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |