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_alerts609,118 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 |
|---|
| 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 |
|---|
| 079bee62-d518-451f-b394-b279a5e39ac2 | 2026-09-16 14:47 | 2026-09-16 14:47 | 2026-09-16 14:47 | ON | ON260918P00070000 | put | 70.0000 | 2026-09-18 | 3.3500 | 3.3500 | 4.1000 | 67.6200 | 61975.00 | 0.00 | 61975.00 | 185 | 5 | 1766 | 3642 | 0.484898407468424 | 0.956513715029408 | 0.956513715029408 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 25928160619.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| bd08d93e-03f0-4224-80fd-be61c86463eb | 2026-09-16 14:45 | 2026-09-16 14:45 | 2026-09-16 14:45 | ON | ON260918P00070000 | put | 70.0000 | 2026-09-18 | 3.2000 | 2.7400 | 3.2000 | 67.9400 | 14400.00 | 14400.00 | 0.00 | 45 | 9 | 1564 | 3642 | 0.42943437671609 | 0.989511742117679 | 0.989511742117679 | false | false | false | true | ||||||||||||||||
| 0cbc239f-31b5-42a0-a44b-1d74cf3b4fe3 | 2026-09-16 14:45 | 2026-09-16 14:45 | 2026-09-16 14:45 | ON | ON260918P00070000 | put | 70.0000 | 2026-09-18 | 3.2000 | 2.7400 | 3.2000 | 67.9800 | 17600.00 | 17600.00 | 0.00 | 55 | 11 | 1519 | 3642 | 0.417078528281164 | 1.00314978075091 | 1.00314978075091 | false | false | false | true | ||||||||||||||||
| 98e06a5e-89cd-45ae-8251-4ab52b2fc154 | 2026-09-16 14:45 | 2026-09-16 14:45 | 2026-09-16 14:45 | ON | ON260918P00070000 | put | 70.0000 | 2026-09-18 | 3.3000 | 2.9800 | 3.3000 | 67.8000 | 22110.00 | 22110.00 | 0.00 | 67 | 16 | 1464 | 3642 | 0.401976935749588 | 0.994456508621419 | 0.994456508621419 | false | false | false | true | ||||||||||||||||
| 19df6c50-db28-430c-b544-f0b9207eafff | 2026-09-16 14:44 | 2026-09-16 14:44 | 2026-09-16 14:44 | ON | ON260918P00070000 | put | 70.0000 | 2026-09-18 | 3.1000 | 2.7400 | 3.1000 | 68.0000 | 34410.00 | 34410.00 | 0.00 | 111 | 11 | 1397 | 3642 | 0.383580450302032 | 0.956786352839675 | 0.956786352839675 | false | false | false | true | ||||||||||||||||
| af75d02c-a8f9-4e60-9f76-b40b11b79e42 | 2026-09-16 14:44 | 2026-09-16 14:44 | 2026-09-16 14:44 | ON | ON260918P00070000 | put | 70.0000 | 2026-09-18 | 3.0000 | 2.6900 | 3.2500 | 68.4900 | 33300.00 | 33300.00 | 0.00 | 111 | 11 | 1285 | 3642 | 0.35282811641955 | 1.06217481803969 | 1.06217481803969 | false | false | false | true | ||||||||||||||||
| 7ce447e4-e81c-418d-a91c-2f4596a603e9 | 2026-09-16 14:44 | 2026-09-16 14:44 | 2026-09-16 14:44 | ON | ON260918P00070000 | put | 70.0000 | 2026-09-18 | 2.7500 | 2.5500 | 2.7500 | 68.7200 | 30525.00 | 30525.00 | 0.00 | 111 | 23 | 1174 | 3642 | 0.322350356946733 | 1.00409824665004 | 1.00409824665004 | false | false | false | true | ||||||||||||||||
| e56a3ecc-8b05-4c37-b9a4-c4103f537cc8 | 2026-09-16 14:43 | 2026-09-16 14:43 | 2026-09-16 14:43 | ON | ON260918P00070000 | put | 70.0000 | 2026-09-18 | 2.6500 | 2.5900 | 2.6500 | 68.6800 | 103085.00 | 13250.00 | 0.00 | 389 | 14 | 1063 | 3642 | 0.291872597473915 | 0.941709286803337 | 0.941709286803337 | false | false | false | true | ||||||||||||||||
| 5786541b-82f2-4aa6-be1f-418a17662854 | 2026-09-16 14:43 | 2026-09-16 14:43 | 2026-09-16 14:43 | ON | ON260918P00070000 | put | 70.0000 | 2026-09-18 | 2.6000 | 2.4500 | 2.6000 | 68.9500 | 24960.00 | 24960.00 | 0.00 | 96 | 22 | 659 | 3642 | 0.180944535969248 | 1.01742922287495 | 0.995110235509044 | false | false | false | true | ||||||||||||||||
| f8bfdfb3-d692-426f-bfe6-de699b80a425 | 2026-09-14 14:27 | 2026-09-14 14:27 | 2026-09-14 14:27 | ON | ON260918P00070000 | put | 70.0000 | 2026-09-18 | 1.3900 | 1.1900 | 1.3900 | 72.3100 | 13483.00 | 13483.00 | 0.00 | 97 | 20 | 344 | 3801 | 0.0905024993422783 | 0.801113824283429 | 0.801113824283429 | false | false | false | true | ||||||||||||||||
| 444e20ab-e772-43b7-ba24-489ccd38d877 | 2026-08-18 14:41 | 2026-08-18 14:41 | 2026-08-18 14:41 | ON | ON260918P00070000 | put | 70.0000 | 2026-09-18 | 1.6900 | 1.6900 | 1.7400 | 78.5900 | 26533.00 | 0.00 | 26533.00 | 157 | 7 | 319 | 3058 | 0.10431654676259 | 0.56757288121289 | 0.56757288121289 | false | false | false | true | ||||||||||||||||
| a58c16b8-1a95-4525-87d3-a54ebe44c98b | 2026-08-18 13:52 | 2026-08-18 13:52 | 2026-08-18 13:52 | ON | ON260918P00070000 | put | 70.0000 | 2026-09-18 | 1.7900 | 1.7300 | 1.8300 | 78.1500 | 13425.00 | 7339.00 | 6086.00 | 75 | 6 | 132 | 3058 | 0.0431654676258993 | 0.567147445066304 | 0.568293167148591 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 25928160619.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 25928160619.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 25928160619.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 25928160619.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 25928160619.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:44:45.237115Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 25928160619.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:44:45.237115Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 25928160619.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:44:45.237115Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 25928160619.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:44:45.237115Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 27894184810.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T18:49:41.095224Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 27894184810.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:49:07.657249Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 27894184810.00 |
| 2026-11-02 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |