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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×ticker = SHOP×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

cfccf1e9-9b49-48fd-9a80-f55699b1005b	2026-08-18 13:32	2026-08-18 13:32	2026-08-18 13:32	SHOP	SHOP260918C00150000	call	150.0000	2026-09-18	6.3600	6.1500	6.5000	146.8200	63576.00	63576.00	0.00	100	5	145	7427	0.0195233607109196	0.442743284798485	0.442743284798485	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Technology	161815483760.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
881c26d0-dcf4-47f0-b0dd-e0d117256f18	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	SHOP	SHOP270917P00145000	put	145.0000	2027-09-17	28.3200	28.3000	30.0500	148.5550	116105.00	11375.00	104730.00	41	12	41	57	0.719298245614035	0.5634576118136	0.565225242884105	false	false	false	true
ee2fede7-a7db-4e6e-85fc-95687cb1e666	2026-08-20 14:22	2026-08-20 14:22	2026-08-20 14:22	SHOP	SHOP281215P00125000	put	125.0000	2028-12-15	30.2000	30.2000	30.9500	146.4000	335245.00	3025.00	329195.00	111	33	111	38	2.92105263157895	0.589128155651034	0.589863161192261	true	false	false	true
3a306f7b-f15c-4366-999c-24e782d1bb77	2026-08-21 10:25	2026-08-21 10:25	2026-08-21 10:25	SHOP	SHOP260918C00150000	call	150.0000	2026-09-18	6.2100	5.9500	6.6000	147.6300	306310.00	42775.00	262910.00	493	62	518	7195	0.0719944405837387	0.434209868407143	0.434209868407143	true	false	false
9093e58a-23e9-44c7-950b-bd6ee0556d28	2026-08-25 10:02	2026-08-25 10:02	2026-08-25 10:02	SHOP	SHOP260904P00150000	put	150.0000	2026-09-04	3.1900	3.1500	3.6000	153.4000	68895.00	28260.00	40635.00	216	10	1317	62	21.241935483871	0.4711798574358	0.48162826529481	false	false	false	true
13f4b573-7f8f-41c5-96df-5483998dcea5	2026-08-26 10:11	2026-08-26 10:11	2026-08-26 10:11	SHOP	SHOP260918C00160000	call	160.0000	2026-09-18	3.9500	3.7000	4.0500	152.2550	67119.00	66724.00	395.00	170	5	449	82256	0.00545856837191208	0.449565959489319	0.450266140640454	false	false	false
78991de2-94e7-4c54-9383-e9a18899bafb	2026-08-28 14:50	2026-08-28 14:50	2026-08-28 14:50	SHOP	SHOP270617P00150000	put	150.0000	2027-06-17	24.8300	24.8000	25.4500	153.0400	71995.00	0.00	71995.00	29	14	30	1219	0.0246103363412633	0.540846291281589	0.545707279083218	true	false	false	true
d64fc5dd-337c-45b9-9a2b-8b90ef618515	2026-08-31 10:26	2026-08-31 10:26	2026-08-31 10:26	SHOP	SHOP270917C00200000	call	200.0000	2027-09-17	18.0100	18.0000	18.7000	145.8300	59440.00	1835.00	57605.00	33	10	33	98	0.336734693877551	0.542416141107112	0.548440320807979	false	false	false
a2ad44d7-caf1-408a-ac3a-46a60ee2f66d	2026-08-31 10:26	2026-08-31 10:26	2026-08-31 10:26	SHOP	SHOP270917C00210000	call	210.0000	2027-09-17	16.0300	15.9000	16.2500	145.7705	72140.00	36945.00	35195.00	45	10	49	106	0.462264150943396	0.542407404759526	0.543289721776726	false	false	false
04f00c1b-aa6b-4c80-92cb-9dec5b84adcf	2026-08-31 10:26	2026-08-31 10:26	2026-08-31 10:26	SHOP	SHOP270917C00200000	call	200.0000	2027-09-17	17.9900	17.9500	18.3000	145.9200	88145.00	34295.00	53850.00	49	5	212	98	2.16326530612245	0.540917399455911	0.54263909441951	false	false	false	true
2a13fc65-7251-4ee2-859c-11fa68988b80	2026-08-31 12:19	2026-08-31 12:19	2026-08-31 12:19	SHOP	SHOP280121P00165000	put	165.0000	2028-01-21	43.5600	43.3000	44.0500	146.8400	69695.00	4365.00	65330.00	16	8	46	117	0.393162393162393	0.545076679716453	0.546558670019266	false	false	false	true
cbce84ee-46c9-452d-8233-8f12e8cb333a	2026-09-01 09:39	2026-09-01 09:39	2026-09-01 09:39	SHOP	SHOP270319C00185000	call	185.0000	2027-03-19	10.3800	10.3500	11.7500	142.6900	69530.00	6360.00	63170.00	67	15	67	751	0.0892143808255659	0.532113750163502	0.533410024166604	false	false	false
af9fe06a-a93a-49c8-a71d-443a39a61436	2026-09-01 13:08	2026-09-01 13:08	2026-09-01 13:08	SHOP	SHOP271217C00185000	call	185.0000	2027-12-17	23.8600	23.7500	24.7000	141.0100	64420.00	19155.00	45265.00	27	6	50	55	0.909090909090909	0.553117503407525	0.554682101366166	false	false	false
f5ed1378-f55b-44b7-8041-c3d2bbfb06a9	2026-09-01 14:34	2026-09-01 14:34	2026-09-01 14:34	SHOP	SHOP260918P00140000	put	140.0000	2026-09-18	5.0200	4.9500	5.0500	139.8600	76335.00	60835.00	14000.00	152	19	520	1630	0.319018404907975	0.420125307251485	0.420125307251485	false	false	false
d7e72f57-e86f-4750-b6a6-b5f671e9292a	2026-09-01 14:38	2026-09-01 14:38	2026-09-01 14:38	SHOP	SHOP261120C00145000	call	145.0000	2026-11-20	12.4600	12.3000	12.5500	139.9500	300166.00	300166.00	0.00	241	12	293	1639	0.178767541183649	0.539507362439364	0.541803298605636	false	false	false
2933459f-76b1-4f04-9a6e-b8073f337018	2026-09-01 14:38	2026-09-01 14:38	2026-09-01 14:38	SHOP	SHOP261120P00135000	put	135.0000	2026-11-20	10.9400	10.8000	11.0500	139.9500	223160.00	101840.00	121320.00	204	12	289	276	1.04710144927536	0.539927864533188	0.540728891123996	false	false	false
763cc38e-e3c7-4d50-8bf6-d66f1d363f63	2026-09-03 12:57	2026-09-03 12:57	2026-09-03 12:57	SHOP	SHOP260911P00144000	put	144.0000	2026-09-11	3.9500	3.9500	4.5000	143.3000	433030.00	2860.00	25690.00	1096	21	1518	31	48.9677419354839	0.432039913148498	0.448560177186012	false	false	false	true
64041904-5424-4ada-9e92-c7a2c5b91b5b	2026-09-08 10:01	2026-09-08 10:01	2026-09-08 10:01	SHOP	SHOP281215P00100000	put	100.0000	2028-12-15	19.3500	19.3500	19.9500	136.3300	112232.00	0.00	112232.00	58	13	79	2396	0.0329716193656093	0.567671696708194	0.567671696708194	false	false	false
935e275b-ae26-4e86-ac28-c1f1df352bb9	2026-09-09 10:02	2026-09-09 10:02	2026-09-09 10:02	SHOP	SHOP260918C00139000	call	139.0000	2026-09-18	1.8300	1.5500	2.0400	131.1700	54804.00	54804.00	0.00	300	6	304	42	7.23809523809524	0.55603511812208	0.55603511812208	false	false	false	true
3a880530-76ef-42fb-99eb-87e31b35cfaf	2026-09-10 14:04	2026-09-10 14:04	2026-09-10 14:04	SHOP	SHOP280121P00095000	put	95.0000	2028-01-21	13.5600	13.2000	13.6000	126.3900	108466.00	108466.00	0.00	80	11	96	3466	0.0276976341604155	0.578369846806127	0.578369846806127	false	false	false	true
d15df030-3c0d-4fb7-8edd-1a785c27c0a2	2026-09-10 15:43	2026-09-10 15:43	2026-09-10 15:43	SHOP	SHOP261030P00125000	put	125.0000	2026-10-30	9.0500	8.2000	9.3500	125.9800	51565.00	32660.00	18905.00	57	7	69	0	0	0.531361000529687	0.534086005235188	false	false	false	true
c427d535-10b8-4eda-9ade-0259e7e81aa7	2026-09-14 11:59	2026-09-14 11:59	2026-09-14 11:59	SHOP	SHOP261002C00150000	call	150.0000	2026-10-02	1.2000	1.0600	1.2200	133.1400	59918.00	59918.00	0.00	500	6	738	160	4.6125	0.501427078858609	0.501427078858609	false	false	false	true
299b8978-e9d7-4737-9ab6-01449bcdfc15	2026-09-17 09:40	2026-09-17 09:40	2026-09-17 09:40	SHOP	SHOP261218C00120000	call	120.0000	2026-12-18	19.9400	19.8000	21.7500	129.2238	69800.00	0.00	59825.00	35	6	35	342	0.10233918128655	0.567260433984205	0.569388302313167	false	false	false	true
7e01f092-4e98-4d3f-b9db-f8c9b060925d	2026-09-17 12:46	2026-09-17 12:46	2026-09-17 12:46	SHOP	SHOP261120C00130000	call	130.0000	2026-11-20	12.0500	12.0000	12.5000	128.1001	798946.00	6045.00	789286.00	663	60	708	781	0.906530089628681	0.581499093820741	0.584520807108566	false	false	false
0492f7a4-e0ee-4f94-aa4c-410a932fcebc	2026-09-17 13:47	2026-09-17 13:46	2026-09-17 13:46	SHOP	SHOP270115P00120000	put	120.0000	2027-01-15	10.7500	10.7500	11.0500	128.3500	126865.00	3240.00	123625.00	118	24	122	3126	0.0390275111964171	0.540087760190467	0.54244709325376	false	false	false
b12712a6-f10d-4012-b809-bd39f6e39be3	2026-09-18 15:48	2026-09-18 15:48	2026-09-18 15:48	SHOP	SHOP261120P00130000	put	130.0000	2026-11-20	12.6000	12.4500	12.8000	128.1400	113420.00	0.00	113420.00	90	7	179	986	0.181541582150101	0.570143824390065	0.570616486397938	false	false	false	true
6fd1e412-f3cc-48d6-8cd7-6935bbeb2d44	2026-09-21 10:01	2026-09-21 10:01	2026-09-21 10:01	SHOP	SHOP260925C00138000	call	138.0000	2026-09-25	0.5500	0.4100	0.5700	129.2311	11327.00	7428.00	3899.00	206	36	316	180	1.75555555555556	0.562562922202325	0.571890520748347	true	false	false	true
2b939231-2630-404f-bbfe-8e3e29e744f6	2026-09-21 10:03	2026-09-21 10:03	2026-09-21 10:03	SHOP	SHOP260925P00125000	put	125.0000	2026-09-25	1.2100	1.2000	1.5200	129.1200	36374.00	0.00	36374.00	300	32	362	470	0.770212765957447	0.524731486737068	0.533739935787221	false	false	false	true
07ff5344-2bb1-44f9-ad3e-18387a137a9a	2026-09-21 10:58	2026-09-21 10:57	2026-09-21 10:57	SHOP	SHOP261120C00130000	call	130.0000	2026-11-20	12.7000	12.4000	12.9000	129.8350	15243.00	0.00	12713.00	12	5	221	1244	0.177652733118971	0.588342371105426	0.592671736938532	false	false	false
72dab2e6-558e-48c7-9fd1-9d27877e4f4b	2026-09-21 11:04	2026-09-21 11:04	2026-09-21 11:04	SHOP	SHOP270115C00150000	call	150.0000	2027-01-15	8.9700	8.9500	9.1000	129.4300	17050.00	5400.00	8950.00	19	10	28	2196	0.0127504553734062	0.535153442307034	0.536946139505964	false	false	false
a8454f38-22c0-42f6-803e-9fee3f0df259	2026-09-21 11:04	2026-09-21 11:04	2026-09-21 11:04	SHOP	SHOP270115C00150000	call	150.0000	2027-01-15	8.9900	8.9500	9.1000	129.4300	18875.00	7210.00	7165.00	21	17	49	2196	0.0223132969034608	0.535153442307034	0.538737801127751	false	false	false
7f541054-0a88-417d-98e7-b33b5b443b3b	2026-09-21 12:26	2026-09-21 12:26	2026-09-21 12:26	SHOP	SHOP261016C00145000	call	145.0000	2026-10-16	2.0100	2.0000	2.1600	130.8450	48911.00	0.00	48911.00	243	39	867	1591	0.544940289126336	0.470855900237366	0.472373986467423	false	false	false	true
ae7c0b5c-ddae-490e-8ab8-1434efb40002	2026-09-21 13:41	2026-09-21 13:41	2026-09-21 13:41	SHOP	SHOP261016P00141000	put	141.0000	2026-10-16	12.3200	12.1000	12.4000	131.0600	336360.00	159960.00	176400.00	273	7	273	0	0	0.449017140923828	0.461639614569463	false	false	false	true
633a98eb-8e54-44fd-850c-922c5d916e8b	2026-09-21 13:41	2026-09-21 13:41	2026-09-21 13:41	SHOP	SHOP261120P00145000	put	145.0000	2026-11-20	20.3400	20.3000	20.4500	131.0600	339670.00	89980.00	249690.00	167	12	167	570	0.292982456140351	0.576392166539125	0.583758296350747	true	false	false
8ff940b0-099b-43eb-a04f-53a2530005fc	2026-09-21 13:41	2026-09-21 13:41	2026-09-21 13:41	SHOP	SHOP261016C00155000	call	155.0000	2026-10-16	0.9700	0.7000	1.0000	131.7900	23128.00	23128.00	0.00	239	13	543	6329	0.0857955443197978	0.4904699190188	0.4904699190188	false	false	false	true
85036ee7-65e6-46b8-ab26-bc3d2c9ea432	2026-09-21 13:41	2026-09-21 13:41	2026-09-21 13:41	SHOP	SHOP261016C00155000	call	155.0000	2026-10-16	0.9500	0.7000	1.0000	131.6700	24878.00	24878.00	0.00	261	5	304	6329	0.0480328645915626	0.491091219864546	0.491091219864546	false	false	false	true
4291da1f-726f-4b45-973d-afb231a420a7	2026-09-21 13:41	2026-09-21 13:41	2026-09-21 13:41	SHOP	SHOP260925C00137000	call	137.0000	2026-09-25	1.4500	1.3600	1.4700	132.0100	13043.00	12901.00	142.00	90	14	269	174	1.54597701149425	0.591105261686199	0.591105261686199	false	false	false	true
893538cf-e496-4508-aa89-8ad33845ebfb	2026-09-21 13:42	2026-09-21 13:41	2026-09-21 13:41	SHOP	SHOP260925C00136000	call	136.0000	2026-09-25	1.7400	1.7100	1.9300	132.0805	16880.00	5114.00	11766.00	97	25	1107	132	8.38636363636364	0.590241105892448	0.597170997024438	true	false	false	true
dfe3360e-6522-41b2-9493-88b7a7f501fb	2026-09-21 13:42	2026-09-21 13:42	2026-09-21 13:42	SHOP	SHOP260925C00140000	call	140.0000	2026-09-25	1.2900	1.2200	1.5000	132.8900	15984.00	0.00	15984.00	124	5	1167	1924	0.606548856548857	0.659024900925365	0.692219767556872	false	false	false	true
2d381593-cf83-46ac-8cc2-15022030320b	2026-09-21 13:44	2026-09-21 13:44	2026-09-21 13:44	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.4100	2.4000	2.4900	134.0000	37876.00	0.00	37876.00	157	5	1718	2633	0.652487656665401	0.531039112639659	0.531798529544902	false	false	false	true
b8adb483-8c89-4a50-8a8e-dcaeb551a390	2026-09-21 13:46	2026-09-21 13:46	2026-09-21 13:46	SHOP	SHOP261016C00137000	call	137.0000	2026-10-16	6.3900	5.4000	7.7500	134.0000	104120.00	51900.00	52220.00	163	7	163	0	0	0.518710728098312	0.521971006877399	true	false	false	true
65d8854d-80d9-4b25-bfe7-82d369a7a93f	2026-09-21 13:46	2026-09-21 13:46	2026-09-21 13:46	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	7.2600	6.9000	7.5500	134.3700	17425.00	7985.00	9440.00	24	6	46805	46336	1.01012171961326	0.520205031429827	0.526010236836086	true	false	false
25038aed-db7f-4808-bdfe-49d287411866	2026-09-21 13:46	2026-09-21 13:46	2026-09-21 13:46	SHOP	SHOP260925C00140000	call	140.0000	2026-09-25	2.0100	1.8200	2.0400	134.2500	125138.00	94420.00	26880.00	624	48	3477	1924	1.80717255717256	0.712249890941043	0.732998250864437	true	false	false
179a2fb3-df86-4691-a6f7-6021b7ed19f2	2026-09-21 13:47	2026-09-21 13:47	2026-09-21 13:47	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.6300	2.6300	2.8000	134.4900	19995.00	1057.00	18938.00	76	18	6827	2633	2.59285985567793	0.541648221295933	0.542545140586248	false	false	false
e6d809b4-bbfb-4469-bed3-3513e52e1467	2026-09-21 13:50	2026-09-21 13:50	2026-09-21 13:50	SHOP	SHOP261002C00146000	call	146.0000	2026-10-02	2.2900	2.0500	2.6900	135.7200	13307.00	7379.00	5928.00	58	12	67	43	1.55813953488372	0.619222270239667	0.620743274123788	true	false	false	true
7d6cdf6a-2856-469a-9c99-64d4b4dd4c9f	2026-09-21 13:50	2026-09-21 13:50	2026-09-21 13:50	SHOP	SHOP261016C00155000	call	155.0000	2026-10-16	2.0700	2.0700	2.1000	134.9100	88978.00	0.00	88978.00	429	15	1368	6329	0.216147890662032	0.565807637949024	0.566821466542303	true	false	false	true
4fdc5add-7e1d-41c3-a98f-cc820de9ea90	2026-09-21 13:51	2026-09-21 13:50	2026-09-21 13:50	SHOP	SHOP261016C00155000	call	155.0000	2026-10-16	2.0900	2.0000	2.1000	134.9600	36196.00	22260.00	13936.00	173	6	1541	6329	0.243482382682888	0.566821466542303	0.567831860249475	true	false	false
c5850d6f-e615-42de-a4f6-124de71b501d	2026-09-21 13:51	2026-09-21 13:50	2026-09-21 13:50	SHOP	SHOP261016C00155000	call	155.0000	2026-10-16	2.2200	2.1100	2.2400	135.1600	124104.00	82426.00	41678.00	559	11	3039	6329	0.480170643071575	0.576205708003907	0.576726614266226	false	false	false
bf519960-6f27-4e9c-896e-6cad4b9f0d31	2026-09-21 13:51	2026-09-21 13:51	2026-09-21 13:51	SHOP	SHOP261218C00150000	call	150.0000	2026-12-18	10.3600	9.8000	10.5500	135.1650	77715.00	75635.00	2080.00	75	5	220	1996	0.110220440881764	0.58380114260571	0.58380114260571	true	false	false	true
6070e8af-c3d8-48a9-ab28-d953e4d9221f	2026-09-21 13:51	2026-09-21 13:51	2026-09-21 13:51	SHOP	SHOP261218C00150000	call	150.0000	2026-12-18	10.3600	9.8000	10.4000	135.1700	39375.00	38345.00	1030.00	38	9	145	1996	0.0726452905811623	0.581797939319138	0.581797939319138	false	false	false