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_alerts728,802 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 |
|---|
| c8adb2cf-b55b-4165-ba02-a13452655d29 | 2026-10-02 12:40 | 2026-10-02 12:40 | 2026-10-02 12:40 | RTX | RTX261218P00175000 | put | 175.0000 | 2026-12-18 | 4.9000 | 4.8500 | 4.9500 | 185.2001 | 13230.00 | 9800.00 | 980.00 | 27 | 18 | 119 | 678 | 0.175516224188791 | 0.294097696250158 | 0.294097696250158 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 248903974034.00 | 2026-10-20 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-10-02T16:42:33.846398Z"} | 2026-10-02 | 2026-10-02 21:15 | 2026-10-02 21:15 |
| 03127538-d73d-4409-a80e-68b9472b9527 | 2026-10-02 12:37 | 2026-10-02 12:36 | 2026-10-02 12:36 | RTX | RTX261016C00190000 | call | 190.0000 | 2026-10-16 | 1.6500 | 1.5100 | 1.6500 | 185.0000 | 84315.00 | 84315.00 | 0.00 | 511 | 36 | 523 | 460 | 1.13695652173913 | 0.232738306259469 | 0.232738306259469 | false | false | false | true | ||||||||||||||||
| 4e573873-9854-4e64-b852-17c8399cbc01 | 2026-10-02 11:47 | 2026-10-02 11:47 | 2026-10-02 11:47 | RTX | RTX261009P00185000 | put | 185.0000 | 2026-10-09 | 2.2700 | 2.1100 | 2.3500 | 185.0000 | 28148.00 | 15663.00 | 12485.00 | 124 | 9 | 180 | 301 | 0.598006644518272 | 0.229643740712435 | 0.229643740712435 | true | false | false | true | ||||||||||||||||
| 8533507d-a1ec-42c2-b462-76ed079fbb00 | 2026-10-02 11:47 | 2026-10-02 11:47 | 2026-10-02 11:47 | RTX | RTX261009C00187500 | call | 187.5000 | 2026-10-09 | 1.3800 | 1.2000 | 1.4300 | 185.0000 | 56441.00 | 56304.00 | 137.00 | 409 | 30 | 418 | 96 | 4.35416666666667 | 0.229297520736971 | 0.229297520736971 | false | false | false | true | ||||||||||||||||
| f47c2873-c6da-4115-a9be-accb3f2bfbdd | 2026-10-02 11:31 | 2026-10-02 11:31 | 2026-10-02 11:31 | RTX | RTX290119P00190000 | put | 190.0000 | 2029-01-19 | 26.9500 | 26.9000 | 28.1000 | 185.0000 | 91636.00 | 0.00 | 91636.00 | 34 | 16 | 34 | 70 | 0.485714285714286 | 0.318001482282796 | 0.318001482282796 | true | false | false | true | ||||||||||||||||
| ccafd312-93cd-45e4-8712-2adb96937d57 | 2026-10-02 11:03 | 2026-10-02 11:03 | 2026-10-02 11:03 | RTX | RTX270219C00230000 | call | 230.0000 | 2027-02-19 | 1.9300 | 1.9200 | 1.9400 | 185.0000 | 25084.00 | 12028.00 | 13056.00 | 130 | 17 | 140 | 1272 | 0.110062893081761 | 0.270168474774839 | 0.270168474774839 | true | false | false | true | ||||||||||||||||
| acfc6e9c-b4a4-423d-8feb-4f981e9120c7 | 2026-10-02 11:03 | 2026-10-02 11:03 | 2026-10-02 11:03 | RTX | RTX270219C00220000 | call | 220.0000 | 2027-02-19 | 3.1000 | 3.0500 | 3.1000 | 185.0000 | 22628.00 | 22628.00 | 0.00 | 73 | 20 | 77 | 778 | 0.0989717223650386 | 0.267499453884568 | 0.267499453884568 | true | false | false | true | ||||||||||||||||
| 0d11cb0f-a168-4c16-99bf-6dbf49ef4424 | 2026-10-02 11:03 | 2026-10-02 11:03 | 2026-10-02 11:03 | RTX | RTX270115C00210000 | call | 210.0000 | 2027-01-15 | 3.2000 | 3.2000 | 3.4000 | 185.0000 | 171325.00 | 7800.00 | 9925.00 | 535 | 26 | 574 | 2023 | 0.283737024221453 | 0.260895120681988 | 0.260895120681988 | false | false | false | true | ||||||||||||||||
| 8c9af4a1-95b2-43d4-9fda-a43e5349c50a | 2026-10-02 10:44 | 2026-10-02 10:44 | 2026-10-02 10:44 | RTX | RTX261218C00220000 | call | 220.0000 | 2026-12-18 | 1.1000 | 1.1000 | 1.3900 | 184.0000 | 20790.00 | 0.00 | 20790.00 | 189 | 13 | 316 | 1441 | 0.219292158223456 | 0.273065884222777 | 0.273065884222777 | true | false | false | true | ||||||||||||||||
| 5e5e9ebc-37b5-4672-a906-34b756743a0f | 2026-10-01 10:19 | 2026-10-01 10:19 | 2026-10-01 10:19 | RTX | RTX270219P00180000 | put | 180.0000 | 2027-02-19 | 9.3500 | 8.3000 | 9.7000 | 185.3800 | 10285.00 | 2805.00 | 7480.00 | 11 | 5 | 11 | 345 | 0.0318840579710145 | 0.292256664897175 | 0.292256664897175 | false | false | false | true | ||||||||||||||||
| 78fc0f46-0f53-4954-8ca7-f527de6c2d19 | 2026-09-30 14:47 | 2026-09-30 14:46 | 2026-09-30 14:46 | RTX | RTX261030C00195000 | call | 195.0000 | 2026-10-30 | 3.4000 | 3.1000 | 3.4500 | 186.2550 | 104380.00 | 103700.00 | 680.00 | 307 | 36 | 352 | 210 | 1.67619047619048 | 0.307197225120424 | 0.307197225120424 | false | false | false | true | ||||||||||||||||
| 0fea2621-3cc6-4346-b92b-0e34d6d672c6 | 2026-09-30 13:56 | 2026-09-30 13:56 | 2026-09-30 13:56 | RTX | RTX261218P00175000 | put | 175.0000 | 2026-12-18 | 4.3800 | 4.3000 | 4.6500 | 186.6100 | 74460.00 | 0.00 | 74460.00 | 170 | 2 | 181 | 497 | 0.364185110663984 | 0.287500219084183 | 0.287500219084183 | false | true | false | true | ||||||||||||||||
| 7d187afa-1ec2-48b3-b583-9881e0f247ec | 2026-09-30 13:08 | 2026-09-30 13:08 | 2026-09-30 13:08 | RTX | RTX280121P00170000 | put | 170.0000 | 2028-01-21 | 12.6300 | 12.3000 | 13.4000 | 187.1700 | 31575.00 | 16380.00 | 15195.00 | 25 | 8 | 30 | 542 | 0.0553505535055351 | 0.304873873772802 | 0.307018380863092 | false | false | false | true | ||||||||||||||||
| d4870f9b-46b9-4478-9ac3-380c7bf5b027 | 2026-09-30 12:50 | 2026-09-30 12:50 | 2026-09-30 12:50 | RTX | RTX261030P00185000 | put | 185.0000 | 2026-10-30 | 5.3500 | 5.0500 | 5.3500 | 187.0000 | 23000.00 | 22470.00 | 530.00 | 43 | 13 | 49 | 21 | 2.33333333333333 | 0.309648265246848 | 0.307261639028547 | false | false | false | true | ||||||||||||||||
| 64d44a5a-2555-4c22-a77c-5054edda9ac7 | 2026-09-30 09:30 | 2026-09-30 09:30 | 2026-09-30 09:30 | RTX | RTX261016P00195000 | put | 195.0000 | 2026-10-16 | 10.0000 | 9.3500 | 10.4500 | 185.6200 | 10000.00 | 10000.00 | 0.00 | 10 | 10 | 11 | 893 | 0.0123180291153415 | 0.248146055291985 | 0.248146055291985 | false | false | false | true | ||||||||||||||||
| 6c8f3603-4421-45ec-b2c3-dc9acb422612 | 2026-09-23 09:30 | 2026-09-23 09:30 | 2026-09-23 09:30 | RTX | RTX270319C00200000 | call | 200.0000 | 2027-03-19 | 12.1000 | 11.6000 | 12.1000 | 191.1050 | 10890.00 | 10890.00 | 0.00 | 9 | 9 | 82 | 433 | 0.189376443418014 | 0.267803929626597 | 0.267803929626597 | false | false | false | true | ||||||||||||||||
| 50cd98d0-d22a-424c-b2a2-39113db25927 | 2026-09-23 09:30 | 2026-09-23 09:30 | 2026-09-23 09:30 | RTX | RTX261218C00200000 | call | 200.0000 | 2026-12-18 | 6.8500 | 6.4000 | 7.3500 | 191.1050 | 16440.00 | 15070.00 | 1370.00 | 24 | 24 | 24 | 1090 | 0.0220183486238532 | 0.263972520129086 | 0.263972520129086 | true | false | false | true | ||||||||||||||||
| 5d025f02-e1dd-4f7b-8cb7-ec965c6c0c47 | 2026-09-23 09:30 | 2026-09-23 09:30 | 2026-09-23 09:30 | RTX | RTX270319C00200000 | call | 200.0000 | 2027-03-19 | 12.1000 | 11.6000 | 12.1000 | 191.1050 | 24200.00 | 24200.00 | 0.00 | 20 | 17 | 71 | 433 | 0.163972286374134 | 0.267803929626597 | 0.267803929626597 | false | false | false | true | ||||||||||||||||
| 5173a3b1-b7c3-4a22-9eef-0da597194e24 | 2026-09-23 09:30 | 2026-09-23 09:30 | 2026-09-23 09:30 | RTX | RTX270319C00200000 | call | 200.0000 | 2027-03-19 | 12.1000 | 11.6000 | 12.1000 | 191.1050 | 19360.00 | 19360.00 | 0.00 | 16 | 13 | 51 | 433 | 0.117782909930716 | 0.267803929626597 | 0.267803929626597 | false | false | false | true | ||||||||||||||||
| a9084794-3ce1-4815-8faa-c85772ea8d1e | 2026-09-23 09:30 | 2026-09-23 09:30 | 2026-09-23 09:30 | RTX | RTX270319C00200000 | call | 200.0000 | 2027-03-19 | 12.1000 | 11.5000 | 12.1000 | 191.1050 | 19360.00 | 18150.00 | 0.00 | 16 | 13 | 19 | 433 | 0.0438799076212471 | 0.267803929626597 | 0.267803929626597 | false | false | false | true | ||||||||||||||||
| 421e0b54-8b55-4370-b982-3355bb154586 | 2026-09-23 09:30 | 2026-09-23 09:30 | 2026-09-23 09:30 | RTX | RTX270319C00200000 | call | 200.0000 | 2027-03-19 | 12.1000 | 11.5500 | 12.1000 | 191.1050 | 19360.00 | 19360.00 | 0.00 | 16 | 13 | 35 | 433 | 0.0808314087759815 | 0.267803929626597 | 0.267803929626597 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 248903974034.00 |
| 2026-10-20 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T16:38:32.067133Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 248903974034.00 |
| 2026-10-20 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T15:48:51.376292Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 248903974034.00 |
| 2026-10-20 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T15:48:51.376292Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 248903974034.00 |
| 2026-10-20 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T15:34:27.628549Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 248903974034.00 |
| 2026-10-20 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T15:03:59.747884Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 248903974034.00 |
| 2026-10-20 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T15:03:59.747884Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 248903974034.00 |
| 2026-10-20 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T15:03:59.747884Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 248903974034.00 |
| 2026-10-20 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-02T14:45:18.611280Z"} |
| 2026-10-02 |
| 2026-10-02 21:15 |
| 2026-10-02 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 249348734221.00 |
| 2026-10-20 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T14:20:01.826419Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 251949907439.00 |
| 2026-10-20 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T18:48:14.075772Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 251949907439.00 |
| 2026-10-20 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T18:03:32.794352Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 251949907439.00 |
| 2026-10-20 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T17:09:03.599351Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 251949907439.00 |
| 2026-10-20 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T16:58:51.549291Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 251949907439.00 |
| 2026-10-20 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:31:22.078710Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 248903974034.00 |
| 2026-10-20 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:30:43.555137Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 248903974034.00 |
| 2026-10-20 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:30:43.555137Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 248903974034.00 |
| 2026-10-20 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:30:43.555137Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 248903974034.00 |
| 2026-10-20 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:30:43.555137Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 248903974034.00 |
| 2026-10-20 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:30:43.555137Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 248903974034.00 |
| 2026-10-20 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:30:43.555137Z"} |
| 2026-10-03 |
| 2026-10-03 00:25 |
| 2026-10-03 00:25 |