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_alerts425,429 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 |
|---|
| be400ff9-aa4c-4c2c-9757-90fe3b0ce389 | 2026-09-21 14:59 | 2026-09-21 14:59 | 2026-09-21 14:59 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 17.4000 | 17.3000 | 17.5500 | 746.2000 | 22620.00 | 0.00 | 20880.00 | 13 | 7 | 589 | 0 | 0 | 0.621001032332134 | 0.622542274530832 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Communication Services | 1634540481654.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:00:53.952817Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| ddfaef3b-22dc-4b64-afe8-ce5acc373c7d | 2026-09-21 15:32 | 2026-09-21 15:32 | 2026-09-21 15:32 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 15.9500 | 15.8000 | 15.9500 | 748.0000 | 11164.00 | 11164.00 | 0.00 | 7 | 7 | 805 | 0 | 0 | 0.604169763933725 | 0.604169763933725 | false | false | false | true | ||||||||||||||||
| 7dd54fd0-9e51-4dbb-85f3-6a6b79cec7b5 | 2026-09-21 15:33 | 2026-09-21 15:33 | 2026-09-21 15:33 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 15.4000 | 15.2500 | 15.4000 | 749.0000 | 77000.00 | 77000.00 | 0.00 | 50 | 18 | 858 | 0 | 0 | 0.604523079623345 | 0.604523079623345 | true | false | false | true | ||||||||||||||||
| 78882582-3a84-4bb5-b725-2ac9965da69b | 2026-09-21 15:35 | 2026-09-21 15:35 | 2026-09-21 15:35 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 14.5000 | 14.4000 | 14.6500 | 752.5050 | 17400.00 | 0.00 | 17400.00 | 12 | 7 | 913 | 0 | 0 | 0.616050424943497 | 0.616050424943497 | false | false | false | true | ||||||||||||||||
| 3951cbc4-566f-40e6-bbfd-c1b2cc62e772 | 2026-09-21 15:41 | 2026-09-21 15:41 | 2026-09-21 15:41 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 15.8000 | 15.6500 | 15.8000 | 749.1200 | 22120.00 | 22120.00 | 0.00 | 14 | 6 | 971 | 0 | 0 | 0.613768887383944 | 0.612514175985694 | false | false | false | true | ||||||||||||||||
| d0db6f62-c3c1-4ea0-8bc5-9f9e731ef63b | 2026-09-22 09:54 | 2026-09-22 09:54 | 2026-09-22 09:54 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 15.8000 | 15.8000 | 16.1000 | 744.2500 | 34760.00 | 0.00 | 34760.00 | 22 | 12 | 287 | 235 | 1.22127659574468 | 0.624181619984312 | 0.624181619984312 | false | false | false | |||||||||||||||||
| a2c3ee2b-f1d6-43c4-9c4f-863d7cb4615a | 2026-09-22 13:01 | 2026-09-22 13:00 | 2026-09-22 13:00 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 16.5000 | 16.5000 | 16.9500 | 742.0000 | 16500.00 | 0.00 | 16500.00 | 10 | 7 | 668 | 235 | 2.84255319148936 | 0.611075079238225 | 0.614359984941744 | true | false | false | true | ||||||||||||||||
| 8aa197d6-4e85-41ed-8f43-3cfbf8bf1f6e | 2026-09-22 15:43 | 2026-09-22 15:43 | 2026-09-22 15:43 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 18.0400 | 18.0000 | 18.3000 | 739.2983 | 16240.00 | 1805.00 | 14435.00 | 9 | 5 | 829 | 235 | 3.52765957446808 | 0.614980118260147 | 0.616963659905234 | false | false | false | |||||||||||||||||
| b26cfd53-c12e-437f-8055-765843d11821 | 2026-09-23 11:19 | 2026-09-23 11:19 | 2026-09-23 11:19 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 11.8000 | 11.5000 | 11.8000 | 752.0050 | 15340.00 | 15340.00 | 0.00 | 13 | 6 | 515 | 220 | 2.34090909090909 | 0.733202710364539 | 0.733202710364539 | false | false | false | true | ||||||||||||||||
| 2e489a97-2610-4165-8b91-d8201c64d909 | 2026-09-23 11:41 | 2026-09-23 11:41 | 2026-09-23 11:41 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 10.8000 | 10.7000 | 10.8000 | 755.0000 | 18360.00 | 18360.00 | 0.00 | 17 | 9 | 626 | 220 | 2.84545454545455 | 0.745264737532581 | 0.745264737532581 | true | false | false | true | ||||||||||||||||
| f639486f-117d-4a2c-b2c2-b7950d5d3d2b | 2026-09-23 12:06 | 2026-09-23 12:05 | 2026-09-23 12:05 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 11.3500 | 11.2000 | 11.3500 | 754.1400 | 10215.00 | 10215.00 | 0.00 | 9 | 5 | 690 | 220 | 3.13636363636364 | 0.752916842247938 | 0.750782346602998 | true | false | false | true | ||||||||||||||||
| 77e9d0df-1b30-452e-bc27-1638d3775948 | 2026-09-23 13:00 | 2026-09-23 12:59 | 2026-09-23 12:59 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 11.5000 | 11.3500 | 11.5000 | 752.2000 | 69000.00 | 69000.00 | 0.00 | 60 | 7 | 998 | 220 | 4.53636363636364 | 0.730547861601692 | 0.722781368854927 | false | false | false | |||||||||||||||||
| 277d9b4f-a218-474e-92a9-0cab38766a21 | 2026-09-23 13:00 | 2026-09-23 13:00 | 2026-09-23 13:00 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 11.7500 | 11.5000 | 11.7500 | 751.5500 | 58750.00 | 58750.00 | 0.00 | 50 | 8 | 1048 | 220 | 4.76363636363636 | 0.730962380048218 | 0.722455558638935 | false | false | false | |||||||||||||||||
| 2d6b37ff-97db-4b1e-854a-a721963e36d0 | 2026-09-23 13:37 | 2026-09-23 13:37 | 2026-09-23 13:37 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 13.0000 | 12.8500 | 13.0000 | 748.7700 | 16900.00 | 16900.00 | 0.00 | 13 | 6 | 1205 | 220 | 5.47727272727273 | 0.727285260530943 | 0.727285260530943 | true | false | false | |||||||||||||||||
| 0b9d859f-15cc-42ea-bcbf-63916ec925e2 | 2026-09-23 13:41 | 2026-09-23 13:40 | 2026-09-23 13:40 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 12.6500 | 12.4000 | 12.6500 | 749.0000 | 24035.00 | 24035.00 | 0.00 | 19 | 9 | 1238 | 220 | 5.62727272727273 | 0.737845113977329 | 0.731617761986805 | true | false | false | |||||||||||||||||
| d366d444-485a-4b81-8f43-314613f761cd | 2026-09-23 15:25 | 2026-09-23 15:25 | 2026-09-23 15:25 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 13.1000 | 13.1000 | 13.1500 | 747.7100 | 24891.00 | 0.00 | 24891.00 | 19 | 5 | 1457 | 220 | 6.62272727272727 | 0.710913134661285 | 0.710913134661285 | false | false | false | |||||||||||||||||
| 5c0240c5-0500-4033-bb29-212b8c6ada0f | 2026-09-23 15:25 | 2026-09-23 15:25 | 2026-09-23 15:25 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 13.1000 | 13.1000 | 13.2000 | 747.6300 | 36680.00 | 0.00 | 36680.00 | 28 | 8 | 1487 | 220 | 6.75909090909091 | 0.709314298826618 | 0.709314298826618 | false | false | false | |||||||||||||||||
| a16039e1-842a-4b59-b7cd-76131a9f6571 | 2026-09-23 15:27 | 2026-09-23 15:27 | 2026-09-23 15:27 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 13.7000 | 13.5000 | 13.7000 | 746.0000 | 10960.00 | 10960.00 | 0.00 | 8 | 8 | 1496 | 220 | 6.8 | 0.717006924324643 | 0.717006924324643 | false | false | false | true | ||||||||||||||||
| 39c147c3-9bd6-470a-8fb5-88a40b8df92d | 2026-09-23 15:45 | 2026-09-23 15:45 | 2026-09-23 15:45 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 13.1500 | 13.0000 | 13.1500 | 747.0000 | 24985.00 | 24985.00 | 0.00 | 19 | 15 | 1596 | 220 | 7.25454545454545 | 0.712908209794245 | 0.712908209794245 | true | false | false | |||||||||||||||||
| f77eb827-8982-4776-b980-7eb45ad0306c | 2026-09-24 09:34 | 2026-09-24 09:34 | 2026-09-24 09:34 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 6.7000 | 6.4000 | 6.7000 | 756.2050 | 35510.00 | 35510.00 | 0.00 | 53 | 9 | 201 | 532 | 0.37781954887218 | 0.792077249937817 | 0.792077249937817 | true | false | false | true | ||||||||||||||||
| 623518b8-0faf-4680-a3cc-2056d1508700 | 2026-09-24 11:11 | 2026-09-24 11:11 | 2026-09-24 11:11 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 3.3000 | 3.3000 | 3.4000 | 764.0000 | 12210.00 | 0.00 | 12210.00 | 37 | 9 | 1736 | 532 | 3.26315789473684 | 0.70146257030448 | 0.70146257030448 | false | false | false | true | ||||||||||||||||
| 4d76bcef-6494-4420-9b97-b07581059baa | 2026-09-24 11:31 | 2026-09-24 11:31 | 2026-09-24 11:31 | META | META260925P00742500 | put | 742.5000 | 2026-09-25 | 3.2000 | 3.1000 | 3.3000 | 764.3800 | 16000.00 | 0.00 | 0.00 | 50 | 5 | 2104 | 532 | 3.95488721804511 | 0.687432188890813 | 0.687432188890813 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:33:58.164258Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:36:57.124687Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:43:03.886437Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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-22T13:56:25.927111Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:06:21.234354Z"} |
| 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:45:09.843958Z"} |
| 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 |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:19:29.119553Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T15:47:22.680410Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T16:06:31.927382Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T17:01:20.516262Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T17:01:20.516262Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T17:39:01.188751Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T17:43:03.709156Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T19:25:57.460829Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T19:25:57.460829Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-23T19:31:17.816750Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T19:47:37.737983Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-24T13:35:42.562828Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:12:31.706500Z"} |
| 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-24T15:34:38.323653Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |