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 |
|---|
| 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 |
|---|
| 2a84abe6-7555-4189-b07e-c52a1eed3aa3 | 2026-08-18 10:06 | 2026-08-18 10:06 | 2026-08-18 10:06 | MOH | MOH260918P00210000 | put | 210.0000 | 2026-09-18 | 11.5000 | 11.5000 | 12.1000 | 206.0200 | 14950.00 | 0.00 | 14950.00 | 13 | 5 | 50 | 162 | 0.308641975308642 | 0.404536859833748 | 0.404536859833748 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 11174454000.00 | 2026-10-21 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0d8e83a6-2de3-40d6-aaae-f33126baf9cc | 2026-08-18 14:39 | 2026-08-18 14:38 | 2026-08-18 14:38 | MOH | MOH261218P00195000 | put | 195.0000 | 2026-12-18 | 15.3000 | 14.6000 | 15.3000 | 206.3000 | 32129.00 | 32129.00 | 0.00 | 21 | 8 | 82 | 92 | 0.891304347826087 | 0.469675128421065 | 0.469675128421065 | true | false | false | true | ||||||||||||||||
| bc5a7b30-ba30-4316-9c55-c447825cb8cb | 2026-08-18 15:27 | 2026-08-18 15:27 | 2026-08-18 15:27 | MOH | MOH260821C00210000 | call | 210.0000 | 2026-08-21 | 1.7000 | 1.4500 | 2.1000 | 205.9350 | 20402.00 | 0.00 | 20402.00 | 120 | 29 | 129 | 330 | 0.390909090909091 | 0.44203298187903 | 0.44203298187903 | false | false | false | true | ||||||||||||||||
| 3db329b1-8913-435e-8855-352fed036c61 | 2026-08-19 14:06 | 2026-08-19 14:06 | 2026-08-19 14:06 | MOH | MOH261218C00230000 | call | 230.0000 | 2026-12-18 | 12.1000 | 11.5000 | 12.1000 | 202.0350 | 10890.00 | 10890.00 | 0.00 | 9 | 6 | 9 | 87 | 0.103448275862069 | 0.456615442907347 | 0.456615442907347 | false | false | false | true | ||||||||||||||||
| e27197ac-a5a6-44a8-a7b8-fea511fcc22b | 2026-08-20 11:02 | 2026-08-20 11:02 | 2026-08-20 11:02 | MOH | MOH260918P00200000 | put | 200.0000 | 2026-09-18 | 7.9000 | 7.9000 | 8.5000 | 200.6150 | 87690.00 | 0.00 | 87690.00 | 111 | 33 | 113 | 218 | 0.518348623853211 | 0.377786510579378 | 0.377786510579378 | false | false | false | true | ||||||||||||||||
| 577e9042-81f9-4d13-8f37-df9f9f6d5e99 | 2026-08-21 14:53 | 2026-08-21 14:52 | 2026-08-21 14:52 | MOH | MOH261218C00240000 | call | 240.0000 | 2026-12-18 | 9.3000 | 8.2000 | 9.3000 | 200.9850 | 55800.00 | 55800.00 | 0.00 | 60 | 20 | 60 | 72 | 0.833333333333333 | 0.462381519459535 | 0.462381519459535 | false | false | false | true | ||||||||||||||||
| b4bbc9c7-51a6-4735-a3df-67a861198249 | 2026-08-28 11:06 | 2026-08-28 11:05 | 2026-08-28 11:05 | MOH | MOH261218P00180000 | put | 180.0000 | 2026-12-18 | 11.2000 | 10.0000 | 12.1000 | 199.0600 | 12320.00 | 8960.00 | 3360.00 | 11 | 5 | 29 | 144 | 0.201388888888889 | 0.48306025714767 | 0.48306025714767 | false | false | false | true | ||||||||||||||||
| c7ad433b-a617-47b1-9b5d-7ebdfacd7ec4 | 2026-08-31 09:43 | 2026-08-31 09:43 | 2026-08-31 09:43 | MOH | MOH260918P00195000 | put | 195.0000 | 2026-09-18 | 5.3000 | 4.4000 | 5.6000 | 200.9700 | 107590.00 | 107060.00 | 530.00 | 203 | 23 | 206 | 176 | 1.17045454545455 | 0.461144498369622 | 0.461144498369622 | true | false | false | true | ||||||||||||||||
| 32911f0d-7222-469b-9c34-f1b7fcbef441 | 2026-08-31 09:43 | 2026-08-31 09:43 | 2026-08-31 09:43 | MOH | MOH260918P00195000 | put | 195.0000 | 2026-09-18 | 6.1000 | 4.4000 | 6.8000 | 200.9700 | 29890.00 | 29890.00 | 0.00 | 49 | 16 | 259 | 176 | 1.47159090909091 | 0.508943527024745 | 0.508943527024745 | false | false | false | true | ||||||||||||||||
| cbbc1710-e00a-4070-a330-d8f1bd4bfe4f | 2026-08-31 11:58 | 2026-08-31 11:58 | 2026-08-31 11:58 | MOH | MOH261016P00175000 | put | 175.0000 | 2026-10-16 | 2.9500 | 2.9500 | 3.5000 | 198.4600 | 12685.00 | 0.00 | 12685.00 | 43 | 14 | 45 | 53 | 0.849056603773585 | 0.422696174563761 | 0.422696174563761 | false | false | false | true | ||||||||||||||||
| 0fedc2e4-a696-4f85-87ab-1d6ea788bbbe | 2026-09-01 14:25 | 2026-09-01 14:25 | 2026-09-01 14:25 | MOH | MOH261218C00250000 | call | 250.0000 | 2026-12-18 | 6.9000 | 6.2000 | 6.9000 | 203.1800 | 29670.00 | 29670.00 | 0.00 | 43 | 14 | 47 | 47 | 1 | 0.459294629863921 | 0.459294629863921 | false | false | false | true | ||||||||||||||||
| 01b08ae9-a1f9-40be-bb16-8141fc3ceb7d | 2026-09-01 14:25 | 2026-09-01 14:25 | 2026-09-01 14:25 | MOH | MOH261218P00180000 | put | 180.0000 | 2026-12-18 | 9.6000 | 8.4000 | 9.6000 | 203.5350 | 39360.00 | 39360.00 | 0.00 | 41 | 10 | 47 | 171 | 0.274853801169591 | 0.481399029550634 | 0.481399029550634 | false | false | false | true | ||||||||||||||||
| 103b084b-fa24-4b92-81e2-b8c209cbe596 | 2026-09-09 09:57 | 2026-09-09 09:56 | 2026-09-09 09:56 | MOH | MOH260918P00190000 | put | 190.0000 | 2026-09-18 | 5.0000 | 0.2500 | 5.0000 | 190.3600 | 21500.00 | 21500.00 | 0.00 | 43 | 13 | 43 | 166 | 0.259036144578313 | 0.442206888129534 | 0.442206888129534 | true | false | false | true | ||||||||||||||||
| f77cd7d1-5596-47b7-9aaf-a40595c6bb2b | 2026-09-16 09:31 | 2026-09-16 09:31 | 2026-09-16 09:31 | MOH | MOH260918C00210000 | call | 210.0000 | 2026-09-18 | 1.3500 | 1.3500 | 2.7500 | 206.0100 | 10127.00 | 0.00 | 10127.00 | 75 | 29 | 111 | 437 | 0.254004576659039 | 0.473250762725107 | 0.473250762725107 | false | false | false | true | ||||||||||||||||
| 76f1eb28-ec09-44ec-bb97-c350ca1d40cf | 2026-09-17 15:32 | 2026-09-17 15:32 | 2026-09-17 15:32 | MOH | MOH261016P00210000 | put | 210.0000 | 2026-10-16 | 10.7000 | 9.2000 | 10.8000 | 207.2800 | 23540.00 | 22470.00 | 0.00 | 22 | 9 | 25 | 63 | 0.396825396825397 | 0.411544474720787 | 0.411544474720787 | false | false | false | true | ||||||||||||||||
| 0c92be60-b3e0-4205-88bb-a9bcb1cd954f | 2026-09-25 11:20 | 2026-09-25 11:19 | 2026-09-25 11:19 | MOH | MOH261218P00180000 | put | 180.0000 | 2026-12-18 | 9.9000 | 9.5000 | 10.5000 | 194.8200 | 11880.00 | 0.00 | 11880.00 | 12 | 5 | 29 | 199 | 0.14572864321608 | 0.474959785370205 | 0.474959785370205 | false | false | false | true | ||||||||||||||||
| 555a4f67-881d-46e1-b413-8d39b6912adb | 2026-09-29 14:50 | 2026-09-29 14:50 | 2026-09-29 14:50 | MOH | MOH261120C00195000 | call | 195.0000 | 2026-11-20 | 12.4000 | 11.3000 | 12.4000 | 187.6000 | 22320.00 | 22320.00 | 0.00 | 18 | 10 | 30 | 181 | 0.165745856353591 | 0.534295695186957 | 0.534295695186957 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11174454000.00 |
| 2026-10-21 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:49:07.657249Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11174454000.00 |
| 2026-10-21 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11174454000.00 |
| 2026-10-21 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11174454000.00 |
| 2026-10-21 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:02:58.462752Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11174454000.00 |
| 2026-10-21 |
| postmarket |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11174454000.00 |
| 2026-10-21 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T15:11:58.135920Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11174454000.00 |
| 2026-10-21 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11174454000.00 |
| 2026-10-21 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11174454000.00 |
| 2026-10-21 |
| postmarket |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11174454000.00 |
| 2026-10-21 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T18:40:09.958238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11174454000.00 |
| 2026-10-21 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T18:40:09.958238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 11174454000.00 |
| 2026-10-21 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:57:31.693440Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10555884000.00 |
| 2026-10-21 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:33:11.249350Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10705698000.00 |
| 2026-10-21 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 9962892000.00 |
| 2026-10-21 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:25:06.221939Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 9885636000.00 |
| 2026-10-21 |
| postmarket |
| — |
| 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 |