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

1f89a5cb-4c90-4b2c-8716-0129271bfb36	2026-09-22 12:44	2026-09-22 12:44	2026-09-22 12:44	SHOP	SHOP261016C00145000	call	145.0000	2026-10-16	9.7000	9.7000	10.1500	148.3250	17460.00	0.00	17460.00	18	5	2264	13449	0.168339653505837	0.514807587796633	0.514807587796633	true	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-22T16:48:50.097062Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
00fc8ce8-af31-4a91-96be-37d34c9faf0a	2026-09-22 11:37	2026-09-22 11:37	2026-09-22 11:37	SHOP	SHOP260925C00148000	call	148.0000	2026-09-25	3.4000	3.0500	3.4000	147.2700	17000.00	17000.00	0.00	50	6	967	157	6.15923566878981	0.698967144275671	0.698967144275671	false	false	false	true
4d7da78d-d04a-4733-98ec-a0340007256d	2026-09-22 11:26	2026-09-22 11:26	2026-09-22 11:26	SHOP	SHOP261016C00185000	call	185.0000	2026-10-16	0.7100	0.7100	0.8500	147.0000	44588.00	0.00	44588.00	628	44	667	641	1.0405616224649	0.574947693815923	0.574935051885004	false	false	false	true
46e5bf52-dc18-4959-87f4-51f1b8016ec6	2026-09-22 11:26	2026-09-22 11:26	2026-09-22 11:26	SHOP	SHOP261016C00200000	call	200.0000	2026-10-16	0.3100	0.2400	0.3900	147.0000	10974.00	31.00	10943.00	354	12	366	70	5.22857142857143	0.618343258114452	0.618332492873225	false	false	false	true
90e3009d-d276-4e88-9d71-b4e468099bae	2026-09-22 11:22	2026-09-22 11:22	2026-09-22 11:22	SHOP	SHOP270617P00130000	put	130.0000	2027-06-17	17.3000	17.3000	17.9000	147.0000	25950.00	0.00	25950.00	15	5	46	600	0.0766666666666667	0.580218515674047	0.580218515674047	false	false	false	true
80276ea5-241c-4fff-b639-6a570131ae4e	2026-09-22 11:17	2026-09-22 11:17	2026-09-22 11:17	SHOP	SHOP261002C00132000	call	132.0000	2026-10-02	16.5000	15.1500	16.5000	147.5100	21450.00	21450.00	0.00	13	5	26	1382	0.0188133140376266	0.589891891694297	0.589891891694297	true	false	false	true
b00788e7-4fc5-4fd8-abb9-65388dd02d46	2026-09-22 11:03	2026-09-22 11:03	2026-09-22 11:03	SHOP	SHOP271217C00260000	call	260.0000	2027-12-17	14.7900	14.3000	14.8000	147.3800	28095.00	28095.00	0.00	19	7	335	424	0.790094339622642	0.583837000340287	0.584056671038687	false	false	false	true
f3347a51-2c43-4818-98be-f13575fc1084	2026-09-22 10:51	2026-09-22 10:51	2026-09-22 10:51	SHOP	SHOP270617P00165000	put	165.0000	2027-06-17	37.1500	35.2000	37.8500	146.7600	33435.00	26005.00	7430.00	9	5	9	39	0.230769230769231	0.583739803862082	0.583739803862082	false	false	false	true
98439cbe-cf58-48a0-999c-84f27d99cf52	2026-09-22 10:44	2026-09-22 10:44	2026-09-22 10:44	SHOP	SHOP261016C00135000	call	135.0000	2026-10-16	15.8000	15.8000	16.0500	147.5600	34760.00	0.00	28440.00	22	6	355	24442	0.0145241796906963	0.532762344549533	0.532762344549533	false	false	false	true
88d714fc-84f0-4012-a523-d33d3853541e	2026-09-22 10:36	2026-09-22 10:36	2026-09-22 10:36	SHOP	SHOP260925C00149000	call	149.0000	2026-09-25	3.4500	3.4500	3.8000	148.4200	17940.00	0.00	17940.00	52	19	902	114	7.91228070175439	0.685377104190434	0.689947599902575	false	false	false	true
ff7b9b7f-d2de-4860-848f-f7df088c95f3	2026-09-22 10:30	2026-09-22 10:30	2026-09-22 10:30	SHOP	SHOP261218C00155000	call	155.0000	2026-12-18	14.9500	14.6500	15.2000	148.6450	509826.00	7475.00	496371.00	341	27	673	925	0.727567567567568	0.588510382956017	0.588510382956017	false	false	false	true
5d9635ec-f097-47fb-b57e-84f1d1e0676c	2026-09-22 10:24	2026-09-22 10:24	2026-09-22 10:24	SHOP	SHOP261002C00150000	call	150.0000	2026-10-02	5.2500	5.2000	5.9000	148.0000	25725.00	0.00	25725.00	49	13	650	975	0.666666666666667	0.586272386611202	0.59669188260272	true	false	false	true
4b7db7e4-4191-4723-91fa-a091d5486ce4	2026-09-22 10:12	2026-09-22 10:12	2026-09-22 10:12	SHOP	SHOP261120C00200000	call	200.0000	2026-11-20	3.0000	2.7800	3.2000	149.8200	30000.00	9300.00	4200.00	100	7	472	713	0.661991584852735	0.636785190817355	0.636785190817355	false	false	false	true
b0d0a031-b6ad-4d76-ad6c-c21ed11290b3	2026-09-22 10:12	2026-09-22 10:12	2026-09-22 10:12	SHOP	SHOP261120C00200000	call	200.0000	2026-11-20	3.0000	2.5700	3.2000	149.7900	30000.00	6000.00	6000.00	100	6	372	713	0.521739130434783	0.63711620139049	0.63711620139049	false	false	false	true
901b8824-5247-4bf3-a931-ed13b929142a	2026-09-22 10:12	2026-09-22 10:12	2026-09-22 10:12	SHOP	SHOP261120C00200000	call	200.0000	2026-11-20	3.0000	2.5700	3.0000	149.7300	30000.00	30000.00	0.00	100	7	272	713	0.38148667601683	0.637778346493391	0.637778346493391	false	false	false	true
f1e796e6-acc0-4bb5-a930-470b8234f3e8	2026-09-22 10:06	2026-09-22 10:06	2026-09-22 10:06	SHOP	SHOP261002C00140000	call	140.0000	2026-10-02	12.0000	10.3000	12.0000	149.8800	194400.00	194400.00	0.00	162	6	737	952	0.774159663865546	0.600426967331475	0.587486997137823	false	false	false	true
194785bf-a835-4ed4-8215-69b16863c386	2026-09-22 10:06	2026-09-22 10:06	2026-09-22 10:06	SHOP	SHOP261002C00140000	call	140.0000	2026-10-02	12.0000	10.2500	12.0000	149.6550	51600.00	51600.00	0.00	43	5	555	952	0.582983193277311	0.610555595750334	0.610555595750334	false	false	false	true
3e208725-e0bc-46d8-bd8f-cff0196ac1f6	2026-09-22 10:06	2026-09-22 10:06	2026-09-22 10:06	SHOP	SHOP261120C00190000	call	190.0000	2026-11-20	4.3000	3.7500	4.5500	149.6500	11610.00	11180.00	430.00	27	5	158	334	0.473053892215569	0.639996597355292	0.639704185769082	false	false	false	true
f3e29891-c457-416d-b4e0-61c5d1e4728f	2026-09-22 10:06	2026-09-22 10:05	2026-09-22 10:05	SHOP	SHOP270115C00200000	call	200.0000	2027-01-15	5.7500	5.0500	5.9000	149.2912	125925.00	125925.00	0.00	219	5	906	2683	0.337681699590011	0.56965134938016	0.56965134938016	false	false	false	true
d97483e9-92ea-4093-920a-92178a21c9d9	2026-09-22 10:05	2026-09-22 10:04	2026-09-22 10:04	SHOP	SHOP270617C00175000	call	175.0000	2027-06-17	22.1000	22.1000	23.0000	148.5800	59670.00	0.00	59670.00	27	5	43	123	0.349593495934959	0.584522628447405	0.584815405133933	false	false	false	true
69db9104-b4ef-496e-824e-c03f355648a8	2026-09-22 10:03	2026-09-22 10:03	2026-09-22 10:03	SHOP	SHOP270115P00130000	put	130.0000	2027-01-15	9.3500	9.1000	9.4000	148.6650	85085.00	85085.00	0.00	91	8	151	2848	0.0530196629213483	0.574746115694869	0.574746115694869	false	false	false	true
a05ee336-7591-40ef-a6fe-470bb3718561	2026-09-22 10:02	2026-09-22 10:02	2026-09-22 10:02	SHOP	SHOP261016C00145000	call	145.0000	2026-10-16	10.0000	9.4500	10.2000	147.8700	16000.00	9000.00	7000.00	16	9	1888	13449	0.140382184549037	0.553618686425462	0.553618686425462	true	false	false	true
88334bc7-ee7d-4c29-8579-3349881655d0	2026-09-22 10:00	2026-09-22 10:00	2026-09-22 10:00	SHOP	SHOP261120C00145000	call	145.0000	2026-11-20	17.2000	16.3000	17.7500	148.0000	43000.00	18920.00	24080.00	25	6	122	2138	0.0570626753975678	0.637694249731987	0.637694249731987	true	false	false	true
e0d8555a-390e-4575-85f5-08d5159e8700	2026-09-22 09:55	2026-09-22 09:55	2026-09-22 09:55	SHOP	SHOP260925C00160000	call	160.0000	2026-09-25	1.2100	1.1500	1.2200	149.6200	13310.00	13310.00	0.00	110	14	6620	645	10.2635658914729	0.833563215741771	0.833563215741771	false	false	false	true
02d7b24c-2955-4b3b-b7dd-ab680964ea3d	2026-09-22 09:55	2026-09-22 09:55	2026-09-22 09:55	SHOP	SHOP260925C00160000	call	160.0000	2026-09-25	1.2000	1.1800	1.2500	149.6400	180960.00	0.00	180960.00	1508	5	6268	645	9.71782945736434	0.829868617192927	0.829868617192927	false	false	false	true
c1b48deb-ad9d-4df1-a066-36735bebe3eb	2026-09-22 09:55	2026-09-22 09:55	2026-09-22 09:55	SHOP	SHOP261002C00140000	call	140.0000	2026-10-02	12.0000	11.8000	12.0000	149.6950	184800.00	184800.00	0.00	154	5	511	952	0.536764705882353	0.6065268531581	0.6065268531581	false	false	false	true
6581be2e-b9f9-4a7f-9131-13248df3e5d5	2026-09-22 09:55	2026-09-22 09:55	2026-09-22 09:55	SHOP	SHOP261120C00140000	call	140.0000	2026-11-20	20.7500	20.5000	20.7500	149.6950	10375.00	4150.00	0.00	5	5	45	739	0.060893098782138	0.642846999916724	0.642846999916724	false	false	false	true
d1beea38-4cd1-4350-9e3a-d49ba1aa9cb8	2026-09-22 09:51	2026-09-22 09:51	2026-09-22 09:51	SHOP	SHOP260925C00160000	call	160.0000	2026-09-25	0.9800	0.9500	1.0200	148.6200	10810.00	3950.00	5880.00	110	9	1486	645	2.30387596899225	0.82105798073346	0.82105798073346	false	false	false	true
bbf2c716-a7c0-4bd0-bfa7-acb57b9438f0	2026-09-22 09:45	2026-09-22 09:44	2026-09-22 09:44	SHOP	SHOP261016P00117000	put	117.0000	2026-10-16	0.5000	0.4200	0.7600	148.0000	13050.00	0.00	13050.00	261	8	263	0	0	0.600589344357671	0.600589344357671	false	false	false	true
94652948-946d-4e90-be7c-9991ea49591c	2026-09-22 09:43	2026-09-22 09:43	2026-09-22 09:43	SHOP	SHOP260925C00132000	call	132.0000	2026-09-25	16.9700	16.9500	18.2000	148.0000	88250.00	0.00	88250.00	52	8	154	468	0.329059829059829	0.708066011628584	0.758562238830075	false	false	false	true
d9a4dffb-865b-4bf8-ad9c-a8ef6a636cc5	2026-09-22 09:42	2026-09-22 09:42	2026-09-22 09:42	SHOP	SHOP260925C00140000	call	140.0000	2026-09-25	10.0000	9.8000	10.0000	148.9300	504000.00	504000.00	0.00	504	5	1022	5464	0.187042459736457	0.768511190139497	0.768511190139497	false	false	false	true
2a2eddfd-16da-41d2-a700-deef537daf5c	2026-09-22 09:42	2026-09-22 09:41	2026-09-22 09:41	SHOP	SHOP261120C00180000	call	180.0000	2026-11-20	5.7500	5.7500	6.0000	148.0100	12650.00	0.00	12650.00	22	8	280	704	0.397727272727273	0.643576366174744	0.647040300984843	true	false	false	true
50b18c49-a313-40cb-b962-9578e571779e	2026-09-22 09:41	2026-09-22 09:41	2026-09-22 09:41	SHOP	SHOP260925C00145000	call	145.0000	2026-09-25	6.0000	5.7500	6.1500	148.4000	14400.00	1800.00	12600.00	24	12	513	983	0.521871820956256	0.735135487788072	0.762647943244508	false	false	false	true
386e001e-86cc-4942-9f4d-1a20773fbe51	2026-09-22 09:41	2026-09-22 09:41	2026-09-22 09:41	SHOP	SHOP260925C00155000	call	155.0000	2026-09-25	1.9600	1.9600	2.1300	148.7950	19600.00	0.00	19600.00	100	7	1775	572	3.10314685314685	0.794806530407844	0.794806530407844	false	false	false	true
08c14260-2837-4400-af41-594196ead22c	2026-09-22 09:40	2026-09-22 09:40	2026-09-22 09:40	SHOP	SHOP261218C00145000	call	145.0000	2026-12-18	20.1500	19.2500	20.7000	149.0100	12090.00	2015.00	10075.00	6	6	116	43646	0.0026577464143335	0.609193656379489	0.609193656379489	false	false	false	true
b69be0fc-09c3-4254-b213-7878caeb547f	2026-09-22 09:40	2026-09-22 09:39	2026-09-22 09:39	SHOP	SHOP260925C00152500	call	152.5000	2026-09-25	3.0000	3.0000	3.0500	149.3500	30000.00	0.00	30000.00	100	5	3447	176	19.5852272727273	0.80210295916381	0.80210295916381	true	false	false	true
7f147dde-98f6-426e-864c-a9025a209bd1	2026-09-22 09:39	2026-09-22 09:39	2026-09-22 09:39	SHOP	SHOP261120C00150000	call	150.0000	2026-11-20	15.5000	15.2000	15.8000	149.1550	12400.00	1550.00	10850.00	8	8	117	1140	0.102631578947368	0.646976931978591	0.646976931978591	false	false	false	true
806afbcd-efa4-49d7-a237-46c155ead740	2026-09-22 09:38	2026-09-22 09:38	2026-09-22 09:38	SHOP	SHOP260925C00143000	call	143.0000	2026-09-25	7.8000	7.4000	8.1500	149.0900	64740.00	64740.00	0.00	83	6	612	1625	0.376615384615385	0.758814577648098	0.758814577648098	false	false	false	true
da4aa05a-d6e0-4ad3-98b5-e258b3964eca	2026-09-22 09:36	2026-09-22 09:36	2026-09-22 09:36	SHOP	SHOP261016C00145000	call	145.0000	2026-10-16	11.0000	10.1000	11.2000	149.1500	27500.00	27500.00	0.00	25	5	378	13449	0.0281061788980593	0.569310664970136	0.569310664970136	false	false	false	true
906643e6-770e-47ef-8fa3-d8d9290fc79e	2026-09-22 09:36	2026-09-22 09:36	2026-09-22 09:36	SHOP	SHOP270319C00230000	call	230.0000	2027-03-19	6.1400	4.8000	6.1500	149.0400	14125.00	14125.00	0.00	23	11	24	449	0.0534521158129176	0.589128919573397	0.589128919573397	false	false	false	true
1e13b315-0b66-4ac7-9142-a78157879688	2026-09-22 09:36	2026-09-22 09:36	2026-09-22 09:36	SHOP	SHOP261120C00190000	call	190.0000	2026-11-20	4.3500	3.6000	4.6000	149.1300	40010.00	435.00	26960.00	92	7	93	334	0.278443113772455	0.650310184667511	0.648947002424016	true	false	false	true
f495e792-d5a3-4c54-a009-b79a5ad60104	2026-09-22 09:34	2026-09-22 09:34	2026-09-22 09:34	SHOP	SHOP260925C00130000	call	130.0000	2026-09-25	17.6500	17.1000	17.6500	147.4550	277105.00	277105.00	0.00	157	40	962	1830	0.52568306010929	0.846494444999814	0.787864759676929	true	false	false	true
39d6bb53-ebf2-4b44-9f4f-90874262f02a	2026-09-22 09:34	2026-09-22 09:34	2026-09-22 09:34	SHOP	SHOP270115C00175000	call	175.0000	2027-01-15	10.6000	10.6000	11.3000	148.1950	62540.00	0.00	62540.00	59	19	168	3099	0.0542110358180058	0.57407558384897	0.575927742517067	false	false	false	true
ef1a9c51-3493-4018-869e-56240502d334	2026-09-22 09:34	2026-09-22 09:34	2026-09-22 09:34	SHOP	SHOP260925P00144000	put	144.0000	2026-09-25	2.2500	2.2500	2.5000	148.4500	30825.00	0.00	30825.00	137	29	140	13	10.7692307692308	0.778104939118902	0.778104939118902	true	false	false	true
e03f2cc0-9dd6-4b2b-b448-df89b9dc043f	2026-09-22 09:33	2026-09-22 09:33	2026-09-22 09:33	SHOP	SHOP260925C00130000	call	130.0000	2026-09-25	18.8000	18.4500	18.8000	148.5500	157920.00	157920.00	0.00	84	21	719	1830	0.392896174863388	0.874223857619668	0.874223857619668	false	false	false	true
d7e76bf0-d04e-4f88-8c18-ae2205e9d211	2026-09-22 09:33	2026-09-22 09:33	2026-09-22 09:33	SHOP	SHOP260925C00130000	call	130.0000	2026-09-25	18.8000	18.5000	18.8000	148.6350	125960.00	125960.00	0.00	67	11	786	1830	0.429508196721311	0.79608387062849	0.79608387062849	false	false	false	true
29e6e8d8-e192-4bfa-bd36-f280191d0221	2026-09-22 09:33	2026-09-22 09:33	2026-09-22 09:33	SHOP	SHOP260925C00130000	call	130.0000	2026-09-25	18.8000	18.5000	18.8000	148.6250	33840.00	33840.00	0.00	18	5	804	1830	0.439344262295082	0.806732071765361	0.806732071765361	false	false	false	true
7f5c6abe-5b30-4185-b56e-f87db77a4b2e	2026-09-22 09:33	2026-09-22 09:33	2026-09-22 09:33	SHOP	SHOP270115C00175000	call	175.0000	2027-01-15	10.6000	10.6000	10.9000	148.5900	107060.00	0.00	107060.00	101	12	101	3099	0.0325911584382059	0.571208482224724	0.571208482224724	false	false	false	true
35af8fe5-2d0e-4756-87cd-855ac947ea3e	2026-09-22 09:33	2026-09-22 09:33	2026-09-22 09:33	SHOP	SHOP260925C00140000	call	140.0000	2026-09-25	10.0000	9.4500	10.0000	148.7400	45000.00	45000.00	0.00	45	7	404	5464	0.0739385065885798	0.811432124414661	0.811432124414661	true	false	false	true
c93b07e7-3857-4d1e-9596-4b9b9b8c466f	2026-09-22 09:33	2026-09-22 09:33	2026-09-22 09:33	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	8.2400	7.8500	8.4000	148.5000	54410.00	27225.00	27185.00	66	17	353	8713	0.0405141742224263	0.577245058352214	0.577245058352214	false	false	false	true