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:alert_rule = RepeatedHits×ticker = SFM×

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

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	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	6404246885.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:10:39.996631Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
f2abb7ee-60bc-4f39-b2aa-920aca0fd01a	2026-08-18 11:55	2026-08-18 11:55	2026-08-18 11:55	SFM	SFM270115C00100000	call	100.0000	2027-01-15	3.3000	2.9000	3.3000	79.5400	41910.00	41910.00	0.00	127	10	652	1542	0.422827496757458	0.444035458416734	0.444035458416734	false	false	false	true
f4d6add9-1dcf-4b1c-8859-81c2b0db55fa	2026-08-18 11:55	2026-08-18 11:55	2026-08-18 11:55	SFM	SFM270115C00100000	call	100.0000	2027-01-15	3.3000	2.9000	3.3000	79.6500	20790.00	20790.00	0.00	63	6	525	1542	0.340466926070039	0.442265706887252	0.442265706887252	false	false	false	true
6d9b8018-f6a0-43ea-8c05-c01a9aa6dffd	2026-08-18 11:54	2026-08-18 11:54	2026-08-18 11:54	SFM	SFM270115C00100000	call	100.0000	2027-01-15	3.3000	2.9000	3.3000	79.5200	99000.00	99000.00	0.00	300	37	408	1542	0.264591439688716	0.444357340784861	0.444357340784861	false	false	false	true
9a59504f-76d9-434e-9941-cb78ad30002f	2026-08-17 13:06	2026-08-17 13:06	2026-08-17 13:06	SFM	SFM261218P00080000	put	80.0000	2026-12-18	7.7000	7.7000	7.9000	80.5900	10010.00	0.00	3850.00	13	13	60	109	0.55045871559633	0.461445066412561	0.461445066412561	false	false	false	true
10596db0-4784-4038-a80e-6fb3c9a543eb	2026-08-17 13:06	2026-08-17 13:06	2026-08-17 13:06	SFM	SFM261218P00080000	put	80.0000	2026-12-18	7.7000	7.4000	7.7000	80.6650	10010.00	10010.00	0.00	13	13	47	109	0.431192660550459	0.463153069308287	0.463153069308287	false	false	false	true
2d416834-aced-48c4-a07f-0abfc6f9c4b0	2026-08-17 13:06	2026-08-17 13:06	2026-08-17 13:06	SFM	SFM261218P00080000	put	80.0000	2026-12-18	7.7000	7.5000	7.8000	80.6650	10010.00	1540.00	2310.00	13	13	34	109	0.311926605504587	0.463153069308287	0.463153069308287	false	false	false	true
7ca67b67-5180-48b2-9972-5b7136f960cc	2026-08-17 13:06	2026-08-17 13:06	2026-08-17 13:06	SFM	SFM261218P00080000	put	80.0000	2026-12-18	7.7000	7.5000	7.8000	80.6750	10010.00	770.00	2310.00	13	13	21	109	0.192660550458716	0.463380340414018	0.463380340414018	false	false	false	true