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 | 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 |
|---|
| 86888114-4764-40e2-9aaa-57927b1e8494 | 2026-09-21 15:42 | 2026-09-21 15:42 | 2026-09-21 15:42 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 5.2500 | 5.2500 | 5.3000 | 747.7550 | 16275.00 | 0.00 | 16275.00 | 31 | 5 | 4819 | 5 | 963.8 | 0.603294105980734 | 0.603294105980734 | true | false | false | true | false | 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-21T19:43:03.886437Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 6b353044-8194-4811-ac98-033f2ccb7c1c | 2026-09-22 09:35 | 2026-09-22 09:35 | 2026-09-22 09:35 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 3.9900 | 3.8500 | 4.0500 | 747.3800 | 11575.00 | 10392.00 | 393.00 | 29 | 9 | 1733 | 1950 | 0.888717948717949 | 0.760877433201713 | 0.760877433201713 | false | false | false | |||||||||||||||||
| 4c83559c-a4f1-445e-a219-ffd372e51baa | 2026-09-22 09:37 | 2026-09-22 09:37 | 2026-09-22 09:37 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 6.6900 | 6.6500 | 6.9000 | 755.4050 | 11365.00 | 0.00 | 11365.00 | 17 | 13 | 4767 | 1950 | 2.44461538461538 | 0.791168273877957 | 0.799535191275813 | false | false | false | |||||||||||||||||
| 97c01d4e-95cf-4d5f-83f2-a343d573165d | 2026-09-22 09:37 | 2026-09-22 09:37 | 2026-09-22 09:37 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 6.9100 | 6.8500 | 7.1500 | 756.0700 | 11050.00 | 4200.00 | 6850.00 | 16 | 5 | 5053 | 1950 | 2.59128205128205 | 0.804435102635896 | 0.789627457552765 | false | false | false | |||||||||||||||||
| 644844ad-cde8-487b-a400-4f1e6dab218e | 2026-09-22 09:38 | 2026-09-22 09:38 | 2026-09-22 09:38 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 6.8000 | 6.8000 | 7.0500 | 756.7150 | 34702.00 | 0.00 | 34702.00 | 51 | 7 | 5931 | 1950 | 3.04153846153846 | 0.771071848661211 | 0.771071848661211 | false | false | false | |||||||||||||||||
| 6d152cee-19bd-4faf-b070-d06b6a300a34 | 2026-09-22 10:07 | 2026-09-22 10:07 | 2026-09-22 10:07 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 3.0000 | 3.0000 | 3.1000 | 746.1900 | 114900.00 | 0.00 | 114900.00 | 383 | 5 | 10980 | 1950 | 5.63076923076923 | 0.695226618334296 | 0.697250908802118 | false | false | false | |||||||||||||||||
| 61418d21-7719-43f0-b1b4-f764bab45b0d | 2026-09-22 10:10 | 2026-09-22 10:10 | 2026-09-22 10:10 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 3.5100 | 3.4000 | 3.6000 | 748.7500 | 35417.00 | 2100.00 | 33317.00 | 101 | 10 | 12096 | 1950 | 6.20307692307692 | 0.693177001456172 | 0.692329262072208 | true | false | false | |||||||||||||||||
| 9430690d-4eb8-4593-be52-374b04789b70 | 2026-09-22 10:10 | 2026-09-22 10:10 | 2026-09-22 10:10 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 3.7000 | 3.6500 | 3.7000 | 749.4100 | 106930.00 | 106930.00 | 0.00 | 289 | 11 | 12572 | 1950 | 6.44717948717949 | 0.695994878009319 | 0.697165508714223 | false | false | false | |||||||||||||||||
| 524670c8-c4b3-47e4-b794-06bc8d28e125 | 2026-09-22 10:11 | 2026-09-22 10:11 | 2026-09-22 10:11 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 4.2000 | 4.2000 | 4.3000 | 751.4100 | 11760.00 | 0.00 | 11760.00 | 28 | 5 | 14805 | 1950 | 7.59230769230769 | 0.697681673964497 | 0.697681673964497 | false | false | false | |||||||||||||||||
| c090dc13-f98e-462a-8b83-0d1ead19e8d8 | 2026-09-22 10:15 | 2026-09-22 10:15 | 2026-09-22 10:15 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 4.5500 | 4.5500 | 4.6500 | 752.8900 | 14105.00 | 0.00 | 14105.00 | 31 | 9 | 15935 | 1950 | 8.17179487179487 | 0.69191441743968 | 0.694216810043888 | true | false | false | |||||||||||||||||
| 0dad35dd-048a-4734-983f-9c35414ca593 | 2026-09-22 10:22 | 2026-09-22 10:22 | 2026-09-22 10:22 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 3.6500 | 3.6500 | 3.7500 | 750.2400 | 18980.00 | 0.00 | 18980.00 | 52 | 7 | 17289 | 1950 | 8.86615384615385 | 0.676814246142811 | 0.676814246142811 | false | false | false | |||||||||||||||||
| 2862b3e0-02ec-418c-8362-ac104840d82f | 2026-09-22 11:46 | 2026-09-22 11:46 | 2026-09-22 11:46 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 2.5600 | 2.5600 | 2.6400 | 748.1600 | 10752.00 | 0.00 | 10752.00 | 42 | 8 | 21662 | 1950 | 11.1087179487179 | 0.618317434436312 | 0.620928725146506 | true | false | false | |||||||||||||||||
| 6569b285-5a71-40b4-bd5d-8cdbfdfa5548 | 2026-09-22 12:34 | 2026-09-22 12:34 | 2026-09-22 12:34 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 2.7700 | 2.6500 | 2.8000 | 747.9100 | 13860.00 | 13860.00 | 0.00 | 50 | 5 | 24991 | 1950 | 12.8158974358974 | 0.647552013040832 | 0.647552013040832 | false | false | false | |||||||||||||||||
| ebd07a9e-9749-481b-8cc4-9e0b017ab625 | 2026-09-22 14:08 | 2026-09-22 14:08 | 2026-09-22 14:08 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 1.5100 | 1.4700 | 1.5100 | 742.6100 | 15100.00 | 15100.00 | 0.00 | 100 | 11 | 29190 | 1950 | 14.9692307692308 | 0.6042566488627 | 0.6042566488627 | false | false | false | |||||||||||||||||
| 2f546b89-e2fa-41cb-a3c7-5ed57f856893 | 2026-09-23 09:47 | 2026-09-23 09:47 | 2026-09-23 09:47 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 1.5000 | 1.4800 | 1.5000 | 752.0000 | 16050.00 | 16050.00 | 0.00 | 107 | 23 | 6502 | 5994 | 1.08475141808475 | 0.878479088909884 | 0.878479088909884 | false | false | false | |||||||||||||||||
| abcf08e6-c255-43a0-b0f7-d4afe78f8131 | 2026-09-23 09:48 | 2026-09-23 09:48 | 2026-09-23 09:48 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 1.8100 | 1.8000 | 1.8500 | 754.0000 | 13970.00 | 3121.00 | 10849.00 | 77 | 19 | 8485 | 5994 | 1.41558224891558 | 0.881138488207056 | 0.871273297308889 | true | false | false | |||||||||||||||||
| c1d21631-7539-45a9-a016-e3092073f517 | 2026-09-23 09:50 | 2026-09-23 09:50 | 2026-09-23 09:50 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 2.6000 | 2.5500 | 2.6000 | 757.0950 | 15860.00 | 15860.00 | 0.00 | 61 | 15 | 11696 | 5994 | 1.95128461795128 | 0.904797903314288 | 0.904797903314288 | true | false | false | |||||||||||||||||
| 1efaa21f-38ab-43d1-8728-0493f8df4570 | 2026-09-23 09:57 | 2026-09-23 09:56 | 2026-09-23 09:56 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 4.4800 | 4.4500 | 4.6500 | 763.4800 | 12531.00 | 460.00 | 12071.00 | 28 | 10 | 17388 | 5994 | 2.9009009009009 | 0.906520489754504 | 0.900618602429962 | true | false | false | |||||||||||||||||
| 616b97b4-dbc8-4126-b649-b58963fc2453 | 2026-09-23 09:57 | 2026-09-23 09:57 | 2026-09-23 09:57 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 4.1100 | 4.1000 | 4.2000 | 762.3000 | 10279.00 | 828.00 | 9451.00 | 25 | 5 | 17679 | 5994 | 2.94944944944945 | 0.908516864110191 | 0.909847056604083 | true | false | false | |||||||||||||||||
| af018a48-561d-48d6-8739-bf0ae2259050 | 2026-09-23 10:00 | 2026-09-23 10:00 | 2026-09-23 10:00 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 3.2000 | 3.2000 | 3.3000 | 759.6429 | 12480.00 | 0.00 | 12480.00 | 39 | 6 | 19661 | 5994 | 3.28011344678011 | 0.904704182293776 | 0.904704182293776 | true | false | false | |||||||||||||||||
| c5c0c227-e654-428a-be55-dad18d831e78 | 2026-09-23 10:08 | 2026-09-23 10:08 | 2026-09-23 10:08 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 1.0000 | 0.9800 | 1.0500 | 748.8400 | 18205.00 | 105.00 | 18100.00 | 182 | 15 | 24955 | 5994 | 4.16332999666333 | 0.900649065740453 | 0.913573610674419 | false | false | false | |||||||||||||||||
| 1d289c93-92da-4cb1-ba68-c70d4b87e761 | 2026-09-23 11:20 | 2026-09-23 11:20 | 2026-09-23 11:20 | META | META260923C00770000 | call | 770.0000 | 2026-09-23 | 1.0000 | 0.9800 | 1.0100 | 755.5700 | 11800.00 | 11800.00 | 0.00 | 118 | 14 | 43118 | 5994 | 7.19352686019353 | 0.770996041375506 | 0.770996041375506 | false | false | false |
| false |
| 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:36:05.660724Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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:39:02.678096Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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:39:02.678096Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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:39:02.678096Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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:11:50.316445Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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:11:50.316445Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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:13:22.184869Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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:17:46.082263Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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:23:46.275389Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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-22T15:49:01.734970Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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-22T16:35:05.886735Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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-22T18:10:48.215993Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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:49:25.662048Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| 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:49:25.662048Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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 |
| 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:58:49.832976Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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:58:49.832976Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-23T14:00:44.029710Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-23T14:09:27.878659Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-23T15:23:47.442599Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |