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

d1418b29-c785-4e5f-8b02-5fc6a52b912c	2026-09-14 11:41	2026-09-14 11:41	2026-09-14 11:41	SHOP	SHOP260918P00140000	put	140.0000	2026-09-18	8.9500	8.7000	9.3000	131.7100	179000.00	36695.00	61755.00	200	67	257	2188	0.11745886654479	0.609505320827192	0.588745846048415	true	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-09-14T16:02:31.142849Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
6b4c66d3-cbf6-4a7c-821e-e94da78c9450	2026-09-11 10:19	2026-09-11 10:19	2026-09-11 10:19	SHOP	SHOP270617P00130000	put	130.0000	2027-06-17	22.6000	22.3000	23.0500	131.2650	241820.00	239560.00	2260.00	107	12	107	578	0.185121107266436	0.567148753856787	0.567148753856787	false	false	false	true
8577fb68-64bd-464e-8ddf-3eb8d6fec82a	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	SHOP	SHOP280121C00120000	call	120.0000	2028-01-21	41.5400	40.7500	42.9500	130.0000	170325.00	0.00	170325.00	41	9	41	414	0.0990338164251208	0.57786314038902	0.577480371623544	false	false	false	true
d15df030-3c0d-4fb7-8edd-1a785c27c0a2	2026-09-10 15:43	2026-09-10 15:43	2026-09-10 15:43	SHOP	SHOP261030P00125000	put	125.0000	2026-10-30	9.0500	8.2000	9.3500	125.9800	51565.00	32660.00	18905.00	57	7	69	0	0	0.531361000529687	0.534086005235188	false	false	false	true	false
91b44bc9-6e28-4210-9cc2-857632abda79	2026-09-10 15:27	2026-09-10 15:27	2026-09-10 15:27	SHOP	SHOP270115C00110000	call	110.0000	2027-01-15	26.2900	25.5000	26.4000	126.2450	128840.00	73715.00	55125.00	49	5	59	729	0.0809327846364883	0.58210546821639	0.576005641122872	false	false	false	true
f02f8719-a12f-40ba-a390-62998b543856	2026-09-10 14:19	2026-09-10 14:19	2026-09-10 14:19	SHOP	SHOP270617P00105000	put	105.0000	2027-06-17	12.2000	12.1000	12.4000	126.3900	87840.00	78080.00	2440.00	72	11	141	628	0.224522292993631	0.570658462519992	0.570658462519992	false	false	false	true
3a880530-76ef-42fb-99eb-87e31b35cfaf	2026-09-10 14:04	2026-09-10 14:04	2026-09-10 14:04	SHOP	SHOP280121P00095000	put	95.0000	2028-01-21	13.5600	13.2000	13.6000	126.3900	108466.00	108466.00	0.00	80	11	96	3466	0.0276976341604155	0.578369846806127	0.578369846806127	false	false	false	true
c1940486-edfd-4e04-90fe-977b46ab9beb	2026-09-09 15:17	2026-09-09 15:17	2026-09-09 15:17	SHOP	SHOP270115P00085000	put	85.0000	2027-01-15	2.0000	1.8300	2.0000	126.8200	139400.00	139400.00	0.00	697	45	728	2066	0.352371732817038	0.584813470585617	0.584813470585617	false	false	false	true
9cabbd65-5b2b-4354-85e0-53d0d1d5e374	2026-09-09 14:49	2026-09-09 14:49	2026-09-09 14:49	SHOP	SHOP261120C00150000	call	150.0000	2026-11-20	6.0000	6.0000	6.1500	127.2500	90600.00	0.00	90600.00	151	8	319	804	0.396766169154229	0.586326063977107	0.586326063977107	false	false	false	true
3ab37039-9c25-4baa-b3f9-609c03f34bb2	2026-09-09 14:48	2026-09-09 14:48	2026-09-09 14:48	SHOP	SHOP280121C00260000	call	260.0000	2028-01-21	9.0500	8.7000	9.8000	127.3850	88690.00	87785.00	905.00	98	9	117	926	0.126349892008639	0.553664802835721	0.553664802835721	false	false	false	true
a5762098-9f5c-4e05-aaf3-6b9c915bd6b5	2026-09-09 14:09	2026-09-09 14:09	2026-09-09 14:09	SHOP	SHOP270416P00080000	put	80.0000	2027-04-16	2.9700	2.1200	2.9700	127.9450	51975.00	51975.00	0.00	175	20	175	1	175	0.576569727030704	0.576569727030704	false	false	false	true	false
096395b7-8785-4ba4-9f72-3d779b0f1d9d	2026-09-09 13:22	2026-09-09 13:22	2026-09-09 13:22	SHOP	SHOP270115C00175000	call	175.0000	2027-01-15	4.8500	4.6500	4.9000	129.4118	242985.00	196910.00	2425.00	501	24	504	2626	0.191926884996192	0.543728402857464	0.543728402857464	false	false	false	true
87e12625-3260-4cb6-ae85-e87511a7f067	2026-09-09 13:20	2026-09-09 13:20	2026-09-09 13:20	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	2.1500	2.1500	2.2500	129.6000	66220.00	0.00	66220.00	308	19	1005	1864	0.539163090128755	0.491693962687323	0.491693962687323	false	false	false	true
458b3800-b4b7-4bcc-b02d-69f7c51d0c28	2026-09-09 12:21	2026-09-09 12:21	2026-09-09 12:21	SHOP	SHOP270917P00125000	put	125.0000	2027-09-17	23.5000	23.5000	24.0000	128.3600	58750.00	0.00	58750.00	25	6	26	914	0.0284463894967177	0.561833958424598	0.561833958424598	false	false	false	true
b22208a4-10e7-4ad1-a56c-7a4ad2041bce	2026-09-09 11:52	2026-09-09 11:52	2026-09-09 11:52	SHOP	SHOP270115C00130000	call	130.0000	2027-01-15	16.7500	16.4500	16.7500	128.1900	522595.00	520925.00	1670.00	312	26	363	1272	0.285377358490566	0.555568784534251	0.555568784534251	false	false	false	true
a48bf671-e229-4592-be97-9e508e580b64	2026-09-09 11:32	2026-09-09 11:32	2026-09-09 11:32	SHOP	SHOP261218C00175000	call	175.0000	2026-12-18	3.6200	3.4000	3.7000	128.8200	70200.00	14475.00	50980.00	194	11	466	2540	0.183464566929134	0.564325177654775	0.561646337219073	false	false	false	true
db3cd7db-c968-4a5e-8449-1c069c2a52d2	2026-09-09 11:06	2026-09-09 11:06	2026-09-09 11:06	SHOP	SHOP270115P00100000	put	100.0000	2027-01-15	4.2500	3.9500	4.2500	130.0700	468335.00	467075.00	1260.00	1102	39	1136	3986	0.284997491219267	0.562281234757511	0.562281234757511	false	false	false	true
a83dc84a-2444-4fd8-8f32-23673de257d4	2026-09-09 10:58	2026-09-09 10:58	2026-09-09 10:58	SHOP	SHOP261016C00120000	call	120.0000	2026-10-16	15.3300	14.0500	15.3500	130.5500	61310.00	33770.00	27540.00	40	5	41	400	0.1025	0.55236144323469	0.55236144323469	false	false	false	true
dd79dda8-f259-43eb-8cff-61539a1ee556	2026-09-09 10:27	2026-09-09 10:27	2026-09-09 10:27	SHOP	SHOP261016C00125000	call	125.0000	2026-10-16	11.4500	11.1500	11.5500	130.0000	125980.00	55210.00	70770.00	110	22	123	804	0.152985074626866	0.503773345035479	0.497988549211136	true	false	false	true
0b8e799f-f76d-4a41-b493-bc5390454fd1	2026-09-09 10:13	2026-09-09 10:13	2026-09-09 10:13	SHOP	SHOP261218P00105000	put	105.0000	2026-12-18	4.4000	4.2500	4.4000	130.8000	146520.00	146520.00	0.00	333	18	373	290	1.28620689655172	0.572703297295847	0.572703297295847	false	false	false	true
935e275b-ae26-4e86-ac28-c1f1df352bb9	2026-09-09 10:02	2026-09-09 10:02	2026-09-09 10:02	SHOP	SHOP260918C00139000	call	139.0000	2026-09-18	1.8300	1.5500	2.0400	131.1700	54804.00	54804.00	0.00	300	6	304	42	7.23809523809524	0.55603511812208	0.55603511812208	false	false	false	true
4d1847bb-31fc-46ac-b8d1-7a3420900617	2026-09-08 15:58	2026-09-08 15:58	2026-09-08 15:58	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	3.1500	3.1000	3.1500	134.2400	59535.00	59535.00	0.00	189	12	1850	1272	1.45440251572327	0.477974781591357	0.477974781591357	true	false	false	true
53ac85bc-0ee1-467a-aae6-624ed4bb5304	2026-09-08 15:53	2026-09-08 15:53	2026-09-08 15:53	SHOP	SHOP260911C00135000	call	135.0000	2026-09-11	2.4000	2.3200	2.4800	134.0800	100320.00	90720.00	9600.00	418	10	1057	38	27.8157894736842	0.579126981733676	0.579126981733676	false	false	false	true
58ceebb9-04a7-4af7-94ac-3001df89e4c5	2026-09-08 12:41	2026-09-08 12:40	2026-09-08 12:40	SHOP	SHOP261218P00120000	put	120.0000	2026-12-18	8.2400	8.2000	8.3000	134.4600	204280.00	140250.00	60730.00	248	34	318	679	0.468335787923417	0.560823188096898	0.560823188096898	false	false	false	true
a2de6967-9bf0-4131-b4ab-bd31030964da	2026-09-08 12:12	2026-09-08 12:12	2026-09-08 12:12	SHOP	SHOP261218P00125000	put	125.0000	2026-12-18	10.4000	10.3000	10.4500	134.1700	112320.00	70720.00	22880.00	108	24	454	1314	0.345509893455099	0.560196531662365	0.560196531662365	true	false	false	true
af76a969-3e2e-4d26-bb5f-c9a117670084	2026-09-08 12:11	2026-09-08 12:11	2026-09-08 12:11	SHOP	SHOP261218P00125000	put	125.0000	2026-12-18	10.4000	10.4000	10.5000	134.0200	67600.00	0.00	43680.00	65	16	318	1314	0.242009132420091	0.558237667274289	0.558237667274289	false	false	false	true
7df29fd7-f441-4b6c-9176-c7e41ef0d607	2026-09-08 11:59	2026-09-08 11:58	2026-09-08 11:58	SHOP	SHOP260911P00130000	put	130.0000	2026-09-11	1.2100	1.2100	1.3500	134.7800	119185.00	0.00	119185.00	985	45	1927	142	13.5704225352113	0.632952888981248	0.632952888981248	false	false	false	true
f45bdef2-ee43-4eca-9496-7f6ab815d484	2026-09-08 11:47	2026-09-08 11:47	2026-09-08 11:47	SHOP	SHOP281215C00240000	call	240.0000	2028-12-15	24.6500	23.6500	25.0000	134.9400	140505.00	2465.00	138040.00	57	8	61	1554	0.0392535392535393	0.567898901455049	0.567898901455049	false	false	false	true
85627f3b-ff2a-465e-8a69-64e134b96ca2	2026-09-08 11:04	2026-09-08 11:04	2026-09-08 11:04	SHOP	SHOP261120P00130000	put	130.0000	2026-11-20	10.9000	10.6500	11.2500	134.8350	190750.00	0.00	190750.00	175	14	223	664	0.335843373493976	0.580639260866543	0.580639260866543	false	false	false	true
06bfe857-de4d-4ede-8a6b-10abc69f471f	2026-09-08 11:02	2026-09-08 11:02	2026-09-08 11:02	SHOP	SHOP270115P00120000	put	120.0000	2027-01-15	9.1500	9.1000	9.5000	134.7950	56730.00	53070.00	3660.00	62	5	66	2922	0.0225872689938398	0.535791768173985	0.535791768173985	false	false	false	true
f8d4b907-46fd-4854-b507-2131d8af6ed2	2026-09-08 10:59	2026-09-08 10:58	2026-09-08 10:58	SHOP	SHOP261016C00120000	call	120.0000	2026-10-16	17.1000	17.0000	17.4000	133.6000	51300.00	20520.00	20520.00	30	5	40	390	0.102564102564103	0.503771959018739	0.504682608068451	false	false	false	true
ad2c1d70-1599-433b-bc64-189c68951f5f	2026-09-08 10:49	2026-09-08 10:49	2026-09-08 10:49	SHOP	SHOP261218P00125000	put	125.0000	2026-12-18	10.6000	10.6000	10.7500	133.3000	72080.00	0.00	72080.00	68	15	244	1314	0.185692541856925	0.556501882735079	0.556501882735079	false	false	false	true
71e237d8-283c-4f99-bd76-ba3554c203c6	2026-09-08 10:49	2026-09-08 10:49	2026-09-08 10:49	SHOP	SHOP261218P00125000	put	125.0000	2026-12-18	10.6000	10.3000	10.7000	133.2100	110200.00	60410.00	21170.00	104	22	116	1314	0.0882800608828006	0.555302751766962	0.55142438325455	true	false	false	true
48b63372-9e37-4076-b4f2-4ca732df12d2	2026-09-08 10:35	2026-09-08 10:35	2026-09-08 10:35	SHOP	SHOP261016P00110000	put	110.0000	2026-10-16	1.1300	1.1000	1.1300	133.0587	64636.00	64636.00	0.00	572	25	1278	17809	0.0717614689202089	0.506646401726276	0.506646401726276	false	false	false	true
92e24b36-5e15-4766-b32b-e1150d652937	2026-09-08 10:15	2026-09-08 10:14	2026-09-08 10:14	SHOP	SHOP260918P00135000	put	135.0000	2026-09-18	5.3000	5.0250	5.6000	134.4250	78970.00	14840.00	64130.00	149	13	211	2680	0.0787313432835821	0.57258547945934	0.571538282928161	true	false	false	true
64041904-5424-4ada-9e92-c7a2c5b91b5b	2026-09-08 10:01	2026-09-08 10:01	2026-09-08 10:01	SHOP	SHOP281215P00100000	put	100.0000	2028-12-15	19.3500	19.3500	19.9500	136.3300	112232.00	0.00	112232.00	58	13	79	2396	0.0329716193656093	0.567671696708194	0.567671696708194	false	false	false	true
b6fa8f1c-e37e-4a51-9033-9e18b62eb06b	2026-09-08 09:46	2026-09-08 09:46	2026-09-08 09:46	SHOP	SHOP261023P00110000	put	110.0000	2026-10-23	1.1000	0.3300	2.8100	136.0200	1114990.00	0.00	1114990.00	10135	5	10135	0	0	0.542231861149355	0.542231861149355	false	false	false	true	false
fca94f13-ea2e-46af-a4a2-6752c798859c	2026-09-08 09:39	2026-09-08 09:39	2026-09-08 09:39	SHOP	SHOP261120C00135000	call	135.0000	2026-11-20	15.5000	15.5000	17.6000	136.2900	131750.00	0.00	131750.00	85	7	88	572	0.153846153846154	0.594901031076125	0.594901031076125	true	false	false	true
dc525722-19fc-433f-b8f6-e8c731da64a3	2026-09-08 09:38	2026-09-08 09:38	2026-09-08 09:38	SHOP	SHOP261016P00140000	put	140.0000	2026-10-16	10.4400	8.5000	10.7500	136.7300	50125.00	31345.00	18780.00	48	7	66	895	0.0737430167597765	0.511715578903612	0.503186923481148	true	false	false	true
0bbf9936-1dd7-4f3e-8a36-5de5a78a7db4	2026-09-04 15:20	2026-09-04 15:20	2026-09-04 15:20	SHOP	SHOP260911C00146000	call	146.0000	2026-09-11	3.8700	3.8000	4.0000	145.5200	92603.00	42658.00	49155.00	239	32	798	420	1.9	0.513620121794245	0.513620121794245	false	false	false	true
e5c1dc19-7a09-48b7-905b-73ee559a139e	2026-09-04 14:27	2026-09-04 14:27	2026-09-04 14:27	SHOP	SHOP271217P00140000	put	140.0000	2027-12-17	28.3000	28.3000	29.1000	146.0800	50940.00	0.00	50940.00	18	7	18	137	0.131386861313869	0.560963164926741	0.560963164926741	false	false	false	true
f75cbd2d-48bd-4acf-a480-0a315cdd5bb9	2026-09-04 14:00	2026-09-04 14:00	2026-09-04 14:00	SHOP	SHOP260918C00145000	call	145.0000	2026-09-18	6.1000	5.8500	6.4500	146.0600	107360.00	106750.00	610.00	176	22	279	2997	0.0930930930930931	0.479932361798575	0.478949334369215	false	false	false	true
db285df0-643f-4218-8c32-05af711166d1	2026-09-04 13:01	2026-09-04 13:01	2026-09-04 13:01	SHOP	SHOP260911C00146000	call	146.0000	2026-09-11	4.6000	4.6000	5.1500	147.0200	98900.00	0.00	98900.00	215	6	240	420	0.571428571428571	0.495841489336392	0.495841489336392	false	false	false	true
b259ab29-f295-4270-8e59-0a8623b4d847	2026-09-04 13:01	2026-09-04 13:01	2026-09-04 13:01	SHOP	SHOP260911P00145000	put	145.0000	2026-09-11	2.9800	2.9700	3.0500	147.0200	98769.00	30300.00	68469.00	331	19	425	779	0.545571245186136	0.493824500003428	0.492803945335071	false	false	false	true
016ec46b-a579-4880-9111-e7a12bb9e250	2026-09-04 13:01	2026-09-04 13:01	2026-09-04 13:01	SHOP	SHOP260911P00147000	put	147.0000	2026-09-11	3.9500	3.9500	4.4500	147.0200	59250.00	0.00	59250.00	150	8	267	40	6.675	0.494451304246511	0.494451304246511	false	false	false	true	false
6464171d-8eb9-44b8-b726-f18a8b0b6edf	2026-09-04 12:55	2026-09-04 12:55	2026-09-04 12:55	SHOP	SHOP280121P00110000	put	110.0000	2028-01-21	14.9500	14.5000	15.0500	147.0900	79235.00	44850.00	22425.00	53	14	102	2202	0.0463215258855586	0.562243095269394	0.562243095269394	true	false	false	true
b1ed7def-9fa3-4eba-b979-db75e8085e3f	2026-09-04 12:19	2026-09-04 12:19	2026-09-04 12:19	SHOP	SHOP260911C00150000	call	150.0000	2026-09-11	2.9000	2.8800	3.0000	147.4100	317323.00	239493.00	77830.00	1093	39	1599	748	2.13770053475936	0.490706397238575	0.495727577124994	true	false	false	true
b395f826-b26f-427a-a9f1-8df1586d4901	2026-09-04 12:05	2026-09-04 12:05	2026-09-04 12:05	SHOP	SHOP260918P00140000	put	140.0000	2026-09-18	2.3400	2.3400	2.5600	147.1300	89156.00	0.00	89156.00	381	40	456	1950	0.233846153846154	0.464735503520132	0.464735503520132	false	false	false	true
4ffee19d-9020-4afa-bb93-05da0f0eb4eb	2026-09-04 12:05	2026-09-04 12:05	2026-09-04 12:05	SHOP	SHOP261120P00145000	put	145.0000	2026-11-20	13.1000	13.0000	13.3000	147.1300	89080.00	87770.00	1310.00	68	13	175	298	0.587248322147651	0.552910517696455	0.552910517696455	false	false	false	true
e575e40e-62ea-4134-8bbc-fcec5d39eed1	2026-09-04 10:41	2026-09-04 10:41	2026-09-04 10:41	SHOP	SHOP281215P00165000	put	165.0000	2028-12-15	50.6000	50.6000	54.0000	148.8000	50600.00	0.00	50600.00	10	8	10	83	0.120481927710843	0.577234682955884	0.577234682955884	false	false	false	true