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_alerts523,327 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 |
|---|
| ac067b94-e24a-4585-9f85-0a3d9bd2f539 | 2026-09-28 15:05 | 2026-09-28 15:04 | 2026-09-28 15:04 | AVGO | AVGO261023P00340000 | put | 340.0000 | 2026-10-23 | 7.5500 | 7.3500 | 7.6000 | 350.6500 | 16610.00 | 16610.00 | 0.00 | 22 | 8 | 250 | 904 | 0.276548672566372 | 0.347298941978078 | 0.347298941978078 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1668717791908.00 | 2026-12-10 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T19:11:33.715590Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 16b85c64-1b9c-4f5d-8724-3e5596b9892b | 2026-09-28 12:16 | 2026-09-28 12:16 | 2026-09-28 12:16 | AVGO | AVGO261023P00340000 | put | 340.0000 | 2026-10-23 | 7.4500 | 7.2000 | 7.5000 | 350.3000 | 14900.00 | 14155.00 | 745.00 | 20 | 6 | 177 | 904 | 0.195796460176991 | 0.340783035801908 | 0.340783035801908 | false | false | false | true | ||||||||||||||||
| 9ab50eab-a289-4cd6-a2c5-f0e4f30095aa | 2026-09-28 10:54 | 2026-09-28 10:54 | 2026-09-28 10:54 | AVGO | AVGO261023P00340000 | put | 340.0000 | 2026-10-23 | 7.9500 | 7.7000 | 7.9500 | 348.7100 | 69960.00 | 69960.00 | 0.00 | 88 | 18 | 127 | 904 | 0.140486725663717 | 0.33911697553023 | 0.33911697553023 | true | false | false | true | ||||||||||||||||
| 16d4ff37-e322-4b9c-96ba-c2ddc010ba63 | 2026-09-25 12:14 | 2026-09-25 12:14 | 2026-09-25 12:14 | AVGO | AVGO261023P00340000 | put | 340.0000 | 2026-10-23 | 6.9500 | 6.8000 | 6.9500 | 353.3000 | 15981.00 | 15981.00 | 0.00 | 23 | 5 | 86 | 864 | 0.099537037037037 | 0.338132853999712 | 0.336694370472715 | false | false | false | true | ||||||||||||||||
| c62e3d8b-f1e5-496a-86ca-3049b83b60be | 2026-09-25 10:49 | 2026-09-25 10:49 | 2026-09-25 10:49 | AVGO | AVGO261023P00340000 | put | 340.0000 | 2026-10-23 | 7.5000 | 7.4500 | 7.8500 | 351.2800 | 17250.00 | 1500.00 | 15750.00 | 23 | 10 | 56 | 864 | 0.0648148148148148 | 0.332928549843846 | 0.33381770418963 | false | false | false | true | ||||||||||||||||
| fc0266a3-3b63-4ccb-a3e8-0750e67b6435 | 2026-09-24 14:43 | 2026-09-24 14:43 | 2026-09-24 14:43 | AVGO | AVGO261023P00340000 | put | 340.0000 | 2026-10-23 | 8.5000 | 8.3000 | 8.5000 | 349.0000 | 16150.00 | 16150.00 | 0.00 | 19 | 5 | 177 | 817 | 0.216646266829865 | 0.337920873422089 | 0.337920873422089 | false | false | false | true | ||||||||||||||||
| f4593b8b-a90c-41b5-83cd-1a144dcd50a7 | 2026-09-24 14:03 | 2026-09-24 14:03 | 2026-09-24 14:03 | AVGO | AVGO261023P00340000 | put | 340.0000 | 2026-10-23 | 8.7000 | 8.5000 | 8.7500 | 348.0000 | 11310.00 | 6090.00 | 5220.00 | 13 | 5 | 154 | 817 | 0.188494492044064 | 0.338123747337525 | 0.338123747337525 | false | false | false | true | ||||||||||||||||
| 22b8e7f3-042f-416e-9634-0df814afc938 | 2026-09-24 12:25 | 2026-09-24 12:25 | 2026-09-24 12:25 | AVGO | AVGO261023P00340000 | put | 340.0000 | 2026-10-23 | 8.3500 | 8.3000 | 8.5500 | 349.3000 | 15030.00 | 4175.00 | 10855.00 | 18 | 13 | 116 | 817 | 0.141982864137087 | 0.332961618532444 | 0.332961618532444 | false | false | false | true | ||||||||||||||||
| a2b5d3e7-9429-4729-8145-c96db9dcaf50 | 2026-09-23 10:24 | 2026-09-23 10:24 | 2026-09-23 10:24 | AVGO | AVGO261023P00340000 | put | 340.0000 | 2026-10-23 | 7.2000 | 7.2000 | 7.5000 | 355.9000 | 31680.00 | 0.00 | 31680.00 | 44 | 10 | 226 | 695 | 0.325179856115108 | 0.355153414224142 | 0.355153414224142 | true | false | false | true | ||||||||||||||||
| dfbad2bf-1713-43df-801b-7f77a3a52d91 | 2026-09-23 10:18 | 2026-09-23 10:18 | 2026-09-23 10:18 | AVGO | AVGO261023P00340000 | put | 340.0000 | 2026-10-23 | 7.0400 | 7.0000 | 7.0500 | 356.0000 | 90865.00 | 85265.00 | 2800.00 | 129 | 16 | 175 | 695 | 0.251798561151079 | 0.352344174489146 | 0.352912734958476 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1668717791908.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:16:42.064656Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1668717791908.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:55:24.203019Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-25T16:18:06.291601Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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:52:00.220874Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-24T18:51:39.883666Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T18:05:05.581438Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T16:27:48.650295Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-23T14:24:55.903933Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |