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_alerts658,639 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 |
|---|
| e1de5afd-ed13-4c25-9d6f-74441852369c | 2026-09-28 12:43 | 2026-09-28 12:43 | 2026-09-28 12:43 | FXI | FXI261106P00035000 | put | 35.0000 | 2026-11-06 | 1.2300 | 1.1600 | 1.2300 | 34.0000 | 61344.00 | 57318.00 | 0.00 | 500 | 25 | 1000 | 0 | 0 | 0.201048157738593 | 0.201048157738593 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 4099596259.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T16:43:39.735275Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| b535984f-05ff-4766-b735-cbe9a3498804 | 2026-09-25 14:34 | 2026-09-25 14:34 | 2026-09-25 14:34 | FXI | FXI261023P00032500 | put | 32.5000 | 2026-10-23 | 0.2400 | 0.2200 | 0.2900 | 33.9650 | 11801.00 | 0.00 | 11801.00 | 500 | 5 | 505 | 12 | 42.0833333333333 | 0.214725735326917 | 0.214725735326917 | false | false | false | |||||||||||||||||
| 4950fb09-903f-40cd-8160-2c3fbb759e14 | 2026-09-24 10:56 | 2026-09-24 10:56 | 2026-09-24 10:56 | FXI | FXI261016C00034500 | call | 34.5000 | 2026-10-16 | 0.5600 | 0.5400 | 0.5700 | 34.1900 | 14165.00 | 14056.00 | 109.00 | 253 | 35 | 282 | 245 | 1.15102040816327 | 0.198669774490949 | 0.198669774490949 | false | false | false | |||||||||||||||||
| 96dd1b0c-6ba5-440c-afa5-b11ea0bb67fb | 2026-09-16 13:02 | 2026-09-16 13:02 | 2026-09-16 13:02 | FXI | FXI261120C00034000 | call | 34.0000 | 2026-11-20 | 1.4100 | 1.4000 | 1.6000 | 34.1300 | 14126.00 | 0.00 | 14126.00 | 100 | 8 | 200 | 7622 | 0.0262398320650748 | 0.213886797351229 | 0.213886797351229 | false | false | false | |||||||||||||||||
| 16c962fa-c3e8-4c56-9954-5629a7700818 | 2026-09-10 10:53 | 2026-09-10 10:53 | 2026-09-10 10:53 | FXI | FXI261016C00035000 | call | 35.0000 | 2026-10-16 | 0.6800 | 0.6500 | 0.6800 | 34.4950 | 14326.00 | 13600.00 | 726.00 | 211 | 10 | 926 | 15046 | 0.0615445965705171 | 0.196843153190261 | 0.196843153190261 | false | false | false | |||||||||||||||||
| c5504dcf-3c54-4abc-bd9e-f679b5114377 | 2026-09-10 10:27 | 2026-09-10 10:27 | 2026-09-10 10:27 | FXI | FXI280121P00032000 | put | 32.0000 | 2028-01-21 | 2.4200 | 2.0400 | 2.6400 | 34.4499 | 40853.00 | 33293.00 | 7560.00 | 169 | 8 | 169 | 2669 | 0.0633195953540652 | 0.275998105757616 | 0.267321657023874 | false | false | false | |||||||||||||||||
| b54d85f4-3174-465b-ae7d-7938b832f95e | 2026-09-10 10:27 | 2026-09-10 10:27 | 2026-09-10 10:27 | FXI | FXI280121P00030000 | put | 30.0000 | 2028-01-21 | 1.8100 | 1.4300 | 1.9700 | 34.4499 | 33878.00 | 27848.00 | 6030.00 | 187 | 17 | 187 | 14066 | 0.0132944689321769 | 0.28450718948213 | 0.276340079406275 | false | false | false | |||||||||||||||||
| a438abb1-cadf-48c0-b736-89723befad8e | 2026-09-10 10:27 | 2026-09-10 10:27 | 2026-09-10 10:27 | FXI | FXI280121P00031000 | put | 31.0000 | 2028-01-21 | 2.1000 | 1.7100 | 2.2900 | 34.4499 | 34574.00 | 30056.00 | 4518.00 | 165 | 7 | 165 | 278 | 0.593525179856115 | 0.279445988806744 | 0.270258826875773 | false | false | false | |||||||||||||||||
| 7685254b-ffa8-486b-9138-ab09999abb25 | 2026-09-08 12:38 | 2026-09-08 12:38 | 2026-09-08 12:38 | FXI | FXI261002P00034500 | put | 34.5000 | 2026-10-02 | 0.4900 | 0.3900 | 0.4900 | 34.9350 | 97826.00 | 97826.00 | 0.00 | 1998 | 39 | 2001 | 18 | 111.166666666667 | 0.203172475380532 | 0.203172475380532 | false | false | false | |||||||||||||||||
| 9154b106-cf80-41c6-be5a-392199463572 | 2026-09-08 10:15 | 2026-09-08 10:15 | 2026-09-08 10:15 | FXI | FXI260918P00035000 | put | 35.0000 | 2026-09-18 | 0.3700 | 0.3700 | 0.4100 | 35.1050 | 11603.00 | 0.00 | 11603.00 | 310 | 21 | 7110 | 64983 | 0.109413231152763 | 0.193256851498059 | 0.188898471393038 | false | false | false | |||||||||||||||||
| 727a5360-1805-4ba6-8d87-3652f9fc07b2 | 2026-09-03 15:00 | 2026-09-03 15:00 | 2026-09-03 15:00 | FXI | FXI261120P00035000 | put | 35.0000 | 2026-11-20 | 0.9900 | 1.0000 | 1.0800 | 35.3805 | 23880.00 | 0.00 | 23880.00 | 241 | 18 | 252 | 16248 | 0.0155096011816839 | 0.202595300701335 | 0.201013131617007 | true | false | false | |||||||||||||||||
| 72764d6d-0c71-447e-8db9-5a3c7f857b82 | 2026-09-03 15:00 | 2026-09-03 15:00 | 2026-09-03 15:00 | FXI | FXI261016P00034000 | put | 34.0000 | 2026-10-16 | 0.3600 | 0.3600 | 0.3900 | 35.3805 | 10106.00 | 0.00 | 10106.00 | 277 | 10 | 309 | 9464 | 0.0326500422654269 | 0.202316567858639 | 0.197108122658355 | true | false | false | |||||||||||||||||
| 69b52455-bc0d-45b5-80ee-3ea12c1c4988 | 2026-09-02 12:14 | 2026-09-02 12:14 | 2026-09-02 12:14 | FXI | FXI261120P00035000 | put | 35.0000 | 2026-11-20 | 0.9600 | 0.9200 | 1.0700 | 35.5400 | 12942.00 | 95.00 | 12847.00 | 135 | 20 | 135 | 16152 | 0.00835809806835067 | 0.205111058368306 | 0.203526271985395 | true | false | false | |||||||||||||||||
| 0098b298-1f69-4378-944d-fb1aa1aa5c0d | 2026-09-01 11:54 | 2026-09-01 11:54 | 2026-09-01 11:54 | FXI | FXI261016C00037000 | call | 37.0000 | 2026-10-16 | 0.4400 | 0.4400 | 0.4500 | 35.4650 | 27635.00 | 135.00 | 27500.00 | 628 | 20 | 3880 | 12442 | 0.311846969940524 | 0.194447517155096 | 0.19248897643318 | false | false | false | |||||||||||||||||
| 239c1115-4614-4d4f-a541-7f2a2664f602 | 2026-08-28 12:21 | 2026-08-28 12:21 | 2026-08-28 12:21 | FXI | FXI261218P00030000 | put | 30.0000 | 2026-12-18 | 0.3800 | 0.2600 | 0.4000 | 35.4000 | 44824.00 | 44460.00 | 62.00 | 1180 | 49 | 1180 | 33273 | 0.0354641901842335 | 0.296809452372573 | 0.278573464136589 | true | false | false | |||||||||||||||||
| 97a737bc-8417-463a-b040-bba6e21f8518 | 2026-08-28 10:14 | 2026-08-28 10:14 | 2026-08-28 10:14 | FXI | FXI261120P00030000 | put | 30.0000 | 2026-11-20 | 0.2300 | 0.1300 | 0.2300 | 35.4850 | 287429.00 | 287385.00 | 22.00 | 12497 | 55 | 28092 | 3787 | 7.41800897808292 | 0.294060477083384 | 0.290491278206664 | true | false | false | |||||||||||||||||
| 59742fde-ffc0-40bd-b22e-af3f82784539 | 2026-08-28 10:02 | 2026-08-28 10:02 | 2026-08-28 10:02 | FXI | FXI261120P00030000 | put | 30.0000 | 2026-11-20 | 0.2300 | 0.1300 | 0.2400 | 35.5850 | 115136.00 | 115092.00 | 22.00 | 5006 | 59 | 5006 | 3787 | 1.32189067863744 | 0.297332683348341 | 0.293741459894331 | true | false | false | |||||||||||||||||
| 59dea44c-7f42-42e2-af6a-0f9cd8e81e77 | 2026-08-24 15:25 | 2026-08-24 15:24 | 2026-08-24 15:24 | FXI | FXI261218P00036000 | put | 36.0000 | 2026-12-18 | 2.0800 | 1.9600 | 2.0800 | 35.5100 | 289740.00 | 289740.00 | 0.00 | 1393 | 48 | 4101 | 61198 | 0.0670119938560084 | 0.257579929779468 | 0.253816017911306 | false | false | false | |||||||||||||||||
| d2234fd3-1312-418f-98f7-2c550cdec1b3 | 2026-08-24 10:07 | 2026-08-24 10:06 | 2026-08-24 10:06 | FXI | FXI260918P00032000 | put | 32.0000 | 2026-09-18 | 0.0500 | 0.0300 | 0.0600 | 35.4850 | 23820.00 | 23820.00 | 0.00 | 4364 | 17 | 4368 | 45495 | 0.0960105506099571 | 0.261168600986642 | 0.251238299049196 | false | false | false | |||||||||||||||||
| 1a17c3b3-f7fd-4f38-b130-3ef185a3283d | 2026-08-21 15:33 | 2026-08-21 15:33 | 2026-08-21 15:33 | FXI | FXI270219C00039000 | call | 39.0000 | 2027-02-19 | 1.1200 | 1.1200 | 1.2000 | 35.8700 | 56158.00 | 0.00 | 56158.00 | 500 | 8 | 1040 | 16728 | 0.0621712099473936 | 0.202813434662963 | 0.202813434662963 | false | false | false | |||||||||||||||||
| 327f6726-c13d-4f89-baa3-9241ac7ca5e6 | 2026-08-20 12:13 | 2026-08-20 12:13 | 2026-08-20 12:13 | FXI | FXI261218P00033000 | put | 33.0000 | 2026-12-18 | 0.9200 | 0.7500 | 0.9200 | 35.5950 | 94757.00 | 94667.00 | 90.00 | 1030 | 48 | 1091 | 22068 | 0.0494381004168932 | 0.268493325119243 | 0.265450525429596 | false | false | false | |||||||||||||||||
| 55b2244f-1918-463c-9499-9c42bc48cf66 | 2026-08-19 11:49 | 2026-08-19 11:49 | 2026-08-19 11:49 | FXI | FXI261218P00031000 | put | 31.0000 | 2026-12-18 | 0.5400 | 0.3300 | 0.5400 | 35.7450 | 201414.00 | 201414.00 | 0.00 | 3730 | 55 | 3730 | 7900 | 0.472151898734177 | 0.293399474487504 | 0.289500702707988 | false | false | false | |||||||||||||||||
| 7de7481d-1c41-4aec-ab5f-9a661ecce3da | 2026-08-19 10:04 | 2026-08-19 10:04 | 2026-08-19 10:04 | FXI | FXI261120P00030000 | put | 30.0000 | 2026-11-20 | 0.2300 | 0.1300 | 0.2300 | 35.6150 | 32658.00 | 32636.00 | 22.00 | 1420 | 47 | 1420 | 3302 | 0.430042398546336 | 0.284746292133228 | 0.28131724163867 | true | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4109333945.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:38:37.498256Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4186569238.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:58:33.796895Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4115649356.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4130752601.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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4130752601.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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4130752601.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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4130752601.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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4130752601.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:42:24.738421Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4164718584.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4164718584.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:09:41.417490Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4164718584.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:09:41.417490Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4164718584.00 |
| — |
| — |
| — |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4164718584.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T16:07:53.122506Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4164718584.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:25:17.992358Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4164718584.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:22:34.427319Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4164718584.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:08:43.927668Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4164718584.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:47:47.207382Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4164718584.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4164718584.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:48:47.460535Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4164718584.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4164718584.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:49:41.153087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 4164718584.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |