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

fde8ff9a-4b43-4f79-9e15-7cfb6b6b55e2	2026-09-03 15:41	2026-09-03 15:41	2026-09-03 15:41	SHOP	SHOP261016C00140000	call	140.0000	2026-10-16	12.3500	12.2500	12.5000	145.7850	60515.00	41990.00	18525.00	49	6	121	558	0.216845878136201	0.449508142072002	0.449508142072002	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-09-03T19:48:49.580975Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
62312d4a-0c9a-478c-9295-1d5ec3e3d841	2026-09-03 15:12	2026-09-03 15:12	2026-09-03 15:12	SHOP	SHOP260911P00145000	put	145.0000	2026-09-11	3.2700	3.2000	3.9000	146.0600	129630.00	68970.00	44490.00	397	11	947	90	10.5222222222222	0.452166384705076	0.449600100801974	false	false	false	true
65701350-0b2f-4f1e-954d-1852b46046ad	2026-09-03 15:07	2026-09-03 15:07	2026-09-03 15:07	SHOP	SHOP260911C00147000	call	147.0000	2026-09-11	3.5800	3.5500	3.6500	146.2900	69875.00	23725.00	46150.00	195	11	220	217	1.01382488479263	0.45476327525854	0.45476327525854	false	false	false	true
0ac019c7-2926-42a6-951f-210b536d3736	2026-09-03 14:39	2026-09-03 14:39	2026-09-03 14:39	SHOP	SHOP260918C00160000	call	160.0000	2026-09-18	1.0700	1.0100	1.0700	145.6500	66126.00	66126.00	0.00	618	8	4112	82020	0.0501341136308217	0.441710948056238	0.441710948056238	false	false	false	true
54bdeca5-a7d3-492d-a8eb-b8725564cc28	2026-09-03 14:13	2026-09-03 14:13	2026-09-03 14:13	SHOP	SHOP260918C00145000	call	145.0000	2026-09-18	5.2100	5.1250	5.3500	144.8300	90205.00	90205.00	0.00	173	5	242	2830	0.0855123674911661	0.445979225572463	0.441705239886412	false	false	false	true
e2e3ac15-1ffa-4cf3-b1b5-c57682a61954	2026-09-03 13:08	2026-09-03 13:08	2026-09-03 13:08	SHOP	SHOP281215P00120000	put	120.0000	2028-12-15	26.8500	25.6000	27.6000	143.8950	120825.00	24165.00	96660.00	45	11	45	1088	0.0413602941176471	0.575572254333459	0.575572254333459	false	false	false	true
e23b6ee9-1106-4295-8802-40b9d4a88109	2026-09-03 12:57	2026-09-03 12:57	2026-09-03 12:57	SHOP	SHOP260911C00146000	call	146.0000	2026-09-11	2.6600	2.6500	2.6800	143.3200	65267.00	30552.00	2650.00	245	20	295	48	6.14583333333333	0.447784416769415	0.447784416769415	true	false	false	true
763cc38e-e3c7-4d50-8bf6-d66f1d363f63	2026-09-03 12:57	2026-09-03 12:57	2026-09-03 12:57	SHOP	SHOP260911P00144000	put	144.0000	2026-09-11	3.9500	3.9500	4.5000	143.3000	433030.00	2860.00	25690.00	1096	21	1518	31	48.9677419354839	0.432039913148498	0.448560177186012	false	false	false	true
1ede17aa-defe-4910-b558-97113f4ddb6e	2026-09-03 09:30	2026-09-03 09:30	2026-09-03 09:30	SHOP	SHOP281215P00100000	put	100.0000	2028-12-15	18.5000	17.4000	18.5500	143.2600	199779.00	129504.00	70275.00	108	10	108	2358	0.0458015267175573	0.588614927362881	0.587664990158794	false	false	false	true
0bdeb6b5-7a0e-4646-82ef-9c6ddd4fca11	2026-09-02 15:12	2026-09-02 15:12	2026-09-02 15:12	SHOP	SHOP270319C00180000	call	180.0000	2027-03-19	10.5000	10.2000	11.1000	140.2000	84000.00	25200.00	58800.00	80	23	80	180	0.444444444444444	0.528975532051521	0.528975532051521	false	false	false	true
8ba0121a-cd16-45ac-bb87-708ec4a2fe8e	2026-09-02 13:23	2026-09-02 13:22	2026-09-02 13:22	SHOP	SHOP281215P00070000	put	70.0000	2028-12-15	7.9600	7.9500	8.6000	140.6300	83620.00	820.00	82800.00	105	13	109	365	0.298630136986301	0.593686463583052	0.594551122269832	false	false	false	true
c0e9552a-58f0-4e1c-abb8-4970b252f9e3	2026-09-02 11:37	2026-09-02 11:36	2026-09-02 11:36	SHOP	SHOP261016P00150000	put	150.0000	2026-10-16	14.3500	13.1000	14.5500	139.7600	87525.00	87525.00	0.00	61	7	63	832	0.0757211538461538	0.438557037680579	0.438557037680579	true	false	false	true
ac0f9632-fcf5-45f8-81ec-d734cb6ab361	2026-09-01 15:53	2026-09-01 15:53	2026-09-01 15:53	SHOP	SHOP261120C00145000	call	145.0000	2026-11-20	12.5000	12.5000	13.0000	139.4600	83750.00	0.00	83750.00	67	15	474	1639	0.289200732153752	0.55014802764824	0.551698408559201	false	false	false	true
c90b99b7-63ce-4608-8f93-9fe13df5dcea	2026-09-01 14:59	2026-09-01 14:59	2026-09-01 14:59	SHOP	SHOP261120C00130000	call	130.0000	2026-11-20	20.4500	19.7000	20.7000	140.4300	59305.00	38855.00	20450.00	29	5	44	561	0.0784313725490196	0.555618648275042	0.555618648275042	false	false	false	true
6100526d-8b21-4663-ac97-b3b5695df7c2	2026-09-01 14:40	2026-09-01 14:40	2026-09-01 14:40	SHOP	SHOP260918C00140000	call	140.0000	2026-09-18	5.3000	5.1500	5.3000	139.9950	52470.00	52470.00	0.00	99	68	501	47586	0.0105283066448115	0.429976465547224	0.429976465547224	false	false	false	true
9bb20d17-316e-4480-9749-060a92528b0a	2026-09-01 14:39	2026-09-01 14:39	2026-09-01 14:39	SHOP	SHOP261120P00120000	put	120.0000	2026-11-20	5.3700	5.2500	5.4500	139.9900	78910.00	31295.00	46545.00	147	8	167	794	0.210327455919395	0.555088678058501	0.552656584794819	true	false	false	true
42df976e-833d-4452-bed8-2de4e0377d2d	2026-09-01 14:39	2026-09-01 14:39	2026-09-01 14:39	SHOP	SHOP260918P00135000	put	135.0000	2026-09-18	2.9400	2.9400	3.0500	140.0100	351940.00	22936.00	329004.00	1196	29	1287	1662	0.774368231046931	0.43899946022209	0.440707564810639	true	false	false	true
1ef8613f-75a1-40a9-af94-189ba6cae3f4	2026-09-01 14:39	2026-09-01 14:39	2026-09-01 14:39	SHOP	SHOP260918P00134000	put	134.0000	2026-09-18	2.6600	2.6300	2.6600	140.0100	51072.00	51072.00	0.00	192	30	203	32	6.34375	0.442315314907814	0.441318232859592	true	false	false	true	false
d7e72f57-e86f-4750-b6a6-b5f671e9292a	2026-09-01 14:38	2026-09-01 14:38	2026-09-01 14:38	SHOP	SHOP261120C00145000	call	145.0000	2026-11-20	12.4600	12.3000	12.5500	139.9500	300166.00	300166.00	0.00	241	12	293	1639	0.178767541183649	0.539507362439364	0.541803298605636	false	false	false	true
2933459f-76b1-4f04-9a6e-b8073f337018	2026-09-01 14:38	2026-09-01 14:38	2026-09-01 14:38	SHOP	SHOP261120P00135000	put	135.0000	2026-11-20	10.9400	10.8000	11.0500	139.9500	223160.00	101840.00	121320.00	204	12	289	276	1.04710144927536	0.539927864533188	0.540728891123996	false	false	false	true
00fe50b2-f2d8-4c96-951c-84e183d19881	2026-09-01 14:38	2026-09-01 14:38	2026-09-01 14:38	SHOP	SHOP261120C00145000	call	145.0000	2026-11-20	12.5000	12.3500	12.5500	139.9400	101250.00	95000.00	0.00	81	14	383	1639	0.233679072605247	0.542380490614615	0.542380490614615	true	false	false	true
f5ed1378-f55b-44b7-8041-c3d2bbfb06a9	2026-09-01 14:34	2026-09-01 14:34	2026-09-01 14:34	SHOP	SHOP260918P00140000	put	140.0000	2026-09-18	5.0200	4.9500	5.0500	139.8600	76335.00	60835.00	14000.00	152	19	520	1630	0.319018404907975	0.420125307251485	0.420125307251485	false	false	false	true
af9fe06a-a93a-49c8-a71d-443a39a61436	2026-09-01 13:08	2026-09-01 13:08	2026-09-01 13:08	SHOP	SHOP271217C00185000	call	185.0000	2027-12-17	23.8600	23.7500	24.7000	141.0100	64420.00	19155.00	45265.00	27	6	50	55	0.909090909090909	0.553117503407525	0.554682101366166	false	false	false	true
cbce84ee-46c9-452d-8233-8f12e8cb333a	2026-09-01 09:39	2026-09-01 09:39	2026-09-01 09:39	SHOP	SHOP270319C00185000	call	185.0000	2027-03-19	10.3800	10.3500	11.7500	142.6900	69530.00	6360.00	63170.00	67	15	67	751	0.0892143808255659	0.532113750163502	0.533410024166604	false	false	false	true
2a13fc65-7251-4ee2-859c-11fa68988b80	2026-08-31 12:19	2026-08-31 12:19	2026-08-31 12:19	SHOP	SHOP280121P00165000	put	165.0000	2028-01-21	43.5600	43.3000	44.0500	146.8400	69695.00	4365.00	65330.00	16	8	46	117	0.393162393162393	0.545076679716453	0.546558670019266	false	false	false	true
10d455b7-e5b5-4ea7-b055-650271b9737b	2026-08-31 10:26	2026-08-31 10:26	2026-08-31 10:26	SHOP	SHOP270917C00200000	call	200.0000	2027-09-17	17.9500	17.8500	18.3000	145.8700	52055.00	14360.00	37695.00	29	7	281	98	2.86734693877551	0.541271365287268	0.541271365287268	false	false	false	true
04f00c1b-aa6b-4c80-92cb-9dec5b84adcf	2026-08-31 10:26	2026-08-31 10:26	2026-08-31 10:26	SHOP	SHOP270917C00200000	call	200.0000	2027-09-17	17.9900	17.9500	18.3000	145.9200	88145.00	34295.00	53850.00	49	5	212	98	2.16326530612245	0.540917399455911	0.54263909441951	false	false	false	true
a2ad44d7-caf1-408a-ac3a-46a60ee2f66d	2026-08-31 10:26	2026-08-31 10:26	2026-08-31 10:26	SHOP	SHOP270917C00210000	call	210.0000	2027-09-17	16.0300	15.9000	16.2500	145.7705	72140.00	36945.00	35195.00	45	10	49	106	0.462264150943396	0.542407404759526	0.543289721776726	false	false	false	true
d64fc5dd-337c-45b9-9a2b-8b90ef618515	2026-08-31 10:26	2026-08-31 10:26	2026-08-31 10:26	SHOP	SHOP270917C00200000	call	200.0000	2027-09-17	18.0100	18.0000	18.7000	145.8300	59440.00	1835.00	57605.00	33	10	33	98	0.336734693877551	0.542416141107112	0.548440320807979	false	false	false	true
d09ae84b-3cee-4cc3-a577-6610836497ad	2026-08-31 09:44	2026-08-31 09:44	2026-08-31 09:44	SHOP	SHOP260925P00140000	put	140.0000	2026-09-25	3.7000	3.4000	3.8500	146.7600	65110.00	64375.00	735.00	176	26	176	307	0.57328990228013	0.44608691510518	0.442414796858088	false	false	false	true
d6577d0c-c239-482f-9674-bf1c8b5bb86c	2026-08-31 09:43	2026-08-31 09:43	2026-08-31 09:43	SHOP	SHOP260918P00160000	put	160.0000	2026-09-18	14.5000	14.5000	15.3000	147.1400	50750.00	0.00	50750.00	35	35	44	657	0.0669710806697108	0.466828385928789	0.466828385928789	false	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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