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 = 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

e536b746-e43e-40dd-aa6e-cf967064733c	2026-09-22 15:58	2026-09-22 15:58	2026-09-22 15:58	SHOP	SHOP261120C00150000	call	150.0000	2026-11-20	14.0700	13.6000	14.1500	147.8200	59085.00	40885.00	18200.00	42	5	401	1140	0.351754385964912	0.616446829948174	0.618564603481631	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-22T19:58:44.027893Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
8a21862e-ba13-4c33-9b94-5bc6ee2e2b13	2026-09-22 15:58	2026-09-22 15:58	2026-09-22 15:58	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	7.4500	6.8500	7.4500	147.7850	21605.00	21605.00	0.00	29	8	3208	8713	0.368185469987375	0.548112990614849	0.548112990614849	false	false	false	true
209997e8-f99a-43b7-81ea-067d6ea1f609	2026-09-22 15:36	2026-09-22 15:35	2026-09-22 15:35	SHOP	SHOP261030C00165000	call	165.0000	2026-10-30	4.7500	3.8500	4.7500	149.0450	30870.00	30870.00	0.00	65	5	102	24	4.25	0.531118943309877	0.528188034847958	true	false	false	true
87660407-a047-40aa-8db9-af0f929ab573	2026-09-22 15:35	2026-09-22 15:35	2026-09-22 15:35	SHOP	SHOP260925C00130000	call	130.0000	2026-09-25	19.0000	18.7500	19.1500	148.9100	233699.00	81699.00	32300.00	123	19	1583	1830	0.865027322404372	0.694633536128622	0.672437178041681	false	false	false	true
48a10e5b-5deb-4386-b99d-8eda0c041de6	2026-09-22 15:34	2026-09-22 15:34	2026-09-22 15:34	SHOP	SHOP260925C00150000	call	150.0000	2026-09-25	3.0500	3.0500	3.1000	149.0500	35380.00	0.00	25315.00	116	30	5973	1513	3.9477858559154	0.644066540471232	0.644066540471232	false	false	false	true
09f5f493-f605-4f8a-99a0-6ff21b34f2a6	2026-09-22 15:34	2026-09-22 15:34	2026-09-22 15:34	SHOP	SHOP260925C00150000	call	150.0000	2026-09-25	2.9700	2.9700	3.0000	148.9400	81675.00	0.00	81675.00	275	62	5807	1513	3.83807005948447	0.640483343448674	0.638751462647093	false	false	false	true
ca65d769-5e12-4d00-abd7-bc86e68cbba4	2026-09-22 15:27	2026-09-22 15:27	2026-09-22 15:27	SHOP	SHOP261120C00145000	call	145.0000	2026-11-20	16.6000	16.2000	16.7500	148.3600	28220.00	3320.00	24900.00	17	11	298	2138	0.139382600561272	0.613014042873098	0.613014042873098	false	false	false	true
11e896af-3e37-46c4-8ead-036b3ca78e65	2026-09-22 15:12	2026-09-22 15:12	2026-09-22 15:12	SHOP	SHOP270917C00220000	call	220.0000	2027-09-17	15.9600	15.4000	16.5000	147.4400	11170.00	1595.00	7980.00	7	6	14	32	0.4375	0.574792808887817	0.574792808887817	false	false	false	true
b0791e59-ecf0-450a-9ca0-c8a472201be6	2026-09-22 15:06	2026-09-22 15:06	2026-09-22 15:06	SHOP	SHOP270115P00155000	put	155.0000	2027-01-15	21.5400	20.8000	22.1500	147.4300	21540.00	21540.00	0.00	10	5	22	416	0.0528846153846154	0.558625489578665	0.557159342773719	false	false	false	true
a198157f-78ae-4728-a064-76abdcb0a895	2026-09-22 14:32	2026-09-22 14:32	2026-09-22 14:32	SHOP	SHOP260925C00152500	call	152.5000	2026-09-25	1.7100	1.5600	1.7300	147.9300	14193.00	9405.00	4788.00	83	12	7238	176	41.125	0.649722401777194	0.647741689842716	true	false	false	true
4b0e9678-35d6-432c-ae45-6322ac7031ab	2026-09-22 13:24	2026-09-22 13:24	2026-09-22 13:24	SHOP	SHOP270115C00155000	call	155.0000	2027-01-15	16.8500	16.5500	17.0000	148.8300	11795.00	5055.00	6740.00	7	7	62	901	0.0688124306326304	0.5601378832649	0.559661366013418	false	false	false	true
c7c23ce8-53cc-43da-9216-e2fc9f160c9e	2026-09-22 13:20	2026-09-22 13:20	2026-09-22 13:20	SHOP	SHOP261120P00150000	put	150.0000	2026-11-20	14.6000	14.2500	14.9000	148.6973	55485.00	46725.00	8760.00	38	8	52	432	0.12037037037037	0.606457231482781	0.606457231482781	false	false	false	true
5ab7731c-daa1-43ed-8b19-67ab5be81ac7	2026-09-22 13:19	2026-09-22 13:19	2026-09-22 13:19	SHOP	SHOP261218C00155000	call	155.0000	2026-12-18	14.6500	14.3500	14.7500	148.6500	11720.00	1465.00	10255.00	8	8	929	925	1.00432432432432	0.578055203150112	0.578055203150112	false	false	false	true
c4e6543c-00b7-46f5-aa6b-c151372eade6	2026-09-22 12:57	2026-09-22 12:57	2026-09-22 12:57	SHOP	SHOP261218C00130000	call	130.0000	2026-12-18	27.6600	27.4500	28.0000	148.5975	24897.00	0.00	24897.00	9	5	19	928	0.0204741379310345	0.586286849896472	0.587562719075208	false	false	false	true
503380f2-dfba-441f-a0d3-42b1e77b084f	2026-09-22 12:47	2026-09-22 12:47	2026-09-22 12:47	SHOP	SHOP260925C00145000	call	145.0000	2026-09-25	5.3500	5.3500	5.7000	148.5500	11235.00	0.00	11235.00	21	5	1341	983	1.36419125127162	0.610269687309883	0.610269687309883	false	false	false	true
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
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