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_alerts326,449 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 |
|---|
| 2a7b1e26-4350-431d-a20d-7cf2b5d77ac4 | 2026-09-22 11:07 | 2026-09-22 11:07 | 2026-09-22 11:07 | MRK | MRK261218C00170000 | call | 170.0000 | 2026-12-18 | 3.4600 | 3.4500 | 3.6500 | 152.0000 | 81215.00 | 0.00 | 81215.00 | 235 | 11 | 2635 | 10885 | 0.242076251722554 | 0.301548631043204 | 0.299910382238977 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 372320871891.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T15:10:39.659738Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| a199b990-a545-48f2-9da3-10dc388c8b65 | 2026-09-22 10:31 | 2026-09-22 10:31 | 2026-09-22 10:31 | MRK | MRK261002C00155000 | call | 155.0000 | 2026-10-02 | 1.1900 | 0.8800 | 1.2300 | 150.7500 | 40329.00 | 20231.00 | 20098.00 | 339 | 8 | 346 | 488 | 0.709016393442623 | 0.275249241306489 | 0.274070857436629 | true | false | false | true | ||||||||||||||||
| c580ba7a-1468-4d04-8cf5-e8356c136ae9 | 2026-09-21 10:45 | 2026-09-21 10:45 | 2026-09-21 10:45 | MRK | MRK261016C00145000 | call | 145.0000 | 2026-10-16 | 6.8400 | 6.5500 | 6.8500 | 148.7250 | 68390.00 | 56060.00 | 0.00 | 100 | 17 | 114 | 2073 | 0.0549927641099855 | 0.293534221756985 | 0.289337692399159 | false | false | false | true | ||||||||||||||||
| 502013f0-8e75-44bb-990b-70aec8f47ce3 | 2026-09-04 15:19 | 2026-09-04 15:19 | 2026-09-04 15:19 | MRK | MRK270319C00185000 | call | 185.0000 | 2027-03-19 | 4.6000 | 4.4000 | 4.6000 | 150.2400 | 55192.00 | 55192.00 | 0.00 | 120 | 19 | 139 | 1404 | 0.099002849002849 | 0.317619462171329 | 0.317619462171329 | false | false | false | true | ||||||||||||||||
| 9d2b0671-a2f6-4665-b4ea-436deafa415e | 2026-08-31 12:38 | 2026-08-31 12:37 | 2026-08-31 12:37 | MRK | MRK261120C00160000 | call | 160.0000 | 2026-11-20 | 4.4500 | 4.4000 | 4.6000 | 147.9290 | 58720.00 | 0.00 | 49920.00 | 132 | 7 | 1751 | 773 | 2.26520051746442 | 0.303220980499849 | 0.305964879929253 | false | false | false | true | ||||||||||||||||
| 9fc63904-8433-48c4-bcd2-5c1edb305993 | 2026-08-31 11:44 | 2026-08-31 11:44 | 2026-08-31 11:44 | MRK | MRK261120C00160000 | call | 160.0000 | 2026-11-20 | 4.5300 | 4.5000 | 4.6000 | 147.9500 | 81566.00 | 54101.00 | 27465.00 | 180 | 22 | 1404 | 773 | 1.81630012936611 | 0.308813110785697 | 0.308813110785697 | false | false | false | true | ||||||||||||||||
| 8d783f43-e142-409b-b23e-ea0f46fc816a | 2026-08-25 10:02 | 2026-08-25 10:02 | 2026-08-25 10:02 | MRK | MRK261016P00150000 | put | 150.0000 | 2026-10-16 | 5.2000 | 5.0000 | 5.2000 | 153.5600 | 84232.00 | 84232.00 | 0.00 | 162 | 25 | 169 | 1269 | 0.13317572892041 | 0.314946478466708 | 0.314946478466708 | false | false | false | true | ||||||||||||||||
| 79141bfc-948d-4397-b94e-f2448705e6c1 | 2026-08-24 14:21 | 2026-08-24 14:21 | 2026-08-24 14:21 | MRK | MRK260828C00152500 | call | 152.5000 | 2026-08-28 | 1.2400 | 1.2100 | 1.3600 | 150.5200 | 52369.00 | 5996.00 | 46373.00 | 422 | 11 | 645 | 568 | 1.13556338028169 | 0.32699921477781 | 0.323611304194669 | false | false | false | true | ||||||||||||||||
| 8e959c65-b033-418a-a0fd-0e1721ca490d | 2026-08-24 13:19 | 2026-08-24 13:19 | 2026-08-24 13:19 | MRK | MRK260918C00150000 | call | 150.0000 | 2026-09-18 | 4.9500 | 4.6000 | 5.0000 | 151.3000 | 892957.00 | 890982.00 | 1975.00 | 1804 | 53 | 1871 | 4700 | 0.398085106382979 | 0.262274721603656 | 0.25781008502923 | true | false | false | true | ||||||||||||||||
| 840050c9-de2e-4eec-af55-ccc984c4bc7f | 2026-08-24 12:37 | 2026-08-24 12:36 | 2026-08-24 12:36 | MRK | MRK260918C00165000 | call | 165.0000 | 2026-09-18 | 0.6000 | 0.5700 | 0.7800 | 150.8000 | 88089.00 | 580.00 | 84716.00 | 1477 | 109 | 1675 | 28213 | 0.0593697940665651 | 0.270875209706296 | 0.270170635063808 | true | false | false | true | ||||||||||||||||
| 8d50835b-1177-45c1-80e0-88e41db67dc0 | 2026-08-21 11:30 | 2026-08-21 11:30 | 2026-08-21 11:30 | MRK | MRK261016P00160000 | put | 160.0000 | 2026-10-16 | 11.1800 | 10.8500 | 11.2500 | 153.4650 | 97300.00 | 82770.00 | 14530.00 | 87 | 8 | 97 | 0 | 0 | 0.333655848974988 | 0.327257998924916 | true | false | false | true | ||||||||||||||||
| 3916f623-ebea-420c-87a5-65aa6b613325 | 2026-08-21 11:23 | 2026-08-21 11:23 | 2026-08-21 11:23 | MRK | MRK260918C00165000 | call | 165.0000 | 2026-09-18 | 1.6000 | 1.6400 | 1.7800 | 154.0300 | 396574.00 | 0.00 | 396574.00 | 2476 | 15 | 2514 | 1979 | 1.27033855482567 | 0.302396619159425 | 0.302396619159425 | true | false | false | true | ||||||||||||||||
| 662c6e6a-7558-4f4b-8a3e-33e61f5bec90 | 2026-08-21 10:36 | 2026-08-21 10:36 | 2026-08-21 10:36 | MRK | MRK270617C00175000 | call | 175.0000 | 2027-06-17 | 11.2000 | 10.6500 | 11.3500 | 153.2150 | 57120.00 | 51570.00 | 5550.00 | 51 | 6 | 52 | 74 | 0.702702702702703 | 0.31317006731741 | 0.312247370909735 | true | false | false | true | ||||||||||||||||
| 06a368a5-92fc-473e-8c5d-109a80ba3868 | 2026-08-19 11:09 | 2026-08-19 11:09 | 2026-08-19 11:09 | MRK | MRK260918P00145000 | put | 145.0000 | 2026-09-18 | 3.4500 | 3.4000 | 3.5000 | 149.5700 | 118700.00 | 60900.00 | 57800.00 | 344 | 5 | 492 | 3 | 164 | 0.336626420570245 | 0.336626420570245 | false | false | false | true | ||||||||||||||||
| 10a9b62a-d951-4461-897c-4ad2659e029f | 2026-08-19 10:41 | 2026-08-19 10:40 | 2026-08-19 10:40 | MRK | MRK270319C00180000 | call | 180.0000 | 2027-03-19 | 5.9000 | 5.4000 | 5.9000 | 149.8650 | 474229.00 | 473644.00 | 585.00 | 804 | 44 | 1125 | 50 | 22.5 | 0.315822918193809 | 0.315860213716828 | true | false | false | true | ||||||||||||||||
| ca7a1aa1-a6f8-435f-9f11-e80509ac15da | 2026-08-19 09:30 | 2026-08-19 09:30 | 2026-08-19 09:30 | MRK | MRK260918C00140000 | call | 140.0000 | 2026-09-18 | 10.0200 | 9.9000 | 11.4500 | 148.5800 | 54124.00 | 50000.00 | 4124.00 | 54 | 8 | 381 | 13469 | 0.0282871779642141 | 0.268013728882731 | 0.268013728882731 | false | false | false | true | ||||||||||||||||
| 9ffa26f6-3efb-4800-aa28-df900093e9fd | 2026-08-18 09:45 | 2026-08-18 09:45 | 2026-08-18 09:45 | MRK | MRK261016C00130000 | call | 130.0000 | 2026-10-16 | 10.5300 | 10.5000 | 10.7500 | 137.0000 | 91571.00 | 0.00 | 91571.00 | 87 | 12 | 104 | 4011 | 0.0259286960857641 | 0.24023279869114 | 0.24023279869114 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 372320871891.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:31:31.654153Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 368842159881.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:47:49.730853Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 357369811764.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 357369811764.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:39:59.140702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 357369811764.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 357369811764.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:12:03.649618Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 357369811764.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:49:58.488781Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 357369811764.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T17:47:44.554262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 357369811764.00 |
| 2026-10-29 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 357369811764.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:38:28.521674Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 357369811764.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:38:28.521674Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 357369811764.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 357369811764.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 357369811764.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:50:22.027850Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 357369811764.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 357369811764.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |