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_alerts523,327 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 | strike |
|---|
| 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 |
|---|
| 5040e2d7-9842-4a68-9c82-69989338f8f0 | 2026-09-28 14:45 | 2026-09-28 14:45 | 2026-09-28 14:45 | ABNB | ABNB271217C00195000 | call | 195.0000 | 2027-12-17 | 18.4500 | 17.7500 | 19.3000 | 157.8100 | 697258.00 | 36653.00 | 660605.00 | 378 | 17 | 378 | 584 | 0.647260273972603 | 0.399135906012789 | 0.398410789351598 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 65480173100.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T18:52:01.773916Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| e3cbeb84-53b7-4c45-8547-e2126ff0dd8e | 2026-09-28 13:41 | 2026-09-28 13:41 | 2026-09-28 13:41 | ABNB | ABNB261218C00160000 | call | 160.0000 | 2026-12-18 | 11.2200 | 10.7500 | 11.5000 | 157.7300 | 47145.00 | 42605.00 | 4540.00 | 42 | 5 | 85 | 1083 | 0.0784856879039705 | 0.39537533336506 | 0.390304009359487 | false | false | ||||||||||||||||||
| 572b3092-2245-43a4-bd1f-9c984526342f | 2026-09-28 13:41 | 2026-09-28 13:41 | 2026-09-28 13:41 | ABNB | ABNB261218P00170000 | put | 170.0000 | 2026-12-18 | 18.0600 | 17.6500 | 18.3500 | 157.7300 | 52380.00 | 52380.00 | 0.00 | 29 | 5 | 76 | 150 | 0.506666666666667 | 0.392708376739707 | 0.390962468608031 | true | false | ||||||||||||||||||
| 43496ba2-23e8-4fd9-a01f-8031024bdb28 | 2026-09-28 13:41 | 2026-09-28 13:41 | 2026-09-28 13:41 | ABNB | ABNB261218C00170000 | call | 170.0000 | 2026-12-18 | 7.1700 | 7.1000 | 7.4000 | 157.7300 | 22240.00 | 19355.00 | 2885.00 | 31 | 6 | 107 | 469 | 0.228144989339019 | 0.391937439845743 | 0.383196455384912 | true | false | ||||||||||||||||||
| 1b06e7b8-f50f-46ed-84a8-ca2d787b8701 | 2026-09-28 13:41 | 2026-09-28 13:41 | 2026-09-28 13:41 | ABNB | ABNB261218C00165000 | call | 165.0000 | 2026-12-18 | 9.1100 | 9.1000 | 9.3000 | 157.7300 | 10020.00 | 0.00 | 10020.00 | 11 | 5 | 43 | 588 | 0.0731292517006803 | 0.391302894947166 | 0.389607376701673 | false | false | ||||||||||||||||||
| 18500b03-4cee-41dc-b81b-fb33e5f4305c | 2026-09-25 09:57 | 2026-09-25 09:56 | 2026-09-25 09:56 | ABNB | ABNB270319C00150000 | call | 150.0000 | 2027-03-19 | 20.4200 | 20.1000 | 20.8000 | 153.9600 | 40846.00 | 0.00 | 18351.00 | 20 | 5 | 21 | 141 | 0.148936170212766 | 0.402983810473325 | 0.402983810473325 | false | false | ||||||||||||||||||
| b1f6e349-70e8-43fa-81e2-58b706827416 | 2026-09-23 15:39 | 2026-09-23 15:39 | 2026-09-23 15:39 | ABNB | ABNB261016P00145000 | put | 145.0000 | 2026-10-16 | 3.3900 | 3.3000 | 3.6000 | 149.8800 | 169457.00 | 139397.00 | 26320.00 | 500 | 46 | 698 | 253 | 2.75889328063241 | 0.382348782060369 | 0.382471589779561 | false | false | ||||||||||||||||||
| 3fcf05df-3aff-4bcd-b986-6b812f89ab2d | 2026-09-23 15:39 | 2026-09-23 15:39 | 2026-09-23 15:39 | ABNB | ABNB261016C00150000 | call | 150.0000 | 2026-10-16 | 5.8500 | 5.7000 | 5.9000 | 149.8750 | 49701.00 | 46191.00 | 585.00 | 85 | 16 | 243 | 890 | 0.273033707865169 | 0.381847331741458 | 0.381847331741458 | false | false | ||||||||||||||||||
| 59c55c4a-5525-454b-b752-d94864b51f77 | 2026-09-23 15:36 | 2026-09-23 15:36 | 2026-09-23 15:36 | ABNB | ABNB270115C00200000 | call | 200.0000 | 2027-01-15 | 1.6800 | 1.5900 | 1.9700 | 150.2000 | 16772.00 | 0.00 | 16772.00 | 100 | 5 | 112 | 1262 | 0.0887480190174326 | 0.378242897849859 | 0.378242897849859 | false | false | ||||||||||||||||||
| 7076453d-44cc-4fea-8cb1-10ea46c4d480 | 2026-09-23 11:52 | 2026-09-23 11:52 | 2026-09-23 11:52 | ABNB | ABNB261016P00150000 | put | 150.0000 | 2026-10-16 | 4.1600 | 4.1500 | 4.3500 | 152.0000 | 71550.00 | 6800.00 | 64750.00 | 172 | 6 | 338 | 1348 | 0.250741839762611 | 0.363418778146158 | 0.361777573096635 | true | false | ||||||||||||||||||
| 6cebefc3-9362-4f85-838b-5093791d0438 | 2026-09-23 11:52 | 2026-09-23 11:52 | 2026-09-23 11:52 | ABNB | ABNB261009P00150000 | put | 150.0000 | 2026-10-09 | 3.3000 | 3.3000 | 3.5000 | 152.0000 | 506040.00 | 15980.00 | 35320.00 | 1532 | 26 | 1563 | 17 | 91.9411764705882 | 0.362763998387588 | 0.360826099818833 | false | false | ||||||||||||||||||
| 18d66389-55e9-4b7c-8a30-c962a8ff99eb | 2026-09-23 10:02 | 2026-09-23 10:02 | 2026-09-23 10:02 | ABNB | ABNB261120P00145000 | put | 145.0000 | 2026-11-20 | 5.3000 | 4.9500 | 5.4500 | 155.0000 | 62000.00 | 60945.00 | 1055.00 | 117 | 23 | 138 | 338 | 0.408284023668639 | 0.41625432499698 | 0.414656107218832 | false | false | ||||||||||||||||||
| 87cbf356-02a8-4682-8df9-6a11b29b8d01 | 2026-09-22 15:50 | 2026-09-22 15:50 | 2026-09-22 15:50 | ABNB | ABNB271217C00230000 | call | 230.0000 | 2027-12-17 | 11.1500 | 11.1000 | 11.8500 | 161.7800 | 137160.00 | 8925.00 | 127115.00 | 123 | 30 | 1015 | 967 | 1.04963805584281 | 0.378605165965863 | 0.377919021859232 | true | false | ||||||||||||||||||
| 2c341fe7-d4a6-408e-a0ee-85b722532eed | 2026-09-14 15:30 | 2026-09-14 15:30 | 2026-09-14 15:30 | ABNB | ABNB271217C00195000 | call | 195.0000 | 2027-12-17 | 24.2800 | 23.8500 | 24.0000 | 170.1450 | 60702.00 | 60702.00 | 0.00 | 25 | 5 | 233 | 391 | 0.595907928388747 | 0.39230503072502 | 0.39230503072502 | false | false | ||||||||||||||||||
| 6408e7c3-c1a8-42fc-847a-73fd04e96ef3 | 2026-09-02 13:00 | 2026-09-02 13:00 | 2026-09-02 13:00 | ABNB | ABNB270617P00185000 | put | 185.0000 | 2027-06-17 | 22.6400 | 21.9500 | 23.2500 | 183.1150 | 95100.00 | 79270.00 | 15830.00 | 42 | 14 | 44 | 184 | 0.239130434782609 | 0.386148948689813 | 0.385356347674043 | false | false | ||||||||||||||||||
| fc96f698-efd0-4939-971e-3b2a4f429ba2 | 2026-08-26 11:42 | 2026-08-26 11:42 | 2026-08-26 11:42 | ABNB | ABNB270617C00200000 | call | 200.0000 | 2027-06-17 | 24.0500 | 23.2500 | 24.0500 | 188.5300 | 122649.00 | 122649.00 | 0.00 | 51 | 18 | 51 | 466 | 0.109442060085837 | 0.388953316341282 | 0.388953316341282 | false | false | ||||||||||||||||||
| a051349e-fac8-4449-9d75-d53002b34b37 | 2026-08-26 11:31 | 2026-08-26 11:30 | 2026-08-26 11:30 | ABNB | ABNB261016P00185000 | put | 185.0000 | 2026-10-16 | 6.3300 | 6.2500 | 6.4500 | 189.0300 | 79105.00 | 54610.00 | 24495.00 | 125 | 13 | 151 | 881 | 0.171396140749149 | 0.307068123199667 | 0.306218679343551 | false | false | ||||||||||||||||||
| b4c0a180-4131-4b64-86c4-0082707fef05 | 2026-08-21 09:31 | 2026-08-21 09:31 | 2026-08-21 09:31 | ABNB | ABNB260828C00165000 | call | 165.0000 | 2026-08-28 | 21.0900 | 19.7500 | 23.1500 | 185.8200 | 92785.00 | 2090.00 | 90695.00 | 44 | 9 | 44 | 113 | 0.389380530973451 | 0.867188994640598 | 0.53431913318717 | false | false | ||||||||||||||||||
| d49387d4-d358-4d68-a2c2-a6a3eeb9452f | 2026-08-19 14:13 | 2026-08-19 14:13 | 2026-08-19 14:13 | ABNB | ABNB270917P00145000 | put | 145.0000 | 2027-09-17 | 9.5200 | 9.3500 | 11.7500 | 187.0800 | 91380.00 | 55755.00 | 35625.00 | 96 | 15 | 96 | 0 | 0 | 0.411289194111091 | 0.406963739536616 | true | false | ||||||||||||||||||
| b37e7f6a-61c8-45ca-a5de-519e9c4b0392 | 2026-08-18 12:48 | 2026-08-18 12:47 | 2026-08-18 12:47 | ABNB | ABNB270115C00230000 | call | 230.0000 | 2027-01-15 | 4.2000 | 4.2000 | 4.5000 | 185.1600 | 84075.00 | 0.00 | 84075.00 | 200 | 23 | 242 | 741 | 0.326585695006748 | 0.338546895169685 | 0.338546895169685 | false | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 65480173100.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:50:34.009292Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 65480173100.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:50:34.009292Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 65480173100.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:50:34.009292Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 65480173100.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:50:34.009292Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 66063319183.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:58:47.547545Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 62753230986.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:42:45.926021Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 62753230986.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:42:45.926021Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 62753230986.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:37:14.904379Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 62753230986.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:54:47.930702Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 62753230986.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:54:47.930702Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 62753230986.00 |
| 2026-11-05 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:02:33.967509Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 67884077456.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 71592718731.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 71592718731.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T17:36:40.694178Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 71592718731.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:48:55.759300Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 71592718731.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:48:55.759300Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 71592718731.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:35:10.222979Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 71592718731.00 |
| 2026-11-05 |
| 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 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 71592718731.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |