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_alerts474,253 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 |
|---|
| c495c08c-cb67-4b51-969a-df1f265cfc9c | 2026-09-25 15:21 | 2026-09-25 15:20 | 2026-09-25 15:20 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 0.9200 | 0.8800 | 0.9200 | 339.9650 | 23092.00 | 23092.00 | 0.00 | 251 | 20 | 17897 | 2681 | 6.67549421857516 | 0.153101526133105 | 0.153101526133105 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 4977636972600.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T19:24:28.165724Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 94a6e7c9-d310-42ea-8a71-76c1ae949c7c | 2026-09-25 15:12 | 2026-09-25 15:12 | 2026-09-25 15:12 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 0.9900 | 0.9700 | 1.0000 | 340.2700 | 17872.00 | 17872.00 | 0.00 | 180 | 7 | 16951 | 2681 | 6.32264080566953 | 0.150670496470169 | 0.151567974904797 | false | false | false | true | ||||||||||||||||
| b2487f2f-e5c1-49bb-9247-604ebae4d4ef | 2026-09-25 14:54 | 2026-09-25 14:54 | 2026-09-25 14:54 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 1.0300 | 1.0000 | 1.0300 | 340.0000 | 41200.00 | 41200.00 | 0.00 | 400 | 10 | 15908 | 2681 | 5.93360686311078 | 0.155436326506444 | 0.155436326506444 | false | false | false | true | ||||||||||||||||
| 0ee2fc97-30ff-4556-8f99-962d8bbe8553 | 2026-09-25 14:50 | 2026-09-25 14:50 | 2026-09-25 14:50 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 1.0000 | 0.9800 | 1.0000 | 340.0000 | 19500.00 | 19500.00 | 0.00 | 195 | 12 | 15422 | 2681 | 5.75233121969414 | 0.155668568335802 | 0.155668568335802 | false | false | false | true | ||||||||||||||||
| 15963bb0-c61f-4292-ad05-c62a784a82a8 | 2026-09-25 14:44 | 2026-09-25 14:44 | 2026-09-25 14:44 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 1.0400 | 1.0000 | 1.0400 | 340.2400 | 52103.00 | 52103.00 | 0.00 | 501 | 15 | 15139 | 2681 | 5.6467735919433 | 0.156479417710031 | 0.155141091617314 | false | false | false | true | ||||||||||||||||
| bc611d0c-9aa6-48e0-8c89-d0d38c6dcd77 | 2026-09-25 12:29 | 2026-09-25 12:29 | 2026-09-25 12:29 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 1.0000 | 0.9800 | 1.0300 | 339.0000 | 15000.00 | 5200.00 | 9800.00 | 150 | 8 | 11558 | 2681 | 4.31107795598657 | 0.164882218002039 | 0.164882218002039 | false | false | false | true | ||||||||||||||||
| 6f9d1bda-f9f2-413b-a918-89105e5c95db | 2026-09-25 12:12 | 2026-09-25 12:12 | 2026-09-25 12:12 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 1.0900 | 1.0100 | 1.0900 | 339.0000 | 10246.00 | 10246.00 | 0.00 | 94 | 7 | 10799 | 2681 | 4.02797463632973 | 0.169637995232047 | 0.169637995232047 | false | false | false | true | false | |||||||||||||||
| 838c74b2-cba7-4fbd-83f6-3df7594a5805 | 2026-09-25 12:04 | 2026-09-25 12:04 | 2026-09-25 12:04 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 1.0700 | 1.0700 | 1.1000 | 339.9850 | 10810.00 | 110.00 | 10700.00 | 101 | 8 | 10235 | 2681 | 3.81760537113018 | 0.166225029026604 | 0.168931840637408 | false | false | false | true | ||||||||||||||||
| 3524429b-60df-40c3-8e0b-0170603fb0ad | 2026-09-25 11:56 | 2026-09-25 11:56 | 2026-09-25 11:56 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 0.7700 | 0.7400 | 0.7900 | 339.0000 | 21406.00 | 231.00 | 21175.00 | 278 | 5 | 8557 | 2681 | 3.1917195076464 | 0.166006818578248 | 0.16471870766715 | false | false | false | true | false | |||||||||||||||
| 2da6726c-8500-45f9-ba0c-4aae5e7f66b1 | 2026-09-25 10:37 | 2026-09-25 10:37 | 2026-09-25 10:37 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 0.4800 | 0.4800 | 0.5000 | 337.1647 | 15568.00 | 0.00 | 12432.00 | 323 | 21 | 3307 | 2681 | 1.23349496456546 | 0.176758002078816 | 0.175464524964941 | false | false | false | true | ||||||||||||||||
| f9b4d32d-5364-4232-9890-9e15a8dc7f17 | 2026-09-24 10:22 | 2026-09-24 10:22 | 2026-09-24 10:22 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 1.0100 | 0.9500 | 1.0100 | 337.4200 | 27876.00 | 27876.00 | 0.00 | 276 | 15 | 1520 | 2106 | 0.721747388414055 | 0.198287526619097 | 0.198287526619097 | true | false | false | true | ||||||||||||||||
| 4e2b68b7-f578-4280-af87-0e86888c0473 | 2026-09-23 09:43 | 2026-09-23 09:43 | 2026-09-23 09:43 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 1.5800 | 1.5700 | 1.6800 | 337.5400 | 39859.00 | 1264.00 | 38595.00 | 252 | 8 | 1099 | 2343 | 0.469056764831413 | 0.217679872052966 | 0.217679872052966 | false | false | false | true | ||||||||||||||||
| 8b506748-393e-46c2-b060-81ad12f92cd8 | 2026-09-22 14:50 | 2026-09-22 14:50 | 2026-09-22 14:50 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 2.7700 | 2.7000 | 2.7700 | 340.2800 | 45428.00 | 45428.00 | 0.00 | 164 | 16 | 3256 | 1574 | 2.06861499364676 | 0.210976295138178 | 0.210976295138178 | false | false | false | true | ||||||||||||||||
| a1312b3d-8460-43a3-b861-ecca08631e26 | 2026-09-22 10:57 | 2026-09-22 10:57 | 2026-09-22 10:57 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 4.0500 | 3.9000 | 4.0500 | 342.6300 | 13760.00 | 13760.00 | 0.00 | 34 | 5 | 1977 | 1574 | 1.25603557814485 | 0.219924613762171 | 0.221002297410176 | true | false | false | true | false | |||||||||||||||
| d86b1a09-a875-40a7-a0b5-31b15e4caa6d | 2026-09-22 10:48 | 2026-09-22 10:48 | 2026-09-22 10:48 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 3.6000 | 3.5000 | 3.6500 | 341.6500 | 277458.00 | 194298.00 | 83160.00 | 771 | 40 | 1790 | 1574 | 1.13722998729352 | 0.224530542432458 | 0.22329446765729 | true | false | false | true | ||||||||||||||||
| bac0505a-7719-4e1c-9af8-f572f904399c | 2026-09-21 15:59 | 2026-09-21 15:58 | 2026-09-21 15:58 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 2.7600 | 2.7600 | 2.8000 | 339.3100 | 276000.00 | 0.00 | 276000.00 | 1000 | 10 | 4830 | 215 | 22.4651162790698 | 0.215526243573314 | 0.215526243573314 | true | false | false | true | ||||||||||||||||
| 8329d6d7-ec91-4b89-bbef-c42e6860474c | 2026-09-21 15:58 | 2026-09-21 15:58 | 2026-09-21 15:58 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 2.6600 | 2.5500 | 2.6600 | 338.9900 | 266265.00 | 265999.00 | 0.00 | 1001 | 44 | 3829 | 215 | 17.8093023255814 | 0.2168474213034 | 0.2168474213034 | false | false | false | true | false | |||||||||||||||
| 54b66102-beb1-4fb4-ac78-39c78b729377 | 2026-09-21 12:08 | 2026-09-21 12:08 | 2026-09-21 12:08 | AAPL | AAPL260928C00342500 | call | 342.5000 | 2026-09-28 | 2.3900 | 2.1600 | 2.4000 | 338.5250 | 16491.00 | 10994.00 | 5497.00 | 69 | 8 | 278 | 215 | 1.29302325581395 | 0.211336780520054 | 0.211336780520054 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:17:13.698421Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:55:18.072403Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:55:18.072403Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:46:04.686299Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:31:25.590153Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:14:10.282260Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:05:43.599354Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:59:16.361510Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 4977636972600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:40:21.587562Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:24:55.986256Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| 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 |
| Technology |
| 4958372655000.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:00:53.883267Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:51:29.790694Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4947135136400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4947135136400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4947135136400.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:10:34.961716Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |