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_alerts425,429 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 |
|---|
| 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 |
|---|
| 4daa2ff1-644f-4ea3-8f77-3947c679ba54 | 2026-08-20 10:30 | 2026-08-20 10:30 | 2026-08-20 10:30 | OUST | OUST270219C00060000 | call | 60.0000 | 2027-02-19 | 5.9000 | 5.6000 | 7.0000 | 38.4300 | 21240.00 | 16520.00 | 4720.00 | 36 | 20 | 36 | 63 | 0.571428571428571 | 1.0394891926165 | 1.0394891926165 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 2412878662.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2c3d6a09-46d0-410c-874c-6324ca14b8c0 | 2026-08-20 10:27 | 2026-08-20 10:27 | 2026-08-20 10:27 | OUST | OUST270219P00042000 | put | 42.0000 | 2027-02-19 | 12.8000 | 12.6000 | 13.2000 | 38.4128 | 32000.00 | 25600.00 | 6400.00 | 25 | 12 | 25 | 1 | 25 | 1.03470419152707 | 1.03470419152707 | false | false | false | true | ||||||||||||||||
| c682f988-6c12-44f9-8fc1-419007413c24 | 2026-08-20 10:18 | 2026-08-20 10:18 | 2026-08-20 10:18 | OUST | OUST260904C00050000 | call | 50.0000 | 2026-09-04 | 0.5000 | 0.4500 | 0.6000 | 38.4799 | 49150.00 | 1050.00 | 48100.00 | 983 | 11 | 983 | 61 | 16.1147540983607 | 1.05167050320133 | 1.05167050320133 | false | false | false | true | ||||||||||||||||
| 61c7e3e2-08bd-44ef-bd50-7c0230026701 | 2026-08-20 10:08 | 2026-08-20 10:08 | 2026-08-20 10:08 | OUST | OUST270115C00040000 | call | 40.0000 | 2027-01-15 | 9.7000 | 9.7000 | 10.2000 | 38.7900 | 25220.00 | 0.00 | 25220.00 | 26 | 9 | 29 | 1452 | 0.0199724517906336 | 1.0237185181578 | 1.0237185181578 | false | false | false | true | ||||||||||||||||
| 3f54d9e8-c679-43e7-b336-0625fb9b6d1d | 2026-08-19 13:21 | 2026-08-19 13:20 | 2026-08-19 13:20 | OUST | OUST261120C00045000 | call | 45.0000 | 2026-11-20 | 7.2000 | 7.0000 | 7.5000 | 40.7600 | 14400.00 | 11520.00 | 2880.00 | 20 | 6 | 101 | 168 | 0.601190476190476 | 1.05742314087906 | 1.05742314087906 | false | false | false | true | ||||||||||||||||
| 19619134-e16d-474a-9e13-a5c8cd5398c5 | 2026-08-19 10:31 | 2026-08-19 10:30 | 2026-08-19 10:30 | OUST | OUST270115C00060000 | call | 60.0000 | 2027-01-15 | 5.6000 | 5.6000 | 6.0000 | 40.2079 | 26880.00 | 0.00 | 26880.00 | 48 | 5 | 64 | 5945 | 0.0107653490328007 | 1.05066708008557 | 1.05066708008557 | false | false | false | true | ||||||||||||||||
| 2794be98-802a-44ca-81c9-59d511864380 | 2026-08-19 09:40 | 2026-08-19 09:40 | 2026-08-19 09:40 | OUST | OUST261120C00065000 | call | 65.0000 | 2026-11-20 | 3.4000 | 3.4000 | 3.6000 | 41.2801 | 29240.00 | 0.00 | 19040.00 | 86 | 9 | 86 | 167 | 0.514970059880239 | 1.10496148586682 | 1.10496148586682 | false | false | false | true | ||||||||||||||||
| 371b3e02-1ae0-4545-b550-a844343dbdfb | 2026-08-18 15:42 | 2026-08-18 15:42 | 2026-08-18 15:42 | OUST | OUST260821C00043000 | call | 43.0000 | 2026-08-21 | 2.1500 | 2.0000 | 2.2000 | 43.5700 | 11825.00 | 2365.00 | 9460.00 | 55 | 5 | 271 | 202 | 1.34158415841584 | 1.17840059625488 | 1.17840059625488 | false | false | false | true | ||||||||||||||||
| 1cb139fb-51ba-4540-a751-c44a3ff0b3d3 | 2026-08-18 15:42 | 2026-08-18 15:42 | 2026-08-18 15:42 | OUST | OUST260821C00044000 | call | 44.0000 | 2026-08-21 | 1.6500 | 1.5000 | 1.6500 | 43.5100 | 23402.00 | 23402.00 | 0.00 | 142 | 8 | 259 | 142 | 1.82394366197183 | 1.18782382019482 | 1.18782382019482 | false | false | false | true | ||||||||||||||||
| 5917733c-a1bb-432c-a213-9d68e97eee78 | 2026-08-18 15:28 | 2026-08-18 15:28 | 2026-08-18 15:28 | OUST | OUST280121C00095000 | call | 95.0000 | 2028-01-21 | 12.8000 | 12.8000 | 13.5000 | 43.1400 | 40960.00 | 0.00 | 40960.00 | 32 | 6 | 57 | 387 | 0.147286821705426 | 1.07870569872653 | 1.07870569872653 | false | false | false | true | ||||||||||||||||
| d332bb9c-6fef-4045-b57e-60048293e6c4 | 2026-08-18 14:30 | 2026-08-18 14:30 | 2026-08-18 14:30 | OUST | OUST261120P00039000 | put | 39.0000 | 2026-11-20 | 6.7000 | 6.7000 | 6.9000 | 43.2600 | 57620.00 | 0.00 | 57620.00 | 86 | 18 | 100 | 11 | 9.09090909090909 | 1.07999971055515 | 1.07999971055515 | false | false | false | true | ||||||||||||||||
| 06cf6e1d-3eff-43c7-b5c1-bc8dc2d87925 | 2026-08-18 12:21 | 2026-08-18 12:21 | 2026-08-18 12:21 | OUST | OUST260918P00043000 | put | 43.0000 | 2026-09-18 | 4.6000 | 4.3000 | 4.7000 | 43.8150 | 17020.00 | 1380.00 | 15640.00 | 37 | 5 | 40 | 14 | 2.85714285714286 | 1.00846327877567 | 1.00846327877567 | false | false | false | true | ||||||||||||||||
| edb03479-dbe3-44c9-8314-4c775f7b46b2 | 2026-08-18 09:53 | 2026-08-18 09:53 | 2026-08-18 09:53 | OUST | OUST260821C00050000 | call | 50.0000 | 2026-08-21 | 0.5500 | 0.5500 | 0.7000 | 44.7650 | 15565.00 | 0.00 | 15565.00 | 283 | 12 | 324 | 3022 | 0.107213765718068 | 1.32376731711867 | 1.32376731711867 | false | false | false | true | ||||||||||||||||
| f0212ac2-088f-443f-8e65-4e4ef5daeb65 | 2026-08-17 15:12 | 2026-08-17 15:11 | 2026-08-17 15:11 | OUST | OUST261120P00030000 | put | 30.0000 | 2026-11-20 | 2.3500 | 1.9000 | 2.3500 | 47.8900 | 14570.00 | 14570.00 | 0.00 | 62 | 13 | 190 | 1393 | 0.136396267049533 | 1.11604396653468 | 1.11604396653468 | false | false | false | true | ||||||||||||||||
| a1789bcb-82a2-4b11-b5e3-7afd271ed700 | 2026-08-17 13:52 | 2026-08-17 13:52 | 2026-08-17 13:52 | OUST | OUST261120P00030000 | put | 30.0000 | 2026-11-20 | 2.3500 | 1.9000 | 2.3500 | 48.0000 | 12220.00 | 12220.00 | 0.00 | 52 | 13 | 128 | 1393 | 0.0918880114860014 | 1.12704538121868 | 1.12704538121868 | false | false | false | true | ||||||||||||||||
| c503c97b-f61c-430f-9f8d-a8d2b37ec3e3 | 2026-08-17 13:52 | 2026-08-17 13:52 | 2026-08-17 13:52 | OUST | OUST261120P00030000 | put | 30.0000 | 2026-11-20 | 2.3500 | 1.9000 | 2.3500 | 48.0000 | 12690.00 | 12690.00 | 0.00 | 54 | 12 | 76 | 1393 | 0.0545585068198134 | 1.12729358027448 | 1.12729358027448 | false | false | false | true | ||||||||||||||||
| b57f60b1-f506-4e21-a1f0-be998eafe615 | 2026-08-17 12:06 | 2026-08-17 12:06 | 2026-08-17 12:06 | OUST | OUST261120C00070000 | call | 70.0000 | 2026-11-20 | 6.8000 | 6.1000 | 6.8000 | 51.4800 | 13600.00 | 13600.00 | 0.00 | 20 | 7 | 39 | 798 | 0.0488721804511278 | 1.15864650211881 | 1.15864650211881 | false | false | false | true | ||||||||||||||||
| 8f04efac-a83e-4b7e-9d69-050e83d83de2 | 2026-08-17 11:40 | 2026-08-17 11:40 | 2026-08-17 11:40 | OUST | OUST260918C00055000 | call | 55.0000 | 2026-09-18 | 4.8000 | 4.8000 | 5.2000 | 51.1250 | 28320.00 | 0.00 | 28320.00 | 59 | 9 | 408 | 817 | 0.499388004895961 | 1.03999397158382 | 1.03999397158382 | true | false | false | true | ||||||||||||||||
| 72616d09-c3cd-4393-bb44-1a67278fea33 | 2026-08-17 11:39 | 2026-08-17 11:39 | 2026-08-17 11:39 | OUST | OUST260918C00055000 | call | 55.0000 | 2026-09-18 | 4.9000 | 4.8000 | 4.9000 | 51.0800 | 60270.00 | 490.00 | 0.00 | 123 | 23 | 349 | 817 | 0.427172582619339 | 1.06012836122443 | 1.06012836122443 | false | false | false | true | ||||||||||||||||
| ffc20b30-885d-43db-a457-4f8b23c73852 | 2026-08-17 11:37 | 2026-08-17 11:37 | 2026-08-17 11:37 | OUST | OUST260918C00060000 | call | 60.0000 | 2026-09-18 | 3.6000 | 3.5000 | 3.6000 | 51.4100 | 10796.00 | 10796.00 | 0.00 | 30 | 8 | 1183 | 1592 | 0.743090452261307 | 1.07391142733239 | 1.06698197142917 | false | false | false | true | ||||||||||||||||
| a4b07717-c9fc-48af-9d7a-1876c44379fb | 2026-08-17 10:56 | 2026-08-17 10:56 | 2026-08-17 10:56 | OUST | OUST260918C00065000 | call | 65.0000 | 2026-09-18 | 2.3900 | 2.3500 | 2.4000 | 50.6000 | 22974.00 | 22504.00 | 470.00 | 96 | 10 | 776 | 110 | 7.05454545454545 | 1.09728890396249 | 1.10176362786858 | false | false | false | true | ||||||||||||||||
| 10c05549-8b6f-4716-85ac-97a510a7f758 | 2026-08-17 10:53 | 2026-08-17 10:53 | 2026-08-17 10:53 | OUST | OUST260918C00065000 | call | 65.0000 | 2026-09-18 | 2.2500 | 2.1000 | 2.3000 | 50.3000 | 17325.00 | 12150.00 | 4725.00 | 77 | 11 | 174 | 110 | 1.58181818181818 | 1.08789305685911 | 1.08789305685911 | false | false | false | true | ||||||||||||||||
| d8f4ca88-ea4f-4268-bd16-fd365e4b5bbf | 2026-08-17 10:14 | 2026-08-17 10:14 | 2026-08-17 10:14 | OUST | OUST261120P00040000 | put | 40.0000 | 2026-11-20 | 5.7000 | 5.7000 | 6.0000 | 49.6900 | 14820.00 | 0.00 | 14820.00 | 26 | 7 | 36 | 83 | 0.433734939759036 | 1.11362303478774 | 1.11362303478774 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:49:07.657249Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 2412878662.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |