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 | 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 |
|---|
| 5a0e5551-e081-47b1-b217-8439ea5c3501 | 2026-09-30 11:27 | 2026-09-30 11:27 | 2026-09-30 11:27 | PRAX | PRAX261218P00280000 | put | 280.0000 | 2026-12-18 | 33.5900 | 30.7000 | 33.7000 | 287.6500 | 63820.00 | 63820.00 | 0.00 | 19 | 6 | 270 | 133 | 2.03007518796993 | 0.742546815600733 | 0.737694639363009 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 7845516628.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T15:32:55.573100Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| efbcd001-74d4-4c78-9231-e2ce9296e899 | 2026-09-30 09:44 | 2026-09-30 09:43 | 2026-09-30 09:43 | PRAX | PRAX261218C00350000 | call | 350.0000 | 2026-12-18 | 16.4000 | 16.4000 | 19.6000 | 284.0000 | 100040.00 | 0.00 | 93480.00 | 61 | 60 | 61 | 444 | 0.137387387387387 | 0.686944626430578 | 0.686944626430578 | false | false | false | true | ||||||||||||||||
| 1a15c85b-922e-4f29-8718-24e241607f14 | 2026-09-29 15:36 | 2026-09-29 15:36 | 2026-09-29 15:36 | PRAX | PRAX261218C00350000 | call | 350.0000 | 2026-12-18 | 15.5000 | 15.5000 | 17.4000 | 281.0000 | 31000.00 | 0.00 | 31000.00 | 20 | 7 | 269 | 175 | 1.53714285714286 | 0.688621508541928 | 0.688621508541928 | false | false | false | true | ||||||||||||||||
| b7cc168c-9c8b-4271-a81e-2bb1c39492f3 | 2026-09-29 13:55 | 2026-09-29 13:55 | 2026-09-29 13:55 | PRAX | PRAX261218C00350000 | call | 350.0000 | 2026-12-18 | 15.4000 | 15.4000 | 16.7000 | 279.6100 | 120120.00 | 0.00 | 4620.00 | 78 | 38 | 249 | 175 | 1.42285714285714 | 0.696388663065844 | 0.696388663065844 | false | false | false | true | ||||||||||||||||
| 90a2ba4c-ee08-4d58-a40a-721cb94254a1 | 2026-09-29 12:33 | 2026-09-29 12:33 | 2026-09-29 12:33 | PRAX | PRAX261218C00350000 | call | 350.0000 | 2026-12-18 | 15.4000 | 15.4000 | 16.8000 | 279.0000 | 50820.00 | 0.00 | 50820.00 | 33 | 21 | 171 | 175 | 0.977142857142857 | 0.694980234215821 | 0.694980234215821 | false | false | false | true | ||||||||||||||||
| 58fbd3fa-e703-43d3-bb92-a6413cabc327 | 2026-09-29 11:08 | 2026-09-29 11:08 | 2026-09-29 11:08 | PRAX | PRAX261218C00350000 | call | 350.0000 | 2026-12-18 | 15.7000 | 15.7000 | 17.0000 | 281.0000 | 70650.00 | 0.00 | 70650.00 | 45 | 15 | 138 | 175 | 0.788571428571429 | 0.690222157930027 | 0.690222157930027 | false | false | false | true | ||||||||||||||||
| 224b9823-dbbe-400b-b25b-4b52880b5c6e | 2026-09-29 10:15 | 2026-09-29 10:15 | 2026-09-29 10:15 | PRAX | PRAX261218C00350000 | call | 350.0000 | 2026-12-18 | 15.3000 | 15.3000 | 16.5000 | 281.3750 | 44370.00 | 0.00 | 44370.00 | 29 | 13 | 93 | 175 | 0.531428571428571 | 0.682417286409183 | 0.682417286409183 | false | false | false | true | ||||||||||||||||
| 3b52e642-0c45-4bcb-ac0d-826c9a61e454 | 2026-09-29 10:06 | 2026-09-29 10:06 | 2026-09-29 10:06 | PRAX | PRAX261218C00350000 | call | 350.0000 | 2026-12-18 | 15.5000 | 15.0000 | 18.6000 | 281.2200 | 23250.00 | 15500.00 | 6200.00 | 15 | 10 | 62 | 175 | 0.354285714285714 | 0.68775017869909 | 0.68775017869909 | true | false | false | true | ||||||||||||||||
| c74be343-fab4-44c0-981d-df3f5a4ba0e3 | 2026-09-29 09:37 | 2026-09-29 09:37 | 2026-09-29 09:37 | PRAX | PRAX261218C00350000 | call | 350.0000 | 2026-12-18 | 16.3000 | 16.3000 | 19.9000 | 284.5400 | 27710.00 | 0.00 | 27710.00 | 17 | 6 | 17 | 175 | 0.0971428571428571 | 0.682356347313947 | 0.682356347313947 | false | false | false | true | ||||||||||||||||
| ff99972f-5535-48fe-8f82-20d789e35c01 | 2026-09-28 13:25 | 2026-09-28 13:25 | 2026-09-28 13:25 | PRAX | PRAX261218C00350000 | call | 350.0000 | 2026-12-18 | 17.5000 | 17.5000 | 18.6000 | 287.7300 | 82250.00 | 0.00 | 45500.00 | 47 | 31 | 164 | 5 | 32.8 | 0.681102436230166 | 0.681102436230166 | false | false | false | true | ||||||||||||||||
| db0a0972-82fb-4fa6-aade-6a2e60212892 | 2026-09-28 12:58 | 2026-09-28 12:58 | 2026-09-28 12:58 | PRAX | PRAX261218C00350000 | call | 350.0000 | 2026-12-18 | 17.5000 | 17.5000 | 18.2000 | 288.1600 | 54250.00 | 0.00 | 19250.00 | 31 | 22 | 117 | 5 | 23.4 | 0.678175780849696 | 0.678175780849696 | true | false | false | true | ||||||||||||||||
| f2cd4fde-c417-4bde-a284-483e3e2665fc | 2026-09-28 11:27 | 2026-09-28 11:27 | 2026-09-28 11:27 | PRAX | PRAX261218C00350000 | call | 350.0000 | 2026-12-18 | 17.4000 | 17.4000 | 19.0000 | 287.7000 | 52200.00 | 0.00 | 52200.00 | 30 | 22 | 86 | 5 | 17.2 | 0.679284906147221 | 0.679284906147221 | false | false | false | true | ||||||||||||||||
| 44f86234-3440-43ee-a90a-b8e742936ca3 | 2026-09-28 10:43 | 2026-09-28 10:43 | 2026-09-28 10:43 | PRAX | PRAX261218C00350000 | call | 350.0000 | 2026-12-18 | 16.6000 | 16.6000 | 19.0000 | 285.4700 | 48140.00 | 0.00 | 48140.00 | 29 | 21 | 55 | 5 | 11 | 0.678041126034222 | 0.678041126034222 | false | false | false | true | ||||||||||||||||
| e2e44342-e458-449a-99fa-8a0bce26ec81 | 2026-09-28 10:39 | 2026-09-28 10:39 | 2026-09-28 10:39 | PRAX | PRAX261218C00350000 | call | 350.0000 | 2026-12-18 | 15.0000 | 15.0000 | 19.0000 | 285.6400 | 33000.00 | 0.00 | 16500.00 | 22 | 13 | 22 | 5 | 4.4 | 0.643644963050709 | 0.643644963050709 | false | false | false | true | ||||||||||||||||
| 5907f9c5-5807-4239-8333-946257482852 | 2026-08-28 12:40 | 2026-08-28 12:40 | 2026-08-28 12:40 | PRAX | PRAX260918P00330000 | put | 330.0000 | 2026-09-18 | 8.5000 | 7.8000 | 8.5000 | 348.2000 | 11050.00 | 11050.00 | 0.00 | 13 | 13 | 17 | 41 | 0.414634146341463 | 0.501363912994569 | 0.501363912994569 | false | false | false | true |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 7845516628.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T13:46:07.580767Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 7845516628.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T19:43:26.980226Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 7845516628.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T17:58:05.042752Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 7845516628.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:39:28.276769Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 7845516628.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:12:41.685966Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 7845516628.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:16:47.847178Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 7845516628.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:10:17.656675Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 7845516628.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:39:45.253242Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 7975344572.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:33:20.125658Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 7975344572.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:04:44.009732Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 7975344572.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:32:36.194150Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 7975344572.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:43:59.804397Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 7975344572.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:39:59.726153Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 9228952033.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |