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_alerts375,978 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 |
|---|
| 922e5ea4-a504-4232-ada0-2a22f62c6b1f | 2026-09-23 13:21 | 2026-09-23 13:21 | 2026-09-23 13:21 | KWEB | KWEB280121P00018000 | put | 18.0000 | 2028-01-21 | 0.7800 | 0.7800 | 0.8700 | 24.8350 | 14126.00 | 0.00 | 14126.00 | 180 | 5 | 200 | 804 | 0.248756218905473 | 0.357891932884584 | 0.356215208864236 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4223436000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T17:25:27.822923Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| e53201fc-83d5-411b-b7bf-bf100b4ae4e7 | 2026-09-21 10:59 | 2026-09-21 10:59 | 2026-09-21 10:59 | KWEB | KWEB261218C00029000 | call | 29.0000 | 2026-12-18 | 0.4000 | 0.3800 | 0.4100 | 24.9000 | 32950.00 | 16760.00 | 4630.00 | 824 | 40 | 1838 | 125567 | 0.0146376038290315 | 0.315327662943011 | 0.315327662943011 | true | false | false | |||||||||||||||||
| 0c2b1f85-954c-4e85-8863-0c6d342053ed | 2026-09-17 11:27 | 2026-09-17 11:27 | 2026-09-17 11:27 | KWEB | KWEB260918P00026000 | put | 26.0000 | 2026-09-18 | 1.6200 | 1.5100 | 1.7000 | 24.4020 | 14061.00 | 14061.00 | 0.00 | 87 | 5 | 117 | 22135 | 0.00528574655522927 | 1.12695413434676 | 0.692024974831209 | false | false | false | |||||||||||||||||
| 42bdf4ba-c644-4d60-848c-e4340bf1f766 | 2026-09-15 10:14 | 2026-09-15 10:14 | 2026-09-15 10:14 | KWEB | KWEB270617C00025000 | call | 25.0000 | 2027-06-17 | 2.8400 | 2.8300 | 2.9200 | 24.5150 | 113968.00 | 56800.00 | 57168.00 | 402 | 9 | 954 | 6782 | 0.140666470067827 | 0.326594963291949 | 0.32540059265153 | false | false | false | |||||||||||||||||
| ef1eee2c-d30c-4357-8d03-adf1c0909338 | 2026-09-11 13:06 | 2026-09-11 13:06 | 2026-09-11 13:06 | KWEB | KWEB261023P00024500 | put | 24.5000 | 2026-10-23 | 0.8100 | 0.8000 | 0.9100 | 24.6750 | 78849.00 | 0.00 | 78849.00 | 979 | 6 | 1636 | 512 | 3.1953125 | 0.285359827850314 | 0.282321537595109 | true | false | false | |||||||||||||||||
| 69e6cb07-7efd-436c-aab0-f91cbc538dea | 2026-09-11 12:51 | 2026-09-11 12:51 | 2026-09-11 12:51 | KWEB | KWEB261023P00024500 | put | 24.5000 | 2026-10-23 | 0.8100 | 0.8100 | 0.9100 | 24.6755 | 52850.00 | 0.00 | 52850.00 | 654 | 5 | 657 | 512 | 1.283203125 | 0.285425546052779 | 0.282387217444242 | true | false | false | |||||||||||||||||
| f2f871e0-d1ba-4fd2-a386-e9380adde130 | 2026-09-10 14:10 | 2026-09-10 14:10 | 2026-09-10 14:10 | KWEB | KWEB260925P00024500 | put | 24.5000 | 2026-09-25 | 0.5400 | 0.5400 | 0.5600 | 24.4950 | 39938.00 | 0.00 | 39938.00 | 739 | 18 | 1272 | 60 | 21.2 | 0.286204849572314 | 0.281149976444401 | false | false | false | |||||||||||||||||
| 13b3cff7-9bf7-4c8f-a6c8-0fd945fd9153 | 2026-09-09 15:13 | 2026-09-09 15:13 | 2026-09-09 15:13 | KWEB | KWEB270219C00026000 | call | 26.0000 | 2027-02-19 | 1.7000 | 1.5900 | 1.7000 | 24.8350 | 95162.00 | 95162.00 | 0.00 | 560 | 20 | 7492 | 206 | 36.3689320388349 | 0.303287776597977 | 0.303287776597977 | true | false | false | |||||||||||||||||
| c0699cce-4f49-4c07-b4f9-b12d87bf50af | 2026-09-08 12:01 | 2026-09-08 12:01 | 2026-09-08 12:01 | KWEB | KWEB270115P00023000 | put | 23.0000 | 2027-01-15 | 0.7800 | 0.7600 | 0.7800 | 25.3150 | 116678.00 | 91884.00 | 0.00 | 1500 | 25 | 8842 | 2844 | 3.10900140646976 | 0.316917973615332 | 0.316917973615332 | false | false | false | |||||||||||||||||
| 766ef5f0-ad14-4ab3-8e22-ebcb803eb360 | 2026-09-08 09:48 | 2026-09-08 09:48 | 2026-09-08 09:48 | KWEB | KWEB261120C00026000 | call | 26.0000 | 2026-11-20 | 1.2200 | 1.1700 | 1.2200 | 25.4500 | 24383.00 | 24383.00 | 0.00 | 200 | 8 | 213 | 1278 | 0.166666666666667 | 0.304625918852067 | 0.302422205413639 | false | false | false | |||||||||||||||||
| 02a401e0-16ed-49f7-95f2-a26a81da4d11 | 2026-09-04 09:31 | 2026-09-04 09:31 | 2026-09-04 09:31 | KWEB | KWEB261016C00026000 | call | 26.0000 | 2026-10-16 | 1.0700 | 0.9200 | 1.0700 | 26.0387 | 98973.00 | 98867.00 | 0.00 | 925 | 37 | 940 | 12723 | 0.0738819460818989 | 0.281998508967941 | 0.281998508967941 | true | false | false | |||||||||||||||||
| 67d3e4e0-203c-405b-a5af-e2f607d725b6 | 2026-09-03 15:17 | 2026-09-03 15:17 | 2026-09-03 15:17 | KWEB | KWEB270115C00026000 | call | 26.0000 | 2027-01-15 | 1.8000 | 1.7100 | 1.8000 | 25.5750 | 50349.00 | 49633.00 | 716.00 | 280 | 5 | 734 | 3534 | 0.207696661007357 | 0.294997613399802 | 0.293374962218528 | false | false | false | |||||||||||||||||
| 928653d0-26f9-4d0a-bfb8-182e9d1684f8 | 2026-09-01 15:42 | 2026-09-01 15:41 | 2026-09-01 15:41 | KWEB | KWEB261016C00027000 | call | 27.0000 | 2026-10-16 | 0.5600 | 0.5400 | 0.5600 | 25.7150 | 13420.00 | 12375.00 | 0.00 | 240 | 20 | 1749 | 13896 | 0.125863557858377 | 0.282259782124556 | 0.279253803860809 | false | false | false | |||||||||||||||||
| d7f19462-c44d-4383-98bf-23a121dc287c | 2026-08-27 14:28 | 2026-08-27 14:27 | 2026-08-27 14:27 | KWEB | KWEB261120C00028000 | call | 28.0000 | 2026-11-20 | 0.8800 | 0.8800 | 0.8900 | 26.0500 | 15989.00 | 5429.00 | 10560.00 | 181 | 8 | 1469 | 17603 | 0.0834516843719821 | 0.309640466011941 | 0.307518723781588 | true | false | false | |||||||||||||||||
| 6a0375de-0965-47a2-9dac-d69579d278e9 | 2026-08-27 12:52 | 2026-08-27 12:52 | 2026-08-27 12:52 | KWEB | KWEB261120C00030000 | call | 30.0000 | 2026-11-20 | 0.4600 | 0.4400 | 0.4600 | 26.0548 | 35940.00 | 34500.00 | 990.00 | 782 | 34 | 3855 | 16949 | 0.227447047023423 | 0.318434943275038 | 0.318434943275038 | false | false | false | |||||||||||||||||
| 68ea40fa-047c-4df1-abf1-042abe5176cc | 2026-08-21 10:39 | 2026-08-21 10:39 | 2026-08-21 10:39 | KWEB | KWEB270115C00030000 | call | 30.0000 | 2027-01-15 | 1.0500 | 0.9000 | 1.0500 | 26.6450 | 52477.00 | 50189.00 | 0.00 | 500 | 32 | 532 | 21528 | 0.0247120029728725 | 0.309744778803948 | 0.309744778803948 | true | false | false | |||||||||||||||||
| 973cfc64-4247-4871-afb1-df272fdd68c8 | 2026-08-19 11:20 | 2026-08-19 11:20 | 2026-08-19 11:20 | KWEB | KWEB270115C00029000 | call | 29.0000 | 2027-01-15 | 1.5800 | 1.5200 | 1.6000 | 27.2450 | 18484.00 | 14376.00 | 4108.00 | 117 | 7 | 217 | 1712 | 0.126752336448598 | 0.30507780043119 | 0.30507780043119 | true | false | false | |||||||||||||||||
| 86ce903b-3688-4f87-a846-ef0167d7e287 | 2026-08-18 15:34 | 2026-08-18 15:34 | 2026-08-18 15:34 | KWEB | KWEB261120C00028000 | call | 28.0000 | 2026-11-20 | 1.2800 | 1.2800 | 1.3200 | 26.8250 | 24004.00 | 0.00 | 24004.00 | 187 | 9 | 429 | 2289 | 0.187418086500655 | 0.308322569241593 | 0.306464975371242 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:02:30.535242Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:37:51.418712Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T17:27:08.545704Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T16:54:27.741510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:37:18.479310Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:21:42.633253Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T13:49:15.511852Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:37:16.307537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T19:44:53.190071Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:57:23.365599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:50:41.871179Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4223436000.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |