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 | 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 |
|---|
| 56539bad-6bc7-4a08-8ff5-f42763693b71 | 2026-09-29 15:45 | 2026-09-29 15:45 | 2026-09-29 15:45 | AMZN | AMZN261009C00247500 | call | 247.5000 | 2026-10-09 | 4.8000 | 4.7500 | 4.8000 | 247.0300 | 75840.00 | 75840.00 | 0.00 | 158 | 15 | 1658 | 1036 | 1.6003861003861 | 0.3001451831331 | 0.3001451831331 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 2660659968805.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T19:48:27.886669Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 11e1947f-1cf0-4dc4-bfda-11be4a0c1ef4 | 2026-09-29 10:29 | 2026-09-29 10:29 | 2026-09-29 10:29 | AMZN | AMZN261009C00247500 | call | 247.5000 | 2026-10-09 | 4.4500 | 4.2500 | 4.5000 | 246.4550 | 18245.00 | 17800.00 | 445.00 | 41 | 8 | 480 | 1036 | 0.463320463320463 | 0.296245083289818 | 0.296096180634156 | true | false | false | true | false | |||||||||||||||
| b4fb5980-085b-4ec2-ae11-823c4e82eac9 | 2026-09-28 15:59 | 2026-09-28 15:59 | 2026-09-28 15:59 | AMZN | AMZN261009C00247500 | call | 247.5000 | 2026-10-09 | 4.5000 | 4.5000 | 4.6500 | 246.0000 | 32400.00 | 0.00 | 32400.00 | 72 | 8 | 2386 | 289 | 8.2560553633218 | 0.28945967932345 | 0.28945967932345 | false | false | false | true | false | |||||||||||||||
| f6e86fa8-093b-4780-bd7c-8bfc05d2dd70 | 2026-09-28 15:15 | 2026-09-28 15:15 | 2026-09-28 15:15 | AMZN | AMZN261009C00247500 | call | 247.5000 | 2026-10-09 | 4.4500 | 4.4000 | 4.5000 | 245.8600 | 16465.00 | 11125.00 | 4895.00 | 37 | 5 | 2087 | 289 | 7.22145328719723 | 0.298236449699428 | 0.298236449699428 | false | false | false | true | ||||||||||||||||
| 7a443c3a-0593-4e2c-be95-2adf82b3ca43 | 2026-09-28 15:15 | 2026-09-28 15:15 | 2026-09-28 15:15 | AMZN | AMZN261009C00247500 | call | 247.5000 | 2026-10-09 | 4.4500 | 4.3500 | 4.5000 | 245.8500 | 10235.00 | 9345.00 | 445.00 | 23 | 12 | 2049 | 289 | 7.08996539792388 | 0.29851239783366 | 0.29851239783366 | false | false | false | true | false | |||||||||||||||
| 42729ae2-5138-480b-943b-02785bdd0d52 | 2026-09-28 12:46 | 2026-09-28 12:46 | 2026-09-28 12:46 | AMZN | AMZN261009C00247500 | call | 247.5000 | 2026-10-09 | 4.7800 | 4.7500 | 4.9000 | 246.0000 | 47794.00 | 0.00 | 47794.00 | 100 | 6 | 1399 | 289 | 4.84083044982699 | 0.289505053449346 | 0.293600699354923 | false | false | false | true | false | |||||||||||||||
| 82ff8c54-d0ab-4538-9bae-dcc7cf2db4e8 | 2026-09-28 12:25 | 2026-09-28 12:25 | 2026-09-28 12:25 | AMZN | AMZN261009C00247500 | call | 247.5000 | 2026-10-09 | 4.9000 | 4.7500 | 4.9500 | 246.9337 | 29890.00 | 19600.00 | 0.00 | 61 | 5 | 1176 | 289 | 4.06920415224914 | 0.29408155641967 | 0.29408155641967 | false | false | false | true | false | |||||||||||||||
| de60b63d-3dc1-4c5a-b054-4a1c2f5e9e7f | 2026-09-23 15:54 | 2026-09-23 15:54 | 2026-09-23 15:54 | AMZN | AMZN261009C00247500 | call | 247.5000 | 2026-10-09 | 7.4000 | 7.1500 | 7.4000 | 249.3000 | 22200.00 | 22200.00 | 0.00 | 30 | 10 | 275 | 89 | 3.08988764044944 | 0.304032717758866 | 0.300163058202022 | true | false | false | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2660659968805.00 |
| 2026-10-29 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2655051085748.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2655051085748.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:23:02.177643Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2655051085748.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:15:55.789711Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2655051085748.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:49:03.667640Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2655051085748.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:25:44.498264Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2688704384092.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:54:40.302966Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |