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_alerts523,327 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 |
|---|
| 6e70132b-e364-49c5-bfec-49fdd74a2e41 | 2026-09-28 15:25 | 2026-09-28 15:25 | 2026-09-28 15:25 | AMZN | AMZN260930P00245000 | put | 245.0000 | 2026-09-30 | 1.7500 | 1.7500 | 1.7600 | 246.0850 | 21700.00 | 0.00 | 21700.00 | 124 | 16 | 5703 | 1489 | 3.83008730691739 | 0.313697782886689 | 0.313697782886689 | false | false | false | true | 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-28T19:30:45.639934Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 25a261d8-3ed9-4d76-88a7-a3cda6aed8c6 | 2026-09-28 15:00 | 2026-09-28 15:00 | 2026-09-28 15:00 | AMZN | AMZN260930P00245000 | put | 245.0000 | 2026-09-30 | 1.5600 | 1.5200 | 1.5700 | 246.4100 | 19188.00 | 19188.00 | 0.00 | 123 | 24 | 5145 | 1489 | 3.45533915379449 | 0.305384980588671 | 0.305384980588671 | true | false | false | true | ||||||||||||||||
| 0ce2b7f4-a2fc-4fbd-b054-4d868b6d382e | 2026-09-28 14:42 | 2026-09-28 14:42 | 2026-09-28 14:42 | AMZN | AMZN260930P00245000 | put | 245.0000 | 2026-09-30 | 1.3900 | 1.3900 | 1.4300 | 246.0000 | 14595.00 | 0.00 | 14595.00 | 105 | 8 | 4813 | 1489 | 3.23237071860309 | 0.306341423621095 | 0.306341423621095 | false | false | false | true | ||||||||||||||||
| d4065f75-86c0-411b-a03d-0c9a366a9537 | 2026-09-28 14:31 | 2026-09-28 14:31 | 2026-09-28 14:31 | AMZN | AMZN260930P00245000 | put | 245.0000 | 2026-09-30 | 1.4800 | 1.4100 | 1.4900 | 246.7056 | 10508.00 | 10064.00 | 444.00 | 71 | 21 | 4582 | 1489 | 3.07723304231028 | 0.310129779941888 | 0.310129779941888 | true | false | false | true | ||||||||||||||||
| e330ecfc-607f-4562-acd2-8774be16bf26 | 2026-09-28 14:30 | 2026-09-28 14:30 | 2026-09-28 14:30 | AMZN | AMZN260930P00245000 | put | 245.0000 | 2026-09-30 | 1.4500 | 1.4100 | 1.4500 | 246.7300 | 11890.00 | 11890.00 | 0.00 | 82 | 20 | 4477 | 1489 | 3.00671591672263 | 0.307099788282577 | 0.307099788282577 | true | false | false | true | ||||||||||||||||
| 24733f68-7294-485a-a22f-4b98e34fdd99 | 2026-09-28 13:00 | 2026-09-28 13:00 | 2026-09-28 13:00 | AMZN | AMZN260930P00245000 | put | 245.0000 | 2026-09-30 | 1.5300 | 1.4700 | 1.5400 | 246.6016 | 11475.00 | 11475.00 | 0.00 | 75 | 12 | 3722 | 1489 | 2.49966420416387 | 0.311686242652915 | 0.311686242652915 | true | false | false | true | ||||||||||||||||
| ea6d2393-3bdd-4560-b260-df5193ef5692 | 2026-09-28 11:01 | 2026-09-28 11:01 | 2026-09-28 11:01 | AMZN | AMZN260930P00245000 | put | 245.0000 | 2026-09-30 | 1.6600 | 1.6600 | 1.7400 | 246.5300 | 25117.00 | 0.00 | 25117.00 | 151 | 18 | 2521 | 1489 | 1.69308260577569 | 0.326358016248423 | 0.326358016248423 | true | false | false | true | ||||||||||||||||
| eb004b18-35bf-4fd4-a8d1-58cce1f8ca19 | 2026-09-28 09:45 | 2026-09-28 09:45 | 2026-09-28 09:45 | AMZN | AMZN260930P00245000 | put | 245.0000 | 2026-09-30 | 1.9900 | 1.9900 | 2.0400 | 245.9100 | 39203.00 | 0.00 | 39203.00 | 197 | 19 | 1152 | 1489 | 0.77367360644728 | 0.336925057106301 | 0.336925057106301 | true | false | false | true | ||||||||||||||||
| 37ec6bee-ed60-452b-9d99-ef97ef391568 | 2026-09-28 09:42 | 2026-09-28 09:42 | 2026-09-28 09:42 | AMZN | AMZN260930P00245000 | put | 245.0000 | 2026-09-30 | 2.2400 | 2.2400 | 2.3300 | 245.4200 | 42112.00 | 0.00 | 42112.00 | 188 | 17 | 913 | 1489 | 0.61316319677636 | 0.339194386598717 | 0.341128036555516 | true | false | false | true | ||||||||||||||||
| 7ee03302-6a90-476b-af5e-52b49ffecc9a | 2026-09-28 09:34 | 2026-09-28 09:34 | 2026-09-28 09:34 | AMZN | AMZN260930P00245000 | put | 245.0000 | 2026-09-30 | 2.0700 | 2.0400 | 2.1300 | 246.0800 | 35600.00 | 619.00 | 34981.00 | 172 | 15 | 447 | 1489 | 0.300201477501679 | 0.361883347705402 | 0.356916356903308 | true | false | false | true | ||||||||||||||||
| d5b0520c-8ea2-48bd-95cb-82691825face | 2026-09-25 11:44 | 2026-09-25 11:44 | 2026-09-25 11:44 | AMZN | AMZN260930P00245000 | put | 245.0000 | 2026-09-30 | 1.4400 | 1.3800 | 1.4400 | 248.7150 | 15408.00 | 15408.00 | 0.00 | 107 | 16 | 732 | 969 | 0.755417956656347 | 0.258381797614452 | 0.258381797614452 | false | false | false | true | ||||||||||||||||
| 943c24ea-7b7a-47ba-a647-82f408460d69 | 2026-09-24 12:13 | 2026-09-24 12:13 | 2026-09-24 12:13 | AMZN | AMZN260930P00245000 | put | 245.0000 | 2026-09-30 | 2.7700 | 2.7600 | 2.8200 | 246.1650 | 10803.00 | 0.00 | 10803.00 | 39 | 5 | 657 | 527 | 1.24667931688805 | 0.270110842644784 | 0.270110842644784 | false | false | false | true | ||||||||||||||||
| 545c66b2-f10a-46ea-9ce1-83688efc8094 | 2026-09-23 12:42 | 2026-09-23 12:42 | 2026-09-23 12:42 | AMZN | AMZN260930P00245000 | put | 245.0000 | 2026-09-30 | 2.0800 | 1.9800 | 2.0900 | 249.0000 | 10400.00 | 10192.00 | 208.00 | 50 | 6 | 211 | 372 | 0.567204301075269 | 0.284509975343819 | 0.284507385220299 | false | false | false | true |
| 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-28T19:00:50.307488Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2655051085748.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:44:38.153371Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-28T18:38:54.071675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-28T18:30:52.408628Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-28T17:04:44.009732Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:01:52.060675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-28T13:47:49.736283Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-28T13:43:35.547112Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-28T13:34:45.644461Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 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:46:29.692189Z"} |
| 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-24T16:15:47.773676Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:43:49.845741Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |