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_alerts474,253 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 |
|---|
| 8f5687b8-6cc3-49e0-a1cd-847ab6382a33 | 2026-09-23 15:51 | 2026-09-23 15:51 | 2026-09-23 15:51 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 6.0000 | 5.9000 | 6.0000 | 745.0700 | 16200.00 | 16200.00 | 0.00 | 27 | 7 | 2160 | 1787 | 1.20872971460548 | 0.714243524581444 | 0.714243524581444 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1640836123547.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T19:54:40.302966Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 8d5b2346-a3db-4e42-8275-eef47e580238 | 2026-09-22 15:57 | 2026-09-22 15:57 | 2026-09-22 15:57 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 8.7500 | 8.7500 | 8.8000 | 736.2000 | 20125.00 | 0.00 | 20125.00 | 23 | 12 | 2321 | 1318 | 1.76100151745068 | 0.59161152793948 | 0.592971423056599 | true | false | false | true | ||||||||||||||||
| 01825ad8-bbd6-4397-83bc-fad859d7d375 | 2026-09-22 11:21 | 2026-09-22 11:21 | 2026-09-22 11:21 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 5.5500 | 5.5500 | 5.7500 | 749.0500 | 18870.00 | 0.00 | 18870.00 | 34 | 7 | 1452 | 1318 | 1.10166919575114 | 0.603376841856558 | 0.607757849146054 | true | false | false | true | ||||||||||||||||
| 5f1e97d3-95fe-4ea8-8c52-87c6efcf0ec9 | 2026-09-22 10:32 | 2026-09-22 10:32 | 2026-09-22 10:32 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 5.6900 | 5.3500 | 5.7000 | 749.8700 | 56856.00 | 56856.00 | 0.00 | 100 | 8 | 1149 | 1318 | 0.871775417298938 | 0.623192616337822 | 0.623682259886553 | false | false | false | true | ||||||||||||||||
| 20001630-bfdf-4d76-bf24-e2666027e77b | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 11.4500 | 10.8500 | 11.4500 | 733.1800 | 10305.00 | 10305.00 | 0.00 | 9 | 8 | 33 | 1318 | 0.0250379362670713 | 0.659972525891271 | 0.659972525891271 | false | false | false | true | ||||||||||||||||
| 57ca41ca-1f27-421d-890c-50fccf116e87 | 2026-09-21 15:50 | 2026-09-21 15:50 | 2026-09-21 15:50 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 8.0300 | 7.8500 | 8.3500 | 746.9700 | 40166.00 | 0.00 | 40166.00 | 50 | 6 | 3057 | 11 | 277.909090909091 | 0.606905969466849 | 0.606905969466849 | false | false | false | true | ||||||||||||||||
| bc9ac781-f6a7-4efa-8900-5ad9bd341691 | 2026-09-21 15:40 | 2026-09-21 15:40 | 2026-09-21 15:40 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 8.0000 | 7.8000 | 8.0000 | 747.7000 | 20800.00 | 20800.00 | 0.00 | 26 | 12 | 2979 | 11 | 270.818181818182 | 0.612925895035154 | 0.612925895035154 | false | false | false | true | ||||||||||||||||
| 8ea7899e-f8cb-4342-8b82-a262436bc419 | 2026-09-21 15:10 | 2026-09-21 15:10 | 2026-09-21 15:10 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 8.6500 | 8.5500 | 8.6500 | 743.1700 | 12110.00 | 12110.00 | 0.00 | 14 | 5 | 2626 | 11 | 238.727272727273 | 0.589673600211641 | 0.589673600211641 | false | false | false | true | ||||||||||||||||
| 96e3101d-b09f-4e5d-9913-b6df54772126 | 2026-09-21 14:49 | 2026-09-21 14:48 | 2026-09-21 14:48 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 8.4000 | 8.2500 | 8.4000 | 747.0000 | 23520.00 | 23520.00 | 0.00 | 28 | 8 | 2137 | 11 | 194.272727272727 | 0.62364555464876 | 0.62364555464876 | false | false | false | true | ||||||||||||||||
| cb302fc8-a204-4efa-ad46-4d2c549fce6d | 2026-09-21 14:32 | 2026-09-21 14:32 | 2026-09-21 14:32 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 8.4000 | 8.2500 | 8.4000 | 747.0000 | 10920.00 | 10920.00 | 0.00 | 13 | 7 | 1980 | 11 | 180 | 0.62364555464876 | 0.62364555464876 | false | false | false | true | ||||||||||||||||
| b9aa12af-2132-4787-8743-deb06ba803cd | 2026-09-21 14:12 | 2026-09-21 14:12 | 2026-09-21 14:12 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 9.0500 | 8.9000 | 9.0500 | 743.1650 | 11765.00 | 11765.00 | 0.00 | 13 | 5 | 1758 | 11 | 159.818181818182 | 0.604569275394707 | 0.604569275394707 | false | false | false | true | ||||||||||||||||
| 131ce735-a13e-4677-a50b-a4375ebfc426 | 2026-09-21 13:07 | 2026-09-21 13:07 | 2026-09-21 13:07 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 11.8000 | 11.6000 | 11.8000 | 733.3950 | 10620.00 | 10620.00 | 0.00 | 9 | 6 | 1237 | 11 | 112.454545454545 | 0.587452310508972 | 0.587452310508972 | true | false | false | true | ||||||||||||||||
| a12d8b7b-293a-493e-bd56-7ed886330e33 | 2026-09-21 12:57 | 2026-09-21 12:57 | 2026-09-21 12:57 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 13.0000 | 12.9000 | 13.0000 | 727.9400 | 55900.00 | 55900.00 | 0.00 | 43 | 17 | 1132 | 11 | 102.909090909091 | 0.556014513083701 | 0.556014513083701 | true | false | false | true | ||||||||||||||||
| aa68c5c4-63b3-496d-96d2-514acd68a6e5 | 2026-09-21 12:53 | 2026-09-21 12:53 | 2026-09-21 12:53 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 12.8000 | 12.8000 | 12.9000 | 728.0000 | 21760.00 | 0.00 | 21760.00 | 17 | 5 | 1082 | 11 | 98.3636363636364 | 0.553547278100615 | 0.553822816775348 | false | false | false | true | ||||||||||||||||
| f4c41481-2d89-47e1-a7e6-8f7b48d29ca0 | 2026-09-21 11:53 | 2026-09-21 11:53 | 2026-09-21 11:53 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 16.2000 | 16.0000 | 16.2000 | 720.2400 | 87480.00 | 87480.00 | 0.00 | 54 | 19 | 590 | 11 | 53.6363636363636 | 0.548004225713624 | 0.548004225713624 | true | false | false | true | ||||||||||||||||
| 3e158a87-2d9e-4045-b0b7-88f062fb1907 | 2026-09-21 10:57 | 2026-09-21 10:57 | 2026-09-21 10:57 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 20.1000 | 20.1000 | 20.4000 | 710.9801 | 22111.00 | 0.00 | 22111.00 | 11 | 7 | 340 | 11 | 30.9090909090909 | 0.514065069588358 | 0.514065069588358 | false | false | false | true | ||||||||||||||||
| c6600c2f-bfa7-4896-a47b-2678378c8823 | 2026-09-21 10:41 | 2026-09-21 10:41 | 2026-09-21 10:41 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 20.2500 | 20.2500 | 20.3000 | 710.9250 | 54675.00 | 0.00 | 54675.00 | 27 | 12 | 317 | 11 | 28.8181818181818 | 0.516242579173802 | 0.518122310594818 | true | false | false | true | ||||||||||||||||
| 78818644-e3a9-48a4-bcc3-277deabc431b | 2026-09-21 10:40 | 2026-09-21 10:40 | 2026-09-21 10:40 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 20.5500 | 20.3000 | 20.5500 | 710.7200 | 10275.00 | 10275.00 | 0.00 | 5 | 5 | 283 | 11 | 25.7272727272727 | 0.5249489837339 | 0.524351476876542 | false | false | false | true | ||||||||||||||||
| ede0e5c0-f6e8-4a6a-8a0d-17d38afecfd8 | 2026-09-21 10:35 | 2026-09-21 10:35 | 2026-09-21 10:35 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 20.0000 | 20.0000 | 20.1500 | 711.5200 | 20002.00 | 0.00 | 20002.00 | 10 | 7 | 274 | 11 | 24.9090909090909 | 0.521631808639423 | 0.52128967650456 | true | false | false | true | ||||||||||||||||
| 92b5df16-e3be-4965-acde-404c93e22360 | 2026-09-21 10:18 | 2026-09-21 10:18 | 2026-09-21 10:18 | META | META260925P00720000 | put | 720.0000 | 2026-09-25 | 19.8500 | 19.7000 | 19.8500 | 712.6892 | 13895.00 | 13895.00 | 0.00 | 7 | 7 | 233 | 11 | 21.1818181818182 | 0.538683388400793 | 0.538683388400793 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:21:55.684470Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:34:01.762519Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:30:37.895663Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:52:57.186278Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:43:03.886437Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:15:34.344712Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:50:33.734980Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:32:54.184324Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:15:35.599753Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:07:15.058898Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:02:00.389820Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:56:43.151057Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:56:02.019393Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:59:04.068372Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:42:35.959490Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:42:35.959490Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:37:14.719915Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:18:27.541285Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |