Simplify AnalyticsOptions flow alerts (market-wide)
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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ac0bc4f1-e0d3-43e3-83fe-0d4f519cdd60 | 2026-09-17 11:33 | 2026-09-17 11:33 | 2026-09-17 11:33 | SHOO | SHOO261016C00045000 | call | 45.0000 | 2026-10-16 | 0.9500 | 0.9500 | 0.9500 | 41.8700 | 33915.00 | 0.00 | 0.00 | 357 | 6 | 371 | 7452 | 0.0497852925389157 | 0.434620452840211 | 0.434620452840211 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3058802571.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:37:51.418712Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| dc5e21f6-91e4-47f4-8b82-b872a34e844b | 2026-09-16 13:13 | 2026-09-16 13:13 | 2026-09-16 13:13 | SHOO | SHOO261016C00040000 | call | 40.0000 | 2026-10-16 | 3.4000 | 3.3000 | 3.6000 | 42.1400 | 60180.00 | 0.00 | 60180.00 | 177 | 16 | 809 | 51 | 15.8627450980392 | 0.441938131015516 | 0.441938131015516 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3037581213.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| dd1a47e6-f0da-497f-82e9-1bec507a9f25 | 2026-09-16 13:13 | 2026-09-16 13:13 | 2026-09-16 13:13 | SHOO | SHOO261016C00040000 | call | 40.0000 | 2026-10-16 | 3.5000 | 3.5000 | 3.7000 | 42.2500 | 25900.00 | 0.00 | 25900.00 | 74 | 15 | 574 | 51 | 11.2549019607843 | 0.447508559435091 | 0.447508559435091 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3037581213.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| b00f9872-184d-4b3f-aba7-c1077c817ade | 2026-09-16 10:33 | 2026-09-16 10:33 | 2026-09-16 10:33 | SHOO | SHOO261016C00040000 | call | 40.0000 | 2026-10-16 | 3.4400 | 2.1000 | 3.5000 | 41.0000 | 172000.00 | 172000.00 | 0.00 | 500 | 2 | 500 | 51 | 9.80392156862745 | 0.518521888248523 | 0.518521888248523 | false | true | true | false | true | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 2 | Common Stock | Consumer Cyclical | 3037581213.00 | 2026-11-04 | unknown | 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 |
| 5270a79e-334e-4252-9068-5537434e81fc | 2026-09-15 15:44 | 2026-09-15 15:44 | 2026-09-15 15:44 | SHOO | SHOO260918C00040000 | call | 40.0000 | 2026-09-18 | 1.4500 | 1.0000 | 1.5000 | 40.7400 | 71050.00 | 71050.00 | 0.00 | 490 | 1 | 500 | 559 | 0.894454382826476 | 0.705706527456144 | 0.705706527456144 | false | true | false | true | false | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T19:44:55.237483Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 0de7909c-cd76-47c9-9980-f6b79fd197e5 | 2026-09-14 11:48 | 2026-09-14 11:48 | 2026-09-14 11:48 | SHOO | SHOO261016C00045000 | call | 45.0000 | 2026-10-16 | 1.0500 | 1.0000 | 1.0500 | 41.7900 | 12180.00 | 12180.00 | 0.00 | 116 | 8 | 341 | 7102 | 0.0480146437623205 | 0.441544383725989 | 0.441544383725989 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T16:02:31.142849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d6107e51-0ef6-4e6d-a6c6-8a7a92b52216 | 2026-09-14 11:48 | 2026-09-14 11:48 | 2026-09-14 11:48 | SHOO | SHOO261016C00045000 | call | 45.0000 | 2026-10-16 | 1.0000 | 0.9000 | 1.0500 | 41.7900 | 19010.00 | 19010.00 | 0.00 | 191 | 6 | 214 | 7102 | 0.030132357082512 | 0.425587358675026 | 0.430164566315002 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T16:02:31.142849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 76cf2efa-aa65-4e90-87c4-b00cb056c82b | 2026-09-10 12:23 | 2026-09-10 12:23 | 2026-09-10 12:23 | SHOO | SHOO261016C00045000 | call | 45.0000 | 2026-10-16 | 1.2000 | 1.0500 | 1.2500 | 42.4100 | 17400.00 | 4200.00 | 13200.00 | 145 | 5 | 304 | 6802 | 0.0446927374301676 | 0.402972584029201 | 0.402972584029201 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T16:37:06.868856Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d246f77a-dd03-4e8c-8606-f6c33e81880e | 2026-09-10 12:22 | 2026-09-10 12:22 | 2026-09-10 12:22 | SHOO | SHOO261016C00045000 | call | 45.0000 | 2026-10-16 | 1.1500 | 1.1500 | 1.2000 | 42.1750 | 14030.00 | 0.00 | 230.00 | 122 | 5 | 122 | 6802 | 0.0179359012055278 | 0.409423839749487 | 0.409423839749487 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T16:37:06.868856Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 60a6b5f5-a5e8-4a86-ac5b-3e574247f50a | 2026-09-09 13:41 | 2026-09-09 13:41 | 2026-09-09 13:41 | SHOO | SHOO261016C00045000 | call | 45.0000 | 2026-10-16 | 1.8500 | 1.6500 | 2.0500 | 43.8700 | 42550.00 | 42365.00 | 185.00 | 230 | 36 | 274 | 6315 | 0.0433887569279493 | 0.407677490061545 | 0.407677490061545 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T17:50:47.676652Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 33e18407-1cb3-46b7-b07d-83a3ccd8937d | 2026-09-09 13:39 | 2026-09-09 13:39 | 2026-09-09 13:39 | SHOO | SHOO260918C00045000 | call | 45.0000 | 2026-09-18 | 0.8000 | 0.6000 | 0.8000 | 43.9000 | 24000.00 | 24000.00 | 0.00 | 300 | 20 | 710 | 2965 | 0.239460370994941 | 0.469002839893134 | 0.452395093477897 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T17:50:47.676652Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0b963a35-f1d6-4a1f-baac-8113c3a05f04 | 2026-09-08 13:33 | 2026-09-08 13:33 | 2026-09-08 13:33 | SHOO | SHOO260918C00045000 | call | 45.0000 | 2026-09-18 | 0.7000 | 0.5000 | 0.7000 | 43.4050 | 12110.00 | 12110.00 | 0.00 | 173 | 12 | 1401 | 1614 | 0.868029739776952 | 0.457293808736985 | 0.457293808736985 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T17:42:35.153326Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b1643dc6-d332-40ec-adea-31e098b1995d | 2026-09-04 10:56 | 2026-09-04 10:56 | 2026-09-04 10:56 | SHOO | SHOO261016C00045000 | call | 45.0000 | 2026-10-16 | 1.3500 | 1.2500 | 1.4000 | 42.9300 | 19548.00 | 1323.00 | 18225.00 | 145 | 20 | 145 | 5164 | 0.0280790085205267 | 0.366481882152019 | 0.363574699941691 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | 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 |
| 7679c889-b317-4614-9ec4-fb7581e528b5 | 2026-09-02 10:38 | 2026-09-02 10:38 | 2026-09-02 10:38 | SHOO | SHOO260918C00040000 | call | 40.0000 | 2026-09-18 | 2.8500 | 2.4000 | 2.8500 | 42.1000 | 57000.00 | 57000.00 | 0.00 | 200 | 9 | 276 | 8 | 34.5 | 0.446254356308616 | 0.446254356308616 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5c55ef09-ea5c-484a-9917-d76e301a7d58 | 2026-09-02 10:38 | 2026-09-02 10:38 | 2026-09-02 10:38 | SHOO | SHOO260918C00040000 | call | 40.0000 | 2026-09-18 | 2.8200 | 1.2500 | 2.8500 | 42.1000 | 21432.00 | 16112.00 | 5320.00 | 76 | 5 | 76 | 8 | 9.5 | 0.442819762183266 | 0.428992587364677 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 92006504-8907-42a0-a5db-07d3e410150e | 2026-08-31 15:25 | 2026-08-31 15:25 | 2026-08-31 15:25 | SHOO | SHOO261016C00045000 | call | 45.0000 | 2026-10-16 | 1.6000 | 1.5500 | 1.6500 | 43.1900 | 15680.00 | 0.00 | 6240.00 | 98 | 5 | 652 | 3684 | 0.176981541802389 | 0.370970882374049 | 0.370970882374049 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T19:31:33.694739Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ebf2b1c0-7e25-4b90-94a9-11dccd9bbacf | 2026-08-31 11:28 | 2026-08-31 11:28 | 2026-08-31 11:28 | SHOO | SHOO261016C00045000 | call | 45.0000 | 2026-10-16 | 1.4500 | 1.3000 | 1.4500 | 42.8000 | 11165.00 | 11165.00 | 0.00 | 77 | 18 | 452 | 3684 | 0.122692725298588 | 0.37225978704136 | 0.37225978704136 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aa910b3d-f9ed-48e3-b230-381a06c489c0 | 2026-08-31 11:28 | 2026-08-31 11:28 | 2026-08-31 11:28 | SHOO | SHOO261016C00045000 | call | 45.0000 | 2026-10-16 | 1.4000 | 1.3000 | 1.4500 | 42.8000 | 10500.00 | 3500.00 | 7000.00 | 75 | 5 | 375 | 3684 | 0.101791530944625 | 0.363678499703334 | 0.363678499703334 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8e0f5110-7aa6-483e-952d-58bdc3f69f93 | 2026-08-31 10:16 | 2026-08-31 10:15 | 2026-08-31 10:15 | SHOO | SHOO261016C00045000 | call | 45.0000 | 2026-10-16 | 1.7000 | 1.4000 | 1.7000 | 43.1900 | 30600.00 | 30600.00 | 0.00 | 180 | 15 | 300 | 3684 | 0.0814332247557003 | 0.387654545898609 | 0.387654545898609 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T14:21:00.001261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fe2a1a0a-36ff-4d5d-9e8b-42bd5a957b0f | 2026-08-28 15:52 | 2026-08-28 15:52 | 2026-08-28 15:52 | SHOO | SHOO261016C00045000 | call | 45.0000 | 2026-10-16 | 2.1500 | 2.0500 | 2.2000 | 44.3400 | 17415.00 | 4300.00 | 3440.00 | 81 | 8 | 923 | 2744 | 0.336370262390671 | 0.362479631711836 | 0.362479631711836 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T19:57:19.773601Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c4a5d845-6106-41d4-bd2e-773033e8b49b | 2026-08-28 14:36 | 2026-08-28 14:35 | 2026-08-28 14:35 | SHOO | SHOO261016C00045000 | call | 45.0000 | 2026-10-16 | 2.3000 | 2.2000 | 2.3500 | 44.6500 | 92000.00 | 18400.00 | 55200.00 | 400 | 6 | 800 | 2744 | 0.291545189504373 | 0.361334788427728 | 0.361334788427728 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T18:46:22.896033Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 647253c7-9e7a-472e-bcfd-c23e1b04b737 | 2026-08-20 12:38 | 2026-08-20 12:38 | 2026-08-20 12:38 | SHOO | SHOO260821C00040000 | call | 40.0000 | 2026-08-21 | 5.7000 | 5.7000 | 6.1000 | 45.8500 | 14820.00 | 0.00 | 11970.00 | 26 | 5 | 26 | 3563 | 0.00729722144260455 | 1.44701904951151 | 2.11053054856711 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3098318202.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T16:44:56.732853Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |