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 | price |
|---|
| 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 |
|---|
| b013c821-3799-4731-8a67-491b63fb648a | 2026-09-10 14:21 | 2026-09-10 14:21 | 2026-09-10 14:21 | AEO | AEO261120C00015000 | call | 15.0000 | 2026-11-20 | 0.8200 | 0.8000 | 0.8200 | 14.1250 | 10660.00 | 10660.00 | 0.00 | 130 | 28 | 879 | 11203 | 0.0784611264839775 | 0.45671269730644 | 0.45671269730644 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 2585656528.00 | 2026-12-01 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T18:37:18.479310Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ad707cf2-39f5-4d7d-bc8f-7e5be58fead0 | 2026-09-10 14:23 | 2026-09-10 14:23 | 2026-09-10 14:23 | AEO | AEO261120C00015000 | call | 15.0000 | 2026-11-20 | 0.8300 | 0.8000 | 0.8300 | 14.1600 | 27307.00 | 27307.00 | 0.00 | 329 | 11 | 1218 | 11203 | 0.10872087833616 | 0.454547641086145 | 0.454547641086145 | false | false | false | true | false | |||||||||||||||
| 7b5a5de1-bf9f-4781-b2f6-a018288a5888 | 2026-09-10 14:23 | 2026-09-10 14:23 | 2026-09-10 14:23 | AEO | AEO261120C00015000 | call | 15.0000 | 2026-11-20 | 0.8400 | 0.8000 | 0.8400 | 14.1650 | 14278.00 | 14195.00 | 83.00 | 170 | 32 | 1388 | 11203 | 0.123895385164688 | 0.453654545101922 | 0.457711420512288 | false | false | false | true | false | |||||||||||||||
| 29c28458-e1c5-474b-b1e8-3f6c148014bd | 2026-09-10 14:37 | 2026-09-10 14:37 | 2026-09-10 14:37 | AEO | AEO261120C00015000 | call | 15.0000 | 2026-11-20 | 0.8700 | 0.8400 | 0.8800 | 14.2150 | 30450.00 | 30450.00 | 0.00 | 350 | 30 | 2678 | 11203 | 0.239043113451754 | 0.460836493943753 | 0.460836493943753 | false | false | false | true | false | |||||||||||||||
| e149d7ed-f9de-4f9f-8b05-80bdaad0c39f | 2026-09-11 09:39 | 2026-09-11 09:39 | 2026-09-11 09:39 | AEO | AEO260918C00014500 | call | 14.5000 | 2026-09-18 | 0.5500 | 0.4500 | 0.6600 | 14.7600 | 11018.00 | 1870.00 | 9148.00 | 200 | 8 | 200 | 334 | 0.598802395209581 | 0.52282522731339 | 0.533955908764491 | false | false | false | true | false | |||||||||||||||
| 94545055-4452-46f5-8fe3-91ba77ee5e5c | 2026-09-11 09:42 | 2026-09-11 09:42 | 2026-09-11 09:42 | AEO | AEO270115C00018000 | call | 18.0000 | 2027-01-15 | 0.8000 | 0.8000 | 0.9900 | 14.8250 | 13920.00 | 0.00 | 13920.00 | 174 | 33 | 375 | 452 | 0.829646017699115 | 0.507576903456225 | 0.507576903456225 | true | false | false | true | false | |||||||||||||||
| be7c2639-ba26-444c-ae88-97aea7951f2b | 2026-09-11 10:18 | 2026-09-11 10:18 | 2026-09-11 10:18 | AEO | AEO270115C00018000 | call | 18.0000 | 2027-01-15 | 0.7900 | 0.7800 | 0.8000 | 14.7500 | 25596.00 | 79.00 | 25517.00 | 324 | 8 | 857 | 452 | 1.89601769911504 | 0.512101140541945 | 0.512101140541945 | false | false | false | true | false | |||||||||||||||
| 9e8d4fa0-e00a-461e-9b83-b3fa46d55d86 | 2026-09-14 13:30 | 2026-09-14 13:30 | 2026-09-14 13:30 | AEO | AEO260918P00016000 | put | 16.0000 | 2026-09-18 | 0.6600 | 0.6000 | 0.6600 | 15.5150 | 62832.00 | 62832.00 | 0.00 | 952 | 42 | 1057 | 491 | 2.15274949083503 | 0.567093924710789 | 0.567093924710789 | false | false | false | true | false | |||||||||||||||
| 93f9b7cd-371e-475b-ad79-14274b1dd597 | 2026-09-14 14:26 | 2026-09-14 14:26 | 2026-09-14 14:26 | AEO | AEO260918C00015500 | call | 15.5000 | 2026-09-18 | 0.3900 | 0.3800 | 0.4000 | 15.5700 | 36192.00 | 0.00 | 35841.00 | 928 | 16 | 1833 | 500 | 3.666 | 0.540366424966795 | 0.540366424966795 | false | false | false | true | false | |||||||||||||||
| e6643e0f-ea41-4bdd-9abb-1c3d780f30d0 | 2026-09-15 11:19 | 2026-09-15 11:19 | 2026-09-15 11:19 | AEO | AEO270115P00014000 | put | 14.0000 | 2027-01-15 | 1.3800 | 1.3800 | 1.4100 | 14.7750 | 25668.00 | 0.00 | 25668.00 | 186 | 8 | 186 | 2496 | 0.0745192307692308 | 0.551953599668197 | 0.551953599668197 | false | false | false | true | false | |||||||||||||||
| ac01e6b9-ab95-4b0e-bccd-8decbdc3add9 | 2026-09-16 11:14 | 2026-09-16 11:14 | 2026-09-16 11:14 | AEO | AEO270219P00014000 | put | 14.0000 | 2027-02-19 | 1.4000 | 1.3700 | 1.4900 | 15.1100 | 14171.00 | 0.00 | 14171.00 | 101 | 11 | 212 | 609 | 0.348111658456486 | 0.539351189958262 | 0.538891196246046 | false | false | false | true | false | |||||||||||||||
| 6524ea6a-d178-46bb-99e7-ddcdae3a2db4 | 2026-09-16 11:14 | 2026-09-16 11:14 | 2026-09-16 11:14 | AEO | AEO270219P00014000 | put | 14.0000 | 2027-02-19 | 1.3900 | 1.3700 | 1.4700 | 15.1150 | 51380.00 | 277.00 | 51103.00 | 369 | 46 | 581 | 609 | 0.954022988505747 | 0.538891196246046 | 0.539351189958262 | false | false | false | true | false | |||||||||||||||
| fecfce3b-e5da-44b9-bc02-b10d135dd618 | 2026-09-16 11:14 | 2026-09-16 11:14 | 2026-09-16 11:14 | AEO | AEO270219P00013000 | put | 13.0000 | 2027-02-19 | 1.0000 | 0.9300 | 1.0100 | 15.1150 | 21800.00 | 12000.00 | 9600.00 | 218 | 13 | 357 | 130 | 2.74615384615385 | 0.540590873987479 | 0.540994155668361 | false | false | false | true | false | |||||||||||||||
| bcc9177b-28be-47eb-9f08-4ef117bce218 | 2026-09-17 10:22 | 2026-09-17 10:22 | 2026-09-17 10:22 | AEO | AEO290119C00020000 | call | 20.0000 | 2029-01-19 | 3.3000 | 2.9600 | 3.6500 | 14.9500 | 10890.00 | 4620.00 | 6270.00 | 33 | 5 | 33 | 2 | 16.5 | 0.472572951744224 | 0.472572951744224 | false | false | false | true | false | |||||||||||||||
| 9ad92b58-272e-47f8-b9e3-be4e0bab055b | 2026-09-18 10:55 | 2026-09-18 10:55 | 2026-09-18 10:55 | AEO | AEO261016P00016000 | put | 16.0000 | 2026-10-16 | 1.2700 | 1.2700 | 1.4200 | 15.1850 | 24511.00 | 0.00 | 24511.00 | 193 | 10 | 195 | 1346 | 0.144873699851412 | 0.483673614727038 | 0.483673614727038 | true | false | false | true | false | |||||||||||||||
| 06395fcd-e412-4e38-8ad3-ec9e155986ca | 2026-09-21 10:35 | 2026-09-21 10:35 | 2026-09-21 10:35 | AEO | AEO261016C00015500 | call | 15.5000 | 2026-10-16 | 0.4600 | 0.4600 | 0.5000 | 15.0600 | 51934.00 | 0.00 | 51934.00 | 1129 | 7 | 1161 | 0 | 0 | 0.40151672291674 | 0.40151672291674 | false | false | false | true | false | |||||||||||||||
| d9bd670e-7c2a-41b6-9c63-46a5f2d3f621 | 2026-09-21 14:11 | 2026-09-21 14:11 | 2026-09-21 14:11 | AEO | AEO270115P00015000 | put | 15.0000 | 2027-01-15 | 1.5200 | 1.4900 | 1.5200 | 15.4400 | 15048.00 | 15048.00 | 0.00 | 99 | 11 | 104 | 2800 | 0.0371428571428571 | 0.538094517502007 | 0.538094517502007 | false | false | false | true | false | |||||||||||||||
| eb1dac12-a41d-4f12-bda1-b93be007db83 | 2026-09-21 15:46 | 2026-09-21 15:46 | 2026-09-21 15:46 | AEO | AEO270115C00017000 | call | 17.0000 | 2027-01-15 | 1.1600 | 1.1600 | 1.2000 | 15.5150 | 11600.00 | 0.00 | 11600.00 | 100 | 9 | 195 | 1030 | 0.189320388349515 | 0.474254649519044 | 0.474254649519044 | true | false | false | true | false | |||||||||||||||
| d204c0fb-dd36-4c40-b36b-d651a22702cb | 2026-09-22 13:51 | 2026-09-22 13:51 | 2026-09-22 13:51 | AEO | AEO270115C00019000 | call | 19.0000 | 2027-01-15 | 0.8100 | 0.7900 | 0.8100 | 15.9600 | 17253.00 | 17253.00 | 0.00 | 213 | 23 | 254 | 522 | 0.486590038314176 | 0.487550984286944 | 0.487550984286944 | false | false | false | true | false | |||||||||||||||
| 7d51827c-9429-4c27-b3d3-577fd455459a | 2026-09-22 13:56 | 2026-09-22 13:56 | 2026-09-22 13:56 | AEO | AEO261120C00015000 | call | 15.0000 | 2026-11-20 | 1.6800 | 1.5300 | 1.6800 | 16.0326 | 11424.00 | 11424.00 | 0.00 | 68 | 5 | 112 | 20226 | 0.00553742707406309 | 0.409957175924264 | 0.409957175924264 | true | false | false | true | false | |||||||||||||||
| 312805a8-d441-44fd-969c-86929ba5b924 | 2026-09-23 12:02 | 2026-09-23 12:02 | 2026-09-23 12:02 | AEO | AEO260925C00014000 | call | 14.0000 | 2026-09-25 | 2.0000 | 1.8000 | 2.2500 | 16.0000 | 20600.00 | 0.00 | 20600.00 | 103 | 11 | 105 | 346 | 0.303468208092486 | 2.06039221363691 | 2.08793035312099 | false | false | false | true | false | |||||||||||||||
| 0f49a836-25dd-4ac7-95a0-2390fc6a5abc | 2026-09-24 10:39 | 2026-09-24 10:39 | 2026-09-24 10:39 | AEO | AEO270115P00018000 | put | 18.0000 | 2027-01-15 | 3.2100 | 2.9500 | 3.2500 | 15.7900 | 11553.00 | 11553.00 | 0.00 | 36 | 5 | 72 | 200 | 0.36 | 0.572284616880496 | 0.551823574116212 | false | false | false | true | false | |||||||||||||||
| 383bd7c4-a875-45f2-bd95-103897bc5737 | 2026-09-25 15:07 | 2026-09-25 15:07 | 2026-09-25 15:07 | AEO | AEO261120P00015000 | put | 15.0000 | 2026-11-20 | 0.5100 | 0.4800 | 0.5200 | 16.0000 | 31722.00 | 31722.00 | 0.00 | 622 | 8 | 628 | 1425 | 0.440701754385965 | 0.447479169356307 | 0.447479169356307 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:37:18.479310Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:37:18.479310Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T19:03:59.290358Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:46:58.036194Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:46:58.036194Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T14:26:53.669819Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T18:49:41.095224Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:29:06.202071Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2481761062.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:39:18.643032Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2481761062.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:39:18.643032Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2481761062.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T15:39:18.643032Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2498518395.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:33:58.839655Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2523654395.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2590683728.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:37:14.719915Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2590683728.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:15:35.599753Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2590683728.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:46:53.809312Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2667767461.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:52:53.749956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2667767461.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:57:38.128984Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2667767461.00 |
| 2026-12-01 |
| 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 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2667767461.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T14:39:59.397883Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2778365861.00 |
| 2026-12-01 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:10:45.993353Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |