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 | expirydate | price |
|---|
| 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 |
|---|
| 04ec46eb-1edc-46eb-b5d7-b0f7db276343 | 2026-09-14 10:49 | 2026-09-14 10:49 | 2026-09-14 10:49 | EOG | EOG260918C00130000 | call | 130.0000 | 2026-09-18 | 21.1000 | 20.6000 | 21.1000 | 151.1163 | 202560.00 | 23210.00 | 0.00 | 96 | 19 | 619 | 8665 | 0.0714368147720715 | 0.572628404608172 | 0.572628404608172 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 77913563803.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a88c0077-fe70-4a31-8bd9-df771b02262e | 2026-09-14 10:48 | 2026-09-14 10:48 | 2026-09-14 10:48 | EOG | EOG260918C00130000 | call | 130.0000 | 2026-09-18 | 21.2000 | 21.0000 | 21.2000 | 151.2150 | 59360.00 | 2120.00 | 0.00 | 28 | 18 | 506 | 8665 | 0.0583958453548759 | 0.626132125944322 | 0.626132125944322 | false | false | false | true | false | |||||||||||||||
| 724af1c6-52ef-44c2-a9ce-e9e3aeea7b15 | 2026-09-14 10:48 | 2026-09-14 10:48 | 2026-09-14 10:48 | EOG | EOG260918C00130000 | call | 130.0000 | 2026-09-18 | 21.3000 | 21.0000 | 21.3000 | 151.3700 | 236430.00 | 236430.00 | 0.00 | 111 | 33 | 467 | 8665 | 0.0538949798038084 | 0.626132125944322 | 0.626132125944322 | true | false | false | true | false | |||||||||||||||
| 3a4a8b35-326a-468b-bbf9-d9b70728ce5a | 2026-09-14 10:48 | 2026-09-14 10:48 | 2026-09-14 10:48 | EOG | EOG260918C00130000 | call | 130.0000 | 2026-09-18 | 21.4000 | 20.7000 | 21.4000 | 151.4900 | 104860.00 | 104860.00 | 0.00 | 49 | 14 | 356 | 8665 | 0.0410848240046163 | 0.626132125944322 | 0.626132125944322 | false | false | false | true | false | |||||||||||||||
| 6af8fb69-c355-4ad4-aa74-b332c1be5253 | 2026-09-14 10:48 | 2026-09-14 10:48 | 2026-09-14 10:48 | EOG | EOG260918C00130000 | call | 130.0000 | 2026-09-18 | 21.5000 | 20.3000 | 21.5000 | 151.4900 | 111800.00 | 53750.00 | 0.00 | 52 | 17 | 307 | 8665 | 0.0354298903635314 | 0.626132125944322 | 0.626132125944322 | true | false | false | true | false | |||||||||||||||
| 3bed9b8f-436c-44cc-8a32-6c2e70842a5b | 2026-09-14 10:21 | 2026-09-14 10:21 | 2026-09-14 10:21 | EOG | EOG260918C00130000 | call | 130.0000 | 2026-09-18 | 21.0000 | 20.0000 | 21.9000 | 150.0000 | 235200.00 | 235200.00 | 0.00 | 112 | 21 | 253 | 8665 | 0.029197922677438 | 0.602673126403342 | 0.602673126403342 | false | false | false | true | false | |||||||||||||||
| f1c427c5-ce43-4acc-9547-e8932c29198b | 2026-09-14 10:21 | 2026-09-14 10:21 | 2026-09-14 10:21 | EOG | EOG260918C00130000 | call | 130.0000 | 2026-09-18 | 21.0000 | 19.7000 | 21.0000 | 150.0000 | 289800.00 | 289800.00 | 0.00 | 138 | 52 | 141 | 8665 | 0.0162723600692441 | 0.514776710660118 | 0.514776710660118 | true | false | false | true | false | |||||||||||||||
| a60f6d91-904a-49f5-8939-403c4560ef29 | 2026-09-10 10:41 | 2026-09-10 10:41 | 2026-09-10 10:41 | EOG | EOG261016C00160000 | call | 160.0000 | 2026-10-16 | 1.2500 | 1.2000 | 1.4000 | 144.3800 | 105030.00 | 526.00 | 104504.00 | 840 | 8 | 911 | 3447 | 0.264287786480998 | 0.320915614126525 | 0.320915614126525 | false | false | false | true | false | |||||||||||||||
| 428fb417-8580-4e8a-91b9-d44fd3b0eaaa | 2026-09-04 12:01 | 2026-09-04 12:01 | 2026-09-04 12:01 | EOG | EOG260918C00150000 | call | 150.0000 | 2026-09-18 | 1.4300 | 1.4000 | 1.8000 | 145.2900 | 83375.00 | 54955.00 | 28420.00 | 582 | 25 | 2642 | 3315 | 0.796983408748115 | 0.273213070149385 | 0.273213070149385 | false | false | false | true | false | |||||||||||||||
| 55b206a6-bd28-45dc-90c9-1650ce9a09c8 | 2026-09-04 10:49 | 2026-09-04 10:49 | 2026-09-04 10:49 | EOG | EOG261016C00155000 | call | 155.0000 | 2026-10-16 | 2.6500 | 2.6500 | 2.8500 | 145.7300 | 85065.00 | 0.00 | 85065.00 | 321 | 20 | 325 | 887 | 0.366403607666291 | 0.295030004253853 | 0.295030004253853 | false | false | false | true | false | |||||||||||||||
| 637abc20-731c-499d-9a4b-0d7c338b592c | 2026-09-02 12:17 | 2026-09-02 12:17 | 2026-09-02 12:17 | EOG | EOG270416P00155000 | put | 155.0000 | 2027-04-16 | 17.4000 | 16.8000 | 17.9000 | 148.4700 | 215760.00 | 85260.00 | 130500.00 | 124 | 16 | 124 | 0 | 0 | 0.343147662465583 | 0.343147662465583 | false | false | false | true | false | |||||||||||||||
| 5548f1b9-e146-407b-9450-fbce5588aead | 2026-08-24 10:57 | 2026-08-24 10:57 | 2026-08-24 10:57 | EOG | EOG270319P00150000 | put | 150.0000 | 2027-03-19 | 13.0000 | 11.6000 | 13.5000 | 150.4750 | 50700.00 | 13000.00 | 37700.00 | 39 | 14 | 39 | 41 | 0.951219512195122 | 0.333701280497153 | 0.333701280497153 | false | false | false | true | false | |||||||||||||||
| b3408a53-a541-43e1-831e-47a43177f5c1 | 2026-08-19 13:29 | 2026-08-19 13:29 | 2026-08-19 13:29 | EOG | EOG260918C00130000 | call | 130.0000 | 2026-09-18 | 20.6000 | 20.1000 | 20.6000 | 149.9500 | 407880.00 | 150380.00 | 0.00 | 198 | 30 | 2168 | 10679 | 0.203015263601461 | 0.306544723246649 | 0.306544723246649 | false | false | false | true | false | |||||||||||||||
| 5903d6d3-6cc4-46e2-a047-aa9f76fae005 | 2026-08-19 13:28 | 2026-08-19 13:28 | 2026-08-19 13:28 | EOG | EOG260918C00130000 | call | 130.0000 | 2026-09-18 | 20.7000 | 20.6000 | 20.7000 | 150.1200 | 579600.00 | 35190.00 | 0.00 | 280 | 44 | 1750 | 10679 | 0.163873021818522 | 0.289271257208985 | 0.289271257208985 | false | false | false | true | false | |||||||||||||||
| 4bff7628-8ba7-4bdb-b42f-392d399a978c | 2026-08-19 13:28 | 2026-08-19 13:28 | 2026-08-19 13:28 | EOG | EOG260918C00130000 | call | 130.0000 | 2026-09-18 | 20.7000 | 20.6000 | 22.3000 | 150.1200 | 455400.00 | 302220.00 | 153180.00 | 220 | 6 | 1970 | 10679 | 0.184474201704279 | 0.289271257208985 | 0.289271257208985 | false | false | false | true | false | |||||||||||||||
| dcb3a520-b380-4f67-a281-6395200727b2 | 2026-08-19 13:24 | 2026-08-19 13:24 | 2026-08-19 13:24 | EOG | EOG260918C00130000 | call | 130.0000 | 2026-09-18 | 21.0000 | 20.6000 | 21.0000 | 150.3300 | 147000.00 | 147000.00 | 0.00 | 70 | 14 | 1462 | 10679 | 0.136904204513531 | 0.31563158440213 | 0.31563158440213 | false | false | false | true | false | |||||||||||||||
| 284b9c2e-8e4a-4fd3-87c8-ab635d6d340c | 2026-08-19 13:24 | 2026-08-19 13:24 | 2026-08-19 13:24 | EOG | EOG260918C00130000 | call | 130.0000 | 2026-09-18 | 21.0000 | 20.6000 | 22.6000 | 150.4100 | 764400.00 | 92400.00 | 480900.00 | 364 | 64 | 1366 | 10679 | 0.127914598745201 | 0.201248742403504 | 0.295307112887004 | true | false | false | true | false | |||||||||||||||
| bdeb0a5c-3395-48c3-8c82-6527dd44dd21 | 2026-08-19 13:24 | 2026-08-19 13:24 | 2026-08-19 13:24 | EOG | EOG260918C00130000 | call | 130.0000 | 2026-09-18 | 21.0000 | 20.9000 | 22.6000 | 150.5750 | 527100.00 | 390600.00 | 136500.00 | 251 | 5 | 1002 | 10679 | 0.0938290102069482 | 0.215740292503005 | 0.215740292503005 | false | false | false | true | false | |||||||||||||||
| 65529bf4-513d-48f6-85fb-86d136d6db44 | 2026-08-19 13:24 | 2026-08-19 13:24 | 2026-08-19 13:24 | EOG | EOG260918C00130000 | call | 130.0000 | 2026-09-18 | 21.0000 | 20.8000 | 21.0000 | 150.5700 | 483000.00 | 98700.00 | 0.00 | 230 | 38 | 732 | 10679 | 0.0685457439835191 | 0.360981976441942 | 0.221208681454873 | false | false | false | true | false | |||||||||||||||
| 05f5a610-39d0-4906-b495-3fd34077ce7c | 2026-08-19 13:24 | 2026-08-19 13:24 | 2026-08-19 13:24 | EOG | EOG260918C00130000 | call | 130.0000 | 2026-09-18 | 21.0000 | 21.0000 | 21.1000 | 150.7900 | 283500.00 | 0.00 | 151200.00 | 135 | 9 | 502 | 10679 | 0.0470081468302275 | 0.360981976441942 | 0.360981976441942 | false | false | false | true | false | |||||||||||||||
| 6ed5a348-9773-429c-8bd0-e2080d7e8b40 | 2026-08-19 13:24 | 2026-08-19 13:24 | 2026-08-19 13:24 | EOG | EOG260918C00130000 | call | 130.0000 | 2026-09-18 | 21.0000 | 20.4000 | 21.0000 | 150.9400 | 766500.00 | 2100.00 | 0.00 | 365 | 69 | 367 | 10679 | 0.034366513718513 | 0.360981976441942 | 0.360981976441942 | false | false | false | true | false | |||||||||||||||
| 9450deae-c18e-4a90-917e-eaa25aa4c8c9 | 2026-08-18 15:37 | 2026-08-18 15:36 | 2026-08-18 15:36 | EOG | EOG260918C00155000 | call | 155.0000 | 2026-09-18 | 3.1000 | 2.8500 | 3.1000 | 148.6900 | 51454.00 | 51454.00 | 0.00 | 166 | 35 | 223 | 4575 | 0.0487431693989071 | 0.313631820256768 | 0.313631820256768 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:57:03.898045Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:13:56.145626Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:19:14.278097Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:09:19.758040Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 77913563803.00 |
| 2026-11-05 |
| unknown |
| — |
| 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 |