Simplify AnalyticsOptions flow alerts (market-wide)
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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cf3ede96-6828-44f2-86b1-8c7f3a82a747 | 2026-08-17 11:15 | 2026-08-17 11:15 | 2026-08-17 11:15 | AMR | AMR270219C00200000 | call | 200.0000 | 2027-02-19 | 17.0000 | 15.5000 | 17.0000 | 167.7950 | 32300.00 | 3400.00 | 0.00 | 19 | 18 | 19 | 26 | 0.730769230769231 | 0.563519925660697 | 0.563519925660697 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2508549053.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| da895a9b-69a4-47ef-bc51-f690c48c54a0 | 2026-08-17 12:04 | 2026-08-17 12:04 | 2026-08-17 12:04 | AMR | AMR260918C00170000 | call | 170.0000 | 2026-09-18 | 9.0000 | 9.0000 | 9.9000 | 166.8800 | 105300.00 | 0.00 | 105300.00 | 117 | 30 | 120 | 36 | 3.33333333333333 | 0.515320230174328 | 0.515320230174328 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2508549053.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e2b6b69f-429d-4e77-943d-556a9e32db0b | 2026-08-19 12:39 | 2026-08-19 12:39 | 2026-08-19 12:39 | AMR | AMR261120C00220000 | call | 220.0000 | 2026-11-20 | 12.8000 | 11.3000 | 12.8000 | 188.9500 | 124160.00 | 124160.00 | 0.00 | 97 | 24 | 102 | 46 | 2.21739130434783 | 0.603735982765133 | 0.603735982765133 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2508549053.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:52:36.966336Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8bbc7b9a-8175-4369-880b-aa72f3af331f | 2026-08-19 13:52 | 2026-08-19 13:52 | 2026-08-19 13:52 | AMR | AMR261120P00175000 | put | 175.0000 | 2026-11-20 | 15.3000 | 13.9000 | 15.3000 | 188.2500 | 79560.00 | 79560.00 | 0.00 | 52 | 15 | 64 | 57 | 1.12280701754386 | 0.606506733669059 | 0.606506733669059 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2508549053.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 046f6d4f-63ad-4cb8-b22f-90fa2399e834 | 2026-08-19 15:20 | 2026-08-19 15:20 | 2026-08-19 15:20 | AMR | AMR261120P00165000 | put | 165.0000 | 2026-11-20 | 10.0000 | 10.0000 | 10.8000 | 191.8600 | 33000.00 | 0.00 | 33000.00 | 33 | 14 | 62 | 92 | 0.673913043478261 | 0.598423280041023 | 0.598423280041023 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2508549053.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 87033330-cf36-4ac3-8ea8-6597b111a5fb | 2026-08-27 14:21 | 2026-08-27 14:21 | 2026-08-27 14:21 | AMR | AMR261016C00270000 | call | 270.0000 | 2026-10-16 | 6.2000 | 5.7000 | 6.2000 | 225.5800 | 30380.00 | 30380.00 | 0.00 | 49 | 15 | 52 | 0 | 0 | 0.580555709251786 | 0.580555709251786 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2508549053.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6cb5a6e9-845c-4d20-9a22-67064cdc83d7 | 2026-08-27 15:02 | 2026-08-27 15:02 | 2026-08-27 15:02 | AMR | AMR270219C00250000 | call | 250.0000 | 2027-02-19 | 29.5000 | 29.2000 | 29.5000 | 227.1750 | 206499.00 | 206499.00 | 0.00 | 70 | 24 | 72 | 12 | 6 | 0.582944419699115 | 0.582944419699115 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2508549053.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6cfaea93-31d6-46e9-9b6b-144ecf1788a8 | 2026-08-31 11:14 | 2026-08-31 11:14 | 2026-08-31 11:14 | AMR | AMR270219P00190000 | put | 190.0000 | 2027-02-19 | 15.0000 | 11.9000 | 16.0000 | 234.3904 | 37500.00 | 30000.00 | 7500.00 | 25 | 5 | 35 | 8 | 4.375 | 0.59118025805468 | 0.59118025805468 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2508549053.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e839bdac-9dff-4bf2-8431-2f8c9cf22db0 | 2026-09-01 11:59 | 2026-09-01 11:59 | 2026-09-01 11:59 | AMR | AMR260918C00250000 | call | 250.0000 | 2026-09-18 | 6.0000 | 5.7500 | 6.4000 | 233.7800 | 15000.00 | 6000.00 | 9000.00 | 25 | 6 | 25 | 202 | 0.123762376237624 | 0.592362768141666 | 0.592362768141666 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2508549053.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T16:07:53.122506Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7d51b0cb-3d75-4f8f-985d-12f384439f3a | 2026-09-03 14:31 | 2026-09-03 14:31 | 2026-09-03 14:31 | AMR | AMR260918C00190000 | call | 190.0000 | 2026-09-18 | 25.4000 | 25.4000 | 25.5000 | 213.1600 | 238766.00 | 0.00 | 238766.00 | 94 | 21 | 94 | 141 | 0.666666666666667 | 0.48661014394342 | 0.574113841716722 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2508549053.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T18:47:01.806289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f2b3b19d-4827-4e47-9d3a-623b2400b2ed | 2026-09-11 14:30 | 2026-09-11 14:29 | 2026-09-11 14:29 | AMR | AMR260918C00210000 | call | 210.0000 | 2026-09-18 | 5.0000 | 4.6000 | 6.4000 | 207.0200 | 89000.00 | 25500.00 | 63500.00 | 178 | 40 | 189 | 19 | 9.94736842105263 | 0.508728887652088 | 0.548201963283797 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2508549053.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T18:33:12.425630Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f29646db-193e-48b1-937a-450aa20fd1e7 | 2026-09-14 10:29 | 2026-09-14 10:29 | 2026-09-14 10:29 | AMR | AMR261016C00220000 | call | 220.0000 | 2026-10-16 | 6.6000 | 5.5000 | 6.7000 | 199.6800 | 22440.00 | 21780.00 | 660.00 | 34 | 24 | 35 | 54 | 0.648148148148148 | 0.579352374225789 | 0.579352374225789 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2508549053.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:43:33.165845Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0a0fcd53-a9a6-4e4b-8b00-faf0aee03b41 | 2026-09-15 10:59 | 2026-09-15 10:59 | 2026-09-15 10:59 | AMR | AMR260918C00195000 | call | 195.0000 | 2026-09-18 | 2.8500 | 2.0000 | 2.8500 | 188.0000 | 43313.00 | 43313.00 | 0.00 | 152 | 34 | 157 | 25 | 6.28 | 0.798877867051239 | 0.798877867051239 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2508549053.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T15:09:54.469160Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| fb27a2e7-8c89-48e9-af67-aa3861b2dc8e | 2026-09-15 12:29 | 2026-09-15 12:29 | 2026-09-15 12:29 | AMR | AMR261016P00200000 | put | 200.0000 | 2026-10-16 | 19.7000 | 18.3000 | 19.7000 | 188.0000 | 224580.00 | 224580.00 | 0.00 | 114 | 30 | 118 | 63 | 1.87301587301587 | 0.610055338788223 | 0.610055338788223 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2508549053.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T16:48:10.363261Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| e8d1ba17-6422-4b8e-b2c8-ea675477c76d | 2026-09-17 11:02 | 2026-09-17 11:02 | 2026-09-17 11:02 | AMR | AMR261016C00185000 | call | 185.0000 | 2026-10-16 | 13.2000 | 11.7000 | 13.2000 | 186.5150 | 46200.00 | 46200.00 | 0.00 | 35 | 18 | 35 | 1 | 35 | 0.581936593941762 | 0.581936593941762 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2342199983.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| bc92ed4b-32d6-4ed2-88f7-c81ef7ea87cb | 2026-09-17 11:02 | 2026-09-17 11:02 | 2026-09-17 11:02 | AMR | AMR261016C00180000 | call | 180.0000 | 2026-10-16 | 15.7000 | 14.5000 | 15.7000 | 186.5150 | 100480.00 | 100480.00 | 0.00 | 64 | 27 | 64 | 2 | 32 | 0.575359699176947 | 0.575359699176947 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2342199983.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 4bad78f8-1443-46db-a29f-80a8accf1552 | 2026-09-17 13:42 | 2026-09-17 13:42 | 2026-09-17 13:42 | AMR | AMR261120C00195000 | call | 195.0000 | 2026-11-20 | 15.1000 | 14.4000 | 15.1000 | 185.6002 | 10570.00 | 10570.00 | 0.00 | 7 | 5 | 7 | 41 | 0.170731707317073 | 0.596014607902476 | 0.596014607902476 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2342199983.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T18:13:15.605683Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| ff08c007-f344-4068-9f60-a27070f1e700 | 2026-09-18 13:22 | 2026-09-18 13:22 | 2026-09-18 13:22 | AMR | AMR261120C00180000 | call | 180.0000 | 2026-11-20 | 15.6000 | 14.6000 | 15.6000 | 175.1200 | 113880.00 | 113880.00 | 0.00 | 73 | 26 | 78 | 110 | 0.709090909090909 | 0.592941375586498 | 0.592941375586498 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2208943220.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| f60d32f3-6170-4579-bcd9-ea57f353c463 | 2026-09-21 12:50 | 2026-09-21 12:50 | 2026-09-21 12:50 | AMR | AMR261016C00200000 | call | 200.0000 | 2026-10-16 | 3.0000 | 3.0000 | 3.3000 | 177.4350 | 32700.00 | 0.00 | 32700.00 | 109 | 27 | 113 | 21 | 5.38095238095238 | 0.537297277267373 | 0.537297277267373 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2225045607.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:51:16.040164Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 47184b5c-8127-48df-9edb-c596cb2b691b | 2026-09-21 12:50 | 2026-09-21 12:50 | 2026-09-21 12:50 | AMR | AMR261016C00190000 | call | 190.0000 | 2026-10-16 | 5.3000 | 5.3000 | 5.7000 | 177.4350 | 35510.00 | 0.00 | 35510.00 | 67 | 17 | 71 | 12 | 5.91666666666667 | 0.53385617077036 | 0.53385617077036 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2225045607.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:51:16.040164Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 7cc13ca8-c458-41e3-a281-fea8744b10f8 | 2026-09-21 13:38 | 2026-09-21 13:38 | 2026-09-21 13:38 | AMR | AMR270219P00190000 | put | 190.0000 | 2027-02-19 | 30.5000 | 29.9000 | 30.5000 | 177.0000 | 27450.00 | 27450.00 | 0.00 | 9 | 8 | 15 | 44 | 0.340909090909091 | 0.550014541882658 | 0.550014541882658 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 2225045607.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:39:31.841992Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |