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 |
|---|
| afaf9c8f-0312-478f-9457-0216978c551d | 2026-08-24 09:50 | 2026-08-24 09:50 | 2026-08-24 09:50 | LITE | LITE260828C00810000 | call | 810.0000 | 2026-08-28 | 27.5900 | 27.2000 | 27.6000 | 796.9900 | 55180.00 | 27600.00 | 11020.00 | 20 | 10 | 42 | 39 | 1.07692307692308 | 1.0006799760334 | 1.0006799760334 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 74902191000.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7f65533a-3dea-4a61-a00f-542c59d2be4e | 2026-08-21 11:37 | 2026-08-21 11:37 | 2026-08-21 11:37 | LITE | LITE260821C00875000 | call | 875.0000 | 2026-08-21 | 5.0200 | 4.6000 | 5.8000 | 869.3500 | 202622.00 | 157660.00 | 44962.00 | 404 | 40 | 722 | 648 | 1.1141975308642 | 0.931644081804882 | 0.961611094984197 | false | false | false | true | ||||||||||||||||
| 9ec6f385-f2df-4c22-80c0-cd31ed90f2f1 | 2026-08-21 10:59 | 2026-08-21 10:59 | 2026-08-21 10:59 | LITE | LITE260821C00870000 | call | 870.0000 | 2026-08-21 | 4.8200 | 4.7000 | 5.4000 | 858.6744 | 94960.00 | 26400.00 | 68560.00 | 197 | 18 | 414 | 1482 | 0.279352226720648 | 1.15213052372919 | 1.13854083461255 | false | false | false | true | ||||||||||||||||
| c91c1a8f-2f2a-4735-8207-30fc49558017 | 2026-08-21 09:37 | 2026-08-21 09:37 | 2026-08-21 09:37 | LITE | LITE260821C00880000 | call | 880.0000 | 2026-08-21 | 18.9000 | 18.4000 | 20.1000 | 892.0050 | 75590.00 | 0.00 | 75590.00 | 40 | 8 | 141 | 1398 | 0.100858369098712 | 1.20549319875843 | 1.26246609803193 | true | false | false | true | ||||||||||||||||
| d738eaf6-2c00-4926-97eb-84a111d11dee | 2026-08-20 15:15 | 2026-08-20 15:15 | 2026-08-20 15:15 | LITE | LITE260918P00920000 | put | 920.0000 | 2026-09-18 | 101.1100 | 99.9000 | 101.8000 | 876.8500 | 202230.00 | 10110.00 | 40450.00 | 20 | 20 | 70 | 71 | 0.985915492957746 | 0.788578181227336 | 0.787559734888933 | false | false | false | true | ||||||||||||||||
| d37a9fab-910e-4090-a7fb-5bc66a7a3399 | 2026-08-20 15:12 | 2026-08-20 15:12 | 2026-08-20 15:12 | LITE | LITE260821C00880000 | call | 880.0000 | 2026-08-21 | 15.4000 | 15.4000 | 16.0000 | 877.2400 | 260267.00 | 0.00 | 260267.00 | 169 | 14 | 2362 | 1379 | 1.71283538796229 | 0.910945379629121 | 0.910399038802192 | true | false | false | true | ||||||||||||||||
| 59de73ea-c067-48ed-b27a-528178b70a08 | 2026-08-20 13:33 | 2026-08-20 13:33 | 2026-08-20 13:33 | LITE | LITE260821C00880000 | call | 880.0000 | 2026-08-21 | 13.9600 | 13.5000 | 14.6000 | 872.9850 | 173066.00 | 38100.00 | 125096.00 | 124 | 52 | 2087 | 1379 | 1.51341551849166 | 0.942161916273456 | 0.942161916273456 | true | false | false | true | ||||||||||||||||
| b88ffaba-204a-4f52-a3ad-7dcc3a5ac076 | 2026-08-20 12:56 | 2026-08-20 12:56 | 2026-08-20 12:56 | LITE | LITE260918P00920000 | put | 920.0000 | 2026-09-18 | 106.1300 | 105.4000 | 106.8000 | 868.3240 | 212260.00 | 21230.00 | 159170.00 | 20 | 20 | 50 | 71 | 0.704225352112676 | 0.792215856694445 | 0.791182483035946 | false | false | false | true | ||||||||||||||||
| 93b3f8ad-bb82-436d-be0c-cffbd0ce7591 | 2026-08-20 12:56 | 2026-08-20 12:56 | 2026-08-20 12:56 | LITE | LITE260918P00920000 | put | 920.0000 | 2026-09-18 | 106.0400 | 105.3000 | 108.6000 | 868.2000 | 148450.00 | 31820.00 | 95430.00 | 14 | 14 | 30 | 71 | 0.422535211267606 | 0.790472991202369 | 0.789439270903022 | false | false | false | true | ||||||||||||||||
| f0433580-ea78-4d03-89a1-acb576c987d5 | 2026-08-20 10:48 | 2026-08-20 10:48 | 2026-08-20 10:48 | LITE | LITE260821P00855000 | put | 855.0000 | 2026-08-21 | 16.5000 | 16.0000 | 16.9000 | 858.9450 | 82478.00 | 36278.00 | 24750.00 | 50 | 6 | 61 | 150 | 0.406666666666667 | 1.03100270559321 | 1.03044152352048 | false | false | false | true | ||||||||||||||||
| 7c96cafb-bee3-41b0-900a-7e1a4b979b9d | 2026-08-20 10:10 | 2026-08-20 10:10 | 2026-08-20 10:10 | LITE | LITE260828C00940000 | call | 940.0000 | 2026-08-28 | 12.0000 | 10.0000 | 12.0000 | 845.0800 | 273580.00 | 272390.00 | 1190.00 | 228 | 8 | 230 | 412 | 0.558252427184466 | 0.844218952214048 | 0.834949669164587 | true | false | false | true | ||||||||||||||||
| 484685e3-3689-44ca-8b5e-1e9c06426f3c | 2026-08-20 10:00 | 2026-08-20 10:00 | 2026-08-20 10:00 | LITE | LITE260821C00850000 | call | 850.0000 | 2026-08-21 | 11.0300 | 9.6000 | 11.9000 | 832.7750 | 237152.00 | 63960.00 | 169892.00 | 215 | 56 | 737 | 292 | 2.52397260273973 | 1.04352195355865 | 1.0238337834887 | true | false | false | true | ||||||||||||||||
| c8de5c12-fe9d-42a3-a64a-8780ee79fb56 | 2026-08-19 10:29 | 2026-08-19 10:29 | 2026-08-19 10:29 | LITE | LITE260828C00870000 | call | 870.0000 | 2026-08-28 | 34.1100 | 33.1500 | 35.6000 | 844.7300 | 143260.00 | 41160.00 | 102100.00 | 42 | 5 | 410 | 30 | 13.6666666666667 | 0.851280404818592 | 0.836528753919318 | true | false | false | true | ||||||||||||||||
| 9844216f-abb1-4766-afd1-4e1d595fabc5 | 2026-08-19 09:51 | 2026-08-19 09:51 | 2026-08-19 09:51 | LITE | LITE260828C00840000 | call | 840.0000 | 2026-08-28 | 44.5200 | 42.0000 | 44.6000 | 838.6300 | 449630.00 | 449630.00 | 0.00 | 101 | 5 | 126 | 11 | 11.4545454545455 | 0.854866511097247 | 0.852959405964724 | false | false | false | true | ||||||||||||||||
| b54c2e53-6545-45f4-9f64-17390a8ce56a | 2026-08-19 09:39 | 2026-08-19 09:39 | 2026-08-19 09:39 | LITE | LITE260828C01100000 | call | 1100.0000 | 2026-08-28 | 2.9800 | 2.1500 | 3.1000 | 848.6700 | 62297.00 | 41642.00 | 10755.00 | 209 | 26 | 439 | 1621 | 0.270820481184454 | 0.990058056650095 | 0.966150022079153 | true | false | false | true | ||||||||||||||||
| cf067b94-0366-4007-88a1-fa0935c0d264 | 2026-08-19 09:39 | 2026-08-19 09:39 | 2026-08-19 09:39 | LITE | LITE260828C01100000 | call | 1100.0000 | 2026-08-28 | 3.0300 | 2.1500 | 3.8000 | 851.3200 | 69075.00 | 32860.00 | 16375.00 | 228 | 26 | 230 | 1621 | 0.14188772362739 | 0.986674836268286 | 0.986674836268286 | true | false | false | true | ||||||||||||||||
| 072a62ec-3937-4dc2-8de7-eac933c578f0 | 2026-08-18 13:46 | 2026-08-18 13:46 | 2026-08-18 13:46 | LITE | LITE270617C01300000 | call | 1300.0000 | 2027-06-17 | 163.8200 | 163.8000 | 171.5000 | 870.0478 | 81910.00 | 0.00 | 81910.00 | 5 | 5 | 6 | 15 | 0.4 | 0.86148858777304 | 0.86117144154341 | false | false | false | true | ||||||||||||||||
| 7134d784-cfbd-43e1-85b8-43e0906684cf | 2026-08-18 12:08 | 2026-08-18 12:08 | 2026-08-18 12:08 | LITE | LITE260821C00940000 | call | 940.0000 | 2026-08-21 | 10.4000 | 9.8000 | 11.8000 | 879.4150 | 75890.00 | 31190.00 | 44700.00 | 73 | 22 | 203 | 134 | 1.51492537313433 | 0.96972623389886 | 0.961614578675757 | false | false | false | true | ||||||||||||||||
| f62187b6-7ade-4a26-a82c-898ee1279577 | 2026-08-18 11:54 | 2026-08-18 11:54 | 2026-08-18 11:54 | LITE | LITE270319P00740000 | put | 740.0000 | 2027-03-19 | 134.1400 | 129.6000 | 136.1000 | 882.1673 | 201210.00 | 161070.00 | 40140.00 | 15 | 5 | 19 | 24 | 0.791666666666667 | 0.852550922221843 | 0.852096941424211 | false | false | false | true | ||||||||||||||||
| f849a87e-3f74-4a6e-8e8a-0528fb059ffb | 2026-08-17 13:33 | 2026-08-17 13:33 | 2026-08-17 13:33 | LITE | LITE280915P00640000 | put | 640.0000 | 2028-09-15 | 197.7400 | 197.6000 | 205.0000 | 987.0500 | 98870.00 | 19790.00 | 39520.00 | 5 | 5 | 22 | 2 | 11 | 0.875201833522822 | 0.874292123560833 | true | false | false | true | ||||||||||||||||
| 74d1fd7a-0639-4bb5-a456-f8906e61877f | 2026-08-17 12:31 | 2026-08-17 12:31 | 2026-08-17 12:31 | LITE | LITE260821C00900000 | call | 900.0000 | 2026-08-21 | 95.9400 | 93.0000 | 96.0000 | 986.6700 | 1218440.00 | 1218440.00 | 0.00 | 127 | 50 | 217 | 775 | 0.28 | 0.962156480936999 | 0.947538923796447 | true | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:38:28.521674Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T13:43:10.748747Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:16:26.699237Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T19:16:26.699237Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:02:58.462752Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:37:39.751673Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:40:44.275238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 74902191000.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |