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_alerts425,429 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 |
|---|
| 2aac2ffe-dea3-4d24-83ce-7b9a8785aa46 | 2026-09-23 09:55 | 2026-09-23 09:55 | 2026-09-23 09:55 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 14.6000 | 14.3500 | 14.6500 | 759.0000 | 343150.00 | 334450.00 | 8700.00 | 235 | 26 | 1738 | 672 | 2.58630952380952 | 0.74105369551436 | 0.740897556254276 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 1640836123547.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T13:57:01.829367Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 4ba9b994-9b25-4e1f-970c-f896359168af | 2026-09-23 09:50 | 2026-09-23 09:49 | 2026-09-23 09:49 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 15.7500 | 15.7000 | 16.0000 | 755.6501 | 85050.00 | 0.00 | 85050.00 | 54 | 6 | 1095 | 672 | 1.62946428571429 | 0.724375883346063 | 0.724375883346063 | false | false | false | true | false | |||||||||||||||
| 1e550606-99ce-460e-9abe-4828742c37b2 | 2026-09-23 09:50 | 2026-09-23 09:49 | 2026-09-23 09:49 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 15.7600 | 15.7500 | 16.0500 | 755.5550 | 12610.00 | 0.00 | 12610.00 | 8 | 6 | 951 | 672 | 1.41517857142857 | 0.722212313518002 | 0.722320491094663 | false | false | false | true | false | |||||||||||||||
| 8d3013f9-a5ed-44da-a66b-0c95c83c65a7 | 2026-09-23 09:49 | 2026-09-23 09:49 | 2026-09-23 09:49 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 15.7700 | 15.7000 | 16.0500 | 755.7009 | 219185.00 | 36445.00 | 182740.00 | 139 | 41 | 935 | 672 | 1.39136904761905 | 0.726914936212648 | 0.725472158614659 | true | false | false | true | ||||||||||||||||
| defc4a66-aac9-4d8a-b972-b55e6a1e4326 | 2026-09-23 09:49 | 2026-09-23 09:49 | 2026-09-23 09:49 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 16.0800 | 16.0000 | 16.3000 | 755.2600 | 136645.00 | 4815.00 | 131830.00 | 85 | 13 | 607 | 672 | 0.90327380952381 | 0.731730759563927 | 0.729378587756927 | false | false | false | true | ||||||||||||||||
| 5a08b73c-a4e9-4ef8-b70d-e004b23bc8d0 | 2026-09-23 09:49 | 2026-09-23 09:49 | 2026-09-23 09:49 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 16.0200 | 15.9500 | 16.2000 | 755.2950 | 70470.00 | 52870.00 | 17600.00 | 44 | 7 | 668 | 672 | 0.994047619047619 | 0.727352860067992 | 0.727896731625565 | true | false | false | true | ||||||||||||||||
| a97f7aa9-ac47-4fc0-8444-5922c13f402a | 2026-09-23 09:49 | 2026-09-23 09:49 | 2026-09-23 09:49 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 16.1200 | 16.1000 | 16.3500 | 755.2250 | 66110.00 | 32300.00 | 33810.00 | 41 | 5 | 515 | 672 | 0.766369047619048 | 0.733103346852882 | 0.730859950601456 | false | false | false | true | ||||||||||||||||
| b34f833d-994e-4230-96f8-3375514212e7 | 2026-09-23 09:49 | 2026-09-23 09:49 | 2026-09-23 09:49 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 16.6800 | 16.5500 | 16.9000 | 754.1953 | 246930.00 | 131775.00 | 115155.00 | 148 | 15 | 363 | 672 | 0.540178571428571 | 0.73300351797274 | 0.732880379600275 | false | false | false | true | ||||||||||||||||
| 472650e9-2992-4d3b-94ed-c6ccf4da3d4a | 2026-09-23 09:49 | 2026-09-23 09:49 | 2026-09-23 09:49 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 16.6000 | 16.5500 | 16.8000 | 754.1953 | 43160.00 | 11620.00 | 31540.00 | 26 | 5 | 389 | 672 | 0.578869047619048 | 0.730635278857965 | 0.730635278857965 | true | false | false | true | ||||||||||||||||
| a7b1af89-4ee9-4f68-8501-4b81a451957c | 2026-09-23 09:44 | 2026-09-23 09:44 | 2026-09-23 09:44 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 19.2900 | 19.1000 | 19.3500 | 748.0000 | 44375.00 | 42445.00 | 1930.00 | 23 | 7 | 73 | 672 | 0.108630952380952 | 0.72773316739335 | 0.726859798335164 | false | false | false | true | false | |||||||||||||||
| 1a6010aa-0dc9-4ad7-a85d-76a82fd55d19 | 2026-09-22 09:49 | 2026-09-22 09:48 | 2026-09-22 09:48 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 22.4600 | 22.4500 | 23.3000 | 744.9800 | 40435.00 | 4510.00 | 35925.00 | 18 | 7 | 302 | 141 | 2.14184397163121 | 0.631361870769625 | 0.63325454804778 | true | false | false | true | false | |||||||||||||||
| 28567523-6ff6-4206-b00e-5a0ec9d9f8ef | 2026-09-22 09:33 | 2026-09-22 09:33 | 2026-09-22 09:33 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 22.6900 | 22.3000 | 22.7000 | 745.3600 | 15885.00 | 13620.00 | 2265.00 | 7 | 6 | 57 | 141 | 0.404255319148936 | 0.649077585975276 | 0.647191274071863 | true | false | false | true | false | |||||||||||||||
| 87a2da27-2ef8-4d4d-8230-b46fecc15a93 | 2026-09-22 09:33 | 2026-09-22 09:33 | 2026-09-22 09:33 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 24.3500 | 23.9500 | 24.3500 | 742.5900 | 21915.00 | 21915.00 | 0.00 | 9 | 5 | 49 | 141 | 0.347517730496454 | 0.650199216295967 | 0.650199216295967 | false | false | false | true | false | |||||||||||||||
| 308f9bec-2f04-46dd-b72c-22a7bb6683ff | 2026-09-21 15:34 | 2026-09-21 15:34 | 2026-09-21 15:34 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 20.5000 | 20.5000 | 20.7500 | 752.4318 | 14350.00 | 0.00 | 14350.00 | 7 | 7 | 217 | 0 | 0 | 0.61526541872403 | 0.61526541872403 | false | false | false | true | false | |||||||||||||||
| f24dac6f-0ec6-4b6f-b31e-cf40cb77473b | 2026-09-21 15:34 | 2026-09-21 15:34 | 2026-09-21 15:34 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 21.6500 | 21.6500 | 21.8000 | 749.8191 | 30315.00 | 2170.00 | 28145.00 | 14 | 6 | 210 | 0 | 0 | 0.607558645116104 | 0.608895783576985 | false | false | false | true | false | |||||||||||||||
| deb6583b-4196-425b-a1ce-bce16674fdf5 | 2026-09-21 15:15 | 2026-09-21 15:15 | 2026-09-21 15:15 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 23.8500 | 23.8500 | 24.0500 | 745.1650 | 45315.00 | 0.00 | 45315.00 | 19 | 5 | 178 | 0 | 0 | 0.597625073763731 | 0.597625073763731 | true | false | false | true | false | |||||||||||||||
| bb9d5cb8-d0f0-41d7-ab33-d51207c18c23 | 2026-09-21 15:06 | 2026-09-21 15:06 | 2026-09-21 15:06 | META | META260925P00755000 | put | 755.0000 | 2026-09-25 | 24.5500 | 24.5500 | 24.7500 | 744.5000 | 39280.00 | 0.00 | 39280.00 | 16 | 11 | 150 | 0 | 0 | 0.60810463179019 | 0.60810463179019 | true | false | false | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:50:57.741684Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:50:57.741684Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:50:57.741684Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:50:57.741684Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:50:57.741684Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:50:57.741684Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:50:57.741684Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:50:57.741684Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:45:53.710169Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:50:24.302840Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:35:07.797098Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:33:30.058722Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:36:57.124687Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:36:57.124687Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |