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_alerts658,639 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 |
|---|
| 545f41a5-47b3-41a5-8689-7c9b4119c987 | 2026-09-23 11:10 | 2026-09-23 11:10 | 2026-09-23 11:10 | AAPL | AAPL260925P00337500 | put | 337.5000 | 2026-09-25 | 2.4000 | 2.3200 | 2.4000 | 338.2050 | 60000.00 | 60000.00 | 0.00 | 250 | 10 | 4492 | 1903 | 2.36048344718865 | 0.27785323228907 | 0.27785323228907 | false | false | false | true | false | 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-23T15:14:40.062093Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 2b432f7c-16d1-45e5-b733-8b3c7c3da1ee | 2026-09-23 11:05 | 2026-09-23 11:05 | 2026-09-23 11:05 | AAPL | AAPL260925P00337500 | put | 337.5000 | 2026-09-25 | 2.3000 | 2.2200 | 2.3000 | 338.3800 | 11500.00 | 11500.00 | 0.00 | 50 | 6 | 4199 | 1903 | 2.20651602732528 | 0.275638638541615 | 0.275638638541615 | false | false | false | true | false | |||||||||||||||
| a35e14c7-7542-400b-b400-47b8b0bc7d7d | 2026-09-23 10:18 | 2026-09-23 10:18 | 2026-09-23 10:18 | AAPL | AAPL260925P00337500 | put | 337.5000 | 2026-09-25 | 3.1200 | 3.1000 | 3.2000 | 336.0000 | 14952.00 | 2552.00 | 12400.00 | 48 | 6 | 3406 | 1903 | 1.78980557015239 | 0.270665278292314 | 0.279766212534707 | false | false | false | true | false | |||||||||||||||
| 98e8ce7d-b2a1-4be5-aa3f-b2949a841cce | 2026-09-23 09:59 | 2026-09-23 09:59 | 2026-09-23 09:59 | AAPL | AAPL260925P00337500 | put | 337.5000 | 2026-09-25 | 2.7800 | 2.7000 | 2.7900 | 337.4500 | 22240.00 | 21962.00 | 0.00 | 80 | 6 | 2736 | 1903 | 1.43772990015765 | 0.28015724852322 | 0.28015724852322 | false | false | false | true | false | |||||||||||||||
| b3552a67-f0eb-43a9-a3e3-daf14058ad0a | 2026-09-23 09:48 | 2026-09-23 09:48 | 2026-09-23 09:48 | AAPL | AAPL260925P00337500 | put | 337.5000 | 2026-09-25 | 2.3600 | 2.3600 | 2.4800 | 338.0000 | 61832.00 | 0.00 | 61832.00 | 262 | 20 | 1921 | 1903 | 1.00945874934314 | 0.28438349750251 | 0.288809517488517 | false | false | false | true | false | |||||||||||||||
| b2abaa07-8fcd-4ac5-bd1c-2944173eca23 | 2026-09-22 14:42 | 2026-09-22 14:42 | 2026-09-22 14:42 | AAPL | AAPL260925P00337500 | put | 337.5000 | 2026-09-25 | 1.6700 | 1.6700 | 1.7500 | 341.0900 | 63961.00 | 0.00 | 63961.00 | 383 | 21 | 3791 | 1567 | 2.41927249521378 | 0.25949218224228 | 0.25949218224228 | false | false | false | true | false | |||||||||||||||
| aa8a87bb-942a-4c0e-a446-c169b5515221 | 2026-09-22 14:25 | 2026-09-22 14:25 | 2026-09-22 14:25 | AAPL | AAPL260925P00337500 | put | 337.5000 | 2026-09-25 | 1.5800 | 1.5500 | 1.5800 | 341.4601 | 26386.00 | 26386.00 | 0.00 | 167 | 28 | 3369 | 1567 | 2.14996809189534 | 0.261753323291862 | 0.261753323291862 | true | false | false | true | false | |||||||||||||||
| 6867828b-d0d2-42b0-8523-532e98146576 | 2026-09-22 13:54 | 2026-09-22 13:54 | 2026-09-22 13:54 | AAPL | AAPL260925P00337500 | put | 337.5000 | 2026-09-25 | 1.8500 | 1.7800 | 1.8900 | 340.6400 | 12580.00 | 12213.00 | 367.00 | 68 | 7 | 2985 | 1567 | 1.90491384811742 | 0.261486223144874 | 0.265038639314223 | false | false | false | true | false | |||||||||||||||
| 2af05f3c-4bde-4a22-b525-99cc555ae08e | 2026-09-22 10:27 | 2026-09-22 10:26 | 2026-09-22 10:26 | AAPL | AAPL260925P00337500 | put | 337.5000 | 2026-09-25 | 2.0400 | 2.0200 | 2.1300 | 340.0000 | 10404.00 | 0.00 | 10404.00 | 51 | 6 | 1539 | 1567 | 0.982131461391193 | 0.266788243278403 | 0.266788243278403 | false | false | false | true | false | |||||||||||||||
| e859a862-0d33-48ef-9fd8-78f9cf5075db | 2026-09-22 09:55 | 2026-09-22 09:55 | 2026-09-22 09:55 | AAPL | AAPL260925P00337500 | put | 337.5000 | 2026-09-25 | 2.0300 | 2.0300 | 2.1600 | 340.5101 | 18270.00 | 0.00 | 18270.00 | 90 | 21 | 908 | 1567 | 0.579451180599872 | 0.274267439650925 | 0.274267439650925 | false | false | false | true | false | |||||||||||||||
| ed8eb5ec-c66e-479f-a9c1-007c366ecb73 | 2026-09-21 13:55 | 2026-09-21 13:55 | 2026-09-21 13:55 | AAPL | AAPL260925P00337500 | put | 337.5000 | 2026-09-25 | 3.0000 | 2.8700 | 3.0000 | 338.3800 | 15300.00 | 15300.00 | 0.00 | 51 | 10 | 1731 | 726 | 2.38429752066116 | 0.24729905149286 | 0.24729905149286 | false | false | false | true | false | |||||||||||||||
| d5e95e99-7ca6-4d71-9e70-5bca48c8a00b | 2026-09-21 13:55 | 2026-09-21 13:55 | 2026-09-21 13:55 | AAPL | AAPL260925P00337500 | put | 337.5000 | 2026-09-25 | 2.9800 | 2.8600 | 2.9900 | 338.4059 | 24435.00 | 24435.00 | 0.00 | 82 | 12 | 1680 | 726 | 2.31404958677686 | 0.246698805667992 | 0.246698805667992 | true | false | false | true | false | |||||||||||||||
| 21b29f6f-b4ab-4192-9764-b64dca3982c4 | 2026-09-21 11:19 | 2026-09-21 11:19 | 2026-09-21 11:19 | AAPL | AAPL260925P00337500 | put | 337.5000 | 2026-09-25 | 3.4000 | 3.3000 | 3.4500 | 337.6850 | 13260.00 | 12580.00 | 680.00 | 39 | 16 | 449 | 726 | 0.618457300275482 | 0.252807882724151 | 0.252807882724151 | true | false | false | true | false |
| 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-23T15:09:03.866421Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| 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 |
| 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-23T14:00:44.029710Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 4918530543600.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:49:25.662048Z"} |
| 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:44:24.241276Z"} |
| 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-22T18:29:55.439380Z"} |
| 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-22T17:57:38.128984Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:27:42.600893Z"} |
| 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-22T13:56:25.927111Z"} |
| 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-21T18:00:14.697100Z"} |
| 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-21T17:55:32.885478Z"} |
| 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-21T15:22:54.080611Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |