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_alerts658,639 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 |
|---|
| 26f08b2e-7e4c-43a4-8124-89d282545b4b | 2026-10-01 10:16 | 2026-10-01 10:16 | 2026-10-01 10:16 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 2.5300 | 2.5150 | 2.6400 | 136.5400 | 31878.00 | 3542.00 | 28336.00 | 126 | 5 | 137 | 9242 | 0.0148236312486475 | 0.537724949318277 | 0.537724949318277 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 417487229520.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-10-01T14:17:16.073634Z"} | 2026-10-01 | 2026-10-01 21:15 | 2026-10-01 21:15 |
| f05cf403-f70a-4faa-b4b6-6d7ee829f74a | 2026-09-30 15:09 | 2026-09-30 15:09 | 2026-09-30 15:09 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 2.2500 | 2.1800 | 2.2500 | 138.3450 | 49500.00 | 49500.00 | 0.00 | 220 | 28 | 746 | 9406 | 0.0793110780352966 | 0.532369888783324 | 0.532369888783324 | false | false | false | true | ||||||||||||||||
| 194d7c12-9b16-488d-bdf2-bbd7c7df9f88 | 2026-09-30 11:12 | 2026-09-30 11:12 | 2026-09-30 11:12 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 2.4400 | 2.4300 | 2.5000 | 137.4200 | 103944.00 | 488.00 | 103456.00 | 426 | 39 | 442 | 9406 | 0.0469912821603232 | 0.536655208479448 | 0.536655208479448 | false | false | false | true | ||||||||||||||||
| e476278c-187c-4b8e-8edb-a4e3d29cd556 | 2026-09-29 15:05 | 2026-09-29 15:05 | 2026-09-29 15:05 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 2.4100 | 2.3850 | 2.4700 | 138.0750 | 32049.00 | 31330.00 | 719.00 | 133 | 5 | 3213 | 7595 | 0.423041474654378 | 0.535810710704812 | 0.537451862907141 | false | false | false | true | ||||||||||||||||
| 56ef8644-4f08-4c48-a8ef-568ae4fd9d4c | 2026-09-29 11:28 | 2026-09-29 11:28 | 2026-09-29 11:28 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 2.3900 | 2.3000 | 2.3900 | 138.7900 | 24844.00 | 24844.00 | 0.00 | 104 | 23 | 2583 | 7595 | 0.340092165898618 | 0.544594376831182 | 0.544594376831182 | false | false | false | true | ||||||||||||||||
| bbd7e793-d71f-40a5-9033-83ef09be1ffb | 2026-09-29 10:23 | 2026-09-29 10:23 | 2026-09-29 10:23 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 2.4100 | 2.3900 | 2.5700 | 139.5001 | 20932.00 | 7260.00 | 13672.00 | 87 | 9 | 685 | 7595 | 0.0901909150757077 | 0.555489214356633 | 0.553221670452594 | true | false | false | true | ||||||||||||||||
| f924ae58-c5b2-47a6-b12d-3196b05587f6 | 2026-09-29 09:57 | 2026-09-29 09:57 | 2026-09-29 09:57 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 2.9600 | 2.8500 | 2.9700 | 134.0000 | 10064.00 | 8288.00 | 1776.00 | 34 | 7 | 45 | 7595 | 0.00592495062541146 | 0.53233737356079 | 0.531725120255306 | false | false | false | true | ||||||||||||||||
| f1e3adf9-3d81-43d3-9551-ea70fc5e1c93 | 2026-09-28 10:32 | 2026-09-28 10:31 | 2026-09-28 10:31 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 3.0500 | 3.0000 | 3.0500 | 133.6550 | 10370.00 | 10370.00 | 0.00 | 34 | 9 | 195 | 7260 | 0.0268595041322314 | 0.524123590401704 | 0.524329272518459 | false | false | false | true | ||||||||||||||||
| c61e4801-2679-40de-849b-46210d2132eb | 2026-09-25 15:45 | 2026-09-25 15:45 | 2026-09-25 15:45 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 2.5800 | 2.5600 | 2.6000 | 137.0000 | 22446.00 | 11610.00 | 10836.00 | 87 | 11 | 559 | 7070 | 0.0790664780763791 | 0.526149732561894 | 0.526149732561894 | true | false | false | true | ||||||||||||||||
| cee1f7b3-8784-4015-9188-9a12fe652e66 | 2026-09-25 15:30 | 2026-09-25 15:30 | 2026-09-25 15:30 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 2.6100 | 2.5500 | 2.6300 | 137.4400 | 59940.00 | 52200.00 | 0.00 | 230 | 37 | 459 | 7070 | 0.0649222065063649 | 0.524296493210779 | 0.526599888208377 | false | false | false | true | ||||||||||||||||
| 750a4d50-eee8-4b65-8c02-a14e0901ddb7 | 2026-09-25 10:37 | 2026-09-25 10:37 | 2026-09-25 10:37 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 2.4200 | 2.4200 | 2.4900 | 138.4300 | 10890.00 | 0.00 | 10890.00 | 45 | 9 | 74 | 7070 | 0.0104667609618105 | 0.523700969012988 | 0.523700969012988 | false | false | false | true | ||||||||||||||||
| 10b0aa19-9cb6-4436-b912-d8d438c57927 | 2026-09-24 10:00 | 2026-09-24 10:00 | 2026-09-24 10:00 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 3.6000 | 3.6000 | 3.6500 | 133.9875 | 16560.00 | 0.00 | 16560.00 | 46 | 7 | 1699 | 6377 | 0.266426219225341 | 0.548458978760106 | 0.548458978760106 | true | false | false | true | ||||||||||||||||
| 92cff208-f013-4912-9ff8-8b956f28c9c1 | 2026-09-24 09:49 | 2026-09-24 09:49 | 2026-09-24 09:49 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 3.1900 | 3.1000 | 3.2500 | 135.5499 | 115922.00 | 115602.00 | 320.00 | 363 | 29 | 670 | 6377 | 0.105065077622707 | 0.539795650709917 | 0.541462724245138 | true | false | false | true | ||||||||||||||||
| 744d103d-e249-4707-a395-74bdfd9b67d5 | 2026-09-24 09:49 | 2026-09-24 09:49 | 2026-09-24 09:49 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 3.1600 | 3.1000 | 3.2000 | 135.5300 | 41739.00 | 27879.00 | 0.00 | 132 | 6 | 307 | 6377 | 0.0481417594480163 | 0.537675111478073 | 0.537675111478073 | false | false | false | true | ||||||||||||||||
| 21cff64d-140a-4698-b73c-74dd8d53d6ce | 2026-09-22 11:29 | 2026-09-22 11:29 | 2026-09-22 11:29 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 1.4900 | 1.4200 | 1.4900 | 150.0000 | 24287.00 | 24287.00 | 0.00 | 163 | 22 | 285 | 5985 | 0.0476190476190476 | 0.549595601554155 | 0.549595601554155 | false | false | false | true | ||||||||||||||||
| 1656f2fe-867c-4cc4-9ee1-1252ac10f3c7 | 2026-09-15 15:22 | 2026-09-15 15:22 | 2026-09-15 15:22 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 2.7400 | 2.6500 | 2.7400 | 140.8250 | 101380.00 | 101380.00 | 0.00 | 370 | 48 | 1478 | 5017 | 0.294598365557106 | 0.533217356439956 | 0.533217356439956 | false | false | false | true | ||||||||||||||||
| 69b60766-f840-4438-965b-e9549d9efb55 | 2026-08-21 10:52 | 2026-08-21 10:52 | 2026-08-21 10:52 | ORCL | ORCL261120P00115000 | put | 115.0000 | 2026-11-20 | 5.0000 | 4.8500 | 5.0000 | 147.0550 | 380982.00 | 380982.00 | 0.00 | 762 | 34 | 823 | 4204 | 0.195765937202664 | 0.643412129001783 | 0.643412129001783 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 416640583440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:16:05.592005Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 416640583440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T15:16:14.234864Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 416640583440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:11:44.120733Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 416640583440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:29:51.337369Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 416640583440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:23:29.656550Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 416640583440.00 |
| 2026-12-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:59:42.347553Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 400947393600.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:35:37.335936Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 414554205600.00 |
| 2026-12-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:47:28.119549Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 414554205600.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:35:55.847824Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 414554205600.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:40:21.587562Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 437111276160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:01:19.671622Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 437111276160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:51:23.785124Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 437111276160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:51:23.785124Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 451141411200.00 |
| 2026-12-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:34:09.835499Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |