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_alerts326,449 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 |
|---|
| 5e74d468-1eff-4560-9dfa-68c0a03d3e84 | 2026-09-04 12:49 | 2026-09-04 12:48 | 2026-09-04 12:48 | AGCO | AGCO261016C00135000 | call | 135.0000 | 2026-10-16 | 5.7000 | 5.5000 | 5.8000 | 132.9348 | 37620.00 | 37620.00 | 0.00 | 66 | 16 | 66 | 0 | 0 | 0.354205093191065 | 0.354205093191065 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 8564880457.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 55e03757-a6a5-422e-9670-21c8d0416dfc | 2026-09-04 12:49 | 2026-09-04 12:48 | 2026-09-04 12:48 | AGCO | AGCO261016C00145000 | call | 145.0000 | 2026-10-16 | 2.5600 | 2.4500 | 2.6000 | 132.9348 | 38850.00 | 26510.00 | 10780.00 | 152 | 23 | 153 | 3 | 51 | 0.365334364255761 | 0.365334364255761 | false | false | false | true | false | |||||||||||||||
| 4d0f72d5-5bca-4c19-adf5-95a5b987b0af | 2026-09-04 12:34 | 2026-09-04 12:34 | 2026-09-04 12:34 | AGCO | AGCO260918C00145000 | call | 145.0000 | 2026-09-18 | 0.8000 | 0.7500 | 0.8500 | 132.5100 | 12620.00 | 1660.00 | 10880.00 | 157 | 12 | 1154 | 1 | 1154 | 0.422100856072555 | 0.422100856072555 | false | false | false | true | false | |||||||||||||||
| 0cbdd54d-a450-403f-a651-8f78dc005c0b | 2026-09-04 12:32 | 2026-09-04 12:32 | 2026-09-04 12:32 | AGCO | AGCO260918C00140000 | call | 140.0000 | 2026-09-18 | 1.4500 | 0.8500 | 1.4500 | 132.5450 | 11890.00 | 11890.00 | 0.00 | 82 | 17 | 83 | 3 | 27.6666666666667 | 0.384944239793674 | 0.384944239793674 | false | false | false | true | ||||||||||||||||
| b6460d55-b1a8-4546-836d-8c50f98d1b77 | 2026-09-04 11:29 | 2026-09-04 11:29 | 2026-09-04 11:29 | AGCO | AGCO270219C00165000 | call | 165.0000 | 2027-02-19 | 3.4000 | 1.1500 | 3.4000 | 130.4350 | 306000.00 | 306000.00 | 0.00 | 900 | 4 | 900 | 2 | 450 | 0.352734640081914 | 0.352734640081914 | false | true | true | false | false | |||||||||||||||
| ef8f57ed-c11b-4426-8bb4-d1d1e9cb2531 | 2026-09-04 11:01 | 2026-09-04 11:01 | 2026-09-04 11:01 | AGCO | AGCO270219C00170000 | call | 170.0000 | 2027-02-19 | 2.7000 | 2.3000 | 2.7000 | 130.4620 | 24840.00 | 24840.00 | 0.00 | 92 | 16 | 94 | 5 | 18.8 | 0.351361673002801 | 0.351361673002801 | false | false | false | true | false | |||||||||||||||
| 0996713d-5ff0-41a7-95de-dbcd49725522 | 2026-08-31 12:25 | 2026-08-31 12:24 | 2026-08-31 12:24 | AGCO | AGCO260918C00130000 | call | 130.0000 | 2026-09-18 | 0.6500 | 0.6000 | 0.7000 | 118.2350 | 10010.00 | 9945.00 | 0.00 | 154 | 5 | 211 | 0 | 0 | 0.369101779612478 | 0.369101779612478 | false | false | false | true | false | |||||||||||||||
| 7599c4c6-bf32-49f9-8785-11558741cad3 | 2026-08-31 11:47 | 2026-08-31 11:46 | 2026-08-31 11:46 | AGCO | AGCO260918C00125000 | call | 125.0000 | 2026-09-18 | 1.4500 | 1.3500 | 1.5000 | 118.6175 | 34659.00 | 729.00 | 33930.00 | 239 | 22 | 1005 | 15 | 67 | 0.348504954006779 | 0.349112667879275 | false | false | false | true | false | |||||||||||||||
| dbb0ad8c-bc2b-41e4-b5d4-12a74890139d | 2026-08-31 10:57 | 2026-08-31 10:56 | 2026-08-31 10:56 | AGCO | AGCO260918C00125000 | call | 125.0000 | 2026-09-18 | 1.1000 | 0.7500 | 1.1000 | 117.5150 | 17909.00 | 17909.00 | 0.00 | 163 | 43 | 221 | 15 | 14.7333333333333 | 0.325500313916938 | 0.338475341204202 | false | false | false | true | ||||||||||||||||
| 1c902414-5920-4179-8a9e-727e017af2d1 | 2026-08-20 14:10 | 2026-08-20 14:10 | 2026-08-20 14:10 | AGCO | AGCO260918C00105000 | call | 105.0000 | 2026-09-18 | 3.1000 | 3.0000 | 3.2000 | 102.9700 | 57020.00 | 0.00 | 57020.00 | 184 | 29 | 197 | 16 | 12.3125 | 0.32712312276439 | 0.325281895590132 | false | false | false | true | false | |||||||||||||||
| 02a02619-e4fa-4c89-857e-03643db2b60e | 2026-08-20 11:07 | 2026-08-20 11:07 | 2026-08-20 11:07 | AGCO | AGCO260821C00105000 | call | 105.0000 | 2026-08-21 | 0.9500 | 0.8000 | 1.0500 | 104.6300 | 11205.00 | 5415.00 | 5790.00 | 118 | 8 | 326 | 8 | 40.75 | 0.534722381290478 | 0.51195640824858 | false | false | false | true | false | |||||||||||||||
| e78b8622-e7a9-4d12-b367-29bdb6fea671 | 2026-08-20 11:07 | 2026-08-20 11:07 | 2026-08-20 11:07 | AGCO | AGCO260821C00105000 | call | 105.0000 | 2026-08-21 | 0.9200 | 0.8000 | 0.9500 | 104.3850 | 16380.00 | 9990.00 | 6390.00 | 178 | 6 | 203 | 8 | 25.375 | 0.562003228547557 | 0.53866435748061 | false | false | false | true | false | |||||||||||||||
| 98c93533-2654-4aa4-9951-6ff9751dd253 | 2026-08-20 10:05 | 2026-08-20 10:05 | 2026-08-20 10:05 | AGCO | AGCO261120C00135000 | call | 135.0000 | 2026-11-20 | 0.4500 | 0.4500 | 0.7000 | 100.4700 | 10890.00 | 0.00 | 10890.00 | 242 | 8 | 4550 | 4634 | 0.981873111782477 | 0.350925699276079 | 0.350925699276079 | false | false | false | true | ||||||||||||||||
| 73d363df-3148-4465-a876-3d7f4a2e505c | 2026-08-20 10:05 | 2026-08-20 10:05 | 2026-08-20 10:05 | AGCO | AGCO261120C00135000 | call | 135.0000 | 2026-11-20 | 0.4500 | 0.4500 | 0.5000 | 100.5000 | 23475.00 | 1200.00 | 22275.00 | 519 | 16 | 4003 | 4634 | 0.863832542080276 | 0.350623351957391 | 0.358438898612955 | false | false | false | true | ||||||||||||||||
| f4ba57b3-b8c6-4914-95c2-392719609bb0 | 2026-08-20 10:05 | 2026-08-20 10:05 | 2026-08-20 10:05 | AGCO | AGCO261120C00135000 | call | 135.0000 | 2026-11-20 | 0.4500 | 0.4500 | 0.5000 | 100.5000 | 14200.00 | 700.00 | 13500.00 | 314 | 6 | 3484 | 4634 | 0.751834268450583 | 0.350623351957391 | 0.358438898612955 | false | false | false | true | ||||||||||||||||
| 2721b18d-1c17-43f5-91c5-6d4cdb178844 | 2026-08-20 10:05 | 2026-08-20 10:04 | 2026-08-20 10:04 | AGCO | AGCO261120C00135000 | call | 135.0000 | 2026-11-20 | 0.4600 | 0.4500 | 0.5000 | 100.8140 | 19505.00 | 2900.00 | 16605.00 | 427 | 18 | 3128 | 4634 | 0.675010789814415 | 0.347462434250117 | 0.355226059116901 | false | false | false | true | ||||||||||||||||
| 5256162a-ba06-460b-8cd3-02d7fa4d3193 | 2026-08-20 10:04 | 2026-08-20 10:04 | 2026-08-20 10:04 | AGCO | AGCO261120C00135000 | call | 135.0000 | 2026-11-20 | 0.4500 | 0.4000 | 0.7000 | 100.8140 | 16065.00 | 2565.00 | 855.00 | 357 | 19 | 2627 | 4634 | 0.566896849374191 | 0.347462434250117 | 0.347462434250117 | false | false | false | true | ||||||||||||||||
| 621098f5-da0c-47b5-86fd-c6054c148aa3 | 2026-08-20 10:04 | 2026-08-20 10:03 | 2026-08-20 10:03 | AGCO | AGCO261120C00135000 | call | 135.0000 | 2026-11-20 | 0.5000 | 0.4000 | 0.5000 | 100.8140 | 16250.00 | 16250.00 | 0.00 | 325 | 17 | 2270 | 4634 | 0.489857574449719 | 0.355226059116901 | 0.355226059116901 | false | false | false | true | ||||||||||||||||
| 094339b8-1f67-40df-bc5d-5156c0ff4b55 | 2026-08-20 10:03 | 2026-08-20 10:03 | 2026-08-20 10:03 | AGCO | AGCO261120C00135000 | call | 135.0000 | 2026-11-20 | 0.5000 | 0.4500 | 0.7000 | 101.0700 | 24750.00 | 23000.00 | 400.00 | 495 | 19 | 1806 | 4634 | 0.389728096676737 | 0.35261160995767 | 0.35261160995767 | true | false | false | true | ||||||||||||||||
| 29594bfc-ada7-4612-bafc-adb6e1097ca4 | 2026-08-20 10:03 | 2026-08-20 10:03 | 2026-08-20 10:03 | AGCO | AGCO261120C00135000 | call | 135.0000 | 2026-11-20 | 0.5200 | 0.4500 | 0.6000 | 101.0700 | 26245.00 | 15155.00 | 2240.00 | 501 | 39 | 1311 | 4634 | 0.282908933966336 | 0.35261160995767 | 0.359933412211367 | true | false | false | true | ||||||||||||||||
| 05447f42-cce4-4d69-a2bc-c49be5ffb990 | 2026-08-20 10:03 | 2026-08-20 10:03 | 2026-08-20 10:03 | AGCO | AGCO261120C00135000 | call | 135.0000 | 2026-11-20 | 0.5500 | 0.5000 | 0.5500 | 101.0700 | 11495.00 | 11495.00 | 0.00 | 209 | 19 | 810 | 4634 | 0.174794993526111 | 0.359933412211367 | 0.359933412211367 | true | false | false | true | ||||||||||||||||
| eef77628-9711-4ed5-be2b-a836f76fce0d | 2026-08-20 09:35 | 2026-08-20 09:35 | 2026-08-20 09:35 | AGCO | AGCO261120C00135000 | call | 135.0000 | 2026-11-20 | 0.4700 | 0.4500 | 0.6000 | 101.0800 | 10380.00 | 3900.00 | 6480.00 | 222 | 21 | 601 | 4634 | 0.129693569270609 | 0.344789881300117 | 0.352509572217965 | false | false | false | true |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:32:28.507822Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| FloorTradeMidCap |
| d9769fb4-003b-49e4-9181-c78c9cc101f5 |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:46:11.944585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:39:59.140702Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T15:07:09.972110Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T18:14:08.178572Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:16:49.821442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:16:49.821442Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| 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 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Industrials |
| 8564880457.00 |
| 2026-10-30 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |