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:er_time = unknown×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

c472f49d-a5f3-42b1-939c-98b5601defa0	2026-09-22 09:33	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP261023C00175000	call	175.0000	2026-10-23	2.3000	1.4300	2.8800	148.6500	28538.00	14750.00	13788.00	124	6	124	3	41.3333333333333	0.572001997711992	0.558690388337788	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	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
85ebc624-7e06-4d0b-820e-64ee719743d9	2026-09-22 09:33	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP261023C00180000	call	180.0000	2026-10-23	1.7600	0.9900	2.1000	148.6500	36972.00	19310.00	17662.00	210	5	210	6	35	0.57458186357401	0.574389813908436	false	false	false	true	false
77190051-a9b8-44c5-8135-1fe43edee594	2026-09-22 09:33	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP261023C00185000	call	185.0000	2026-10-23	1.2800	0.6600	1.6300	148.6549	36230.00	24212.00	12018.00	284	5	285	11	25.9090909090909	0.579554234747559	0.573564076802123	false	false	false	true
1231ca72-eed3-4cb9-8dd2-c5e73170ed35	2026-09-22 09:33	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP261023C00162500	call	162.5000	2026-10-23	4.7800	3.1500	5.1500	148.6450	61160.00	31830.00	29330.00	128	10	128	0	0	0.559389700969923	0.556194658534475	true	false	false	true	false
d7e3230d-52e8-4adb-ab13-ea4315c9a16f	2026-09-22 09:33	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP261016P00120000	put	120.0000	2026-10-16	0.7000	0.6800	0.8700	148.6400	13793.00	6970.00	6823.00	198	5	258	6075	0.0424691358024691	0.586470950264715	0.59245005296124	false	false	false	true
4427db7d-a1df-43fa-ab4d-44a73fee090d	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP261002C00148000	call	148.0000	2026-10-02	7.1700	5.0000	7.2500	148.0750	14340.00	14340.00	0.00	20	6	40	83	0.481927710843373	0.730388620753242	0.648364747861209	false	false	false	true
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
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
4ce996da-1b63-45ab-a304-8d086fbaa293	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SHOP	SHOP260925C00130000	call	130.0000	2026-09-25	18.2100	17.8000	18.2500	147.9800	156570.00	156570.00	0.00	86	20	238	1830	0.130054644808743	0.898297482640711	0.828818311943428	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
36aeb2a5-80da-4a0a-b4be-2cb049894f08	2026-09-22 09:32	2026-09-22 09:31	2026-09-22 09:31	SHOP	SHOP270319P00125000	put	125.0000	2027-03-19	11.5600	11.4000	13.0000	147.9300	30050.00	15080.00	14970.00	26	6	111	439	0.252847380410023	0.588126638700659	0.591307487231894	false	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
d2c2805f-0183-4630-87b0-c070db416a8f	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SHOP	SHOP260925C00143000	call	143.0000	2026-09-25	6.5400	5.6500	6.6500	146.7350	18300.00	9170.00	9130.00	28	7	317	1625	0.195076923076923	0.849933580493734	0.840779921895316	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
fb09a80a-08d2-491b-ac7b-61e7d18fa315	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	SHOP	SHOP260925C00147000	call	147.0000	2026-09-25	3.9100	2.5100	4.4500	146.4000	15625.00	13675.00	1950.00	40	8	40	111	0.36036036036036	0.795715658836491	0.786271466672934	false	false	false	true
d8a0973a-d5ed-49b1-9c9c-f3521962aa44	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	SHOP	SHOP260925C00149000	call	149.0000	2026-09-25	3.0900	1.8700	3.4000	146.5450	21915.00	11210.00	10705.00	71	6	88	114	0.771929824561403	0.816025644830962	0.784995050179592	true	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
33c6b225-3782-4d75-bb2b-4641c12628cf	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	SHOP	SHOP260925C00146000	call	146.0000	2026-09-25	4.0300	2.7800	5.1500	146.0500	26575.00	17055.00	9110.00	66	24	83	358	0.231843575418994	0.806031922859166	0.767317537665161	true	false	false	true
f6515fc2-9567-4c38-837a-21bd41d97760	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	SHOP	SHOP260925C00135000	call	135.0000	2026-09-25	5.0900	4.9000	5.1000	137.0000	38212.00	38212.00	0.00	75	9	5691	728	7.81730769230769	0.606670768088077	0.609786880944667	false	false	false	true
45608c02-7643-4927-b520-dd211527d2d2	2026-09-21 15:58	2026-09-21 15:58	2026-09-21 15:58	SHOP	SHOP260925C00135000	call	135.0000	2026-09-25	5.1000	4.8500	5.1000	137.8200	41806.00	41306.00	500.00	82	17	5586	728	7.67307692307692	0.602360225842099	0.609786880944667	false	false	false	true
17be49c7-cf61-4d5b-ae60-c26642ff279a	2026-09-21 15:58	2026-09-21 15:58	2026-09-21 15:58	SHOP	SHOP260925C00135000	call	135.0000	2026-09-25	5.0900	4.8500	5.1000	137.8200	57992.00	57992.00	0.00	114	30	5504	728	7.56043956043956	0.6047454520144	0.609786880944667	false	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
552fcefe-2371-4a07-8d9a-e0f65d872242	2026-09-21 15:50	2026-09-21 15:50	2026-09-21 15:50	SHOP	SHOP261016C00155000	call	155.0000	2026-10-16	2.0500	2.0500	2.2100	136.6400	51672.00	421.00	51251.00	252	23	10094	6329	1.59488070785274	0.527664403880781	0.538633112013861	true	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
ace99e02-c9b4-4a19-941a-8e33d40ffd15	2026-09-21 15:47	2026-09-21 15:47	2026-09-21 15:47	SHOP	SHOP260925C00142000	call	142.0000	2026-09-25	1.7200	1.5500	1.7300	137.0000	20120.00	19780.00	169.00	117	25	983	48	20.4791666666667	0.618867107135039	0.612032172419792	true	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
91ee85da-ba7b-4a14-a97d-85c45a4c4ed0	2026-09-21 15:22	2026-09-21 15:22	2026-09-21 15:22	SHOP	SHOP280121C00155000	call	155.0000	2028-01-21	33.4000	33.3500	34.2500	137.7299	93516.00	0.00	93516.00	28	16	33	159	0.207547169811321	0.579973792859733	0.579323027149823	false	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
89c9bf33-3706-473c-bf77-5981d7f8ab89	2026-09-21 15:19	2026-09-21 15:19	2026-09-21 15:19	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	8.8400	8.4500	8.8500	137.6000	10610.00	10610.00	0.00	12	12	48276	46336	1.04186809392265	0.510532532505922	0.511996212122227	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
f5f00878-d042-4cc1-8bef-25ebe64bdbd5	2026-09-21 14:58	2026-09-21 14:58	2026-09-21 14:58	SHOP	SHOP260925C00140000	call	140.0000	2026-09-25	2.1500	2.0300	2.1600	136.1550	29235.00	29235.00	0.00	136	5	7565	1924	3.93191268191268	0.639721900618125	0.64914718401645	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
c6f15fc0-81d4-41b5-8dbd-c3c28bfbd8c7	2026-09-21 14:47	2026-09-21 14:46	2026-09-21 14:46	SHOP	SHOP261016C00145000	call	145.0000	2026-10-16	3.7700	3.5500	3.8000	134.0000	28250.00	28250.00	0.00	75	7	8072	1591	5.073538654934	0.531541585349515	0.527629403998013	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
72dc37a4-1e55-4602-813c-998ab3f506c2	2026-09-21 14:24	2026-09-21 14:24	2026-09-21 14:24	SHOP	SHOP260925P00132000	put	132.0000	2026-09-25	2.0800	1.8800	2.4100	134.9500	16655.00	429.00	16226.00	80	22	185	86	2.15116279069767	0.60024290648072	0.607176425834824	true	false	false	true
29de8961-8c5e-41b8-84e5-85d64d1d9a83	2026-09-21 14:24	2026-09-21 14:24	2026-09-21 14:24	SHOP	SHOP260925P00133000	put	133.0000	2026-09-25	2.5000	2.3000	2.7900	134.9500	18003.00	750.00	17253.00	72	26	195	73	2.67123287671233	0.604286259799636	0.600548857901754	true	false	false	true