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_alerts566,287 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 | strike |
|---|
| 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 |
|---|
| f9479d56-8cb8-4c12-9d4d-d1557c45bd6e | 2026-09-29 10:44 | 2026-09-29 10:44 | 2026-09-29 10:44 | MAGS | MAGS261120P00070000 | put | 70.0000 | 2026-11-20 | 1.7500 | 1.6500 | 1.8000 | 71.4600 | 45497.00 | 45497.00 | 0.00 | 260 | 52 | 769 | 826 | 0.930992736077482 | 0.243140165356692 | 0.243140165356692 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 684331200.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T14:48:41.802751Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 15c372d3-658b-4f5e-bba4-f4bc716bc6a9 | 2026-09-29 09:32 | 2026-09-29 09:32 | 2026-09-29 09:32 | MAGS | MAGS270319C00080000 | call | 80.0000 | 2027-03-19 | 1.7900 | 1.5500 | 1.9000 | 71.5000 | 163712.00 | 158672.00 | 5040.00 | 914 | 12 | 1001 | 681 | 1.46989720998532 | 0.215768324402191 | 0.214577471003952 | false | false | ||||||||||||||||||
| 153f2f11-de66-4fb5-aa44-6ece528ec8f4 | 2026-09-28 13:33 | 2026-09-28 13:33 | 2026-09-28 13:33 | MAGS | MAGS261002C00074000 | call | 74.0000 | 2026-10-02 | 0.1500 | 0.0500 | 0.2000 | 71.0000 | 18152.00 | 18137.00 | 15.00 | 1211 | 55 | 1220 | 151 | 8.0794701986755 | 0.261877112650145 | 0.261877112650145 | false | false | ||||||||||||||||||
| 37668eb5-7532-45c1-914d-38924dd3071b | 2026-09-28 10:53 | 2026-09-28 10:52 | 2026-09-28 10:52 | MAGS | MAGS270319C00085000 | call | 85.0000 | 2027-03-19 | 0.9400 | 0.6500 | 1.1500 | 71.5601 | 20375.00 | 17525.00 | 2850.00 | 217 | 11 | 961 | 1162 | 0.827022375215146 | 0.219115950716795 | 0.216736280634587 | false | false | ||||||||||||||||||
| 42aeee54-95db-426a-8dbb-e93276a87abd | 2026-09-28 10:23 | 2026-09-28 10:23 | 2026-09-28 10:23 | MAGS | MAGS261030C00073000 | call | 73.0000 | 2026-10-30 | 1.4300 | 1.2000 | 1.6000 | 71.0000 | 75925.00 | 75925.00 | 0.00 | 530 | 11 | 530 | 552 | 0.960144927536232 | 0.218670272327618 | 0.218670272327618 | false | false | ||||||||||||||||||
| 40772628-915a-4b25-bd37-a8dae5e66860 | 2026-09-23 10:29 | 2026-09-23 10:29 | 2026-09-23 10:29 | MAGS | MAGS261120C00074000 | call | 74.0000 | 2026-11-20 | 1.9500 | 1.9000 | 2.0000 | 72.0550 | 10737.00 | 792.00 | 5655.00 | 55 | 6 | 216 | 111 | 1.94594594594595 | 0.22889383970215 | 0.22889383970215 | false | false | ||||||||||||||||||
| 92e096c8-8bfd-4786-b035-d4064db422b8 | 2026-09-21 11:56 | 2026-09-21 11:56 | 2026-09-21 11:56 | MAGS | MAGS270115P00067000 | put | 67.0000 | 2027-01-15 | 1.8300 | 1.8000 | 1.9000 | 72.1800 | 26200.00 | 0.00 | 3495.00 | 143 | 38 | 308 | 82 | 3.75609756097561 | 0.271104792075034 | 0.26728678572092 | false | false | ||||||||||||||||||
| fac7981f-1975-40ae-b5c3-3e30ee887bed | 2026-09-21 11:56 | 2026-09-21 11:56 | 2026-09-21 11:56 | MAGS | MAGS270115P00067000 | put | 67.0000 | 2027-01-15 | 1.7200 | 1.5000 | 2.1500 | 72.1800 | 18450.00 | 350.00 | 9700.00 | 107 | 31 | 107 | 82 | 1.30487804878049 | 0.263450418099201 | 0.259594667108821 | false | false | ||||||||||||||||||
| 6b60267c-bd2c-40ff-86d8-694312f5d226 | 2026-09-18 13:05 | 2026-09-18 13:05 | 2026-09-18 13:05 | MAGS | MAGS261016C00072000 | call | 72.0000 | 2026-10-16 | 0.8500 | 0.8500 | 0.9500 | 70.4250 | 85098.00 | 0.00 | 85098.00 | 1000 | 42 | 1010 | 6639 | 0.152131345082091 | 0.184348506028008 | 0.181615046882983 | false | false | ||||||||||||||||||
| 165218b5-1a58-46cf-9046-a80fa44a8b2d | 2026-09-17 09:41 | 2026-09-17 09:40 | 2026-09-17 09:40 | MAGS | MAGS261009C00070000 | call | 70.0000 | 2026-10-09 | 1.6300 | 1.6000 | 1.8500 | 70.3180 | 39132.00 | 0.00 | 39132.00 | 240 | 5 | 540 | 585 | 0.923076923076923 | 0.201679039575544 | 0.201679039575544 | false | false | ||||||||||||||||||
| 6649761a-e76c-43ba-a4c6-8e955f413e7b | 2026-09-17 09:36 | 2026-09-17 09:36 | 2026-09-17 09:36 | MAGS | MAGS261009C00070000 | call | 70.0000 | 2026-10-09 | 1.6800 | 1.6500 | 1.8500 | 70.3800 | 33520.00 | 0.00 | 33520.00 | 200 | 9 | 200 | 585 | 0.341880341880342 | 0.205326285383081 | 0.205326285383081 | false | false | ||||||||||||||||||
| 709fe7cc-c62f-4c5f-a272-4015772f7ea2 | 2026-09-15 12:08 | 2026-09-15 12:08 | 2026-09-15 12:08 | MAGS | MAGS261016P00062000 | put | 62.0000 | 2026-10-16 | 0.2500 | 0.2000 | 0.2500 | 69.7150 | 10160.00 | 10160.00 | 0.00 | 407 | 37 | 412 | 1014 | 0.406311637080868 | 0.309573458687089 | 0.309573458687089 | false | false | ||||||||||||||||||
| 937acc26-cfc3-4d80-891f-5826235477d9 | 2026-09-11 09:39 | 2026-09-11 09:39 | 2026-09-11 09:39 | MAGS | MAGS270115C00073000 | call | 73.0000 | 2027-01-15 | 2.6900 | 2.2000 | 2.9000 | 70.2262 | 10760.00 | 10760.00 | 0.00 | 40 | 13 | 40 | 75 | 0.533333333333333 | 0.211241577452233 | 0.211241577452233 | false | false | ||||||||||||||||||
| d7faa4c0-1553-4959-a759-95e64a24616c | 2026-09-03 11:39 | 2026-09-03 11:39 | 2026-09-03 11:39 | MAGS | MAGS261218P00065000 | put | 65.0000 | 2026-12-18 | 1.3900 | 1.3500 | 1.4000 | 70.7400 | 13941.00 | 13941.00 | 0.00 | 100 | 10 | 471 | 1484 | 0.317385444743935 | 0.262012266006208 | 0.261138793291111 | false | false | ||||||||||||||||||
| 73475a51-55dc-4a00-8dc4-a53918575f2c | 2026-09-03 09:59 | 2026-09-03 09:59 | 2026-09-03 09:59 | MAGS | MAGS261218P00065000 | put | 65.0000 | 2026-12-18 | 1.4900 | 1.4000 | 1.5000 | 70.2750 | 14905.00 | 14905.00 | 0.00 | 100 | 6 | 352 | 1484 | 0.237196765498652 | 0.261305828731538 | 0.260455201396887 | false | false | ||||||||||||||||||
| 6fe350c8-53a8-497d-855a-505d619198af | 2026-08-28 12:00 | 2026-08-28 12:00 | 2026-08-28 12:00 | MAGS | MAGS270115C00069000 | call | 69.0000 | 2027-01-15 | 4.4400 | 3.6000 | 4.9000 | 69.0000 | 22220.00 | 22220.00 | 0.00 | 50 | 6 | 50 | 186 | 0.268817204301075 | 0.225460326288704 | 0.225460326288704 | false | false | ||||||||||||||||||
| d805b739-d5e9-4e1a-91e7-951778e0baf2 | 2026-08-28 11:16 | 2026-08-28 11:16 | 2026-08-28 11:16 | MAGS | MAGS260918C00070000 | call | 70.0000 | 2026-09-18 | 1.1200 | 0.9500 | 1.2500 | 69.6300 | 10046.00 | 10046.00 | 0.00 | 90 | 5 | 305 | 7840 | 0.0389030612244898 | 0.183711270604755 | 0.183711270604755 | false | false | ||||||||||||||||||
| 88a65111-6463-4bdb-914d-8197cf71df66 | 2026-08-28 11:05 | 2026-08-28 11:05 | 2026-08-28 11:05 | MAGS | MAGS260918C00070500 | call | 70.5000 | 2026-09-18 | 1.0500 | 0.1500 | 1.0500 | 69.7864 | 209980.00 | 209980.00 | 0.00 | 2000 | 67 | 2000 | 5 | 400 | 0.195581756432552 | 0.195581756432552 | true | false | ||||||||||||||||||
| 50a9e895-eeab-4906-bff7-8b008c63dbd4 | 2026-08-21 11:58 | 2026-08-21 11:57 | 2026-08-21 11:57 | MAGS | MAGS260918C00074000 | call | 74.0000 | 2026-09-18 | 0.0500 | 0.0500 | 0.2000 | 67.5050 | 15602.00 | 0.00 | 15602.00 | 3120 | 10 | 3668 | 8821 | 0.415825870082757 | 0.190250025598974 | 0.190250025598974 | false | false | ||||||||||||||||||
| 78051645-9d44-468c-84f5-867c1c278963 | 2026-08-20 15:47 | 2026-08-20 15:47 | 2026-08-20 15:47 | MAGS | MAGS261016P00065000 | put | 65.0000 | 2026-10-16 | 1.5800 | 1.4000 | 1.6000 | 66.9150 | 47451.00 | 47451.00 | 0.00 | 300 | 25 | 306 | 0 | 0 | 0.249868772727316 | 0.247810920795743 | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:33:34.031299Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:41:35.586557Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:55:24.203019Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:26:39.560401Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:31:12.586989Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:00:04.115943Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:00:04.115943Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:09:50.881001Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:47:44.789077Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:46:58.036194Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T14:10:05.195539Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.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 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:11:58.135920Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T16:17:50.496167Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 684331200.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:59:19.634890Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |