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

b9ba4684-5d19-4729-a582-e40f812ad85a	2026-09-23 15:40	2026-09-23 15:40	2026-09-23 15:40	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	5.1000	5.0000	5.2000	143.2100	24990.00	3060.00	1020.00	49	19	5185	7429	0.697940503432494	0.53902909685945	0.53902909685945	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	172027903192.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T19:42:45.926021Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
543f6b3e-1a4b-4615-9765-0226fe7d1a40	2026-09-23 15:40	2026-09-23 15:40	2026-09-23 15:40	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	5.1000	5.1000	5.2000	143.2250	10200.00	0.00	2040.00	20	10	5128	7429	0.690267869161394	0.538597923007251	0.538597923007251	false	false	false	true
f3e1f069-1c35-4622-a5cf-ae5a76685c64	2026-09-23 15:39	2026-09-23 15:39	2026-09-23 15:39	SHOP	SHOP261016C00150000	call	150.0000	2026-10-16	5.1000	5.1000	5.2000	143.2000	13260.00	0.00	3060.00	26	11	5103	7429	0.686902678691614	0.539316492600773	0.539316492600773	false	false	false	true
2ad5286b-4464-45e7-9346-79645a2d4e53	2026-09-23 15:32	2026-09-23 15:32	2026-09-23 15:32	SHOP	SHOP270617C00230000	call	230.0000	2027-06-17	9.2500	7.4000	9.2500	144.0000	121175.00	121175.00	0.00	131	8	132	375	0.352	0.583617764800057	0.583617764800057	false	false	false	true
8c0016a8-e748-45d8-a150-30debcaeae9b	2026-09-23 15:30	2026-09-23 15:30	2026-09-23 15:30	SHOP	SHOP280121P00135000	put	135.0000	2028-01-21	28.0000	28.0000	29.4000	143.0000	179220.00	0.00	179220.00	64	16	91	529	0.172022684310019	0.589071913424634	0.589071913424634	false	false	false	true
518d658c-b061-402c-af47-9e68ccefab95	2026-09-23 14:04	2026-09-23 14:04	2026-09-23 14:04	SHOP	SHOP260925C00144000	call	144.0000	2026-09-25	2.2800	2.1900	2.3800	142.3000	27360.00	0.00	27360.00	120	5	712	1041	0.683957732949087	0.719717301003196	0.719717301003196	true	false	false	true
3de533c1-926a-4b56-8346-04ad30e221cf	2026-09-23 13:13	2026-09-23 13:13	2026-09-23 13:13	SHOP	SHOP261030P00124000	put	124.0000	2026-10-30	2.8600	2.2700	3.4500	141.0000	38324.00	286.00	38038.00	134	13	168	15	11.2	0.54494164224363	0.545646904670303	false	false	false	true
cfaef421-375e-47e9-b1d4-5d38891cecd9	2026-09-23 12:45	2026-09-23 12:45	2026-09-23 12:45	SHOP	SHOP260925C00141000	call	141.0000	2026-09-25	4.0000	3.3500	4.0000	142.7800	11600.00	11600.00	0.00	29	6	661	517	1.27852998065764	0.718129470559598	0.718129470559598	false	false	false	true
8d718e7d-40be-4269-8be4-ad7626474a80	2026-09-23 12:42	2026-09-23 12:42	2026-09-23 12:42	SHOP	SHOP270617C00175000	call	175.0000	2027-06-17	18.7500	18.2500	19.0500	142.0000	58125.00	56250.00	1875.00	31	6	92	105	0.876190476190476	0.578899980094594	0.578899980094594	false	false	false	true
fac2f65d-36a1-4b6d-94f3-5c1291865b4e	2026-09-23 12:40	2026-09-23 12:40	2026-09-23 12:40	SHOP	SHOP270917P00145000	put	145.0000	2027-09-17	30.2100	30.1000	32.1500	142.0000	24170.00	6040.00	18130.00	8	6	9	88	0.102272727272727	0.582644867536181	0.582884521135938	true	false	false	true
75d787bf-0347-4869-8590-cfaf85f19e0d	2026-09-23 11:40	2026-09-23 11:40	2026-09-23 11:40	SHOP	SHOP261218C00140000	call	140.0000	2026-12-18	17.9000	17.9000	18.2500	142.5800	12530.00	0.00	12530.00	7	7	16	1455	0.0109965635738832	0.584071711966769	0.584071711966769	true	false	false	true
202d591d-b95d-4fde-90ce-c6b0740c9da3	2026-09-23 11:38	2026-09-23 11:37	2026-09-23 11:37	SHOP	SHOP260925C00141000	call	141.0000	2026-09-25	4.1000	3.7500	4.4500	142.9400	51250.00	50840.00	0.00	125	5	524	517	1.01353965183752	0.718754213549849	0.718754213549849	false	false	false	true
db7c0460-2bee-4f4d-902b-5801e3418c6d	2026-09-23 11:36	2026-09-23 11:36	2026-09-23 11:36	SHOP	SHOP270115P00130000	put	130.0000	2027-01-15	10.7500	10.3500	10.7500	142.7600	45150.00	45150.00	0.00	42	6	210	2910	0.0721649484536082	0.566127050706007	0.566127050706007	false	false	false	true
e04b9695-e4ba-43c7-8d2b-26e924746ddf	2026-09-23 11:36	2026-09-23 11:36	2026-09-23 11:36	SHOP	SHOP261120C00145000	call	145.0000	2026-11-20	13.5000	13.4500	13.6000	142.7750	193105.00	43360.00	149745.00	143	13	292	2177	0.134129536058797	0.62348229397742	0.62348229397742	false	false	false	true
1297ab05-6790-4529-abb3-b468c58900d1	2026-09-23 11:36	2026-09-23 11:36	2026-09-23 11:36	SHOP	SHOP261120C00140000	call	140.0000	2026-11-20	15.8100	15.8000	16.3500	142.7750	167620.00	12720.00	154900.00	106	6	119	743	0.160161507402423	0.625493308421123	0.625493308421123	false	false	false	true
dda4441e-b445-4e8c-9931-b4faab5dc7df	2026-09-23 11:24	2026-09-23 11:24	2026-09-23 11:24	SHOP	SHOP270319P00130000	put	130.0000	2027-03-19	15.3000	14.7000	15.3500	140.7600	85694.00	84169.00	1525.00	56	16	66	375	0.176	0.577401554947091	0.578816498838915	false	false	false	true
090e3e0a-34b2-4e23-9924-11b093da5f2a	2026-09-23 11:24	2026-09-23 11:24	2026-09-23 11:24	SHOP	SHOP270319P00120000	put	120.0000	2027-03-19	11.0500	10.6500	11.1000	140.7600	26520.00	24310.00	2210.00	24	11	26	601	0.043261231281198	0.579893652233984	0.579893652233984	false	false	false	true
383f40c4-e9c1-40ac-9a21-bcaa81ab28e2	2026-09-23 11:03	2026-09-23 11:03	2026-09-23 11:03	SHOP	SHOP261218P00125000	put	125.0000	2026-12-18	8.0000	8.0000	8.2500	140.2200	68810.00	0.00	68810.00	86	20	173	1210	0.14297520661157	0.579773059886735	0.581226327181443	false	false	false	true
18bce2eb-8c96-4c75-af35-930c10958c0b	2026-09-23 11:03	2026-09-23 11:03	2026-09-23 11:03	SHOP	SHOP261218P00125000	put	125.0000	2026-12-18	8.0500	7.8500	8.4000	140.1750	18520.00	16105.00	1610.00	23	5	87	1210	0.071900826446281	0.58285770657438	0.58285770657438	true	false	false	true
dda4feea-6a40-4caf-8fa4-b177090ef11d	2026-09-23 10:48	2026-09-23 10:48	2026-09-23 10:48	SHOP	SHOP261218C00170000	call	170.0000	2026-12-18	6.2000	5.7000	6.3500	138.5950	13020.00	12400.00	620.00	21	9	29	528	0.0549242424242424	0.579675641442854	0.579675641442854	false	false	false	true
5cce6716-80d2-474f-83ff-4e04dc475b3d	2026-09-23 10:38	2026-09-23 10:38	2026-09-23 10:38	SHOP	SHOP260925C00140000	call	140.0000	2026-09-25	2.3000	2.3000	2.4500	138.9300	18630.00	0.00	18630.00	81	6	1664	4748	0.350463352990733	0.677328065119137	0.677328065119137	false	false	false	true
dcd700eb-a80b-4cd1-9412-832d56bbba7b	2026-09-23 10:24	2026-09-23 10:24	2026-09-23 10:24	SHOP	SHOP260925C00138000	call	138.0000	2026-09-25	3.7500	3.7000	4.3000	139.5200	10880.00	3755.00	5625.00	29	24	278	946	0.293868921775899	0.713638067560965	0.710200410365055	true	false	false	true
7f3efb85-db30-4b8e-b62f-16ab0f6fbb5e	2026-09-23 10:23	2026-09-23 10:22	2026-09-23 10:22	SHOP	SHOP261016P00133000	put	133.0000	2026-10-16	4.2000	4.2000	5.4500	139.1801	74760.00	0.00	74760.00	178	30	224	84	2.66666666666667	0.51309072189767	0.51309072189767	false	false	false	true
d5b8691e-1c41-4935-8eaa-7ef6e6c5395e	2026-09-23 10:20	2026-09-23 10:20	2026-09-23 10:20	SHOP	SHOP260925P00134000	put	134.0000	2026-09-25	1.2000	1.1400	1.2000	138.9770	10080.00	10080.00	0.00	84	12	146	165	0.884848484848485	0.763597115003133	0.763597115003133	false	false	false	true
8af84d68-8d3b-4bcf-a55d-0fc9ae4efeca	2026-09-23 10:16	2026-09-23 10:16	2026-09-23 10:16	SHOP	SHOP271217C00250000	call	250.0000	2027-12-17	12.8000	12.8000	13.2000	137.2150	69126.00	0.00	69126.00	54	7	54	785	0.0687898089171975	0.584780556361003	0.584967896451781	false	false	false	true
efff6eea-863e-4afe-9499-7cfd792eddd1	2026-09-23 10:13	2026-09-23 10:13	2026-09-23 10:13	SHOP	SHOP261002C00140000	call	140.0000	2026-10-02	3.4900	3.4500	4.4000	137.0000	17430.00	12600.00	4830.00	50	5	200	465	0.43010752688172	0.526109186560601	0.526109186560601	false	false	false	true
bba1589f-5df7-46ac-9916-fdb8cf92f47e	2026-09-23 10:08	2026-09-23 10:08	2026-09-23 10:08	SHOP	SHOP270115P00130000	put	130.0000	2027-01-15	12.6500	12.4000	13.0000	137.4300	31625.00	6325.00	12650.00	25	5	40	2910	0.013745704467354	0.569265174012219	0.570815449644979	false	false	false	true
0ea2f056-1677-42d0-95bc-111c4c75cb11	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	SHOP	SHOP261023C00160000	call	160.0000	2026-10-23	2.7700	2.3300	2.8600	139.0000	151893.00	77808.00	74085.00	548	6	565	74	7.63513513513514	0.558207247921379	0.560314424111165	false	false	false	true
b251a97b-a5ce-46a7-bc05-1b701e7711c1	2026-09-23 10:03	2026-09-23 10:03	2026-09-23 10:03	SHOP	SHOP261120P00135000	put	135.0000	2026-11-20	10.0500	9.8000	10.2500	141.5850	30150.00	4020.00	26130.00	30	6	216	919	0.235038084874864	0.615286260201229	0.615286260201229	false	false	false	true
7943aa84-0e4b-4612-b8ef-631c2540053c	2026-09-23 10:02	2026-09-23 10:02	2026-09-23 10:02	SHOP	SHOP260925P00141000	put	141.0000	2026-09-25	2.4800	2.1300	2.5700	142.0000	23520.00	11950.00	11570.00	95	7	214	120	1.78333333333333	0.772099665401476	0.772099665401476	false	false	false	true
d776a1b3-94bb-40d7-ab19-89a393632f82	2026-09-23 10:00	2026-09-23 10:00	2026-09-23 10:00	SHOP	SHOP260925P00144000	put	144.0000	2026-09-25	3.9000	3.9000	4.1500	142.0000	12090.00	0.00	8580.00	31	15	226	363	0.622589531680441	0.759615216836453	0.759615216836453	false	false	false	true
74fbe8c3-be58-4d6a-acb1-61b7808113b7	2026-09-23 10:00	2026-09-23 10:00	2026-09-23 10:00	SHOP	SHOP260925P00142000	put	142.0000	2026-09-25	2.2000	2.2000	2.3700	144.0000	10560.00	0.00	10560.00	48	5	635	539	1.17810760667904	0.736759885960402	0.736759885960402	false	false	false	true
b5240647-2882-4804-8ae0-8775d018fee6	2026-09-23 09:59	2026-09-23 09:59	2026-09-23 09:59	SHOP	SHOP260925P00141000	put	141.0000	2026-09-25	1.8000	1.6000	1.9800	143.8600	15976.00	9113.00	6863.00	89	12	100	120	0.833333333333333	0.736151275370545	0.730403210967766	true	false	false	true
629d90e3-e7b6-4db7-938c-8c26d1f74af0	2026-09-23 09:49	2026-09-23 09:49	2026-09-23 09:49	SHOP	SHOP260925P00152500	put	152.5000	2026-09-25	5.3500	4.4500	5.3500	149.1300	13375.00	13375.00	0.00	25	7	31	201	0.154228855721393	0.769504194883586	0.769504194883586	false	false	false	true
350abb38-e7ef-4363-a8e3-aa3ddef0b969	2026-09-23 09:49	2026-09-23 09:49	2026-09-23 09:49	SHOP	SHOP260925P00155000	put	155.0000	2026-09-25	7.2000	6.2500	7.2000	149.1300	30240.00	30240.00	0.00	42	14	42	15	2.8	0.789324691204596	0.789324691204596	false	false	false	true
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
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