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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsDescendingFill×ticker = MCD×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

268ea930-1bc5-43d0-85e1-f6e3ed2b7dd3	2026-09-24 15:12	2026-09-24 15:12	2026-09-24 15:12	MCD	MCD261016C00240000	call	240.0000	2026-10-16	4.3500	4.3000	4.5000	238.2601	43520.00	34800.00	8720.00	100	5	495	690	0.717391304347826	0.2103360558366	0.209906522820835	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Cyclical	168645129668.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T19:15:33.602136Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
eeed07f3-079b-4558-be71-87b37885de4e	2026-09-24 11:39	2026-09-24 11:39	2026-09-24 11:39	MCD	MCD280121C00300000	call	300.0000	2028-01-21	11.7700	11.5500	11.9500	240.0000	20015.00	5900.00	12935.00	17	7	427	5462	0.0781764921274258	0.230547593418789	0.230045343217245	false	false	false	true
c7372b26-eac5-4def-9709-9d6b75115152	2026-09-24 10:33	2026-09-24 10:33	2026-09-24 10:33	MCD	MCD280121C00300000	call	300.0000	2028-01-21	11.6300	11.5500	12.2000	240.4350	17440.00	3495.00	13945.00	15	9	299	5462	0.0547418528011717	0.229510109654872	0.229006271260696	false	false	false	true
70fbae64-42de-49db-b364-0632a826c992	2026-09-24 10:11	2026-09-24 10:11	2026-09-24 10:11	MCD	MCD261218C00235000	call	235.0000	2026-12-18	14.5600	14.3500	15.0000	240.7750	20379.00	18921.00	1458.00	14	5	64	233	0.274678111587983	0.217889804048336	0.219744711271589	false	false	false	true
244674e6-c257-456a-afc0-73b98333b066	2026-09-24 09:39	2026-09-24 09:38	2026-09-24 09:38	MCD	MCD270917P00195000	put	195.0000	2027-09-17	5.4500	5.2000	5.8500	240.8400	37070.00	3280.00	33790.00	68	17	77	775	0.0993548387096774	0.277056425016456	0.276206385041203	false	false	false	true
9baa3cda-d850-499b-95a5-c5a11fb3058d	2026-09-23 15:58	2026-09-23 15:58	2026-09-23 15:58	MCD	MCD261120C00235000	call	235.0000	2026-11-20	11.5500	11.5500	11.6500	238.0000	35809.00	0.00	35809.00	31	6	313	18	17.3888888888889	0.243400515488143	0.242310708473512	false	false	false	true
c0b82d3e-6541-4627-bf60-422336fb829a	2026-09-23 13:59	2026-09-23 13:59	2026-09-23 13:59	MCD	MCD261016C00245000	call	245.0000	2026-10-16	2.7000	2.6900	2.8000	237.6450	180150.00	151200.00	25650.00	667	5	3803	45	84.5111111111111	0.226813681019123	0.224472172569646	true	false	false	true
36a8fd7e-4f67-48ab-b1d7-e49b533d64f1	2026-09-23 13:12	2026-09-23 13:12	2026-09-23 13:12	MCD	MCD260925C00240000	call	240.0000	2026-09-25	0.6500	0.6100	0.7200	235.0000	12289.00	0.00	12289.00	189	11	4599	49	93.8571428571429	0.329811794810129	0.327794158819431	true	false	false	true
b2d3f1b5-bb86-414d-809a-cddc09bf2ac8	2026-09-23 11:50	2026-09-23 11:50	2026-09-23 11:50	MCD	MCD260925P00235000	put	235.0000	2026-09-25	1.5700	1.5000	1.6300	236.0000	12123.00	7964.00	4159.00	77	17	2904	510	5.69411764705882	0.33021073738713	0.323269307138466	true	false	false	true
91140289-5ebf-4389-8185-62560582cda0	2026-09-23 10:03	2026-09-23 10:03	2026-09-23 10:03	MCD	MCD270115C00250000	call	250.0000	2027-01-15	9.0700	9.0000	9.4500	238.7300	13600.00	0.00	13600.00	15	5	260	991	0.262361251261352	0.236548363825709	0.232726116453533	false	false	false	true
86b82922-0519-4139-924d-a5e4c2157298	2026-09-23 09:49	2026-09-23 09:49	2026-09-23 09:49	MCD	MCD261120C00275000	call	275.0000	2026-11-20	1.6000	1.5700	1.7000	241.6750	15033.00	0.00	15033.00	94	30	1977	948	2.08544303797468	0.262927263054101	0.262280042080813	true	false	false	true
5578c208-3068-4c1c-84b4-1d1eea2aa853	2026-09-23 09:49	2026-09-23 09:49	2026-09-23 09:49	MCD	MCD261120C00275000	call	275.0000	2026-11-20	1.6000	1.6000	1.7000	241.8800	13768.00	0.00	13768.00	86	20	1881	948	1.98417721518987	0.261938871429539	0.261454450962462	false	false	false	true
e9aebdda-2d62-44ec-85a2-e94b3774cc8f	2026-09-22 14:01	2026-09-22 14:01	2026-09-22 14:01	MCD	MCD270319P00260000	put	260.0000	2027-03-19	20.7100	20.2000	20.9000	250.6900	20714.00	20714.00	0.00	10	6	20	1157	0.017286084701815	0.265724587222375	0.265724587222375	false	false	false	true
b360f924-4870-4fbb-9d55-071acff1f904	2026-09-22 10:10	2026-09-22 10:10	2026-09-22 10:10	MCD	MCD261023C00270000	call	270.0000	2026-10-23	1.2400	0.9400	1.3900	251.0400	12200.00	6151.00	6049.00	98	6	116	109	1.06422018348624	0.224932069486354	0.223770187862189	false	false	false	true
86c1c3d3-d4cd-4309-b338-ee5864f6adaa	2026-09-22 09:51	2026-09-22 09:51	2026-09-22 09:51	MCD	MCD260925C00247500	call	247.5000	2026-09-25	5.2200	5.0500	5.7000	251.0500	37069.00	0.00	37069.00	71	11	122	1525	0.08	0.342976339133939	0.342976339133939	false	false	false	true
882075d4-1369-47b8-9ea9-fa4c0dd35c38	2026-09-21 11:13	2026-09-21 11:13	2026-09-21 11:13	MCD	MCD261120C00250000	call	250.0000	2026-11-20	9.4300	9.4000	9.5500	248.0550	13205.00	3780.00	4700.00	14	7	367	757	0.484808454425363	0.238855618398616	0.238791412306392	false	false	false	true
db82e9ff-dc83-4079-bb7c-db9797e937d6	2026-09-21 11:05	2026-09-21 11:05	2026-09-21 11:05	MCD	MCD261218C00280000	call	280.0000	2026-12-18	2.3500	2.3200	2.5000	247.5100	36136.00	0.00	36136.00	154	15	163	1325	0.123018867924528	0.227576622507412	0.226594840116512	false	false	false	true
e11680cc-2726-49a4-986c-42f3c6385b84	2026-09-17 15:00	2026-09-17 15:00	2026-09-17 15:00	MCD	MCD260918C00250000	call	250.0000	2026-09-18	1.2100	1.1900	1.2500	249.8300	80207.00	48077.00	17850.00	664	17	1349	534	2.52621722846442	0.247241296359367	0.252995859820707	true	false	false	true
83050f6b-fe3a-4293-b74d-add8fbe178a3	2026-09-17 15:00	2026-09-17 15:00	2026-09-17 15:00	MCD	MCD261120C00250000	call	250.0000	2026-11-20	10.7500	10.6000	10.7500	249.8300	88111.00	88111.00	0.00	82	9	92	557	0.165170556552962	0.238316813970611	0.238316813970611	false	false	false	true
65bb08d7-8668-4bf1-bca0-5b76999050ee	2026-09-17 10:47	2026-09-17 10:47	2026-09-17 10:47	MCD	MCD261016P00250000	put	250.0000	2026-10-16	5.9000	5.7500	5.9000	249.5300	198228.00	198228.00	0.00	336	38	412	2811	0.146567057986482	0.216007158925028	0.216007158925028	false	false	false	true
31ee14a8-6f22-4044-8466-2eb085da1d1e	2026-09-16 10:43	2026-09-16 10:43	2026-09-16 10:43	MCD	MCD270115C00300000	call	300.0000	2027-01-15	1.8600	1.7500	1.8700	249.6300	65348.00	65164.00	184.00	351	17	664	8629	0.0769498203731603	0.236297714521301	0.235946889004217	false	false	false	true
646281ce-1513-4577-90e8-22c3bcbd177d	2026-09-14 09:45	2026-09-14 09:45	2026-09-14 09:45	MCD	MCD280121C00250000	call	250.0000	2028-01-21	36.9900	35.8500	37.6500	257.0000	81375.00	81375.00	0.00	22	6	26	608	0.0427631578947368	0.212759052683531	0.212664534211572	false	false	false	true
a143e36a-ad3a-4a08-8927-d26cf075cb96	2026-09-10 11:29	2026-09-10 11:29	2026-09-10 11:29	MCD	MCD270319C00300000	call	300.0000	2027-03-19	4.6000	4.4000	4.7000	253.6400	87328.00	52828.00	2300.00	190	6	262	2780	0.0942446043165468	0.228108403849499	0.228108403849499	false	false	false	true
f52caaba-faf7-496c-912e-5761f736b3e1	2026-09-08 13:36	2026-09-08 13:36	2026-09-08 13:36	MCD	MCD280121C00240000	call	240.0000	2028-01-21	40.9000	40.3500	41.0000	256.1100	327230.00	327230.00	0.00	80	7	162	151	1.07284768211921	0.203451174178911	0.203183985654107	false	false	false	true
f29725bb-7697-4615-a196-6d66d0468320	2026-09-03 15:22	2026-09-03 15:22	2026-09-03 15:22	MCD	MCD270617C00280000	call	280.0000	2027-06-17	14.9900	14.7000	15.2000	259.5850	50975.00	37475.00	13500.00	34	13	137	4742	0.0288907633909743	0.215516506562548	0.215516506562548	false	false	false	true
992094dc-838a-4e6c-8a63-429203b56c3f	2026-09-01 13:49	2026-09-01 13:49	2026-09-01 13:49	MCD	MCD270319P00270000	put	270.0000	2027-03-19	20.1200	19.6000	20.1500	262.0300	74435.00	56390.00	18045.00	37	17	41	489	0.0838445807770961	0.247894846604313	0.247894846604313	false	false	false	true
5d605176-e261-4a45-b28f-64bbbeab5696	2026-08-31 15:48	2026-08-31 15:48	2026-08-31 15:48	MCD	MCD261016P00255000	put	255.0000	2026-10-16	3.6500	3.4000	3.6500	265.0500	115185.00	104385.00	10800.00	316	36	384	726	0.528925619834711	0.219287836554711	0.219287836554711	false	false	false	true
80a81ec0-73f5-4855-97d6-c53c423668d3	2026-08-26 11:18	2026-08-26 11:18	2026-08-26 11:18	MCD	MCD270617C00290000	call	290.0000	2027-06-17	14.6300	14.1500	14.6500	267.2100	52680.00	51220.00	0.00	36	36	39	676	0.0576923076923077	0.210996787239151	0.211226532740073	false	false	false	true
c46e1156-6b4b-4bcf-8431-58b6584f0ff1	2026-08-25 10:32	2026-08-25 10:32	2026-08-25 10:32	MCD	MCD260918P00300000	put	300.0000	2026-09-18	31.1900	29.4500	31.2000	270.8000	77964.00	74849.00	0.00	25	8	95	617	0.153970826580227	0.410566560977174	0.410026792161164	false	false	false	true
c00b525a-b409-496d-8ea5-3643b4a27360	2026-08-25 10:29	2026-08-25 10:29	2026-08-25 10:29	MCD	MCD260918P00290000	put	290.0000	2026-09-18	21.3300	20.2000	21.3500	270.9550	53330.00	53330.00	0.00	25	6	64	1100	0.0581818181818182	0.332071795614513	0.329719267170341	false	false	false	true
c58f4efb-7bbc-426c-bf66-e1c485a7ad8c	2026-08-25 10:12	2026-08-25 10:12	2026-08-25 10:12	MCD	MCD260918C00262500	call	262.5000	2026-09-18	10.0500	10.0500	11.7000	271.1550	56287.00	0.00	56287.00	56	8	56	0	0	0.134780361859946	0.137204342257708	false	false	false	true
ec1b66f7-9907-4f4e-90e9-f1f9b8d76074	2026-08-25 09:51	2026-08-25 09:51	2026-08-25 09:51	MCD	MCD260918C00265000	call	265.0000	2026-09-18	8.3800	7.8000	8.4000	270.5719	108094.00	68849.00	39245.00	129	13	137	369	0.371273712737127	0.172970756359911	0.165109221569946	false	false	false	true
73a50054-b56f-41e2-9a79-d546b6c238d4	2026-08-18 10:10	2026-08-18 10:10	2026-08-18 10:10	MCD	MCD280121C00260000	call	260.0000	2028-01-21	38.4700	36.1000	38.5000	268.4900	384655.00	127040.00	0.00	100	8	104	419	0.248210023866348	0.204615127761229	0.204615127761229	false	false	false	true