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_alerts566,287 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 |
|---|
| 728206e9-7120-4a87-ad08-f1e4f699d047 | 2026-09-18 14:22 | 2026-09-18 14:22 | 2026-09-18 14:22 | USO | USO260918C00155000 | call | 155.0000 | 2026-09-18 | 0.1500 | 0.1400 | 0.1700 | 154.1800 | 20790.00 | 0.00 | 20790.00 | 1386 | 5 | 8326 | 7563 | 1.10088589184186 | 0.528887881107598 | 0.528887881107598 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | Financial Services | 1228364647.00 | — | — | — | 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 |
| b12b0b6f-31a4-44e4-864d-d59a19119b20 | 2026-09-18 12:40 | 2026-09-18 12:40 | 2026-09-18 12:40 | USO | USO260918C00155000 | call | 155.0000 | 2026-09-18 | 0.3700 | 0.3500 | 0.3700 | 154.1901 | 13653.00 | 13616.00 | 0.00 | 369 | 5 | 2239 | 7563 | 0.296046542377363 | 0.582922682244742 | 0.582922682244742 | false | false | false | true | ||||||||||||||||
| f0ec678e-27db-4dd9-a7ba-95cf40fc8a40 | 2026-09-18 11:20 | 2026-09-18 11:20 | 2026-09-18 11:20 | USO | USO260918C00155000 | call | 155.0000 | 2026-09-18 | 1.6500 | 1.6500 | 1.7200 | 156.2300 | 74250.00 | 0.00 | 74250.00 | 450 | 5 | 1067 | 7563 | 0.141081581383049 | 0.630351028840542 | 0.630351028840542 | true | false | false | true | ||||||||||||||||
| f9c839cf-d8cd-46a4-a907-d37e2f4def7f | 2026-09-17 12:23 | 2026-09-17 12:23 | 2026-09-17 12:23 | USO | USO260918C00155000 | call | 155.0000 | 2026-09-18 | 1.7600 | 1.6700 | 1.8700 | 154.8100 | 157872.00 | 0.00 | 157872.00 | 897 | 6 | 2787 | 7201 | 0.387029579225108 | 0.570528604207684 | 0.570528604207684 | false | false | false | true | ||||||||||||||||
| 1fffd6cc-9a57-4d67-a741-3ddc3cad1f73 | 2026-09-17 09:38 | 2026-09-17 09:38 | 2026-09-17 09:38 | USO | USO260918C00155000 | call | 155.0000 | 2026-09-18 | 1.5400 | 1.5200 | 1.6200 | 154.2500 | 11550.00 | 4928.00 | 6622.00 | 75 | 11 | 455 | 7201 | 0.0631856686571309 | 0.583529739512396 | 0.583529739512396 | false | false | false | true | ||||||||||||||||
| 5ddf0f8a-66b9-40bd-9400-85db0a467604 | 2026-09-11 10:44 | 2026-09-11 10:44 | 2026-09-11 10:44 | USO | USO260918C00155000 | call | 155.0000 | 2026-09-18 | 4.5000 | 4.4500 | 4.5500 | 153.8650 | 31050.00 | 0.00 | 29250.00 | 69 | 14 | 2141 | 5428 | 0.394436256448047 | 0.58557579737325 | 0.58557579737325 | true | false | false | true | ||||||||||||||||
| e5029a93-0a25-4ffb-97a5-3d8a1298a5a0 | 2026-09-11 09:53 | 2026-09-11 09:53 | 2026-09-11 09:53 | USO | USO260918C00155000 | call | 155.0000 | 2026-09-18 | 3.9000 | 3.7500 | 3.9000 | 153.0000 | 330284.00 | 330284.00 | 0.00 | 847 | 22 | 1614 | 5428 | 0.297347089167281 | 0.559286815139752 | 0.559286815139752 | false | false | false | true | ||||||||||||||||
| bca3f164-e559-495c-9eb2-36a34cace992 | 2026-09-10 14:10 | 2026-09-10 14:10 | 2026-09-10 14:10 | USO | USO260918C00155000 | call | 155.0000 | 2026-09-18 | 7.2000 | 7.0500 | 7.2000 | 158.2800 | 28800.00 | 28800.00 | 0.00 | 40 | 5 | 3599 | 3308 | 1.08796856106409 | 0.57574328097731 | 0.57574328097731 | false | false | false | true | ||||||||||||||||
| d70440dd-bb2a-421b-9446-4c3a4f40420b | 2026-09-10 11:55 | 2026-09-10 11:55 | 2026-09-10 11:55 | USO | USO260918C00155000 | call | 155.0000 | 2026-09-18 | 6.1300 | 6.0000 | 6.2000 | 156.6049 | 19626.00 | 19626.00 | 0.00 | 32 | 5 | 3205 | 3308 | 0.968863361547763 | 0.567354430931858 | 0.567354430931858 | false | false | false | true | ||||||||||||||||
| 2fe5ff7a-f088-48ab-8d96-50e7b066c9bf | 2026-09-10 10:48 | 2026-09-10 10:48 | 2026-09-10 10:48 | USO | USO260918C00155000 | call | 155.0000 | 2026-09-18 | 4.6000 | 4.3500 | 4.6500 | 154.4600 | 11500.00 | 10120.00 | 1380.00 | 25 | 6 | 2649 | 3308 | 0.800785973397823 | 0.525868517699107 | 0.525868517699107 | false | false | false | true | ||||||||||||||||
| ed7b4dc8-ef68-4ddf-acec-ffe8b0ef8c78 | 2026-09-10 10:26 | 2026-09-10 10:26 | 2026-09-10 10:26 | USO | USO260918C00155000 | call | 155.0000 | 2026-09-18 | 3.8500 | 3.7500 | 3.9500 | 153.1000 | 15400.00 | 13475.00 | 0.00 | 40 | 6 | 2549 | 3308 | 0.77055622732769 | 0.51495007899662 | 0.51495007899662 | false | false | false | true | ||||||||||||||||
| aadd6e46-a054-4c2f-b55b-5e01bd3b4b3f | 2026-09-10 09:54 | 2026-09-10 09:54 | 2026-09-10 09:54 | USO | USO260918C00155000 | call | 155.0000 | 2026-09-18 | 3.9500 | 3.8500 | 4.0500 | 153.5500 | 21725.00 | 17380.00 | 4345.00 | 55 | 6 | 2278 | 3308 | 0.68863361547763 | 0.502979455683375 | 0.502979455683375 | false | false | false | true | ||||||||||||||||
| cfc5a543-9df7-495e-8394-a15ff64f22e0 | 2026-09-09 14:51 | 2026-09-09 14:51 | 2026-09-09 14:51 | USO | USO260918C00155000 | call | 155.0000 | 2026-09-18 | 2.2500 | 2.0900 | 2.2500 | 149.5600 | 42523.00 | 42299.00 | 224.00 | 189 | 11 | 986 | 3062 | 0.322011757021555 | 0.461579459335592 | 0.460401362088798 | true | false | false | true | ||||||||||||||||
| 60162b04-9f07-4550-b093-44a9817961ea | 2026-09-09 12:21 | 2026-09-09 12:21 | 2026-09-09 12:21 | USO | USO260918C00155000 | call | 155.0000 | 2026-09-18 | 2.3900 | 2.3900 | 2.4500 | 149.3001 | 14343.00 | 0.00 | 14101.00 | 60 | 6 | 596 | 3062 | 0.194644023514043 | 0.488148251912616 | 0.491676198555131 | false | false | false | true | ||||||||||||||||
| 40cd692d-55b5-4186-bdbb-03b50e899a86 | 2026-09-09 12:21 | 2026-09-09 12:21 | 2026-09-09 12:21 | USO | USO260918C00155000 | call | 155.0000 | 2026-09-18 | 2.3900 | 2.3900 | 2.4100 | 149.3001 | 39674.00 | 0.00 | 39674.00 | 166 | 14 | 536 | 3062 | 0.175048987589811 | 0.488148251912616 | 0.488148251912616 | true | false | false | true | ||||||||||||||||
| 90818e54-a7b4-4f03-9dad-0a2616b2a5c1 | 2026-08-19 11:09 | 2026-08-19 11:09 | 2026-08-19 11:09 | USO | USO260918C00155000 | call | 155.0000 | 2026-09-18 | 1.6400 | 1.4900 | 1.6400 | 132.3150 | 11644.00 | 11644.00 | 0.00 | 71 | 13 | 79 | 2577 | 0.0306558013193636 | 0.520008460605714 | 0.520008460605714 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:45:45.480252Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T15:05:41.395170Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:59:42.234161Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T16:13:08.333814Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:57:03.898045Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:36:53.026568Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:06:33.692120Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:58:33.363095Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T16:21:26.040266Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T16:21:26.040266Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |