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_alerts326,449 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 | price |
|---|
| 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 |
|---|
| 3c4e0123-8c5f-4973-b609-17eee17ebeff | 2026-09-16 15:27 | 2026-09-16 15:27 | 2026-09-16 15:27 | TPR | TPR261120C00135000 | call | 135.0000 | 2026-11-20 | 3.6000 | 3.6000 | 4.1000 | 118.0400 | 10080.00 | 0.00 | 10080.00 | 28 | 11 | 28 | 165 | 0.16969696969697 | 0.45060294393705 | 0.45060294393705 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 23516254503.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:29:08.379560Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 512dc3c0-0b3c-4e3f-9a43-197c401551d6 | 2026-09-16 15:55 | 2026-09-16 15:55 | 2026-09-16 15:55 | TPR | TPR280121P00055000 | put | 55.0000 | 2028-01-21 | 1.5000 | 1.3000 | 2.0000 | 118.0000 | 18750.00 | 2250.00 | 16500.00 | 125 | 8 | 125 | 105 | 1.19047619047619 | 0.498990708274481 | 0.498990708274481 | false | false | false | true | false | |||||||||||||||
| 8a853186-7810-47c4-b1f4-1a49679251b5 | 2026-09-17 09:53 | 2026-09-17 09:53 | 2026-09-17 09:53 | TPR | TPR261023C00128000 | call | 128.0000 | 2026-10-23 | 1.8500 | 1.8000 | 1.8500 | 118.4500 | 19055.00 | 19055.00 | 0.00 | 103 | 6 | 107 | 1 | 107 | 0.335052272243587 | 0.335052272243587 | false | false | false | true | false | |||||||||||||||
| 1d65199b-5e48-4b64-b48b-f1e92d2bb03a | 2026-09-17 15:51 | 2026-09-17 15:51 | 2026-09-17 15:51 | TPR | TPR261120C00110000 | call | 110.0000 | 2026-11-20 | 12.7300 | 11.7000 | 12.8000 | 116.0000 | 31835.00 | 31835.00 | 0.00 | 25 | 6 | 60 | 166 | 0.36144578313253 | 0.464602771933048 | 0.448248873057454 | false | false | false | true | false | |||||||||||||||
| bb439770-2f31-48e5-85b6-43cc70be770f | 2026-09-21 10:08 | 2026-09-21 10:07 | 2026-09-21 10:07 | TPR | TPR261016P00105000 | put | 105.0000 | 2026-10-16 | 0.9600 | 0.6500 | 1.3500 | 113.3200 | 194115.00 | 0.00 | 153615.00 | 2022 | 2 | 2023 | 14 | 144.5 | 0.340609566428468 | 0.340609566428468 | false | true | false | true | true | |||||||||||||||
| 27a8301f-018c-47b5-8639-7428d65fa8b0 | 2026-09-21 10:08 | 2026-09-21 10:07 | 2026-09-21 10:07 | TPR | TPR261016P00105000 | put | 105.0000 | 2026-10-16 | 0.9600 | 0.6500 | 1.3500 | 113.3200 | 194115.00 | 0.00 | 153615.00 | 2022 | 2 | 2023 | 14 | 144.5 | 0.340609566428468 | 0.340609566428468 | false | true | false | true | true | |||||||||||||||
| 07719436-33db-490b-8007-48569f793490 | 2026-09-22 11:23 | 2026-09-22 11:22 | 2026-09-22 11:22 | TPR | TPR261016P00110000 | put | 110.0000 | 2026-10-16 | 3.7000 | 3.4000 | 3.7000 | 110.0000 | 25160.00 | 25160.00 | 0.00 | 68 | 16 | 70 | 192 | 0.364583333333333 | 0.34982157357453 | 0.34982157357453 | false | false | false | true | false | |||||||||||||||
| c1a67531-4e4f-4e1e-9ff2-19015266969f | 2026-09-22 14:17 | 2026-09-22 14:17 | 2026-09-22 14:17 | TPR | TPR260925P00113000 | put | 113.0000 | 2026-09-25 | 1.8500 | 1.6000 | 1.8500 | 112.5100 | 12395.00 | 12395.00 | 0.00 | 67 | 17 | 71 | 28 | 2.53571428571429 | 0.395676500949741 | 0.395676500949741 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 23516254503.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 23137410315.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:57:31.198579Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 23137410315.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22545217031.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:08:15.762043Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22545217031.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:08:15.762043Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22449509026.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:29:11.777432Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 22449509026.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T18:18:27.911867Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |