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_alerts658,639 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 |
|---|
| d74f658b-6ce0-4278-a452-8823e29b043f | 2026-09-30 13:53 | 2026-09-30 13:53 | 2026-09-30 13:53 | TLN | TLN270115P00280000 | put | 280.0000 | 2027-01-15 | 19.3000 | 17.8000 | 21.5000 | 316.4700 | 1158000.00 | 0.00 | 1158000.00 | 600 | 1 | 601 | 36 | 16.6944444444444 | 0.56192508467167 | 0.56192508467167 | false | true | false | true | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Utilities | 15085325304.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-30T17:55:15.856475Z"} | 2026-09-30 | 2026-09-30 21:15 | 2026-09-30 21:15 |
| 68c3ecfd-17da-440f-b3ca-4f1f0107c625 | 2026-09-30 11:29 | 2026-09-30 11:29 | 2026-09-30 11:29 | PEG | PEG261120P00075000 | put | 75.0000 | 2026-11-20 | 7.1000 | 6.4000 | 7.9000 | 67.7250 | 53250.00 | 0.00 | 53250.00 | 75 | 1 | 75 | 36 | 2.08333333333333 | 0.202794850134028 | 0.202794850134028 | false | true | ||||||||||||||||||
| d12f2ebc-c132-479d-ad75-8b610214fa4d | 2026-09-28 10:51 | 2026-09-28 10:51 | 2026-09-28 10:51 | NRGV | NRGV270115C00007000 | call | 7.0000 | 2027-01-15 | 0.4000 | 0.0500 | 0.6500 | 4.1350 | 80000.00 | 80000.00 | 0.00 | 2000 | 1 | 2000 | 20154 | 0.0992358836955443 | 1.17444752780432 | 1.17444752780432 | false | true | ||||||||||||||||||
| ceadf622-b835-47a9-b811-8b0b38c2862e | 2026-09-28 10:51 | 2026-09-28 10:51 | 2026-09-28 10:51 | NRGV | NRGV270115C00004000 | call | 4.0000 | 2027-01-15 | 1.0500 | 0.7500 | 1.3500 | 4.1350 | 105000.00 | 0.00 | 0.00 | 1000 | 1 | 1000 | 34285 | 0.029167274318215 | 1.09911334212085 | 1.09911334212085 | false | true | ||||||||||||||||||
| a3f8e738-9496-4cac-ae67-6079f1b4070d | 2026-09-25 15:14 | 2026-09-25 15:14 | 2026-09-25 15:14 | PAM | PAM261218P00065000 | put | 65.0000 | 2026-12-18 | 1.5000 | 0.6500 | 3.0000 | 78.0800 | 79500.00 | 0.00 | 79500.00 | 530 | 1 | 530 | 557 | 0.951526032315978 | 0.444774931526788 | 0.444774931526788 | false | true | ||||||||||||||||||
| 4bad4dcc-4da4-4954-aa2c-87ba5a66296b | 2026-09-15 15:48 | 2026-09-15 15:48 | 2026-09-15 15:48 | MWH | MWH270416C00035000 | call | 35.0000 | 2027-04-16 | 2.4500 | 2.1500 | 2.5500 | 25.0000 | 245000.00 | 245000.00 | 0.00 | 1000 | 6 | 1001 | 1003 | 0.998005982053839 | 0.645817834780421 | 0.645817834780421 | false | true | ||||||||||||||||||
| 8a59d9b7-6b1e-42bf-8133-dc2353626d1f | 2026-09-14 12:46 | 2026-09-14 12:46 | 2026-09-14 12:46 | CEG | CEG261023P00225000 | put | 225.0000 | 2026-10-23 | 2.0000 | 1.1750 | 3.6000 | 266.0900 | 1088000.00 | 0.00 | 1088000.00 | 5440 | 1 | 5441 | 0 | 0 | 0.441184265463206 | 0.441184265463206 | false | true | ||||||||||||||||||
| 87e8c8b5-c081-4028-ade0-acbafe0d943e | 2026-09-03 13:35 | 2026-09-03 13:35 | 2026-09-03 13:35 | CNP | CNP260918C00040000 | call | 40.0000 | 2026-09-18 | 0.5000 | 0.5000 | 0.8000 | 40.0050 | 135000.00 | 0.00 | 135000.00 | 2700 | 1 | 2701 | 800 | 3.37625 | 0.14393069519557 | 0.14393069519557 | false | true | ||||||||||||||||||
| 714e74be-5574-45e1-9f4a-4e480b41cd50 | 2026-09-02 15:51 | 2026-09-02 15:50 | 2026-09-02 15:50 | AEP | AEP261120C00130000 | call | 130.0000 | 2026-11-20 | 2.4000 | 2.2500 | 2.5500 | 123.7150 | 240000.00 | 0.00 | 0.00 | 1000 | 1 | 1021 | 1554 | 0.657014157014157 | 0.193272704049728 | 0.193272704049728 | false | true | ||||||||||||||||||
| 25f063d5-487c-4350-b96d-290219fb9325 | 2026-09-02 13:43 | 2026-09-02 13:42 | 2026-09-02 13:42 | EVRG | EVRG261016C00082500 | call | 82.5000 | 2026-10-16 | 1.4000 | 1.3000 | 1.7500 | 81.1650 | 64820.00 | 0.00 | 64820.00 | 463 | 1 | 463 | 2 | 231.5 | 0.162350078268107 | 0.162350078268107 | false | true | ||||||||||||||||||
| a30d6547-b3a1-443f-badf-aae0aed585f2 | 2026-08-31 14:24 | 2026-08-31 14:24 | 2026-08-31 14:24 | NRG | NRG261218C00165000 | call | 165.0000 | 2026-12-18 | 1.0000 | 0.8000 | 1.6000 | 109.0000 | 2500000.00 | 0.00 | 2500000.00 | 25000 | 2 | 25006 | 26489 | 0.944014496583487 | 0.485473833459603 | 0.485473833459603 | false | true | ||||||||||||||||||
| 8daba57a-bebd-44df-9c5e-7eaac60ed0ca | 2026-08-31 14:24 | 2026-08-31 14:24 | 2026-08-31 14:24 | NRG | NRG261218C00145000 | call | 145.0000 | 2026-12-18 | 2.4000 | 2.1000 | 2.4000 | 109.0000 | 4800000.00 | 4800000.00 | 0.00 | 20000 | 2 | 20001 | 240 | 83.3375 | 0.471834570292608 | 0.471834570292608 | false | true | ||||||||||||||||||
| 4efc02d2-a9be-40fb-a074-8e193ad8dae4 | 2026-08-25 13:37 | 2026-08-25 13:36 | 2026-08-25 13:36 | XEL | XEL261016C00080000 | call | 80.0000 | 2026-10-16 | 1.2600 | 1.2000 | 1.3500 | 77.2500 | 144145.00 | 29770.00 | 114375.00 | 1144 | 2 | 1148 | 39 | 29.4358974358974 | 0.192615773303912 | 0.192615773303912 | false | true | ||||||||||||||||||
| d0f45756-93b7-4f1f-87cc-f2abe4846ffb | 2026-08-25 13:17 | 2026-08-25 13:17 | 2026-08-25 13:17 | ETR | ETR261016C00110000 | call | 110.0000 | 2026-10-16 | 2.1000 | 2.0000 | 2.4500 | 106.3400 | 296100.00 | 0.00 | 296100.00 | 1410 | 1 | 1415 | 76 | 18.6184210526316 | 0.210393266505819 | 0.210393266505819 | false | true | ||||||||||||||||||
| 8d0a1afa-cf77-4448-90af-c48b89f313af | 2026-08-24 13:33 | 2026-08-24 13:33 | 2026-08-24 13:33 | SRE | SRE261120C00090000 | call | 90.0000 | 2026-11-20 | 2.0100 | 1.9500 | 2.1500 | 83.8400 | 319590.00 | 0.00 | 254400.00 | 1590 | 2 | 1626 | 150 | 10.84 | 0.243756517587289 | 0.243756517587289 | false | true | ||||||||||||||||||
| fe10cbb3-8396-4202-9163-6b271961e52b | 2026-08-24 13:25 | 2026-08-24 13:25 | 2026-08-24 13:25 | NRG | NRG260918C00130000 | call | 130.0000 | 2026-09-18 | 0.8600 | 0.7000 | 0.9500 | 111.7950 | 602000.00 | 602000.00 | 0.00 | 7000 | 2 | 8024 | 390 | 20.574358974359 | 0.476412816593948 | 0.476412816593948 | false | true | ||||||||||||||||||
| 8ffcb927-d50a-4a65-b0a8-36f9d1f64b70 | 2026-08-21 14:13 | 2026-08-21 14:12 | 2026-08-21 14:12 | EIX | EIX261016P00060000 | put | 60.0000 | 2026-10-16 | 0.7000 | 0.5500 | 0.7500 | 71.0000 | 175000.00 | 175000.00 | 0.00 | 2500 | 1 | 2586 | 643 | 4.02177293934681 | 0.416386927032184 | 0.416386927032184 | false | true | ||||||||||||||||||
| aa869afb-e76c-41ba-a408-f3c36bb35661 | 2026-08-21 13:20 | 2026-08-21 13:19 | 2026-08-21 13:19 | NKLR | NKLR261120P00005000 | put | 5.0000 | 2026-11-20 | 0.9000 | 0.7000 | 0.9000 | 6.2100 | 270000.00 | 270000.00 | 0.00 | 3000 | 1 | 4000 | 5981 | 0.668784484199967 | 1.3270730454277 | 1.3270730454277 | false | true | ||||||||||||||||||
| 980220d3-a753-4deb-8c62-acfb44cc8985 | 2026-08-19 14:38 | 2026-08-19 14:38 | 2026-08-19 14:38 | SRE | SRE261016P00080000 | put | 80.0000 | 2026-10-16 | 1.4200 | 1.3500 | 1.5500 | 86.1100 | 269520.00 | 0.00 | 159320.00 | 1898 | 2 | 1898 | 65 | 29.2 | 0.29089768007628 | 0.29089768007628 | false | true | ||||||||||||||||||
| 38148c55-bd51-4e12-b12b-9d9224444192 | 2026-08-19 11:07 | 2026-08-19 11:07 | 2026-08-19 11:07 | OKLO | OKLO261218C00090000 | call | 90.0000 | 2026-12-18 | 1.0500 | 0.9400 | 1.2000 | 41.5350 | 5276145.00 | 0.00 | 5276145.00 | 50249 | 1 | 50292 | 53090 | 0.947297042757581 | 0.916987030434185 | 0.916987030434185 | false | true | ||||||||||||||||||
| 05afcb7c-60cf-4af1-a1f5-1260613ab7a8 | 2026-08-17 09:51 | 2026-08-17 09:51 | 2026-08-17 09:51 | VST | VST261002P00125000 | put | 125.0000 | 2026-10-02 | 1.5000 | 1.0200 | 2.2000 | 146.7800 | 1403250.00 | 0.00 | 1403250.00 | 9355 | 1 | 9356 | 1 | 9356 | 0.433845311160426 | 0.433845311160426 | false | true |
| true |
| true |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 33733067630.00 |
| 2026-11-02 |
| 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 |
| false |
| false |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 736450259.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:52:34.097246Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| false |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 736450259.00 |
| 2026-11-09 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:52:34.097246Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| true |
| false |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| ADR |
| Utilities |
| 4232181946.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:17:13.698421Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| false |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| — |
| Utilities |
| 3123333921.00 |
| 2026-11-12 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| true |
| true |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 93739103262.00 |
| 2026-11-06 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:49:37.903150Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| true |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 25459539131.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T17:55:09.170571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 66505948650.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:59:06.148248Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| true |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 18643661528.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T18:05:44.095975Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| false |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 22801531091.00 |
| 2026-11-05 |
| 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 |
| false |
| true |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 22801531091.00 |
| 2026-11-05 |
| 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 |
| true |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 46322880133.00 |
| 2026-10-29 |
| 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 |
| true |
| true |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 47449715735.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T17:31:01.749779Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 54267189881.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T17:47:44.554262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| true |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 22801531091.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T17:47:44.554262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| true |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 521564286.00 |
| 2026-09-21 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 54267189881.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| false |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 6735699107.00 |
| 2026-11-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| true |
| true |
| LowHistoricVolumeFloor |
| b356ec2b-92e1-458a-934a-7719f71c40bc |
| 1 |
| Common Stock |
| Utilities |
| 47233940992.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |