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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×endpoint = /api/option-trades/flow-alerts×ticker = SFM×

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

c276ae90-5e3e-42f8-8ec2-f621b5d6b4e3	2026-10-01 13:13	2026-10-01 13:13	2026-10-01 13:13	SFM	SFM261218P00060000	put	60.0000	2026-12-18	2.9000	2.7000	3.0000	66.0000	39150.00	290.00	38860.00	135	28	136	717	0.189679218967922	0.490902182048195	0.490902182048195	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	6012606860.00	2026-10-28	postmarket	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T17:13:55.640440Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
9459bf4b-533b-4435-bc66-583588160206	2026-09-28 10:53	2026-09-28 10:53	2026-09-28 10:53	SFM	SFM270115P00065000	put	65.0000	2027-01-15	6.9000	6.7000	6.9000	63.7550	124190.00	124190.00	0.00	180	27	262	1005	0.260696517412935	0.481305274069875	0.481305274069875	false	false	false
4c7866a2-1435-4482-b83a-c3f08f516957	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SFM	SFM261016P00060000	put	60.0000	2026-10-16	1.2000	1.1500	1.3500	62.0000	16200.00	1200.00	15000.00	135	10	1118	1254	0.891547049441786	0.392628658579152	0.392628658579152	false	false	false
b67caba2-e41d-4d61-a884-281d0ec9071c	2026-09-25 15:59	2026-09-25 15:59	2026-09-25 15:59	SFM	SFM261016P00060000	put	60.0000	2026-10-16	1.2000	1.1500	1.2500	62.0000	12480.00	2640.00	8160.00	104	8	976	1254	0.778309409888357	0.395517937445556	0.395517937445556	false	false	false
75c2be96-3023-423e-81b1-7db6129797e3	2026-09-25 15:18	2026-09-25 15:18	2026-09-25 15:18	SFM	SFM270115C00070000	call	70.0000	2027-01-15	4.3000	4.1000	4.3000	63.3050	21070.00	21070.00	0.00	49	8	56	65	0.861538461538462	0.466429687129227	0.466429687129227	false	false	false
d3a3d31f-f3fd-4ecc-bd03-b56681398e22	2026-09-25 15:16	2026-09-25 15:16	2026-09-25 15:16	SFM	SFM261016P00060000	put	60.0000	2026-10-16	1.0500	0.9500	1.2000	63.3400	42004.00	5985.00	36019.00	400	16	624	1254	0.497607655502392	0.405041492267604	0.407175791967367	false	false	false
09a11e30-b009-4758-a32c-06c254bb5b15	2026-09-25 12:54	2026-09-25 12:54	2026-09-25 12:54	SFM	SFM270115P00065000	put	65.0000	2027-01-15	6.8000	6.6000	6.8000	63.8900	77518.00	77518.00	0.00	114	14	187	1030	0.181553398058252	0.473058006761858	0.473058006761858	false	false	false
9155e53f-cdea-48c2-ba11-0b95385bcd3c	2026-09-25 11:59	2026-09-25 11:59	2026-09-25 11:59	SFM	SFM270115P00065000	put	65.0000	2027-01-15	6.6000	6.4000	6.6000	64.0000	45540.00	45540.00	0.00	69	16	73	1030	0.070873786407767	0.469394310529676	0.469394310529676	false	false	false
f50feaf8-1f5d-47e5-ae51-384cdc534c5d	2026-09-24 15:03	2026-09-24 15:03	2026-09-24 15:03	SFM	SFM261218C00070000	call	70.0000	2026-12-18	4.5000	4.3000	5.0000	65.4300	29700.00	24750.00	4950.00	66	9	78	52	1.5	0.484420977748082	0.484420977748082	false	false	false
40082471-61bd-4125-8aab-b5ac7401b59e	2026-09-23 14:53	2026-09-23 14:53	2026-09-23 14:53	SFM	SFM261218C00090000	call	90.0000	2026-12-18	0.9500	0.8000	0.9500	66.7450	34286.00	34286.00	0.00	361	29	553	824	0.671116504854369	0.484032080985684	0.484032080985684	false	false	false
81c3d690-c30e-44df-ae90-c6204d368bf5	2026-09-22 15:06	2026-09-22 15:06	2026-09-22 15:06	SFM	SFM270115C00090000	call	90.0000	2027-01-15	1.6000	1.4500	1.6000	68.2300	16160.00	16160.00	0.00	101	21	105	3080	0.0340909090909091	0.459855182461826	0.459855182461826	false	false	false
a6bb465d-79aa-4637-9988-65c2c31a567b	2026-09-22 09:45	2026-09-22 09:44	2026-09-22 09:44	SFM	SFM261218P00065000	put	65.0000	2026-12-18	3.7000	3.6000	4.0000	70.0000	56240.00	28860.00	740.00	152	11	153	687	0.222707423580786	0.472507581063705	0.472507581063705	false	false	false
4f7e573b-2010-410b-a299-010afb2d6a25	2026-09-21 12:26	2026-09-21 12:26	2026-09-21 12:26	SFM	SFM270115P00065000	put	65.0000	2027-01-15	4.3000	4.3000	4.4000	70.3700	36980.00	0.00	36980.00	86	22	193	838	0.230310262529833	0.463194174995609	0.463194174995609	false	false	false
537c180a-93e1-4d7e-87ed-34937726d54c	2026-09-21 10:16	2026-09-21 10:16	2026-09-21 10:16	SFM	SFM270115P00065000	put	65.0000	2027-01-15	4.4000	4.4000	4.6000	70.0000	43121.00	0.00	43121.00	98	26	98	838	0.116945107398568	0.467948926969176	0.468957601543358	false	false	false
884400bc-370d-4199-9e56-af197febeb61	2026-09-18 14:15	2026-09-18 14:15	2026-09-18 14:15	SFM	SFM261218C00080000	call	80.0000	2026-12-18	3.7000	3.6000	3.7000	70.9900	24790.00	12210.00	0.00	67	5	72	228	0.315789473684211	0.472603059523561	0.472603059523561	false	false	false
5b41e026-a92b-4e69-a64c-2d776e6a64a4	2026-09-18 13:57	2026-09-18 13:57	2026-09-18 13:57	SFM	SFM261120P00060000	put	60.0000	2026-11-20	1.4800	1.3500	1.5000	70.9950	39960.00	39960.00	0.00	270	6	589	6	98.1666666666667	0.497838967369091	0.497838967369091	false	false	false
7a3dbf8b-1455-4605-a7cf-a0e81983a177	2026-09-18 13:51	2026-09-18 13:51	2026-09-18 13:51	SFM	SFM261218P00065000	put	65.0000	2026-12-18	3.6000	3.5000	3.7000	71.3950	22320.00	21240.00	0.00	62	16	66	659	0.100151745068285	0.48532918710886	0.48532918710886	false	false	false
e5599851-86f6-454c-a1ee-c11a32f17fb0	2026-09-18 09:58	2026-09-18 09:58	2026-09-18 09:58	SFM	SFM261120P00060000	put	60.0000	2026-11-20	1.6500	1.6500	1.9500	70.3400	51320.00	0.00	51320.00	311	33	313	6	52.1666666666667	0.504846756272419	0.504846756272419	false	false	false
9d2dd64c-a284-4543-ab83-6dae62216d94	2026-09-17 10:18	2026-09-17 10:18	2026-09-17 10:18	SFM	SFM260918P00075000	put	75.0000	2026-09-18	4.2000	3.7000	4.2000	70.8750	21000.00	21000.00	0.00	50	7	72	1807	0.0398450470392916	0.724598355434007	0.724598355434007	false	false	false
a1ce96b4-6d0e-422c-a812-516734fbf61b	2026-09-16 14:10	2026-09-16 14:10	2026-09-16 14:10	SFM	SFM261016P00080000	put	80.0000	2026-10-16	9.0000	8.4000	9.0000	71.6900	11700.00	11700.00	0.00	13	6	36	355	0.101408450704225	0.421302105319932	0.421302105319932	true	false	false
d74ef261-d4aa-45a5-bd15-59f304ecdf43	2026-09-16 10:27	2026-09-16 10:27	2026-09-16 10:27	SFM	SFM261016C00070000	call	70.0000	2026-10-16	4.4000	4.4000	4.7000	71.0000	103840.00	0.00	103840.00	236	34	238	106	2.24528301886792	0.426626832648381	0.426626832648381	false	false	false
840b3ec2-7737-44b9-a3ca-59306566b931	2026-09-11 11:19	2026-09-11 11:19	2026-09-11 11:19	SFM	SFM261218P00080000	put	80.0000	2026-12-18	11.6000	11.3000	11.7000	71.9450	106720.00	106720.00	0.00	92	21	93	169	0.550295857988166	0.479964873782941	0.479964873782941	false	false	false
27e4d8c6-40d9-4ab2-aaef-77676af7e6a9	2026-09-10 10:56	2026-09-10 10:56	2026-09-10 10:56	SFM	SFM261218C00095000	call	95.0000	2026-12-18	1.6000	1.4500	1.6000	72.8900	17600.00	17600.00	0.00	110	21	120	541	0.22181146025878	0.473640164710156	0.473640164710156	false	false	false
0d50e868-042b-4708-a99d-31bc8738944d	2026-09-09 14:00	2026-09-09 14:00	2026-09-09 14:00	SFM	SFM261218P00065000	put	65.0000	2026-12-18	2.9500	2.8500	2.9500	74.7200	19470.00	19470.00	0.00	66	5	213	287	0.742160278745645	0.481520595738239	0.481520595738239	false	false	false
39dddebf-ab96-48e7-a0b0-c902509a9e4e	2026-09-09 09:40	2026-09-09 09:40	2026-09-09 09:40	SFM	SFM270115C00110000	call	110.0000	2027-01-15	1.0000	0.9500	1.2000	75.5750	12000.00	9000.00	600.00	120	18	5320	3965	1.34174022698613	0.45373683612649	0.45373683612649	false	false	false
970d60fe-a48d-4b89-bafc-ece4ef9f7433	2026-09-09 09:40	2026-09-09 09:40	2026-09-09 09:40	SFM	SFM270115C00110000	call	110.0000	2027-01-15	1.0000	0.9500	1.0000	75.4500	18800.00	15800.00	0.00	188	18	4900	3965	1.23581336696091	0.455384605698024	0.455384605698024	false	false	false
6e5e5eb2-4c6d-4217-b1e5-c8a3d1b1b01a	2026-09-09 09:40	2026-09-09 09:40	2026-09-09 09:40	SFM	SFM270115C00110000	call	110.0000	2027-01-15	1.0000	0.9000	1.0000	75.5350	24500.00	1300.00	0.00	245	18	4492	3965	1.13291298865069	0.454263894018099	0.454263894018099	false	false	false
82d3e817-8f2e-4504-aa1f-7c26985ffef7	2026-09-09 09:40	2026-09-09 09:39	2026-09-09 09:39	SFM	SFM270115C00110000	call	110.0000	2027-01-15	1.0000	0.9000	1.0000	75.4900	15300.00	2000.00	0.00	153	14	4149	3965	1.04640605296343	0.454857090906173	0.454857090906173	false	false	false
479c5dc4-4f69-4141-9989-7a668118dd7a	2026-09-09 09:39	2026-09-09 09:38	2026-09-09 09:38	SFM	SFM270115C00110000	call	110.0000	2027-01-15	1.0000	1.0000	1.1000	75.4900	49900.00	0.00	49900.00	499	15	3531	3965	0.890542244640605	0.454857090906173	0.454857090906173	false	false	false
893a21b2-fdea-4eb0-8367-fc029c93b1af	2026-09-09 09:38	2026-09-09 09:38	2026-09-09 09:38	SFM	SFM270115C00110000	call	110.0000	2027-01-15	1.0500	1.0000	1.1000	75.4900	39375.00	37275.00	0.00	375	19	3032	3965	0.76469104665826	0.460627934360301	0.460627934360301	false	false	false
34834ed5-4ca9-427f-b19d-dd7212725350	2026-09-09 09:38	2026-09-09 09:38	2026-09-09 09:38	SFM	SFM270115C00110000	call	110.0000	2027-01-15	1.0000	0.9500	1.0500	75.4900	162400.00	0.00	11800.00	1624	7	2324	3965	0.586128625472888	0.454857090906173	0.454857090906173	false	false	false
7ac96dff-3647-4b3b-bd27-641db57f6072	2026-09-09 09:38	2026-09-09 09:38	2026-09-09 09:38	SFM	SFM270115C00110000	call	110.0000	2027-01-15	1.0000	0.9000	1.0000	75.4900	13100.00	6300.00	0.00	131	7	627	3965	0.158133669609079	0.454857090906173	0.454857090906173	false	false	false
eb32e413-af22-4341-8e3d-0e8563d6dbca	2026-09-08 12:21	2026-09-08 12:21	2026-09-08 12:21	SFM	SFM270115P00065000	put	65.0000	2027-01-15	3.4000	3.1000	3.4000	76.0900	74460.00	74460.00	0.00	219	19	229	433	0.528868360277136	0.482707269866716	0.482707269866716	false	false	false
fd6ac93d-f7b0-4e7e-a138-9576a1ff2484	2026-09-08 11:57	2026-09-08 11:56	2026-09-08 11:56	SFM	SFM260918P00075000	put	75.0000	2026-09-18	1.6100	1.6000	1.6500	76.2950	24500.00	5940.00	18560.00	152	21	239	1634	0.146266829865361	0.454922112082977	0.454922112082977	false	false	false
0034cf79-cd49-4a9d-911c-9c38b1c48bed	2026-09-08 10:27	2026-09-08 10:27	2026-09-08 10:27	SFM	SFM261218P00070000	put	70.0000	2026-12-18	3.8000	3.8000	4.4000	77.9200	11400.00	0.00	10260.00	30	8	30	304	0.0986842105263158	0.477283549860181	0.477283549860181	false	false	false
1c26e497-8629-47fd-bb93-b277115040b1	2026-09-02 14:11	2026-09-02 14:10	2026-09-02 14:10	SFM	SFM270319C00080000	call	80.0000	2027-03-19	11.5000	9.4000	11.5000	78.7450	166750.00	166750.00	0.00	145	9	145	148	0.97972972972973	0.489604825396096	0.489604825396096	false	false	false
135f6648-c903-4212-b1e9-3ba2d93efdbd	2026-09-02 13:10	2026-09-02 13:10	2026-09-02 13:10	SFM	SFM261016C00090000	call	90.0000	2026-10-16	1.1000	0.8500	1.1000	78.0100	16279.00	16279.00	0.00	148	24	156	417	0.37410071942446	0.417578419189388	0.417578419189388	true	false	false
c579fbb0-b401-4a13-9c9d-78be9e9c6eaf	2026-09-02 12:01	2026-09-02 12:01	2026-09-02 12:01	SFM	SFM270319C00075000	call	75.0000	2027-03-19	13.1000	11.5000	13.1000	77.3900	365490.00	365490.00	0.00	279	14	279	280	0.996428571428571	0.497159805381662	0.497159805381662	false	false	false
f46156fa-4646-4ec8-96a5-534792913c49	2026-08-31 11:30	2026-08-31 11:30	2026-08-31 11:30	SFM	SFM260918P00085000	put	85.0000	2026-09-18	4.8000	4.8000	5.6000	81.5950	11040.00	0.00	11040.00	23	7	37	483	0.0766045548654244	0.392600752535286	0.392600752535286	false	false	false
66791e4f-528a-4bb5-891f-e886b98821fa	2026-08-28 10:17	2026-08-28 10:17	2026-08-28 10:17	SFM	SFM260918P00085000	put	85.0000	2026-09-18	3.8000	3.6000	3.8000	83.6900	136800.00	136800.00	0.00	360	16	376	225	1.67111111111111	0.397910530923485	0.397910530923485	false	false	false
6f176e18-61d1-4174-8a49-20c73b8ba048	2026-08-26 13:42	2026-08-26 13:42	2026-08-26 13:42	SFM	SFM261016C00085000	call	85.0000	2026-10-16	5.4000	5.4000	5.6000	85.0397	39960.00	0.00	39960.00	74	22	128	338	0.378698224852071	0.407781550485552	0.407781550485552	false	false	false
5b11bd61-459f-4e99-88b5-f10a72e8b1e9	2026-08-25 13:40	2026-08-25 13:40	2026-08-25 13:40	SFM	SFM261016C00100000	call	100.0000	2026-10-16	1.2000	1.2000	1.3500	84.8000	14400.00	0.00	14400.00	120	6	1535	1591	0.964802011313639	0.420355594289466	0.420355594289466	false	false	false
5e1ce454-4c04-4bd2-b66e-7f4c72b904d1	2026-08-25 13:40	2026-08-25 13:40	2026-08-25 13:40	SFM	SFM261016C00100000	call	100.0000	2026-10-16	1.2000	1.2000	1.3500	84.7950	12000.00	0.00	12000.00	100	5	1395	1591	0.876807039597737	0.421101535498982	0.420462155154503	false	false	false
00f7a569-301b-460d-be70-ca9f4ed487e4	2026-08-25 13:36	2026-08-25 13:36	2026-08-25 13:36	SFM	SFM261016C00100000	call	100.0000	2026-10-16	1.2000	1.2000	1.3000	84.7550	30000.00	0.00	30000.00	250	19	1295	1591	0.813953488372093	0.421314668121472	0.421314668121472	false	false	false
ab602ea3-6667-4e27-8c34-0bcabd532490	2026-08-25 13:35	2026-08-25 13:35	2026-08-25 13:35	SFM	SFM261016C00100000	call	100.0000	2026-10-16	1.2000	1.0500	1.4000	84.8300	13560.00	13440.00	120.00	113	16	1044	1591	0.656191074795726	0.419716243995344	0.419716243995344	true	false	false
6abc7635-36d8-4b99-9708-40a3699fee24	2026-08-25 13:35	2026-08-25 13:35	2026-08-25 13:35	SFM	SFM261016C00100000	call	100.0000	2026-10-16	1.2000	1.0000	1.2500	84.8300	22680.00	9840.00	11520.00	189	10	931	1591	0.585166561910748	0.419716243995344	0.419716243995344	false	false	false
f3dcb843-eb61-409a-96e7-429c3690c60a	2026-08-25 13:35	2026-08-25 13:35	2026-08-25 13:35	SFM	SFM261016C00100000	call	100.0000	2026-10-16	1.1500	1.0500	1.2000	84.4600	23460.00	11270.00	4715.00	204	7	308	1591	0.193588937774984	0.421487605774762	0.421487605774762	true	false	false
dfa08adc-580c-4775-ba10-f1991ff5cadd	2026-08-25 13:35	2026-08-25 13:35	2026-08-25 13:35	SFM	SFM261016C00100000	call	100.0000	2026-10-16	1.2000	0.8500	1.2000	84.7900	45720.00	18120.00	0.00	381	8	690	1591	0.433689503456945	0.420568716736448	0.420568716736448	false	false	false
d348d53a-51f3-4a14-b389-90b80b7dfaee	2026-08-21 11:08	2026-08-21 11:08	2026-08-21 11:08	SFM	SFM270319P00055000	put	55.0000	2027-03-19	1.9500	1.6500	1.9500	80.5900	39000.00	39000.00	0.00	200	20	201	8	25.125	0.513073793766157	0.513073793766157	false	false	false
ec473504-e914-40de-9d32-211f53656edf	2026-08-21 09:31	2026-08-21 09:31	2026-08-21 09:31	SFM	SFM270115C00075000	call	75.0000	2027-01-15	11.9000	11.6000	12.7000	79.3500	121380.00	20230.00	101150.00	102	5	103	281	0.366548042704626	0.458835998061548	0.458835998061548	false	false	false