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 |
|---|
| cb4b31f4-7b65-4a95-9e06-15350b79d927 | 2026-08-20 10:45 | 2026-08-20 10:45 | 2026-08-20 10:45 | BP | BP261218C00050000 | call | 50.0000 | 2026-12-18 | 1.4700 | 1.2000 | 1.4700 | 45.1900 | 182280.00 | 182280.00 | 0.00 | 1240 | 28 | 1405 | 1986 | 0.707452165156093 | 0.289394937069139 | 0.289394937069139 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Energy | 126202725954.00 | 2026-10-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0b78e3be-54f5-4b67-b91d-b1d773e7541a | 2026-08-19 14:51 | 2026-08-19 14:51 | 2026-08-19 14:51 | VLO | VLO270617P00340000 | put | 340.0000 | 2027-06-17 | 47.0000 | 45.6000 | 47.1000 | 345.9300 | 75200.00 | 75200.00 | 0.00 | 16 | 5 | 19 | 35 | 0.542857142857143 | 0.453002411195454 | 0.453002411195454 | false | false | false | true | ||||||||||||||||
| b8458693-b45b-4976-9810-c6f03ff817d7 | 2026-08-19 14:02 | 2026-08-19 14:02 | 2026-08-19 14:02 | VLO | VLO260918P00340000 | put | 340.0000 | 2026-09-18 | 13.8000 | 13.5000 | 14.0000 | 344.1950 | 345000.00 | 345000.00 | 0.00 | 250 | 9 | 322 | 289 | 1.11418685121107 | 0.417248827317616 | 0.417248827317616 | false | false | false | true | ||||||||||||||||
| e2bc4181-b2a3-487a-bf6f-aaa0c57cd315 | 2026-08-19 13:24 | 2026-08-19 13:24 | 2026-08-19 13:24 | BP | BP260918C00044000 | call | 44.0000 | 2026-09-18 | 1.6000 | 1.5700 | 1.6500 | 44.0750 | 120640.00 | 8000.00 | 112640.00 | 754 | 47 | 1832 | 3103 | 0.590396390589752 | 0.296749136623949 | 0.296749136623949 | false | false | false | true | ||||||||||||||||
| 6f95b685-9b5c-4883-a199-6531c325b5eb | 2026-08-19 12:27 | 2026-08-19 12:27 | 2026-08-19 12:27 | BP | BP260918C00044000 | call | 44.0000 | 2026-09-18 | 1.6800 | 1.5900 | 1.8100 | 44.1250 | 79966.00 | 78792.00 | 1007.00 | 476 | 46 | 1076 | 3103 | 0.346761198839832 | 0.30729603359447 | 0.30729603359447 | false | false | false | true | ||||||||||||||||
| 352abee8-c023-405f-9405-d1c7b0c941de | 2026-08-19 12:27 | 2026-08-19 12:26 | 2026-08-19 12:26 | BP | BP260918C00044000 | call | 44.0000 | 2026-09-18 | 1.6500 | 1.6000 | 1.6500 | 44.1050 | 84480.00 | 84480.00 | 0.00 | 512 | 55 | 600 | 3103 | 0.193361263293587 | 0.303481675841884 | 0.303481675841884 | false | false | false | true | ||||||||||||||||
| e652ad9c-d972-46d0-8538-bbb3a0e48fa5 | 2026-08-19 12:12 | 2026-08-19 12:12 | 2026-08-19 12:12 | BP | BP261016C00044000 | call | 44.0000 | 2026-10-16 | 2.2700 | 2.2200 | 2.2800 | 44.0599 | 62198.00 | 62198.00 | 0.00 | 274 | 39 | 478 | 5971 | 0.0800535923630883 | 0.302197747439043 | 0.301417487920382 | true | false | false | true | ||||||||||||||||
| f56a82bf-02ee-4b44-b3ca-d084d7e7874b | 2026-08-19 11:15 | 2026-08-19 11:15 | 2026-08-19 11:15 | VLO | VLO260918C00350000 | call | 350.0000 | 2026-09-18 | 17.2300 | 17.2000 | 18.1000 | 349.2750 | 101630.00 | 0.00 | 101630.00 | 59 | 23 | 95 | 1406 | 0.0675675675675676 | 0.426518690590337 | 0.429028059515841 | true | false | false | true | ||||||||||||||||
| fc8db3b9-e80e-4bcb-841d-95188f6b3c44 | 2026-08-19 10:06 | 2026-08-19 10:06 | 2026-08-19 10:06 | VLO | VLO260911P00310000 | put | 310.0000 | 2026-09-11 | 3.2300 | 1.4500 | 4.2000 | 345.2300 | 198345.00 | 198345.00 | 0.00 | 615 | 5 | 615 | 104 | 5.91346153846154 | 0.448646842233357 | 0.451106748485726 | false | false | false | true | ||||||||||||||||
| e400e7c5-6f9a-459e-8e7d-67e743f6df1d | 2026-08-18 14:17 | 2026-08-18 14:17 | 2026-08-18 14:17 | BP | BP261218C00045000 | call | 45.0000 | 2026-12-18 | 2.3600 | 2.3000 | 2.3700 | 43.4150 | 200448.00 | 197432.00 | 3016.00 | 850 | 5 | 17002 | 2183 | 7.78836463582226 | 0.27569435172866 | 0.27569435172866 | false | false | false | true | ||||||||||||||||
| 3389beab-d3f1-4d4c-9e79-6aee0edc0d6f | 2026-08-18 13:18 | 2026-08-18 13:18 | 2026-08-18 13:18 | VLO | VLO270115P00340000 | put | 340.0000 | 2027-01-15 | 32.8000 | 31.4000 | 34.0000 | 347.4000 | 59040.00 | 42640.00 | 16400.00 | 18 | 8 | 20 | 36 | 0.555555555555556 | 0.447670977900161 | 0.447670977900161 | false | false | false | true | ||||||||||||||||
| 807c02f2-213c-445f-879e-7846d07a46a5 | 2026-08-18 11:21 | 2026-08-18 11:21 | 2026-08-18 11:21 | VLO | VLO261218P00360000 | put | 360.0000 | 2026-12-18 | 40.8000 | 40.8000 | 41.9000 | 346.7800 | 69361.00 | 0.00 | 69361.00 | 17 | 9 | 29 | 35 | 0.828571428571429 | 0.450796932984401 | 0.450796932984401 | true | false | false | true | ||||||||||||||||
| 1eadf7cc-09f0-4f44-bb39-d6864a4e0058 | 2026-08-18 10:05 | 2026-08-18 10:05 | 2026-08-18 10:05 | BP | BP261016C00043000 | call | 43.0000 | 2026-10-16 | 2.3800 | 2.3300 | 2.3800 | 43.4100 | 175644.00 | 175644.00 | 0.00 | 738 | 51 | 763 | 1915 | 0.398433420365535 | 0.293256980458719 | 0.293256980458719 | false | false | false | true | ||||||||||||||||
| 441164e2-8982-46cb-94ad-1326f61d425d | 2026-08-17 14:18 | 2026-08-17 14:18 | 2026-08-17 14:18 | VLO | VLO261218C00440000 | call | 440.0000 | 2026-12-18 | 11.2000 | 10.5000 | 11.2000 | 347.6400 | 103040.00 | 103040.00 | 0.00 | 92 | 30 | 98 | 31 | 3.16129032258065 | 0.451857370926132 | 0.451857370926132 | false | false | false | true | ||||||||||||||||
| 847dde26-4978-4c94-909e-f432ed3cad2f | 2026-08-17 10:54 | 2026-08-17 10:54 | 2026-08-17 10:54 | VLO | VLO261218C00460000 | call | 460.0000 | 2026-12-18 | 8.3000 | 7.9000 | 8.3000 | 346.9600 | 53950.00 | 53950.00 | 0.00 | 65 | 8 | 68 | 8 | 8.5 | 0.453118948716446 | 0.453118948716446 | false | false | false | true |
| RepeatedHits |
| 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-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 |
| 110261821190.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Energy |
| 126202725954.00 |
| 2026-10-30 |
| premarket |
| — |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| ADR |
| Energy |
| 126202725954.00 |
| 2026-10-30 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:28:32.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Energy |
| 126202725954.00 |
| 2026-10-30 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:28:32.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Energy |
| 126202725954.00 |
| 2026-10-30 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:28:32.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 110261821190.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Energy |
| 110261821190.00 |
| 2026-10-22 |
| premarket |
| — |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Energy |
| 126202725954.00 |
| 2026-10-30 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:49:07.657249Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| 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-08-18T17:20:11.917066Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| 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-08-18T15:23:23.944279Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| ADR |
| Energy |
| 126202725954.00 |
| 2026-10-30 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| 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-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 |
| 110261821190.00 |
| 2026-10-22 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T14:59:17.821734Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |