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 |
|---|
| 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 |
|---|
| 81efcc6a-31df-437c-8a55-decf5b14e8e4 | 2026-09-23 13:53 | 2026-09-23 13:53 | 2026-09-23 13:53 | AEP | AEP261218C00125000 | call | 125.0000 | 2026-12-18 | 2.3000 | 2.1500 | 2.3500 | 118.7600 | 11270.00 | 11270.00 | 0.00 | 49 | 9 | 75 | 580 | 0.129310344827586 | 0.185665344433645 | 0.185665344433645 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Utilities | 64422026672.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T17:55:17.981841Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 34331323-f0c2-40bc-ae4f-cdfbd0d4314a | 2026-09-23 13:53 | 2026-09-23 13:53 | 2026-09-23 13:53 | AEP | AEP261218C00120000 | call | 120.0000 | 2026-12-18 | 4.2000 | 4.1000 | 4.2000 | 118.7600 | 36540.00 | 36540.00 | 0.00 | 87 | 16 | 87 | 431 | 0.201856148491879 | 0.184143037336797 | 0.184143037336797 | false | false | false | |||||||||||||||||
| 23701707-5845-4fb2-945f-21b6411d298a | 2026-09-23 12:37 | 2026-09-23 12:36 | 2026-09-23 12:36 | AEP | AEP261120P00115000 | put | 115.0000 | 2026-11-20 | 2.5500 | 2.5000 | 2.6500 | 118.3400 | 16575.00 | 14535.00 | 2040.00 | 65 | 15 | 68 | 219 | 0.310502283105023 | 0.231868014095238 | 0.231868014095238 | false | false | false | |||||||||||||||||
| 0328ffc1-b185-4230-8606-45df2646cc2c | 2026-09-22 15:06 | 2026-09-22 15:06 | 2026-09-22 15:06 | AEP | AEP261218P00120000 | put | 120.0000 | 2026-12-18 | 4.6000 | 4.5000 | 4.7000 | 120.0760 | 23920.00 | 22540.00 | 0.00 | 52 | 17 | 96 | 331 | 0.290030211480363 | 0.223935624042348 | 0.223935624042348 | false | false | false | |||||||||||||||||
| 4a435dda-209a-4564-9ebc-2d59cf793766 | 2026-09-22 12:51 | 2026-09-22 12:51 | 2026-09-22 12:51 | AEP | AEP261218C00130000 | call | 130.0000 | 2026-12-18 | 1.5000 | 1.4000 | 1.5000 | 120.5200 | 12750.00 | 12750.00 | 0.00 | 85 | 18 | 88 | 255 | 0.345098039215686 | 0.183339034769261 | 0.183339034769261 | false | false | false | |||||||||||||||||
| 4cf8e030-6060-46a3-8972-877a0318472e | 2026-09-22 11:58 | 2026-09-22 11:58 | 2026-09-22 11:58 | AEP | AEP261218P00120000 | put | 120.0000 | 2026-12-18 | 4.4000 | 4.3000 | 4.4000 | 120.4700 | 18480.00 | 18480.00 | 0.00 | 42 | 12 | 44 | 331 | 0.132930513595166 | 0.222677953822642 | 0.222677953822642 | false | false | false | |||||||||||||||||
| cd2aca66-3bc3-42d8-b7e2-a0b71b0da230 | 2026-09-21 15:22 | 2026-09-21 15:22 | 2026-09-21 15:22 | AEP | AEP261120C00130000 | call | 130.0000 | 2026-11-20 | 0.8500 | 0.8000 | 0.9000 | 120.2100 | 12783.00 | 0.00 | 11933.00 | 150 | 19 | 193 | 2588 | 0.0745749613601236 | 0.185228095677275 | 0.185087405025634 | false | false | false | |||||||||||||||||
| 8ee752fc-e6f6-41d2-97c2-21e08e4aa864 | 2026-09-17 10:29 | 2026-09-17 10:29 | 2026-09-17 10:29 | AEP | AEP270115P00120000 | put | 120.0000 | 2027-01-15 | 4.9000 | 4.9000 | 5.2000 | 120.8200 | 61250.00 | 0.00 | 61250.00 | 125 | 33 | 125 | 446 | 0.280269058295964 | 0.221699152362755 | 0.221699152362755 | false | false | false | |||||||||||||||||
| f660e8e5-2a4c-420b-aba6-17119663d761 | 2026-09-15 11:24 | 2026-09-15 11:24 | 2026-09-15 11:24 | AEP | AEP261218C00125000 | call | 125.0000 | 2026-12-18 | 3.7000 | 3.3000 | 3.7000 | 121.2800 | 90280.00 | 90280.00 | 0.00 | 244 | 30 | 247 | 356 | 0.693820224719101 | 0.193552632532694 | 0.193552632532694 | false | false | false | |||||||||||||||||
| 7baf414a-046a-4cc8-bdc9-94aa6e9b17e6 | 2026-09-15 11:24 | 2026-09-15 11:24 | 2026-09-15 11:24 | AEP | AEP261218C00120000 | call | 120.0000 | 2026-12-18 | 6.2000 | 5.8000 | 6.2000 | 121.2800 | 51460.00 | 51460.00 | 0.00 | 83 | 21 | 83 | 397 | 0.209068010075567 | 0.198045496808347 | 0.198045496808347 | false | false | false | |||||||||||||||||
| 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 | false | |||||||||||||||||
| 2e219359-87b4-4d0c-ad81-5bc4966d61e3 | 2026-08-31 14:07 | 2026-08-31 14:07 | 2026-08-31 14:07 | AEP | AEP270115C00135000 | call | 135.0000 | 2027-01-15 | 2.1000 | 1.9000 | 2.1500 | 122.0000 | 61703.00 | 57113.00 | 2280.00 | 294 | 20 | 323 | 1061 | 0.304429783223374 | 0.19196675492773 | 0.194050678002365 | true | false | false | |||||||||||||||||
| fa3a98ed-cb69-453c-a317-b6d728b09fda | 2026-08-27 12:17 | 2026-08-27 12:17 | 2026-08-27 12:17 | AEP | AEP261218C00125000 | call | 125.0000 | 2026-12-18 | 4.7000 | 4.5000 | 4.7000 | 122.4800 | 93980.00 | 93980.00 | 0.00 | 200 | 31 | 257 | 243 | 1.05761316872428 | 0.190467671413489 | 0.190467671413489 | false | false | false | |||||||||||||||||
| 4813a993-5013-4871-b89f-97676e0ea2b8 | 2026-08-26 11:43 | 2026-08-26 11:42 | 2026-08-26 11:42 | AEP | AEP260918P00125000 | put | 125.0000 | 2026-09-18 | 3.1000 | 2.9000 | 3.1000 | 123.4800 | 50840.00 | 50840.00 | 0.00 | 164 | 26 | 166 | 2735 | 0.0606946983546618 | 0.196375478551037 | 0.196375478551037 | false | false | false | |||||||||||||||||
| 58ccbf40-2d23-43f4-8dad-c360c2b24107 | 2026-08-24 14:36 | 2026-08-24 14:35 | 2026-08-24 14:35 | AEP | AEP261016C00125000 | call | 125.0000 | 2026-10-16 | 2.7000 | 2.6500 | 2.7000 | 121.9000 | 75580.00 | 75580.00 | 0.00 | 280 | 37 | 894 | 562 | 1.59074733096085 | 0.202272174131639 | 0.202272174131639 | false | false | false | |||||||||||||||||
| 307cc971-cfa5-423e-9ef3-bfa907285133 | 2026-08-24 09:37 | 2026-08-24 09:37 | 2026-08-24 09:37 | AEP | AEP261016C00125000 | call | 125.0000 | 2026-10-16 | 2.0100 | 2.0000 | 2.5000 | 120.4200 | 106569.00 | 0.00 | 106569.00 | 530 | 23 | 531 | 562 | 0.944839857651246 | 0.194549371107765 | 0.198670780960641 | true | false | false | |||||||||||||||||
| fc651691-2f10-4ee7-943b-da21269628db | 2026-08-21 12:52 | 2026-08-21 12:52 | 2026-08-21 12:52 | AEP | AEP261120C00130000 | call | 130.0000 | 2026-11-20 | 2.3500 | 2.1500 | 2.6000 | 122.0700 | 59925.00 | 58750.00 | 1175.00 | 255 | 41 | 269 | 312 | 0.862179487179487 | 0.200446388915024 | 0.200083114138962 | true | false | false | |||||||||||||||||
| 65ed59ee-997d-495f-9680-a204086e6b79 | 2026-08-20 10:24 | 2026-08-20 10:24 | 2026-08-20 10:24 | AEP | AEP260918C00130000 | call | 130.0000 | 2026-09-18 | 1.6500 | 1.6500 | 1.8500 | 127.2700 | 143899.00 | 0.00 | 143899.00 | 872 | 45 | 875 | 1442 | 0.606796116504854 | 0.184068287692733 | 0.184068287692733 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 64422026672.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:55:17.981841Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 64422026672.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:39:09.093031Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 65439502938.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:10:39.996631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 65439502938.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:52:20.560244Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 65439502938.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:00:55.569269Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 65308917749.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:25:50.208697Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 66174044627.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:33:58.839655Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 66505948650.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:29:06.202071Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 66505948650.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:29:06.202071Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 66505948650.00 |
| 2026-11-04 |
| 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 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 66505948650.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:30:57.923324Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 66505948650.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T15:48:55.759300Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Utilities |
| 66505948650.00 |
| 2026-11-04 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 66505948650.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:38:06.174043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Utilities |
| 66505948650.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Utilities |
| 66505948650.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |