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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| d3265fee-1453-49e7-ab4a-c22d83310fad | 2026-09-21 14:31 | 2026-09-21 14:31 | 2026-09-21 14:31 | CL | CL261016P00086000 | put | 86.0000 | 2026-10-16 | 1.7000 | 1.6000 | 1.7000 | 86.0000 | 29580.00 | 29580.00 | 0.00 | 174 | 28 | 339 | 0 | 0 | 0.211652355542901 | 0.211652355542901 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 68764128230.00 | 2026-10-30 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:32:54.184324Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 164d0166-dddc-4ec2-ba66-0eca62a57536 | 2026-09-21 13:31 | 2026-09-21 13:31 | 2026-09-21 13:31 | CL | CL261218P00085000 | put | 85.0000 | 2026-12-18 | 3.1000 | 2.7000 | 3.1000 | 86.3100 | 20460.00 | 20460.00 | 0.00 | 66 | 5 | 71 | 141 | 0.50354609929078 | 0.244954400857226 | 0.244954400857226 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 68764128230.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:34:20.106500Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| a21fe961-7f95-4d9c-a8c8-d08d4ca0a652 | 2026-09-21 11:50 | 2026-09-21 11:50 | 2026-09-21 11:50 | CL | CL261218C00085000 | call | 85.0000 | 2026-12-18 | 5.0000 | 4.8000 | 5.0000 | 86.7400 | 13000.00 | 13000.00 | 0.00 | 26 | 5 | 35 | 72 | 0.486111111111111 | 0.212780077339842 | 0.212780077339842 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 68764128230.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:52:20.515056Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| b2124b11-677e-4d08-b5ab-5092b621e1c1 | 2026-09-21 11:25 | 2026-09-21 11:24 | 2026-09-21 11:24 | CL | CL261016P00086000 | put | 86.0000 | 2026-10-16 | 1.5000 | 1.4000 | 1.5000 | 86.6800 | 22800.00 | 22800.00 | 0.00 | 152 | 26 | 159 | 0 | 0 | 0.213564345393565 | 0.213564345393565 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 68764128230.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:27:55.894324Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| c29c53f9-de03-4b4b-87ed-ad9603e34f95 | 2026-09-11 10:03 | 2026-09-11 10:03 | 2026-09-11 10:03 | CL | CL261002C00089000 | call | 89.0000 | 2026-10-02 | 2.1500 | 1.1000 | 2.3500 | 89.4850 | 214949.00 | 186554.00 | 28395.00 | 999 | 33 | 999 | 5 | 199.8 | 0.306840103552834 | 0.221330892029626 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T14:11:33.656123Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4abe59a0-9b81-49c7-a8d9-47edb3bceb99 | 2026-09-10 13:09 | 2026-09-10 13:09 | 2026-09-10 13:09 | CL | CL270115P00085000 | put | 85.0000 | 2027-01-15 | 3.1000 | 3.1000 | 3.3000 | 88.0500 | 67270.00 | 0.00 | 67270.00 | 217 | 28 | 220 | 653 | 0.336906584992343 | 0.24394621508882 | 0.24394621508882 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T17:37:34.117542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5ed8d1f3-b98e-4c01-a11a-9add41bb4f20 | 2026-09-08 10:58 | 2026-09-08 10:58 | 2026-09-08 10:58 | CL | CL270319P00087500 | put | 87.5000 | 2027-03-19 | 5.2000 | 4.7000 | 5.2000 | 88.4000 | 134680.00 | 134680.00 | 0.00 | 259 | 25 | 963 | 151 | 6.37748344370861 | 0.258415373776621 | 0.258415373776621 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7d9cad7d-78d4-4fb4-b173-f7454c478b03 | 2026-09-08 10:51 | 2026-09-08 10:51 | 2026-09-08 10:51 | CL | CL270319P00087500 | put | 87.5000 | 2027-03-19 | 5.0000 | 4.7000 | 5.3000 | 88.5700 | 111500.00 | 71500.00 | 25500.00 | 223 | 14 | 223 | 151 | 1.47682119205298 | 0.253022983355556 | 0.253022983355556 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f496376b-a1eb-4676-b0f7-0b7310117acd | 2026-08-31 13:15 | 2026-08-31 13:14 | 2026-08-31 13:14 | CL | CL260918P00100000 | put | 100.0000 | 2026-09-18 | 9.8000 | 9.7000 | 10.0000 | 90.1550 | 73522.00 | 0.00 | 61762.00 | 75 | 10 | 75 | 6 | 12.5 | 0.286070551805594 | 0.288074138440396 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 37a6d768-2878-4f84-83fe-acf853040766 | 2026-08-26 10:40 | 2026-08-26 10:40 | 2026-08-26 10:40 | CL | CL261016P00090000 | put | 90.0000 | 2026-10-16 | 1.9000 | 1.9000 | 2.0500 | 91.9250 | 105450.00 | 0.00 | 105450.00 | 555 | 18 | 555 | 120 | 4.625 | 0.217852358730232 | 0.217852358730232 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 756a6a0d-44e0-4ae6-a9a4-b8464c33d1f9 | 2026-08-21 14:58 | 2026-08-21 14:58 | 2026-08-21 14:58 | CL | CL261120C00095000 | call | 95.0000 | 2026-11-20 | 2.4500 | 2.4500 | 2.9500 | 91.1550 | 159250.00 | 0.00 | 159250.00 | 650 | 35 | 650 | 160 | 4.0625 | 0.202473334475806 | 0.202473334475806 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:11:44.414359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6f0f2fd8-e80c-4820-945a-107c5b1bc451 | 2026-08-20 10:36 | 2026-08-20 10:36 | 2026-08-20 10:36 | CL | CL270319C00105000 | call | 105.0000 | 2027-03-19 | 1.8000 | 1.8000 | 1.8500 | 89.6150 | 64080.00 | 0.00 | 64080.00 | 356 | 9 | 7369 | 8176 | 0.901296477495108 | 0.215478381457366 | 0.215478381457366 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 91f37094-ac62-44d0-afc0-4df681619bcb | 2026-08-20 10:35 | 2026-08-20 10:35 | 2026-08-20 10:35 | CL | CL270319C00105000 | call | 105.0000 | 2027-03-19 | 1.8000 | 1.8000 | 2.0500 | 89.6700 | 71640.00 | 0.00 | 71640.00 | 398 | 6 | 6018 | 8176 | 0.73605675146771 | 0.214868766545975 | 0.214868766545975 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a8973749-622b-4cf9-9781-a4d064d6c2be | 2026-08-20 10:35 | 2026-08-20 10:35 | 2026-08-20 10:35 | CL | CL270319C00105000 | call | 105.0000 | 2027-03-19 | 1.8000 | 1.8000 | 1.8500 | 89.6605 | 66600.00 | 0.00 | 66600.00 | 370 | 7 | 5620 | 8176 | 0.687377690802348 | 0.214974066801078 | 0.214974066801078 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a8e40fa7-1084-497c-978a-161454cf2e83 | 2026-08-20 10:35 | 2026-08-20 10:35 | 2026-08-20 10:35 | CL | CL270319C00105000 | call | 105.0000 | 2027-03-19 | 1.8500 | 1.8000 | 1.8500 | 89.7150 | 72145.00 | 18500.00 | 180.00 | 390 | 16 | 5250 | 8176 | 0.642123287671233 | 0.216780358318331 | 0.214369957495093 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4ebb93c2-ac1b-46d5-a5f8-669c0181994e | 2026-08-20 10:35 | 2026-08-20 10:35 | 2026-08-20 10:35 | CL | CL270319C00105000 | call | 105.0000 | 2027-03-19 | 1.8500 | 1.7500 | 1.8500 | 89.7210 | 66970.00 | 4625.00 | 0.00 | 362 | 14 | 4846 | 8176 | 0.592710371819961 | 0.216713457225209 | 0.216713457225209 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a23b16e0-ed0f-4424-bd7f-31082d80af63 | 2026-08-20 10:33 | 2026-08-20 10:33 | 2026-08-20 10:33 | CL | CL270319C00105000 | call | 105.0000 | 2027-03-19 | 1.7500 | 1.7500 | 2.0000 | 89.6450 | 73150.00 | 0.00 | 73150.00 | 418 | 8 | 3872 | 8176 | 0.473581213307241 | 0.212712489726347 | 0.212712489726347 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 98ee014b-baf1-41c8-9414-b3ce4e62e6e7 | 2026-08-20 10:33 | 2026-08-20 10:33 | 2026-08-20 10:33 | CL | CL270319C00105000 | call | 105.0000 | 2027-03-19 | 1.7500 | 1.7500 | 2.0000 | 89.6400 | 50750.00 | 0.00 | 50750.00 | 290 | 6 | 3454 | 8176 | 0.422455968688845 | 0.212767577603761 | 0.212767577603761 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0f53037c-a3f3-42ba-bf20-9d5a735a431b | 2026-08-20 10:33 | 2026-08-20 10:33 | 2026-08-20 10:33 | CL | CL270319C00105000 | call | 105.0000 | 2027-03-19 | 1.8500 | 1.7000 | 1.8500 | 89.6700 | 71780.00 | 51800.00 | 0.00 | 388 | 15 | 2641 | 8176 | 0.323018590998043 | 0.217282098901734 | 0.217282098901734 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 152a9c8c-3b52-4049-b91f-1a5452b0db42 | 2026-08-20 10:32 | 2026-08-20 10:32 | 2026-08-20 10:32 | CL | CL270319C00105000 | call | 105.0000 | 2027-03-19 | 1.7000 | 1.5500 | 1.8500 | 89.6450 | 60030.00 | 13620.00 | 3400.00 | 353 | 20 | 1783 | 8176 | 0.218077299412916 | 0.210259744510852 | 0.210259744510852 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ddfa8581-f68c-49d0-8d51-842763bdce63 | 2026-08-20 10:32 | 2026-08-20 10:32 | 2026-08-20 10:32 | CL | CL270319C00105000 | call | 105.0000 | 2027-03-19 | 1.7600 | 1.5000 | 1.8000 | 89.6400 | 61710.00 | 61710.00 | 0.00 | 350 | 27 | 1430 | 8176 | 0.174902152641879 | 0.212767577603761 | 0.215201289171573 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1789eb0f-df88-4966-b7d2-75267be8ec2e | 2026-08-20 10:32 | 2026-08-20 10:32 | 2026-08-20 10:32 | CL | CL270319C00105000 | call | 105.0000 | 2027-03-19 | 1.6800 | 1.5500 | 2.0000 | 89.6500 | 89370.00 | 42945.00 | 2310.00 | 533 | 38 | 1075 | 8176 | 0.131482387475538 | 0.207623392928481 | 0.207732205884182 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 466df523-330e-4bcc-a477-44acf23c4f34 | 2026-08-20 10:32 | 2026-08-20 10:32 | 2026-08-20 10:32 | CL | CL270319C00105000 | call | 105.0000 | 2027-03-19 | 1.9500 | 0.8500 | 1.9500 | 89.8750 | 60645.00 | 14820.00 | 0.00 | 311 | 16 | 312 | 8176 | 0.038160469667319 | 0.219745047671608 | 0.219745047671608 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70063519941.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |