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 | expiry |
|---|
| 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 |
|---|
| fc885e3c-7a0c-476e-b47b-0d0bea91188b | 2026-09-23 14:40 | 2026-09-23 14:40 | 2026-09-23 14:40 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 53.8000 | 53.8000 | 53.9500 | 747.9650 | 80700.00 | 0.00 | 80700.00 | 15 | 11 | 142 | 1637 | 0.0867440439828955 | 0.458572462511139 | 0.459639311130195 | 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-23T18:40:32.778143Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 6229e211-ada5-4160-b7d5-ce8e1248f409 | 2026-09-22 15:02 | 2026-09-22 15:01 | 2026-09-22 15:01 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 46.7500 | 46.6000 | 46.9500 | 738.8300 | 28050.00 | 23375.00 | 4675.00 | 6 | 6 | 560 | 2022 | 0.276953511374876 | 0.435087092304845 | 0.435087092304845 | false | false | false | true | ||||||||||||||||
| 5fb73529-19e5-44ad-8326-d81bcb277084 | 2026-09-22 15:02 | 2026-09-22 15:01 | 2026-09-22 15:01 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 46.8000 | 46.6000 | 46.8000 | 738.6110 | 56160.00 | 56160.00 | 0.00 | 12 | 12 | 554 | 2022 | 0.273986152324431 | 0.437796922137872 | 0.437796922137872 | false | false | false | true | ||||||||||||||||
| e0f9dd6b-cdce-497d-bfdc-e7d158fd6cd9 | 2026-09-22 15:01 | 2026-09-22 15:01 | 2026-09-22 15:01 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 46.7200 | 46.7000 | 47.1500 | 738.6300 | 42045.00 | 9350.00 | 4675.00 | 9 | 9 | 539 | 2022 | 0.266567754698319 | 0.436206684430878 | 0.436915201880837 | false | false | false | true | ||||||||||||||||
| 48b71215-e168-45be-bb01-9f3785381d1f | 2026-09-22 10:36 | 2026-09-22 10:36 | 2026-09-22 10:36 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 54.4500 | 54.1000 | 54.4500 | 749.9900 | 43560.00 | 43560.00 | 0.00 | 8 | 8 | 435 | 2022 | 0.21513353115727 | 0.438381650654328 | 0.438381650654328 | false | false | false | true | ||||||||||||||||
| b7d3623b-f099-4ffe-a66e-a62a02df2ab8 | 2026-09-22 10:14 | 2026-09-22 10:14 | 2026-09-22 10:14 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 55.7500 | 55.7500 | 56.7500 | 751.9800 | 189550.00 | 0.00 | 189550.00 | 34 | 13 | 401 | 2022 | 0.198318496538081 | 0.437076759997874 | 0.437076759997874 | true | false | false | true | ||||||||||||||||
| b63b57b5-936f-42ea-b3c5-fa240326dea1 | 2026-09-22 10:14 | 2026-09-22 10:13 | 2026-09-22 10:13 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 55.8700 | 55.8500 | 56.9500 | 751.8300 | 61460.00 | 0.00 | 61460.00 | 11 | 10 | 362 | 2022 | 0.179030662710188 | 0.439527843104371 | 0.440140632964693 | false | false | false | true | ||||||||||||||||
| 183fc65d-2fa3-4779-a705-3694fe9e74a7 | 2026-09-22 09:44 | 2026-09-22 09:44 | 2026-09-22 09:44 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 52.8000 | 52.0500 | 52.8000 | 745.0000 | 132000.00 | 132000.00 | 0.00 | 25 | 15 | 60 | 2022 | 0.029673590504451 | 0.454945752718816 | 0.457463862269344 | false | false | false | true | ||||||||||||||||
| 92561b4b-799c-48ed-b100-4434e100d525 | 2026-09-21 14:00 | 2026-09-21 14:00 | 2026-09-21 14:00 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 53.0500 | 53.0500 | 53.3000 | 744.0000 | 84880.00 | 0.00 | 84880.00 | 16 | 13 | 1319 | 1881 | 0.701222753854333 | 0.465558119443676 | 0.465558119443676 | true | false | false | true | ||||||||||||||||
| eb32c8d7-1508-43a2-b183-ddb393dd6c0c | 2026-09-21 13:40 | 2026-09-21 13:40 | 2026-09-21 13:40 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 49.5500 | 49.0500 | 49.6000 | 739.8000 | 222977.00 | 222977.00 | 0.00 | 45 | 31 | 1284 | 1881 | 0.682615629984051 | 0.455787991510057 | 0.456480690266525 | false | false | false | true | ||||||||||||||||
| 960fea4e-33b9-47b4-a722-2eb47e5e8f8d | 2026-09-21 13:39 | 2026-09-21 13:39 | 2026-09-21 13:39 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 49.3000 | 49.3000 | 49.5000 | 739.9000 | 59160.00 | 0.00 | 59160.00 | 12 | 7 | 1238 | 1881 | 0.658160552897395 | 0.451428986610316 | 0.451428986610316 | false | false | false | true | ||||||||||||||||
| de76cf49-5454-4c37-8d4f-c44586f89e53 | 2026-09-21 12:52 | 2026-09-21 12:52 | 2026-09-21 12:52 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 41.3500 | 41.3500 | 41.5500 | 728.0000 | 33080.00 | 0.00 | 33080.00 | 8 | 7 | 1186 | 1881 | 0.630515683147262 | 0.438067229041378 | 0.438067229041378 | false | false | false | true | ||||||||||||||||
| f18deaa2-6cfb-4a10-bd04-8c8743f2ba34 | 2026-09-21 12:40 | 2026-09-21 12:40 | 2026-09-21 12:40 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 41.1900 | 41.1500 | 41.5500 | 727.8601 | 37070.00 | 12360.00 | 24710.00 | 9 | 8 | 1144 | 1881 | 0.608187134502924 | 0.441198778207982 | 0.442643424452385 | true | false | false | true | ||||||||||||||||
| 836fc51e-6e46-4b12-a015-cd3b2d69410d | 2026-09-21 12:37 | 2026-09-21 12:37 | 2026-09-21 12:37 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 40.8500 | 40.8500 | 41.1000 | 727.2901 | 61275.00 | 0.00 | 61275.00 | 15 | 7 | 1135 | 1881 | 0.603402445507709 | 0.441593641102159 | 0.442471254547635 | true | false | false | true | ||||||||||||||||
| 485bf33d-f854-4b80-8784-bd36d904fa72 | 2026-09-21 11:45 | 2026-09-21 11:45 | 2026-09-21 11:45 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 35.0500 | 35.0500 | 35.3000 | 719.3100 | 24535.00 | 0.00 | 24535.00 | 7 | 7 | 940 | 1881 | 0.49973418394471 | 0.425851907955295 | 0.425851907955295 | false | false | false | true | ||||||||||||||||
| 8a12e408-18a9-4bbf-bde2-e0da9eaecf1d | 2026-09-21 11:32 | 2026-09-21 11:32 | 2026-09-21 11:32 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 30.9500 | 30.9500 | 31.1000 | 712.7700 | 24760.00 | 0.00 | 24760.00 | 8 | 5 | 854 | 1881 | 0.454013822434875 | 0.417947919765113 | 0.417947919765113 | false | false | false | true | ||||||||||||||||
| 1cfc29b6-290f-4d14-a354-80559427efc9 | 2026-09-21 10:30 | 2026-09-21 10:30 | 2026-09-21 10:30 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 29.7000 | 29.5000 | 29.7000 | 710.5100 | 14850.00 | 14850.00 | 0.00 | 5 | 5 | 600 | 1881 | 0.318979266347687 | 0.416773312885582 | 0.416773312885582 | false | false | false | true | ||||||||||||||||
| 6ea3ce3f-7964-45ff-ae12-dcf88f4b6225 | 2026-09-21 10:17 | 2026-09-21 10:16 | 2026-09-21 10:16 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 32.5000 | 32.4500 | 33.0000 | 715.7250 | 32500.00 | 0.00 | 32500.00 | 10 | 7 | 362 | 1881 | 0.192450824029771 | 0.417275926050043 | 0.417815566504193 | true | false | false | true | ||||||||||||||||
| ec49e26a-c8dc-426e-b0f5-994756a88f67 | 2026-09-21 10:01 | 2026-09-21 10:01 | 2026-09-21 10:01 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 29.9800 | 29.6500 | 30.0000 | 711.0000 | 20985.00 | 20985.00 | 0.00 | 7 | 7 | 249 | 1881 | 0.13237639553429 | 0.416775176078712 | 0.41744898726163 | true | false | false | true | ||||||||||||||||
| 9cacec7b-265c-467b-a47d-96adeeff6902 | 2026-09-17 13:23 | 2026-09-17 13:23 | 2026-09-17 13:23 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 15.1800 | 15.1500 | 15.2000 | 678.2300 | 150299.00 | 95759.00 | 54540.00 | 99 | 14 | 245 | 1750 | 0.14 | 0.374648907833057 | 0.374648907833057 | false | false | false | true | ||||||||||||||||
| be7df597-c5e8-4732-8487-f7327582473b | 2026-09-08 10:09 | 2026-09-08 10:08 | 2026-09-08 10:08 | META | META261016C00715000 | call | 715.0000 | 2026-10-16 | 5.6700 | 5.4000 | 5.7500 | 618.7100 | 113450.00 | 113450.00 | 0.00 | 200 | 5 | 1110 | 324 | 3.42592592592593 | 0.391482442754058 | 0.391482442754058 | false | false | false | true |
| 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-22T19:02:38.336545Z"} |
| 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-22T19:02:38.336545Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T19:02:38.336545Z"} |
| 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-22T14:38:45.745623Z"} |
| 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-22T14:15:02.242582Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-22T14:15:02.242582Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:45:11.876123Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:05:09.858972Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| 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-21T17:43:51.748700Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| 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-21T17:43:51.748700Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:56:43.151057Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-21T16:41:29.676906Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| 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-21T16:38:21.627494Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| 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-21T15:46:21.763749Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| 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-21T15:32:21.239106Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| 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-21T14:32:01.820117Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| 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-21T14:18:27.541285Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-21T14:02:45.816631Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1504581232976.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1467733535590.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:14:21.867252Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |