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 | 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 |
|---|
| 072aa18a-3e21-4d2a-a24e-0a78ac7b3bb3 | 2026-09-18 11:06 | 2026-09-18 11:06 | 2026-09-18 11:06 | AMZN | AMZN260918C00250000 | call | 250.0000 | 2026-09-18 | 5.1900 | 5.0500 | 5.3000 | 255.1300 | 259710.00 | 0.00 | 259710.00 | 500 | 6 | 10358 | 18720 | 0.553311965811966 | 0.484555753279848 | 0.64639293811288 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 2736595616352.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| f52beedf-3796-4ce2-a1bb-a2b62414f296 | 2026-09-18 11:06 | 2026-09-18 11:05 | 2026-09-18 11:05 | AMZN | AMZN260918C00250000 | call | 250.0000 | 2026-09-18 | 5.2500 | 5.2500 | 5.4000 | 255.3300 | 501900.00 | 0.00 | 501900.00 | 956 | 8 | 9152 | 18720 | 0.488888888888889 | 0.537341012449668 | 0.370230684128604 | false | false | false | true | ||||||||||||||||
| f3692a6a-9dc2-4617-be4a-39fd1e348942 | 2026-09-18 11:05 | 2026-09-18 11:05 | 2026-09-18 11:05 | AMZN | AMZN260918C00250000 | call | 250.0000 | 2026-09-18 | 5.1700 | 5.1500 | 5.4000 | 255.1801 | 488390.00 | 0.00 | 488390.00 | 945 | 16 | 8180 | 18720 | 0.436965811965812 | 0.654313867395876 | 0.697627677106133 | false | false | false | true | ||||||||||||||||
| 21c1e48f-447c-4676-9bae-aee46866a561 | 2026-09-18 11:05 | 2026-09-18 11:05 | 2026-09-18 11:05 | AMZN | AMZN260918C00250000 | call | 250.0000 | 2026-09-18 | 5.1500 | 5.1500 | 5.4000 | 255.2800 | 114330.00 | 0.00 | 114330.00 | 222 | 6 | 7235 | 18720 | 0.386485042735043 | 0.60301228679714 | 0.60301228679714 | false | false | false | true | ||||||||||||||||
| 3a986b44-29a6-455e-8c26-66fbf886523d | 2026-09-18 10:35 | 2026-09-18 10:35 | 2026-09-18 10:35 | AMZN | AMZN260918C00250000 | call | 250.0000 | 2026-09-18 | 2.8500 | 2.6900 | 2.8500 | 252.5600 | 142500.00 | 142500.00 | 0.00 | 500 | 6 | 4564 | 18720 | 0.243803418803419 | 0.455062946053576 | 0.455062946053576 | false | false | false | true | ||||||||||||||||
| c53adfb9-f542-4f5e-8e1c-867c675fda06 | 2026-09-18 10:12 | 2026-09-18 10:12 | 2026-09-18 10:12 | AMZN | AMZN260918C00250000 | call | 250.0000 | 2026-09-18 | 2.8500 | 2.7700 | 2.8400 | 252.5650 | 142499.00 | 142499.00 | 0.00 | 500 | 6 | 2873 | 18720 | 0.153472222222222 | 0.436979464977995 | 0.436979464977995 | false | false | false | true | ||||||||||||||||
| 01ec9a23-88c1-43d8-8320-2adc2e4b28f4 | 2026-09-18 09:56 | 2026-09-18 09:56 | 2026-09-18 09:56 | AMZN | AMZN260918C00250000 | call | 250.0000 | 2026-09-18 | 3.3900 | 3.2500 | 3.4000 | 253.1600 | 199815.00 | 199815.00 | 0.00 | 589 | 10 | 1984 | 18720 | 0.105982905982906 | 0.488274168601162 | 0.459219038154879 | true | false | false | true | ||||||||||||||||
| b68d3217-8f63-42a6-9ad6-460a27ebec2f | 2026-09-17 13:21 | 2026-09-17 13:21 | 2026-09-17 13:21 | AMZN | AMZN260918C00250000 | call | 250.0000 | 2026-09-18 | 2.4000 | 2.4000 | 2.4800 | 251.0500 | 129120.00 | 0.00 | 129120.00 | 538 | 34 | 19530 | 22417 | 0.871213810947049 | 0.341422807000953 | 0.346145796073067 | false | false | false | true | ||||||||||||||||
| 16c83981-3183-4d58-980a-a30299988c1e | 2026-09-17 12:10 | 2026-09-17 12:10 | 2026-09-17 12:10 | AMZN | AMZN260918C00250000 | call | 250.0000 | 2026-09-18 | 2.9900 | 2.9000 | 3.0000 | 251.8200 | 159084.00 | 133370.00 | 25714.00 | 532 | 43 | 17723 | 22417 | 0.790605344158451 | 0.371866025306387 | 0.367865648549125 | true | false | false | true | ||||||||||||||||
| ffc6b498-713e-4fa9-96e9-6b155b927bb8 | 2026-09-17 09:31 | 2026-09-17 09:31 | 2026-09-17 09:31 | AMZN | AMZN260918C00250000 | call | 250.0000 | 2026-09-18 | 2.3000 | 2.3000 | 2.4500 | 250.3400 | 114311.00 | 0.00 | 114311.00 | 497 | 21 | 2209 | 22417 | 0.0985412856314404 | 0.395978791760705 | 0.404199169847472 | true | false | false | true | ||||||||||||||||
| ed824394-e413-4b0c-bbad-d4d9bf04e49c | 2026-09-17 09:31 | 2026-09-17 09:31 | 2026-09-17 09:31 | AMZN | AMZN260918C00250000 | call | 250.0000 | 2026-09-18 | 3.0800 | 2.9400 | 3.2500 | 251.6300 | 154798.00 | 0.00 | 154798.00 | 503 | 10 | 1333 | 22417 | 0.0594637997947986 | 0.380157999882258 | 0.412659575251371 | true | false | false | true | ||||||||||||||||
| 48f9a1cf-374b-461e-8044-36f889dd70e6 | 2026-09-16 13:46 | 2026-09-16 13:46 | 2026-09-16 13:46 | AMZN | AMZN260918C00250000 | call | 250.0000 | 2026-09-18 | 1.6600 | 1.6600 | 1.6900 | 247.0000 | 101260.00 | 0.00 | 101260.00 | 610 | 37 | 10623 | 17269 | 0.615148532051653 | 0.375455873152368 | 0.375455873152368 | false | false | false | true | ||||||||||||||||
| 63a0fc7f-e07d-4076-8686-c7a01720cf94 | 2026-09-15 10:53 | 2026-09-15 10:53 | 2026-09-15 10:53 | AMZN | AMZN260918C00250000 | call | 250.0000 | 2026-09-18 | 2.6500 | 2.6500 | 2.6900 | 248.0000 | 106001.00 | 0.00 | 106001.00 | 400 | 7 | 3579 | 16068 | 0.222740851381628 | 0.366061978149615 | 0.367187304304129 | false | false | false | true | ||||||||||||||||
| 93ff815a-9182-4ea3-8ba8-aa486b01367d | 2026-09-14 09:57 | 2026-09-14 09:56 | 2026-09-14 09:56 | AMZN | AMZN260918C00250000 | call | 250.0000 | 2026-09-18 | 5.6500 | 5.4500 | 5.7500 | 253.2300 | 113055.00 | 73450.00 | 39605.00 | 200 | 6 | 3243 | 17109 | 0.189549359985972 | 0.356824764847785 | 0.356824764847785 | false | false | false | true | ||||||||||||||||
| 7b7d5274-1e6e-4837-a156-cd84bc0b160d | 2026-09-14 09:49 | 2026-09-14 09:49 | 2026-09-14 09:49 | AMZN | AMZN260918C00250000 | call | 250.0000 | 2026-09-18 | 5.9200 | 5.7500 | 5.9500 | 253.6800 | 177600.00 | 177600.00 | 0.00 | 300 | 7 | 2154 | 17109 | 0.125898649833421 | 0.358390050694555 | 0.354295921614823 | false | false | false | true | ||||||||||||||||
| 9ddbd2af-7227-41a7-93ad-2e8f79b05c2a | 2026-08-19 10:16 | 2026-08-19 10:16 | 2026-08-19 10:16 | AMZN | AMZN260918C00250000 | call | 250.0000 | 2026-09-18 | 15.5500 | 15.5500 | 16.0500 | 260.7900 | 155500.00 | 0.00 | 155500.00 | 100 | 11 | 148 | 15508 | 0.00954346143925716 | 0.29335166215165 | 0.29335166215165 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2736595616352.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2736595616352.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2736595616352.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2736595616352.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2736595616352.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2736595616352.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2709414106151.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2709414106151.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T16:22:15.429007Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2709414106151.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:32:41.851557Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2709414106151.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:32:41.851557Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2653001686169.00 |
| 2026-10-29 |
| unknown |
| 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 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:09:54.469160Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:00:07.512367Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:00:07.512367Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2734761943045.00 |
| 2026-10-29 |
| 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 |