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_alerts566,287 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 |
|---|
| e86066c0-660e-4c19-b140-ec05bc335d63 | 2026-09-28 13:02 | 2026-09-28 13:02 | 2026-09-28 13:02 | WM | WM290119C00210000 | call | 210.0000 | 2029-01-19 | 33.0000 | 31.6000 | 34.5000 | 207.6850 | 33000.00 | 19800.00 | 13200.00 | 10 | 5 | 10 | 19 | 0.526315789473684 | 0.181438015533164 | 0.181438015533164 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 82517202585.00 | 2026-10-27 | postmarket | — | 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 |
| ebca5bdd-dc4f-4103-b579-f275301887ce | 2026-09-28 12:03 | 2026-09-28 12:03 | 2026-09-28 12:03 | WM | WM270617C00240000 | call | 240.0000 | 2027-06-17 | 5.7000 | 3.7000 | 5.9000 | 206.9200 | 143640.00 | 129390.00 | 14250.00 | 252 | 15 | 298 | 430 | 0.693023255813954 | 0.204469307901259 | 0.204469307901259 | true | false | false | |||||||||||||||||
| 4f74be21-62fe-4def-964c-a76f236f3b72 | 2026-09-25 15:30 | 2026-09-25 15:30 | 2026-09-25 15:30 | WM | WM261218C00210000 | call | 210.0000 | 2026-12-18 | 7.5000 | 7.3000 | 7.5000 | 206.6100 | 21000.00 | 21000.00 | 0.00 | 28 | 7 | 30 | 85 | 0.352941176470588 | 0.205716508096454 | 0.205716508096454 | false | false | false | |||||||||||||||||
| b4c5f664-086d-4fa5-afc9-553710319c3a | 2026-09-25 14:08 | 2026-09-25 14:07 | 2026-09-25 14:07 | WM | WM261218P00200000 | put | 200.0000 | 2026-12-18 | 4.8000 | 4.6000 | 4.9000 | 207.0000 | 27840.00 | 27360.00 | 0.00 | 58 | 19 | 100 | 666 | 0.15015015015015 | 0.223548392071691 | 0.223548392071691 | false | false | false | |||||||||||||||||
| a136fd42-e77d-421e-a8e6-e99600bc73b8 | 2026-09-25 13:18 | 2026-09-25 13:18 | 2026-09-25 13:18 | WM | WM261218P00200000 | put | 200.0000 | 2026-12-18 | 4.8000 | 4.6000 | 4.8000 | 207.0000 | 19200.00 | 19200.00 | 0.00 | 40 | 14 | 40 | 666 | 0.0600600600600601 | 0.223146940102176 | 0.223146940102176 | false | false | false | |||||||||||||||||
| 5e565462-5c78-4661-8772-f4293fd390a7 | 2026-09-23 12:47 | 2026-09-23 12:47 | 2026-09-23 12:47 | WM | WM261120P00210000 | put | 210.0000 | 2026-11-20 | 8.2000 | 8.0000 | 8.2000 | 206.9000 | 136940.00 | 136940.00 | 0.00 | 167 | 40 | 176 | 191 | 0.921465968586387 | 0.220922791007945 | 0.220922791007945 | false | false | false | |||||||||||||||||
| b105f0c7-3d17-4b55-88f0-1072e473e462 | 2026-09-22 12:35 | 2026-09-22 12:35 | 2026-09-22 12:35 | WM | WM270115P00210000 | put | 210.0000 | 2027-01-15 | 10.0000 | 9.8000 | 10.1000 | 207.2600 | 60000.00 | 60000.00 | 0.00 | 60 | 7 | 72 | 321 | 0.224299065420561 | 0.216269832892783 | 0.216269832892783 | false | false | false | |||||||||||||||||
| 8bd9d7f0-b269-4615-9c03-0d5e13892475 | 2026-09-21 12:20 | 2026-09-21 12:20 | 2026-09-21 12:20 | WM | WM270617C00220000 | call | 220.0000 | 2027-06-17 | 12.7000 | 12.2000 | 12.7000 | 208.0000 | 11430.00 | 11430.00 | 0.00 | 9 | 8 | 19 | 36 | 0.527777777777778 | 0.203602469887271 | 0.203602469887271 | false | false | false | |||||||||||||||||
| a4a802bf-28be-4082-a157-78eca3b49777 | 2026-09-21 10:40 | 2026-09-21 10:40 | 2026-09-21 10:40 | WM | WM261120P00210000 | put | 210.0000 | 2026-11-20 | 7.5000 | 7.1000 | 7.6000 | 208.3300 | 58500.00 | 57750.00 | 0.00 | 78 | 27 | 88 | 92 | 0.956521739130435 | 0.218636521337133 | 0.218636521337133 | false | false | false | |||||||||||||||||
| 0a963c49-c99b-4a47-89c0-1fdf15e54240 | 2026-09-04 14:30 | 2026-09-04 14:29 | 2026-09-04 14:29 | WM | WM261016C00220000 | call | 220.0000 | 2026-10-16 | 4.9000 | 4.7000 | 4.9000 | 218.4550 | 190117.00 | 190117.00 | 0.00 | 388 | 37 | 424 | 263 | 1.61216730038023 | 0.174815500377991 | 0.174815500377991 | false | false | false | |||||||||||||||||
| b54d059f-1a36-4b1e-919a-3c56a86c7b77 | 2026-08-26 14:30 | 2026-08-26 14:30 | 2026-08-26 14:30 | WM | WM261218C00230000 | call | 230.0000 | 2026-12-18 | 7.0000 | 6.1000 | 7.1000 | 221.5100 | 88200.00 | 72800.00 | 15400.00 | 126 | 18 | 308 | 413 | 0.745762711864407 | 0.191744989407525 | 0.191744989407525 | true | false | false | |||||||||||||||||
| dd39fec6-582d-4bea-9b10-b47f1e7563e6 | 2026-08-21 10:45 | 2026-08-21 10:45 | 2026-08-21 10:45 | WM | WM261016P00220000 | put | 220.0000 | 2026-10-16 | 4.7000 | 4.7000 | 4.9000 | 223.8000 | 65806.00 | 0.00 | 65806.00 | 140 | 27 | 160 | 322 | 0.496894409937888 | 0.200917018729469 | 0.200917018729469 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82517202585.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:05:35.930466Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82673091507.00 |
| 2026-10-27 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:35:55.847824Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82673091507.00 |
| 2026-10-27 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:10:19.042064Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82673091507.00 |
| 2026-10-27 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:23:42.010099Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 83092792450.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T16:50:31.727712Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 83012849413.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:42:20.042631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82757031695.00 |
| 2026-10-26 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:21:14.001426Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 82757031695.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:42:35.959490Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 87173884479.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T18:34:11.376593Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 87173884479.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T18:39:51.047298Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 87173884479.00 |
| 2026-10-26 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:50:41.871179Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |