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_alerts474,253 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 |
|---|
| 06c5977e-f29f-44e3-8cb8-dddfb8c4d619 | 2026-09-25 11:57 | 2026-09-25 11:57 | 2026-09-25 11:57 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 0.4400 | 0.4000 | 0.4450 | 150.1927 | 10780.00 | 10780.00 | 0.00 | 245 | 24 | 304 | 16067 | 0.0189207692786457 | 0.590555709211154 | 0.590555709211154 | 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-25T15:59:16.361510Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| ec821fba-2ac1-4a91-98dd-36c1d2e41697 | 2026-09-16 11:33 | 2026-09-16 11:33 | 2026-09-16 11:33 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 0.6000 | 0.5900 | 0.6200 | 156.4500 | 83580.00 | 600.00 | 82980.00 | 1393 | 23 | 1638 | 15922 | 0.102876523049868 | 0.600448562425015 | 0.600448562425015 | false | false | false | true | false | |||||||||||||||
| c52d4105-9275-4156-ae64-1cd719b92800 | 2026-09-09 15:17 | 2026-09-09 15:17 | 2026-09-09 15:17 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 0.6900 | 0.6600 | 0.6900 | 149.4800 | 13800.00 | 13800.00 | 0.00 | 200 | 6 | 4384 | 17795 | 0.246361337454341 | 0.486931988341512 | 0.486931988341512 | false | false | false | true | false | |||||||||||||||
| 4729ea98-5368-4813-8df5-bba6ccf36dd4 | 2026-09-09 13:45 | 2026-09-09 13:45 | 2026-09-09 13:45 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 0.7300 | 0.7100 | 0.7300 | 148.6050 | 10877.00 | 10877.00 | 0.00 | 149 | 26 | 3903 | 17795 | 0.219331272829446 | 0.484000084806338 | 0.484000084806338 | false | false | false | true | false | |||||||||||||||
| bc4f7af2-d38d-4a56-aecd-0e0a314ba0dd | 2026-09-09 10:43 | 2026-09-09 10:43 | 2026-09-09 10:43 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 0.6500 | 0.6400 | 0.6500 | 148.9155 | 66690.00 | 66690.00 | 0.00 | 1026 | 5 | 3151 | 17795 | 0.177072211295308 | 0.474109814422307 | 0.474109814422307 | false | false | false | true | false | |||||||||||||||
| 1e87a80d-05e7-48dd-95be-83e3a82bb89b | 2026-09-09 09:31 | 2026-09-09 09:31 | 2026-09-09 09:31 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 0.6700 | 0.6500 | 0.6900 | 148.7628 | 20033.00 | 2278.00 | 16616.00 | 299 | 16 | 679 | 17795 | 0.0381567856139365 | 0.475855735069969 | 0.475855735069969 | false | false | false | true | false | |||||||||||||||
| a0987903-c3e1-4972-82b4-527effc09606 | 2026-09-09 09:30 | 2026-09-09 09:30 | 2026-09-09 09:30 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 0.6900 | 0.4900 | 0.9000 | 148.8000 | 11523.00 | 0.00 | 11523.00 | 167 | 34 | 167 | 17795 | 0.00938465861196965 | 0.479595274689755 | 0.479595274689755 | false | false | false | true | false | |||||||||||||||
| d12a90d5-e51c-4f63-b5b1-56c602afbd33 | 2026-09-03 10:23 | 2026-09-03 10:23 | 2026-09-03 10:23 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 1.1600 | 1.1600 | 1.1700 | 143.0300 | 86188.00 | 0.00 | 86188.00 | 743 | 13 | 1261 | 22130 | 0.0569814731134207 | 0.443981303695238 | 0.443981303695238 | true | false | false | true | false | |||||||||||||||
| 3e8a64da-5c34-4a71-9c80-4bcdf0255d96 | 2026-09-03 10:23 | 2026-09-03 10:23 | 2026-09-03 10:23 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 1.1600 | 1.1600 | 1.2500 | 143.0300 | 35580.00 | 1995.00 | 33585.00 | 306 | 46 | 518 | 22130 | 0.0234071396294623 | 0.443981303695238 | 0.445104435784171 | true | false | false | true | false | |||||||||||||||
| c2800a79-cfc3-4fbb-a0b1-62443519497d | 2026-09-01 15:14 | 2026-09-01 15:13 | 2026-09-01 15:13 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 1.6000 | 1.6000 | 1.6800 | 140.5600 | 12800.00 | 0.00 | 12800.00 | 80 | 32 | 3369 | 19074 | 0.176627870399497 | 0.449658469124077 | 0.449658469124077 | false | false | false | true | false | |||||||||||||||
| 5751e2fc-ba65-4de6-8a0a-d1dc9ab55007 | 2026-09-01 15:14 | 2026-09-01 15:13 | 2026-09-01 15:13 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 1.6100 | 1.6000 | 1.6500 | 140.5600 | 122544.00 | 0.00 | 122544.00 | 762 | 11 | 4724 | 19074 | 0.247666981230995 | 0.45059874354043 | 0.449658469124077 | false | false | false | true | false | |||||||||||||||
| 2798bdda-b726-44fa-a207-7f387db8d718 | 2026-09-01 15:14 | 2026-09-01 15:13 | 2026-09-01 15:13 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 1.6000 | 1.6000 | 1.6800 | 140.5600 | 94880.00 | 0.00 | 94880.00 | 593 | 11 | 3962 | 19074 | 0.20771731152354 | 0.449658469124077 | 0.449658469124077 | false | false | false | true | false | |||||||||||||||
| 72851f80-5d60-4871-a66a-72a7c3b01a8a | 2026-09-01 15:12 | 2026-09-01 15:12 | 2026-09-01 15:12 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 1.6500 | 1.6000 | 1.6500 | 140.6198 | 161700.00 | 161700.00 | 0.00 | 980 | 29 | 3289 | 19074 | 0.172433679354095 | 0.455093196870439 | 0.455093196870439 | false | false | false | true | false | |||||||||||||||
| 152222f2-0d96-4748-9297-918f62d8dcf5 | 2026-09-01 13:29 | 2026-09-01 13:29 | 2026-09-01 13:29 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 1.7900 | 1.7200 | 1.7900 | 139.4200 | 12530.00 | 12530.00 | 0.00 | 70 | 18 | 2106 | 19074 | 0.110412079270211 | 0.452484167215349 | 0.452484167215349 | false | false | false | true | false | |||||||||||||||
| d5b78213-7e76-4095-85d2-d8db2ee8b400 | 2026-09-01 12:45 | 2026-09-01 12:45 | 2026-09-01 12:45 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 1.7900 | 1.7700 | 1.8600 | 139.1150 | 15573.00 | 12530.00 | 3043.00 | 87 | 46 | 994 | 19074 | 0.0521128237391213 | 0.448500976329133 | 0.448500976329133 | false | false | false | true | false | |||||||||||||||
| ad8a6d99-c540-4c53-acae-4e6b044cb530 | 2026-09-01 12:44 | 2026-09-01 12:44 | 2026-09-01 12:44 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 1.8000 | 1.7500 | 1.8700 | 139.1150 | 14388.00 | 10434.00 | 3954.00 | 80 | 20 | 765 | 19074 | 0.0401069518716578 | 0.449388577660185 | 0.448500976329133 | true | false | false | true | false | |||||||||||||||
| febb769d-99d7-4d2f-bf85-b2deb19aad4d | 2026-08-27 14:06 | 2026-08-27 14:06 | 2026-08-27 14:06 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 3.6500 | 3.5500 | 3.7500 | 130.6900 | 18250.00 | 3650.00 | 7665.00 | 50 | 6 | 492 | 16114 | 0.0305324562492243 | 0.438036580718842 | 0.438036580718842 | false | false | false | true | false | |||||||||||||||
| 98c5f9d3-20cc-4b22-ad70-c477331436bc | 2026-08-17 13:39 | 2026-08-17 13:39 | 2026-08-17 13:39 | USO | USO261016P00120000 | put | 120.0000 | 2026-10-16 | 5.1500 | 5.1000 | 5.1500 | 129.8695 | 42745.00 | 42745.00 | 0.00 | 83 | 10 | 122 | 16990 | 0.00718069452619188 | 0.474195906662466 | 0.474195906662466 | 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-16T15:39:18.643032Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 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-09T19:27:55.926703Z"} |
| 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-09T17:50:47.676652Z"} |
| 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:59:53.339088Z"} |
| 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-09T13:30:57.501605Z"} |
| 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-03T14:24:32.358904Z"} |
| 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-03T14:24:32.358904Z"} |
| 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-01T19:21:20.162349Z"} |
| 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-01T19:21:20.162349Z"} |
| 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-01T19:21:20.162349Z"} |
| 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-01T19:21:20.162349Z"} |
| 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-01T17:48:11.364966Z"} |
| 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-01T16:48:42.201804Z"} |
| 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-01T16:48:42.201804Z"} |
| 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-27T18:14:24.609292Z"} |
| 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 |