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_alerts609,118 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 |
|---|
| 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 |
|---|
| 88ea34c5-6015-4e55-befe-d46fbccd20f1 | 2026-08-20 12:22 | 2026-08-20 12:22 | 2026-08-20 12:22 | MRK | MRK261016C00155000 | call | 155.0000 | 2026-10-16 | 5.2500 | 5.0500 | 5.2500 | 151.1100 | 108666.00 | 108666.00 | 0.00 | 207 | 14 | 345 | 414 | 0.833333333333333 | 0.275724280156598 | 0.275724280156598 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 357369811764.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T16:44:56.732853Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4a22727f-664b-495d-9055-45f230eac2e9 | 2026-08-21 11:30 | 2026-08-21 11:30 | 2026-08-21 11:30 | MRK | MRK261016C00155000 | call | 155.0000 | 2026-10-16 | 6.5000 | 6.4500 | 6.6500 | 153.4650 | 143037.00 | 13000.00 | 127437.00 | 220 | 26 | 378 | 695 | 0.543884892086331 | 0.283676604505048 | 0.283676604505048 | false | false | false | true | ||||||||||||||||
| 4b0e450c-a043-4700-b16d-a26071b00edd | 2026-09-04 12:52 | 2026-09-04 12:52 | 2026-09-04 12:52 | MRK | MRK261016C00155000 | call | 155.0000 | 2026-10-16 | 3.5000 | 3.5000 | 3.5500 | 150.2000 | 57400.00 | 0.00 | 57400.00 | 164 | 27 | 1144 | 3174 | 0.360428481411468 | 0.257388824230642 | 0.257388824230642 | false | false | false | true | ||||||||||||||||
| 7d54aca7-4063-4251-9a07-2518728e0d22 | 2026-09-04 13:03 | 2026-09-04 13:03 | 2026-09-04 13:03 | MRK | MRK261016C00155000 | call | 155.0000 | 2026-10-16 | 3.6000 | 3.5500 | 3.6000 | 150.3300 | 52560.00 | 52560.00 | 0.00 | 146 | 20 | 1309 | 3174 | 0.412413358538122 | 0.259842672199651 | 0.259842672199651 | false | false | false | true | ||||||||||||||||
| 200ef31c-07b4-4cf9-8e5b-1780d874dc1b | 2026-09-21 11:22 | 2026-09-21 11:22 | 2026-09-21 11:22 | MRK | MRK261016C00155000 | call | 155.0000 | 2026-10-16 | 2.0000 | 2.0000 | 2.0800 | 148.7400 | 42800.00 | 0.00 | 42800.00 | 214 | 5 | 408 | 4651 | 0.0877230703074608 | 0.271911039222389 | 0.271911039222389 | false | false | false | true | ||||||||||||||||
| b0f47af1-0c74-47f8-bd6e-11faad3d2097 | 2026-09-21 12:23 | 2026-09-21 12:23 | 2026-09-21 12:23 | MRK | MRK261016C00155000 | call | 155.0000 | 2026-10-16 | 2.0000 | 2.0000 | 2.1900 | 149.0300 | 76801.00 | 0.00 | 76600.00 | 384 | 5 | 2042 | 4651 | 0.439045366587831 | 0.265382859425583 | 0.265382859425583 | false | false | false | true | ||||||||||||||||
| 6799feae-5ada-42a1-9b07-af6c5a004d80 | 2026-09-22 11:12 | 2026-09-22 11:12 | 2026-09-22 11:12 | MRK | MRK261016C00155000 | call | 155.0000 | 2026-10-16 | 3.5900 | 3.3000 | 3.6000 | 152.9000 | 107805.00 | 107805.00 | 0.00 | 300 | 8 | 409 | 6307 | 0.0648485809418107 | 0.279236062618272 | 0.279588409222767 | false | false | false | true | ||||||||||||||||
| b5aad4e6-3f44-4fc5-84fc-4624ac48d3ab | 2026-09-23 13:11 | 2026-09-23 13:10 | 2026-09-23 13:10 | MRK | MRK261016C00155000 | call | 155.0000 | 2026-10-16 | 1.4600 | 1.3300 | 1.4600 | 147.3650 | 29116.00 | 29116.00 | 0.00 | 200 | 5 | 746 | 6699 | 0.111359904463353 | 0.271642019519915 | 0.270793250029541 | false | false | false | true | ||||||||||||||||
| fd555d8a-d70f-4b39-be71-a23751e7e566 | 2026-09-23 13:11 | 2026-09-23 13:11 | 2026-09-23 13:11 | MRK | MRK261016C00155000 | call | 155.0000 | 2026-10-16 | 1.4900 | 1.4000 | 1.4900 | 147.0000 | 14751.00 | 14751.00 | 0.00 | 99 | 5 | 855 | 6699 | 0.127630989699955 | 0.272359140183643 | 0.272359140183643 | false | false | false | true | ||||||||||||||||
| 5593deea-b340-4d81-83ac-695add4cf094 | 2026-09-25 12:53 | 2026-09-25 12:53 | 2026-09-25 12:53 | MRK | MRK261016C00155000 | call | 155.0000 | 2026-10-16 | 1.3500 | 1.3400 | 1.5500 | 147.5500 | 124479.00 | 4726.00 | 119753.00 | 922 | 55 | 1082 | 7008 | 0.15439497716895 | 0.267869996518389 | 0.271868489671871 | false | false | false | true | ||||||||||||||||
| 62132bd3-c8dc-4bfb-b14e-e670eac6d770 | 2026-09-25 15:34 | 2026-09-25 15:34 | 2026-09-25 15:34 | MRK | MRK261016C00155000 | call | 155.0000 | 2026-10-16 | 1.6800 | 1.6500 | 1.7100 | 148.6050 | 10920.00 | 8904.00 | 0.00 | 65 | 8 | 1358 | 7008 | 0.193778538812785 | 0.275345306254426 | 0.275345306254426 | false | false | false | true | ||||||||||||||||
| bbe0aed7-b86a-41f6-a4a9-6123edeeba10 | 2026-09-25 15:35 | 2026-09-25 15:35 | 2026-09-25 15:35 | MRK | MRK261016C00155000 | call | 155.0000 | 2026-10-16 | 1.6800 | 1.6500 | 1.7400 | 148.6350 | 14784.00 | 12936.00 | 1848.00 | 88 | 6 | 1469 | 7008 | 0.209617579908676 | 0.274639389796981 | 0.274639389796981 | false | false | false | true | ||||||||||||||||
| 5cbe14ce-c26f-4b00-a7be-2002493acc01 | 2026-09-28 14:49 | 2026-09-28 14:49 | 2026-09-28 14:49 | MRK | MRK261016C00155000 | call | 155.0000 | 2026-10-16 | 1.6600 | 1.4700 | 1.6700 | 149.0701 | 24888.00 | 11608.00 | 0.00 | 150 | 5 | 660 | 6926 | 0.0952930984695351 | 0.282268177274465 | 0.284919893837724 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 357369811764.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:07:55.847311Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 357369811764.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:07:55.847311Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 368842159881.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:22:54.080611Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 368842159881.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:25:44.384112Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 372320871891.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:15:45.651673Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 365338776155.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:11:20.356460Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 365338776155.00 |
| 2026-10-29 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:17:19.986908Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 367065796302.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:59:29.985705Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 367065796302.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:35:55.847824Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 367065796302.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:35:55.847824Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 366843750854.00 |
| 2026-10-29 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T18:52:01.773916Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |