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_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 |
|---|
| 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 |
|---|
| 7137d30c-181d-49c8-a18a-09aee1029644 | 2026-09-23 12:54 | 2026-09-23 12:54 | 2026-09-23 12:54 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 25.2000 | 24.1000 | 25.2000 | 369.3450 | 15120.00 | 12600.00 | 0.00 | 6 | 6 | 212 | 582 | 0.36426116838488 | 0.533414755869481 | 0.533414755869481 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 108214656942.00 | 2026-10-22 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T16:56:20.780869Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 8e9719b3-b51c-4089-93f8-bb087507e737 | 2026-09-23 12:53 | 2026-09-23 12:53 | 2026-09-23 12:53 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 25.0000 | 23.0000 | 26.2000 | 370.0000 | 22500.00 | 20000.00 | 2500.00 | 9 | 9 | 203 | 582 | 0.348797250859107 | 0.554779079197029 | 0.537728199555106 | false | false | false | true | false | |||||||||||||||
| a7a105c7-4661-4425-9b46-512387ef92df | 2026-09-23 12:51 | 2026-09-23 12:51 | 2026-09-23 12:51 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 28.0000 | 25.5000 | 28.4000 | 365.9600 | 145600.00 | 145600.00 | 0.00 | 52 | 5 | 188 | 582 | 0.323024054982818 | 0.557365380894366 | 0.558158789890914 | 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| c60bc313-a753-448a-8f0e-4146429293d9 | 2026-09-22 14:59 | 2026-09-22 14:59 | 2026-09-22 14:59 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 17.3000 | 15.8000 | 17.3000 | 386.7350 | 17300.00 | 17300.00 | 0.00 | 10 | 5 | 738 | 796 | 0.92713567839196 | 0.534945016658212 | 0.534945016658212 | false | false | false | true | false | |||||||||||||||
| 735947fa-09d6-4122-b428-d150cd5924b0 | 2026-09-22 10:41 | 2026-09-22 10:41 | 2026-09-22 10:41 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 17.7000 | 17.7000 | 18.7000 | 383.1500 | 10620.00 | 0.00 | 10620.00 | 6 | 6 | 234 | 796 | 0.293969849246231 | 0.505693263585553 | 0.505693263585553 | false | false | false | true | false | |||||||||||||||
| 34e47a23-bdf6-4372-86f0-6ff28fb44520 | 2026-09-22 10:39 | 2026-09-22 10:39 | 2026-09-22 10:39 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 17.9000 | 17.4000 | 18.7000 | 382.4300 | 21480.00 | 0.00 | 21480.00 | 12 | 7 | 220 | 796 | 0.276381909547739 | 0.502610101296452 | 0.502610101296452 | false | false | false | true | false | |||||||||||||||
| ec5d0b70-641b-4b71-8f0b-962df58421bf | 2026-09-22 10:10 | 2026-09-22 10:10 | 2026-09-22 10:10 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 18.4800 | 18.4000 | 20.1000 | 381.8800 | 33270.00 | 0.00 | 33270.00 | 18 | 17 | 176 | 796 | 0.221105527638191 | 0.505287960580926 | 0.509138674994435 | false | false | false | true | false | |||||||||||||||
| ff571229-caa0-4df5-ae13-beb33c0198cc | 2026-09-22 09:59 | 2026-09-22 09:59 | 2026-09-22 09:59 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 21.2500 | 19.9000 | 22.1000 | 376.0000 | 19125.00 | 19125.00 | 0.00 | 9 | 5 | 150 | 796 | 0.188442211055276 | 0.51859568055638 | 0.51859568055638 | false | false | false | true | false | |||||||||||||||
| d3866b01-2bd9-49b7-839d-1b2bfb3eab54 | 2026-09-22 09:42 | 2026-09-22 09:42 | 2026-09-22 09:42 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 18.2000 | 17.9000 | 19.4000 | 383.4800 | 21840.00 | 0.00 | 21840.00 | 12 | 12 | 116 | 796 | 0.14572864321608 | 0.519784588051983 | 0.522335299342694 | false | false | false | true | false | |||||||||||||||
| 94438901-17bf-4465-bfa2-551bc8b892eb | 2026-09-22 09:39 | 2026-09-22 09:39 | 2026-09-22 09:39 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 18.5000 | 18.5000 | 19.4000 | 383.2450 | 22200.00 | 0.00 | 22200.00 | 12 | 12 | 99 | 796 | 0.124371859296482 | 0.527409417315607 | 0.527409417315607 | true | false | false | true | false | |||||||||||||||
| a636f8ef-628f-4777-b99c-67d839c217c6 | 2026-09-22 09:38 | 2026-09-22 09:38 | 2026-09-22 09:38 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 18.8000 | 18.8000 | 21.0000 | 382.1650 | 63920.00 | 0.00 | 63920.00 | 34 | 7 | 85 | 796 | 0.10678391959799 | 0.522762531276496 | 0.522762531276496 | false | false | false | true | false | |||||||||||||||
| 69105f87-4a8b-4182-a25a-a934104e0442 | 2026-09-22 09:35 | 2026-09-22 09:35 | 2026-09-22 09:35 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 18.8000 | 18.8000 | 19.9000 | 382.4460 | 41360.00 | 0.00 | 3760.00 | 22 | 18 | 30 | 796 | 0.0376884422110553 | 0.526006927406625 | 0.526006927406625 | false | false | false | true | false | |||||||||||||||
| 98d266b3-3cc9-4044-b9f5-4a05b5e40c7a | 2026-09-16 10:28 | 2026-09-16 10:28 | 2026-09-16 10:28 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 16.7500 | 16.3000 | 17.5000 | 393.0000 | 72039.00 | 48575.00 | 23464.00 | 43 | 6 | 55 | 348 | 0.158045977011494 | 0.526350532098936 | 0.526584736027484 | false | false | false | true | false | |||||||||||||||
| 78b50d9c-0cae-436b-9a61-c415657f0f14 | 2026-09-04 10:55 | 2026-09-04 10:54 | 2026-09-04 10:54 | VLO | VLO261016P00380000 | put | 380.0000 | 2026-10-16 | 27.1000 | 25.8000 | 27.1000 | 370.1300 | 119240.00 | 119240.00 | 0.00 | 44 | 10 | 44 | 43 | 1.02325581395349 | 0.450394013257324 | 0.450394013257324 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 108214656942.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:56:20.780869Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 108214656942.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:52:42.063868Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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: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 |
| — |
| 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: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:02:38.336545Z"} |
| 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-22T14:42:44.065275Z"} |
| 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-22T14:41:08.297651Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 108588962642.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:11:50.316445Z"} |
| 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-22T14:01:27.900775Z"} |
| 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-22T13:43:21.956551Z"} |
| 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-22T13:40:19.961747Z"} |
| 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-22T13:39:02.678096Z"} |
| 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-22T13:36:05.660724Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 116115386472.00 |
| 2026-10-22 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 110261821190.00 |
| 2026-10-22 |
| premarket |
| — |
| 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 |