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 |
|---|
| db8d27ae-37a0-42a2-b19d-e30c887ff9fb | 2026-09-25 11:22 | 2026-09-25 11:22 | 2026-09-25 11:22 | AVGO | AVGO261120P00330000 | put | 330.0000 | 2026-11-20 | 9.5000 | 9.4000 | 9.5250 | 352.2000 | 23750.00 | 23750.00 | 0.00 | 25 | 7 | 699 | 7717 | 0.0905792406375535 | 0.363176454516689 | 0.362994617264796 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1684184352671.00 | 2026-12-10 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T15:25:06.221939Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 3ab8ae89-a42a-4079-ad25-785b1b77e4e0 | 2026-09-25 10:05 | 2026-09-25 10:05 | 2026-09-25 10:05 | AVGO | AVGO261120P00330000 | put | 330.0000 | 2026-11-20 | 10.1500 | 9.8500 | 10.2000 | 350.7300 | 455735.00 | 326830.00 | 128905.00 | 449 | 89 | 475 | 7717 | 0.0615524167422574 | 0.36778590289781 | 0.36778590289781 | false | false | false | |||||||||||||||||
| ec9f4b0e-765c-4f7e-8b5b-8ef490c3fc3a | 2026-09-24 11:12 | 2026-09-24 11:11 | 2026-09-24 11:11 | AVGO | AVGO261120P00330000 | put | 330.0000 | 2026-11-20 | 11.0000 | 10.8000 | 11.1000 | 347.0000 | 264000.00 | 262900.00 | 1100.00 | 240 | 34 | 720 | 6901 | 0.104332705405014 | 0.360655888350202 | 0.360655888350202 | true | false | false | |||||||||||||||||
| 8941431e-f270-408f-93ef-9582ff93f79c | 2026-09-24 09:39 | 2026-09-24 09:38 | 2026-09-24 09:38 | AVGO | AVGO261120P00330000 | put | 330.0000 | 2026-11-20 | 11.0000 | 10.8000 | 11.0500 | 349.0400 | 15400.00 | 14300.00 | 1100.00 | 14 | 5 | 56 | 6901 | 0.00811476597594551 | 0.371444003927476 | 0.371571168471943 | false | false | false | |||||||||||||||||
| d241ff2a-9a42-48fc-95e2-86e1078ae736 | 2026-09-23 15:48 | 2026-09-23 15:48 | 2026-09-23 15:48 | AVGO | AVGO261120P00330000 | put | 330.0000 | 2026-11-20 | 9.5200 | 9.4500 | 9.6500 | 355.4700 | 24760.00 | 11460.00 | 13300.00 | 26 | 7 | 857 | 6577 | 0.13030256956059 | 0.375908196723789 | 0.377091086743651 | false | false | false | |||||||||||||||||
| 3fd1ec8a-4fa3-4895-af20-54cc4b8c067d | 2026-09-23 11:28 | 2026-09-23 11:28 | 2026-09-23 11:28 | AVGO | AVGO261120P00330000 | put | 330.0000 | 2026-11-20 | 9.2500 | 9.1500 | 9.2500 | 356.0000 | 129500.00 | 129500.00 | 0.00 | 140 | 6 | 344 | 6577 | 0.0523034818306219 | 0.376036441421836 | 0.376036441421836 | false | false | false | |||||||||||||||||
| a5dc933b-8d2e-4eb9-a991-0dd020d99dec | 2026-09-23 10:18 | 2026-09-23 10:18 | 2026-09-23 10:18 | AVGO | AVGO261120P00330000 | put | 330.0000 | 2026-11-20 | 9.2500 | 9.2000 | 9.3500 | 356.0000 | 43462.00 | 16642.00 | 26820.00 | 47 | 8 | 129 | 6577 | 0.0196138056864832 | 0.374984498667308 | 0.374500535062141 | false | false | false | |||||||||||||||||
| fb580c23-8331-4ce4-969d-eb4349c1494f | 2026-09-22 13:28 | 2026-09-22 13:28 | 2026-09-22 13:28 | AVGO | AVGO261120P00330000 | put | 330.0000 | 2026-11-20 | 7.8500 | 7.7500 | 7.8500 | 364.3350 | 45530.00 | 45530.00 | 0.00 | 58 | 11 | 230 | 6393 | 0.0359768496793368 | 0.384723128142122 | 0.384723128142122 | false | false | false | |||||||||||||||||
| 9ace20ca-1174-4e22-8b56-945063f6b09c | 2026-09-22 13:28 | 2026-09-22 13:28 | 2026-09-22 13:28 | AVGO | AVGO261120P00330000 | put | 330.0000 | 2026-11-20 | 7.8500 | 7.7500 | 7.9500 | 364.3479 | 45530.00 | 39250.00 | 6280.00 | 58 | 15 | 288 | 6393 | 0.0450492726419521 | 0.384789015020326 | 0.384789015020326 | false | false | false | |||||||||||||||||
| 40c6a9b9-b830-43f7-9f1e-ad208003fdc2 | 2026-09-14 12:07 | 2026-09-14 12:06 | 2026-09-14 12:06 | AVGO | AVGO261120P00330000 | put | 330.0000 | 2026-11-20 | 14.0000 | 13.5000 | 14.0000 | 346.0800 | 100800.00 | 100800.00 | 0.00 | 72 | 19 | 517 | 5764 | 0.0896946564885496 | 0.383354865380059 | 0.383354865380059 | false | false | false | |||||||||||||||||
| be2b63ca-5628-4605-b0e0-68af2964dcc1 | 2026-08-19 09:30 | 2026-08-19 09:30 | 2026-08-19 09:30 | AVGO | AVGO261120P00330000 | put | 330.0000 | 2026-11-20 | 14.3900 | 14.2500 | 14.8000 | 373.3950 | 269180.00 | 56580.00 | 196755.00 | 187 | 71 | 562 | 3442 | 0.163277164439279 | 0.467182406749217 | 0.465023780606372 | true | false | false | |||||||||||||||||
| d351fa59-f449-4803-90e4-a34f58d68295 | 2026-08-19 09:30 | 2026-08-19 09:30 | 2026-08-19 09:30 | AVGO | AVGO261120P00330000 | put | 330.0000 | 2026-11-20 | 14.6100 | 14.4500 | 16.3000 | 372.7999 | 103715.00 | 8995.00 | 78750.00 | 71 | 20 | 121 | 3442 | 0.0351539802440442 | 0.46339111079907 | 0.471764424679882 | true | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1684184352671.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:06:13.706447Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1694590865776.00 |
| 2026-12-10 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:12:31.706500Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1694590865776.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:40:59.800251Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1694590865776.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:51:14.662813Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1694590865776.00 |
| 2026-12-10 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:31:00.015856Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1694590865776.00 |
| 2026-12-10 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:19:47.877581Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1740179030987.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:30:55.056187Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1740179030987.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:30:55.056187Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1645565687063.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:23:59.234542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1645565687063.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1645565687063.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |