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.
Simplify Analyticsuw_flow_alerts474,253 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 |
|---|
| 7e479dba-557b-4f3b-9fd8-ed4c37b69887 | 2026-08-19 15:03 | 2026-08-19 15:03 | 2026-08-19 15:03 | CVX | CVX270115C00210000 | call | 210.0000 | 2027-01-15 | 12.5000 | 12.5000 | 12.6500 | 206.3300 | 57500.00 | 0.00 | 57500.00 | 46 | 11 | 341 | 12028 | 0.0283505154639175 | 0.240754564675642 | 0.240754564675642 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 419199391205.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6f4d403c-3ef8-4970-b709-83ad4caa3a07 | 2026-08-19 15:03 | 2026-08-19 15:03 | 2026-08-19 15:03 | CVX | CVX270115C00210000 | call | 210.0000 | 2027-01-15 | 12.5000 | 12.5000 | 12.5500 | 206.3000 | 72500.00 | 0.00 | 72500.00 | 58 | 14 | 262 | 12028 | 0.0217825074825407 | 0.241055572898134 | 0.241055572898134 | false | false | false | true | ||||||||||||||||
| 0eb62ed2-a245-47d5-9f36-214e70c337a3 | 2026-08-19 15:03 | 2026-08-19 15:03 | 2026-08-19 15:03 | CVX | CVX270115C00210000 | call | 210.0000 | 2027-01-15 | 12.5000 | 12.5000 | 12.6000 | 206.3300 | 130000.00 | 0.00 | 130000.00 | 104 | 25 | 204 | 12028 | 0.0169604256734287 | 0.240754564675642 | 0.240754564675642 | false | false | false | true | ||||||||||||||||
| 54672902-04b5-4896-9477-0059d4ded705 | 2026-08-19 14:50 | 2026-08-19 14:50 | 2026-08-19 14:50 | CVX | CVX260821C00190000 | call | 190.0000 | 2026-08-21 | 17.0000 | 15.4500 | 18.0000 | 206.8800 | 51000.00 | 51000.00 | 0.00 | 30 | 15 | 100 | 720 | 0.138888888888889 | 0.58709403780793 | 0.58709403780793 | false | false | false | true | ||||||||||||||||
| c9873af4-b66b-4ea7-b83b-70f4290167c6 | 2026-08-19 10:52 | 2026-08-19 10:52 | 2026-08-19 10:52 | CVX | CVX260904P00205000 | put | 205.0000 | 2026-09-04 | 3.4500 | 3.2500 | 3.4500 | 206.8500 | 114540.00 | 114540.00 | 0.00 | 332 | 28 | 332 | 5 | 66.4 | 0.259515112452221 | 0.259515112452221 | false | false | false | true | ||||||||||||||||
| 83ac0b80-4117-475e-9fd8-a5276ca0d68d | 2026-08-19 09:47 | 2026-08-19 09:47 | 2026-08-19 09:47 | CVX | CVX260911P00205000 | put | 205.0000 | 2026-09-11 | 4.4000 | 4.4000 | 4.9500 | 206.1500 | 88445.00 | 0.00 | 88445.00 | 201 | 6 | 201 | 47 | 4.27659574468085 | 0.251842005707536 | 0.251842005707536 | false | false | false | true | ||||||||||||||||
| df296caa-b373-4097-81f8-1d4f85860341 | 2026-08-18 14:57 | 2026-08-18 14:57 | 2026-08-18 14:57 | CVX | CVX260821P00202500 | put | 202.5000 | 2026-08-21 | 1.7500 | 1.7500 | 1.8600 | 205.2100 | 94252.00 | 17952.00 | 76300.00 | 538 | 45 | 957 | 105 | 9.11428571428571 | 0.397502217213485 | 0.397502217213485 | false | false | false | true | ||||||||||||||||
| d252b7c0-53f3-4679-9abd-8ad416e4f88c | 2026-08-18 10:33 | 2026-08-18 10:32 | 2026-08-18 10:32 | CVX | CVX280121C00260000 | call | 260.0000 | 2028-01-21 | 10.0000 | 9.9000 | 10.0000 | 204.7500 | 83000.00 | 83000.00 | 0.00 | 83 | 6 | 142 | 274 | 0.518248175182482 | 0.236005217796985 | 0.236005217796985 | false | false | false | true | ||||||||||||||||
| 6c8a96f5-d8fc-4ebf-b59c-0a38a865bfa8 | 2026-08-17 14:34 | 2026-08-17 14:34 | 2026-08-17 14:34 | CVX | CVX261120C00200000 | call | 200.0000 | 2026-11-20 | 12.5500 | 12.3000 | 12.7000 | 203.4000 | 97890.00 | 16315.00 | 81575.00 | 78 | 8 | 112 | 329 | 0.340425531914894 | 0.235269467492801 | 0.235269467492801 | false | false | false | true | ||||||||||||||||
| e700b422-26ae-421d-9c44-98f1f35f9fc6 | 2026-08-17 14:23 | 2026-08-17 14:23 | 2026-08-17 14:23 | CVX | CVX260918C00185000 | call | 185.0000 | 2026-09-18 | 18.4000 | 18.2000 | 18.6500 | 203.2708 | 51520.00 | 33120.00 | 18400.00 | 28 | 5 | 338 | 5180 | 0.0652509652509653 | 0.176191610804111 | 0.176191610804111 | false | false | false | true | ||||||||||||||||
| aa56f9a9-c86c-4c54-8e86-ec51afe83fe8 | 2026-08-17 14:17 | 2026-08-17 14:17 | 2026-08-17 14:17 | CVX | CVX270617C00210000 | call | 210.0000 | 2027-06-17 | 16.8500 | 16.4000 | 16.9500 | 203.0400 | 84270.00 | 44070.00 | 0.00 | 50 | 5 | 61 | 2041 | 0.0298873101420872 | 0.230414227083361 | 0.230414227083361 | false | false | false | true | ||||||||||||||||
| 5a49ebee-026c-492e-ba8b-73450aa94469 | 2026-08-17 12:38 | 2026-08-17 12:38 | 2026-08-17 12:38 | CVX | CVX260918C00210000 | call | 210.0000 | 2026-09-18 | 2.7300 | 2.6700 | 2.7400 | 201.8000 | 69069.00 | 68797.00 | 272.00 | 253 | 26 | 790 | 9207 | 0.0858042793526664 | 0.235774756273707 | 0.235878070002804 | false | false | false | true | ||||||||||||||||
| 9416ef84-5179-4940-93b0-de3cb1d5ad10 | 2026-08-17 12:33 | 2026-08-17 12:33 | 2026-08-17 12:33 | CVX | CVX270617C00220000 | call | 220.0000 | 2027-06-17 | 12.4000 | 12.1000 | 12.4000 | 201.7400 | 63240.00 | 63240.00 | 0.00 | 51 | 6 | 63 | 2023 | 0.0311418685121107 | 0.230826104658329 | 0.230826104658329 | false | false | false | true | ||||||||||||||||
| 69b2e5a5-448d-4f60-8ebf-e8766eb755d9 | 2026-08-17 11:42 | 2026-08-17 11:42 | 2026-08-17 11:42 | CVX | CVX260821C00190000 | call | 190.0000 | 2026-08-21 | 11.2500 | 11.1000 | 11.2500 | 201.1800 | 112500.00 | 112500.00 | 0.00 | 100 | 6 | 203 | 4056 | 0.0500493096646943 | 0.287994054247288 | 0.287994054247288 | true | false | false | true | ||||||||||||||||
| 3980f9c4-24f5-4d45-aedc-06ee004f02ac | 2026-08-17 11:00 | 2026-08-17 11:00 | 2026-08-17 11:00 | CVX | CVX260821P00200000 | put | 200.0000 | 2026-08-21 | 2.7600 | 2.6400 | 2.7600 | 201.0100 | 181607.00 | 181607.00 | 0.00 | 658 | 59 | 823 | 369 | 2.23035230352304 | 0.391519378017807 | 0.391519378017807 | false | false | false | true | ||||||||||||||||
| c5982f0c-72d5-4cdb-b17d-ab975162d6ce | 2026-08-17 10:21 | 2026-08-17 10:21 | 2026-08-17 10:21 | CVX | CVX270617C00195000 | call | 195.0000 | 2027-06-17 | 21.0000 | 20.9500 | 23.4000 | 201.6800 | 210000.00 | 2100.00 | 73500.00 | 100 | 21 | 101 | 975 | 0.103589743589744 | 0.190169728017237 | 0.190169728017237 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:50:14.094967Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T19:23:50.384726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |