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_alerts375,978 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 | expiry |
|---|
| 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 |
|---|
| bf2fe5de-4713-4771-8602-268b7144a784 | 2026-09-01 11:00 | 2026-09-01 11:00 | 2026-09-01 11:00 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 9.0000 | 7.5000 | 9.3000 | 312.7900 | 76500.00 | 39580.00 | 36920.00 | 85 | 25 | 667 | 303 | 2.2013201320132 | 0.403605332019775 | 0.3991929587481 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 32958787183.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T15:18:08.991662Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 73ba4568-ba35-447a-b5ac-7fb3dbf28501 | 2026-09-01 11:00 | 2026-09-01 11:00 | 2026-09-01 11:00 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 9.0000 | 9.0000 | 9.4000 | 312.4450 | 49500.00 | 0.00 | 49500.00 | 55 | 7 | 730 | 303 | 2.40924092409241 | 0.389771899075363 | 0.389771899075363 | false | false | false | true | ||||||||||||||||
| bab6bd09-5b1e-48e7-af08-cb98b5d526d0 | 2026-09-01 11:00 | 2026-09-01 11:00 | 2026-09-01 11:00 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 9.3000 | 8.6000 | 9.7000 | 312.5500 | 140429.00 | 116249.00 | 24180.00 | 151 | 32 | 881 | 303 | 2.90759075907591 | 0.402789792000427 | 0.402789792000427 | false | false | false | true | ||||||||||||||||
| 419d6206-e500-4a33-be51-e0a290d1e203 | 2026-09-01 11:01 | 2026-09-01 11:01 | 2026-09-01 11:01 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 9.8000 | 9.4000 | 10.2000 | 310.9600 | 12740.00 | 0.00 | 9800.00 | 13 | 5 | 945 | 303 | 3.11881188118812 | 0.39477932060676 | 0.39477932060676 | false | false | false | true | ||||||||||||||||
| 3c1a45df-3df9-4765-bdd2-ce842f0e8b9c | 2026-09-02 14:35 | 2026-09-02 14:35 | 2026-09-02 14:35 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 10.4000 | 9.8000 | 10.4000 | 309.4800 | 29120.00 | 29120.00 | 0.00 | 28 | 5 | 78 | 1117 | 0.0698299015219337 | 0.402498880931175 | 0.402498880931175 | false | false | false | true | ||||||||||||||||
| 5454c2c3-6229-4214-b5a7-4a698c8cb2ed | 2026-09-04 10:00 | 2026-09-04 10:00 | 2026-09-04 10:00 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 17.2000 | 15.3000 | 18.3000 | 297.4900 | 53320.00 | 29240.00 | 12040.00 | 31 | 5 | 31 | 1135 | 0.0273127753303965 | 0.4236553032518 | 0.4236553032518 | false | false | false | true | ||||||||||||||||
| e7b5e5b3-cdf9-4e99-87c3-ed58b6cb8a3e | 2026-09-04 10:02 | 2026-09-04 10:02 | 2026-09-04 10:02 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 16.9000 | 15.8000 | 16.9000 | 297.0800 | 65910.00 | 65910.00 | 0.00 | 39 | 8 | 70 | 1135 | 0.0616740088105727 | 0.395934272420899 | 0.395934272420899 | false | false | false | true | ||||||||||||||||
| 4c8068ad-af0d-4b4a-a00f-8e26ce7fa438 | 2026-09-04 10:02 | 2026-09-04 10:02 | 2026-09-04 10:02 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 16.5000 | 15.9000 | 16.5000 | 297.5950 | 82500.00 | 66000.00 | 0.00 | 50 | 11 | 120 | 1135 | 0.105726872246696 | 0.393651187925469 | 0.393651187925469 | false | false | false | true | ||||||||||||||||
| 9ae3c8de-f7bd-4ef6-a90a-6e0bc0e9aed9 | 2026-09-04 10:03 | 2026-09-04 10:02 | 2026-09-04 10:02 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 16.3000 | 16.2000 | 16.3000 | 297.6600 | 114100.00 | 114100.00 | 0.00 | 70 | 15 | 200 | 1135 | 0.176211453744493 | 0.386156964636046 | 0.386156964636046 | false | false | false | true | ||||||||||||||||
| 32db35e3-35fd-4cb6-8f42-83f958558068 | 2026-09-04 10:03 | 2026-09-04 10:03 | 2026-09-04 10:03 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 15.5000 | 14.7000 | 15.5000 | 299.1300 | 17050.00 | 17050.00 | 0.00 | 11 | 5 | 287 | 1135 | 0.252863436123348 | 0.394939380520777 | 0.394939380520777 | false | false | false | true | ||||||||||||||||
| 152cf684-e9fe-4ebd-916e-d7b98736ec0a | 2026-09-04 10:37 | 2026-09-04 10:37 | 2026-09-04 10:37 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 16.4200 | 16.2000 | 17.3000 | 297.9800 | 16420.00 | 9860.00 | 4920.00 | 10 | 6 | 497 | 1135 | 0.437885462555066 | 0.407635389177287 | 0.40605226691963 | true | false | false | true | ||||||||||||||||
| 70c0570c-e1aa-4628-b339-2788694687d2 | 2026-09-04 10:43 | 2026-09-04 10:43 | 2026-09-04 10:43 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 17.4100 | 16.2000 | 17.6000 | 297.4400 | 12190.00 | 12190.00 | 0.00 | 7 | 7 | 598 | 1135 | 0.526872246696035 | 0.440946770243275 | 0.426805404315874 | false | false | false | true | ||||||||||||||||
| d59fa45c-e906-46b8-9960-67b4c4f54b59 | 2026-09-04 15:18 | 2026-09-04 15:18 | 2026-09-04 15:18 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 15.1000 | 15.1000 | 15.7000 | 299.0150 | 22650.00 | 0.00 | 4530.00 | 15 | 5 | 723 | 1135 | 0.637004405286344 | 0.372674540794678 | 0.372674540794678 | false | false | false | true | ||||||||||||||||
| 9b2719fd-90d0-4d08-869f-d9fa6ef5e6ee | 2026-09-04 15:18 | 2026-09-04 15:18 | 2026-09-04 15:18 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 15.0000 | 14.7000 | 15.4000 | 299.4600 | 12000.00 | 3000.00 | 4500.00 | 8 | 6 | 789 | 1135 | 0.695154185022026 | 0.381798047835417 | 0.381798047835417 | false | false | false | true | ||||||||||||||||
| e38394a8-9ca9-4c6a-9b9e-f06b09348c81 | 2026-09-04 15:56 | 2026-09-04 15:56 | 2026-09-04 15:56 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 16.5000 | 15.9000 | 17.0000 | 297.3000 | 47850.00 | 36300.00 | 11550.00 | 29 | 5 | 948 | 1135 | 0.835242290748899 | 0.383848242634203 | 0.383848242634203 | false | false | false | true | ||||||||||||||||
| 64a23571-dd11-48b0-be65-9cb1f97733b9 | 2026-09-04 15:56 | 2026-09-04 15:56 | 2026-09-04 15:56 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 16.3900 | 16.0000 | 17.2000 | 297.1700 | 26230.00 | 11470.00 | 14760.00 | 16 | 5 | 967 | 1135 | 0.851982378854626 | 0.374518014378431 | 0.369578564637779 | true | false | false | true | ||||||||||||||||
| faddcb0e-0759-4e2d-9d29-d834adb1fd26 | 2026-09-04 15:57 | 2026-09-04 15:57 | 2026-09-04 15:57 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 16.1000 | 15.4000 | 16.6000 | 297.7500 | 12880.00 | 3220.00 | 4830.00 | 8 | 5 | 991 | 1135 | 0.873127753303965 | 0.379475615515616 | 0.379475615515616 | false | false | false | true | ||||||||||||||||
| 35474615-41b1-4dc7-85ee-3d2566ffbf84 | 2026-09-04 15:57 | 2026-09-04 15:57 | 2026-09-04 15:57 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 16.1000 | 16.1000 | 16.6000 | 297.7500 | 11270.00 | 0.00 | 11270.00 | 7 | 5 | 998 | 1135 | 0.879295154185022 | 0.379475615515616 | 0.379475615515616 | false | false | false | true | ||||||||||||||||
| 687c1ae0-0150-4d09-8d6e-182c19599c2c | 2026-09-15 13:57 | 2026-09-15 13:57 | 2026-09-15 13:57 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 19.5000 | 18.3000 | 20.0000 | 291.1250 | 39000.00 | 7800.00 | 7800.00 | 20 | 5 | 25 | 686 | 0.0364431486880466 | 0.544540448511053 | 0.544540448511053 | false | false | false | true | ||||||||||||||||
| bbf1bc0e-dbf7-4c73-b592-501515ffeec1 | 2026-09-15 13:58 | 2026-09-15 13:57 | 2026-09-15 13:57 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 19.4000 | 18.5000 | 19.9000 | 291.1900 | 19400.00 | 19400.00 | 0.00 | 10 | 5 | 35 | 686 | 0.0510204081632653 | 0.535862082090464 | 0.535862082090464 | false | false | false | true | ||||||||||||||||
| ed008239-86cd-4633-8e7e-9c89eb8a28ba | 2026-09-17 14:28 | 2026-09-17 14:28 | 2026-09-17 14:28 | EXPE | EXPE260918P00310000 | put | 310.0000 | 2026-09-18 | 24.8000 | 24.8000 | 28.5000 | 283.3200 | 3819740.00 | 0.00 | 3819740.00 | 1540 | 2 | 1541 | 626 | 2.46166134185304 | 1.61710408038129 | 1.61710408038129 | false | true | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T15:18:08.991662Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T15:18:08.991662Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T15:18:08.991662Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:44:26.340635Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:44:26.340635Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T19:30:40.028430Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32958787183.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| FloorTradeLargeCap |
| 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 32579805784.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |