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 |
|---|
| ff41fa7a-f14f-4ff8-9228-d4f81e262520 | 2026-09-21 11:44 | 2026-09-21 11:44 | 2026-09-21 11:44 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 2.0000 | 2.0000 | 2.0400 | 255.8500 | 18000.00 | 0.00 | 18000.00 | 90 | 8 | 1464 | 232 | 6.31034482758621 | 0.321652203451396 | 0.321652203451396 | false | false | false | true | 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:46:21.763749Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| d820fdfd-075f-41e4-8c43-a13e4a00eea6 | 2026-09-21 13:37 | 2026-09-21 13:36 | 2026-09-21 13:36 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 1.2500 | 1.2100 | 1.2600 | 257.0000 | 30877.00 | 30877.00 | 0.00 | 247 | 21 | 2740 | 232 | 11.8103448275862 | 0.319995017412631 | 0.316116631779533 | false | false | false | true | ||||||||||||||||
| 60a90cbb-65d3-46e9-b8e9-00b89c09e21f | 2026-09-21 14:17 | 2026-09-21 14:17 | 2026-09-21 14:17 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 1.1400 | 1.1300 | 1.1400 | 258.4500 | 17100.00 | 17100.00 | 0.00 | 150 | 12 | 3174 | 232 | 13.6810344827586 | 0.33157391760376 | 0.33157391760376 | false | false | false | true | ||||||||||||||||
| aaddc967-9c9f-4959-a770-59539255aadf | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 2.7400 | 2.5500 | 2.7400 | 254.1500 | 44661.00 | 44661.00 | 0.00 | 163 | 18 | 276 | 1414 | 0.195190947666195 | 0.433735324432827 | 0.433735324432827 | true | false | false | true | ||||||||||||||||
| 3d083f00-b1a2-4d68-bcc3-5530d09765c3 | 2026-09-22 10:02 | 2026-09-22 10:02 | 2026-09-22 10:02 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 1.0000 | 1.0000 | 1.0200 | 257.4100 | 10000.00 | 0.00 | 10000.00 | 100 | 5 | 4230 | 1414 | 2.99151343705799 | 0.371114815623975 | 0.371114815623975 | false | false | false | true | ||||||||||||||||
| 065654f8-288e-49cf-816d-0fccde39e9d2 | 2026-09-22 10:07 | 2026-09-22 10:07 | 2026-09-22 10:07 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 1.1900 | 1.1700 | 1.2100 | 256.7950 | 17969.00 | 4284.00 | 11305.00 | 151 | 10 | 5069 | 1414 | 3.58486562942008 | 0.371242365115404 | 0.36842362898406 | false | false | false | true | ||||||||||||||||
| e4736425-d61f-4c4d-8a25-09f770722d95 | 2026-09-22 10:17 | 2026-09-22 10:17 | 2026-09-22 10:17 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 1.2600 | 1.2300 | 1.2800 | 256.5500 | 10436.00 | 5061.00 | 5375.00 | 83 | 9 | 6949 | 1414 | 4.91442715700141 | 0.361326610627211 | 0.362785117244789 | true | false | false | true | ||||||||||||||||
| 491e5254-de7d-4110-984e-c119b10d4ec8 | 2026-09-22 10:18 | 2026-09-22 10:18 | 2026-09-22 10:18 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 1.2800 | 1.2400 | 1.2800 | 256.5400 | 22783.00 | 22783.00 | 0.00 | 178 | 14 | 7300 | 1414 | 5.16265912305516 | 0.366000211215758 | 0.367970561157899 | false | false | false | true | ||||||||||||||||
| 3c187f59-4b47-42d9-aeac-94a340ce20b3 | 2026-09-22 10:58 | 2026-09-22 10:58 | 2026-09-22 10:58 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 1.2500 | 1.2100 | 1.2600 | 256.2700 | 13876.00 | 13876.00 | 0.00 | 111 | 8 | 9650 | 1414 | 6.82461103253182 | 0.342082316324851 | 0.344032225932746 | true | false | false | true | ||||||||||||||||
| ab4622ad-430f-4cfb-9f73-3d0790898b89 | 2026-09-22 11:18 | 2026-09-22 11:18 | 2026-09-22 11:18 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 1.6000 | 1.5700 | 1.6000 | 255.4300 | 14880.00 | 14880.00 | 0.00 | 93 | 7 | 11602 | 1414 | 8.20509193776521 | 0.341471618470432 | 0.341471618470432 | false | false | false | true | ||||||||||||||||
| 91c1c8ed-d67e-4397-962c-6ddc69a83999 | 2026-09-22 11:30 | 2026-09-22 11:30 | 2026-09-22 11:30 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 1.6500 | 1.6300 | 1.6900 | 255.0000 | 16667.00 | 169.00 | 16498.00 | 101 | 5 | 12557 | 1414 | 8.88048090523338 | 0.344895281889404 | 0.338253006454354 | false | false | false | true | ||||||||||||||||
| f926319d-14e2-4368-a0da-cb87e3d2b59a | 2026-09-22 11:31 | 2026-09-22 11:31 | 2026-09-22 11:31 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 1.6500 | 1.6400 | 1.6800 | 255.0000 | 16166.00 | 0.00 | 16166.00 | 98 | 6 | 12693 | 1414 | 8.97666195190948 | 0.335599708106372 | 0.337692799789598 | true | false | false | true | ||||||||||||||||
| b66f9b9c-8581-455c-8830-5f4934c1639a | 2026-09-22 13:20 | 2026-09-22 13:20 | 2026-09-22 13:20 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 2.0300 | 2.0300 | 2.0800 | 254.4250 | 12992.00 | 0.00 | 12992.00 | 64 | 8 | 15360 | 1414 | 10.8628005657709 | 0.327665234064849 | 0.327665234064849 | true | false | false | true | ||||||||||||||||
| 98f8aa3a-b947-483c-a4df-0651a67dd63d | 2026-09-22 13:50 | 2026-09-22 13:50 | 2026-09-22 13:50 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 1.7300 | 1.7000 | 1.7400 | 255.0050 | 12115.00 | 12115.00 | 0.00 | 70 | 5 | 15919 | 1414 | 11.2581329561528 | 0.329849304004807 | 0.327971096377345 | false | false | false | true | ||||||||||||||||
| 4b1978c5-6e1f-4a95-ad9f-1730699bf79d | 2026-09-22 14:13 | 2026-09-22 14:13 | 2026-09-22 14:13 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 1.5700 | 1.5300 | 1.5700 | 255.2600 | 22294.00 | 22294.00 | 0.00 | 142 | 18 | 17152 | 1414 | 12.1301272984441 | 0.320992754254998 | 0.320992754254998 | true | false | false | true | ||||||||||||||||
| 5bffa8c4-3084-40cf-93a2-9584e0aa7ff6 | 2026-09-22 15:18 | 2026-09-22 15:18 | 2026-09-22 15:18 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 1.4300 | 1.4300 | 1.4500 | 255.3700 | 14872.00 | 0.00 | 14872.00 | 104 | 5 | 18266 | 1414 | 12.9179632248939 | 0.304237455799219 | 0.304237455799219 | false | false | false | true | ||||||||||||||||
| 4d087d89-8e12-414f-a506-0e8bb2f05d4a | 2026-09-22 15:51 | 2026-09-22 15:51 | 2026-09-22 15:51 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 1.4200 | 1.3800 | 1.4200 | 255.4000 | 57652.00 | 57652.00 | 0.00 | 406 | 30 | 19272 | 1414 | 13.6294200848656 | 0.308357291825567 | 0.304934156061389 | true | false | false | true | ||||||||||||||||
| 4da2e724-27da-4a1f-b6dc-b6f2d759de09 | 2026-09-22 15:54 | 2026-09-22 15:54 | 2026-09-22 15:54 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 1.6600 | 1.6600 | 1.6900 | 254.0000 | 24900.00 | 0.00 | 24900.00 | 150 | 5 | 19535 | 1414 | 13.8154172560113 | 0.313430972780923 | 0.313430972780923 | false | false | false | true | ||||||||||||||||
| dcd45e86-7212-4bfd-88b9-f5c3ecbe80b7 | 2026-09-22 15:54 | 2026-09-22 15:54 | 2026-09-22 15:54 | AMZN | AMZN260923P00255000 | put | 255.0000 | 2026-09-23 | 1.3800 | 1.3500 | 1.4400 | 255.0000 | 14625.00 | 0.00 | 14625.00 | 106 | 14 | 19657 | 1414 | 13.9016973125884 | 0.307566293887613 | 0.301886372874813 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:39:31.841992Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-21T18:20:26.028708Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-22T13:30:37.895663Z"} |
| 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:04:08.107942Z"} |
| 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 |
| 2750294234589.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:10:05.607073Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:17:46.082263Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:20:22.518739Z"} |
| 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-22T15:00:53.883267Z"} |
| 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-22T15:21:55.684470Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-22T15:34:09.835499Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:34:09.835499Z"} |
| 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-22T17:23:35.118331Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:52:53.749956Z"} |
| 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 |
| 2750294234589.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:18:27.911867Z"} |
| 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 |
| 2750294234589.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:23:17.824277Z"} |
| 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 |
| 2750294234589.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 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 |
| 2750294234589.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 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 |
| 2750294234589.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |