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_alerts609,118 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 |
|---|
| 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 |
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | ||||||||||||||||
| 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 | ||||||||||||||||
| 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 | |||||||||||||||||
| 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 | ||||||||||||||||
| 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 | |||||||||||||||||
| 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 | |||||||||||||||||
| 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 | ||||||||||||||||
| 518a6b1c-66e8-4794-99b9-8e2e81474467 | 2026-09-21 11:24 | 2026-09-21 11:24 | 2026-09-21 11:24 | SHOO | SHOO261016C00045000 | call | 45.0000 | 2026-10-16 | 1.0800 | 0.9000 | 1.1500 | 42.7100 | 53460.00 | 53460.00 | 0.00 | 495 | 2 | 505 | 7852 | 0.0643148242485991 | 0.437679515181187 | 0.437679515181187 | false | true | false | |||||||||||||||||
| 2c2c6259-6d67-4c6b-8184-a474f605ddc9 | 2026-09-25 14:45 | 2026-09-25 14:45 | 2026-09-25 14:45 | SHOO | SHOO261016C00045000 | call | 45.0000 | 2026-10-16 | 1.9000 | 1.7000 | 2.1500 | 44.8050 | 21660.00 | 13680.00 | 7790.00 | 114 | 20 | 2406 | 8658 | 0.277893277893278 | 0.45348267054311 | 0.45348267054311 | false | false | false |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 3134174979.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:27:55.894324Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 3297359901.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:46:04.686299Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |