Simplify Analytics
← Data Explorer

Options 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

created_at (ET days)to
column equals (exact text)
sort
chart against created_at
reset
active:ticker = CLX×
iduuidcreated_attimestamp with time zonestart_timetimestamp with time zoneend_timetimestamp with time zonetickertextoption_symboltextoption_typetextstrikenumericexpirydatepricenumericbidnumericasknumericunderlying_pricenumerictotal_premiumnumerictotal_ask_side_premnumerictotal_bid_side_premnumerictotal_sizebiginttrade_countintegervolumebigintopen_interestbigintvolume_oi_rationumericiv_startnumericiv_endnumerichas_sweepbooleanhas_floorbooleanhas_multilegbooleanhas_singlelegbooleanall_opening_tradesbooleanalert_ruletextrule_iduuidexpiry_countintegerissue_typetextsectortextmarketcapnumericnext_earnings_datedateer_timetextmissing_periscopebooleansourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
cbb5ffb3-2936-4dfd-b2d3-b22e89b78cdb2026-08-27 10:292026-08-27 10:292026-08-27 10:29CLXCLX261016C00115000call115.00002026-10-161.25001.25001.3500103.465011000.000.0011000.00889958370.1135005973715650.3045837489421470.304583748942147falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-27T14:37:18.031558Z"}2026-09-152026-09-15 08:452026-09-15 08:45
b1896a88-d43f-42ec-bfe9-46a0b26a9a602026-08-25 13:402026-08-25 13:402026-08-25 13:40CLXCLX260918P00105000put105.00002026-09-183.00003.00003.2000104.765032703.000.0032703.00109314297940.5403022670025190.2812446233377820.281244623337782falsefalsefalsetruefalseRepeatedHitsAscendingFilla0979b52-28e4-4585-8f22-881faad2dd8e1Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-25T17:59:30.582778Z"}2026-09-152026-09-15 08:452026-09-15 08:45
f4ea2586-3159-4724-973e-0a2db92738ef2026-08-25 13:402026-08-25 13:402026-08-25 13:40CLXCLX260918P00105000put105.00002026-09-183.00003.00003.2000104.765010803.000.0010803.0036163207940.4030226700251890.2821784258660520.282178425866052falsefalsefalsetruefalseRepeatedHitsDescendingFill5ce5ec11-087c-4c00-b164-08106b0158561Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-25T17:59:30.582778Z"}2026-09-152026-09-15 08:452026-09-15 08:45
b681adee-0f77-4495-9861-a9521327f34b2026-08-25 13:292026-08-25 13:282026-08-25 13:28CLXCLX260918P00105000put105.00002026-09-183.10003.10003.2000104.680013330.000.0013330.004320867940.108312342569270.2867237825376360.286723782537636falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-25T17:31:01.749779Z"}2026-09-152026-09-15 08:452026-09-15 08:45
64519a2b-b9f8-4d49-adc1-442d4f1c09542026-08-21 15:412026-08-21 15:412026-08-21 15:41CLXCLX270115P00100000put100.00002027-01-155.30005.10005.5000106.780022260.0013250.000.004265013400.03731343283582090.3418334220091240.341833422009124falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-21T19:48:47.460535Z"}2026-09-152026-09-15 08:452026-09-15 08:45
4b09480b-deca-4d94-90b6-489ce58029882026-08-21 09:522026-08-21 09:522026-08-21 09:52CLXCLX260918C00105000call105.00002026-09-183.70003.70004.0000105.334122200.000.0022200.00601812132570.03715075222597480.2905484996288050.290548499628805falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"}2026-09-152026-09-15 08:452026-09-15 08:45
ed98b90d-e9ab-4fec-8619-1b4b08daa9f62026-08-21 09:522026-08-21 09:522026-08-21 09:52CLXCLX260918C00105000call105.00002026-09-183.70003.70004.0000105.380022200.000.0022200.0060176132570.01872889161805340.2888496511599450.288375393294141falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-21T14:02:30.096545Z"}2026-09-152026-09-15 08:452026-09-15 08:45
9b639fdd-7ad3-4d85-9d94-454534609f802026-08-20 11:542026-08-20 11:542026-08-20 11:54CLXCLX270115P00095000put95.00002027-01-153.40003.40003.7000107.160011220.000.0011220.003364112240.03349673202614380.3366942805129620.336694280512962falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"}2026-09-152026-09-15 08:452026-09-15 08:45
12097ecb-ede7-4d3c-878e-ebaa9ad61caa2026-08-20 09:532026-08-20 09:532026-08-20 09:53CLXCLX260918C00110000call110.00002026-09-183.20003.20003.5000108.625012800.000.0012800.00401276353520.1425635276532140.3015072308392290.301507230839229truefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"}2026-09-152026-09-15 08:452026-09-15 08:45
a8c6abf3-e929-46f4-b31f-ce16300cdd232026-08-20 09:532026-08-20 09:532026-08-20 09:53CLXCLX260918C00110000call110.00002026-09-183.20003.20003.5000108.625056000.000.0056000.001751664753520.1208893871449930.3015072308392290.301507230839229truefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"}2026-09-152026-09-15 08:452026-09-15 08:45
1bce406e-a6f8-4e7e-bd0e-03992fa7f1b22026-08-20 09:532026-08-20 09:532026-08-20 09:53CLXCLX260918C00110000call110.00002026-09-183.20003.20003.5000108.6700130240.000.00130240.00407647153520.08800448430493270.299761791346630.29976179134663truefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"}2026-09-152026-09-15 08:452026-09-15 08:45
494de83c-438a-4e97-bb3c-d431779383b92026-08-20 09:362026-08-20 09:362026-08-20 09:36CLXCLX260918C00110000call110.00002026-09-183.26002.35003.5000108.850013365.0013365.000.004155753520.01065022421524660.3009111451338720.300911145133872falsefalsefalsetruefalseRepeatedHitsDescendingFill5ce5ec11-087c-4c00-b164-08106b0158561Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"}2026-09-152026-09-15 08:452026-09-15 08:45
c956d641-24b1-42fd-9b93-9abe1678aa912026-08-19 15:172026-08-19 15:172026-08-19 15:17CLXCLX260821C00105000call105.00002026-08-213.50003.30003.5000108.310035000.0035000.000.001005307255740.5511302475780410.3421962245207590.359766907226513falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"}2026-09-152026-09-15 08:452026-09-15 08:45
3cffe73c-effe-4ee0-b8ce-73c392c12f9f2026-08-19 15:112026-08-19 15:112026-08-19 15:11CLXCLX260821C00105000call105.00002026-08-213.30003.10003.3000108.180033000.0033000.000.001007267055740.4790096878363830.3447934362203240.30163723506594falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"}2026-09-152026-09-15 08:452026-09-15 08:45
50a2ca2e-b0fb-4ffb-b4ad-b30f0f414fd92026-08-19 15:102026-08-19 15:102026-08-19 15:10CLXCLX260821C00105000call105.00002026-08-213.10002.75003.1000107.900031000.0031000.000.001005247055740.4431288123430210.354204692079670.334800897248464falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-19T19:28:47.574144Z"}2026-09-152026-09-15 08:452026-09-15 08:45
151016a1-a3d2-4e14-8bae-913570fa19672026-08-19 13:252026-08-19 13:252026-08-19 13:25CLXCLX260918C00110000call110.00002026-09-182.50002.50002.5500106.850015500.000.0015500.0062848754430.08947271725151570.3019888958991390.301988895899139falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"}2026-09-152026-09-15 08:452026-09-15 08:45
a0a130ce-a0ec-4123-949a-be984a03d9962026-08-19 11:032026-08-19 11:022026-08-19 11:02CLXCLX260821C00105000call105.00002026-08-212.35002.30002.3500106.960082250.0082250.000.003508145055740.2601363473268750.3523399589091010.345976535222831falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"}2026-09-152026-09-15 08:452026-09-15 08:45
eaf940c9-0d18-48fa-9bd0-c9a217363c7d2026-08-19 11:022026-08-19 11:022026-08-19 11:02CLXCLX261016C00115000call115.00002026-10-162.50002.50002.6500106.940018500.000.0018250.0074121217520.1609042553191490.3073933285500320.307393328550032truefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"}2026-09-152026-09-15 08:452026-09-15 08:45
8dcfadad-8154-45ce-8eaa-f442b642e5b92026-08-19 11:022026-08-19 11:022026-08-19 11:02CLXCLX260821C00105000call105.00002026-08-212.40002.10002.4000107.030048240.0048240.000.00201665155740.1167922497308930.3441637018720530.344163701872053falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"}2026-09-152026-09-15 08:452026-09-15 08:45
5f486f92-84e7-4c01-bf8a-996dc04871d92026-08-19 10:582026-08-19 10:572026-08-19 10:57CLXCLX260918P00110000put110.00002026-09-185.30005.20005.5000106.825012720.001060.0011660.00241024380.6315789473684210.2997166665130070.299972169196367falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-19T15:01:13.058297Z"}2026-09-152026-09-15 08:452026-09-15 08:45
b82e654c-7058-4ab3-a3e2-1a050e3ed2c92026-08-18 11:332026-08-18 11:322026-08-18 11:32CLXCLX260821C00105000call105.00002026-08-212.45002.35002.4500106.790034300.0034300.000.00140724175620.03186987569426080.3517770667203680.351777066720368falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"}2026-09-152026-09-15 08:452026-09-15 08:45
f4b2fa59-f655-46a2-b35a-684ed02f7ec82026-08-18 10:562026-08-18 10:562026-08-18 10:56CLXCLX270319P00100000put100.00002027-03-197.00007.00007.1000107.200016100.000.0016100.00235385409.6250.357290889400130.35729088940013falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"}2026-09-152026-09-15 08:452026-09-15 08:45
41c757ce-1a13-412a-9f29-37e59b3cb32b2026-08-18 10:562026-08-18 10:562026-08-18 10:56CLXCLX270319P00100000put100.00002027-03-197.00006.70007.5000107.2600245000.0046900.00198100.0035011362409.050.3579421473228530.357942147322853falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"}2026-09-152026-09-15 08:452026-09-15 08:45
29372d9b-a01e-40d6-a9a5-65ccb4677a052026-08-17 15:342026-08-17 15:342026-08-17 15:34CLXCLX260918C00100000call100.00002026-09-187.74007.30008.2000105.980046464.002346.0044118.0060718314380.1272600834492350.3189859844142990.318985984414299falsefalsefalsetruefalseRepeatedHitsDescendingFill5ce5ec11-087c-4c00-b164-08106b0158561Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"}2026-09-152026-09-15 08:452026-09-15 08:45
82bb9b54-a4ae-44aa-9209-f9dd83f394b02026-08-17 15:052026-08-17 15:052026-08-17 15:05CLXCLX260918C00100000call100.00002026-09-187.78007.70008.6000106.110046700.000.0046700.0060512314380.08553546592489570.3056424453159720.305642445315972falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"}2026-09-152026-09-15 08:452026-09-15 08:45
7cde434a-9be3-4b17-81c8-e8dd84afd1b62026-08-17 11:202026-08-17 11:202026-08-17 11:20CLXCLX260918C00100000call100.00002026-09-187.15007.00008.3000105.300042908.000.0042908.006086014380.04172461752433940.3049199567327590.304919956732759falsefalsefalsetruefalseRepeatedHitsDescendingFill5ce5ec11-087c-4c00-b164-08106b0158561Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"}2026-09-152026-09-15 08:452026-09-15 08:45
0e7af4d2-331a-4e48-958a-3ea6d13a1b272026-08-17 11:052026-08-17 11:042026-08-17 11:04CLXCLX260918C00110000call110.00002026-09-182.55002.50002.6000106.730029835.000.0028815.001173822252480.04230182926829270.2996491970365660.299649197036566falsefalsefalsetruefalseRepeatedHitse6b9f0b6-fcd9-44fe-9d1c-f53521c152c31Common StockConsumer Defensive10800348057.002026-11-02unknownuw_flow_alerts/api/option-trades/flow-alerts{"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"}2026-09-152026-09-15 08:452026-09-15 08:45