Simplify AnalyticsOptions flow alerts (market-wide)
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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| f8064eb0-2c5c-4247-a41a-ba5b3cd24ced | 2026-09-09 13:25 | 2026-09-09 13:25 | 2026-09-09 13:25 | AMGN | AMGN280121C00400000 | call | 400.0000 | 2028-01-21 | 55.8900 | 54.0500 | 58.0000 | 391.1800 | 50305.00 | 0.00 | 50305.00 | 9 | 5 | 15 | 121 | 0.12396694214876 | 0.27093660538107 | 0.270367068450121 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 206251109908.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T17:50:47.676652Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 583d2680-c3eb-4485-ae11-00bedb02345e | 2026-09-09 15:07 | 2026-09-09 15:07 | 2026-09-09 15:07 | AMGN | AMGN270416C00350000 | call | 350.0000 | 2027-04-16 | 61.3000 | 61.3000 | 62.9000 | 390.6700 | 134861.00 | 0.00 | 134861.00 | 22 | 10 | 23 | 13 | 1.76923076923077 | 0.270947326348955 | 0.271056837553492 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 206251109908.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9864d59c-a8c5-4af0-8474-dac17c764811 | 2026-09-10 10:44 | 2026-09-10 10:44 | 2026-09-10 10:44 | AMGN | AMGN260918P00410000 | put | 410.0000 | 2026-09-18 | 26.1500 | 23.9000 | 27.3500 | 384.4200 | 130768.00 | 130768.00 | 0.00 | 50 | 12 | 57 | 723 | 0.0788381742738589 | 0.331249145028489 | 0.331249145028489 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 206251109908.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T14:57:03.898045Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e03ee649-a00c-4e11-bd3b-2ac7969f04ac | 2026-09-10 12:07 | 2026-09-10 12:07 | 2026-09-10 12:07 | AMGN | AMGN270115C00400000 | call | 400.0000 | 2027-01-15 | 19.9000 | 19.8500 | 20.0000 | 382.7100 | 276610.00 | 266660.00 | 9950.00 | 139 | 20 | 172 | 1359 | 0.126563649742458 | 0.277461894850185 | 0.277461894850185 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 206251109908.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T16:13:08.333814Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e58c02c9-863e-46dd-85be-d4411aa1185e | 2026-09-11 11:50 | 2026-09-11 11:50 | 2026-09-11 11:50 | AMGN | AMGN270115P00365000 | put | 365.0000 | 2027-01-15 | 17.4500 | 17.0500 | 17.4500 | 380.3150 | 94230.00 | 94230.00 | 0.00 | 54 | 20 | 54 | 38 | 1.42105263157895 | 0.302022978340688 | 0.302022978340688 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 206251109908.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T15:53:19.427541Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d66cbef7-ef25-4d25-9dfb-85bc3029ea34 | 2026-09-11 11:50 | 2026-09-11 11:50 | 2026-09-11 11:50 | AMGN | AMGN270115P00350000 | put | 350.0000 | 2027-01-15 | 12.1000 | 11.8000 | 12.1000 | 380.3150 | 77440.00 | 77440.00 | 0.00 | 64 | 22 | 66 | 1206 | 0.054726368159204 | 0.303972495437769 | 0.303972495437769 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 206251109908.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T15:53:19.427541Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d96662fa-b302-43ae-8782-493184491428 | 2026-09-14 09:58 | 2026-09-14 09:58 | 2026-09-14 09:58 | AMGN | AMGN280121C00400000 | call | 400.0000 | 2028-01-21 | 47.4000 | 47.4000 | 51.0000 | 377.1300 | 142200.00 | 0.00 | 142200.00 | 30 | 5 | 30 | 119 | 0.252100840336134 | 0.268303990004442 | 0.268303990004442 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 206251109908.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:00:07.512367Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 56bdcf14-9c02-421f-b005-2222bf59310f | 2026-09-14 10:41 | 2026-09-14 10:41 | 2026-09-14 10:41 | AMGN | AMGN270917C00410000 | call | 410.0000 | 2027-09-17 | 35.6000 | 33.9000 | 35.6500 | 378.1200 | 445000.00 | 267000.00 | 89000.00 | 125 | 5 | 125 | 4 | 31.25 | 0.272508020467601 | 0.272508020467601 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 206251109908.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:43:33.165845Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a316780f-137d-4e94-ae0c-44cfd59d7f3b | 2026-09-14 10:42 | 2026-09-14 10:42 | 2026-09-14 10:42 | AMGN | AMGN270917C00410000 | call | 410.0000 | 2027-09-17 | 35.3000 | 33.9500 | 35.3000 | 377.7650 | 271810.00 | 271810.00 | 0.00 | 77 | 6 | 203 | 4 | 50.75 | 0.271707715677704 | 0.271707715677704 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 206251109908.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:43:33.165845Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 78c84d8b-069c-47f5-9a68-f5a4389516ec | 2026-09-14 10:42 | 2026-09-14 10:42 | 2026-09-14 10:42 | AMGN | AMGN270917C00410000 | call | 410.0000 | 2027-09-17 | 35.2000 | 33.9500 | 35.2000 | 377.6900 | 404800.00 | 404800.00 | 0.00 | 115 | 5 | 481 | 4 | 120.25 | 0.271295991646447 | 0.271295991646447 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 206251109908.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:43:33.165845Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0e9b26ff-1a5a-4e79-9c8c-5ff7da04ad8e | 2026-09-14 10:42 | 2026-09-14 10:42 | 2026-09-14 10:42 | AMGN | AMGN270917C00410000 | call | 410.0000 | 2027-09-17 | 35.2000 | 33.9500 | 35.2000 | 377.6900 | 489280.00 | 489280.00 | 0.00 | 139 | 8 | 343 | 4 | 85.75 | 0.271295991646447 | 0.271295991646447 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 206251109908.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:43:33.165845Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d17d0229-01d3-46f1-a383-a9fbb1ecc29e | 2026-09-14 12:32 | 2026-09-14 12:32 | 2026-09-14 12:32 | AMGN | AMGN261218P00390000 | put | 390.0000 | 2026-12-18 | 26.9500 | 26.0500 | 26.9500 | 380.1800 | 83545.00 | 83545.00 | 0.00 | 31 | 16 | 38 | 92 | 0.41304347826087 | 0.307193791117047 | 0.307193791117047 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 206251109908.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T16:49:37.903150Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aad07935-587d-4f7a-9c36-d340c7e536f9 | 2026-09-14 15:00 | 2026-09-14 15:00 | 2026-09-14 15:00 | AMGN | AMGN261120C00345000 | call | 345.0000 | 2026-11-20 | 42.9500 | 41.4500 | 44.4500 | 379.6950 | 107375.00 | 4295.00 | 103080.00 | 25 | 15 | 25 | 1 | 25 | 0.305257072686688 | 0.305257072686688 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 206251109908.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 619bb0f8-e07a-40db-a37d-71b0b77767df | 2026-09-14 15:01 | 2026-09-14 15:01 | 2026-09-14 15:01 | AMGN | AMGN261023P00380000 | put | 380.0000 | 2026-10-23 | 12.5500 | 11.7000 | 12.5500 | 379.6900 | 72790.00 | 72790.00 | 0.00 | 58 | 17 | 59 | 5 | 11.8 | 0.267242554396019 | 0.267242554396019 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 206251109908.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 47105593-7739-4a1e-bfa9-c3cb7367ef0d | 2026-09-14 15:15 | 2026-09-14 15:15 | 2026-09-14 15:15 | AMGN | AMGN261030C00415000 | call | 415.0000 | 2026-10-30 | 4.0900 | 3.6500 | 4.2000 | 380.0800 | 55246.00 | 55246.00 | 0.00 | 135 | 14 | 144 | 0 | 0 | 0.270140575018215 | 0.269880981135352 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 206251109908.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:19:00.930033Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d636bdd6-c085-43c7-b4b4-4974ede182fb | 2026-09-17 11:13 | 2026-09-17 11:12 | 2026-09-17 11:12 | AMGN | AMGN260918P00390000 | put | 390.0000 | 2026-09-18 | 10.0000 | 8.1000 | 10.0500 | 380.2100 | 103000.00 | 103000.00 | 0.00 | 103 | 6 | 110 | 335 | 0.328358208955224 | 0.344460998403233 | 0.344460998403233 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 205321222859.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 1f7451f3-df6c-47b2-98e3-22ecd66b0595 | 2026-09-17 11:49 | 2026-09-17 11:49 | 2026-09-17 11:49 | AMGN | AMGN261120P00385000 | put | 385.0000 | 2026-11-20 | 20.2500 | 19.4500 | 20.2500 | 382.1100 | 72900.00 | 72900.00 | 0.00 | 36 | 18 | 60 | 106 | 0.566037735849057 | 0.316598703742531 | 0.316598703742531 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 205321222859.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:59:42.981722Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 429e486f-5d6b-4dca-8e84-175fbce15724 | 2026-09-18 10:51 | 2026-09-18 10:51 | 2026-09-18 10:51 | AMGN | AMGN270319P00340000 | put | 340.0000 | 2027-03-19 | 13.9500 | 13.2500 | 14.7000 | 381.8677 | 103222.00 | 68352.00 | 34870.00 | 74 | 10 | 74 | 110 | 0.672727272727273 | 0.327868622625842 | 0.327868622625842 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 208494732728.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| c93bfd4a-2ad8-4bb7-8a57-99818fd05b3f | 2026-09-18 12:02 | 2026-09-18 12:02 | 2026-09-18 12:02 | AMGN | AMGN270319P00340000 | put | 340.0000 | 2027-03-19 | 13.9000 | 13.0000 | 13.9000 | 383.2300 | 77840.00 | 77840.00 | 0.00 | 56 | 19 | 130 | 110 | 1.18181818181818 | 0.331136622501792 | 0.331136622501792 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 208494732728.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T16:02:16.049420Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |