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.
Simplify Analyticsuw_flow_alerts523,327 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 |
|---|
| 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 |
|---|
| f0dcb0f0-f63b-4f2d-b43b-8d35fceb38a7 | 2026-09-28 15:20 | 2026-09-28 15:20 | 2026-09-28 15:20 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 2.2000 | 2.2000 | 2.2700 | 133.0800 | 19360.00 | 0.00 | 19360.00 | 88 | 11 | 1351 | 4017 | 0.336320637291511 | 0.521070813638067 | 0.521070813638067 | false | false | false | true | false | 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-28T19:23:02.177643Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 7168c9eb-56be-40d2-9bae-f9ff3bc3f630 | 2026-09-28 12:15 | 2026-09-28 12:15 | 2026-09-28 12:15 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 1.9100 | 1.9100 | 1.9800 | 132.5450 | 22729.00 | 0.00 | 22729.00 | 119 | 12 | 958 | 4017 | 0.23848643266119 | 0.503719017668008 | 0.503719017668008 | false | false | false | |||||||||||||||||
| dfe79d46-961b-4ecb-b3ef-983683e651d2 | 2026-09-28 09:47 | 2026-09-28 09:47 | 2026-09-28 09:47 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 2.3100 | 2.1900 | 2.3100 | 134.0600 | 20790.00 | 20790.00 | 0.00 | 90 | 7 | 273 | 4017 | 0.0679611650485437 | 0.506065971348318 | 0.506065971348318 | false | false | false | |||||||||||||||||
| ae1b9007-b75a-4c8c-892b-5ae94c570592 | 2026-09-24 14:30 | 2026-09-24 14:30 | 2026-09-24 14:30 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 4.3000 | 4.1500 | 4.3250 | 139.4100 | 17630.00 | 17630.00 | 0.00 | 41 | 7 | 1347 | 3702 | 0.36385737439222 | 0.47418623282733 | 0.47418623282733 | false | false | false | |||||||||||||||||
| 8b61ae13-04c2-45ab-8812-522494373049 | 2026-09-24 12:42 | 2026-09-24 12:42 | 2026-09-24 12:42 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 4.2000 | 4.0500 | 4.2000 | 138.9600 | 25620.00 | 25620.00 | 0.00 | 61 | 5 | 1180 | 3702 | 0.318746623446786 | 0.480049432399263 | 0.480049432399263 | false | false | false | |||||||||||||||||
| 1cdbedbb-c6b5-4309-8ad2-011d8194aa64 | 2026-09-23 10:22 | 2026-09-23 10:22 | 2026-09-23 10:22 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 7.5000 | 7.5000 | 7.6000 | 145.5900 | 10500.00 | 0.00 | 10500.00 | 14 | 5 | 58 | 3361 | 0.0172567688188039 | 0.48291439843862 | 0.48291439843862 | false | false | false | |||||||||||||||||
| c09f28a6-4120-4068-b10c-94caa0e6465d | 2026-09-21 14:58 | 2026-09-21 14:58 | 2026-09-21 14:58 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 9.3500 | 9.3500 | 9.5000 | 148.4100 | 93500.00 | 0.00 | 93500.00 | 100 | 5 | 458 | 3472 | 0.131912442396313 | 0.476962875867083 | 0.476962875867083 | false | false | false | |||||||||||||||||
| c06e1611-e626-468c-9ae8-1a0e8969ecdc | 2026-09-18 13:44 | 2026-09-18 13:44 | 2026-09-18 13:44 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 8.1000 | 7.9500 | 8.1500 | 146.1400 | 83430.00 | 82620.00 | 0.00 | 103 | 25 | 895 | 3369 | 0.265657465123182 | 0.453731484821028 | 0.453731484821028 | true | false | false | |||||||||||||||||
| ffb1f69b-a479-4936-b560-1fe0279f28d7 | 2026-09-18 10:29 | 2026-09-18 10:29 | 2026-09-18 10:29 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 8.1000 | 8.0000 | 8.1000 | 145.6700 | 80966.00 | 80966.00 | 0.00 | 100 | 6 | 383 | 3369 | 0.113683585633719 | 0.470164542930996 | 0.47004212184755 | false | false | false | |||||||||||||||||
| be135c60-ba2e-43b7-80d9-6ec4bf36823c | 2026-09-17 14:55 | 2026-09-17 14:55 | 2026-09-17 14:55 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 10.2000 | 10.1500 | 10.2500 | 148.9750 | 153000.00 | 40800.00 | 102000.00 | 150 | 7 | 910 | 3413 | 0.266627600351597 | 0.472106617346825 | 0.472106617346825 | false | false | false | |||||||||||||||||
| e5b8fbab-b1a5-4379-a9b1-f7069b632d7b | 2026-09-16 09:47 | 2026-09-16 09:47 | 2026-09-16 09:47 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 7.8100 | 7.8000 | 7.9000 | 143.9300 | 62468.00 | 0.00 | 62468.00 | 80 | 6 | 2279 | 2477 | 0.920064594267259 | 0.491285346869209 | 0.492501302020161 | false | false | false | |||||||||||||||||
| f875b21a-aae6-4c87-b8cf-8d3937000973 | 2026-09-16 09:44 | 2026-09-16 09:44 | 2026-09-16 09:44 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 6.9300 | 6.9000 | 7.1000 | 142.2200 | 51980.00 | 0.00 | 51980.00 | 75 | 7 | 2171 | 2477 | 0.876463463867582 | 0.488450071308087 | 0.491526993904413 | false | false | false | |||||||||||||||||
| bcbd9f46-4ff6-457c-a16c-1cdb5bc4f99c | 2026-09-16 09:37 | 2026-09-16 09:37 | 2026-09-16 09:37 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 6.6500 | 6.4000 | 6.6500 | 141.6100 | 153615.00 | 153615.00 | 0.00 | 231 | 6 | 1227 | 2477 | 0.495357287040775 | 0.490944599221029 | 0.490944599221029 | true | false | false | |||||||||||||||||
| bf39978c-67bf-42be-b00f-ef6d49561fcb | 2026-09-16 09:31 | 2026-09-16 09:31 | 2026-09-16 09:31 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 5.8000 | 5.8000 | 6.2500 | 139.9900 | 99760.00 | 0.00 | 99760.00 | 172 | 16 | 198 | 2477 | 0.0799354057327412 | 0.483703218577638 | 0.483703218577638 | false | false | false | |||||||||||||||||
| b0f14075-22e7-4ee5-a5c5-1c31bb4b8a66 | 2026-09-15 15:59 | 2026-09-15 15:58 | 2026-09-15 15:58 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 6.1500 | 6.1000 | 6.2000 | 140.0000 | 89175.00 | 0.00 | 80565.00 | 145 | 24 | 2464 | 1636 | 1.50611246943765 | 0.486937698503744 | 0.48831495650026 | false | false | false | |||||||||||||||||
| 0bc19ba8-0045-48cb-8e43-f9f479b82765 | 2026-09-15 09:56 | 2026-09-15 09:55 | 2026-09-15 09:55 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 6.3000 | 6.2500 | 6.4000 | 140.8300 | 67410.00 | 0.00 | 67410.00 | 107 | 6 | 859 | 1636 | 0.525061124694376 | 0.482843515823885 | 0.482843515823885 | false | false | false | |||||||||||||||||
| 2f4d28df-937f-4ff9-8193-87b0f497504f | 2026-09-14 09:54 | 2026-09-14 09:53 | 2026-09-14 09:53 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 8.5500 | 8.5500 | 8.9500 | 144.8100 | 92340.00 | 0.00 | 92340.00 | 108 | 5 | 356 | 1642 | 0.216808769792935 | 0.488462527573251 | 0.491292727114216 | true | false | false | |||||||||||||||||
| 9be4c221-614d-467e-a0c5-4b005728218d | 2026-09-04 13:30 | 2026-09-04 13:30 | 2026-09-04 13:30 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 20.2000 | 20.0500 | 20.4500 | 157.5600 | 494900.00 | 72720.00 | 422180.00 | 245 | 17 | 300 | 1634 | 0.18359853121175 | 0.614052186454579 | 0.614428541148477 | true | false | false | |||||||||||||||||
| 7e35beb0-5de2-4d21-a0eb-45657850b434 | 2026-09-02 11:57 | 2026-09-02 11:57 | 2026-09-02 11:57 | ORCL | ORCL261016C00145000 | call | 145.0000 | 2026-10-16 | 12.1500 | 12.1000 | 12.1500 | 144.1800 | 58320.00 | 58320.00 | 0.00 | 48 | 6 | 147 | 1714 | 0.0857642940490082 | 0.612781989176564 | 0.612781989176564 | false | false | false |
| false |
| 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-28T16:16:42.064656Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| 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-28T13:49:52.918259Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| 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-24T18:32:33.635262Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| 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-24T16:43:03.644135Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| 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-23T14:22:47.791063Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 449206220160.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:00:53.952817Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 446333670960.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:59:53.998874Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 446333670960.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 455344404240.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 432878045760.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 432878045760.00 |
| 2026-12-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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 432878045760.00 |
| 2026-12-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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 432878045760.00 |
| 2026-12-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:33:11.249350Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 437806735440.00 |
| 2026-12-09 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| 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-15T14:04:43.913092Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| 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-14T14:00:07.512367Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-04T17:34:11.817020Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-02T16:19:14.278097Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |