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 | expiry |
|---|
| 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 |
|---|
| c395a84e-7bf0-47ca-9603-ff4d1ffc200f | 2026-09-25 13:33 | 2026-09-25 13:33 | 2026-09-25 13:33 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 4.7000 | 4.6000 | 4.7500 | 393.0200 | 21620.00 | 940.00 | 15980.00 | 46 | 6 | 2531 | 15597 | 0.162274796435212 | 0.193550125119398 | 0.193550125119398 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ETF | — | 144613484818.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T17:33:28.969909Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 6ef53f66-6aee-4c1e-b20f-725205af4b4a | 2026-09-25 12:00 | 2026-09-25 12:00 | 2026-09-25 12:00 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 4.8000 | 4.7000 | 4.8000 | 393.0000 | 24000.00 | 24000.00 | 0.00 | 50 | 8 | 2405 | 15597 | 0.154196319805091 | 0.191532448573447 | 0.191210540054864 | true | false | false | true | ||||||||||||||||
| 24c02743-dac7-4d1c-b194-b3b0c3f05efc | 2026-09-24 12:47 | 2026-09-24 12:46 | 2026-09-24 12:46 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 4.8000 | 4.8000 | 4.8500 | 391.9600 | 33600.00 | 0.00 | 10080.00 | 70 | 6 | 1740 | 14803 | 0.117543741133554 | 0.202318356544323 | 0.202318356544323 | true | false | false | true | ||||||||||||||||
| 4fbe1621-98bd-414a-9584-295e3443bed0 | 2026-09-23 13:46 | 2026-09-23 13:45 | 2026-09-23 13:45 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 5.5000 | 5.4500 | 5.5000 | 393.0000 | 27500.00 | 27500.00 | 0.00 | 50 | 6 | 2372 | 14216 | 0.166854248733821 | 0.203904970089485 | 0.203904970089485 | false | false | false | true | ||||||||||||||||
| c2670994-eef4-472a-bef1-68e6371824a7 | 2026-09-23 13:44 | 2026-09-23 13:44 | 2026-09-23 13:44 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 5.5000 | 5.4000 | 5.5500 | 393.0000 | 55000.00 | 46200.00 | 0.00 | 100 | 7 | 2321 | 14216 | 0.163266741699494 | 0.20296603753065 | 0.203174846100126 | false | false | false | true | ||||||||||||||||
| 9cfd1293-44d7-4a6b-b954-e82f6fbbbe9f | 2026-09-22 14:05 | 2026-09-22 14:05 | 2026-09-22 14:05 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 8.6500 | 8.4500 | 8.7000 | 399.1599 | 19895.00 | 2595.00 | 0.00 | 23 | 5 | 2427 | 15888 | 0.152756797583082 | 0.210209042951447 | 0.209454683939168 | true | false | false | true | ||||||||||||||||
| 401917c6-719a-4912-a5f9-d0a4178b4176 | 2026-09-22 13:07 | 2026-09-22 13:07 | 2026-09-22 13:07 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 7.8500 | 7.8500 | 8.0000 | 397.9300 | 124082.00 | 0.00 | 124082.00 | 158 | 12 | 2212 | 15888 | 0.139224572004028 | 0.204997863785334 | 0.205489299697045 | false | false | false | true | ||||||||||||||||
| fbfbbcca-6747-4c4f-b9cd-0177b2fca392 | 2026-09-22 10:02 | 2026-09-22 10:02 | 2026-09-22 10:02 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 7.6000 | 7.6000 | 7.7000 | 397.2400 | 46387.00 | 0.00 | 46387.00 | 61 | 10 | 253 | 15888 | 0.0159239677744209 | 0.207072080511648 | 0.207072080511648 | true | false | false | true | ||||||||||||||||
| c4e8ec52-c0c5-4c2f-b48c-4f43507c0edd | 2026-09-21 12:53 | 2026-09-21 12:52 | 2026-09-21 12:52 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 8.4500 | 8.4500 | 8.5000 | 398.0000 | 10985.00 | 0.00 | 10985.00 | 13 | 7 | 803 | 12364 | 0.0649466192170818 | 0.210597385384308 | 0.210717482463073 | true | false | false | true | ||||||||||||||||
| 0a134828-f022-4447-81f0-64be62a92220 | 2026-09-21 10:17 | 2026-09-21 10:17 | 2026-09-21 10:17 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 8.1800 | 8.1000 | 8.3000 | 397.6444 | 12267.00 | 0.00 | 12267.00 | 15 | 5 | 519 | 12364 | 0.0419767065674539 | 0.211652838913218 | 0.211652838913218 | false | false | false | true | ||||||||||||||||
| f5e7c7fc-9a08-4c0c-abb0-aa687f4d694d | 2026-09-17 10:29 | 2026-09-17 10:29 | 2026-09-17 10:29 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 11.5000 | 11.5000 | 11.6000 | 400.3400 | 129950.00 | 0.00 | 129950.00 | 113 | 8 | 609 | 12202 | 0.0499098508441239 | 0.237815435337928 | 0.237815435337928 | true | false | false | true | ||||||||||||||||
| 8f6e1f78-1d80-4888-869b-a3793620cb89 | 2026-09-16 13:57 | 2026-09-16 13:57 | 2026-09-16 13:57 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 11.7000 | 11.6000 | 11.7000 | 398.0000 | 66690.00 | 66690.00 | 0.00 | 57 | 7 | 889 | 12909 | 0.0688666821597335 | 0.253795375738863 | 0.253795375738863 | true | false | false | true | ||||||||||||||||
| 06da9fe1-ee9e-484e-984e-2b5803bb25be | 2026-09-16 10:31 | 2026-09-16 10:30 | 2026-09-16 10:30 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 10.7500 | 10.7000 | 10.7500 | 397.0000 | 64500.00 | 64500.00 | 0.00 | 60 | 7 | 403 | 12909 | 0.0312185297079557 | 0.248443764951699 | 0.248335290224598 | false | false | false | true | ||||||||||||||||
| d9644ada-c5ad-40c8-9c9b-12df68c0eb6e | 2026-09-14 16:12 | 2026-09-14 16:12 | 2026-09-14 16:12 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 9.0000 | 8.8000 | 9.0500 | 393.0000 | 384295.00 | 895.00 | 383400.00 | 427 | 5 | 3444 | 11131 | 0.309406162968287 | 0.245278713839109 | 0.246367988908149 | false | false | false | true | ||||||||||||||||
| 46501e9f-b07a-440f-b038-9db929b17f9f | 2026-09-11 09:34 | 2026-09-11 09:34 | 2026-09-11 09:34 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 14.4000 | 14.3500 | 14.4500 | 402.0000 | 244825.00 | 244825.00 | 0.00 | 170 | 6 | 333 | 11214 | 0.0296950240770466 | 0.248301465450947 | 0.249000952603221 | false | false | false | true | ||||||||||||||||
| 9246730a-36a7-4598-a5e7-c40aea048da3 | 2026-09-09 09:36 | 2026-09-09 09:36 | 2026-09-09 09:36 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 17.1500 | 17.1000 | 17.2500 | 405.9200 | 149205.00 | 32585.00 | 97755.00 | 87 | 10 | 225 | 11438 | 0.019671271201259 | 0.255690079065265 | 0.255690079065265 | false | false | false | true | ||||||||||||||||
| f96f3f82-f1ff-4f80-a84b-4f5592d55e7f | 2026-09-08 14:32 | 2026-09-08 14:32 | 2026-09-08 14:32 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 14.4500 | 14.4000 | 14.4500 | 401.7800 | 79475.00 | 79475.00 | 0.00 | 55 | 11 | 424 | 11236 | 0.0377358490566038 | 0.246225798231496 | 0.246225798231496 | false | false | false | true | ||||||||||||||||
| d38a48d3-64df-4748-b9ce-4d1b917707f2 | 2026-09-01 12:25 | 2026-09-01 12:25 | 2026-09-01 12:25 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 13.5500 | 13.5000 | 13.7000 | 399.6200 | 1051495.00 | 1360.00 | 1050135.00 | 776 | 39 | 1468 | 11607 | 0.126475402774188 | 0.227970263926212 | 0.228642444559326 | false | false | false | true | ||||||||||||||||
| 8663ab02-0810-444d-b98d-07cd5fc5367a | 2026-09-01 09:35 | 2026-09-01 09:35 | 2026-09-01 09:35 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 13.2500 | 13.2000 | 13.6000 | 399.0001 | 68910.00 | 3985.00 | 63600.00 | 52 | 12 | 90 | 11607 | 0.00775394158697338 | 0.229167449876295 | 0.230064153636322 | true | false | false | true | ||||||||||||||||
| af011587-9498-4e0f-b30b-ac7dcdd5f4c5 | 2026-08-31 12:59 | 2026-08-31 12:59 | 2026-08-31 12:59 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 17.5600 | 17.5500 | 17.8000 | 406.5900 | 219517.00 | 0.00 | 219517.00 | 125 | 5 | 384 | 11853 | 0.032396861554037 | 0.22588538596966 | 0.22570347821277 | false | false | false | true | ||||||||||||||||
| 0514e0ed-84c8-428e-a62b-cf0d4972eba2 | 2026-08-28 10:32 | 2026-08-28 10:32 | 2026-08-28 10:32 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 26.5000 | 26.3500 | 26.5000 | 418.1300 | 429300.00 | 429300.00 | 0.00 | 162 | 5 | 287 | 12781 | 0.0224552069478132 | 0.238078120979787 | 0.238078120979787 | false | false | false | true | ||||||||||||||||
| 198ab19d-f586-4d54-9b8f-3843b7d04867 | 2026-08-19 10:25 | 2026-08-19 10:25 | 2026-08-19 10:25 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 23.2500 | 22.9500 | 23.4000 | 411.1600 | 104625.00 | 90675.00 | 13950.00 | 45 | 7 | 170 | 13977 | 0.0121628389497031 | 0.241516596471527 | 0.241516596471527 | false | false | false | true | ||||||||||||||||
| c55c5717-c8a6-4cdf-bdea-f5426b8bc19b | 2026-08-18 10:37 | 2026-08-18 10:37 | 2026-08-18 10:37 | GLD | GLD261016C00400000 | call | 400.0000 | 2026-10-16 | 17.3000 | 17.2500 | 17.4500 | 402.4200 | 198950.00 | 188570.00 | 10380.00 | 115 | 6 | 149 | 13832 | 0.0107721226142279 | 0.229735617191346 | 0.229690696156888 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 144613484818.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:00:57.770407Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 145541313705.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:48:32.631672Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146956242979.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:48:41.957434Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146956242979.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:45:14.864344Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146698617465.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:10:48.215993Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 146698617465.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:14:46.677665Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146698617465.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:04:08.107942Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147753657378.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:56:43.151057Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 147753657378.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:18:27.541285Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 146364491326.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:33:58.839655Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 145045725759.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:03:30.942669Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 145045725759.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:37:33.609039Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:46:31.810255Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 147692376545.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T18:43:21.019108Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T16:27:11.873526Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:44:23.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:08:52.274087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:38:22.875878Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| 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 |
| ETF |
| — |
| 143675098310.00 |
| — |
| — |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |