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 |
|---|
| 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 |
|---|
| a02db4c7-00f2-494b-94ac-b5f32e6600a8 | 2026-09-21 10:34 | 2026-09-21 10:34 | 2026-09-21 10:34 | AAPL | AAPL260923C00337500 | call | 337.5000 | 2026-09-23 | 2.5300 | 2.5300 | 2.6000 | 337.3100 | 17208.00 | 0.00 | 17208.00 | 68 | 9 | 6379 | 3698 | 1.72498647917793 | 0.261764987056722 | 0.259757110829372 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 4947135136400.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:34:41.643622Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 1e254218-ca73-4283-8309-14324f449938 | 2026-09-22 10:17 | 2026-09-22 10:17 | 2026-09-22 10:17 | AAPL | AAPL260923C00337500 | call | 337.5000 | 2026-09-23 | 3.3000 | 3.3000 | 3.5000 | 339.6200 | 24105.00 | 0.00 | 24105.00 | 73 | 7 | 2182 | 4661 | 0.468139884145033 | 0.296736216973114 | 0.289025199785173 | true | false | false | |||||||||||||||||
| d4515f36-f364-45e2-ad81-03004858a375 | 2026-09-23 10:21 | 2026-09-23 10:20 | 2026-09-23 10:20 | AAPL | AAPL260923C00337500 | call | 337.5000 | 2026-09-23 | 0.9100 | 0.9000 | 0.9600 | 336.8000 | 10600.00 | 0.00 | 10600.00 | 117 | 6 | 10250 | 4068 | 2.5196656833825 | 0.359214268582005 | 0.355512113029539 | false | false | false | |||||||||||||||||
| 16d41dcf-07fe-44e5-b72e-f12266dab4b7 | 2026-09-23 10:34 | 2026-09-23 10:34 | 2026-09-23 10:34 | AAPL | AAPL260923C00337500 | call | 337.5000 | 2026-09-23 | 1.1500 | 1.1300 | 1.1900 | 337.5700 | 11849.00 | 117.00 | 11500.00 | 103 | 6 | 13948 | 4068 | 3.42871189773845 | 0.337332676256018 | 0.334347371982597 | false | false | false | |||||||||||||||||
| 067ef09f-32b1-4cc9-9085-2a5967037713 | 2026-09-23 10:45 | 2026-09-23 10:45 | 2026-09-23 10:45 | AAPL | AAPL260923C00337500 | call | 337.5000 | 2026-09-23 | 1.1600 | 1.1400 | 1.1600 | 337.6200 | 14483.00 | 12528.00 | 0.00 | 125 | 17 | 16089 | 4068 | 3.95501474926254 | 0.32599610823108 | 0.332360346085176 | true | false | false | |||||||||||||||||
| 06d76c9e-9484-44b9-a16c-fb140b68592f | 2026-09-23 10:49 | 2026-09-23 10:49 | 2026-09-23 10:49 | AAPL | AAPL260923C00337500 | call | 337.5000 | 2026-09-23 | 1.3900 | 1.3600 | 1.3900 | 338.1150 | 15546.00 | 14176.00 | 1370.00 | 112 | 34 | 17279 | 4068 | 4.24754178957719 | 0.320316668532919 | 0.320325343737173 | false | false | false | |||||||||||||||||
| 82344754-3b47-48b3-92ad-ab00ac93d91a | 2026-09-23 10:50 | 2026-09-23 10:50 | 2026-09-23 10:50 | AAPL | AAPL260923C00337500 | call | 337.5000 | 2026-09-23 | 1.3300 | 1.3200 | 1.3700 | 338.0201 | 17021.00 | 0.00 | 17021.00 | 128 | 5 | 18028 | 4068 | 4.43166175024582 | 0.319635531428145 | 0.319635531428145 | false | false | false | |||||||||||||||||
| ba22af8d-18c8-4c5d-95d0-cbcf715c77aa | 2026-09-23 11:05 | 2026-09-23 11:05 | 2026-09-23 11:05 | AAPL | AAPL260923C00337500 | call | 337.5000 | 2026-09-23 | 1.5200 | 1.5100 | 1.5900 | 338.3950 | 12499.00 | 1248.00 | 11251.00 | 82 | 8 | 20681 | 4068 | 5.0838249754179 | 0.305439817366822 | 0.315021795722872 | true | false | false | |||||||||||||||||
| 4f570a0b-f3d2-41ec-82ac-57e8f3ca584d | 2026-09-23 11:27 | 2026-09-23 11:27 | 2026-09-23 11:27 | AAPL | AAPL260923C00337500 | call | 337.5000 | 2026-09-23 | 0.4800 | 0.4600 | 0.4900 | 336.2600 | 15541.00 | 6096.00 | 8975.00 | 324 | 8 | 26439 | 4068 | 6.49926253687316 | 0.312367960339249 | 0.314968266361421 | false | false | false | |||||||||||||||||
| 55b4a025-4d0c-4f17-95a0-a5129f2faf83 | 2026-09-23 13:35 | 2026-09-23 13:35 | 2026-09-23 13:35 | AAPL | AAPL260923C00337500 | call | 337.5000 | 2026-09-23 | 0.4000 | 0.3900 | 0.4100 | 337.0300 | 16556.00 | 0.00 | 16478.00 | 414 | 9 | 62306 | 4068 | 15.3161258603736 | 0.271320378343708 | 0.266612746359508 | true | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:17:46.082263Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:21:45.775363Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:35:38.031989Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:47:19.358930Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:51:34.694161Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:51:34.694161Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:09:03.866421Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:28:13.578365Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:39:01.188751Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |