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_alerts523,327 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 |
|---|
| df3d0fe4-127d-4481-b285-76ca182fead5 | 2026-09-22 15:49 | 2026-09-22 15:49 | 2026-09-22 15:49 | META | META270319P00610000 | put | 610.0000 | 2027-03-19 | 30.1500 | 29.9500 | 30.3000 | 737.8550 | 15075.00 | 3015.00 | 12060.00 | 5 | 5 | 11 | 1535 | 0.00716612377850163 | 0.44383287474868 | 0.44383287474868 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1624286634087.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T19:49:40.866869Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| dfe2d8ef-df40-4891-8f78-e9c6993ad826 | 2026-09-22 15:49 | 2026-09-22 15:49 | 2026-09-22 15:49 | META | META270319P00610000 | put | 610.0000 | 2027-03-19 | 30.1500 | 30.1500 | 30.3500 | 737.9000 | 36180.00 | 0.00 | 36180.00 | 12 | 11 | 23 | 1535 | 0.0149837133550489 | 0.443860688108752 | 0.44389545255696 | false | false | false | |||||||||||||||||
| 6f113e6c-e372-4069-b2e7-b095f6494ddc | 2026-09-22 15:49 | 2026-09-22 15:49 | 2026-09-22 15:49 | META | META270319P00610000 | put | 610.0000 | 2027-03-19 | 30.1000 | 30.1000 | 30.4500 | 738.2641 | 24080.00 | 0.00 | 24080.00 | 8 | 8 | 32 | 1535 | 0.0208469055374593 | 0.443786651852091 | 0.444056284276525 | false | false | false | |||||||||||||||||
| 0aa9f5a8-d8e3-42a6-b23f-0def5fb3a39c | 2026-09-22 15:50 | 2026-09-22 15:50 | 2026-09-22 15:50 | META | META270319P00610000 | put | 610.0000 | 2027-03-19 | 29.9000 | 29.9000 | 30.4000 | 738.8000 | 20930.00 | 0.00 | 20930.00 | 7 | 7 | 42 | 1535 | 0.0273615635179153 | 0.443417292936649 | 0.443417292936649 | false | false | false | |||||||||||||||||
| 1aef2545-3d33-405c-ad71-9e26c3cc473a | 2026-09-22 15:50 | 2026-09-22 15:50 | 2026-09-22 15:50 | META | META270319P00610000 | put | 610.0000 | 2027-03-19 | 29.8000 | 29.1000 | 30.1000 | 740.7550 | 26820.00 | 2980.00 | 5960.00 | 9 | 9 | 51 | 1535 | 0.0332247557003257 | 0.445424779762098 | 0.445424779762098 | true | false | false | |||||||||||||||||
| d4820ab7-c355-4092-b45a-9882e5ae1587 | 2026-09-22 15:50 | 2026-09-22 15:50 | 2026-09-22 15:50 | META | META270319P00610000 | put | 610.0000 | 2027-03-19 | 29.7500 | 29.4500 | 29.8000 | 740.6300 | 14875.00 | 5950.00 | 2975.00 | 5 | 5 | 56 | 1535 | 0.0364820846905537 | 0.444905832238166 | 0.444905832238166 | true | false | false | |||||||||||||||||
| b7575a98-b7ef-4d8a-ba2c-fc34163787f4 | 2026-09-22 15:50 | 2026-09-22 15:50 | 2026-09-22 15:50 | META | META270319P00610000 | put | 610.0000 | 2027-03-19 | 29.7500 | 29.5000 | 29.8000 | 740.8650 | 26775.00 | 2975.00 | 5950.00 | 9 | 9 | 70 | 1535 | 0.0456026058631922 | 0.445229356377632 | 0.445229356377632 | true | false | false | |||||||||||||||||
| 10b01b90-9487-48bb-bc16-52cbb1f85620 | 2026-09-22 15:51 | 2026-09-22 15:50 | 2026-09-22 15:50 | META | META270319P00610000 | put | 610.0000 | 2027-03-19 | 29.7500 | 29.7500 | 29.8000 | 740.9800 | 29750.00 | 0.00 | 29750.00 | 10 | 10 | 80 | 1535 | 0.0521172638436482 | 0.445387597919801 | 0.445387597919801 | false | false | false | |||||||||||||||||
| 1e9907f0-08fb-4f66-8bcc-8ca2f775ee2e | 2026-09-24 15:20 | 2026-09-24 15:20 | 2026-09-24 15:20 | META | META270319P00610000 | put | 610.0000 | 2027-03-19 | 23.6000 | 23.3000 | 23.6000 | 777.0000 | 16520.00 | 16520.00 | 0.00 | 7 | 7 | 125 | 1549 | 0.0806972240154939 | 0.450875901584552 | 0.450875901584552 | true | false | false | |||||||||||||||||
| 06af3eb2-33e9-4352-adde-4469f9b669c2 | 2026-09-24 15:23 | 2026-09-24 15:23 | 2026-09-24 15:23 | META | META270319P00610000 | put | 610.0000 | 2027-03-19 | 23.5000 | 23.5000 | 23.7500 | 778.9300 | 23500.00 | 0.00 | 16450.00 | 10 | 10 | 139 | 1549 | 0.0897353131052292 | 0.451381973548677 | 0.451381973548677 | false | false | false | |||||||||||||||||
| 3297984f-bf37-4813-a3dc-0409858d76bb | 2026-09-24 15:23 | 2026-09-24 15:23 | 2026-09-24 15:23 | META | META270319P00610000 | put | 610.0000 | 2027-03-19 | 23.4500 | 23.4500 | 23.5000 | 779.1900 | 18760.00 | 0.00 | 18760.00 | 8 | 8 | 158 | 1549 | 0.102001291155584 | 0.451313188565298 | 0.451313188565298 | false | false | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:49:40.866869Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1624286634087.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:52:58.637042Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:21:59.976006Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:29:28.297700Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:29:28.297700Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |