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_alerts609,118 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 |
|---|
| ee6d3fa7-c129-4967-80fb-745d2818cb7e | 2026-08-19 10:32 | 2026-08-19 10:32 | 2026-08-19 10:32 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 11.8500 | 11.7500 | 11.8500 | 261.3500 | 171825.00 | 171825.00 | 0.00 | 145 | 5 | 530 | 7778 | 0.0681409102597069 | 0.346007894380215 | 0.346007894380215 | false | false | false | true | false | 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:37:39.751673Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| efb268c7-16b8-4ece-8475-c0b7b0cb4ffb | 2026-08-19 10:42 | 2026-08-19 10:42 | 2026-08-19 10:42 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 12.4400 | 12.4000 | 12.4500 | 262.5450 | 211490.00 | 211490.00 | 0.00 | 170 | 7 | 781 | 7778 | 0.100411416816662 | 0.347845167745853 | 0.347845167745853 | false | false | false | |||||||||||||||||
| 97d2a949-ad08-4f75-a77b-97a8e7968392 | 2026-08-26 13:01 | 2026-08-26 13:01 | 2026-08-26 13:01 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 10.2400 | 10.2000 | 10.2500 | 258.9000 | 105511.00 | 105511.00 | 0.00 | 103 | 7 | 289 | 8028 | 0.0359990034877927 | 0.347778531337156 | 0.347778531337156 | false | false | false | |||||||||||||||||
| 68006875-4d4b-46f8-9a3d-c95ab8fe596e | 2026-09-21 11:26 | 2026-09-21 11:25 | 2026-09-21 11:25 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 7.1000 | 7.1000 | 7.1500 | 255.3250 | 117150.00 | 0.00 | 117150.00 | 165 | 7 | 965 | 10217 | 0.0944504257609866 | 0.37090875496246 | 0.37090875496246 | false | false | false | |||||||||||||||||
| f9dcd534-cdc7-44cf-a515-2f4bc17479e2 | 2026-09-21 13:23 | 2026-09-21 13:23 | 2026-09-21 13:23 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 8.0100 | 8.0000 | 8.1500 | 257.0000 | 27236.00 | 0.00 | 27236.00 | 34 | 5 | 1336 | 10217 | 0.130762454732309 | 0.372979469674553 | 0.373504041340688 | true | false | false | |||||||||||||||||
| efc8d412-e06e-44d3-b5b8-bcddd86dddf3 | 2026-09-21 15:26 | 2026-09-21 15:26 | 2026-09-21 15:26 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 8.5000 | 8.5000 | 8.7000 | 259.0200 | 85000.00 | 0.00 | 85000.00 | 100 | 5 | 1659 | 10217 | 0.1623764314378 | 0.375758077237899 | 0.375758077237899 | false | false | false | |||||||||||||||||
| 3cbf4071-51b9-4155-9c29-35042e85fa03 | 2026-09-22 13:55 | 2026-09-22 13:55 | 2026-09-22 13:55 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 7.1500 | 7.1000 | 7.2000 | 255.4450 | 17160.00 | 6435.00 | 2145.00 | 24 | 7 | 851 | 10922 | 0.0779161325764512 | 0.374610814060957 | 0.374610814060957 | false | false | false | |||||||||||||||||
| f53fdeac-719b-4e63-aefb-bc52639a7d43 | 2026-09-23 09:57 | 2026-09-23 09:57 | 2026-09-23 09:57 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 5.5500 | 5.5000 | 5.5500 | 250.2400 | 13320.00 | 13320.00 | 0.00 | 24 | 6 | 356 | 11406 | 0.031211642994915 | 0.375050636241498 | 0.375050636241498 | true | false | false | |||||||||||||||||
| 04e64a37-b366-45ce-bdd3-a058fc55a1e8 | 2026-09-23 13:02 | 2026-09-23 13:02 | 2026-09-23 13:02 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 5.0000 | 5.0000 | 5.0500 | 248.0700 | 54000.00 | 0.00 | 54000.00 | 108 | 5 | 880 | 11406 | 0.0771523759424864 | 0.375079280622481 | 0.375079280622481 | false | false | false | |||||||||||||||||
| 0adf2233-cdd4-4aa9-a443-668fb7168d59 | 2026-09-24 10:17 | 2026-09-24 10:17 | 2026-09-24 10:17 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 4.4000 | 4.3000 | 4.4000 | 245.7964 | 43962.00 | 43962.00 | 0.00 | 100 | 6 | 768 | 11892 | 0.0645812310797175 | 0.376273775001486 | 0.376273775001486 | false | false | false | |||||||||||||||||
| 33c08a9b-ca38-4beb-b47f-3db93ddda3e1 | 2026-09-24 14:24 | 2026-09-24 14:24 | 2026-09-24 14:24 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 5.3000 | 5.3000 | 5.3500 | 249.6850 | 31800.00 | 0.00 | 31800.00 | 60 | 12 | 1243 | 11892 | 0.104524049781366 | 0.375198163706838 | 0.375198163706838 | false | false | false | |||||||||||||||||
| e5bffcee-6d38-4491-8d0d-25df874fd2cb | 2026-09-25 13:50 | 2026-09-25 13:50 | 2026-09-25 13:50 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 5.2500 | 5.1000 | 5.2500 | 250.1600 | 19425.00 | 19425.00 | 0.00 | 37 | 7 | 469 | 12699 | 0.0369320418930624 | 0.373268168515629 | 0.373064999956261 | true | false | false | |||||||||||||||||
| 3c0bb9f1-5b8f-48de-a25a-a47c1e0184f1 | 2026-09-25 14:52 | 2026-09-25 14:52 | 2026-09-25 14:52 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 5.1000 | 5.1000 | 5.2000 | 249.0000 | 22950.00 | 0.00 | 22950.00 | 45 | 5 | 660 | 12699 | 0.0519725962674226 | 0.372493733035495 | 0.372413046487945 | false | false | false | |||||||||||||||||
| 50c8246f-245a-4e32-9841-1b9e8b704f1d | 2026-09-28 10:02 | 2026-09-28 10:02 | 2026-09-28 10:02 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 4.1100 | 4.0500 | 4.2000 | 245.9550 | 164041.00 | 8260.00 | 155781.00 | 399 | 8 | 690 | 12887 | 0.0535423294793202 | 0.379786351820287 | 0.379786351820287 | false | false | false | |||||||||||||||||
| 921d2bff-2c6d-4166-a47e-9029028ab204 | 2026-09-28 11:54 | 2026-09-28 11:54 | 2026-09-28 11:54 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 4.0700 | 4.0000 | 4.1000 | 246.2900 | 124135.00 | 2849.00 | 121286.00 | 305 | 5 | 1413 | 12887 | 0.109645379064173 | 0.374969995740877 | 0.374969995740877 | false | false | false | |||||||||||||||||
| f2875689-8b40-4f26-a987-d0555a8020b6 | 2026-09-29 15:09 | 2026-09-29 15:09 | 2026-09-29 15:09 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 4.5000 | 4.5000 | 4.6000 | 248.4410 | 22500.00 | 0.00 | 22500.00 | 50 | 14 | 1867 | 12931 | 0.144381718351249 | 0.376843553952446 | 0.376843553952446 | false | false | false | |||||||||||||||||
| ded7b9b5-8599-45fb-b29c-db19e80ea8d8 | 2026-09-30 10:10 | 2026-09-30 10:10 | 2026-09-30 10:10 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 5.0000 | 5.0000 | 5.1500 | 250.7523 | 55000.00 | 0.00 | 55000.00 | 110 | 10 | 269 | 14008 | 0.0192033123929183 | 0.37869749607648 | 0.37869749607648 | false | false | false | |||||||||||||||||
| cf4505a0-33dd-42d9-ac6b-8053edd6e9a9 | 2026-09-30 15:42 | 2026-09-30 15:42 | 2026-09-30 15:42 | AMZN | AMZN261120C00280000 | call | 280.0000 | 2026-11-20 | 4.6500 | 4.6000 | 4.6500 | 249.8100 | 85095.00 | 85095.00 | 0.00 | 183 | 23 | 1251 | 14008 | 0.0893061107938321 | 0.374715232409801 | 0.374715232409801 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:50:22.027850Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-26T17:27:57.423992Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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:27:55.894324Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2787722742683.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:24:56.111062Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| 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-22T17:57:38.128984Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| 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:58:49.832976Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| 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-23T17:03:13.598333Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| 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 |
| false |
| 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-24T18:26:21.590036Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-25T18:00:15.336636Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-25T18:55:18.072403Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2655051085748.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:03:25.739526Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2655051085748.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:58:21.684493Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2660659968805.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:11:44.120733Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2660659968805.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:11:55.859186Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2660659968805.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:46:40.965849Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |