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_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 | strikenumeric | expirydate |
|---|
| 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 |
|---|
| 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 | false | 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 |
| 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 | false | true | ||||||||||||||||
| e37583cd-36bc-452d-816d-384fd2a167ea | 2026-08-24 09:50 | 2026-08-24 09:49 | 2026-08-24 09:49 | ZETA | ZETA270115P00025000 | put | 25.0000 | 2027-01-15 | 2.6300 | 2.6000 | 2.8400 | 28.7550 | 29982.00 | 7627.00 | 22355.00 | 114 | 5 | 1606 | 621 | 2.58615136876006 | 0.663191188043882 | 0.663191188043882 | false | false | false | true | ||||||||||||||||
| 7c9fba25-33ff-4042-bcf8-cbcab4b322bb | 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.8300 | 28.7600 | 30909.00 | 0.00 | 30909.00 | 118 | 6 | 1743 | 621 | 2.80676328502415 | 0.661777716821489 | 0.660133451846696 | false | false | false | true | ||||||||||||||||
| 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 | false | true | ||||||||||||||||
| 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 | false | true | ||||||||||||||||
| c8b6fd23-9898-4086-8111-4f0220f26499 | 2026-08-25 13:47 | 2026-08-25 13:47 | 2026-08-25 13:47 | ZETA | ZETA270115P00025000 | put | 25.0000 | 2027-01-15 | 2.8500 | 2.8500 | 2.9000 | 27.8450 | 60135.00 | 0.00 | 60135.00 | 211 | 7 | 219 | 2602 | 0.0841660261337433 | 0.657429607781165 | 0.657680217662937 | false | false | false | true |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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 |
| 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 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 7050904301.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T17:59:30.582778Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |