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.
Simplify Analyticsuw_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 |
|---|
| 454dc3b6-cb9b-4d3c-b412-532d778a8782 | 2026-09-02 11:34 | 2026-09-02 11:34 | 2026-09-02 11:34 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.1200 | 3.1200 | 3.1400 | 292.7800 | 191880.00 | 0.00 | 191880.00 | 615 | 5 | 16654 | 75400 | 0.220875331564987 | 0.210790055543859 | 0.210790055543859 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 79887436077.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| eddd2b44-cb84-4b01-a785-e54d323a0540 | 2026-09-02 11:33 | 2026-09-02 11:33 | 2026-09-02 11:33 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.1400 | 3.1300 | 3.1800 | 292.7300 | 751402.00 | 0.00 | 751402.00 | 2393 | 38 | 16035 | 75400 | 0.212665782493369 | 0.211045012844459 | 0.211045012844459 | true | false | false | true | false | |||||||||||||||
| e02d3fd4-32ea-488b-a56e-a8040f708478 | 2026-09-02 11:33 | 2026-09-02 11:33 | 2026-09-02 11:33 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.1400 | 3.1400 | 3.1800 | 292.7650 | 435204.00 | 0.00 | 435204.00 | 1386 | 52 | 12690 | 75400 | 0.168302387267905 | 0.211310616796913 | 0.211310616796913 | true | false | false | true | false | |||||||||||||||
| d828926f-51a1-4737-bed9-454271129649 | 2026-09-02 11:33 | 2026-09-02 11:33 | 2026-09-02 11:33 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.1400 | 3.1300 | 3.1800 | 292.7800 | 279460.00 | 2198.00 | 277262.00 | 890 | 16 | 13580 | 75400 | 0.180106100795756 | 0.211424397532629 | 0.211424397532629 | true | false | false | true | false | |||||||||||||||
| c17abda8-0cc7-4e80-80c4-5a1c9c8c8b46 | 2026-09-02 11:33 | 2026-09-02 11:33 | 2026-09-02 11:33 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.1600 | 3.1500 | 3.2000 | 292.7400 | 969804.00 | 100488.00 | 869316.00 | 3069 | 73 | 11304 | 75400 | 0.149920424403183 | 0.211754063600556 | 0.211754063600556 | true | false | false | true | false | |||||||||||||||
| f998cee4-439f-4152-8216-c08a76242ebf | 2026-09-01 14:55 | 2026-09-01 14:55 | 2026-09-01 14:55 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.9200 | 3.9200 | 3.9700 | 290.2400 | 126616.00 | 0.00 | 126616.00 | 323 | 8 | 8847 | 71843 | 0.123143521289478 | 0.212922513361707 | 0.212922513361707 | false | false | false | true | false | |||||||||||||||
| 287d3ce1-c11b-48b6-a4df-314493e4246c | 2026-09-01 13:47 | 2026-09-01 13:47 | 2026-09-01 13:47 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.6600 | 3.6200 | 3.6700 | 290.7400 | 706746.00 | 644526.00 | 62220.00 | 1931 | 41 | 7058 | 71843 | 0.0982419999164846 | 0.209402901785757 | 0.209322975096446 | false | false | false | true | false | |||||||||||||||
| 9d9b6ce5-7072-49a0-b3db-509206e63b8a | 2026-09-01 13:46 | 2026-09-01 13:46 | 2026-09-01 13:46 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.6500 | 3.6200 | 3.6500 | 290.7500 | 698737.00 | 698737.00 | 0.00 | 1915 | 24 | 5127 | 71843 | 0.0713639463830853 | 0.209106327720322 | 0.209106327720322 | false | false | false | true | false | |||||||||||||||
| a3683ac1-02ef-4119-88e6-ff815f53b7ef | 2026-09-01 10:03 | 2026-09-01 10:03 | 2026-09-01 10:03 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.3900 | 3.3900 | 3.4200 | 291.4700 | 162042.00 | 0.00 | 162042.00 | 478 | 16 | 1792 | 71843 | 0.0249432790946926 | 0.206983500385136 | 0.206983500385136 | false | false | false | true | false | |||||||||||||||
| ec0e6345-8633-4a1c-9e9f-019989bd55cb | 2026-08-31 15:57 | 2026-08-31 15:57 | 2026-08-31 15:57 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 2.8300 | 2.7900 | 2.8300 | 293.9600 | 275076.00 | 275076.00 | 0.00 | 972 | 29 | 46237 | 56091 | 0.824321192348148 | 0.20595212942776 | 0.20595212942776 | true | false | false | true | false | |||||||||||||||
| 9f9dbaba-0efd-4071-ac3e-6e049cdc2b12 | 2026-08-31 14:48 | 2026-08-31 14:48 | 2026-08-31 14:48 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.0200 | 3.0200 | 3.0500 | 293.0201 | 248244.00 | 0.00 | 248244.00 | 822 | 11 | 43345 | 56091 | 0.77276211869997 | 0.205200393403687 | 0.205200393403687 | false | false | false | true | false | |||||||||||||||
| 91a1ac06-10f1-4c26-b0f2-ffe4631c08ce | 2026-08-31 14:48 | 2026-08-31 14:48 | 2026-08-31 14:48 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.0200 | 3.0100 | 3.0600 | 293.0201 | 755000.00 | 0.00 | 755000.00 | 2500 | 6 | 38658 | 56091 | 0.689201476172648 | 0.205200393403687 | 0.205200393403687 | false | false | false | true | false | |||||||||||||||
| 82c153f8-e211-41ec-8026-24f43fa3d9c4 | 2026-08-31 14:48 | 2026-08-31 14:48 | 2026-08-31 14:48 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.0100 | 3.0100 | 3.0500 | 293.0500 | 244748.00 | 0.00 | 244748.00 | 813 | 8 | 44158 | 56091 | 0.787256422598991 | 0.205200393403687 | 0.205105419627871 | false | false | false | true | false | |||||||||||||||
| 06713b2d-3d48-463d-9644-35fde234c8b5 | 2026-08-31 14:48 | 2026-08-31 14:48 | 2026-08-31 14:48 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.0200 | 3.0200 | 3.0600 | 293.0201 | 1167230.00 | 0.00 | 1167230.00 | 3865 | 20 | 42523 | 56091 | 0.758107361252251 | 0.205200393403687 | 0.205200393403687 | false | false | false | true | false | |||||||||||||||
| cd739cbd-5581-4cb2-944b-ada308e2a83b | 2026-08-31 11:13 | 2026-08-31 11:13 | 2026-08-31 11:13 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.0200 | 3.0200 | 3.0500 | 293.1400 | 368138.00 | 0.00 | 368138.00 | 1219 | 7 | 29597 | 56091 | 0.527660408978267 | 0.206078536740924 | 0.206078536740924 | false | false | false | true | false | |||||||||||||||
| 72f710e0-b23a-4ec8-9b9d-2a859595dda3 | 2026-08-31 11:13 | 2026-08-31 11:13 | 2026-08-31 11:13 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 3.0200 | 3.0200 | 3.0600 | 293.1400 | 351226.00 | 0.00 | 351226.00 | 1163 | 31 | 28378 | 56091 | 0.505927867215774 | 0.206078536740924 | 0.206078536740924 | false | false | false | true | false | |||||||||||||||
| 4b98c825-9baf-4fef-bdb9-27cc87bbd6f6 | 2026-08-31 10:41 | 2026-08-31 10:41 | 2026-08-31 10:41 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 2.9900 | 2.9900 | 3.0100 | 293.3950 | 114218.00 | 0.00 | 114218.00 | 382 | 9 | 25230 | 56091 | 0.449804781515751 | 0.206992698279699 | 0.206992698279699 | false | false | false | true | false | |||||||||||||||
| 3c51c019-a971-4a39-8447-db512515c1de | 2026-08-31 10:41 | 2026-08-31 10:41 | 2026-08-31 10:41 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 2.9900 | 2.9900 | 3.0200 | 293.3800 | 189566.00 | 0.00 | 189566.00 | 634 | 9 | 24525 | 56091 | 0.437235920201102 | 0.206883601691699 | 0.206883601691699 | false | false | false | true | false | |||||||||||||||
| 3acf2032-06af-458d-855c-1427a1568066 | 2026-08-31 10:41 | 2026-08-31 10:41 | 2026-08-31 10:41 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 2.9800 | 2.9800 | 3.0000 | 293.3950 | 117431.00 | 0.00 | 111750.00 | 394 | 5 | 25748 | 56091 | 0.459039774651905 | 0.206992698279699 | 0.206676385763165 | false | false | false | true | false | |||||||||||||||
| 10214f8c-c152-49c3-a991-1af8de4bc303 | 2026-08-27 14:29 | 2026-08-27 14:29 | 2026-08-27 14:29 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 2.3400 | 2.3100 | 2.3400 | 299.3950 | 119808.00 | 119808.00 | 0.00 | 512 | 28 | 7049 | 48176 | 0.146317668548655 | 0.217219533292337 | 0.217219533292337 | false | false | false | true | false | |||||||||||||||
| 1175621c-ae49-4fce-af3c-9b3e93c0d464 | 2026-08-27 14:28 | 2026-08-27 14:28 | 2026-08-27 14:28 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 2.3300 | 2.3000 | 2.3300 | 299.4200 | 219486.00 | 219486.00 | 0.00 | 942 | 34 | 6537 | 48176 | 0.135689970109598 | 0.217020844216836 | 0.217020844216836 | false | false | false | true | false | |||||||||||||||
| 9660d123-fcf7-46cd-a66c-2ac65bf90f77 | 2026-08-27 10:00 | 2026-08-27 10:00 | 2026-08-27 10:00 | IWM | IWM261016P00280000 | put | 280.0000 | 2026-10-16 | 2.5000 | 2.4800 | 2.5000 | 298.6600 | 571500.00 | 227750.00 | 0.00 | 2286 | 25 | 2344 | 48176 | 0.0486549319163069 | 0.218214042588383 | 0.218214042588383 | false | false | false | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T18:58:03.753197Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.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 |
| — |
| 79887436077.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 |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:20:18.853903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:34:32.417809Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:01:22.528333Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:01:22.528333Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:01:22.528333Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:01:22.528333Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:41:39.850499Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:41:39.850499Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T14:41:39.850499Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 79887436077.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:11:49.813441Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |