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 |
|---|
| 13b1e5cd-d602-41be-bc7a-115c8ad1ceb2 | 2026-09-21 12:11 | 2026-09-21 12:11 | 2026-09-21 12:11 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 43.3000 | 43.1500 | 43.3500 | 724.2650 | 34640.00 | 25980.00 | 8660.00 | 8 | 7 | 82 | 1 | 82 | 0.432697882508794 | 0.432469762197288 | false | 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-21T16:13:06.153982Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 14cc6703-3fd9-4541-a9a2-2638514d56fe | 2026-09-21 12:11 | 2026-09-21 12:11 | 2026-09-21 12:11 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 43.4000 | 43.2000 | 43.4000 | 724.3900 | 121520.00 | 121520.00 | 0.00 | 28 | 12 | 112 | 1 | 112 | 0.434760114084564 | 0.434760114084564 | true | false | false | |||||||||||||||||
| 6a369888-4612-46d2-8ca7-3f37641744c7 | 2026-09-21 12:16 | 2026-09-21 12:15 | 2026-09-21 12:16 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 42.6000 | 42.3000 | 42.6500 | 726.1600 | 25560.00 | 25560.00 | 0.00 | 6 | 6 | 119 | 1 | 119 | 0.437345973461515 | 0.437345973461515 | true | false | false | |||||||||||||||||
| 62c5412b-0a09-4996-891e-06ee8b130fe0 | 2026-09-21 13:08 | 2026-09-21 13:08 | 2026-09-21 13:08 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 39.2400 | 38.8500 | 39.3000 | 734.0101 | 47090.00 | 43170.00 | 3920.00 | 12 | 8 | 170 | 1 | 170 | 0.449172086556441 | 0.448114025588954 | true | false | false | |||||||||||||||||
| aa996d66-cdfd-4b85-859f-ca59e9a0da2d | 2026-09-21 13:59 | 2026-09-21 13:59 | 2026-09-21 13:59 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 35.6000 | 35.4000 | 35.6000 | 744.0050 | 149520.00 | 149520.00 | 0.00 | 42 | 13 | 248 | 1 | 248 | 0.465486421944511 | 0.465486421944511 | false | false | false | |||||||||||||||||
| 3cb923a6-52d3-49fe-bccc-8e868c4c4762 | 2026-09-21 14:03 | 2026-09-21 14:02 | 2026-09-21 14:02 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 34.9500 | 34.4500 | 35.1000 | 745.0000 | 206203.00 | 206203.00 | 0.00 | 59 | 25 | 315 | 1 | 315 | 0.466424948430923 | 0.465106318527975 | true | false | false | |||||||||||||||||
| 100b9894-011a-4906-a301-3cd50b941d01 | 2026-09-21 15:14 | 2026-09-21 15:14 | 2026-09-21 15:14 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 34.3500 | 34.1500 | 34.3500 | 744.6397 | 120223.00 | 120223.00 | 0.00 | 35 | 14 | 505 | 1 | 505 | 0.453510052736952 | 0.453205868042077 | false | false | false | |||||||||||||||||
| c31e5217-33fd-49e7-8525-5483c6803e82 | 2026-09-21 15:14 | 2026-09-21 15:14 | 2026-09-21 15:14 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 34.3500 | 34.3500 | 34.5500 | 744.5600 | 51525.00 | 0.00 | 51525.00 | 15 | 5 | 520 | 1 | 520 | 0.452723561019173 | 0.452723561019173 | false | false | false | |||||||||||||||||
| c49fe0f4-66b8-4eda-b38f-82a1e1f9eeb8 | 2026-09-21 15:39 | 2026-09-21 15:39 | 2026-09-21 15:39 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 32.5500 | 32.3000 | 32.5500 | 749.2307 | 48825.00 | 48825.00 | 0.00 | 15 | 5 | 563 | 1 | 563 | 0.458582810535612 | 0.457140749534186 | true | false | false | |||||||||||||||||
| 3030d81a-b85c-4313-947e-c09dcbebe718 | 2026-09-21 15:46 | 2026-09-21 15:46 | 2026-09-21 15:46 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 33.1000 | 33.0500 | 33.2500 | 747.9500 | 52960.00 | 6620.00 | 33100.00 | 16 | 7 | 591 | 1 | 591 | 0.456782361517077 | 0.456782361517077 | false | false | false | |||||||||||||||||
| 3217c032-09e3-4b5a-b602-043aebd5cda9 | 2026-09-21 15:48 | 2026-09-21 15:48 | 2026-09-21 15:48 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 33.6300 | 33.4000 | 33.8000 | 747.0000 | 50440.00 | 47080.00 | 3360.00 | 15 | 13 | 619 | 1 | 619 | 0.459441350872805 | 0.458117694963624 | true | false | false | |||||||||||||||||
| 88bda7bb-cc1c-4b69-97fb-cf1d93e12c39 | 2026-09-22 10:53 | 2026-09-22 10:53 | 2026-09-22 10:53 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 31.1000 | 30.5000 | 31.1000 | 747.0500 | 21770.00 | 21770.00 | 0.00 | 7 | 5 | 107 | 306 | 0.349673202614379 | 0.433919402319368 | 0.433919402319368 | true | false | false | |||||||||||||||||
| 60c9a4aa-a575-4fdd-98b8-9be610836aac | 2026-09-22 12:53 | 2026-09-22 12:53 | 2026-09-22 12:53 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 33.6000 | 33.1500 | 33.6500 | 742.4450 | 60475.00 | 50400.00 | 10075.00 | 18 | 10 | 198 | 306 | 0.647058823529412 | 0.438360673591685 | 0.439019778746706 | true | false | false | |||||||||||||||||
| de76f299-cead-4ccd-a9a2-e8f88f281ee5 | 2026-09-22 15:38 | 2026-09-22 15:38 | 2026-09-22 15:38 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 35.5000 | 34.8000 | 35.8000 | 738.6600 | 17750.00 | 17750.00 | 0.00 | 5 | 5 | 231 | 306 | 0.754901960784314 | 0.441121460119417 | 0.438981179634451 | false | false | false | |||||||||||||||||
| 352670ee-5e42-4145-b9d5-12b82f5424f1 | 2026-09-23 09:54 | 2026-09-23 09:53 | 2026-09-23 09:53 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 27.3500 | 27.0500 | 27.4500 | 756.8600 | 41025.00 | 32850.00 | 8175.00 | 15 | 5 | 95 | 423 | 0.224586288416076 | 0.448386935317771 | 0.450516979528963 | false | false | false | |||||||||||||||||
| a064c4b7-33f0-4194-993c-84846a1a2ea5 | 2026-09-23 09:57 | 2026-09-23 09:57 | 2026-09-23 09:57 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 25.9000 | 25.8000 | 26.3500 | 762.0050 | 31080.00 | 10360.00 | 20720.00 | 12 | 5 | 121 | 423 | 0.286052009456265 | 0.458252225420582 | 0.458252225420582 | true | false | false | |||||||||||||||||
| 2a5c7aef-0523-43fd-aa60-0224a3a207e9 | 2026-09-23 10:19 | 2026-09-23 10:19 | 2026-09-23 10:19 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 33.8500 | 33.8500 | 34.1000 | 743.0000 | 44005.00 | 0.00 | 44005.00 | 13 | 8 | 193 | 423 | 0.456264775413712 | 0.456158520774537 | 0.456158520774537 | false | false | false | |||||||||||||||||
| 00c860c2-a3a6-4057-8fcd-42d906da41ff | 2026-09-23 15:58 | 2026-09-23 15:57 | 2026-09-23 15:57 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 32.9500 | 32.7500 | 33.2500 | 744.0000 | 23065.00 | 19770.00 | 3295.00 | 7 | 7 | 476 | 423 | 1.12529550827423 | 0.453404648950934 | 0.453404648950934 | false | false | false | |||||||||||||||||
| b1c71337-92cb-4676-8f15-59c0cfac42ba | 2026-09-24 09:34 | 2026-09-24 09:34 | 2026-09-24 09:34 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 26.4100 | 26.2000 | 27.2500 | 757.5800 | 113545.00 | 7930.00 | 105615.00 | 43 | 18 | 80 | 514 | 0.155642023346304 | 0.450122457675432 | 0.451154213952409 | true | false | false | |||||||||||||||||
| 204defb9-0be8-4a90-afd1-b01a61fbd2df | 2026-09-24 14:11 | 2026-09-24 14:11 | 2026-09-24 14:11 | META | META261016P00745000 | put | 745.0000 | 2026-10-16 | 19.5500 | 19.4000 | 19.5500 | 773.7100 | 21505.00 | 21505.00 | 0.00 | 11 | 5 | 267 | 514 | 0.519455252918288 | 0.43914252972079 | 0.4384657059765 | true | false | false |
| 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-21T16:13:06.153982Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T16:17:17.704519Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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-21T17:12:05.796133Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T18:00:14.697100Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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 |
| 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:15:34.344712Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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:15:34.344712Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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 |
| 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:46:53.809312Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-21T19:50:07.722851Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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:56:01.933088Z"} |
| 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:59:26.444099Z"} |
| 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-22T19:40:59.804437Z"} |
| 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 |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:55:29.867504Z"} |
| 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 |
| 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 |
| 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} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-24T13:35:42.562828Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T18:15:40.223371Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |