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_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 |
|---|
| 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 |
|---|
| 2ed35466-b1ed-431e-911c-af7da646d72c | 2026-09-25 15:55 | 2026-09-25 15:55 | 2026-09-25 15:55 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 17.9000 | 17.9000 | 18.4500 | 249.7050 | 153940.00 | 0.00 | 153940.00 | 86 | 6 | 862 | 13909 | 0.0619742612696815 | 0.353733021997029 | 0.353733021997029 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 2693018909521.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T19:58:21.779683Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| e8b04399-7079-4886-b4c6-0ec879d7c23d | 2026-09-25 14:57 | 2026-09-25 14:57 | 2026-09-25 14:57 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 17.8500 | 17.8000 | 17.9500 | 249.0000 | 103530.00 | 0.00 | 103530.00 | 58 | 10 | 719 | 13909 | 0.0516931483212309 | 0.354604431979786 | 0.354604431979786 | false | false | false | true | ||||||||||||||||
| b313cb6c-fda4-43cf-82e3-a6cbc8e93538 | 2026-09-25 10:56 | 2026-09-25 10:56 | 2026-09-25 10:56 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 17.2500 | 17.0000 | 17.2500 | 248.5300 | 46575.00 | 36225.00 | 0.00 | 27 | 10 | 226 | 13909 | 0.0162484722122367 | 0.353612801639766 | 0.353612801639766 | false | false | false | true | ||||||||||||||||
| 80a2c0c6-3da1-4528-b562-13d9feffdf63 | 2026-09-24 10:46 | 2026-09-24 10:46 | 2026-09-24 10:46 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 16.0500 | 15.9500 | 16.2000 | 246.0750 | 48150.00 | 41730.00 | 6420.00 | 30 | 5 | 1515 | 12867 | 0.117743063651201 | 0.353728593059052 | 0.353728593059052 | false | false | false | true | ||||||||||||||||
| 52e2b8b0-1b3c-4e45-9bdd-793cdb3db3b5 | 2026-09-24 10:16 | 2026-09-24 10:16 | 2026-09-24 10:16 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 15.9500 | 15.8500 | 16.0500 | 245.8350 | 79750.00 | 47850.00 | 31900.00 | 50 | 5 | 447 | 12867 | 0.0347400326416414 | 0.354246629727941 | 0.354246629727941 | false | false | false | true | ||||||||||||||||
| d622356e-b963-4101-9410-867f816f084d | 2026-09-24 10:08 | 2026-09-24 10:08 | 2026-09-24 10:08 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 16.3500 | 16.2500 | 16.4500 | 246.4700 | 11445.00 | 4905.00 | 1635.00 | 7 | 5 | 239 | 12867 | 0.0185746483251729 | 0.355711336752272 | 0.355711336752272 | false | false | false | true | ||||||||||||||||
| 80abe55e-dce3-4513-b409-560f748797db | 2026-09-24 09:35 | 2026-09-24 09:35 | 2026-09-24 09:35 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 17.0000 | 17.0000 | 17.2500 | 247.3297 | 28900.00 | 0.00 | 28900.00 | 17 | 5 | 27 | 12867 | 0.00209839123338774 | 0.359844625866373 | 0.359844625866373 | false | false | false | true | ||||||||||||||||
| 3612c366-b361-4d47-bdeb-17ddb76cf8a0 | 2026-09-23 15:47 | 2026-09-23 15:47 | 2026-09-23 15:47 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 18.0800 | 18.0500 | 18.3000 | 249.0000 | 12653.00 | 0.00 | 12653.00 | 7 | 5 | 1040 | 12423 | 0.0837156886420349 | 0.359864790139797 | 0.359864790139797 | false | false | false | true | ||||||||||||||||
| 27e230f4-97eb-422f-8e00-8488dbd77324 | 2026-09-23 09:54 | 2026-09-23 09:54 | 2026-09-23 09:54 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 19.0000 | 19.0000 | 19.5500 | 250.7900 | 11400.00 | 0.00 | 11400.00 | 6 | 5 | 128 | 12423 | 0.0103034693713274 | 0.359780043436936 | 0.359780043436936 | false | false | false | true | ||||||||||||||||
| 764f2ac1-9f33-40d1-a962-9349125fa821 | 2026-09-22 13:31 | 2026-09-22 13:30 | 2026-09-22 13:30 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 21.0000 | 21.0000 | 21.4500 | 253.0000 | 33600.00 | 0.00 | 33600.00 | 16 | 9 | 318 | 12283 | 0.0258894406903851 | 0.361416911711449 | 0.361662811376219 | false | false | false | true | ||||||||||||||||
| 0194fe56-5050-4b20-99a8-8afd1cd991f3 | 2026-09-22 10:54 | 2026-09-22 10:54 | 2026-09-22 10:54 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 22.6000 | 22.4500 | 22.7500 | 256.5500 | 90400.00 | 6780.00 | 18080.00 | 40 | 19 | 206 | 12283 | 0.0167711471138973 | 0.361570528694351 | 0.361570528694351 | false | false | false | true | ||||||||||||||||
| 0eb4c930-5131-4265-822b-b2bb2fbd1375 | 2026-09-22 10:52 | 2026-09-22 10:52 | 2026-09-22 10:52 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 22.7000 | 22.4500 | 22.9500 | 256.5900 | 113500.00 | 2270.00 | 18160.00 | 50 | 20 | 166 | 12283 | 0.013514613693723 | 0.363145098575076 | 0.363145098575076 | false | false | false | true | ||||||||||||||||
| 1b0fd929-4fe9-49d2-9ffe-1ffd6fa35a76 | 2026-09-21 11:45 | 2026-09-21 11:45 | 2026-09-21 11:45 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 22.3000 | 22.0500 | 22.3000 | 256.0000 | 124880.00 | 124880.00 | 0.00 | 56 | 28 | 246 | 12147 | 0.0202519140528526 | 0.360154803479462 | 0.360154803479462 | false | false | false | true | ||||||||||||||||
| 977bcbee-c739-4166-a762-c969f5c5957d | 2026-09-18 12:15 | 2026-09-18 12:15 | 2026-09-18 12:15 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 21.0000 | 20.9000 | 21.1500 | 253.0000 | 111319.00 | 23100.00 | 88219.00 | 53 | 14 | 518 | 11845 | 0.0437315322921064 | 0.355396663501786 | 0.355396663501786 | false | false | false | true | ||||||||||||||||
| e5f27e78-1f6f-4346-88c0-1f151711b509 | 2026-09-18 10:48 | 2026-09-18 10:48 | 2026-09-18 10:48 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 20.3500 | 20.3500 | 20.6000 | 252.6530 | 148561.00 | 0.00 | 148561.00 | 73 | 11 | 182 | 11845 | 0.0153651329674968 | 0.353594674506961 | 0.353594674506961 | false | false | false | true | ||||||||||||||||
| 9a05dec9-4da1-4001-a6e5-27f8f51d5170 | 2026-09-17 10:17 | 2026-09-17 10:17 | 2026-09-17 10:17 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 19.3200 | 19.3000 | 19.4000 | 250.4197 | 135226.00 | 0.00 | 135226.00 | 70 | 5 | 172 | 11760 | 0.0146258503401361 | 0.355933978239717 | 0.355933978239717 | false | false | false | true | ||||||||||||||||
| a55a6405-fb45-448b-83d3-de46351fe2dd | 2026-09-16 11:01 | 2026-09-16 11:01 | 2026-09-16 11:01 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 17.9500 | 17.9000 | 18.1000 | 247.3800 | 161550.00 | 0.00 | 161550.00 | 90 | 11 | 229 | 11346 | 0.0201833245196545 | 0.360498215242663 | 0.360498215242663 | false | false | false | true | ||||||||||||||||
| 8c6e26be-2f73-417b-8b65-c638648c4ac7 | 2026-09-14 13:57 | 2026-09-14 13:57 | 2026-09-14 13:57 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 22.6500 | 22.6500 | 23.2000 | 255.4001 | 122310.00 | 0.00 | 122310.00 | 54 | 7 | 485 | 10983 | 0.0441591550578166 | 0.360008534764979 | 0.360008534764979 | false | false | false | true | ||||||||||||||||
| e70e867c-85e1-4cdd-92f1-4301d03697a7 | 2026-09-01 10:51 | 2026-09-01 10:51 | 2026-09-01 10:51 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 22.8500 | 22.6000 | 22.8500 | 254.2100 | 228500.00 | 228500.00 | 0.00 | 100 | 5 | 331 | 10020 | 0.0330339321357285 | 0.351296712363027 | 0.351296712363027 | false | false | false | true | ||||||||||||||||
| d9a18285-6ca5-4701-baa1-0b75984ca1fe | 2026-09-01 09:40 | 2026-09-01 09:40 | 2026-09-01 09:40 | AMZN | AMZN261218C00250000 | call | 250.0000 | 2026-12-18 | 23.0000 | 22.7500 | 23.9500 | 254.6299 | 186300.00 | 52900.00 | 133400.00 | 81 | 5 | 95 | 10020 | 0.0094810379241517 | 0.349406319076228 | 0.349406319076228 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2693018909521.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:03:13.684497Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2693018909521.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:00:01.492206Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2688704384092.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:46:40.041951Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2688704384092.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:18:01.976836Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2688704384092.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:08:54.070178Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2688704384092.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:35:42.562828Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2688704384092.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:47:37.737983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2688704384092.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:55:29.867504Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2750294234589.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:40:26.166069Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2750294234589.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2750294234589.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:46:21.763749Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2736595616352.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:25:30.671610Z"} |
| 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:02:00.544193Z"} |
| 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-17T14:19:06.318420Z"} |
| 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 |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} |
| 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 |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T18:18:53.599003Z"} |
| 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-01T14:59:17.018627Z"} |
| 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-01T13:44:23.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |