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 |
|---|
| 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 |
|---|
| f875e2bf-f304-4c43-ae2c-7224c3976265 | 2026-09-24 12:32 | 2026-09-24 12:32 | 2026-09-24 12:32 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 7.3900 | 7.1000 | 7.4000 | 767.0147 | 118980.00 | 98405.00 | 20575.00 | 161 | 24 | 17721 | 862 | 20.5580046403712 | 0.663171556622925 | 0.663171556622925 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 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-24T16:36:42.025876Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| c3d734e4-2dec-4631-b430-21f11932e361 | 2026-09-24 12:16 | 2026-09-24 12:16 | 2026-09-24 12:16 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 7.7100 | 7.5000 | 7.7500 | 766.0000 | 19270.00 | 0.00 | 3770.00 | 25 | 5 | 16189 | 862 | 18.7807424593968 | 0.684008075735971 | 0.670777554052695 | false | false | false | |||||||||||||||||
| 83f8c1e8-c725-45df-b14b-3e70673cf266 | 2026-09-24 10:26 | 2026-09-24 10:26 | 2026-09-24 10:26 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 8.5000 | 8.3500 | 8.8000 | 767.3700 | 37400.00 | 0.00 | 37400.00 | 44 | 7 | 6842 | 862 | 7.93735498839907 | 0.744689016234117 | 0.743534506168738 | true | false | false | |||||||||||||||||
| 9c465ed4-a245-48fb-b1cb-f8bcc78c66b4 | 2026-09-24 10:23 | 2026-09-24 10:23 | 2026-09-24 10:23 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 9.2000 | 9.2000 | 9.4500 | 765.2200 | 10125.00 | 0.00 | 10125.00 | 11 | 5 | 6555 | 862 | 7.60440835266821 | 0.740319261664848 | 0.73230053314871 | true | false | false | |||||||||||||||||
| ad317b5e-15bd-48b9-9b88-c253186bb8a9 | 2026-09-24 10:21 | 2026-09-24 10:21 | 2026-09-24 10:21 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 8.7900 | 8.7000 | 9.0000 | 766.7100 | 11425.00 | 0.00 | 11425.00 | 13 | 8 | 6406 | 862 | 7.43155452436195 | 0.745948930645296 | 0.739507246551482 | false | false | false | |||||||||||||||||
| 4e01686a-5e19-4ee9-bd61-79aba36b52be | 2026-09-24 10:17 | 2026-09-24 10:17 | 2026-09-24 10:17 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 11.4100 | 11.3000 | 11.4500 | 760.5100 | 11410.00 | 11410.00 | 0.00 | 10 | 5 | 5707 | 862 | 6.62064965197216 | 0.739860282702275 | 0.736709340645695 | true | false | false | |||||||||||||||||
| 2c3e3e36-62ac-4210-a963-9e93f51a56c2 | 2026-09-24 10:17 | 2026-09-24 10:17 | 2026-09-24 10:17 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 11.1100 | 11.1000 | 11.5000 | 760.7043 | 46651.00 | 0.00 | 46651.00 | 42 | 8 | 5656 | 862 | 6.5614849187935 | 0.730018525308984 | 0.723716431819783 | false | false | false | |||||||||||||||||
| c83a49a4-beb4-492f-83ad-ebe5177ea888 | 2026-09-24 10:12 | 2026-09-24 10:12 | 2026-09-24 10:12 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 10.1900 | 9.8000 | 10.2000 | 764.5700 | 35663.00 | 34660.00 | 1003.00 | 35 | 7 | 4937 | 862 | 5.72737819025522 | 0.778332486845239 | 0.767527443479913 | true | false | false | |||||||||||||||||
| 1bbc4386-7216-4438-a0cb-ee9576696ae7 | 2026-09-24 10:09 | 2026-09-24 10:09 | 2026-09-24 10:09 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 9.4900 | 9.3000 | 9.7500 | 765.8200 | 13284.00 | 10450.00 | 2834.00 | 14 | 6 | 4572 | 862 | 5.30394431554524 | 0.763243660385983 | 0.760468645590935 | false | false | false | |||||||||||||||||
| f9cbe886-09af-4e9c-a440-dee67438f8f3 | 2026-09-24 10:09 | 2026-09-24 10:09 | 2026-09-24 10:09 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 9.9800 | 9.8000 | 10.2500 | 764.8300 | 43920.00 | 0.00 | 43920.00 | 44 | 22 | 4544 | 862 | 5.27146171693736 | 0.741376616827141 | 0.760004663521533 | true | false | false | |||||||||||||||||
| e17a89c7-ecb5-47d9-b6f2-c268659c4a60 | 2026-09-24 10:08 | 2026-09-24 10:08 | 2026-09-24 10:08 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 10.5900 | 10.5000 | 10.9000 | 762.6600 | 26475.00 | 0.00 | 26475.00 | 25 | 6 | 4395 | 862 | 5.09860788863109 | 0.749964560469884 | 0.743646033184492 | false | false | false | |||||||||||||||||
| 5268d169-5ed1-4f5a-bf76-5551236effde | 2026-09-24 10:07 | 2026-09-24 10:07 | 2026-09-24 10:07 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 11.5600 | 11.1500 | 11.9000 | 760.6699 | 19653.00 | 12763.00 | 5750.00 | 17 | 7 | 4107 | 862 | 4.76450116009281 | 0.737504419096987 | 0.746619638247246 | true | false | false | |||||||||||||||||
| 84532f39-0ce2-4094-9b84-e1e8a219887c | 2026-09-24 09:41 | 2026-09-24 09:41 | 2026-09-24 09:41 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 11.0100 | 10.9000 | 11.5500 | 763.6750 | 11011.00 | 0.00 | 11011.00 | 10 | 6 | 1437 | 862 | 1.66705336426914 | 0.79132150958791 | 0.804796804446472 | false | false | false | |||||||||||||||||
| 91f73ce7-0776-468a-a61e-d8ecadea125f | 2026-09-24 09:41 | 2026-09-24 09:41 | 2026-09-24 09:41 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 11.9300 | 11.6000 | 12.3000 | 761.6350 | 15515.00 | 0.00 | 15515.00 | 13 | 5 | 1387 | 862 | 1.60904872389791 | 0.78907604830804 | 0.783134122026183 | false | false | false | |||||||||||||||||
| 595700f2-ee20-4ec4-81b5-70eca4b7cfa2 | 2026-09-24 09:39 | 2026-09-24 09:39 | 2026-09-24 09:39 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 11.5800 | 11.4750 | 11.9000 | 762.1200 | 10423.00 | 0.00 | 10423.00 | 9 | 6 | 1022 | 862 | 1.18561484918794 | 0.796613383793621 | 0.79426368437425 | false | false | false | |||||||||||||||||
| 4aeab7e7-a8c7-453e-abca-32c581aaae0e | 2026-09-24 09:38 | 2026-09-24 09:38 | 2026-09-24 09:38 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 11.8000 | 11.7500 | 12.3000 | 762.0750 | 34215.00 | 0.00 | 34215.00 | 29 | 5 | 864 | 862 | 1.00232018561485 | 0.811871751001078 | 0.80556324776299 | false | false | false | |||||||||||||||||
| b4c732da-00ac-4d0e-841a-390127204498 | 2026-09-24 09:36 | 2026-09-24 09:36 | 2026-09-24 09:36 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 16.2000 | 15.4500 | 17.0000 | 753.6700 | 16205.00 | 6540.00 | 9665.00 | 10 | 10 | 441 | 862 | 0.511600928074246 | 0.788500330689183 | 0.796142216896088 | true | false | false | |||||||||||||||||
| e6ff04fe-7860-4506-acdb-671d20fe1d7e | 2026-09-23 09:54 | 2026-09-23 09:54 | 2026-09-23 09:54 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 17.9500 | 17.8000 | 17.9500 | 756.3775 | 102339.00 | 102339.00 | 0.00 | 57 | 12 | 281 | 570 | 0.492982456140351 | 0.730779030210359 | 0.722029337226314 | true | false | false | |||||||||||||||||
| 3f56dc32-cff0-4708-bc79-40d75003e06e | 2026-09-22 09:43 | 2026-09-22 09:43 | 2026-09-22 09:43 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 25.3800 | 25.3000 | 26.2000 | 746.0000 | 20300.00 | 7620.00 | 12680.00 | 8 | 8 | 205 | 269 | 0.762081784386617 | 0.660688751858782 | 0.65470076205295 | true | false | false | |||||||||||||||||
| f8c36332-fc5d-4d5f-aae1-4bfdfc3c4d61 | 2026-09-21 15:19 | 2026-09-21 15:19 | 2026-09-21 15:19 | META | META260925P00760000 | put | 760.0000 | 2026-09-25 | 27.3600 | 27.2500 | 27.5000 | 744.5500 | 65656.00 | 0.00 | 65656.00 | 24 | 6 | 221 | 1 | 221 | 0.600015249048249 | 0.600015249048249 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-24T16:16:49.777231Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-24T14:28:24.219175Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-24T14:24:55.986256Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-24T14:24:55.986256Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-24T14:18:01.976836Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-24T14:18:01.976836Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-24T14:14:26.159357Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-24T14:10:55.671270Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-24T14:10:55.671270Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-24T14:08:54.070178Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-24T14:08:54.070178Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:42:52.039375Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:42:52.039375Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:40:59.800251Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:38:54.076483Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:37:11.678086Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-23T13:55:29.867504Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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-22T13:45:11.876123Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:21:01.961528Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |