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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = SHOP×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

d1b397ec-a82d-47ee-9427-9239f130bbcd	2026-09-21 13:47	2026-09-21 13:47	2026-09-21 13:47	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	7.7000	7.4000	7.7500	135.0800	13860.00	13860.00	0.00	18	6	46881	46336	1.01176191298343	0.531289015688094	0.531289015688094	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	166686022258.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T17:50:05.863152Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
00fd405b-f7f8-44b9-9c26-2a2b0668707e	2026-09-21 13:47	2026-09-21 13:46	2026-09-21 13:46	SHOP	SHOP261120P00120000	put	120.0000	2026-11-20	6.5000	5.8000	6.7000	134.1900	67555.00	3900.00	63005.00	104	13	194	1558	0.124518613607189	0.617405748529967	0.617405748529967	true	false	false	true
73c9ac85-a67d-450a-9433-4cd9d17269a4	2026-09-21 13:46	2026-09-21 13:46	2026-09-21 13:46	SHOP	SHOP260925C00135000	call	135.0000	2026-09-25	3.8000	3.5500	3.9000	134.0000	28488.00	0.00	28488.00	75	11	3956	728	5.43406593406593	0.714531168961589	0.714531168961589	true	false	false	true
19049fd7-b6a6-4a57-8aa7-80e7b45f82e6	2026-09-21 13:46	2026-09-21 13:46	2026-09-21 13:46	SHOP	SHOP261016C00136000	call	136.0000	2026-10-16	6.8500	5.8500	7.9500	134.0000	92505.00	46075.00	46430.00	135	13	148	0	0	0.523130727749061	0.519571607115542	true	false	false	true
9e6d94ff-201c-4455-85ca-aba771eed29f	2026-09-21 13:45	2026-09-21 13:45	2026-09-21 13:45	SHOP	SHOP260925P00135000	put	135.0000	2026-09-25	4.1500	3.3500	4.1500	134.0000	168075.00	168075.00	0.00	405	5	525	288	1.82291666666667	0.683387009526718	0.683387009526718	false	false	false	true
905c4893-2d0b-42fa-a909-bb5cc7074ef5	2026-09-21 13:45	2026-09-21 13:45	2026-09-21 13:45	SHOP	SHOP260925P00135000	put	135.0000	2026-09-25	4.0500	3.4500	4.0500	134.0000	136080.00	136080.00	0.00	336	9	1163	288	4.03819444444444	0.681827991500437	0.682723341379186	true	false	false	true
ca07a9a2-9775-4fa9-9b14-4875df725257	2026-09-21 13:45	2026-09-21 13:45	2026-09-21 13:45	SHOP	SHOP261016C00145000	call	145.0000	2026-10-16	3.7000	3.7000	4.4500	134.0000	14800.00	0.00	14800.00	40	6	7374	1591	4.63482086737901	0.524610739405877	0.524610739405877	false	false	false	true
f3e88417-8f66-4467-b5ef-3dbcc3d221b6	2026-09-21 13:45	2026-09-21 13:45	2026-09-21 13:45	SHOP	SHOP261016C00145000	call	145.0000	2026-10-16	4.4500	3.7000	4.4500	134.0000	48060.00	48060.00	0.00	108	9	7334	1591	4.60967944688875	0.57389622725862	0.575908761806521	false	false	false	true
6d111eaa-b89a-4ff4-b3bf-e03be8489595	2026-09-21 13:45	2026-09-21 13:44	2026-09-21 13:45	SHOP	SHOP261016C00145000	call	145.0000	2026-10-16	4.4000	3.7000	4.4000	134.0000	25520.00	25520.00	0.00	58	9	5764	1591	3.62287869264613	0.574900271717605	0.574900271717605	false	false	false	true
0612fd35-7f35-43ef-8e52-d7e8a8e0586e	2026-09-21 13:45	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP261016C00145000	call	145.0000	2026-10-16	4.3000	3.4500	4.3500	135.0000	193045.00	192210.00	835.00	449	19	4875	1591	3.06411062225016	0.565373759227013	0.563509587277939	false	false	false	true
3cd3776b-9d0e-4670-9435-287bbd5e1025	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP261218C00135000	call	135.0000	2026-12-18	15.6400	13.9500	15.9500	134.0000	31270.00	26605.00	4665.00	20	6	30	575	0.0521739130434783	0.578859447622622	0.574578727588213	false	false	false	true
4c56657d-5c5c-4d1c-8017-7728e76c17be	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.5000	2.1800	3.0000	134.0000	85500.00	0.00	85500.00	342	5	3169	2633	1.20357007216103	0.537840113366564	0.537840113366564	false	false	false	true
dc2742ac-2c64-4246-88d5-39e5186b7d77	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.4500	2.2200	2.5000	134.0000	100940.00	85750.00	15190.00	412	15	2675	2633	1.01595138625142	0.535114409069971	0.53347075733205	false	false	false	true
5a51ecb1-7837-4079-bc05-1e2306b48812	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.4300	2.2200	2.5000	134.0000	118578.00	39524.00	79054.00	488	7	2207	2633	0.838207368021268	0.532722187557547	0.534128267280053	false	false	false	true
aa481166-e413-41cd-bffb-eabe95f39648	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.3900	2.3900	2.4900	134.0000	47083.00	0.00	47083.00	197	6	1561	2633	0.592859855677934	0.529239598147232	0.529457586863507	false	false	false	true
6d1f8419-af13-43b9-ae5b-6630598ec06e	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP260925C00135000	call	135.0000	2026-09-25	3.1500	2.9800	3.1500	133.0000	15750.00	15750.00	0.00	50	5	3666	728	5.03571428571429	0.667714331591245	0.667714331591245	false	false	false	true
e24a2c96-79a8-4e3c-a363-d88a74ed9fae	2026-09-21 13:42	2026-09-21 13:42	2026-09-21 13:42	SHOP	SHOP260925C00132000	call	132.0000	2026-09-25	3.5000	3.1000	3.5000	132.1399	12950.00	12950.00	0.00	37	14	618	207	2.98550724637681	0.616745795425836	0.616745795425836	false	false	false	true
1d94521c-59c7-47cf-9813-552933c45c95	2026-09-21 13:41	2026-09-21 13:41	2026-09-21 13:41	SHOP	SHOP260925P00142000	put	142.0000	2026-09-25	10.4000	10.2500	10.4000	132.0200	321360.00	321360.00	0.00	309	8	309	21	14.7142857142857	0.592325312763351	0.583171092317919	false	false	false	true
03dba1c4-e5a9-4d6c-8a85-633f41bfebd8	2026-09-21 13:41	2026-09-21 13:41	2026-09-21 13:41	SHOP	SHOP261016C00125000	call	125.0000	2026-10-16	10.3000	10.1500	10.6500	131.4200	163770.00	152440.00	11330.00	159	24	183	972	0.188271604938272	0.495861639649046	0.475921422475087	false	false	false	true
ce4fb483-06ec-4ddf-b17f-2bcf79381ace	2026-09-21 13:41	2026-09-21 13:41	2026-09-21 13:41	SHOP	SHOP261218C00115000	call	115.0000	2026-12-18	24.0500	22.1000	24.3000	131.1300	889845.00	779220.00	108225.00	370	32	370	268	1.38059701492537	0.57812219107595	0.574593324725498	false	false	false	true
47aa38d6-c203-4307-8f44-04012828c16f	2026-09-21 13:41	2026-09-21 13:41	2026-09-21 13:41	SHOP	SHOP261009C00134000	call	134.0000	2026-10-09	4.3500	4.2500	4.7750	131.2000	28275.00	8265.00	20010.00	65	9	90	5	18	0.481969946339263	0.47113456903555	false	false	false	true
6eb1dab2-f438-4536-8293-5df48a74e126	2026-09-21 13:30	2026-09-21 13:30	2026-09-21 13:30	SHOP	SHOP261009C00132000	call	132.0000	2026-10-09	5.0000	4.6500	5.2000	130.8000	14000.00	13500.00	0.00	28	8	89	86	1.03488372093023	0.473273412206688	0.469528950449002	false	false	false	true
4514eecc-e83e-4559-8d0d-c6f7da524209	2026-09-21 13:14	2026-09-21 13:14	2026-09-21 13:14	SHOP	SHOP270917C00165000	call	165.0000	2027-09-17	20.0000	19.5000	20.1000	130.5400	20000.00	2000.00	18000.00	10	10	10	34	0.294117647058824	0.565305971714791	0.565305971714791	false	false	false	true
eabb724b-54e8-494d-b684-bceb5a7709b8	2026-09-21 12:26	2026-09-21 12:26	2026-09-21 12:26	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	4.7000	4.7000	4.8500	130.7800	16450.00	0.00	16450.00	35	17	46210	46336	0.997280732044199	0.465416616696607	0.465416616696607	true	false	false	true
140e3922-4ded-498a-82d6-aacdc312cd81	2026-09-21 12:12	2026-09-21 12:12	2026-09-21 12:12	SHOP	SHOP261120C00140000	call	140.0000	2026-11-20	9.1000	8.4500	9.3000	130.7000	60060.00	50960.00	9100.00	66	13	81	706	0.114730878186969	0.590572359731451	0.590572359731451	false	false	false	true
7897e2bb-a54c-4d40-a811-f0981eb4fb58	2026-09-21 12:09	2026-09-21 12:09	2026-09-21 12:09	SHOP	SHOP260925C00136000	call	136.0000	2026-09-25	1.0100	0.9400	1.0100	130.2200	22624.00	22624.00	0.00	224	11	535	132	4.0530303030303	0.551065117994953	0.549940514064455	false	false	false	true
13c591f5-1c62-4ea5-8f7b-9155c7884af6	2026-09-21 11:51	2026-09-21 11:51	2026-09-21 11:51	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	4.3500	4.1500	4.3500	129.7700	87000.00	87000.00	0.00	200	13	45979	46336	0.992295407458563	0.470831300988549	0.470831300988549	false	false	false	true
8c3d1322-ac10-467d-ad9e-4248640c3d05	2026-09-21 11:36	2026-09-21 11:36	2026-09-21 11:36	SHOP	SHOP260925C00135000	call	135.0000	2026-09-25	1.1000	1.0000	1.1200	129.0000	21324.00	19344.00	1980.00	194	32	1258	728	1.72802197802198	0.544431331266769	0.546722194740488	true	false	false	true
9f2c42b1-0816-4d9f-bd3e-a37f0a6b63a8	2026-09-21 11:00	2026-09-21 11:00	2026-09-21 11:00	SHOP	SHOP261218P00120000	put	120.0000	2026-12-18	9.0000	8.7000	9.0000	129.3895	69290.00	67500.00	1790.00	77	5	85	1227	0.0692746536267319	0.563345328220309	0.561165270251369	false	false	false	true
4728d845-02df-41c6-8394-fd18b3ab2c1d	2026-09-21 10:37	2026-09-21 10:37	2026-09-21 10:37	SHOP	SHOP261120C00130000	call	130.0000	2026-11-20	12.6500	12.6500	12.8500	129.6250	165715.00	0.00	165715.00	131	12	200	1244	0.160771704180064	0.593954795480202	0.593954795480202	false	false	false	true
acfc6c9c-0c56-4845-bc2c-5f993743c8f4	2026-09-21 10:31	2026-09-21 10:31	2026-09-21 10:31	SHOP	SHOP260925C00132000	call	132.0000	2026-09-25	1.9500	1.9500	2.0600	129.6650	10725.00	0.00	10725.00	55	18	208	207	1.0048309178744	0.540094842127905	0.540094842127905	true	false	false	true
4615e62b-34de-42fd-87ae-f16c83c7b23e	2026-09-21 10:31	2026-09-21 10:31	2026-09-21 10:31	SHOP	SHOP260925C00133000	call	133.0000	2026-09-25	1.6400	1.6300	1.7400	129.6650	14556.00	8036.00	6520.00	89	12	126	109	1.15596330275229	0.544799023238106	0.544799023238106	false	false	false	true
0a72f693-cea4-41e5-ab20-8619a2595545	2026-09-21 10:26	2026-09-21 10:26	2026-09-21 10:26	SHOP	SHOP261016C00132000	call	132.0000	2026-10-16	5.6000	4.7000	5.6500	129.8412	15680.00	10080.00	5600.00	28	9	28	0	0	0.473576666091147	0.473576666091147	false	false	false	true
fe922a26-6a91-410c-9f68-a1189f79f840	2026-09-21 10:25	2026-09-21 10:25	2026-09-21 10:25	SHOP	SHOP260925P00128000	put	128.0000	2026-09-25	2.0500	2.0500	2.2000	129.8600	11070.00	0.00	11070.00	54	17	61	159	0.383647798742138	0.540262163444115	0.540262163444115	false	false	false	true
f470e208-f9d6-4f89-9410-8e84fb14d9c9	2026-09-21 10:23	2026-09-21 10:23	2026-09-21 10:23	SHOP	SHOP261120P00125000	put	125.0000	2026-11-20	9.5500	9.2500	9.5500	129.0000	75440.00	75440.00	0.00	79	13	146	745	0.195973154362416	0.594258667687515	0.594258667687515	false	false	false	true
bd030c41-5f84-4b3a-8c26-107d04390176	2026-09-21 10:18	2026-09-21 10:18	2026-09-21 10:18	SHOP	SHOP261120P00125000	put	125.0000	2026-11-20	9.6500	9.5000	10.6500	129.6300	43425.00	4825.00	38600.00	45	12	67	745	0.0899328859060403	0.595444783961331	0.595444783961331	true	false	false	true
75a6290b-3924-45bb-bdbe-c90428681496	2026-09-21 10:15	2026-09-21 10:14	2026-09-21 10:14	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	4.0500	4.0500	4.3000	128.0000	24305.00	0.00	24305.00	60	11	45458	46336	0.981051450276243	0.474268759430721	0.474268759430721	false	false	false	true
44c5e272-4001-44ed-872d-96d996285245	2026-09-21 10:15	2026-09-21 10:14	2026-09-21 10:14	SHOP	SHOP270917C00125000	call	125.0000	2027-09-17	32.8500	32.8000	33.0000	128.0000	22995.00	0.00	22995.00	7	6	130	57	2.28070175438596	0.575348166780863	0.575348166780863	false	false	false	true
484573f4-3abf-44fe-bb99-7c597924bc03	2026-09-21 10:14	2026-09-21 10:14	2026-09-21 10:14	SHOP	SHOP270917C00125000	call	125.0000	2027-09-17	32.9000	32.9000	33.0500	129.0400	26320.00	0.00	26320.00	8	8	118	57	2.07017543859649	0.574438780605656	0.574438780605656	false	false	false	true
b05bec13-312b-4c0a-bfe6-05391ceb8a0b	2026-09-21 10:11	2026-09-21 10:11	2026-09-21 10:11	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	1.1000	1.0000	1.1000	129.0000	34100.00	34100.00	0.00	310	26	459	2633	0.174325864033422	0.489421941231613	0.489421941231613	false	false	false	true
b4171801-81da-4c8f-b261-a0fad6ff8a67	2026-09-21 10:11	2026-09-21 10:11	2026-09-21 10:11	SHOP	SHOP270917C00125000	call	125.0000	2027-09-17	32.9000	32.8500	32.9500	129.0000	19741.00	0.00	16451.00	6	6	64	57	1.12280701754386	0.573874195327518	0.573874195327518	false	false	false	true
40a2d838-17af-4a94-ba35-437e960b4ba6	2026-09-21 10:01	2026-09-21 10:01	2026-09-21 10:01	SHOP	SHOP260925C00138000	call	138.0000	2026-09-25	0.5600	0.4400	0.5700	129.2312	16632.00	12376.00	4256.00	297	22	613	180	3.40555555555556	0.571890520748347	0.571885821312414	true	false	false	true
c2389948-49b3-40b0-83cd-8db08fe6b02a	2026-09-18 14:51	2026-09-18 14:51	2026-09-18 14:51	SHOP	SHOP261016C00130000	call	130.0000	2026-10-16	5.5000	5.4500	5.7500	128.0000	104570.00	8320.00	92400.00	190	33	1060	1228	0.863192182410424	0.440813555219533	0.440813555219533	true	false	false	true
82215e1e-75f6-4279-bee7-8f9412a7b270	2026-09-18 14:51	2026-09-18 14:51	2026-09-18 14:51	SHOP	SHOP261016C00130000	call	130.0000	2026-10-16	5.5000	5.4000	5.6250	128.0000	55000.00	7700.00	16500.00	100	8	870	1228	0.708469055374593	0.440813555219533	0.440813555219533	false	false	false	true
5b0bce6d-d350-4dd3-ae0e-c9c5cd7fd016	2026-09-18 14:51	2026-09-18 14:50	2026-09-18 14:50	SHOP	SHOP261016C00130000	call	130.0000	2026-10-16	5.5000	5.4000	5.5000	127.9950	55000.00	16500.00	0.00	100	6	370	1228	0.301302931596091	0.440984666037984	0.440984666037984	false	false	false	true
3dfe6408-8266-4cc9-871f-8a1444c8597d	2026-09-18 14:51	2026-09-18 14:50	2026-09-18 14:50	SHOP	SHOP261016C00130000	call	130.0000	2026-10-16	5.5000	5.5000	5.7500	128.0300	220040.00	0.00	220040.00	400	30	770	1228	0.627035830618892	0.439786307195546	0.439786307195546	true	false	false	true
ca12d20d-24e1-4982-8242-0841bd583224	2026-09-18 13:45	2026-09-18 13:45	2026-09-18 13:45	SHOP	SHOP260925C00130000	call	130.0000	2026-09-25	2.0000	2.0000	2.0400	127.3200	54400.00	0.00	36000.00	272	58	1243	209	5.94736842105263	0.439502668411542	0.439502668411542	true	false	false	true
41f64cdc-64e1-4c41-b954-56cc8c079337	2026-09-18 10:51	2026-09-18 10:50	2026-09-18 10:50	SHOP	SHOP260918C00115000	call	115.0000	2026-09-18	12.6000	11.4000	12.6000	127.5900	661500.00	661500.00	0.00	525	22	526	1508	0.348806366047745	1.65394670186259	1.65394670186259	true	false	false	true
d5200c8e-97b8-4145-8de9-9a23d8e7f5a8	2026-09-17 15:27	2026-09-17 15:27	2026-09-17 15:27	SHOP	SHOP270416P00115000	put	115.0000	2027-04-16	12.9000	12.7500	13.0500	128.1700	190920.00	179310.00	11610.00	148	6	174	287	0.606271777003484	0.551533564945505	0.551533564945505	false	false	false	true
1ea8ec82-d1b3-4b17-bc15-598bc98b815f	2026-09-17 14:30	2026-09-17 14:30	2026-09-17 14:30	SHOP	SHOP261016P00120000	put	120.0000	2026-10-16	3.0500	2.9300	3.1000	128.3137	112545.00	103090.00	9150.00	369	28	606	5977	0.101388656516647	0.466278861363074	0.466135467491073	true	false	false	true