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_alerts375,978 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 |
|---|
| b17b76dc-87bf-4c9c-abc6-4910a68f0b49 | 2026-09-23 13:06 | 2026-09-23 13:06 | 2026-09-23 13:06 | PEP | PEP261218C00140000 | call | 140.0000 | 2026-12-18 | 2.4800 | 2.4600 | 2.6300 | 129.4500 | 77750.00 | 0.00 | 77750.00 | 314 | 27 | 18836 | 3266 | 5.76729944886712 | 0.229757803994057 | 0.230756877201365 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Defensive | 177681583020.00 | 2026-10-08 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T17:11:20.356460Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 6763bcdb-094d-497a-b7d2-bcfd37158ce9 | 2026-09-23 13:04 | 2026-09-23 13:04 | 2026-09-23 13:04 | PEP | PEP261218C00140000 | call | 140.0000 | 2026-12-18 | 2.5500 | 2.3900 | 2.5500 | 129.6000 | 16558.00 | 16558.00 | 0.00 | 65 | 5 | 18189 | 3266 | 5.56919779546846 | 0.231513232463217 | 0.231974937441711 | false | false | false | true | ||||||||||||||||
| 471a747b-e57f-4ce7-9d49-95f135b2eacf | 2026-09-23 13:04 | 2026-09-23 13:04 | 2026-09-23 13:04 | PEP | PEP261218C00140000 | call | 140.0000 | 2026-12-18 | 2.5500 | 2.5200 | 2.6100 | 129.6000 | 61437.00 | 12732.00 | 44370.00 | 241 | 19 | 18036 | 3266 | 5.52235150030619 | 0.231513232463217 | 0.231974937441711 | false | false | false | true | ||||||||||||||||
| 33bd6888-c04d-41fe-ac1a-10f2ff15a44d | 2026-09-23 13:04 | 2026-09-23 13:04 | 2026-09-23 13:04 | PEP | PEP261218C00140000 | call | 140.0000 | 2026-12-18 | 2.5500 | 2.5200 | 2.5800 | 129.6400 | 14777.00 | 8912.00 | 5610.00 | 58 | 6 | 17575 | 3266 | 5.38120024494795 | 0.230971054036699 | 0.231432313159475 | false | false | false | true | ||||||||||||||||
| c0acba39-5acc-439f-b452-ba710bebd222 | 2026-09-23 12:51 | 2026-09-23 12:51 | 2026-09-23 12:51 | PEP | PEP261218C00140000 | call | 140.0000 | 2026-12-18 | 2.6400 | 2.6000 | 2.6900 | 129.9900 | 39650.00 | 13250.00 | 26400.00 | 150 | 7 | 16054 | 3266 | 4.91549295774648 | 0.230775947532707 | 0.231230276309305 | false | false | false | true | ||||||||||||||||
| 7a2294ad-7855-4632-bd4b-a41c4d318039 | 2026-09-23 12:10 | 2026-09-23 12:10 | 2026-09-23 12:10 | PEP | PEP261218C00140000 | call | 140.0000 | 2026-12-18 | 2.5400 | 2.4600 | 2.5600 | 129.6602 | 108602.00 | 108347.00 | 0.00 | 427 | 23 | 14497 | 3266 | 4.43876301285977 | 0.230697159841784 | 0.23115819379372 | false | false | false | true | ||||||||||||||||
| c0597ec7-3933-44f5-81b5-7fa8f1f270e2 | 2026-09-23 11:42 | 2026-09-23 11:42 | 2026-09-23 11:42 | PEP | PEP280121P00095000 | put | 95.0000 | 2028-01-21 | 2.4600 | 2.4500 | 2.8400 | 130.0000 | 12299.00 | 0.00 | 12299.00 | 50 | 12 | 100 | 318 | 0.314465408805031 | 0.294846421768668 | 0.295224456023523 | false | false | false | true | ||||||||||||||||
| 38668230-05af-4b30-b013-820b6d047631 | 2026-09-23 11:42 | 2026-09-23 11:42 | 2026-09-23 11:42 | PEP | PEP280121P00095000 | put | 95.0000 | 2028-01-21 | 2.4800 | 2.4400 | 2.8400 | 130.0000 | 28809.00 | 10410.00 | 18399.00 | 116 | 22 | 216 | 318 | 0.679245283018868 | 0.294998700268907 | 0.296921729795996 | false | false | false | true | ||||||||||||||||
| 7053d06d-e0f8-440d-a81c-69a9268e0b61 | 2026-09-23 11:42 | 2026-09-23 11:42 | 2026-09-23 11:42 | PEP | PEP280121P00095000 | put | 95.0000 | 2028-01-21 | 2.3300 | 2.2700 | 2.8400 | 130.0000 | 11662.00 | 0.00 | 11662.00 | 50 | 6 | 50 | 318 | 0.157232704402516 | 0.288013093943591 | 0.294164285061644 | false | false | false | true | ||||||||||||||||
| f9b9b3ed-1e3c-42ed-97b7-262adf412f0e | 2026-09-23 11:32 | 2026-09-23 11:31 | 2026-09-23 11:31 | PEP | PEP261218C00140000 | call | 140.0000 | 2026-12-18 | 2.4700 | 2.4100 | 2.5300 | 129.8150 | 63344.00 | 2728.00 | 42512.00 | 256 | 14 | 8409 | 3266 | 2.57470912431108 | 0.223058616683949 | 0.225833401596482 | false | false | false | true | ||||||||||||||||
| 886bd5a9-f5fc-437f-a164-6648771ace34 | 2026-09-23 10:29 | 2026-09-23 10:28 | 2026-09-23 10:28 | PEP | PEP261218C00140000 | call | 140.0000 | 2026-12-18 | 2.7500 | 2.6600 | 2.7600 | 130.6400 | 78834.00 | 51334.00 | 7150.00 | 287 | 20 | 6618 | 3266 | 2.0263319044703 | 0.225721687436974 | 0.226724368310538 | false | false | false | true | ||||||||||||||||
| ada8efff-06a6-4192-bb14-461a7419489d | 2026-09-22 15:54 | 2026-09-22 15:54 | 2026-09-22 15:54 | PEP | PEP270115C00145000 | call | 145.0000 | 2027-01-15 | 2.2600 | 2.1900 | 2.3100 | 131.0000 | 25568.00 | 14218.00 | 11350.00 | 113 | 10 | 181 | 1598 | 0.113266583229036 | 0.212306306487076 | 0.213151961141257 | false | false | false | true | ||||||||||||||||
| 546258fb-3614-4afd-8ff6-d8590d60f027 | 2026-09-22 15:15 | 2026-09-22 15:15 | 2026-09-22 15:15 | PEP | PEP261218C00140000 | call | 140.0000 | 2026-12-18 | 2.6700 | 2.6700 | 2.7300 | 131.0650 | 25629.00 | 0.00 | 5337.00 | 96 | 9 | 1009 | 940 | 1.07340425531915 | 0.21532043558249 | 0.21532043558249 | false | false | false | true | ||||||||||||||||
| 25e54a76-141e-4a51-a393-44c87319e131 | 2026-09-22 15:12 | 2026-09-22 15:12 | 2026-09-22 15:12 | PEP | PEP261218C00140000 | call | 140.0000 | 2026-12-18 | 2.6200 | 2.6200 | 2.6900 | 130.9900 | 10496.00 | 0.00 | 9707.00 | 40 | 6 | 198 | 940 | 0.21063829787234 | 0.214596462221653 | 0.215037782045299 | false | false | false | true | ||||||||||||||||
| 1bd35f45-f0b5-4ea1-bd17-d24cffe263f2 | 2026-09-22 14:51 | 2026-09-22 14:51 | 2026-09-22 14:51 | PEP | PEP261120C00135000 | call | 135.0000 | 2026-11-20 | 3.4500 | 3.4000 | 3.4500 | 130.7300 | 13099.00 | 13099.00 | 0.00 | 38 | 8 | 669 | 1218 | 0.549261083743842 | 0.232999017125329 | 0.233488171296347 | false | false | false | true | ||||||||||||||||
| 45747d97-6633-4cc4-8ad1-0fd9ae8c1001 | 2026-09-21 15:43 | 2026-09-21 15:43 | 2026-09-21 15:43 | PEP | PEP280121C00130000 | call | 130.0000 | 2028-01-21 | 14.7400 | 14.6500 | 14.8000 | 129.8200 | 26535.00 | 26535.00 | 0.00 | 18 | 5 | 178 | 448 | 0.397321428571429 | 0.178277538799656 | 0.18009100713605 | false | false | false | true | ||||||||||||||||
| 0d8d2f85-5636-479d-a95f-76b44478f067 | 2026-09-04 10:02 | 2026-09-04 10:02 | 2026-09-04 10:02 | PEP | PEP270115C00160000 | call | 160.0000 | 2027-01-15 | 1.5600 | 1.5100 | 1.5700 | 138.6500 | 71690.00 | 10342.00 | 0.00 | 459 | 33 | 2573 | 4696 | 0.547913117546848 | 0.21224978947542 | 0.212715774258679 | false | false | false | true | ||||||||||||||||
| eef9e2a7-69d8-4537-a1d6-088c72e13c2d | 2026-08-27 15:29 | 2026-08-27 15:29 | 2026-08-27 15:29 | PEP | PEP261016C00140000 | call | 140.0000 | 2026-10-16 | 4.5000 | 4.5000 | 4.6000 | 140.0000 | 227294.00 | 0.00 | 227294.00 | 505 | 44 | 540 | 1259 | 0.428911834789516 | 0.195661117759242 | 0.195661117759242 | false | false | false | true | ||||||||||||||||
| 3b20cec6-c814-43a3-b74e-9949e3a5e04e | 2026-08-24 15:16 | 2026-08-24 15:16 | 2026-08-24 15:16 | PEP | PEP261218C00155000 | call | 155.0000 | 2026-12-18 | 3.4000 | 3.4000 | 3.5500 | 144.5500 | 239072.00 | 0.00 | 239072.00 | 703 | 42 | 1132 | 3010 | 0.376079734219269 | 0.204492487556854 | 0.204492487556854 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 177681583020.00 |
| 2026-10-08 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:06:21.638399Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 177681583020.00 |
| 2026-10-08 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:06:21.638399Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 177681583020.00 |
| 2026-10-08 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:06:21.638399Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 177681583020.00 |
| 2026-10-08 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:52:42.063868Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 177681583020.00 |
| 2026-10-08 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:13:15.432740Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 177681583020.00 |
| 2026-10-08 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:47:22.680410Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 177681583020.00 |
| 2026-10-08 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:47:22.680410Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 177681583020.00 |
| 2026-10-08 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:47:22.680410Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 177681583020.00 |
| 2026-10-08 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:35:15.101362Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 177681583020.00 |
| 2026-10-08 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:29:05.852425Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 179060123494.00 |
| 2026-10-08 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 179060123494.00 |
| 2026-10-08 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:17:07.798020Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 179060123494.00 |
| 2026-10-08 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:17:07.798020Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 179060123494.00 |
| 2026-10-08 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:55:20.077577Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 176876297001.00 |
| 2026-10-08 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:46:53.809312Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 186089315018.00 |
| 2026-10-08 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 186089315018.00 |
| 2026-10-08 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:35:44.109119Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Defensive |
| 186089315018.00 |
| 2026-10-08 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |