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_alerts609,118 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 |
|---|
| 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 |
|---|
| 6d281149-774e-44b5-ae61-bf475e05674b | 2026-09-30 10:53 | 2026-09-30 10:52 | 2026-09-30 10:52 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 7.4100 | 7.4000 | 7.6500 | 146.0000 | 21480.00 | 0.00 | 21480.00 | 29 | 7 | 63 | 3807 | 0.016548463356974 | 0.51370764152356 | 0.51370764152356 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | Financial Services | 1228364647.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T14:54:10.101725Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| b6cb874f-e17c-434b-80cf-b5a8101001cb | 2026-09-29 09:46 | 2026-09-29 09:46 | 2026-09-29 09:46 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 7.6500 | 7.6500 | 7.8500 | 146.4795 | 44370.00 | 0.00 | 44370.00 | 58 | 15 | 361 | 3595 | 0.100417246175243 | 0.53777805813757 | 0.53777805813757 | false | false | false | true | false | |||||||||||||||
| a3236011-e0d6-41b3-b213-1a1a36441e30 | 2026-09-29 09:46 | 2026-09-29 09:46 | 2026-09-29 09:46 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 7.6500 | 7.4500 | 7.8500 | 146.4795 | 110925.00 | 0.00 | 103275.00 | 145 | 28 | 303 | 3595 | 0.0842837273991655 | 0.53777805813757 | 0.53777805813757 | true | false | false | true | false | |||||||||||||||
| 1e82f544-ed1e-4ab7-841d-6a33a56aee55 | 2026-09-29 09:41 | 2026-09-29 09:41 | 2026-09-29 09:41 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 7.2600 | 7.0500 | 7.6500 | 145.8100 | 11610.00 | 2165.00 | 9445.00 | 16 | 8 | 147 | 3595 | 0.0408901251738526 | 0.539587422600544 | 0.531561945608835 | true | false | false | true | false | |||||||||||||||
| 21bc58e5-9e99-4b18-9be8-a7dfe4e53a3b | 2026-09-29 09:33 | 2026-09-29 09:33 | 2026-09-29 09:33 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 7.3000 | 7.3000 | 7.5500 | 145.7400 | 30669.00 | 0.00 | 30669.00 | 42 | 11 | 80 | 3595 | 0.0222531293463143 | 0.542664925843733 | 0.542664925843733 | true | false | false | true | false | |||||||||||||||
| be56485a-7170-4672-808e-26d92d0cf7c9 | 2026-09-25 13:37 | 2026-09-25 13:37 | 2026-09-25 13:37 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 9.6500 | 9.5000 | 9.9500 | 148.0000 | 91675.00 | 14475.00 | 77200.00 | 95 | 6 | 200 | 3549 | 0.0563539025077487 | 0.527850888054828 | 0.526730348360725 | false | false | false | true | false | |||||||||||||||
| e9b1e643-74d8-41b5-a2ee-51bbfaa42924 | 2026-09-22 09:32 | 2026-09-22 09:31 | 2026-09-22 09:31 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 7.4000 | 7.4000 | 7.6500 | 145.7099 | 11840.00 | 0.00 | 11840.00 | 16 | 8 | 189 | 3495 | 0.0540772532188841 | 0.461054419293845 | 0.461054419293845 | false | false | false | true | false | |||||||||||||||
| 4275b4ba-9df9-42f0-a845-9b6b483cdb08 | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 7.4500 | 7.1000 | 7.4500 | 145.5550 | 113912.00 | 113912.00 | 0.00 | 153 | 24 | 166 | 3495 | 0.0474964234620887 | 0.470160668878781 | 0.470160668878781 | true | false | false | true | false | |||||||||||||||
| dfcdf76d-0a27-4e87-9c46-de6fe41b94f3 | 2026-09-21 11:02 | 2026-09-21 11:02 | 2026-09-21 11:02 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 9.1500 | 9.1000 | 9.2500 | 148.4800 | 16470.00 | 15555.00 | 915.00 | 18 | 5 | 57 | 3483 | 0.016365202411714 | 0.460708470997118 | 0.460708470997118 | true | false | false | true | false | |||||||||||||||
| d50813bd-0114-48a7-8e44-cf9335ed3bd9 | 2026-09-10 15:18 | 2026-09-10 15:18 | 2026-09-10 15:18 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 18.0400 | 18.0000 | 18.3500 | 158.0600 | 45100.00 | 0.00 | 45100.00 | 25 | 5 | 618 | 3745 | 0.16502002670227 | 0.513148297220313 | 0.516243675016034 | false | false | false | true | false | |||||||||||||||
| e9d9ac4f-5706-4e20-b5cf-9cb9f7cee126 | 2026-09-10 12:07 | 2026-09-10 12:07 | 2026-09-10 12:07 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 17.0000 | 16.8000 | 17.0000 | 156.7000 | 10200.00 | 10200.00 | 0.00 | 6 | 6 | 408 | 3745 | 0.10894526034713 | 0.512715768802016 | 0.512715768802016 | true | false | false | true | false | |||||||||||||||
| 99cc56cd-d83f-4fef-9833-de5155b7d861 | 2026-09-09 10:08 | 2026-09-09 10:08 | 2026-09-09 10:08 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 10.7000 | 10.4500 | 10.8000 | 148.5550 | 21400.00 | 21400.00 | 0.00 | 20 | 5 | 124 | 4107 | 0.0301923545166788 | 0.45596959921362 | 0.45596959921362 | true | false | false | true | false | |||||||||||||||
| b19d053c-eafe-40bd-a56f-b059c2801dac | 2026-09-09 09:35 | 2026-09-09 09:35 | 2026-09-09 09:35 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 10.6800 | 10.5000 | 10.8000 | 148.6000 | 10680.00 | 4272.00 | 6408.00 | 10 | 5 | 65 | 4107 | 0.0158266374482591 | 0.453373893459166 | 0.453373893459166 | false | false | false | true | false | |||||||||||||||
| 4886f7ae-52d3-4781-900f-ae0118a23817 | 2026-09-04 12:00 | 2026-09-04 12:00 | 2026-09-04 12:00 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 6.7500 | 6.7000 | 7.1000 | 141.2000 | 27004.00 | 0.00 | 24979.00 | 40 | 15 | 297 | 4480 | 0.0662946428571429 | 0.426279802788962 | 0.426279802788962 | true | false | false | true | false | |||||||||||||||
| 9ce9fab9-bf20-4a9e-8f8b-c2ddc25ddd90 | 2026-09-04 09:46 | 2026-09-04 09:46 | 2026-09-04 09:46 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 5.6000 | 5.4000 | 5.9500 | 138.8300 | 16800.00 | 0.00 | 16800.00 | 30 | 6 | 90 | 4480 | 0.0200892857142857 | 0.421091606682652 | 0.421091606682652 | false | false | false | true | false | |||||||||||||||
| d3f9a5b5-eb5c-4898-89db-9913a277e50b | 2026-09-01 13:25 | 2026-09-01 13:25 | 2026-09-01 13:25 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 7.0500 | 6.7500 | 7.0500 | 139.5100 | 124785.00 | 124785.00 | 0.00 | 177 | 7 | 1223 | 9463 | 0.129240198668498 | 0.469460070723918 | 0.465980422100719 | false | false | false | true | false | |||||||||||||||
| da0bb8c9-b996-4280-b82b-bcba144e2834 | 2026-09-01 11:22 | 2026-09-01 11:22 | 2026-09-01 11:22 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 5.7500 | 5.4500 | 5.7500 | 137.1100 | 431186.00 | 431186.00 | 0.00 | 750 | 45 | 838 | 9463 | 0.0885554263975483 | 0.45156422337413 | 0.45156422337413 | true | false | false | true | false | |||||||||||||||
| 68f9085d-f629-47c5-beff-a3aa1792716c | 2026-08-28 11:15 | 2026-08-28 11:15 | 2026-08-28 11:15 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 3.6100 | 3.4500 | 3.7500 | 129.2400 | 14440.00 | 8680.00 | 0.00 | 40 | 5 | 121 | 9435 | 0.0128245892951775 | 0.464049756161068 | 0.464049756161068 | false | false | false | true | false | |||||||||||||||
| 2332a4e5-3381-4407-a946-200d748fdb54 | 2026-08-27 15:18 | 2026-08-27 15:18 | 2026-08-27 15:18 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 4.3000 | 4.1000 | 4.3000 | 130.0000 | 322433.00 | 322433.00 | 0.00 | 750 | 61 | 805 | 8936 | 0.0900850492390331 | 0.476230090828401 | 0.475864048785064 | true | false | false | true | false | |||||||||||||||
| 07c6e00a-5fd7-4db6-b7db-8564260e9578 | 2026-08-24 09:45 | 2026-08-24 09:45 | 2026-08-24 09:45 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 5.5000 | 5.4000 | 5.9000 | 132.9700 | 19250.00 | 0.00 | 19250.00 | 35 | 17 | 112 | 7643 | 0.0146539317022112 | 0.482335580779394 | 0.482335580779394 | true | false | false | true | false | |||||||||||||||
| 5b85202e-69ae-4cf6-a9fc-96355d859d20 | 2026-08-21 12:38 | 2026-08-21 12:37 | 2026-08-21 12:37 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 6.6000 | 6.5500 | 6.8000 | 134.8100 | 139260.00 | 660.00 | 138600.00 | 211 | 5 | 1232 | 6606 | 0.186497123826824 | 0.488472642556944 | 0.488472642556944 | false | false | false | true | false | |||||||||||||||
| b94e6f0b-790f-44bb-a9cc-8f822b1856a0 | 2026-08-17 13:35 | 2026-08-17 13:35 | 2026-08-17 13:35 | USO | USO261016C00145000 | call | 145.0000 | 2026-10-16 | 5.8000 | 5.4500 | 5.8500 | 129.7200 | 20295.00 | 20295.00 | 0.00 | 35 | 13 | 70 | 1128 | 0.0620567375886525 | 0.525202719166929 | 0.525202719166929 | true | false | false | true | false |
| 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-29T13:48:49.550855Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| 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-29T13:48:49.550855Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| 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-29T13:42:07.664429Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| 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-29T13:35:17.817749Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| 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-25T17:41:26.046305Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-22T13:32:27.895939Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T13:31:35.812482Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-21T15:05:23.809831Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-10T19:25:57.950009Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-10T16:13:08.333814Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-09T14:11:22.686371Z"} |
| 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-09T13:36:21.128731Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-04T16:13:56.145626Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-04T13:56:18.493427Z"} |
| 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-01T17:48:11.364966Z"} |
| 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-01T15:45:30.323966Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| Financial Services |
| 1228364647.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:36:02.227679Z"} |
| 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 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:35:44.109119Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-24T13:46:45.098903Z"} |
| 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-21T16:43:46.028086Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-17T17:44:03.146928Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |