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 | price |
|---|
| 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 |
|---|
| 831dc4ac-6d1a-4b74-8d8d-f1044105dfc1 | 2026-09-24 10:12 | 2026-09-24 10:12 | 2026-09-24 10:12 | HPQ | HPQ261002C00032000 | call | 32.0000 | 2026-10-02 | 0.9100 | 0.8600 | 1.0200 | 31.9150 | 18246.00 | 0.00 | 18246.00 | 200 | 5 | 201 | 187 | 1.07486631016043 | 0.502721780723024 | 0.502721780723024 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 29001597563.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T14:14:26.159357Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| e3d99424-077a-440a-aa6d-25468a4b31c2 | 2026-09-24 10:33 | 2026-09-24 10:33 | 2026-09-24 10:33 | HPQ | HPQ270219P00034000 | put | 34.0000 | 2027-02-19 | 5.1500 | 4.8500 | 5.2500 | 31.9000 | 20600.00 | 3090.00 | 17510.00 | 40 | 17 | 40 | 199 | 0.201005025125628 | 0.52847678344125 | 0.52727340607425 | false | false | false | true | false | |||||||||||||||
| cb008d38-60c6-4c76-8217-c747ff9644aa | 2026-09-24 10:45 | 2026-09-24 10:45 | 2026-09-24 10:45 | HPQ | HPQ261023P00033000 | put | 33.0000 | 2026-10-23 | 2.2100 | 2.1400 | 2.2100 | 32.0500 | 28730.00 | 28730.00 | 0.00 | 130 | 15 | 130 | 26 | 5 | 0.480981390074295 | 0.480981390074295 | false | false | false | true | false | |||||||||||||||
| a53f6ab3-69e2-45a8-9963-5c1ae6f989c4 | 2026-09-24 11:40 | 2026-09-24 11:40 | 2026-09-24 11:40 | HPQ | HPQ261120P00032000 | put | 32.0000 | 2026-11-20 | 2.5800 | 2.5100 | 2.5900 | 31.5500 | 17285.00 | 16513.00 | 772.00 | 67 | 15 | 110 | 312 | 0.352564102564103 | 0.493427983603596 | 0.494481890106813 | true | false | false | true | false | |||||||||||||||
| 999f6c93-6034-4f04-8171-ed9d67837f09 | 2026-09-24 14:34 | 2026-09-24 14:33 | 2026-09-24 14:33 | HPQ | HPQ260925P00032000 | put | 32.0000 | 2026-09-25 | 0.5800 | 0.5500 | 0.5800 | 31.5950 | 18560.00 | 18560.00 | 0.00 | 320 | 23 | 523 | 1203 | 0.43474646716542 | 0.515814504961115 | 0.515814504961115 | false | false | false | true | false | |||||||||||||||
| 43598beb-de21-4ffb-b3cf-686a10d6bfaf | 2026-09-24 15:18 | 2026-09-24 15:18 | 2026-09-24 15:18 | HPQ | HPQ260925P00032000 | put | 32.0000 | 2026-09-25 | 0.6100 | 0.5400 | 0.6100 | 31.0000 | 12749.00 | 12749.00 | 0.00 | 209 | 33 | 752 | 1203 | 0.625103906899418 | 0.549177941834077 | 0.53209428940621 | false | false | false | true | false | |||||||||||||||
| 2ea3583c-513d-4948-81ef-2bd516ad7310 | 2026-09-25 10:03 | 2026-09-25 10:03 | 2026-09-25 10:03 | HPQ | HPQ261016C00030000 | call | 30.0000 | 2026-10-16 | 2.3000 | 2.3000 | 2.4000 | 31.4500 | 31050.00 | 0.00 | 31050.00 | 135 | 39 | 360 | 1728 | 0.208333333333333 | 0.481282729858488 | 0.481282729858488 | true | false | false | true | false | |||||||||||||||
| dd64bde8-2f7d-4df3-a7c8-6c39bb9df5c3 | 2026-09-25 10:25 | 2026-09-25 10:24 | 2026-09-25 10:24 | HPQ | HPQ260925C00031000 | call | 31.0000 | 2026-09-25 | 0.5000 | 0.3500 | 0.5000 | 31.4250 | 19950.00 | 19950.00 | 0.00 | 399 | 7 | 603 | 365 | 1.65205479452055 | 0.719350695746053 | 0.719350695746053 | false | false | false | true | false | |||||||||||||||
| fdd05329-6bdc-4a03-afb0-3733da1c44cc | 2026-09-25 10:45 | 2026-09-25 10:45 | 2026-09-25 10:45 | HPQ | HPQ261009C00031500 | call | 31.5000 | 2026-10-09 | 1.2000 | 1.1200 | 1.2100 | 31.5050 | 23161.00 | 23161.00 | 0.00 | 193 | 29 | 194 | 84 | 2.30952380952381 | 0.479287741378569 | 0.481220523226883 | false | false | false | true | false | |||||||||||||||
| c109a65c-3065-49d8-b43d-eaf2a74143a9 | 2026-09-25 11:15 | 2026-09-25 11:15 | 2026-09-25 11:15 | HPQ | HPQ261120P00030000 | put | 30.0000 | 2026-11-20 | 1.5800 | 1.5200 | 1.5800 | 31.5150 | 29862.00 | 29862.00 | 0.00 | 189 | 17 | 249 | 1298 | 0.191833590138675 | 0.488169207046216 | 0.488169207046216 | false | false | false | true | false | |||||||||||||||
| e8ed8e2d-84fb-41a2-8b36-552874f2dc35 | 2026-09-25 11:41 | 2026-09-25 11:41 | 2026-09-25 11:41 | HPQ | HPQ261016C00030000 | call | 30.0000 | 2026-10-16 | 2.3000 | 2.3000 | 2.4200 | 31.0000 | 19090.00 | 0.00 | 19090.00 | 83 | 15 | 1134 | 1728 | 0.65625 | 0.473524561511706 | 0.473524561511706 | false | false | false | true | false | |||||||||||||||
| d6957b58-26d2-4d5d-a0d8-1fe73604edd2 | 2026-09-25 12:10 | 2026-09-25 12:10 | 2026-09-25 12:10 | HPQ | HPQ280121P00023000 | put | 23.0000 | 2028-01-21 | 2.7000 | 2.6600 | 2.9500 | 31.6100 | 15913.00 | 2493.00 | 13420.00 | 59 | 8 | 62 | 2414 | 0.0256835128417564 | 0.546649174501295 | 0.558128651000859 | false | false | false | true | false | |||||||||||||||
| 317f3adf-6da9-4d02-a63c-a1e3fe1be4d9 | 2026-09-25 12:10 | 2026-09-25 12:10 | 2026-09-25 12:10 | HPQ | HPQ280121P00023000 | put | 23.0000 | 2028-01-21 | 2.7400 | 2.7200 | 2.9300 | 31.6100 | 16713.00 | 4701.00 | 12012.00 | 61 | 6 | 123 | 2414 | 0.0509527754763877 | 0.553927432919224 | 0.553927432919224 | true | false | false | true | false | |||||||||||||||
| 97e153e6-5106-4c7e-912e-9423d65591b3 | 2026-09-25 12:10 | 2026-09-25 12:10 | 2026-09-25 12:10 | HPQ | HPQ280121P00023000 | put | 23.0000 | 2028-01-21 | 2.7300 | 2.7300 | 2.9100 | 31.6200 | 48066.00 | 4932.00 | 43134.00 | 176 | 13 | 313 | 2414 | 0.129660314830157 | 0.553927432919224 | 0.554115686005767 | false | false | false | true | false | |||||||||||||||
| 6bd8bd13-b4ca-4773-841e-33d2442aeed6 | 2026-09-25 12:54 | 2026-09-25 12:54 | 2026-09-25 12:54 | HPQ | HPQ270115C00040000 | call | 40.0000 | 2027-01-15 | 1.2100 | 1.2100 | 1.3000 | 31.5550 | 11132.00 | 0.00 | 11132.00 | 92 | 16 | 93 | 2030 | 0.0458128078817734 | 0.510435513556955 | 0.510435513556955 | false | false | false | true | false | |||||||||||||||
| e5e7f005-6a78-4852-9cc9-1afbcebfeefb | 2026-09-25 13:35 | 2026-09-25 13:35 | 2026-09-25 13:35 | HPQ | HPQ261120C00032000 | call | 32.0000 | 2026-11-20 | 2.2800 | 2.1600 | 2.2800 | 31.0000 | 23019.00 | 22797.00 | 222.00 | 101 | 8 | 187 | 3606 | 0.0518580144204104 | 0.503173102776834 | 0.490933277656788 | false | false | false | true | false | |||||||||||||||
| 9c3a5cad-3ea2-40e6-bf3f-dceee68c92b6 | 2026-09-25 13:40 | 2026-09-25 13:40 | 2026-09-25 13:40 | HPQ | HPQ261016C00030000 | call | 30.0000 | 2026-10-16 | 2.2000 | 2.1600 | 2.2800 | 31.0000 | 87120.00 | 83820.00 | 3300.00 | 396 | 13 | 1785 | 1728 | 1.03298611111111 | 0.46820898783261 | 0.474510044849305 | false | false | false | true | false | |||||||||||||||
| 007dc5a2-036c-429f-a1f7-45ce5dc0c60f | 2026-09-25 14:53 | 2026-09-25 14:52 | 2026-09-25 14:52 | HPQ | HPQ261016P00034000 | put | 34.0000 | 2026-10-16 | 3.1000 | 3.1000 | 3.2500 | 31.0000 | 18600.00 | 0.00 | 18600.00 | 60 | 11 | 5064 | 13707 | 0.36944626833005 | 0.469691548758952 | 0.486028881087985 | false | false | false | true | false | |||||||||||||||
| d54db63e-a8d9-478a-8488-f4d95e92254a | 2026-09-25 15:44 | 2026-09-25 15:44 | 2026-09-25 15:44 | HPQ | HPQ260925P00032000 | put | 32.0000 | 2026-09-25 | 0.7000 | 0.6700 | 0.7500 | 31.0000 | 13020.00 | 6300.00 | 6720.00 | 186 | 8 | 2861 | 3296 | 0.868021844660194 | 1.27063459132817 | 3.65600107698886 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 29001597563.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:35:45.310206Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 29001597563.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:46:40.041951Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 29001597563.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:45:14.547721Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 29001597563.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:38:47.854858Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 29001597563.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:21:59.976006Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 28226057330.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:04:05.801469Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 28226057330.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:26:29.670335Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 28226057330.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:47:41.799650Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 28226057330.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:19:48.264136Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 28226057330.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:42:35.066388Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 28226057330.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:10:39.655295Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 28226057330.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:10:39.655295Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 28226057330.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:10:39.655295Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 28226057330.00 |
| 2026-11-24 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:59:29.985705Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 28226057330.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:41:26.046305Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 28226057330.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:41:26.046305Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 28226057330.00 |
| 2026-11-24 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 28226057330.00 |
| 2026-11-24 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:47:28.119549Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |