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 | 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 |
|---|
| 87a15a01-50e2-47c6-a835-99642e07743a | 2026-08-17 11:28 | 2026-08-17 11:28 | 2026-08-17 11:28 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 9.8000 | 9.8000 | 9.8500 | 261.3800 | 105840.00 | 0.00 | 105840.00 | 108 | 8 | 1234 | 20599 | 0.0599058206709064 | 0.280799930839951 | 0.280799930839951 | 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-17T15:40:30.458422Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6f7eb838-87b5-4343-96e8-f853286f2a4d | 2026-08-17 14:07 | 2026-08-17 14:06 | 2026-08-17 14:06 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 8.8200 | 8.7000 | 8.8500 | 259.0000 | 264601.00 | 264601.00 | 0.00 | 300 | 6 | 2968 | 20599 | 0.144084664304092 | 0.285228909479501 | 0.285228909479501 | false | false | false | true | ||||||||||||||||
| 41af4c3b-719a-4bf6-be83-ae88cbf13994 | 2026-08-17 15:17 | 2026-08-17 15:17 | 2026-08-17 15:17 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 9.4500 | 9.4500 | 9.5000 | 260.5050 | 228690.00 | 0.00 | 228690.00 | 242 | 7 | 3500 | 20599 | 0.169911160735958 | 0.284198262057023 | 0.285084105161606 | false | false | false | true | ||||||||||||||||
| 92cc1b2a-7bab-4649-b56d-903b78503d44 | 2026-08-18 10:39 | 2026-08-18 10:38 | 2026-08-18 10:38 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 10.2400 | 10.0500 | 10.2500 | 262.0100 | 102425.00 | 102425.00 | 0.00 | 100 | 10 | 1555 | 20706 | 0.0750990051192891 | 0.287993004671698 | 0.288901825330907 | false | false | false | true | ||||||||||||||||
| c1f0b2a3-d8ee-4886-a993-4da58548ac14 | 2026-08-18 12:45 | 2026-08-18 12:45 | 2026-08-18 12:45 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 10.0000 | 9.9000 | 10.0500 | 261.5700 | 176000.00 | 85000.00 | 40000.00 | 176 | 18 | 3069 | 20706 | 0.148217907852796 | 0.28977954299924 | 0.288846374310084 | false | false | false | true | ||||||||||||||||
| 1ee03b5c-006a-4330-89f3-c95aded57352 | 2026-08-21 11:52 | 2026-08-21 11:52 | 2026-08-21 11:52 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 8.9000 | 8.7500 | 8.9500 | 260.5500 | 146850.00 | 145960.00 | 890.00 | 165 | 18 | 2062 | 21658 | 0.0952073136947087 | 0.286665949952325 | 0.286665949952325 | true | false | false | true | ||||||||||||||||
| 899b2039-2398-4dd9-b63f-77f09e2c7692 | 2026-08-24 10:00 | 2026-08-24 10:00 | 2026-08-24 10:00 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 9.7800 | 9.5500 | 9.8000 | 262.3950 | 133030.00 | 133030.00 | 0.00 | 136 | 5 | 1080 | 21739 | 0.0496802980817885 | 0.300116807573489 | 0.300161126036634 | true | false | false | true | ||||||||||||||||
| 26743785-c0b0-476a-9754-1d8ff655ca46 | 2026-08-24 12:59 | 2026-08-24 12:58 | 2026-08-24 12:58 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 10.0500 | 10.0500 | 10.1500 | 263.0300 | 110550.00 | 0.00 | 110550.00 | 110 | 16 | 2249 | 21739 | 0.103454620727724 | 0.295722672128968 | 0.295722672128968 | false | false | false | true | ||||||||||||||||
| 581f6e01-d9f4-4958-a7e5-bf5b98c7c901 | 2026-08-26 15:54 | 2026-08-26 15:54 | 2026-08-26 15:54 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 7.9500 | 7.8500 | 7.9500 | 260.3500 | 158982.00 | 158982.00 | 0.00 | 200 | 39 | 1097 | 20789 | 0.0527682909230843 | 0.286522157390289 | 0.286522157390289 | false | false | false | true | ||||||||||||||||
| 1bcb11c1-b1e5-4ede-ae47-2f564c358553 | 2026-08-27 10:29 | 2026-08-27 10:28 | 2026-08-27 10:28 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 6.0700 | 6.0000 | 6.1500 | 257.1200 | 106268.00 | 26144.00 | 80124.00 | 175 | 5 | 2006 | 20915 | 0.0959120248625388 | 0.282903288679272 | 0.282903288679272 | false | false | false | true | ||||||||||||||||
| e4e6769a-53f5-4422-9aac-f68648ac3c96 | 2026-08-27 10:41 | 2026-08-27 10:41 | 2026-08-27 10:41 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 6.0000 | 5.9500 | 6.1000 | 256.9950 | 210600.00 | 23400.00 | 106200.00 | 351 | 13 | 2628 | 20915 | 0.125651446330385 | 0.282412654160466 | 0.282412654160466 | false | false | false | true | ||||||||||||||||
| 70d31819-7d18-43db-b430-3c729505c394 | 2026-08-27 10:42 | 2026-08-27 10:42 | 2026-08-27 10:42 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 6.0000 | 5.9000 | 6.0500 | 256.9800 | 271200.00 | 34800.00 | 180600.00 | 452 | 15 | 3203 | 20915 | 0.153143676786995 | 0.283422380096802 | 0.282688201371559 | false | false | false | true | ||||||||||||||||
| c683c7c9-0c1f-4feb-84a2-203c947e94ae | 2026-08-27 10:47 | 2026-08-27 10:47 | 2026-08-27 10:47 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 5.9000 | 5.8500 | 6.0000 | 256.8000 | 143960.00 | 0.00 | 143960.00 | 244 | 14 | 3483 | 20915 | 0.166531197704996 | 0.28116414142382 | 0.281985121038403 | false | false | false | true | ||||||||||||||||
| 077a6dce-8482-4ddc-a46a-e6c02fd8ae12 | 2026-08-27 10:47 | 2026-08-27 10:47 | 2026-08-27 10:47 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 5.9000 | 5.8000 | 6.0000 | 256.7100 | 118000.00 | 12980.00 | 51920.00 | 200 | 9 | 3684 | 20915 | 0.176141525221133 | 0.282531826169017 | 0.283623774027213 | false | false | false | true | ||||||||||||||||
| 33c42c5a-82a0-4175-b470-31e79a77518e | 2026-08-27 15:43 | 2026-08-27 15:43 | 2026-08-27 15:43 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 5.7000 | 5.6500 | 5.7000 | 256.6800 | 136800.00 | 136800.00 | 0.00 | 240 | 6 | 8651 | 20915 | 0.413626583791537 | 0.276156911425552 | 0.276156911425552 | false | false | false | true | ||||||||||||||||
| ce8bc68e-4d50-45db-94ac-701276bdf4a1 | 2026-08-28 09:30 | 2026-08-28 09:30 | 2026-08-28 09:30 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 6.5000 | 6.1000 | 6.5000 | 258.4600 | 937300.00 | 937300.00 | 0.00 | 1442 | 5 | 1470 | 22714 | 0.0647177951923924 | 0.281527457438668 | 0.281527457438668 | false | false | false | true | ||||||||||||||||
| 93751d8b-33c5-4e7d-ab7c-a43873bfa0fa | 2026-09-01 10:29 | 2026-09-01 10:29 | 2026-09-01 10:29 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 4.0000 | 3.9000 | 4.0000 | 254.4000 | 104400.00 | 104400.00 | 0.00 | 261 | 23 | 1644 | 21535 | 0.076340840492222 | 0.28180820671076 | 0.28180820671076 | false | false | false | true | ||||||||||||||||
| 8912389d-f69e-4de2-9ce0-d10daf3d56c7 | 2026-09-02 10:32 | 2026-09-02 10:32 | 2026-09-02 10:32 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 4.2500 | 4.1500 | 4.3000 | 255.7000 | 418750.00 | 302175.00 | 116575.00 | 986 | 27 | 1556 | 22622 | 0.0687826010078684 | 0.279481109945932 | 0.278104286523919 | true | false | false | true | ||||||||||||||||
| 503ae29a-4914-4d01-b944-4ca78eee98e0 | 2026-09-03 14:30 | 2026-09-03 14:30 | 2026-09-03 14:30 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 6.0000 | 5.9000 | 6.0000 | 259.4800 | 190200.00 | 190200.00 | 0.00 | 317 | 5 | 4642 | 24443 | 0.189911222026756 | 0.288534251638572 | 0.288534251638572 | false | false | false | true | ||||||||||||||||
| 7319d5b7-9817-4896-a7f0-39e1ac1d19a9 | 2026-09-04 12:55 | 2026-09-04 12:55 | 2026-09-04 12:55 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 4.4500 | 4.4500 | 4.6500 | 257.2008 | 293255.00 | 0.00 | 293255.00 | 659 | 6 | 3702 | 23780 | 0.155677039529016 | 0.276190115612696 | 0.276190115612696 | false | false | false | true | ||||||||||||||||
| a4b5465b-4cc6-4e67-8844-a3a7ea4e1bc9 | 2026-09-08 10:50 | 2026-09-08 10:50 | 2026-09-08 10:50 | AMZN | AMZN260918C00260000 | call | 260.0000 | 2026-09-18 | 3.9000 | 3.9000 | 4.0000 | 256.4600 | 469950.00 | 0.00 | 469950.00 | 1205 | 17 | 4868 | 23875 | 0.203895287958115 | 0.31607444023189 | 0.315573711831496 | false | false | false | true |
| 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-08-17T18:13:23.978459Z"} |
| 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-17T19:39:36.389012Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-18T14:49:07.673043Z"} |
| 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-18T16:50:14.134420Z"} |
| 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-21T15:55:19.311132Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-24T14:08:32.927735Z"} |
| 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-24T17:17:38.633077Z"} |
| 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-26T19:59:46.397035Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-27T14:37:18.031558Z"} |
| 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-27T14:49:52.356548Z"} |
| 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-27T14:49:52.356548Z"} |
| 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-27T14:49:52.356548Z"} |
| 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-27T14:49:52.356548Z"} |
| 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-27T19:52:49.177007Z"} |
| 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-28T13:32:48.312014Z"} |
| 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:37:25.650051Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-02T14:46:18.296261Z"} |
| 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-03T18:47:01.806289Z"} |
| 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-04T17:07:55.847311Z"} |
| 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-08T15:02:25.769037Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |