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_alerts658,639 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 |
|---|
| 774b6e1d-f075-45a3-87ef-773b7e9216c9 | 2026-10-01 15:36 | 2026-10-01 15:36 | 2026-10-01 15:36 | MRK | MRK261218P00135000 | put | 135.0000 | 2026-12-18 | 4.8500 | 4.6500 | 4.9000 | 143.3500 | 26190.00 | 485.00 | 25705.00 | 54 | 9 | 131 | 1140 | 0.114912280701754 | 0.345495023376562 | 0.345495023376562 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 354803953261.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-10-01T19:36:48.028615Z"} | 2026-10-01 | 2026-10-01 21:15 | 2026-10-01 21:15 |
| 0859c9ce-4337-42f4-9409-6fbb832e57c6 | 2026-10-01 13:01 | 2026-10-01 13:01 | 2026-10-01 13:01 | MRK | MRK270416P00135000 | put | 135.0000 | 2027-04-16 | 8.7000 | 8.7000 | 8.8500 | 143.8300 | 43500.00 | 0.00 | 43500.00 | 50 | 10 | 59 | 82 | 0.719512195121951 | 0.345871857449008 | 0.345871857449008 | false | false | false | true | ||||||||||||||||
| fef1ccb3-73cc-47d5-a269-8a80306f57b8 | 2026-10-01 11:47 | 2026-10-01 11:47 | 2026-10-01 11:47 | MRK | MRK270617P00130000 | put | 130.0000 | 2027-06-17 | 8.1500 | 8.1500 | 8.2500 | 144.0000 | 17115.00 | 0.00 | 17115.00 | 21 | 7 | 376 | 792 | 0.474747474747475 | 0.349303830419705 | 0.349303830419705 | false | false | false | true | ||||||||||||||||
| 94e67b5b-bcdc-4d28-acbd-b99eed180f5e | 2026-10-01 10:12 | 2026-10-01 10:12 | 2026-10-01 10:12 | MRK | MRK261218C00170000 | call | 170.0000 | 2026-12-18 | 1.9000 | 1.7800 | 2.0100 | 144.6700 | 10642.00 | 3040.00 | 7602.00 | 56 | 8 | 56 | 13527 | 0.0041398684113255 | 0.325078241893554 | 0.326240826014369 | false | false | false | true | ||||||||||||||||
| 91037e20-14cb-4ec0-b330-432919bc04c2 | 2026-10-01 09:50 | 2026-10-01 09:50 | 2026-10-01 09:50 | MRK | MRK261016C00155000 | call | 155.0000 | 2026-10-16 | 0.5100 | 0.5100 | 0.6600 | 144.5800 | 35139.00 | 0.00 | 35139.00 | 689 | 42 | 701 | 6682 | 0.104908709967076 | 0.285146888984031 | 0.285146888984031 | false | false | false | true | ||||||||||||||||
| 66f3bfd4-ece9-4c86-adb6-671a0c689670 | 2026-09-30 16:00 | 2026-09-30 15:59 | 2026-09-30 15:59 | MRK | MRK261218C00160000 | call | 160.0000 | 2026-12-18 | 3.9500 | 3.9500 | 4.2000 | 145.0000 | 14615.00 | 0.00 | 14615.00 | 37 | 6 | 52 | 1694 | 0.0306965761511216 | 0.320615018201486 | 0.320615018201486 | true | false | false | true | ||||||||||||||||
| 07e6587e-89ad-4b46-b52e-853ed2c150b7 | 2026-09-30 12:30 | 2026-09-30 12:30 | 2026-09-30 12:30 | MRK | MRK261030C00160000 | call | 160.0000 | 2026-10-30 | 1.9900 | 1.7600 | 1.9900 | 146.4600 | 39800.00 | 39800.00 | 0.00 | 200 | 21 | 2225 | 135 | 16.4814814814815 | 0.373992188084836 | 0.373992188084836 | true | false | false | true | ||||||||||||||||
| 3faded9f-f0d9-4e40-a589-5b322b4f9857 | 2026-09-30 11:25 | 2026-09-30 11:24 | 2026-09-30 11:24 | MRK | MRK271217P00135000 | put | 135.0000 | 2027-12-17 | 12.7500 | 12.5500 | 13.1500 | 147.4000 | 11475.00 | 1275.00 | 10200.00 | 9 | 7 | 9 | 98 | 0.0918367346938776 | 0.356506616842041 | 0.356506616842041 | false | false | false | true | ||||||||||||||||
| f13b1484-9fe5-4087-8824-d8db14d83702 | 2026-09-29 15:56 | 2026-09-29 15:56 | 2026-09-29 15:56 | MRK | MRK261120P00155000 | put | 155.0000 | 2026-11-20 | 10.4000 | 10.1500 | 10.6500 | 149.1550 | 90460.00 | 89420.00 | 0.00 | 87 | 12 | 87 | 335 | 0.259701492537313 | 0.337123048365868 | 0.337123048365868 | false | false | false | true | ||||||||||||||||
| e2620528-e739-47e0-b987-2aae3ca15ef5 | 2026-09-29 15:53 | 2026-09-29 15:53 | 2026-09-29 15:53 | MRK | MRK261016C00145000 | call | 145.0000 | 2026-10-16 | 6.1500 | 6.1000 | 6.6500 | 149.0800 | 55355.00 | 620.00 | 54735.00 | 90 | 9 | 114 | 2347 | 0.0485726459309757 | 0.281391921157931 | 0.285839184072035 | false | false | false | true | ||||||||||||||||
| d9029b05-7d4a-498b-8641-0ac7e1ec2e6a | 2026-09-29 15:53 | 2026-09-29 15:53 | 2026-09-29 15:53 | MRK | MRK261002P00148000 | put | 148.0000 | 2026-10-02 | 1.2000 | 1.0400 | 1.2500 | 149.0800 | 92040.00 | 10080.00 | 5760.00 | 767 | 59 | 781 | 243 | 3.21399176954733 | 0.3175065677659 | 0.3175065677659 | true | false | false | true | ||||||||||||||||
| e93c3852-7dcf-44dc-988d-befc9f0ec4e4 | 2026-09-29 14:47 | 2026-09-29 14:47 | 2026-09-29 14:47 | MRK | MRK280121C00195000 | call | 195.0000 | 2028-01-21 | 9.6000 | 9.3000 | 9.6000 | 148.8100 | 24000.00 | 24000.00 | 0.00 | 25 | 5 | 26 | 252 | 0.103174603174603 | 0.301527398854639 | 0.301527398854639 | false | false | false | true | ||||||||||||||||
| b7053f9b-cb31-4988-9438-b9fd9549c557 | 2026-09-29 14:46 | 2026-09-29 14:46 | 2026-09-29 14:46 | MRK | MRK261016P00150000 | put | 150.0000 | 2026-10-16 | 4.0000 | 3.9000 | 4.0000 | 148.8450 | 18000.00 | 18000.00 | 0.00 | 45 | 9 | 63 | 1742 | 0.0361653272101033 | 0.275968365388779 | 0.275968365388779 | false | false | false | true | ||||||||||||||||
| 4ede3ee4-f314-4510-a75c-39be5c4b4471 | 2026-09-29 13:10 | 2026-09-29 13:10 | 2026-09-29 13:10 | MRK | MRK280121C00185000 | call | 185.0000 | 2028-01-21 | 11.4500 | 11.1500 | 11.5000 | 148.3300 | 45800.00 | 42365.00 | 1145.00 | 40 | 18 | 76 | 21 | 3.61904761904762 | 0.297636941789881 | 0.298405591024825 | true | false | false | true | ||||||||||||||||
| d038b966-f7ee-461e-bf5e-bc809dffb2bd | 2026-09-29 12:52 | 2026-09-29 12:52 | 2026-09-29 12:52 | MRK | MRK280121C00185000 | call | 185.0000 | 2028-01-21 | 11.4000 | 11.1000 | 11.4000 | 148.3050 | 37620.00 | 37620.00 | 0.00 | 33 | 10 | 36 | 21 | 1.71428571428571 | 0.297016398485239 | 0.297016398485239 | false | false | false | true | ||||||||||||||||
| 2f611fc5-45f9-4290-b9b9-9b7dfad23e24 | 2026-09-29 10:26 | 2026-09-29 10:26 | 2026-09-29 10:26 | MRK | MRK261002P00143000 | put | 143.0000 | 2026-10-02 | 0.5100 | 0.5000 | 0.5300 | 146.8050 | 14007.00 | 3657.00 | 10350.00 | 276 | 23 | 277 | 1302 | 0.212749615975422 | 0.34553088991614 | 0.34553088991614 | false | false | false | true | ||||||||||||||||
| 126fa752-cf49-4626-a125-9985a22330ab | 2026-09-29 10:23 | 2026-09-29 10:22 | 2026-09-29 10:22 | MRK | MRK261016C00150000 | call | 150.0000 | 2026-10-16 | 2.4000 | 2.3200 | 2.4000 | 146.8201 | 77760.00 | 77760.00 | 0.00 | 324 | 6 | 508 | 5608 | 0.0905848787446505 | 0.287412990161998 | 0.287412990161998 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 354803953261.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T17:02:28.084506Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 354803953261.00 |
| 2026-10-29 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T15:50:21.814834Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 354803953261.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T14:13:32.059410Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 354803953261.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:52:25.864426Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 368299382121.00 |
| 2026-10-29 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 368299382121.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T16:34:30.603445Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 368299382121.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T15:27:52.116479Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 368299382121.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:57:26.018295Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 368299382121.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:53:48.849377Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 368299382121.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:53:48.849377Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 368299382121.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:53:35.621722Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 368299382121.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:53:35.621722Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 368299382121.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:16:24.150546Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 368299382121.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:54:42.907148Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 368299382121.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:27:05.819137Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 368299382121.00 |
| 2026-10-29 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:23:29.656550Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |