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

c0be89f9-44b2-4cd9-823b-a8bdd6e0f60c	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP260925C00130000	call	130.0000	2026-09-25	18.2500	17.6500	18.2500	148.1300	127750.00	127750.00	0.00	70	16	525	1830	0.286885245901639	0.722759396237665	0.722759396237665	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	178554183066.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T13:33:30.058722Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
92de4c4f-676f-453f-be32-998e652014d2	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP260925C00130000	call	130.0000	2026-09-25	18.2500	17.7000	18.7000	148.1800	49275.00	49275.00	0.00	27	5	552	1830	0.301639344262295	0.625631745261369	0.625631745261369	false	false	false	true
b05667d7-09a8-4e1f-a61f-916a0668e57a	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP260925C00130000	call	130.0000	2026-09-25	18.2500	17.8000	18.2500	148.0100	257325.00	257325.00	0.00	141	27	419	1830	0.22896174863388	0.838949948296151	0.847098344520982	false	false	false	true
2cb4fdce-6537-4b30-846b-4e8f66f3f9fa	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP260925C00130000	call	130.0000	2026-09-25	18.2000	17.8000	18.2000	147.9500	25480.00	25480.00	0.00	14	6	252	1830	0.137704918032787	0.893108360572204	0.853249589884827	false	false	false	true
4fed5b4b-fedf-49d4-8607-779b844740c1	2026-09-22 09:32	2026-09-22 09:31	2026-09-22 09:31	SHOP	SHOP261218C00145000	call	145.0000	2026-12-18	19.4000	18.4500	19.9000	147.9300	42670.00	21340.00	21330.00	22	8	62	43646	0.00142051963524722	0.604593975362369	0.605665410408332	true	false	false	true
e1c0caa9-2461-4ae6-95a9-d432154e442f	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SHOP	SHOP260925C00155000	call	155.0000	2026-09-25	1.8000	1.6600	1.8000	147.1800	24300.00	24300.00	0.00	135	20	183	572	0.31993006993007	0.858390428189343	0.860218053789425	true	false	false	true
a79bb70e-4a76-44c7-91e5-6bd0dd6cf5b0	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	SHOP	SHOP260925C00143000	call	143.0000	2026-09-25	5.9500	5.6500	6.4000	146.5000	147560.00	88060.00	59500.00	248	5	278	1625	0.171076923076923	0.749905744609401	0.749905744609401	false	false	false	true
ac60d634-9fd3-461a-b13e-a83aed9fd463	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	SHOP	SHOP261002C00150000	call	150.0000	2026-10-02	4.6800	3.2000	5.3500	146.4000	51460.00	26075.00	25385.00	110	5	128	975	0.131282051282051	0.636066404627409	0.646553318903282	true	false	false	true
a62041e9-25de-4184-8a89-6a3be8c0b3a2	2026-09-21 15:58	2026-09-21 15:58	2026-09-21 15:58	SHOP	SHOP261120C00125000	call	125.0000	2026-11-20	21.0000	21.0000	21.4500	137.7450	10500.00	0.00	4200.00	5	5	104	1083	0.0960295475530933	0.620781085887324	0.620781085887324	false	false	false	true
21ab5d51-64d8-4fb6-96a9-13366d02234c	2026-09-21 15:56	2026-09-21 15:56	2026-09-21 15:56	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	9.0000	8.3000	9.0500	137.7300	90000.00	90000.00	0.00	100	8	48545	46336	1.04767351519337	0.517217358738155	0.517217358738155	false	false	false	true
ddfc1cbf-c138-4603-bdef-aa5ee4a8d0b1	2026-09-21 15:47	2026-09-21 15:47	2026-09-21 15:47	SHOP	SHOP260925C00144000	call	144.0000	2026-09-25	1.2500	1.1200	1.2500	137.0000	90875.00	90875.00	0.00	727	37	894	134	6.67164179104478	0.627027064423502	0.627027064423502	false	false	false	true
c6c59430-a95f-4ed8-be34-fc3162e7ee9c	2026-09-21 15:41	2026-09-21 15:41	2026-09-21 15:41	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	3.1500	3.1000	3.2500	137.1000	437850.00	243180.00	194670.00	1390	9	15048	2633	5.71515381693885	0.524276934130202	0.52650588187823	false	false	false	true
b5831c45-391d-4ec5-8321-1758ebb6c8d3	2026-09-21 15:26	2026-09-21 15:25	2026-09-21 15:25	SHOP	SHOP261120C00180000	call	180.0000	2026-11-20	2.8200	2.8200	3.1500	136.5200	30738.00	0.00	30738.00	109	5	181	589	0.307300509337861	0.619512203236009	0.619512203236009	true	false	false	true
f59022a4-7009-413e-8f80-0d25c6549898	2026-09-21 15:24	2026-09-21 15:24	2026-09-21 15:24	SHOP	SHOP261016C00145000	call	145.0000	2026-10-16	4.4500	4.4500	4.6000	137.0900	12019.00	0.00	12019.00	27	17	8302	1591	5.21810182275299	0.519104251736877	0.519104251736877	true	false	false	true
f144ed01-f521-48ca-aa2d-25d34b0c053a	2026-09-21 15:19	2026-09-21 15:19	2026-09-21 15:19	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	8.8000	8.4500	8.8000	137.5500	14080.00	14080.00	0.00	16	16	48262	46336	1.04156595303867	0.511796053523765	0.510532532505922	false	false	false	true
fbe85578-8fec-4a01-9155-2df6361aa4be	2026-09-21 15:19	2026-09-21 15:19	2026-09-21 15:19	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	8.8000	8.4500	8.8000	137.5300	10560.00	10560.00	0.00	12	12	48246	46336	1.04122064917127	0.511375080363515	0.511375080363515	false	false	false	true
34116a05-b367-488e-8ab3-62e3a9dcafd7	2026-09-21 15:10	2026-09-21 15:10	2026-09-21 15:10	SHOP	SHOP261016C00140000	call	140.0000	2026-10-16	6.1500	6.1000	6.2500	136.8550	34440.00	615.00	33825.00	56	7	1625	1314	1.23668188736682	0.516649471289917	0.516649471289917	false	false	false	true
36f603fa-d21c-409b-9adb-8fdf0c9c6f39	2026-09-21 15:07	2026-09-21 15:07	2026-09-21 15:07	SHOP	SHOP261002C00145000	call	145.0000	2026-10-02	2.4000	2.3500	2.5000	136.9150	20400.00	14400.00	6000.00	85	5	260	452	0.575221238938053	0.560994942966662	0.560994942966662	false	false	false	true
43b14224-2b25-4db1-b758-73195cb0f0e0	2026-09-21 15:06	2026-09-21 15:06	2026-09-21 15:06	SHOP	SHOP261218C00125000	call	125.0000	2026-12-18	22.3000	20.0500	22.7000	136.7400	35680.00	35680.00	0.00	16	5	67	489	0.137014314928425	0.589431267542598	0.587261405655178	true	false	false	true
820858a0-ac7a-4828-9818-ceb402b14e02	2026-09-21 15:04	2026-09-21 15:04	2026-09-21 15:04	SHOP	SHOP261218P00140000	put	140.0000	2026-12-18	16.5500	16.3000	16.6000	136.0000	148950.00	148950.00	0.00	90	19	94	1151	0.0816681146828844	0.579451266274775	0.579103924627925	false	false	false	true
7c8db5a4-af78-45a7-bef2-1121c6d17581	2026-09-21 15:04	2026-09-21 15:04	2026-09-21 15:04	SHOP	SHOP261023C00155000	call	155.0000	2026-10-23	2.7500	2.2900	2.8700	136.0000	10995.00	5724.00	5271.00	40	7	102	29	3.51724137931034	0.520034947083895	0.524821341780776	true	false	false	true
13aaeb9d-76c4-4378-84f6-032bcec1d6b8	2026-09-21 15:03	2026-09-21 15:03	2026-09-21 15:03	SHOP	SHOP261120C00160000	call	160.0000	2026-11-20	6.0000	5.6000	6.0000	136.0000	18600.00	18600.00	0.00	31	5	257	1372	0.18731778425656	0.6135738727402	0.6135738727402	false	false	false	true
47cb6f56-cbbb-4bac-a44e-d89f8decdebe	2026-09-21 14:53	2026-09-21 14:53	2026-09-21 14:53	SHOP	SHOP261016C00155000	call	155.0000	2026-10-16	2.0000	1.9900	2.0200	135.7100	54914.00	2010.00	52904.00	274	7	4604	6329	0.727445094011692	0.543628111536712	0.543628111536712	false	false	false	true
9d718337-2746-47b2-b9ef-41a5e4486e02	2026-09-21 14:46	2026-09-21 14:46	2026-09-21 14:46	SHOP	SHOP261218P00130000	put	130.0000	2026-12-18	12.1000	11.6500	12.4000	134.0000	52030.00	18150.00	33880.00	43	7	179	728	0.245879120879121	0.580059852113669	0.580059852113669	false	false	false	true
86b489a6-0d83-494c-a531-7b2681c9a013	2026-09-21 14:43	2026-09-21 14:42	2026-09-21 14:42	SHOP	SHOP261016C00160000	call	160.0000	2026-10-16	1.3100	1.1700	1.5400	135.3400	16234.00	1820.00	14414.00	124	13	460	2327	0.197679415556511	0.546538265123939	0.550323788176444	false	false	false	true
a5b2455f-89d7-41bb-9186-3a8e79a03c21	2026-09-21 14:33	2026-09-21 14:33	2026-09-21 14:33	SHOP	SHOP261002C00140000	call	140.0000	2026-10-02	3.3000	3.3000	3.5000	135.1900	106590.00	0.00	106590.00	323	13	1086	210	5.17142857142857	0.545761424589414	0.556889517845469	false	false	false	true
baa771c4-5fd4-4bcf-a5f0-7e79256e54e5	2026-09-21 14:29	2026-09-21 14:29	2026-09-21 14:29	SHOP	SHOP261218P00155000	put	155.0000	2026-12-18	26.9500	26.2000	27.0000	135.0000	13475.00	10780.00	2695.00	5	5	8	209	0.0382775119617225	0.583811346297895	0.583811346297895	false	false	false	true
39965973-2b2c-49c1-aec5-14f6d773153f	2026-09-21 14:14	2026-09-21 14:14	2026-09-21 14:14	SHOP	SHOP261016C00155000	call	155.0000	2026-10-16	2.1500	1.9300	2.1500	135.2500	100190.00	100190.00	0.00	466	39	4216	6329	0.666139990519829	0.56695564897618	0.56695564897618	false	false	false	true
f93eb6e1-3b6e-44d7-9b49-c67518aa8ce2	2026-09-21 14:12	2026-09-21 14:12	2026-09-21 14:12	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	8.1500	7.7000	8.1500	135.7975	13040.00	13040.00	0.00	16	5	47947	46336	1.03476778314917	0.535496681022485	0.535496681022485	true	false	false	true
e96c471f-a48e-4ae8-bb7d-9e173a473f1a	2026-09-21 14:12	2026-09-21 14:11	2026-09-21 14:11	SHOP	SHOP261016C00140000	call	140.0000	2026-10-16	5.9000	5.5000	5.9000	135.6300	24780.00	24780.00	0.00	42	7	1353	1314	1.0296803652968	0.538556462041166	0.538556462041166	false	false	false	true
63bb2548-5085-429b-b37c-12313ba5307c	2026-09-21 14:10	2026-09-21 14:09	2026-09-21 14:09	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	7.2500	7.1000	7.3500	134.3350	10875.00	10875.00	0.00	15	6	47851	46336	1.03269595994475	0.527313161488903	0.527313161488903	false	false	false	true
2b1a922a-9921-4914-a0f0-8db079d33927	2026-09-21 14:09	2026-09-21 14:09	2026-09-21 14:09	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.4500	2.4500	2.5500	133.0000	11515.00	0.00	11515.00	47	9	8025	2633	3.04785415875427	0.535333531771889	0.536319495079213	true	false	false	true
1e4a53ae-79c1-4b9b-a5d8-f8e1c139410e	2026-09-21 14:09	2026-09-21 14:09	2026-09-21 14:09	SHOP	SHOP261218C00145000	call	145.0000	2026-12-18	11.4500	11.3000	11.5500	134.0000	29770.00	12595.00	17175.00	26	5	43608	340	128.258823529412	0.580576864317014	0.580576864317014	false	false	false	true
02122bec-9fa9-4664-b9d1-c6a46dbfbb50	2026-09-21 14:06	2026-09-21 14:06	2026-09-21 14:06	SHOP	SHOP261016C00137000	call	137.0000	2026-10-16	6.5000	5.8500	7.1000	134.0000	24700.00	24700.00	0.00	38	6	213	0	0	0.525601345449304	0.525601345449304	true	false	false	true
7b78b9b3-97c9-4d79-9100-6ddc0ea26329	2026-09-21 14:01	2026-09-21 14:01	2026-09-21 14:01	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	6.9000	6.6500	7.2000	133.0000	36570.00	690.00	35880.00	53	5	47743	46336	1.03036515883978	0.518891201108073	0.518891201108073	true	false	false	true
73793c89-9e23-4335-9ff4-7509ccb03dfa	2026-09-21 14:01	2026-09-21 14:01	2026-09-21 14:01	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	6.9500	6.9000	7.2000	134.0000	31280.00	700.00	6950.00	45	8	47640	46336	1.02814226519337	0.516787443499452	0.520362415959751	false	false	false	true
90fd8e46-e43a-478c-8ab2-43ae09d554d4	2026-09-21 13:59	2026-09-21 13:59	2026-09-21 13:59	SHOP	SHOP261120P00125000	put	125.0000	2026-11-20	8.2000	7.8000	8.5000	134.8500	26240.00	26240.00	0.00	32	9	513	745	0.688590604026846	0.615062067660826	0.615062067660826	false	false	false	true
50b2c982-7edc-4539-9b55-c86a390de4bf	2026-09-21 13:57	2026-09-21 13:57	2026-09-21 13:57	SHOP	SHOP261016C00134000	call	134.0000	2026-10-16	7.7000	7.1500	8.2000	134.3800	67760.00	49280.00	18480.00	88	8	236	0	0	0.523731949455556	0.523731949455556	false	false	false	true
0d482860-fa6f-4f50-ae0b-9654d961b617	2026-09-21 13:55	2026-09-21 13:55	2026-09-21 13:55	SHOP	SHOP261120P00120000	put	120.0000	2026-11-20	6.2500	6.2500	6.7500	134.3050	290625.00	0.00	290000.00	465	37	740	1558	0.474967907573813	0.605325517343135	0.605325517343135	false	false	false	true
988c92ea-a871-4e33-be58-da897433d471	2026-09-21 13:55	2026-09-21 13:55	2026-09-21 13:55	SHOP	SHOP261016C00136000	call	136.0000	2026-10-16	6.7000	6.3000	7.7500	134.1250	32180.00	680.00	31500.00	48	5	221	0	0	0.53150642547491	0.527935720837389	true	false	false	true
4697f89e-d1ea-4c8f-9d12-bc935c114f14	2026-09-21 13:55	2026-09-21 13:54	2026-09-21 13:54	SHOP	SHOP260925C00150000	call	150.0000	2026-09-25	0.3100	0.3000	0.4900	134.0793	18551.00	0.00	18551.00	600	14	1427	667	2.13943028485757	0.706813992412739	0.706813992412739	false	false	false	true
be1f8b24-6ec4-4d17-8400-08aa89f174b4	2026-09-21 13:54	2026-09-21 13:54	2026-09-21 13:54	SHOP	SHOP261002C00137000	call	137.0000	2026-10-02	3.9500	3.8000	4.9000	133.7300	43065.00	8700.00	32785.00	109	25	252	48	5.25	0.57333873248415	0.57239938492354	true	false	false	true
2be37d8d-2251-4024-a763-f8206f818e50	2026-09-21 13:52	2026-09-21 13:52	2026-09-21 13:52	SHOP	SHOP260925P00131000	put	131.0000	2026-09-25	2.3300	2.3000	2.7200	134.4000	40466.00	22834.00	17632.00	174	22	202	51	3.96078431372549	0.686190291556839	0.686190291556839	true	false	false	true
3aa455b3-5974-4712-8fdd-df79543ec74d	2026-09-21 13:52	2026-09-21 13:52	2026-09-21 13:52	SHOP	SHOP260925C00143000	call	143.0000	2026-09-25	1.3500	1.3500	1.5500	134.5400	22140.00	0.00	22140.00	164	8	1362	298	4.57046979865772	0.743939809207307	0.743939809207307	false	false	false	true
0055d6e6-63db-41ae-bc30-0e4d065d9812	2026-09-21 13:51	2026-09-21 13:50	2026-09-21 13:50	SHOP	SHOP261016C00155000	call	155.0000	2026-10-16	2.2300	2.1100	2.2800	135.1600	78611.00	49778.00	28833.00	352	8	3391	6329	0.535787644177595	0.576726614266226	0.576726614266226	true	false	false	true
76185dae-7067-4ff2-84cc-978346db5f05	2026-09-21 13:51	2026-09-21 13:50	2026-09-21 13:50	SHOP	SHOP261016C00155000	call	155.0000	2026-10-16	2.1300	1.9400	2.1500	135.0900	71292.00	51722.00	19570.00	335	7	1878	6329	0.29672934112814	0.570354413332208	0.567208609261635	false	false	false	true
31dc93de-7796-4a94-a757-94f44dbe7d62	2026-09-21 13:50	2026-09-21 13:50	2026-09-21 13:50	SHOP	SHOP261218C00150000	call	150.0000	2026-12-18	10.3500	10.1000	10.6500	135.5000	17595.00	15525.00	2070.00	17	17	107	1996	0.0536072144288577	0.578309077127672	0.578309077127672	false	false	false	true
e079df5f-12f8-4890-a8ca-8b555c4157e9	2026-09-21 13:50	2026-09-21 13:50	2026-09-21 13:50	SHOP	SHOP261009C00142000	call	142.0000	2026-10-09	4.0000	4.0000	4.4000	135.1750	10000.00	0.00	10000.00	25	6	210	19	11.0526315789474	0.55292026760843	0.55292026760843	false	false	false	true
b95fc7a9-b006-4e13-9c61-6faaeb4207f8	2026-09-21 13:50	2026-09-21 13:49	2026-09-21 13:49	SHOP	SHOP261120C00125000	call	125.0000	2026-11-20	19.3000	18.2500	19.5500	135.0450	11580.00	1930.00	9650.00	6	5	63	1083	0.0581717451523546	0.629224651699659	0.629224651699659	false	false	false	true
58fa65cc-0ffd-4e57-a1f6-d7ecf428001a	2026-09-21 13:48	2026-09-21 13:48	2026-09-21 13:48	SHOP	SHOP260925C00136000	call	136.0000	2026-09-25	3.7500	3.3500	3.8500	135.0200	13865.00	7125.00	6740.00	37	7	1233	132	9.34090909090909	0.741488792093435	0.741488792093435	true	false	false	true