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 |
|---|
| eabb078b-5ca7-4458-974b-3524a86430f9 | 2026-09-22 15:42 | 2026-09-22 15:42 | 2026-09-22 15:42 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 21.7000 | 21.2000 | 21.7000 | 377.5600 | 23870.00 | 10850.00 | 0.00 | 11 | 11 | 776 | 796 | 0.974874371859296 | 0.542223292257428 | 0.542223292257428 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 108588962642.00 | 2026-10-22 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| d876e914-e6c2-45b9-aa7a-8ba2608003d6 | 2026-09-22 15:42 | 2026-09-22 15:42 | 2026-09-22 15:42 | VLO | VLO261016C00390000 | call | 390.0000 | 2026-10-16 | 16.2500 | 16.0000 | 16.3000 | 377.7900 | 21120.00 | 21120.00 | 0.00 | 13 | 6 | 103 | 298 | 0.345637583892617 | 0.544386860457642 | 0.544386860457642 | false | false | false | true | false | |||||||||||||||
| 8871ac3e-9087-4c1a-99c5-03b75643a865 | 2026-09-22 15:47 | 2026-09-22 15:47 | 2026-09-22 15:47 | VLO | VLO261016P00300000 | put | 300.0000 | 2026-10-16 | 1.2800 | 0.8500 | 1.7000 | 377.9800 | 211200.00 | 128700.00 | 82500.00 | 1650 | 2 | 5200 | 2658 | 1.95635816403311 | 0.580844262841976 | 0.580844262841976 | false | true | false | true | false | |||||||||||||||
| 10950924-cde1-4d7f-a15a-dc0a81b632b5 | 2026-09-22 15:47 | 2026-09-22 15:40 | 2026-09-22 15:47 | VLO | VLO261016P00300000 | put | 300.0000 | 2026-10-16 | 1.3000 | 0.0000 | 0.0000 | 377.9800 | 275901.00 | 137020.00 | 87661.00 | 2148 | 39 | 5200 | 2658 | 1.95635816403311 | 0 | 0 | true | true | false | true | false | |||||||||||||||
| dd7b88df-bb8b-4ad4-8e0b-03ffd2877e34 | 2026-09-22 15:48 | 2026-09-22 15:48 | 2026-09-22 15:48 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 21.6000 | 21.3000 | 21.6000 | 377.5550 | 21600.00 | 6480.00 | 0.00 | 10 | 10 | 816 | 796 | 1.0251256281407 | 0.539569322505196 | 0.539569322505196 | false | false | false | true | false | |||||||||||||||
| caa6a7cf-2a05-4fb8-9d90-df03a175bc7d | 2026-09-22 15:48 | 2026-09-22 15:48 | 2026-09-22 15:48 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 21.8000 | 21.4000 | 21.8000 | 377.6200 | 13080.00 | 6540.00 | 0.00 | 6 | 6 | 822 | 796 | 1.03266331658291 | 0.545565376408013 | 0.545565376408013 | false | false | false | true | false | |||||||||||||||
| 4d769b07-3346-4234-8a59-0a5dc1c8fd79 | 2026-09-22 15:51 | 2026-09-22 15:51 | 2026-09-22 15:51 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 22.1000 | 20.9000 | 22.1000 | 376.8000 | 33150.00 | 30940.00 | 0.00 | 15 | 6 | 852 | 796 | 1.07035175879397 | 0.54301512486764 | 0.54301512486764 | false | false | false | true | false | |||||||||||||||
| f9c5a848-697c-48ac-ad58-5d0075e74d4e | 2026-09-22 15:55 | 2026-09-22 15:55 | 2026-09-22 15:55 | VLO | VLO260925P00375000 | put | 375.0000 | 2026-09-25 | 7.3000 | 6.6000 | 7.3000 | 377.0000 | 20440.00 | 20440.00 | 0.00 | 28 | 8 | 1762 | 1308 | 1.34709480122324 | 0.611832840340821 | 0.611832840340821 | false | false | false | true | false | |||||||||||||||
| 29b73ec6-3450-4adb-aa76-0a6b27453955 | 2026-09-22 15:55 | 2026-09-22 15:55 | 2026-09-22 15:55 | VLO | VLO260925P00375000 | put | 375.0000 | 2026-09-25 | 7.3000 | 6.7000 | 7.4000 | 376.8600 | 17520.00 | 17520.00 | 0.00 | 24 | 6 | 1786 | 1308 | 1.36544342507645 | 0.607177641031568 | 0.607177641031568 | false | false | false | true | false | |||||||||||||||
| 8b078431-b22c-4bed-8df6-501306415db7 | 2026-09-22 15:55 | 2026-09-22 15:55 | 2026-09-22 15:55 | VLO | VLO261002P00360000 | put | 360.0000 | 2026-10-02 | 6.4000 | 5.8000 | 6.4000 | 376.6800 | 17920.00 | 17920.00 | 0.00 | 28 | 5 | 1733 | 584 | 2.96746575342466 | 0.544042259768013 | 0.544042259768013 | true | false | false | true | false | |||||||||||||||
| 67394fd5-165b-4887-a345-9e03e2900c98 | 2026-09-22 15:55 | 2026-09-22 15:55 | 2026-09-22 15:55 | VLO | VLO261002P00360000 | put | 360.0000 | 2026-10-02 | 6.3000 | 5.8000 | 6.3000 | 376.6800 | 21420.00 | 21420.00 | 0.00 | 34 | 6 | 1767 | 584 | 3.02568493150685 | 0.539333910478075 | 0.539333910478075 | true | false | false | true | false | |||||||||||||||
| aaf97a7f-0129-48de-8965-deb7143f1990 | 2026-09-22 15:56 | 2026-09-22 15:56 | 2026-09-22 15:56 | VLO | VLO261016C00380000 | call | 380.0000 | 2026-10-16 | 20.0000 | 20.0000 | 20.1000 | 377.2500 | 34000.00 | 0.00 | 34000.00 | 17 | 11 | 81 | 204 | 0.397058823529412 | 0.539932418353774 | 0.539932418353774 | false | false | false | true | false | |||||||||||||||
| 9616d7a3-d744-4388-82a1-d386faac3f93 | 2026-09-22 15:57 | 2026-09-22 15:56 | 2026-09-22 15:56 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 22.0000 | 20.7000 | 22.0000 | 376.8000 | 13200.00 | 13200.00 | 0.00 | 6 | 6 | 865 | 796 | 1.08668341708543 | 0.540419858525296 | 0.540419858525296 | false | false | false | true | false |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 108588962642.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 108588962642.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:49:40.866869Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 36cb34b2-bfec-40a0-b347-859cae1cf152 |
| 1 |
| Common Stock |
| Energy |
| 108588962642.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:49:40.866869Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 108588962642.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:49:40.866869Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 108588962642.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:49:40.866869Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 108588962642.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 108588962642.00 |
| 2026-10-22 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:55:34.426688Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 108588962642.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 108588962642.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 108588962642.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 108588962642.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 108588962642.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |