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 |
|---|
| 165e2fa3-ff5e-438c-8478-d9017906fb5b | 2026-08-17 09:32 | 2026-08-17 09:32 | 2026-08-17 09:32 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 19.3100 | 19.2500 | 19.8000 | 263.1200 | 206655.00 | 0.00 | 206655.00 | 107 | 14 | 148 | 62456 | 0.0023696682464455 | 0.334689015205445 | 0.333948271785328 | false | false | false | true | false | 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-08-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a5b598e3-601b-4ade-8afc-6d0fb76a8109 | 2026-09-09 14:01 | 2026-09-09 14:01 | 2026-09-09 14:01 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 13.6000 | 13.5500 | 13.7000 | 252.3100 | 235280.00 | 189040.00 | 46240.00 | 173 | 17 | 611 | 63380 | 0.00964026506784475 | 0.35237873100573 | 0.35237873100573 | false | false | false | |||||||||||||||||
| 294c2c41-8d98-42ca-bd1d-fad98195bc6f | 2026-09-14 13:51 | 2026-09-14 13:50 | 2026-09-14 13:50 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 14.1500 | 14.1500 | 14.4000 | 255.6950 | 152820.00 | 0.00 | 152820.00 | 108 | 9 | 802 | 63594 | 0.0126112526338963 | 0.344888930865924 | 0.344888930865924 | false | false | false | |||||||||||||||||
| 03188a1c-7e58-4158-8a16-be260c163412 | 2026-09-16 11:34 | 2026-09-16 11:34 | 2026-09-16 11:34 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 10.9000 | 10.9000 | 11.0500 | 247.5601 | 523260.00 | 0.00 | 523260.00 | 480 | 33 | 755 | 64097 | 0.011779022419146 | 0.346468434748175 | 0.346670417089679 | false | false | false | |||||||||||||||||
| 8bb057ad-bf4d-47e7-b33d-b989c5c9fd71 | 2026-09-21 10:13 | 2026-09-21 10:13 | 2026-09-21 10:13 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 14.1000 | 13.9500 | 14.1000 | 256.8450 | 11280.00 | 5640.00 | 0.00 | 8 | 6 | 477 | 63989 | 0.00745440622607011 | 0.346308456151111 | 0.346308456151111 | false | false | false | true | ||||||||||||||||
| 52e33757-1b2f-4112-8a8d-cedf0f632562 | 2026-09-22 14:28 | 2026-09-22 14:28 | 2026-09-22 14:28 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 13.3500 | 13.3000 | 13.4500 | 255.2900 | 339090.00 | 2670.00 | 336420.00 | 254 | 13 | 2606 | 63618 | 0.0409632493948254 | 0.346198532424196 | 0.346198532424196 | true | false | false | |||||||||||||||||
| 429088d0-8589-4767-b8f5-06ea7d9c199b | 2026-09-22 14:29 | 2026-09-22 14:29 | 2026-09-22 14:29 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 13.3500 | 13.3500 | 13.4500 | 255.3750 | 1065338.00 | 0.00 | 1065338.00 | 798 | 53 | 3752 | 63618 | 0.0589770190826496 | 0.345159544599771 | 0.345746765558677 | true | false | false | |||||||||||||||||
| 2240cff6-5996-463c-86c8-16ecf7fe3ceb | 2026-09-22 14:32 | 2026-09-22 14:32 | 2026-09-22 14:32 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 13.4000 | 13.3500 | 13.4500 | 255.5200 | 671340.00 | 665980.00 | 4020.00 | 501 | 6 | 5357 | 63618 | 0.0842057279386337 | 0.345385243189752 | 0.345385243189752 | false | false | false | |||||||||||||||||
| 0a1658a8-f1ba-40e4-b01e-8f9b35e62524 | 2026-09-23 10:12 | 2026-09-23 10:12 | 2026-09-23 10:12 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 10.8700 | 10.8000 | 11.0000 | 248.9150 | 27175.00 | 0.00 | 27175.00 | 25 | 7 | 414 | 62546 | 0.00661912832155534 | 0.347929183853173 | 0.347929183853173 | false | false | false | |||||||||||||||||
| 9f1af601-0def-46e5-9db5-35f95e309fad | 2026-09-23 10:15 | 2026-09-23 10:14 | 2026-09-23 10:14 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 10.8000 | 10.8000 | 10.9000 | 248.8500 | 79920.00 | 0.00 | 79920.00 | 74 | 9 | 532 | 62546 | 0.00850573977552521 | 0.347041647321086 | 0.347041647321086 | false | false | false | |||||||||||||||||
| b530f28b-7908-400b-9d12-b51830211c7d | 2026-09-23 10:21 | 2026-09-23 10:21 | 2026-09-23 10:21 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 10.8000 | 10.7250 | 10.8500 | 248.8550 | 10800.00 | 9720.00 | 1080.00 | 10 | 10 | 593 | 62546 | 0.00948102196783168 | 0.347006842195034 | 0.347006842195034 | false | false | false | |||||||||||||||||
| d961d3a1-f243-4ce6-8d90-eba267d84967 | 2026-09-23 14:29 | 2026-09-23 14:29 | 2026-09-23 14:29 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 10.9500 | 10.9500 | 11.2000 | 249.3800 | 96360.00 | 0.00 | 96360.00 | 88 | 11 | 1357 | 62546 | 0.0216960317206536 | 0.346210086817769 | 0.346210086817769 | false | false | false | |||||||||||||||||
| ad6f6daa-37dd-4655-9bf6-8185c4d6b49e | 2026-09-23 15:37 | 2026-09-23 15:36 | 2026-09-23 15:36 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 11.0000 | 10.9750 | 11.2500 | 249.4100 | 34100.00 | 0.00 | 34100.00 | 31 | 10 | 1478 | 62546 | 0.0236306078726058 | 0.346952616683831 | 0.346952616683831 | false | false | false | |||||||||||||||||
| ba69d4bb-322f-4c8a-b77e-38c6f2d5bc25 | 2026-09-24 10:56 | 2026-09-24 10:56 | 2026-09-24 10:56 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 9.7500 | 9.6500 | 9.8000 | 246.7600 | 25350.00 | 3900.00 | 5850.00 | 26 | 7 | 351 | 62849 | 0.00558481439641044 | 0.342483649619991 | 0.342483649619991 | false | false | false | |||||||||||||||||
| 715319e6-e714-47ae-876a-cef70370a242 | 2026-09-24 10:57 | 2026-09-24 10:57 | 2026-09-24 10:57 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 9.6500 | 9.6500 | 9.7500 | 246.6210 | 17370.00 | 0.00 | 17370.00 | 18 | 7 | 386 | 62849 | 0.00614170472083884 | 0.341444519150579 | 0.341444519150579 | false | false | false | true | ||||||||||||||||
| 12571d3d-8c71-4672-a71a-d739f1cecfd9 | 2026-09-25 11:14 | 2026-09-25 11:14 | 2026-09-25 11:14 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 10.1900 | 10.0000 | 10.2500 | 248.6200 | 203720.00 | 102000.00 | 95600.00 | 200 | 21 | 811 | 62951 | 0.0128830360121364 | 0.340113369638111 | 0.339138367893276 | false | false | false | |||||||||||||||||
| b3baf130-3b4f-4afd-bbbd-4819df27953d | 2026-09-28 09:41 | 2026-09-28 09:41 | 2026-09-28 09:41 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 9.0000 | 9.0000 | 9.2000 | 245.3000 | 12600.00 | 0.00 | 12600.00 | 14 | 7 | 129 | 64045 | 0.002014208759466 | 0.344023856018616 | 0.344023856018616 | false | false | false | true | ||||||||||||||||
| f0474a90-d2f6-4d2b-97c9-4909525cb3ca | 2026-09-28 15:02 | 2026-09-28 15:02 | 2026-09-28 15:02 | AMZN | AMZN270115C00275000 | call | 275.0000 | 2027-01-15 | 9.0000 | 9.0000 | 9.2000 | 246.0850 | 20700.00 | 0.00 | 20700.00 | 23 | 7 | 675 | 64045 | 0.0105394644390663 | 0.338702260608603 | 0.338702260608603 | 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-09-09T18:27:25.894507Z"} |
| 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-09-14T18:18:53.599003Z"} |
| 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 |
| 2653001686169.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:39:18.643032Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 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-21T14:14:40.112451Z"} |
| 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-22T18:29:55.439380Z"} |
| 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-22T18:29:55.439380Z"} |
| 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:36:42.386317Z"} |
| 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-23T14:13:13.809395Z"} |
| 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-23T14:16:29.786516Z"} |
| 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-23T14:21:45.775363Z"} |
| 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-23T18:35:00.755474Z"} |
| 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-23T19:37:14.904379Z"} |
| 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:58:33.796895Z"} |
| 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-24T14:58:33.796895Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:15:19.758010Z"} |
| 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 |
| 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 |
| 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:04:54.976253Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |