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×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	expirydate

09d3a17b-f159-4604-9611-0dcd6ca655aa	2026-08-17 09:47	2026-08-17 09:47	2026-08-17 09:47	SHOP	SHOP261218C00140000	call	140.0000	2026-12-18	24.0500	24.0500	24.6000	149.7600	245310.00	0.00	245310.00	102	30	102	941	0.108395324123273	0.531501766916234	0.531501766916234	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	161815483760.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
0dba84d7-ad55-4c19-a9c8-d94b3ea9b398	2026-08-17 10:09	2026-08-17 10:09	2026-08-17 10:09	SHOP	SHOP260918C00145000	call	145.0000	2026-09-18	10.7000	10.5500	11.4000	150.0625	64200.00	62060.00	2140.00	60	17	99	2603	0.038033038801383	0.437608632222438	0.437608632222438	false	false	false	true
ab688152-41df-4724-9993-335c5170d9c5	2026-08-17 13:02	2026-08-17 13:02	2026-08-17 13:02	SHOP	SHOP260828P00149000	put	149.0000	2026-08-28	4.2500	3.9000	4.2500	149.4500	93075.00	93075.00	0.00	219	26	222	14	15.8571428571429	0.440941972875312	0.440941972875312	false	false	false	true
e39a2870-3925-45ed-966c-699948d2c83c	2026-08-17 14:25	2026-08-17 14:25	2026-08-17 14:25	SHOP	SHOP260918C00160000	call	160.0000	2026-09-18	4.0000	3.8500	4.0000	149.3999	85600.00	85600.00	0.00	214	23	3907	80512	0.0485269276629571	0.441865729697893	0.441865729697893	false	false	false	true
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
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
11d856c9-52c1-43ee-b99f-1953979e7197	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	SHOP	SHOP281215P00100000	put	100.0000	2028-12-15	18.5300	18.4500	20.0000	148.5550	87095.00	0.00	87095.00	47	12	47	2320	0.0202586206896552	0.596936126178307	0.59511728483712	false	false	false	true
2db9c4fb-5de9-44bd-86b2-a1ed4f0a830e	2026-08-19 14:28	2026-08-19 14:28	2026-08-19 14:28	SHOP	SHOP270617P00110000	put	110.0000	2027-06-17	10.1000	10.1000	10.3000	146.5450	50500.00	0.00	35350.00	50	6	50	1183	0.0422654268808115	0.560801513554494	0.560801513554494	false	false	false	true
a8db5a08-b8f9-450d-a8b2-bc9b28d4372b	2026-08-20 09:56	2026-08-20 09:56	2026-08-20 09:56	SHOP	SHOP281215C00150000	call	150.0000	2028-12-15	53.3000	53.3000	55.5000	145.3900	170560.00	0.00	170560.00	32	5	35	417	0.0839328537170264	0.585899441292196	0.585899441292196	false	false	false	true
85d2bca2-8382-47f5-b6f8-dda344b826cd	2026-08-20 10:14	2026-08-20 10:14	2026-08-20 10:14	SHOP	SHOP270617P00095000	put	95.0000	2027-06-17	6.0000	5.9000	6.3000	144.7500	60000.00	57600.00	2400.00	100	7	113	639	0.176838810641628	0.565479884309069	0.565479884309069	false	false	false	true
e1a40ea0-6a73-406c-b498-07eea01cdb94	2026-08-20 10:43	2026-08-20 10:43	2026-08-20 10:43	SHOP	SHOP260821P00150000	put	150.0000	2026-08-21	5.4500	4.8000	5.4500	144.6900	73575.00	73575.00	0.00	135	7	197	2784	0.0707614942528736	0.443545168773257	0.504617786250666	true	false	false	true
82c49d09-4399-40ea-94a7-84a54d9eb4c9	2026-08-20 10:43	2026-08-20 10:43	2026-08-20 10:43	SHOP	SHOP260821P00150000	put	150.0000	2026-08-21	5.4000	4.9000	5.4500	144.6750	89655.00	89655.00	0.00	166	6	459	2784	0.164870689655172	0.493093787191731	0.44533970129178	true	false	false	true
b0253fd6-9239-4d11-930d-0c91260661c3	2026-08-20 13:31	2026-08-20 13:31	2026-08-20 13:31	SHOP	SHOP260918C00150000	call	150.0000	2026-09-18	6.2000	6.1500	6.4000	146.7800	120280.00	104160.00	16120.00	194	50	3430	7645	0.44865925441465	0.451006598055391	0.45072291998253	true	false	false	true
798aae65-9944-482f-8bc9-f032795eec2e	2026-08-20 14:06	2026-08-20 14:06	2026-08-20 14:06	SHOP	SHOP260821C00130000	call	130.0000	2026-08-21	16.7500	16.1500	16.7500	146.6500	92125.00	31825.00	0.00	55	7	131	2049	0.063933626159102	1.19040602578538	1.19040602578538	false	false	false	true
50cb6bb1-59d8-454c-ba2e-660ee7a2f9dc	2026-08-20 14:06	2026-08-20 14:06	2026-08-20 14:06	SHOP	SHOP260821C00130000	call	130.0000	2026-08-21	16.8000	16.5500	16.8000	146.7300	124320.00	80640.00	0.00	74	6	205	2049	0.100048804294778	1.11770400044723	1.11770400044723	false	false	false	true
1d4188eb-7099-40b3-a188-942d92e3cc6c	2026-08-20 14:06	2026-08-20 14:06	2026-08-20 14:06	SHOP	SHOP260821C00130000	call	130.0000	2026-08-21	16.8000	16.8000	16.9500	146.6700	117600.00	0.00	26880.00	70	7	275	2049	0.134211810639336	1.25329026392162	1.25329026392162	false	false	false	true
26dc9709-4cfd-4b17-a082-d3a5ecb78ced	2026-08-20 14:06	2026-08-20 14:06	2026-08-20 14:06	SHOP	SHOP260821C00130000	call	130.0000	2026-08-21	16.7500	16.7500	16.9500	146.6800	70350.00	0.00	70350.00	42	10	317	2049	0.154709614446071	1.11505914891022	1.11505914891022	false	false	false	true
d1809c03-cbf5-42a3-a810-afac2b66035b	2026-08-20 14:06	2026-08-20 14:06	2026-08-20 14:06	SHOP	SHOP260821C00130000	call	130.0000	2026-08-21	16.7500	16.7500	16.8000	146.7050	82075.00	0.00	82075.00	49	5	373	2049	0.182040019521718	1.02795654204923	1.02795654204923	false	false	false	true
adaaaeac-a8e5-4e06-b8f9-5bd97fe35486	2026-08-20 14:06	2026-08-20 14:06	2026-08-20 14:06	SHOP	SHOP260821C00130000	call	130.0000	2026-08-21	16.8000	16.6500	16.8000	146.7050	104160.00	57120.00	0.00	62	6	435	2049	0.212298682284041	1.18193315598415	1.18193315598415	true	false	false	true
e5e1eba1-9f47-47b6-b359-e7adc173eebc	2026-08-20 14:06	2026-08-20 14:06	2026-08-20 14:06	SHOP	SHOP260821C00130000	call	130.0000	2026-08-21	16.8500	16.8500	17.0500	146.7400	89305.00	0.00	89305.00	53	5	527	2049	0.257198633479746	1.21731481018197	1.21731481018197	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	true
18cdbb65-b08a-4cec-86f1-64f997fc38a4	2026-08-21 13:15	2026-08-21 13:15	2026-08-21 13:15	SHOP	SHOP260918C00140000	call	140.0000	2026-09-18	12.9500	11.7500	13.1500	149.0900	64750.00	64750.00	0.00	50	7	59	47772	0.00123503307376706	0.45382089123572	0.45382089123572	false	false	false	true
37f07ea1-8203-4f51-b1ef-315ad4e22628	2026-08-24 12:53	2026-08-24 12:53	2026-08-24 12:53	SHOP	SHOP261120C00140000	call	140.0000	2026-11-20	21.6000	20.8000	21.7000	149.2650	174960.00	12960.00	162000.00	81	9	82	509	0.161100196463654	0.560623562928953	0.560623562928953	false	false	false	true
b9a12c5e-daa2-42fb-a510-1da9dc831a08	2026-08-24 15:16	2026-08-24 15:15	2026-08-24 15:15	SHOP	SHOP260918C00145000	call	145.0000	2026-09-18	9.9600	9.9500	10.0500	149.7300	93580.00	0.00	88555.00	94	12	730	2611	0.27958636537725	0.469588086028647	0.462798093239647	false	false	false	true
fa8a303c-21fd-4e5e-aef4-89d38066f46f	2026-08-25 10:02	2026-08-25 10:02	2026-08-25 10:02	SHOP	SHOP260904P00155000	put	155.0000	2026-09-04	5.7000	4.9500	6.1000	152.9600	342000.00	341430.00	570.00	600	7	1500	30	50	0.462679628272414	0.462679628272414	true	false	false	true
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
d4bed830-bee3-4c32-b87e-469c3ccd9e22	2026-08-25 10:14	2026-08-25 10:14	2026-08-25 10:14	SHOP	SHOP260904C00155000	call	155.0000	2026-09-04	4.1500	4.1500	4.6000	153.2700	114540.00	0.00	114540.00	276	11	462	347	1.3314121037464	0.481279004378034	0.481279004378034	false	false	false	true
577f920a-15ea-4655-b2fd-dd6670378b56	2026-08-25 10:59	2026-08-25 10:59	2026-08-25 10:59	SHOP	SHOP260828P00155000	put	155.0000	2026-08-28	3.5000	3.5000	3.9500	154.0800	87500.00	0.00	87500.00	250	6	854	214	3.99065420560748	0.544797139893101	0.544797139893101	true	false	false	true
d5f1de11-c94d-469f-8452-00e5db279d1b	2026-08-25 14:42	2026-08-25 14:42	2026-08-25 14:42	SHOP	SHOP260828P00157500	put	157.5000	2026-08-28	5.6500	5.4500	5.8000	152.9800	80795.00	31640.00	49155.00	143	6	144	40	3.6	0.512927720337665	0.512927720337665	false	false	false	true
f8995381-a3b9-407d-b325-febdd86ac53d	2026-08-25 15:23	2026-08-25 15:22	2026-08-25 15:22	SHOP	SHOP280121P00145000	put	145.0000	2028-01-21	30.4600	30.4500	32.4500	153.1500	57870.00	0.00	57870.00	19	7	19	97	0.195876288659794	0.567492161387245	0.568276238146879	false	false	false	true
9ca6316f-8d7c-414c-b207-849441b195d9	2026-08-25 15:23	2026-08-25 15:22	2026-08-25 15:22	SHOP	SHOP270917C00250000	call	250.0000	2027-09-17	12.9000	12.7000	13.6500	153.1600	135450.00	61920.00	73530.00	105	6	120	375	0.32	0.546611188783988	0.546611188783988	false	false	false	true
26c6200e-8400-4764-a91f-1310b39c9d55	2026-08-25 15:44	2026-08-25 15:44	2026-08-25 15:44	SHOP	SHOP270319P00155000	put	155.0000	2027-03-19	23.7500	23.0000	24.4500	153.6000	408478.00	325353.00	83125.00	172	8	172	114	1.50877192982456	0.545855427021656	0.545855427021656	false	false	false	true
160ca4ac-1ffc-4f3f-b7d9-f21b66fb2a3f	2026-08-26 10:11	2026-08-26 10:11	2026-08-26 10:11	SHOP	SHOP260918C00160000	call	160.0000	2026-09-18	4.0000	3.6500	4.0500	152.2200	91599.00	86799.00	4800.00	229	55	279	82256	0.00339184983466252	0.454771588358031	0.454645705866116	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	true
030c5c9b-56f4-4788-baf0-0745687b9c3d	2026-08-26 15:48	2026-08-26 15:48	2026-08-26 15:48	SHOP	SHOP260918P00149000	put	149.0000	2026-09-18	5.5500	5.3000	5.5500	150.7100	89352.00	89352.00	0.00	161	36	161	133	1.21052631578947	0.436784199375352	0.435919544491946	false	false	false	true
6501c863-c62e-4b08-bd50-54f62cb5e6b3	2026-08-27 11:07	2026-08-27 11:07	2026-08-27 11:07	SHOP	SHOP280121C00195000	call	195.0000	2028-01-21	30.1000	30.1000	31.7500	154.3850	54180.00	0.00	54180.00	18	6	20	162	0.123456790123457	0.552318003018585	0.552318003018585	false	false	false	true
5fa65bda-cdf5-4b33-9100-84624e46a899	2026-08-27 11:43	2026-08-27 11:43	2026-08-27 11:43	SHOP	SHOP280121C00195000	call	195.0000	2028-01-21	30.1000	30.1000	31.7000	154.2800	51170.00	0.00	51170.00	17	6	37	162	0.228395061728395	0.553073625015553	0.553073625015553	false	false	false	true
f4031b51-1b85-4d23-bd41-6ceb6e3dd573	2026-08-27 14:29	2026-08-27 14:29	2026-08-27 14:29	SHOP	SHOP260918C00155000	call	155.0000	2026-09-18	5.9700	5.8500	6.0500	153.5900	68665.00	28800.00	39865.00	115	18	888	3701	0.239935152661443	0.433673731550252	0.428425146317777	false	false	false	true
a124aea9-891c-4f1d-91b7-1f67afd33dce	2026-08-27 14:35	2026-08-27 14:35	2026-08-27 14:35	SHOP	SHOP260918P00155000	put	155.0000	2026-09-18	7.1000	7.1000	7.2000	153.3250	119280.00	0.00	33370.00	168	46	473	1054	0.44876660341556	0.425754843108641	0.425754843108641	false	false	false	true
6d36b9a3-1582-4b37-b907-d58edbf0921e	2026-08-27 14:35	2026-08-27 14:35	2026-08-27 14:35	SHOP	SHOP260918P00155000	put	155.0000	2026-09-18	7.1000	6.8000	7.1500	153.3250	209455.00	206615.00	1420.00	295	46	305	1054	0.289373814041746	0.430507300921941	0.429085791051489	true	false	false	true
7154ad97-3146-44ee-9098-fcbc62d6f4c0	2026-08-28 09:52	2026-08-28 09:52	2026-08-28 09:52	SHOP	SHOP260918C00145000	call	145.0000	2026-09-18	12.9000	12.7000	12.9000	155.2800	91590.00	91590.00	0.00	71	9	357	3102	0.115087040618956	0.433528104133389	0.433528104133389	false	false	false	true
878bf634-21bb-4152-8b91-b4d5e5a07a40	2026-08-28 10:35	2026-08-28 10:35	2026-08-28 10:35	SHOP	SHOP261120C00160000	call	160.0000	2026-11-20	14.6000	14.6000	14.9000	155.7800	324120.00	0.00	324120.00	222	28	239	728	0.328296703296703	0.532216644676937	0.532216644676937	false	false	false	true
e53d3b53-ce8b-44f5-8142-17a01b696796	2026-08-28 11:40	2026-08-28 11:40	2026-08-28 11:40	SHOP	SHOP271217C00180000	call	180.0000	2027-12-17	33.5000	33.5000	35.1500	155.0000	67000.00	0.00	67000.00	20	9	20	115	0.173913043478261	0.554994604358735	0.554994604358735	false	false	false	true
09b36191-d460-42c3-b782-c2a168c3c478	2026-08-28 12:13	2026-08-28 12:12	2026-08-28 12:12	SHOP	SHOP261120C00160000	call	160.0000	2026-11-20	14.0500	13.8500	14.3000	154.6300	140500.00	73060.00	67440.00	100	5	360	728	0.494505494505495	0.533729841074745	0.533729841074745	false	false	false	true
c169a057-90c9-4e09-b3b6-b70dfba1c53f	2026-08-28 13:45	2026-08-28 13:45	2026-08-28 13:45	SHOP	SHOP281215C00190000	call	190.0000	2028-12-15	46.1000	44.6000	46.4500	153.5700	78370.00	9220.00	69150.00	17	17	17	48	0.354166666666667	0.576354066862184	0.576354066862184	false	false	false	true
f9716f49-fa91-4696-baa9-61bf9e79b08a	2026-08-28 13:48	2026-08-28 13:48	2026-08-28 13:48	SHOP	SHOP260918C00150000	call	150.0000	2026-09-18	8.4000	8.1000	8.7500	153.6800	75605.00	16805.00	58800.00	90	6	116	10013	0.0115849395785479	0.4267186971415	0.4267186971415	false	false	false	true
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
54fc2098-6215-4aa4-8310-4684b583e786	2026-08-28 15:44	2026-08-28 15:44	2026-08-28 15:44	SHOP	SHOP261016C00155000	call	155.0000	2026-10-16	9.0000	9.0000	9.2500	152.9400	126055.00	9955.00	116100.00	140	6	372	763	0.487549148099607	0.429272382614333	0.429044026284395	true	false	false	true
bae77987-f2f0-4215-aaa0-34caa52e86e8	2026-08-31 09:41	2026-08-31 09:41	2026-08-31 09:41	SHOP	SHOP270617P00125000	put	125.0000	2027-06-17	14.9000	14.9000	15.3500	146.7650	222010.00	0.00	222010.00	149	9	159	203	0.783251231527094	0.542516895376035	0.542516895376035	false	false	false	true