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_alerts375,978 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 |
|---|
| 3bca5949-a2cf-4c79-89a0-9abad680689a | 2026-09-10 13:46 | 2026-09-10 13:46 | 2026-09-10 13:46 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 0.8500 | 0.8100 | 1.0200 | 14.2050 | 21845.00 | 85.00 | 21760.00 | 257 | 30 | 3766 | 22668 | 0.166137286041998 | 0.454345104864501 | 0.454345104864501 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 36449502746.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T18:09:00.187388Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d01e9352-8809-4825-b4f8-a7b8914ff8f5 | 2026-09-10 13:09 | 2026-09-10 13:08 | 2026-09-10 13:08 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 0.8700 | 0.8000 | 1.0800 | 14.2650 | 10527.00 | 261.00 | 10266.00 | 121 | 22 | 2568 | 22668 | 0.113287453679195 | 0.455180066321415 | 0.455180066321415 | false | false | false | true | ||||||||||||||||
| 93dc0536-73b2-44f8-b8fa-52cf2e723acc | 2026-09-10 10:11 | 2026-09-10 10:11 | 2026-09-10 10:11 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 0.9200 | 0.9200 | 1.1300 | 14.2314 | 11316.00 | 0.00 | 11316.00 | 123 | 14 | 1356 | 22668 | 0.0598200105876125 | 0.467549135506415 | 0.467549135506415 | false | false | false | true | ||||||||||||||||
| 0399d87a-72e2-4ebe-bb0b-ae26e0f4ef16 | 2026-09-09 15:58 | 2026-09-09 15:57 | 2026-09-09 15:57 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 0.9700 | 0.9400 | 1.1700 | 14.2500 | 13580.00 | 10476.00 | 3104.00 | 140 | 6 | 14058 | 8923 | 1.57547909895775 | 0.481413360172038 | 0.481413360172038 | false | false | false | true | ||||||||||||||||
| cbab9213-a2d9-4914-be5f-db863bbaf578 | 2026-09-09 15:57 | 2026-09-09 15:57 | 2026-09-09 15:57 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 0.9700 | 0.9400 | 1.0900 | 14.2650 | 25414.00 | 15714.00 | 9700.00 | 262 | 7 | 13818 | 8923 | 1.54858231536479 | 0.480542562994436 | 0.480542562994436 | true | false | false | true | ||||||||||||||||
| ec4bcabe-a902-4cc6-ba30-da4cea94841b | 2026-09-09 15:57 | 2026-09-09 15:57 | 2026-09-09 15:57 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 0.9700 | 0.9400 | 1.0900 | 14.2650 | 70810.00 | 12610.00 | 58200.00 | 730 | 6 | 13556 | 8923 | 1.5192199932758 | 0.480542562994436 | 0.480542562994436 | false | false | false | true | ||||||||||||||||
| 774b43cb-40fd-4471-96cc-2781c660958d | 2026-09-09 15:18 | 2026-09-09 15:17 | 2026-09-09 15:17 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 1.0600 | 1.0400 | 1.0600 | 14.3450 | 53000.00 | 53000.00 | 0.00 | 500 | 7 | 12011 | 8923 | 1.34607194889611 | 0.494031406117763 | 0.494031406117763 | false | false | false | true | ||||||||||||||||
| 574fc8a2-ef9f-482d-af28-29c92aef1c05 | 2026-09-09 15:17 | 2026-09-09 15:17 | 2026-09-09 15:17 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 1.0600 | 1.0400 | 1.0600 | 14.3500 | 64766.00 | 64766.00 | 0.00 | 611 | 5 | 11511 | 8923 | 1.29003698307744 | 0.493735549303473 | 0.493735549303473 | false | false | false | true | ||||||||||||||||
| cbeec636-7cb7-4b1c-90b1-f9c80ac19489 | 2026-09-09 15:17 | 2026-09-09 15:16 | 2026-09-09 15:16 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 1.0600 | 1.0400 | 1.0600 | 14.3750 | 40386.00 | 40386.00 | 0.00 | 381 | 5 | 10900 | 8923 | 1.22156225484702 | 0.492257585256441 | 0.492257585256441 | false | false | false | true | ||||||||||||||||
| b0e1e4ea-8f43-4f06-a0de-6a36adb8131c | 2026-09-09 15:16 | 2026-09-09 15:16 | 2026-09-09 15:16 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 1.0600 | 1.0400 | 1.2100 | 14.3710 | 88401.00 | 88086.00 | 315.00 | 834 | 9 | 10150 | 8923 | 1.13750980611902 | 0.492493911960848 | 0.490503465735235 | true | false | false | true | ||||||||||||||||
| c4f14cfb-0dd5-40f5-b8d7-daea5f59b07c | 2026-09-09 15:16 | 2026-09-09 15:15 | 2026-09-09 15:15 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 1.0600 | 1.0400 | 1.2100 | 14.3850 | 53106.00 | 25546.00 | 5088.00 | 501 | 7 | 9315 | 8923 | 1.04393141320184 | 0.491667013729331 | 0.491667013729331 | false | false | false | true | ||||||||||||||||
| ab7b1c6a-b2cc-4e52-9678-537f0f208369 | 2026-09-09 15:15 | 2026-09-09 15:15 | 2026-09-09 15:15 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 1.0600 | 1.0400 | 1.0600 | 14.3800 | 63792.00 | 61692.00 | 2100.00 | 602 | 6 | 8572 | 8923 | 0.960663453995293 | 0.49196225573191 | 0.49196225573191 | true | false | false | true | ||||||||||||||||
| 5b00ebcb-4578-4c82-b374-302a6cd205ab | 2026-09-09 15:15 | 2026-09-09 15:15 | 2026-09-09 15:15 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 1.0600 | 1.0500 | 1.2100 | 14.3850 | 40068.00 | 0.00 | 39538.00 | 378 | 33 | 7658 | 8923 | 0.858231536478763 | 0.491667013729331 | 0.491667013729331 | false | false | false | true | ||||||||||||||||
| 7ecbbda2-64c6-4934-b615-44efad7dfa83 | 2026-09-09 12:06 | 2026-09-09 12:06 | 2026-09-09 12:06 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 1.1000 | 1.0600 | 1.3000 | 14.3700 | 236830.00 | 31130.00 | 205700.00 | 2153 | 17 | 6478 | 8923 | 0.7259890171467 | 0.500472152957289 | 0.500472152957289 | false | false | false | true | ||||||||||||||||
| 87b4f29e-096c-4baa-99ce-9723593249f8 | 2026-09-09 11:51 | 2026-09-09 11:51 | 2026-09-09 11:51 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 1.1400 | 1.0600 | 1.1400 | 14.3600 | 46583.00 | 41724.00 | 0.00 | 409 | 8 | 3220 | 8923 | 0.36086517987224 | 0.509230883047728 | 0.508929071900481 | false | false | false | true | ||||||||||||||||
| 4d27ec35-03fb-42d0-af0f-e4164cdb681c | 2026-09-09 11:51 | 2026-09-09 11:51 | 2026-09-09 11:51 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 1.1400 | 1.1300 | 1.1400 | 14.3600 | 22800.00 | 22800.00 | 0.00 | 200 | 8 | 2095 | 8923 | 0.234786506780231 | 0.508929071900481 | 0.508929071900481 | false | false | false | true | ||||||||||||||||
| 19403c5d-4b97-4ea0-b444-17b0b9b008dc | 2026-09-09 11:51 | 2026-09-09 11:51 | 2026-09-09 11:51 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 1.1400 | 1.1300 | 1.1900 | 14.3600 | 74784.00 | 58596.00 | 9120.00 | 656 | 6 | 2751 | 8923 | 0.308304381934327 | 0.508929071900481 | 0.508929071900481 | false | false | false | true | ||||||||||||||||
| 48ff9f3d-9ec9-4c76-bda7-47c8fa368f0b | 2026-09-09 11:51 | 2026-09-09 11:50 | 2026-09-09 11:50 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 1.1400 | 1.1300 | 1.1400 | 14.3600 | 57000.00 | 57000.00 | 0.00 | 500 | 6 | 895 | 8923 | 0.100302588815421 | 0.508929071900481 | 0.508929071900481 | false | false | false | true | ||||||||||||||||
| 7b82667c-4ee2-4e76-9baa-a412c311e67e | 2026-09-04 13:52 | 2026-09-04 13:52 | 2026-09-04 13:52 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 0.8700 | 0.8600 | 0.9200 | 13.9100 | 202275.00 | 7395.00 | 144333.00 | 2325 | 17 | 3790 | 5094 | 0.74401256380055 | 0.471836117244781 | 0.471836117244781 | true | false | false | true | ||||||||||||||||
| 79d18920-bfd1-496d-bf58-a009cde9b492 | 2026-09-03 15:53 | 2026-09-03 15:53 | 2026-09-03 15:53 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 0.7800 | 0.7300 | 0.7800 | 13.9850 | 186342.00 | 186342.00 | 0.00 | 2389 | 10 | 5172 | 3 | 1724 | 0.447068990331798 | 0.447068990331798 | false | false | false | true | ||||||||||||||||
| 08108fd2-c450-41c3-ada1-da1ccc606763 | 2026-09-03 15:18 | 2026-09-03 15:18 | 2026-09-03 15:18 | PCG | PCG270917C00022000 | call | 22.0000 | 2027-09-17 | 0.7800 | 0.7700 | 0.8600 | 14.0700 | 141882.00 | 132756.00 | 9126.00 | 1819 | 8 | 2500 | 3 | 833.333333333333 | 0.442366633598311 | 0.442366633598311 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:21:23.599560Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:32:54.294551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:32:54.294551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:32:54.294551Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T16:21:26.040266Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:51:30.246262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:51:30.246262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:51:30.246262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:51:30.246262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T18:01:17.201510Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 36449502746.00 |
| 2026-10-22 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:29:59.445996Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |