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_alerts566,287 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 | strike |
|---|
| 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 |
|---|
| efbe49f7-94e1-4b2a-bb6c-355d65f72f6a | 2026-09-29 10:30 | 2026-09-29 10:30 | 2026-09-29 10:30 | EXE | EXE261023C00081000 | call | 81.0000 | 2026-10-23 | 4.7600 | 4.7000 | 5.1000 | 84.3800 | 11420.00 | 0.00 | 11420.00 | 24 | 6 | 40 | 0 | 0 | 0.310695510613041 | 0.296339245077846 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Energy | 19487988958.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T14:32:52.206353Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 52e26440-9240-4eab-9dfe-80816252cf65 | 2026-09-28 13:01 | 2026-09-28 13:01 | 2026-09-28 13:01 | EXE | EXE261120C00085000 | call | 85.0000 | 2026-11-20 | 4.7300 | 4.6000 | 5.5000 | 85.9400 | 47316.00 | 0.00 | 47316.00 | 100 | 7 | 200 | 660 | 0.303030303030303 | 0.308148823231909 | 0.308148823231909 | false | false | ||||||||||||||||||
| 9bd9e9df-a347-4d8f-b462-404c11a5edfb | 2026-09-28 10:21 | 2026-09-28 10:20 | 2026-09-28 10:20 | EXE | EXE261120C00085000 | call | 85.0000 | 2026-11-20 | 4.7400 | 4.5000 | 5.7000 | 85.9300 | 47385.00 | 0.00 | 47385.00 | 100 | 5 | 100 | 660 | 0.151515151515152 | 0.310946969582358 | 0.310946969582358 | false | false | ||||||||||||||||||
| fcf85310-297c-4858-837a-99c26ac6a0c8 | 2026-09-16 12:40 | 2026-09-16 12:40 | 2026-09-16 12:40 | EXE | EXE270115C00105000 | call | 105.0000 | 2027-01-15 | 2.6600 | 2.6500 | 2.8000 | 91.0300 | 90020.00 | 4320.00 | 85700.00 | 339 | 8 | 477 | 5798 | 0.0822697481890307 | 0.328552689291167 | 0.328552689291167 | true | false | ||||||||||||||||||
| 136af1f5-b6a6-47cb-a595-6e11497c85b2 | 2026-09-16 12:40 | 2026-09-16 12:40 | 2026-09-16 12:40 | EXE | EXE270617C00105000 | call | 105.0000 | 2027-06-17 | 6.3700 | 6.3000 | 6.6000 | 91.0300 | 68809.00 | 32639.00 | 30410.00 | 108 | 19 | 4117 | 2135 | 1.92833723653396 | 0.328789502937007 | 0.328135428090763 | false | false | ||||||||||||||||||
| fcb928b1-2aae-4713-bd73-d00ed937098b | 2026-09-16 10:54 | 2026-09-16 10:54 | 2026-09-16 10:54 | EXE | EXE260918C00091000 | call | 91.0000 | 2026-09-18 | 0.9500 | 0.7500 | 0.9500 | 90.5300 | 29905.00 | 29905.00 | 0.00 | 315 | 28 | 315 | 0 | 0 | 0.433336124387677 | 0.433336124387677 | false | false | false | |||||||||||||||||
| 087959b8-4c04-4997-88e8-b1943251c6f0 | 2026-09-04 14:58 | 2026-09-04 14:57 | 2026-09-04 14:57 | EXE | EXE260918C00100000 | call | 100.0000 | 2026-09-18 | 1.2000 | 1.1000 | 1.2500 | 97.5750 | 18314.00 | 13634.00 | 0.00 | 153 | 7 | 722 | 4710 | 0.153290870488323 | 0.277551750800394 | 0.277361532164633 | false | false | ||||||||||||||||||
| 9899219b-aa2e-44ae-95ae-0b5514d60185 | 2026-08-26 10:43 | 2026-08-26 10:43 | 2026-08-26 10:43 | EXE | EXE260918C00095000 | call | 95.0000 | 2026-09-18 | 4.5100 | 4.5000 | 4.7000 | 97.7700 | 46944.00 | 0.00 | 46944.00 | 104 | 5 | 364 | 11409 | 0.0319046366903322 | 0.291681583376917 | 0.284849509397615 | false | false | ||||||||||||||||||
| 4cb51cd8-0a40-4e4c-9bae-a14e626a303f | 2026-08-26 10:41 | 2026-08-26 10:41 | 2026-08-26 10:41 | EXE | EXE260918C00100000 | call | 100.0000 | 2026-09-18 | 2.1500 | 2.1500 | 2.2500 | 97.9300 | 81493.00 | 223.00 | 81270.00 | 379 | 9 | 3773 | 9241 | 0.408289146196299 | 0.309974612953131 | 0.300771247993892 | false | false | ||||||||||||||||||
| e093c8a9-183b-4abb-b010-e3dd9c8df07b | 2026-08-26 10:36 | 2026-08-26 10:36 | 2026-08-26 10:36 | EXE | EXE260918C00100000 | call | 100.0000 | 2026-09-18 | 2.3000 | 2.2500 | 2.4000 | 98.1800 | 43939.00 | 230.00 | 42559.00 | 191 | 9 | 2945 | 9241 | 0.318688453630559 | 0.305262856137112 | 0.30530387255541 | true | false | ||||||||||||||||||
| fa5de615-5ec5-4026-9d5f-f199d416de1f | 2026-08-26 10:27 | 2026-08-26 10:27 | 2026-08-26 10:27 | EXE | EXE260918C00100000 | call | 100.0000 | 2026-09-18 | 2.2700 | 2.2500 | 2.3500 | 98.1950 | 22670.00 | 0.00 | 22670.00 | 100 | 6 | 2178 | 9241 | 0.23568877827075 | 0.301539093255353 | 0.301539093255353 | false | false | ||||||||||||||||||
| fb8209c5-4e17-4aa5-beb1-59c3c121b2f0 | 2026-08-26 10:27 | 2026-08-26 10:27 | 2026-08-26 10:27 | EXE | EXE260918C00110000 | call | 110.0000 | 2026-09-18 | 0.3900 | 0.3000 | 0.4000 | 98.1700 | 19524.00 | 19524.00 | 0.00 | 500 | 10 | 724 | 5090 | 0.142239685658153 | 0.340298225578296 | 0.338031975762279 | false | false | ||||||||||||||||||
| d3cb46d1-c119-42d7-8044-6ed42a204532 | 2026-08-24 11:14 | 2026-08-24 11:14 | 2026-08-24 11:14 | EXE | EXE260918P00095000 | put | 95.0000 | 2026-09-18 | 2.7200 | 2.7000 | 2.8000 | 95.2950 | 18515.00 | 8250.00 | 9990.00 | 68 | 10 | 93 | 1564 | 0.059462915601023 | 0.303793709203412 | 0.298736878435254 | false | false | ||||||||||||||||||
| f2a6ee77-ed3d-4916-847c-cbeb8cec6c11 | 2026-08-20 15:19 | 2026-08-20 15:19 | 2026-08-20 15:19 | EXE | EXE260918C00100000 | call | 100.0000 | 2026-09-18 | 1.9000 | 1.6500 | 1.9000 | 95.6700 | 76165.00 | 75425.00 | 0.00 | 401 | 5 | 5068 | 2583 | 1.96205962059621 | 0.324762809674413 | 0.319016668791241 | false | false | ||||||||||||||||||
| 4ba02b08-f9b3-4151-b1f7-e240a85b2b73 | 2026-08-19 10:17 | 2026-08-19 10:17 | 2026-08-19 10:17 | EXE | EXE260918C00095000 | call | 95.0000 | 2026-09-18 | 4.3000 | 4.3000 | 4.5000 | 96.9350 | 41720.00 | 0.00 | 41720.00 | 97 | 16 | 150 | 11228 | 0.0133594584966156 | 0.279947926021128 | 0.279947926021128 | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 19749588240.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:04:44.009732Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 19749588240.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:22:37.821840Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 20543646236.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 20543646236.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 20543646236.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 21622453893.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:05:15.166096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 21622453893.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:02:19.815281Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 21622453893.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 21622453893.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 21622453893.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 21622453893.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 21622453893.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:29:12.492303Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 21622453893.00 |
| 2026-10-27 |
| 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 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 21622453893.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |