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_alerts281,039 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 |
|---|
| 98a36918-a64d-4e60-9805-407c54380187 | 2026-09-10 15:14 | 2026-09-10 15:13 | 2026-09-10 15:13 | TSEM | TSEM260918C00222500 | call | 222.5000 | 2026-09-18 | 3.7000 | 3.7000 | 4.2000 | 208.5550 | 23687.00 | 0.00 | 23687.00 | 64 | 21 | 70 | 48 | 1.45833333333333 | 0.703720618297329 | 0.703720618297329 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 21507575292.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T19:25:57.950009Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d90e272d-ad13-4cba-a339-6617030819b7 | 2026-09-11 10:30 | 2026-09-11 10:30 | 2026-09-11 10:30 | TSEM | TSEM261016C00240000 | call | 240.0000 | 2026-10-16 | 7.8000 | 7.8000 | 8.4000 | 209.0600 | 248040.00 | 0.00 | 248040.00 | 318 | 40 | 319 | 7830 | 0.0407407407407407 | 0.690347643620012 | 0.695610084651649 | false | false | false | true | false | |||||||||||||||
| f37b8d10-53f8-40c2-9733-1954b17e29e6 | 2026-09-11 15:25 | 2026-09-11 15:25 | 2026-09-11 15:25 | TSEM | TSEM261009P00175000 | put | 175.0000 | 2026-10-09 | 3.1000 | 3.1000 | 3.7000 | 210.7200 | 68200.00 | 0.00 | 68200.00 | 220 | 17 | 502 | 4 | 125.5 | 0.688713495589469 | 0.688713495589469 | false | false | false | true | false | |||||||||||||||
| 2293ef7a-b6f5-480a-abde-9da0e0aeffd2 | 2026-09-14 11:17 | 2026-09-14 11:17 | 2026-09-14 11:17 | TSEM | TSEM261002P00155000 | put | 155.0000 | 2026-10-02 | 1.0000 | 0.4500 | 1.9000 | 195.8250 | 24200.00 | 21400.00 | 2800.00 | 242 | 5 | 242 | 12 | 20.1666666666667 | 0.745552414453977 | 0.745552414453977 | false | false | false | true | false | |||||||||||||||
| d1381e97-de3d-4e48-ae24-0e0300ade973 | 2026-09-15 09:52 | 2026-09-15 09:52 | 2026-09-15 09:52 | TSEM | TSEM280121C00175000 | call | 175.0000 | 2028-01-21 | 79.0000 | 75.4000 | 80.9000 | 194.4400 | 505600.00 | 505600.00 | 0.00 | 64 | 1 | 64 | 3 | 21.3333333333333 | 0.783130902744823 | 0.783130902744823 | false | true | false | true | true | |||||||||||||||
| 5b7f37f9-a577-4011-86c8-0b0f091e0c1d | 2026-09-15 13:24 | 2026-09-15 13:23 | 2026-09-15 13:23 | TSEM | TSEM261016C00195000 | call | 195.0000 | 2026-10-16 | 15.7000 | 15.7000 | 16.3000 | 194.1850 | 158570.00 | 0.00 | 158570.00 | 101 | 13 | 112 | 21 | 5.33333333333333 | 0.699537857250966 | 0.699537857250966 | false | false | false | true | false | |||||||||||||||
| a0627c6f-7b1e-42df-b882-55d51e0526f5 | 2026-09-15 14:14 | 2026-09-15 14:14 | 2026-09-15 14:14 | TSEM | TSEM261016C00200000 | call | 200.0000 | 2026-10-16 | 13.1000 | 13.1000 | 13.8000 | 193.2800 | 260690.00 | 0.00 | 260690.00 | 199 | 11 | 203 | 140 | 1.45 | 0.699466333464477 | 0.699466333464477 | false | false | false | true | false | |||||||||||||||
| 3e0cdfcd-7550-4474-b430-1b33b5941d28 | 2026-09-15 14:14 | 2026-09-15 14:14 | 2026-09-15 14:14 | TSEM | TSEM261016C00210000 | call | 210.0000 | 2026-10-16 | 9.3000 | 9.3000 | 10.1000 | 193.2800 | 293882.00 | 0.00 | 293882.00 | 316 | 35 | 317 | 201 | 1.5771144278607 | 0.68718832510406 | 0.68718832510406 | false | false | false | true | false | |||||||||||||||
| 8a7d14ab-abca-435e-9ecf-73820415558a | 2026-09-16 09:41 | 2026-09-16 09:41 | 2026-09-16 09:41 | TSEM | TSEM261016P00185000 | put | 185.0000 | 2026-10-16 | 8.0000 | 6.9000 | 8.0000 | 205.7700 | 201599.00 | 201599.00 | 0.00 | 252 | 38 | 252 | 140 | 1.8 | 0.743129569874064 | 0.743129569874064 | false | false | false | true | false | |||||||||||||||
| 7d63f222-737d-4fc7-b079-c38ccf82c376 | 2026-09-16 10:23 | 2026-09-16 10:23 | 2026-09-16 10:23 | TSEM | TSEM260918C00210000 | call | 210.0000 | 2026-09-18 | 3.6000 | 3.6000 | 4.0000 | 206.0000 | 24480.00 | 0.00 | 24480.00 | 68 | 12 | 154 | 340 | 0.452941176470588 | 0.849642689862781 | 0.849642689862781 | false | false | false | true | false | |||||||||||||||
| 75321958-7eb3-45c4-a389-c1dd02d4d1ba | 2026-09-16 15:00 | 2026-09-16 15:00 | 2026-09-16 15:00 | TSEM | TSEM260918P00185000 | put | 185.0000 | 2026-09-18 | 0.8000 | 0.4500 | 0.8000 | 199.5650 | 37993.00 | 37993.00 | 0.00 | 475 | 44 | 566 | 923 | 0.613217768147346 | 0.896788942704603 | 0.896788942704603 | false | false | false | true | false | |||||||||||||||
| 96de5508-8e7b-42f5-8711-b8cafbb5de99 | 2026-09-17 09:33 | 2026-09-17 09:32 | 2026-09-17 09:32 | TSEM | TSEM270115C00300000 | call | 300.0000 | 2027-01-15 | 13.3700 | 11.4000 | 15.7000 | 214.5800 | 267418.00 | 0.00 | 267418.00 | 200 | 8 | 200 | 830 | 0.240963855421687 | 0.732260786391165 | 0.732260786391165 | false | false | false | true | false | |||||||||||||||
| f8bbbab4-cf2d-4daa-b060-d34e8bdf1e0e | 2026-09-17 09:34 | 2026-09-17 09:34 | 2026-09-17 09:34 | TSEM | TSEM260918P00225000 | put | 225.0000 | 2026-09-18 | 11.4000 | 10.4000 | 13.6000 | 215.1900 | 57000.00 | 0.00 | 57000.00 | 50 | 6 | 50 | 55 | 0.909090909090909 | 1.10480237170069 | 1.10480237170069 | false | false | false | true | false | |||||||||||||||
| ca04f652-e814-4856-a5e1-2841753f782c | 2026-09-17 09:35 | 2026-09-17 09:35 | 2026-09-17 09:35 | TSEM | TSEM261030C00300000 | call | 300.0000 | 2026-10-30 | 3.0000 | 2.6000 | 3.2000 | 216.7300 | 19500.00 | 8700.00 | 10800.00 | 65 | 5 | 219 | 0 | 0 | 0.728636362764148 | 0.728636362764148 | false | false | false | true | false | |||||||||||||||
| fe8f26c2-5483-4cbd-9aca-6a7f59c04625 | 2026-09-17 10:02 | 2026-09-17 10:02 | 2026-09-17 10:02 | TSEM | TSEM260925P00200000 | put | 200.0000 | 2026-09-25 | 3.1000 | 2.3500 | 3.1000 | 217.4100 | 52390.00 | 52390.00 | 0.00 | 169 | 28 | 177 | 88 | 2.01136363636364 | 0.762614149460738 | 0.762614149460738 | false | false | false | true | false | |||||||||||||||
| bb774c27-45b6-4d8d-9a22-d2c611d6be98 | 2026-09-17 11:34 | 2026-09-17 11:34 | 2026-09-17 11:34 | TSEM | TSEM270416C00240000 | call | 240.0000 | 2027-04-16 | 41.7000 | 40.2000 | 43.4000 | 215.0000 | 33360.00 | 25020.00 | 8340.00 | 8 | 6 | 9 | 1 | 9 | 0.754328161057937 | 0.753726068286194 | false | false | false | true | false | |||||||||||||||
| fc6628ea-0be8-4892-ac7e-c8f9d70fd25e | 2026-09-17 12:10 | 2026-09-17 12:10 | 2026-09-17 12:10 | TSEM | TSEM270416C00240000 | call | 240.0000 | 2027-04-16 | 44.5000 | 42.3000 | 44.5000 | 219.3800 | 35600.00 | 35600.00 | 0.00 | 8 | 5 | 21 | 1 | 21 | 0.758863072633434 | 0.758863072633434 | false | false | false | true | false | |||||||||||||||
| cdb122ff-9697-46e6-a061-460a0242c314 | 2026-09-17 12:24 | 2026-09-17 12:24 | 2026-09-17 12:24 | TSEM | TSEM270115C00300000 | call | 300.0000 | 2027-01-15 | 14.8000 | 13.6000 | 14.8000 | 219.5000 | 56240.00 | 56240.00 | 0.00 | 38 | 8 | 240 | 830 | 0.289156626506024 | 0.731805511213596 | 0.731805511213596 | false | false | false | true | false | |||||||||||||||
| c3393b74-73d2-41cc-927a-2f9e8b4a480c | 2026-09-18 14:01 | 2026-09-18 14:01 | 2026-09-18 14:01 | TSEM | TSEM271217C00320000 | call | 320.0000 | 2027-12-17 | 51.5000 | 47.1000 | 54.0000 | 224.7600 | 515000.00 | 257500.00 | 128750.00 | 100 | 5 | 100 | 27 | 3.7037037037037 | 0.746977644731858 | 0.746977644731858 | false | false | false | true | false | |||||||||||||||
| fc2d89fb-22d1-4919-a3bd-d8d90e2974aa | 2026-09-18 15:55 | 2026-09-18 15:54 | 2026-09-18 15:54 | TSEM | TSEM260925C00240000 | call | 240.0000 | 2026-09-25 | 2.9500 | 2.9500 | 4.2000 | 225.0000 | 28025.00 | 0.00 | 28025.00 | 95 | 9 | 107 | 10 | 10.7 | 0.630166450901073 | 0.630166450901073 | false | false | false | true | false | |||||||||||||||
| 377d536e-119b-4ff0-ae92-2cb5116749df | 2026-09-21 11:57 | 2026-09-21 11:57 | 2026-09-21 11:57 | TSEM | TSEM261016C00260000 | call | 260.0000 | 2026-10-16 | 8.6000 | 7.5000 | 8.6000 | 234.2300 | 413653.00 | 413653.00 | 0.00 | 481 | 32 | 630 | 540 | 1.16666666666667 | 0.719454498156421 | 0.719454498156421 | false | false | false | true | false | |||||||||||||||
| bff4e1af-c562-465b-8bfb-14af077d9e43 | 2026-09-21 13:21 | 2026-09-21 13:20 | 2026-09-21 13:20 | TSEM | TSEM261016C00240000 | call | 240.0000 | 2026-10-16 | 14.9000 | 14.1000 | 14.9000 | 233.0000 | 67050.00 | 67050.00 | 0.00 | 45 | 7 | 62 | 8222 | 0.00754074434444174 | 0.712450103858472 | 0.712450103858472 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 21507575292.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 21507575292.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 21507575292.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| Common Stock |
| Technology |
| 21507575292.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 21507575292.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T17:45:33.615815Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 21507575292.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 21507575292.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 22754456489.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:45:36.515971Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 22754456489.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 22754456489.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 24672042733.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 24672042733.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 24672042733.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 24672042733.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:07:38.635762Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 24672042733.00 |
| 2026-11-09 |
| unknown |
| — |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 24672042733.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T16:22:15.429007Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 24672042733.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T16:46:55.190867Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 25162692734.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 25162692734.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 26312794343.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:00:04.115943Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 26312794343.00 |
| 2026-11-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:24:56.111062Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |