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_alerts326,449 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 |
|---|
| f504738e-b9a2-4f30-80e9-7a1f930686fe | 2026-09-22 14:44 | 2026-09-22 14:44 | 2026-09-22 14:44 | EIX | EIX270416C00060000 | call | 60.0000 | 2027-04-16 | 3.7000 | 3.7000 | 4.3000 | 55.3800 | 27020.00 | 0.00 | 27020.00 | 73 | 13 | 93 | 524 | 0.177480916030534 | 0.306429677137093 | 0.3003556710726 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Utilities | 21184009544.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T18:44:24.241276Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 9dbc7970-3245-469d-8075-700397ca04a2 | 2026-09-22 13:36 | 2026-09-22 13:36 | 2026-09-22 13:36 | EIX | EIX261120C00057500 | call | 57.5000 | 2026-11-20 | 2.2500 | 1.9000 | 2.3000 | 55.0000 | 21822.00 | 21822.00 | 0.00 | 97 | 26 | 317 | 82 | 3.86585365853659 | 0.342328015211957 | 0.342328015211957 | true | false | false | |||||||||||||||||
| 7c22a0b9-19c5-4ca3-b77c-ec134e673560 | 2026-09-21 12:58 | 2026-09-21 12:57 | 2026-09-21 12:57 | EIX | EIX261016C00060000 | call | 60.0000 | 2026-10-16 | 0.4300 | 0.4000 | 0.4500 | 55.5150 | 13442.00 | 5756.00 | 7686.00 | 315 | 10 | 563 | 5289 | 0.106447343543203 | 0.30769526322623 | 0.30769526322623 | false | false | false | |||||||||||||||||
| fa39c585-0537-48ee-8633-6ed57e6b28a6 | 2026-09-17 11:42 | 2026-09-17 11:42 | 2026-09-17 11:42 | EIX | EIX270115P00050000 | put | 50.0000 | 2027-01-15 | 2.9000 | 2.7500 | 2.9000 | 55.4300 | 108150.00 | 108150.00 | 0.00 | 373 | 37 | 392 | 2644 | 0.148260211800303 | 0.454238640970282 | 0.454238640970282 | true | false | false | |||||||||||||||||
| 11961dbb-ba6e-4bde-ac0d-72d08566de6c | 2026-09-10 13:11 | 2026-09-10 13:11 | 2026-09-10 13:11 | EIX | EIX270416C00065000 | call | 65.0000 | 2027-04-16 | 4.4800 | 4.0000 | 4.8000 | 57.0300 | 89600.00 | 59900.00 | 29700.00 | 200 | 6 | 200 | 98 | 2.04081632653061 | 0.392060488389454 | 0.387417803369734 | false | false | false | |||||||||||||||||
| 688b1697-0b39-4a0f-a9aa-d5c74b2bd5dd | 2026-09-09 15:04 | 2026-09-09 15:04 | 2026-09-09 15:04 | EIX | EIX261016P00055000 | put | 55.0000 | 2026-10-16 | 2.2500 | 2.0500 | 2.2500 | 58.1100 | 54673.00 | 54673.00 | 0.00 | 243 | 39 | 681 | 3926 | 0.173458991339786 | 0.513532514729193 | 0.513532514729193 | true | false | false | |||||||||||||||||
| 56875be3-3e53-4fd1-a2cc-993f32bf0788 | 2026-09-04 10:56 | 2026-09-04 10:56 | 2026-09-04 10:56 | EIX | EIX260918C00060000 | call | 60.0000 | 2026-09-18 | 1.1000 | 0.9500 | 1.1000 | 55.9622 | 58284.00 | 58284.00 | 0.00 | 530 | 58 | 711 | 6509 | 0.109233369181134 | 0.577943548273628 | 0.577943548273628 | true | false | false | |||||||||||||||||
| ec6f77f9-1ce4-4805-9da8-c5e60b11d0e7 | 2026-09-04 10:01 | 2026-09-04 10:01 | 2026-09-04 10:01 | EIX | EIX270115P00055000 | put | 55.0000 | 2027-01-15 | 5.6200 | 5.6000 | 6.2000 | 55.7670 | 21930.00 | 1710.00 | 9020.00 | 39 | 6 | 81 | 373 | 0.2171581769437 | 0.488610698204454 | 0.488610698204454 | false | false | false | |||||||||||||||||
| 82a7e169-5682-4376-9663-9ea0c52b82c4 | 2026-09-04 10:01 | 2026-09-04 10:00 | 2026-09-04 10:00 | EIX | EIX270416C00060000 | call | 60.0000 | 2027-04-16 | 5.0800 | 5.0000 | 5.3000 | 55.6800 | 176447.00 | 108627.00 | 67820.00 | 347 | 25 | 351 | 135 | 2.6 | 0.360736651430839 | 0.360736651430839 | false | false | false | |||||||||||||||||
| 0fbdee33-abf5-49b0-839e-0bf2828b9c71 | 2026-09-04 10:01 | 2026-09-04 10:00 | 2026-09-04 10:00 | EIX | EIX270416C00062500 | call | 62.5000 | 2027-04-16 | 4.2900 | 4.2000 | 4.5000 | 55.6800 | 323760.00 | 275200.00 | 48560.00 | 755 | 29 | 758 | 4 | 189.5 | 0.363656737001966 | 0.363656737001966 | false | false | false | |||||||||||||||||
| 4e4033db-5cd1-4128-bd79-e1f9418f113a | 2026-09-04 09:55 | 2026-09-04 09:55 | 2026-09-04 09:55 | EIX | EIX270115C00062500 | call | 62.5000 | 2027-01-15 | 2.9200 | 2.9000 | 3.2000 | 55.6700 | 63970.00 | 20355.00 | 43615.00 | 219 | 17 | 1219 | 536 | 2.27425373134328 | 0.384150846242205 | 0.384150846242205 | false | false | false | |||||||||||||||||
| 26727570-f6d4-4044-aa20-7371324974e7 | 2026-09-02 11:40 | 2026-09-02 11:40 | 2026-09-02 11:40 | EIX | EIX261016P00045000 | put | 45.0000 | 2026-10-16 | 0.5000 | 0.3500 | 0.5000 | 54.8700 | 15547.00 | 15547.00 | 0.00 | 311 | 35 | 405 | 439 | 0.92255125284738 | 0.496300038558972 | 0.496300038558972 | true | false | false | |||||||||||||||||
| 71929513-6005-4d12-8e60-5d456ec89791 | 2026-09-01 15:31 | 2026-09-01 15:31 | 2026-09-01 15:31 | EIX | EIX261016C00067500 | call | 67.5000 | 2026-10-16 | 1.6500 | 1.4000 | 1.7000 | 58.9900 | 46849.00 | 19789.00 | 27060.00 | 284 | 64 | 303 | 157 | 1.92993630573248 | 0.526878624610823 | 0.526483870897435 | true | false | false | |||||||||||||||||
| a570453f-277a-4b27-b8db-d805055cf27f | 2026-09-01 10:06 | 2026-09-01 10:06 | 2026-09-01 10:06 | EIX | EIX261016C00060000 | call | 60.0000 | 2026-10-16 | 1.1500 | 0.9000 | 1.1500 | 53.8050 | 77843.00 | 77843.00 | 0.00 | 677 | 36 | 1185 | 2001 | 0.592203898050975 | 0.415229299665517 | 0.415229299665517 | false | false | false | |||||||||||||||||
| d1141610-477e-45ef-aa51-5d7c7ac77670 | 2026-08-31 15:58 | 2026-08-31 15:58 | 2026-08-31 15:58 | EIX | EIX270115C00060000 | call | 60.0000 | 2027-01-15 | 2.8200 | 2.1000 | 2.9000 | 54.0700 | 41965.00 | 13680.00 | 28285.00 | 149 | 7 | 820 | 163 | 5.03067484662577 | 0.359993045837286 | 0.356040157857908 | false | false | false | |||||||||||||||||
| 8a9ee6fd-9330-4e0a-9aea-0a813204b315 | 2026-08-31 12:55 | 2026-08-31 12:55 | 2026-08-31 12:55 | EIX | EIX260918P00050000 | put | 50.0000 | 2026-09-18 | 0.9500 | 0.7500 | 0.9500 | 53.3500 | 27102.00 | 27102.00 | 0.00 | 286 | 8 | 1251 | 0 | 0 | 0.496366389545466 | 0.496366389545466 | false | false | false | |||||||||||||||||
| 882285e9-84fc-49c9-b29f-4d9e79378c0b | 2026-08-28 15:24 | 2026-08-28 15:24 | 2026-08-28 15:24 | EIX | EIX260918C00075000 | call | 75.0000 | 2026-09-18 | 1.6000 | 1.1000 | 1.6000 | 70.5000 | 79353.00 | 79198.00 | 155.00 | 496 | 44 | 1161 | 3862 | 0.300621439668566 | 0.479037444774886 | 0.479037444774886 | true | false | false | |||||||||||||||||
| bcbc4e54-b213-4763-8373-0cb0ba5eb0ab | 2026-08-24 15:17 | 2026-08-24 15:16 | 2026-08-24 15:16 | EIX | EIX260918C00075000 | call | 75.0000 | 2026-09-18 | 2.6000 | 2.6000 | 2.9000 | 73.7250 | 39040.00 | 0.00 | 39040.00 | 150 | 6 | 1732 | 1717 | 1.00873616773442 | 0.40261502545716 | 0.40261502545716 | false | false | false | |||||||||||||||||
| d19f88a0-4fe7-4952-a753-323cee411be0 | 2026-08-24 14:38 | 2026-08-24 14:38 | 2026-08-24 14:38 | EIX | EIX260918C00075000 | call | 75.0000 | 2026-09-18 | 2.6000 | 2.6000 | 2.7000 | 73.6700 | 14574.00 | 0.00 | 14574.00 | 56 | 8 | 1451 | 1717 | 0.84507862550961 | 0.405951050994654 | 0.405951050994654 | false | false | false | |||||||||||||||||
| 45a835e6-c044-48cd-b48d-b596fce3bd16 | 2026-08-18 10:18 | 2026-08-18 10:18 | 2026-08-18 10:18 | EIX | EIX260918C00072500 | call | 72.5000 | 2026-09-18 | 4.0000 | 3.6000 | 4.0000 | 73.5550 | 201177.00 | 201177.00 | 0.00 | 503 | 34 | 508 | 4110 | 0.12360097323601 | 0.391316234802525 | 0.391316234802525 | false | false | false | |||||||||||||||||
| 41380dd8-22a6-479e-944b-b74a6bb97423 | 2026-08-18 10:08 | 2026-08-18 10:08 | 2026-08-18 10:08 | EIX | EIX260821C00072500 | call | 72.5000 | 2026-08-21 | 1.5800 | 1.5000 | 1.8500 | 73.2500 | 158098.00 | 0.00 | 158098.00 | 1000 | 8 | 1051 | 3500 | 0.300285714285714 | 0.464929979444158 | 0.464929979444158 | false | false | false | |||||||||||||||||
| b9b51e9f-e526-4e47-b7cb-ab16af449977 | 2026-08-17 15:02 | 2026-08-17 15:02 | 2026-08-17 15:02 | EIX | EIX260918P00055000 | put | 55.0000 | 2026-09-18 | 0.1500 | 0.0500 | 0.1500 | 71.6400 | 14898.00 | 14898.00 | 0.00 | 994 | 56 | 10999 | 130 | 84.6076923076923 | 0.513599627497066 | 0.513599627497066 | true | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21184009544.00 |
| 2026-10-27 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:40:26.166069Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21145528146.00 |
| 2026-10-27 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21357175835.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:59:42.981722Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T17:37:34.117542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:56:18.493427Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T15:49:54.253343Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T19:44:53.190071Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:20:18.853903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T13:34:32.417809Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:08:52.274087Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T19:36:54.231390Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T18:49:58.488781Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 21599608641.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |