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_alerts326,449 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 |
|---|
| f15dbd17-f3db-478d-a171-1f57c7661531 | 2026-08-20 10:35 | 2026-08-20 10:34 | 2026-08-20 10:34 | FLEX | FLEX260918C00125000 | call | 125.0000 | 2026-09-18 | 3.5000 | 3.4000 | 3.7000 | 111.7900 | 64050.00 | 350.00 | 63700.00 | 183 | 31 | 226 | 458 | 0.493449781659389 | 0.633735079676499 | 0.633735079676499 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 40013730577.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 72eeae0b-d8df-422b-9d55-4fdec13b568a | 2026-08-20 10:34 | 2026-08-20 10:34 | 2026-08-20 10:34 | FLEX | FLEX261016C00120000 | call | 120.0000 | 2026-10-16 | 8.2000 | 8.0000 | 8.2000 | 112.1850 | 10660.00 | 10660.00 | 0.00 | 13 | 9 | 43 | 86 | 0.5 | 0.626648781869538 | 0.626648781869538 | false | false | false | true | false | |||||||||||||||
| 89b24c89-0474-4e46-9e3e-c84c65b4b364 | 2026-08-19 14:38 | 2026-08-19 14:37 | 2026-08-19 14:37 | FLEX | FLEX261016C00125000 | call | 125.0000 | 2026-10-16 | 7.2000 | 7.2000 | 7.7000 | 113.6600 | 48960.00 | 0.00 | 48960.00 | 68 | 20 | 76 | 310 | 0.245161290322581 | 0.622649249593029 | 0.622649249593029 | false | false | false | true | ||||||||||||||||
| f82b6fc3-9a98-4a3a-b271-624e3f75752e | 2026-08-19 14:07 | 2026-08-19 14:07 | 2026-08-19 14:07 | FLEX | FLEX280121C00100000 | call | 100.0000 | 2028-01-21 | 43.9000 | 43.9000 | 47.6000 | 114.2500 | 153662.00 | 0.00 | 153662.00 | 35 | 11 | 115 | 412 | 0.279126213592233 | 0.683673539851702 | 0.683673539851702 | false | false | false | true | ||||||||||||||||
| 66507f46-2c1f-4d6d-b909-415a48789ec1 | 2026-08-19 13:04 | 2026-08-19 13:04 | 2026-08-19 13:04 | FLEX | FLEX260918C00120000 | call | 120.0000 | 2026-09-18 | 6.8000 | 6.8000 | 7.0000 | 115.3400 | 10200.00 | 0.00 | 10200.00 | 15 | 7 | 94 | 217 | 0.433179723502304 | 0.654280823756382 | 0.654280823756382 | false | false | false | true | ||||||||||||||||
| 034a05b9-1d03-45a6-89f6-5cac739630a8 | 2026-08-19 13:00 | 2026-08-19 12:59 | 2026-08-19 12:59 | FLEX | FLEX261016C00130000 | call | 130.0000 | 2026-10-16 | 6.7000 | 6.7000 | 7.2000 | 115.7600 | 113901.00 | 0.00 | 113901.00 | 170 | 40 | 176 | 134 | 1.3134328358209 | 0.632280179210895 | 0.632280179210895 | false | false | false | true | ||||||||||||||||
| a4387692-274c-4398-884f-3464c0fe75bb | 2026-08-19 12:50 | 2026-08-19 12:50 | 2026-08-19 12:50 | FLEX | FLEX261016C00160000 | call | 160.0000 | 2026-10-16 | 1.7000 | 1.4500 | 1.7000 | 116.2300 | 13940.00 | 13940.00 | 0.00 | 82 | 5 | 149 | 507 | 0.293885601577909 | 0.62760643662062 | 0.62760643662062 | false | false | false | true | ||||||||||||||||
| 4868223b-c63c-47d8-a05a-9ad8efc32328 | 2026-08-19 12:00 | 2026-08-19 12:00 | 2026-08-19 12:00 | FLEX | FLEX260918C00125000 | call | 125.0000 | 2026-09-18 | 5.1000 | 4.9000 | 5.4000 | 115.3700 | 12240.00 | 0.00 | 12240.00 | 24 | 6 | 61 | 548 | 0.111313868613139 | 0.655198844527269 | 0.655198844527269 | false | false | false | true | ||||||||||||||||
| 9164d811-4cad-4539-a1e5-ba1a2d536376 | 2026-08-19 10:14 | 2026-08-19 10:14 | 2026-08-19 10:14 | FLEX | FLEX280121C00100000 | call | 100.0000 | 2028-01-21 | 43.1300 | 43.1000 | 47.6000 | 113.1400 | 224270.00 | 0.00 | 224270.00 | 52 | 6 | 56 | 412 | 0.135922330097087 | 0.686386369282319 | 0.686386369282319 | false | false | false | true | ||||||||||||||||
| beb100c6-86be-4fd7-8362-05c41cf554bf | 2026-08-19 09:34 | 2026-08-19 09:33 | 2026-08-19 09:33 | FLEX | FLEX280121C00120000 | call | 120.0000 | 2028-01-21 | 41.9900 | 39.3000 | 42.0000 | 118.7250 | 281310.00 | 20910.00 | 0.00 | 67 | 5 | 67 | 68 | 0.985294117647059 | 0.731176698519066 | 0.727184832453567 | false | false | false | true | ||||||||||||||||
| 7db01176-a39a-4699-80aa-712b9796453a | 2026-08-18 15:45 | 2026-08-18 15:45 | 2026-08-18 15:45 | FLEX | FLEX270219P00110000 | put | 110.0000 | 2027-02-19 | 16.3000 | 15.7000 | 17.1000 | 120.9300 | 45640.00 | 0.00 | 45640.00 | 28 | 8 | 30 | 36 | 0.833333333333333 | 0.692871835468454 | 0.692871835468454 | false | false | false | true | ||||||||||||||||
| ec318ce5-7395-4ae8-9f97-719acc56c590 | 2026-08-18 15:12 | 2026-08-18 15:12 | 2026-08-18 15:12 | FLEX | FLEX261120C00180000 | call | 180.0000 | 2026-11-20 | 3.3000 | 2.9000 | 3.6000 | 119.5300 | 22770.00 | 22440.00 | 330.00 | 69 | 23 | 70 | 120 | 0.583333333333333 | 0.696742880388368 | 0.69641045001477 | false | false | false | true | ||||||||||||||||
| dfe25aee-a0ed-47bd-af8a-ee4a9b50b8bd | 2026-08-18 14:10 | 2026-08-18 14:09 | 2026-08-18 14:09 | FLEX | FLEX261120P00130000 | put | 130.0000 | 2026-11-20 | 22.4000 | 22.2000 | 22.6000 | 119.3350 | 17920.00 | 8960.00 | 0.00 | 8 | 5 | 9 | 39 | 0.230769230769231 | 0.693442489989884 | 0.693442489989884 | false | false | false | true | ||||||||||||||||
| 627420c8-f796-42cc-91fe-9f2bf5f4108f | 2026-08-18 11:04 | 2026-08-18 11:04 | 2026-08-18 11:04 | FLEX | FLEX260918C00125000 | call | 125.0000 | 2026-09-18 | 7.2000 | 7.2000 | 7.3000 | 120.7700 | 72000.00 | 0.00 | 72000.00 | 100 | 16 | 147 | 527 | 0.278937381404175 | 0.630743293578718 | 0.630743293578718 | false | false | false | true | ||||||||||||||||
| 3ad8cc5a-b823-4b4b-8915-ebe5e7c2a9dd | 2026-08-18 10:57 | 2026-08-18 10:57 | 2026-08-18 10:57 | FLEX | FLEX260918C00125000 | call | 125.0000 | 2026-09-18 | 7.1000 | 7.1000 | 7.3000 | 120.4150 | 14910.00 | 0.00 | 14910.00 | 21 | 5 | 24 | 527 | 0.0455407969639469 | 0.635433002398252 | 0.635433002398252 | false | false | false | true | ||||||||||||||||
| af9ce1b3-1616-4abe-a48f-98e879cbf12a | 2026-08-18 10:53 | 2026-08-18 10:53 | 2026-08-18 10:53 | FLEX | FLEX261016C00145000 | call | 145.0000 | 2026-10-16 | 4.9000 | 4.5000 | 4.9000 | 120.8100 | 180803.00 | 180803.00 | 0.00 | 369 | 44 | 369 | 500 | 0.738 | 0.637005104650213 | 0.637005104650213 | false | false | false | true | ||||||||||||||||
| a2bb89e2-9711-48fd-be58-e53377ac8bb3 | 2026-08-18 09:38 | 2026-08-18 09:38 | 2026-08-18 09:38 | FLEX | FLEX261120C00130000 | call | 130.0000 | 2026-11-20 | 15.5000 | 14.1000 | 15.5000 | 123.0000 | 114700.00 | 114700.00 | 0.00 | 74 | 24 | 121 | 118 | 1.02542372881356 | 0.714893141524577 | 0.714893141524577 | false | false | false | true | ||||||||||||||||
| 71583a47-7c6d-457e-877e-146b431196f7 | 2026-08-17 10:51 | 2026-08-17 10:51 | 2026-08-17 10:51 | FLEX | FLEX270115C00150000 | call | 150.0000 | 2027-01-15 | 16.7000 | 15.9000 | 17.1000 | 130.3300 | 153640.00 | 153640.00 | 0.00 | 92 | 1 | 156 | 1602 | 0.0973782771535581 | 0.689574450910651 | 0.689574450910651 | false | true | false | true | ||||||||||||||||
| 512fafcf-ffb7-47da-919d-5e7fb8193a96 | 2026-08-17 10:18 | 2026-08-17 10:18 | 2026-08-17 10:18 | FLEX | FLEX260918P00105000 | put | 105.0000 | 2026-09-18 | 1.3000 | 1.1500 | 1.4000 | 128.9600 | 25225.00 | 520.00 | 24705.00 | 194 | 38 | 1066 | 1141 | 0.934268185801928 | 0.612471679895962 | 0.612471679895962 | false | false | false | true | ||||||||||||||||
| e741dfd8-b816-4d4c-8948-296f16240e0a | 2026-08-17 10:18 | 2026-08-17 10:18 | 2026-08-17 10:18 | FLEX | FLEX260918P00105000 | put | 105.0000 | 2026-09-18 | 1.4100 | 1.4000 | 1.8500 | 128.7300 | 18781.00 | 4640.00 | 14141.00 | 133 | 33 | 408 | 1141 | 0.357581069237511 | 0.622925262751684 | 0.629757737270716 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:16:43.855599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:16:43.855599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:52:36.966336Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:07:57.422777Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:24:28.155578Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| 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 |
| 40013730577.00 |
| 2026-11-04 |
| 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 |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:23:23.944279Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 40013730577.00 |
| 2026-11-04 |
| 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 |