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
active:ticker = ALMS×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28d03075-7a0d-4ef6-bc55-47f4ed855468 | 2026-09-16 12:53 | 2026-09-16 12:53 | 2026-09-16 12:53 | ALMS | ALMS270416C00017000 | call | 17.0000 | 2027-04-16 | 0.7000 | 0.6500 | 0.8000 | 7.9500 | 16800.00 | 0.00 | 2660.00 | 240 | 5 | 252 | 2200 | 0.114545454545455 | 0.977340015733592 | 0.977340015733592 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1027715798.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 62c98d80-09ae-4d1f-ad18-240963c5ecbc | 2026-09-02 12:54 | 2026-09-02 12:54 | 2026-09-02 12:54 | ALMS | ALMS270115C00011000 | call | 11.0000 | 2027-01-15 | 2.2000 | 1.9000 | 2.2000 | 10.4800 | 19360.00 | 19360.00 | 0.00 | 88 | 5 | 100 | 0 | 0 | 0.930680779479912 | 0.930680779479912 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T16:56:20.498446Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5318bf12-5514-41c1-aaca-de4422637f42 | 2026-09-02 10:15 | 2026-09-02 10:15 | 2026-09-02 10:15 | ALMS | ALMS260918C00011000 | call | 11.0000 | 2026-09-18 | 1.0500 | 0.6000 | 1.0500 | 10.5562 | 15645.00 | 15645.00 | 0.00 | 149 | 6 | 363 | 5 | 72.6 | 1.39609395395753 | 1.39609395395753 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T14:25:30.485375Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 564c260e-281a-4057-a9ec-e8f3262f367a | 2026-09-01 13:29 | 2026-09-01 13:29 | 2026-09-01 13:29 | ALMS | ALMS270416C00022000 | call | 22.0000 | 2027-04-16 | 0.7000 | 0.5000 | 0.7000 | 9.1600 | 11760.00 | 11760.00 | 0.00 | 168 | 13 | 312 | 10 | 31.2 | 0.976666526602584 | 0.976666526602584 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T17:48:11.364966Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d164dd51-3aae-40fb-a6df-82fc94348ba1 | 2026-09-01 11:33 | 2026-09-01 11:33 | 2026-09-01 11:33 | ALMS | ALMS261016C00010000 | call | 10.0000 | 2026-10-16 | 0.9500 | 0.6500 | 0.9500 | 9.2050 | 38000.00 | 38000.00 | 0.00 | 400 | 12 | 505 | 3 | 168.333333333333 | 0.966022544323971 | 0.966022544323971 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T15:45:30.323966Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 03aae275-4f7d-4db2-b1a7-af8a33e406e8 | 2026-09-01 11:26 | 2026-09-01 11:25 | 2026-09-01 11:25 | ALMS | ALMS261016P00008000 | put | 8.0000 | 2026-10-16 | 0.6500 | 0.6500 | 0.7000 | 9.1486 | 11380.00 | 0.00 | 11380.00 | 175 | 25 | 1777 | 2 | 888.5 | 0.963255767557849 | 0.963255767557849 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T15:45:30.323966Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 156b461a-ff46-4640-b59e-e99e3c6ce239 | 2026-09-01 11:25 | 2026-09-01 11:25 | 2026-09-01 11:25 | ALMS | ALMS261016P00008000 | put | 8.0000 | 2026-10-16 | 0.6500 | 0.5500 | 0.7000 | 9.2000 | 20605.00 | 520.00 | 3510.00 | 317 | 16 | 1592 | 2 | 796 | 0.976498210025121 | 0.976498210025121 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T15:45:30.323966Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c93bda20-1429-4a53-844f-342f35e6db71 | 2026-09-01 09:35 | 2026-09-01 09:35 | 2026-09-01 09:35 | ALMS | ALMS260918P00012000 | put | 12.0000 | 2026-09-18 | 2.0000 | 1.7500 | 3.1000 | 10.8546 | 40000.00 | 2000.00 | 2400.00 | 200 | 6 | 200 | 741 | 0.269905533063428 | 1.39514777629467 | 1.39514777629467 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T13:44:23.259187Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ed07f555-76b9-48cc-8701-dd4ad0dfa6f2 | 2026-08-27 14:41 | 2026-08-27 14:41 | 2026-08-27 14:41 | ALMS | ALMS260918P00020000 | put | 20.0000 | 2026-09-18 | 3.7000 | 3.3000 | 3.8000 | 23.3400 | 156136.00 | 147256.00 | 8880.00 | 422 | 53 | 442 | 6134 | 0.0720573850668406 | 2.49673191287052 | 2.5055767008873 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 460c57e0-4e83-488b-a3f6-bbf42ac4acc5 | 2026-08-24 15:35 | 2026-08-24 15:35 | 2026-08-24 15:35 | ALMS | ALMS260918P00012000 | put | 12.0000 | 2026-09-18 | 1.4000 | 0.9500 | 1.4000 | 23.2450 | 28000.00 | 2240.00 | 0.00 | 200 | 12 | 225 | 0 | 0 | 3.01189269618068 | 3.01189269618068 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T19:47:47.207382Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f4d7f8ed-defe-4d18-82ee-4ea107c70538 | 2026-08-24 12:15 | 2026-08-24 12:15 | 2026-08-24 12:15 | ALMS | ALMS260918P00022000 | put | 22.0000 | 2026-09-18 | 5.3000 | 4.9000 | 5.4000 | 22.7800 | 93262.00 | 90612.00 | 0.00 | 176 | 23 | 223 | 518 | 0.43050193050193 | 2.48878653295543 | 2.48878653295543 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T16:44:07.615841Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d5144ab5-9029-4aa1-86ca-589e9e0bb6d9 | 2026-08-24 12:13 | 2026-08-24 12:13 | 2026-08-24 12:13 | ALMS | ALMS260918P00015000 | put | 15.0000 | 2026-09-18 | 2.0000 | 2.0000 | 2.1000 | 22.7000 | 15000.00 | 0.00 | 13000.00 | 75 | 75 | 264 | 147 | 1.79591836734694 | 2.59468667931907 | 2.59468667931907 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T16:14:40.561585Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 09742373-7a8a-4dd6-abe5-589f4880f9dd | 2026-08-24 12:13 | 2026-08-24 12:13 | 2026-08-24 12:13 | ALMS | ALMS260918P00015000 | put | 15.0000 | 2026-09-18 | 2.0000 | 2.0000 | 2.0500 | 22.7000 | 15800.00 | 0.00 | 15800.00 | 79 | 6 | 343 | 147 | 2.33333333333333 | 2.59468667931907 | 2.59468667931907 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T16:14:40.561585Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d93d5987-3f52-4e28-b51b-4310af4df55e | 2026-08-21 15:59 | 2026-08-21 15:59 | 2026-08-21 15:59 | ALMS | ALMS260918C00035000 | call | 35.0000 | 2026-09-18 | 3.4000 | 3.0000 | 3.5000 | 24.1800 | 62900.00 | 44200.00 | 18700.00 | 185 | 21 | 2671 | 967 | 2.76215098241986 | 2.39285074379944 | 2.39285074379944 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fbe351b5-44cc-498c-9de6-a8593df9b1dd | 2026-08-21 15:49 | 2026-08-21 15:49 | 2026-08-21 15:49 | ALMS | ALMS260918C00040000 | call | 40.0000 | 2026-09-18 | 2.6000 | 0.8500 | 2.6000 | 24.0700 | 65000.00 | 65000.00 | 0.00 | 250 | 21 | 250 | 92 | 2.71739130434783 | 2.41113853100956 | 2.41113853100956 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cab191ba-a92c-40cb-9645-5ced42942fb4 | 2026-08-21 14:55 | 2026-08-21 14:55 | 2026-08-21 14:55 | ALMS | ALMS260918C00030000 | call | 30.0000 | 2026-09-18 | 4.2000 | 4.0000 | 4.2000 | 24.0650 | 62578.00 | 62578.00 | 0.00 | 149 | 38 | 530 | 7047 | 0.075209308925784 | 2.30171903618792 | 2.30171903618792 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:11:44.414359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f376c9e2-7686-4088-aea1-47eff6950c8e | 2026-08-21 14:34 | 2026-08-21 14:34 | 2026-08-21 14:34 | ALMS | ALMS260918P00020000 | put | 20.0000 | 2026-09-18 | 4.0000 | 3.5000 | 4.0000 | 23.8000 | 30400.00 | 30400.00 | 0.00 | 76 | 5 | 531 | 5626 | 0.0943832207607536 | 2.41898565022252 | 2.41898565022252 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bfc6b388-4eaa-4ba2-904a-549e3ee1954a | 2026-08-21 14:33 | 2026-08-21 14:33 | 2026-08-21 14:33 | ALMS | ALMS260918C00035000 | call | 35.0000 | 2026-09-18 | 2.8500 | 2.0000 | 3.1000 | 23.7500 | 598500.00 | 598500.00 | 0.00 | 2100 | 3 | 2104 | 967 | 2.17580144777663 | 2.24425951466364 | 2.24425951466364 | false | true | false | true | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c38ccf8f-e34a-4adb-bcfb-2edd695ff753 | 2026-08-21 12:54 | 2026-08-21 12:53 | 2026-08-21 12:53 | ALMS | ALMS260918C00025000 | call | 25.0000 | 2026-09-18 | 5.2000 | 3.7000 | 5.2000 | 23.6450 | 18720.00 | 18720.00 | 0.00 | 36 | 16 | 37 | 70 | 0.528571428571429 | 2.20249076748115 | 2.20249076748115 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 67edc6a8-a48f-4101-8d8b-46ad865643ce | 2026-08-20 11:10 | 2026-08-20 11:10 | 2026-08-20 11:10 | ALMS | ALMS260918C00030000 | call | 30.0000 | 2026-09-18 | 3.1000 | 3.1000 | 3.4000 | 22.5300 | 23251.00 | 0.00 | 23251.00 | 75 | 23 | 76 | 2776 | 0.0273775216138329 | 2.11072442515007 | 2.11072442515007 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:16:49.821442Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3e594415-f99b-4bdf-aff8-d16f436cd61c | 2026-08-19 09:39 | 2026-08-19 09:39 | 2026-08-19 09:39 | ALMS | ALMS260918P00025000 | put | 25.0000 | 2026-09-18 | 6.1000 | 5.8000 | 6.3000 | 25.3670 | 43310.00 | 31720.00 | 2440.00 | 71 | 14 | 72 | 820 | 0.0878048780487805 | 2.23523351642836 | 2.23523351642836 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 27093811-2013-42a5-95a4-1788fad1bb13 | 2026-08-18 09:33 | 2026-08-18 09:33 | 2026-08-18 09:33 | ALMS | ALMS260918P00025000 | put | 25.0000 | 2026-09-18 | 6.1000 | 6.1000 | 6.8000 | 25.3200 | 41480.00 | 0.00 | 41480.00 | 68 | 16 | 68 | 752 | 0.0904255319148936 | 2.19347164343382 | 2.19347164343382 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fcefd025-1cf1-4323-99ee-2e803a59501b | 2026-08-17 11:46 | 2026-08-17 11:46 | 2026-08-17 11:46 | ALMS | ALMS260918P00025000 | put | 25.0000 | 2026-09-18 | 6.1000 | 6.1000 | 6.5000 | 25.5700 | 14640.00 | 0.00 | 14640.00 | 24 | 7 | 24 | 728 | 0.032967032967033 | 2.19146346745447 | 2.19146346745447 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 1193392904.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |