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 |
|---|
| 6793028b-d732-42bc-b71a-9b26e360d9d2 | 2026-09-30 15:06 | 2026-09-30 15:05 | 2026-09-30 15:05 | CVX | CVX270115C00230000 | call | 230.0000 | 2027-01-15 | 4.1500 | 4.1500 | 4.2500 | 205.6852 | 57713.00 | 0.00 | 57713.00 | 139 | 28 | 180 | 5506 | 0.0326916091536506 | 0.255560753133055 | 0.255560753133055 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 403808132980.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T19:08:45.785033Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| d2e089fc-d547-4ce7-968b-e0c31d19717a | 2026-09-29 15:33 | 2026-09-29 15:33 | 2026-09-29 15:33 | CVX | CVX270115C00230000 | call | 230.0000 | 2027-01-15 | 3.8000 | 3.7500 | 3.8000 | 204.0150 | 10640.00 | 10640.00 | 0.00 | 28 | 17 | 145 | 5448 | 0.0266152716593245 | 0.256025176600575 | 0.256025176600575 | false | false | false | true | false | |||||||||||||||
| d81c4825-524f-45db-9213-3a7f093bfdb3 | 2026-09-28 15:33 | 2026-09-28 15:33 | 2026-09-28 15:33 | CVX | CVX270115C00230000 | call | 230.0000 | 2027-01-15 | 4.4000 | 4.2000 | 4.4000 | 205.8700 | 33440.00 | 33440.00 | 0.00 | 76 | 10 | 214 | 5389 | 0.0397105214325478 | 0.25829870419848 | 0.25829870419848 | false | false | false | true | false | |||||||||||||||
| 65d3872b-7eca-4c4e-af80-495800b0e93e | 2026-09-23 15:33 | 2026-09-23 15:33 | 2026-09-23 15:33 | CVX | CVX270115C00230000 | call | 230.0000 | 2027-01-15 | 4.4500 | 4.3000 | 4.4500 | 205.1500 | 18690.00 | 18690.00 | 0.00 | 42 | 10 | 291 | 5296 | 0.0549471299093656 | 0.258438999446795 | 0.258438999446795 | false | false | false | true | false | |||||||||||||||
| 0462b0fb-ab18-46ae-afb8-0128f3a3f59f | 2026-09-21 15:28 | 2026-09-21 15:27 | 2026-09-21 15:27 | CVX | CVX270115C00230000 | call | 230.0000 | 2027-01-15 | 4.2000 | 4.2000 | 4.3500 | 203.8450 | 23100.00 | 0.00 | 23100.00 | 55 | 17 | 861 | 4710 | 0.182802547770701 | 0.258072136516724 | 0.258347788451775 | false | false | false | true | false | |||||||||||||||
| cb2db664-665e-4c0f-8d08-3fb1c955008a | 2026-09-21 15:07 | 2026-09-21 15:07 | 2026-09-21 15:07 | CVX | CVX270115C00230000 | call | 230.0000 | 2027-01-15 | 4.4500 | 4.4000 | 4.5000 | 204.9600 | 16020.00 | 13795.00 | 2225.00 | 36 | 9 | 775 | 4710 | 0.164543524416136 | 0.257307191161108 | 0.257307191161108 | false | false | false | true | false | |||||||||||||||
| 34a282b9-20ed-4b20-ac01-7fb17ced56e3 | 2026-09-21 13:42 | 2026-09-21 13:42 | 2026-09-21 13:42 | CVX | CVX270115C00230000 | call | 230.0000 | 2027-01-15 | 4.3400 | 4.2500 | 4.3500 | 204.3100 | 10857.00 | 10857.00 | 0.00 | 25 | 5 | 542 | 4710 | 0.115074309978769 | 0.259178132152502 | 0.259178132152502 | false | false | false | true | false | |||||||||||||||
| ac1487c7-b293-4879-891d-e4fbd07a7708 | 2026-09-21 11:58 | 2026-09-21 11:57 | 2026-09-21 11:57 | CVX | CVX270115C00230000 | call | 230.0000 | 2027-01-15 | 4.7000 | 4.6500 | 4.7000 | 206.0050 | 100580.00 | 470.00 | 0.00 | 214 | 54 | 266 | 4710 | 0.0564755838641189 | 0.256468123645533 | 0.256468123645533 | true | false | false | true | false | |||||||||||||||
| 4409e40f-7647-4868-8750-832538cc6ee1 | 2026-09-21 11:58 | 2026-09-21 11:57 | 2026-09-21 11:57 | CVX | CVX270115C00230000 | call | 230.0000 | 2027-01-15 | 4.7000 | 4.7000 | 4.7000 | 206.0050 | 23970.00 | 0.00 | 0.00 | 51 | 9 | 317 | 4710 | 0.0673036093418259 | 0.256468123645533 | 0.256468123645533 | false | false | false | true | false | |||||||||||||||
| 2b2168af-9565-4c5f-ab19-beab7dc8abd3 | 2026-09-17 11:07 | 2026-09-17 11:07 | 2026-09-17 11:07 | CVX | CVX270115C00230000 | call | 230.0000 | 2027-01-15 | 6.6000 | 6.5500 | 6.6000 | 210.6350 | 177540.00 | 660.00 | 0.00 | 269 | 69 | 280 | 4579 | 0.0611487224284778 | 0.262907289862552 | 0.262907289862552 | false | false | false | true | false | |||||||||||||||
| a5012dcd-5aa0-4d0a-b013-65960c32b12a | 2026-09-01 15:07 | 2026-09-01 15:07 | 2026-09-01 15:07 | CVX | CVX270115C00230000 | call | 230.0000 | 2027-01-15 | 6.7600 | 6.7000 | 6.8500 | 209.9900 | 50675.00 | 0.00 | 50675.00 | 75 | 6 | 240 | 2848 | 0.0842696629213483 | 0.255471358507375 | 0.255684873357143 | false | false | false | true | false | |||||||||||||||
| 57432003-b06c-43c4-8642-666e3bc73d95 | 2026-08-19 10:11 | 2026-08-19 10:11 | 2026-08-19 10:11 | CVX | CVX270115C00230000 | call | 230.0000 | 2027-01-15 | 6.3700 | 5.8000 | 6.4500 | 207.4200 | 63731.00 | 63731.00 | 0.00 | 100 | 14 | 100 | 2677 | 0.0373552484124019 | 0.248858699678458 | 0.248858699678458 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 403808132980.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:36:36.492519Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 407739917815.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:36:53.342339Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 406040754520.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:37:14.904379Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 402405335376.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:30:17.874351Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 402405335376.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:10:48.404426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 402405335376.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:43:51.748700Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 402405335376.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:00:04.115943Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 402405335376.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:00:04.115943Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 418013928440.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T19:21:20.162349Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 419199391205.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |