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_alerts566,287 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 |
|---|
| 5cd19dc8-30c8-4fac-8439-edb4cdba7462 | 2026-09-24 13:16 | 2026-09-24 13:16 | 2026-09-24 13:16 | ZETA | ZETA270115C00045000 | call | 45.0000 | 2027-01-15 | 0.8300 | 0.8300 | 0.8700 | 29.2400 | 16111.00 | 0.00 | 16111.00 | 194 | 22 | 1369 | 1414 | 0.968175388967468 | 0.661714942258406 | 0.659288400775554 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 6773506582.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-24T17:20:10.992675Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| 50c871d9-da13-4f20-bed0-e8c8a3dacf7c | 2026-09-24 13:05 | 2026-09-24 13:05 | 2026-09-24 13:05 | ZETA | ZETA280121C00045000 | call | 45.0000 | 2028-01-21 | 5.5500 | 5.5500 | 5.7500 | 29.5400 | 111060.00 | 0.00 | 111060.00 | 200 | 7 | 655 | 3823 | 0.171331415119016 | 0.67551147971177 | 0.67551147971177 | false | false | ||||||||||||||||||
| 33f46d4d-465b-4561-a481-be8c2f99796b | 2026-09-24 13:05 | 2026-09-24 13:04 | 2026-09-24 13:04 | ZETA | ZETA280121C00045000 | call | 45.0000 | 2028-01-21 | 5.5500 | 5.5500 | 5.7500 | 29.5400 | 111060.00 | 0.00 | 111060.00 | 200 | 8 | 455 | 3823 | 0.119016479204813 | 0.67551147971177 | 0.67551147971177 | false | false | ||||||||||||||||||
| 0d597fd0-f884-4acd-b073-e44a4b130383 | 2026-09-24 13:04 | 2026-09-24 13:04 | 2026-09-24 13:04 | ZETA | ZETA280121C00045000 | call | 45.0000 | 2028-01-21 | 5.5500 | 5.5500 | 5.7500 | 29.5450 | 110505.00 | 0.00 | 110505.00 | 199 | 8 | 255 | 3823 | 0.0667015432906095 | 0.675337058372077 | 0.675337058372077 | false | false | ||||||||||||||||||
| 3c9f5444-9899-4cc2-86eb-5f0bdb6b885a | 2026-09-16 10:49 | 2026-09-16 10:49 | 2026-09-16 10:49 | ZETA | ZETA260918P00030000 | put | 30.0000 | 2026-09-18 | 0.2300 | 0.2300 | 0.3000 | 31.2550 | 17163.00 | 0.00 | 17163.00 | 746 | 27 | 754 | 1038 | 0.726396917148362 | 0.770273731810694 | 0.755837774090244 | false | false | ||||||||||||||||||
| 4b02a6c1-0c59-4b50-8f93-ee8a409a1cd8 | 2026-09-11 10:42 | 2026-09-11 10:42 | 2026-09-11 10:42 | ZETA | ZETA280121C00035000 | call | 35.0000 | 2028-01-21 | 8.5500 | 8.5500 | 9.1000 | 30.4400 | 25654.00 | 0.00 | 25654.00 | 30 | 5 | 78 | 5783 | 0.0134878090956251 | 0.678155248655828 | 0.677417636924534 | false | false | ||||||||||||||||||
| cacec5bc-591d-4368-977b-f88af6010383 | 2026-09-04 14:02 | 2026-09-04 14:02 | 2026-09-04 14:02 | ZETA | ZETA260904C00030000 | call | 30.0000 | 2026-09-04 | 1.3100 | 1.2600 | 1.3200 | 31.3200 | 26222.00 | 21932.00 | 0.00 | 200 | 12 | 919 | 2752 | 0.333938953488372 | 0.976115176142344 | 0.976115176142344 | true | false | ||||||||||||||||||
| 9e829676-5afb-475d-9bd2-317746f6381c | 2026-09-04 12:42 | 2026-09-04 12:42 | 2026-09-04 12:42 | ZETA | ZETA261218C00030000 | call | 30.0000 | 2026-12-18 | 5.4400 | 5.4000 | 5.6500 | 31.6100 | 266479.00 | 201564.00 | 64915.00 | 490 | 48 | 528 | 6697 | 0.078841272211438 | 0.675958529485143 | 0.675958529485143 | false | false | ||||||||||||||||||
| 72f9f1a5-a31a-423a-baeb-573b89cbc758 | 2026-09-03 09:38 | 2026-09-03 09:38 | 2026-09-03 09:38 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 3.1000 | 2.7500 | 3.2000 | 32.4600 | 24768.00 | 24768.00 | 0.00 | 80 | 14 | 240 | 11603 | 0.0206843057829872 | 0.607251051644644 | 0.607251051644644 | false | false | ||||||||||||||||||
| dcdc453f-4e55-4d6e-8f6a-78a6a2eb5d5c | 2026-08-31 14:01 | 2026-08-31 14:01 | 2026-08-31 14:01 | ZETA | ZETA270319P00030000 | put | 30.0000 | 2027-03-19 | 5.2000 | 5.0500 | 5.4500 | 30.0000 | 250999.00 | 246839.00 | 4160.00 | 483 | 23 | 849 | 29 | 29.2758620689655 | 0.66724740463092 | 0.66724740463092 | false | false | ||||||||||||||||||
| 5e333f44-e5d5-4297-a87a-e58ee49489ad | 2026-08-27 14:44 | 2026-08-27 14:44 | 2026-08-27 14:44 | ZETA | ZETA270115C00030000 | call | 30.0000 | 2027-01-15 | 4.9000 | 4.9000 | 5.1000 | 30.0350 | 34332.00 | 0.00 | 34332.00 | 70 | 5 | 242 | 18209 | 0.0132901312537756 | 0.636602718729668 | 0.636602718729668 | false | false | ||||||||||||||||||
| c3e7a60c-f631-47cd-b878-dc164411275c | 2026-08-25 15:09 | 2026-08-25 15:09 | 2026-08-25 15:09 | ZETA | ZETA281215C00025000 | call | 25.0000 | 2028-12-15 | 12.9500 | 12.9500 | 13.6500 | 27.8900 | 119141.00 | 0.00 | 119141.00 | 92 | 5 | 297 | 1537 | 0.193233571893299 | 0.694626965692687 | 0.693858353738381 | false | false | ||||||||||||||||||
| 3f60f83f-cec9-4b05-aef0-9175239da208 | 2026-08-24 09:50 | 2026-08-24 09:50 | 2026-08-24 09:50 | ZETA | ZETA270115P00025000 | put | 25.0000 | 2027-01-15 | 2.6200 | 2.6100 | 2.8000 | 28.8000 | 81329.00 | 0.00 | 62758.00 | 311 | 10 | 2304 | 621 | 3.71014492753623 | 0.663617139763306 | 0.661972398637365 | false | false | ||||||||||||||||||
| 39531ece-52e5-45c6-bfab-370fd20de792 | 2026-08-24 09:50 | 2026-08-24 09:50 | 2026-08-24 09:50 | ZETA | ZETA270115P00025000 | put | 25.0000 | 2027-01-15 | 2.6200 | 2.5700 | 2.8100 | 28.8050 | 65414.00 | 2620.00 | 42620.00 | 250 | 9 | 1993 | 621 | 3.20933977455717 | 0.663846658394627 | 0.662201857637643 | false | false | ||||||||||||||||||
| 604940db-46d9-4634-ae41-6597eda62b88 | 2026-08-24 09:48 | 2026-08-24 09:48 | 2026-08-24 09:48 | ZETA | ZETA270115P00025000 | put | 25.0000 | 2027-01-15 | 2.5700 | 2.4500 | 2.6900 | 28.9600 | 28473.00 | 0.00 | 21277.00 | 111 | 9 | 375 | 621 | 0.603864734299517 | 0.662679557162846 | 0.661030706808649 | false | false | ||||||||||||||||||
| 1841c5ac-0460-43b2-b755-44bf9f33ee1b | 2026-08-24 09:48 | 2026-08-24 09:48 | 2026-08-24 09:48 | ZETA | ZETA270115P00025000 | put | 25.0000 | 2027-01-15 | 2.5800 | 2.4500 | 2.7700 | 28.8800 | 37682.00 | 4656.00 | 22185.00 | 146 | 14 | 170 | 621 | 0.273752012882448 | 0.662340255805898 | 0.659045893602299 | false | false | ||||||||||||||||||
| 8b62f563-d444-4f41-b1ef-f050143ebee7 | 2026-08-21 09:54 | 2026-08-21 09:54 | 2026-08-21 09:54 | ZETA | ZETA260918C00030000 | call | 30.0000 | 2026-09-18 | 0.9000 | 0.7800 | 1.0400 | 27.3900 | 96425.00 | 77983.00 | 18352.00 | 1072 | 38 | 2103 | 7120 | 0.295365168539326 | 0.606339359347146 | 0.6015548556131 | true | false |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6773506582.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:08:54.073871Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6773506582.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:08:54.073871Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 6773506582.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:08:54.073871Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7014524272.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T18:34:11.376593Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:45:03.310585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T18:25:38.432903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T19:21:53.483381Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |