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_alerts474,253 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 |
|---|
| 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 |
|---|
| 1469bb82-a22b-44c8-aced-4d7614ebb52a | 2026-09-22 15:56 | 2026-09-22 15:56 | 2026-09-22 15:56 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 2.9800 | 2.9400 | 2.9900 | 624.2900 | 36919.00 | 36919.00 | 0.00 | 124 | 20 | 13728 | 1401 | 9.79871520342612 | 0.537146600183769 | 0.538057690654996 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1018288956948.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| 93090ed2-f560-48b8-abf4-dfb40f9463be | 2026-09-22 15:55 | 2026-09-22 15:55 | 2026-09-22 15:55 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 3.0500 | 2.9600 | 3.0500 | 624.4400 | 49410.00 | 49410.00 | 0.00 | 162 | 15 | 13479 | 1401 | 9.62098501070664 | 0.539682920724405 | 0.539682920724405 | false | false | false | true | false | |||||||||||||||
| 94839f72-54da-44ad-b6f5-2639aaa22775 | 2026-09-22 15:39 | 2026-09-22 15:39 | 2026-09-22 15:39 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 2.2900 | 2.2700 | 2.3500 | 621.6301 | 56334.00 | 0.00 | 56334.00 | 246 | 23 | 12930 | 1401 | 9.22912205567452 | 0.535657041011923 | 0.535657041011923 | false | false | false | true | false | |||||||||||||||
| 6484da6e-1b5e-43e9-83f2-b267ba4390c5 | 2026-09-22 15:39 | 2026-09-22 15:39 | 2026-09-22 15:39 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 2.3100 | 2.3000 | 2.3700 | 621.6150 | 10395.00 | 0.00 | 10395.00 | 45 | 5 | 12509 | 1401 | 8.92862241256246 | 0.538034136814279 | 0.538034136814279 | false | false | false | true | false | |||||||||||||||
| d1fb0d2c-7ee8-4f70-9056-7472f8bc55f9 | 2026-09-22 15:36 | 2026-09-22 15:35 | 2026-09-22 15:36 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 2.4700 | 2.4000 | 2.4800 | 621.6799 | 43979.00 | 43979.00 | 0.00 | 178 | 36 | 12142 | 1401 | 8.66666666666667 | 0.553555391364808 | 0.55057041783341 | false | false | false | true | false | |||||||||||||||
| f00f1bd5-7a5f-4b3c-9f00-259ed2d8766f | 2026-09-22 15:35 | 2026-09-22 15:35 | 2026-09-22 15:35 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 2.4600 | 2.4600 | 2.5100 | 621.5300 | 59778.00 | 0.00 | 59778.00 | 243 | 16 | 11838 | 1401 | 8.44967880085653 | 0.555099034431118 | 0.555099034431118 | true | false | false | true | false | |||||||||||||||
| 9ab75705-383f-499c-b3d6-41dee228a510 | 2026-09-22 15:35 | 2026-09-22 15:35 | 2026-09-22 15:35 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 2.4800 | 2.4300 | 2.4800 | 621.9100 | 55530.00 | 52824.00 | 1230.00 | 224 | 22 | 10863 | 1401 | 7.75374732334047 | 0.54811130411296 | 0.54811130411296 | true | false | false | true | false | |||||||||||||||
| 85eeef6e-f9f3-417b-9240-348e5d957685 | 2026-09-22 15:35 | 2026-09-22 15:35 | 2026-09-22 15:35 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 2.5500 | 2.4800 | 2.5700 | 621.9051 | 11744.00 | 11489.00 | 255.00 | 46 | 29 | 11088 | 1401 | 7.91434689507495 | 0.555683282661632 | 0.557095033005537 | true | false | false | true | false | |||||||||||||||
| 6c188683-7ae0-432d-a39f-94f6f7543d52 | 2026-09-22 15:35 | 2026-09-22 15:35 | 2026-09-22 15:35 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 2.5300 | 2.4600 | 2.5500 | 621.8819 | 24788.00 | 23530.00 | 1258.00 | 98 | 34 | 11042 | 1401 | 7.88151320485368 | 0.550754775282257 | 0.551742289062833 | false | false | false | true | false | |||||||||||||||
| 5eb2d699-7701-461d-a91b-99825b20b4e1 | 2026-09-22 15:35 | 2026-09-22 15:35 | 2026-09-22 15:35 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 2.4800 | 2.4200 | 2.4900 | 621.8600 | 12887.00 | 12887.00 | 0.00 | 52 | 12 | 10915 | 1401 | 7.79086366880799 | 0.548304924475103 | 0.549295622830299 | true | false | false | true | false | |||||||||||||||
| e1b0727f-093b-473e-8bed-5381e83ff564 | 2026-09-22 15:35 | 2026-09-22 15:35 | 2026-09-22 15:35 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 2.5000 | 2.4300 | 2.5000 | 621.9800 | 12726.00 | 12726.00 | 0.00 | 51 | 7 | 10573 | 1401 | 7.54675231977159 | 0.548426163908285 | 0.547439541712356 | false | false | false | true | false | |||||||||||||||
| 5c8abcce-b283-4f47-805c-c77e27b66988 | 2026-09-22 15:35 | 2026-09-22 15:35 | 2026-09-22 15:35 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 2.4800 | 2.4000 | 2.5000 | 621.9250 | 16351.00 | 15608.00 | 743.00 | 66 | 16 | 10639 | 1401 | 7.59386152748037 | 0.545894244632346 | 0.546766371218762 | true | false | false | true | false | |||||||||||||||
| be44b0a0-5429-42d8-9855-af491502a402 | 2026-09-22 15:07 | 2026-09-22 15:07 | 2026-09-22 15:07 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 2.2500 | 2.2000 | 2.2500 | 620.5400 | 39375.00 | 39375.00 | 0.00 | 175 | 10 | 9582 | 1401 | 6.83940042826552 | 0.55668675142961 | 0.55668675142961 | false | false | false | true | false | |||||||||||||||
| f79a8f67-7a99-4269-8b96-da8de4b021f3 | 2026-09-22 12:36 | 2026-09-22 12:36 | 2026-09-22 12:36 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 1.4000 | 1.4000 | 1.4400 | 615.7600 | 28000.00 | 0.00 | 28000.00 | 200 | 7 | 6154 | 1401 | 4.3925767309065 | 0.560286712203955 | 0.560286712203955 | false | false | false | true | false | |||||||||||||||
| 61ef46da-f084-47b7-af80-d8e3cc2c2d1a | 2026-09-22 12:26 | 2026-09-22 12:26 | 2026-09-22 12:26 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 1.3000 | 1.3000 | 1.3300 | 614.6050 | 12480.00 | 0.00 | 12480.00 | 96 | 7 | 5838 | 1401 | 4.16702355460385 | 0.569598908351742 | 0.569598908351742 | false | false | false | true | false | |||||||||||||||
| 05180ae6-9bb8-4505-b889-ecc757db5f9a | 2026-09-22 10:51 | 2026-09-22 10:51 | 2026-09-22 10:51 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 1.9400 | 1.8700 | 1.9400 | 616.7780 | 19206.00 | 19206.00 | 0.00 | 99 | 5 | 4552 | 1401 | 3.24910778015703 | 0.605887488878496 | 0.605887488878496 | false | false | false | true | false | |||||||||||||||
| 6d23dc47-f584-4108-a81b-34bb51aabdcc | 2026-09-22 10:13 | 2026-09-22 10:13 | 2026-09-22 10:13 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 2.3800 | 2.3400 | 2.4600 | 618.4900 | 13350.00 | 3587.00 | 9763.00 | 56 | 12 | 3280 | 1401 | 2.34118486795146 | 0.618061129246417 | 0.618061129246417 | true | false | false | true | false | |||||||||||||||
| 99a022c5-7256-466f-9757-7e0e2652baa4 | 2026-09-22 10:11 | 2026-09-22 10:11 | 2026-09-22 10:11 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 3.0800 | 3.0000 | 3.1000 | 621.1260 | 15994.00 | 15384.00 | 610.00 | 52 | 11 | 2943 | 1401 | 2.10064239828694 | 0.627198814720122 | 0.623373034581758 | false | false | false | true | false | |||||||||||||||
| cb463cb6-7d64-4e9b-ad9f-8c079177eedb | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 1.8700 | 1.8700 | 2.6000 | 610.6100 | 23375.00 | 0.00 | 23375.00 | 125 | 5 | 621 | 1401 | 0.443254817987152 | 0.726149518826801 | 0.726149518826801 | false | false | false | true | false | |||||||||||||||
| 42a360bc-d853-47bc-a92f-d88032a2e15d | 2026-09-21 15:38 | 2026-09-21 15:38 | 2026-09-21 15:38 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 4.9000 | 4.8000 | 4.9000 | 615.8900 | 61250.00 | 61250.00 | 0.00 | 125 | 5 | 3012 | 8 | 376.5 | 0.654844461774317 | 0.654844461774317 | false | false | false | true | false | |||||||||||||||
| 9895e24c-1bbb-43e7-8a8e-89e9ec01c31a | 2026-09-21 15:38 | 2026-09-21 15:38 | 2026-09-21 15:38 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 4.9000 | 4.8000 | 4.9000 | 615.9550 | 61250.00 | 61250.00 | 0.00 | 125 | 6 | 2860 | 8 | 357.5 | 0.653671920624056 | 0.653671920624056 | false | false | false | true | false | |||||||||||||||
| e7acecef-915b-462b-b4cb-b5c700677716 | 2026-09-21 15:00 | 2026-09-21 15:00 | 2026-09-21 15:00 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 3.8800 | 3.7500 | 3.9000 | 612.2220 | 76778.00 | 76778.00 | 0.00 | 198 | 15 | 1913 | 8 | 239.125 | 0.648101041505262 | 0.646955405174391 | false | false | false | true | false | |||||||||||||||
| 8b89c859-5621-41f5-bcf6-d11ccd361d82 | 2026-09-21 15:00 | 2026-09-21 15:00 | 2026-09-21 15:00 | AMD | AMD260923C00635000 | call | 635.0000 | 2026-09-23 | 3.7700 | 3.6000 | 3.8000 | 611.9800 | 83727.00 | 83727.00 | 0.00 | 222 | 32 | 1562 | 8 | 195.25 | 0.642804842477679 | 0.644451438625436 | false | false | false | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:58:44.027893Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:36:12.199864Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:10:39.996631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:27:20.551854Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:56:01.933088Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:15:02.242582Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:11:50.316445Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1018288956948.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:30:37.895663Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| 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 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1004821037852.00 |
| 2026-11-03 |
| 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 |