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 |
|---|
| 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 |
|---|
| 4d1bdb6d-c35e-4cde-9c0b-4120249caf2d | 2026-08-19 09:49 | 2026-08-19 09:49 | 2026-08-19 09:49 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.7500 | 2.7500 | 3.3000 | 97.1350 | 17050.00 | 0.00 | 17050.00 | 62 | 5 | 66 | 478 | 0.138075313807531 | 0.444596708475885 | 0.444596708475885 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Energy | 40610811028.00 | 2026-11-04 | 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 |
| f83152ec-e826-4974-8965-3c707fd64099 | 2026-08-19 09:49 | 2026-08-19 09:49 | 2026-08-19 09:49 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.7500 | 2.7500 | 3.3000 | 97.0000 | 53900.00 | 0.00 | 53900.00 | 196 | 6 | 262 | 478 | 0.548117154811716 | 0.447503204155438 | 0.447503204155438 | true | false | false | true | ||||||||||||||||
| d6ab5004-1040-4292-91d5-0186cf280004 | 2026-08-19 09:49 | 2026-08-19 09:49 | 2026-08-19 09:49 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.7400 | 2.7300 | 3.3000 | 96.9300 | 24947.00 | 0.00 | 20306.00 | 91 | 6 | 353 | 478 | 0.738493723849372 | 0.449009832499362 | 0.447470589600532 | false | false | false | true | ||||||||||||||||
| f7aa4221-c121-4bcc-9a9a-7e61703d9b80 | 2026-08-19 09:51 | 2026-08-19 09:51 | 2026-08-19 09:51 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.7500 | 2.5600 | 2.9900 | 97.0100 | 79750.00 | 0.00 | 79750.00 | 290 | 11 | 1020 | 478 | 2.13389121338912 | 0.447287947284374 | 0.447287947284374 | false | false | false | true | ||||||||||||||||
| f91d0adc-09af-4c3a-821d-330cb7b7e978 | 2026-08-19 09:51 | 2026-08-19 09:51 | 2026-08-19 09:51 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.7500 | 2.5100 | 2.9900 | 96.9200 | 78376.00 | 7151.00 | 70400.00 | 285 | 7 | 1362 | 478 | 2.84937238493724 | 0.449225041207947 | 0.449993955968269 | false | false | false | true | ||||||||||||||||
| dd69340a-84d0-495c-98e5-c0fce9d790f5 | 2026-08-19 12:54 | 2026-08-19 12:53 | 2026-08-19 12:53 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.7500 | 2.6200 | 2.9000 | 97.0300 | 92400.00 | 0.00 | 92400.00 | 336 | 6 | 1871 | 478 | 3.91422594142259 | 0.446857415071194 | 0.446857415071194 | false | false | false | true | ||||||||||||||||
| 0b064a5a-6eb8-498d-88c3-a906a7cd38ec | 2026-08-19 13:09 | 2026-08-19 13:09 | 2026-08-19 13:09 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.7500 | 2.7500 | 2.8400 | 96.9200 | 37675.00 | 0.00 | 23650.00 | 137 | 10 | 2361 | 478 | 4.93933054393305 | 0.449225041207947 | 0.449225041207947 | false | false | false | true | ||||||||||||||||
| 8043c9de-9c76-4d72-b063-42188cc3260e | 2026-08-19 13:10 | 2026-08-19 13:09 | 2026-08-19 13:09 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.7500 | 2.7500 | 2.8300 | 96.9656 | 55275.00 | 0.00 | 55275.00 | 201 | 6 | 2607 | 478 | 5.45397489539749 | 0.448243641236783 | 0.448243641236783 | false | false | false | true | ||||||||||||||||
| 6091d0f8-db8c-486f-85e8-e1d50c188471 | 2026-08-19 13:12 | 2026-08-19 13:12 | 2026-08-19 13:12 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.7500 | 2.7500 | 2.8600 | 97.0000 | 105325.00 | 0.00 | 105325.00 | 383 | 6 | 2990 | 478 | 6.25523012552301 | 0.447503204155438 | 0.447503204155438 | false | false | false | true | ||||||||||||||||
| 14a8e1e7-76b6-4309-bc52-e15707db61d7 | 2026-08-19 14:12 | 2026-08-19 14:12 | 2026-08-19 14:12 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.7500 | 2.7500 | 2.9000 | 96.9650 | 17050.00 | 0.00 | 17050.00 | 62 | 5 | 3073 | 478 | 6.42887029288703 | 0.448256555201398 | 0.448256555201398 | false | false | false | true | ||||||||||||||||
| 63828646-309a-4804-b77e-549e12216724 | 2026-08-19 14:15 | 2026-08-19 14:15 | 2026-08-19 14:15 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.7500 | 2.7500 | 2.8400 | 96.8600 | 59400.00 | 0.00 | 59400.00 | 216 | 5 | 3345 | 478 | 6.9979079497908 | 0.450516170672088 | 0.450516170672088 | false | false | false | true | ||||||||||||||||
| deec9bf4-561e-4615-b8ee-6abc72617760 | 2026-08-19 14:15 | 2026-08-19 14:15 | 2026-08-19 14:15 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.7500 | 2.7500 | 2.8400 | 96.9000 | 107525.00 | 0.00 | 107525.00 | 391 | 6 | 3742 | 478 | 7.82845188284519 | 0.449655440972182 | 0.449655440972182 | false | false | false | true | ||||||||||||||||
| 74283c9c-9c17-48ae-8dc6-a7482181724f | 2026-08-19 14:17 | 2026-08-19 14:17 | 2026-08-19 14:17 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.7500 | 2.7500 | 2.8700 | 96.9450 | 21725.00 | 0.00 | 21725.00 | 79 | 5 | 3821 | 478 | 7.99372384937239 | 0.448687008324504 | 0.448687008324504 | false | false | false | true | ||||||||||||||||
| 42b1ac60-a761-4f59-b2b0-c6adcf2e5dd7 | 2026-08-20 09:48 | 2026-08-20 09:48 | 2026-08-20 09:48 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.5000 | 2.3100 | 2.7900 | 95.9500 | 50499.00 | 249.00 | 50250.00 | 202 | 12 | 205 | 3963 | 0.0517284885187989 | 0.452884124050038 | 0.453557914150019 | false | false | false | true | ||||||||||||||||
| 7997f4fb-8fd0-4573-8b69-360e1de3d935 | 2026-08-20 09:48 | 2026-08-20 09:48 | 2026-08-20 09:48 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.5000 | 2.5000 | 2.6500 | 95.8200 | 58250.00 | 0.00 | 58250.00 | 233 | 6 | 440 | 3963 | 0.111026999747666 | 0.457125223123071 | 0.457125223123071 | false | false | false | true | ||||||||||||||||
| 6e1c95c1-30e7-4c57-ba02-6c5e91571b5a | 2026-08-20 09:50 | 2026-08-20 09:50 | 2026-08-20 09:50 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.5000 | 2.3100 | 2.6400 | 95.7609 | 59714.00 | 4250.00 | 55464.00 | 239 | 19 | 858 | 3963 | 0.216502649507949 | 0.458378221294025 | 0.457563926915315 | false | false | false | true | ||||||||||||||||
| 960292f9-c3fd-4012-affc-6e5d0952d47c | 2026-08-20 09:50 | 2026-08-20 09:50 | 2026-08-20 09:50 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.5000 | 2.5000 | 2.6100 | 95.6800 | 45250.00 | 0.00 | 1250.00 | 181 | 6 | 1039 | 3963 | 0.262175119858693 | 0.460093241511084 | 0.460093241511084 | false | false | false | true | ||||||||||||||||
| b3f5f91c-6b97-4e50-b908-702bfd5c692b | 2026-08-21 09:41 | 2026-08-21 09:41 | 2026-08-21 09:41 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 4.0700 | 4.0000 | 4.3000 | 100.5400 | 408220.00 | 309810.00 | 98410.00 | 1002 | 43 | 1013 | 5194 | 0.195032730073161 | 0.472209555261937 | 0.471844106288692 | false | false | false | true | ||||||||||||||||
| 3037f28e-0250-4064-8556-c80c080962ef | 2026-09-02 10:20 | 2026-09-02 10:20 | 2026-09-02 10:20 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 2.3300 | 2.3300 | 2.5600 | 97.7601 | 170328.00 | 238.00 | 170090.00 | 731 | 56 | 746 | 5478 | 0.136181087988317 | 0.455544535304114 | 0.46539441475005 | true | false | false | true | ||||||||||||||||
| 3638c156-f543-403c-b23d-04456dc3a501 | 2026-09-04 15:58 | 2026-09-04 15:58 | 2026-09-04 15:58 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 3.2300 | 3.1000 | 3.2500 | 100.8050 | 1990003.00 | 1990003.00 | 0.00 | 6161 | 2 | 15324 | 5589 | 2.74181427804616 | 0.47166723587977 | 0.47166723587977 | false | true | true | false | ||||||||||||||||
| 52ab764f-b45d-4062-abba-ac5209baa4b3 | 2026-09-18 13:34 | 2026-09-18 13:34 | 2026-09-18 13:34 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 0.9900 | 0.7950 | 1.0400 | 93.8750 | 88664.00 | 60500.00 | 28164.00 | 893 | 46 | 995 | 21248 | 0.046827936746988 | 0.513164268433658 | 0.513164268433658 | false | false | false | true | ||||||||||||||||
| 1507d4b2-9519-4a4b-bf2f-a875811d1b78 | 2026-09-23 12:05 | 2026-09-23 12:04 | 2026-09-23 12:04 | CCJ | CCJ261016C00110000 | call | 110.0000 | 2026-10-16 | 0.4800 | 0.4600 | 0.5100 | 92.1600 | 13658.00 | 13152.00 | 506.00 | 285 | 5 | 329 | 21598 | 0.0152328919344384 | 0.501947644133716 | 0.496705983966733 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| 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 |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:16:43.855599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:16:43.855599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:16:43.855599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:16:43.855599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:37:13.611011Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:37:13.611011Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:37:13.611011Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:37:13.611011Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:43:10.748747Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:25:30.485375Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 2 |
| Common Stock |
| Energy |
| 40610811028.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T20:00:02.053596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 39896659944.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Energy |
| 39539584402.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:06:31.927382Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |