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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 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 = AFRM×

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

2ff7e75f-6228-46d6-b6c0-03587f2e0e1a	2026-09-30 15:45	2026-09-30 15:45	2026-09-30 15:45	AFRM	AFRM261002C00072000	call	72.0000	2026-10-02	0.5200	0.4000	0.5200	69.6800	26208.00	26208.00	0.00	504	24	986	374	2.63636363636364	0.657913598334189	0.657913598334189	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	20573919967.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T19:46:40.965849Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
b13ea697-41aa-48fc-ba63-7a2fc3c700a0	2026-09-30 14:06	2026-09-30 14:06	2026-09-30 14:06	AFRM	AFRM261016C00072500	call	72.5000	2026-10-16	2.0300	2.0200	2.2500	69.6000	68575.00	60697.00	7878.00	338	11	352	416	0.846153846153846	0.543051320562584	0.544843259131457	false	false	false
3c95dc6e-406e-463c-a4a7-d54e8a80ae2f	2026-09-30 12:29	2026-09-30 12:29	2026-09-30 12:29	AFRM	AFRM261120P00065000	put	65.0000	2026-11-20	4.1000	3.9000	4.2500	70.0600	41820.00	41410.00	410.00	102	6	134	928	0.144396551724138	0.644846164595654	0.645018369605427	false	false	false
be723f3d-7ace-4dd1-b8b3-ce8bc1623fb9	2026-09-30 11:50	2026-09-30 11:50	2026-09-30 11:50	AFRM	AFRM261120C00080000	call	80.0000	2026-11-20	3.2500	3.0000	3.2500	69.0000	10710.00	9750.00	960.00	33	10	43	1709	0.0251609128145114	0.642978544135922	0.642978544135922	false	false	false
69f10149-1728-4c28-afd7-08fb1c83bb1d	2026-09-30 11:50	2026-09-30 11:50	2026-09-30 11:50	AFRM	AFRM261120C00070000	call	70.0000	2026-11-20	6.8000	6.5000	6.8000	69.0000	244795.00	244120.00	675.00	360	30	366	1137	0.321899736147757	0.653275880575063	0.653275880575063	true	false	false
06763821-e516-404b-9048-21e71e01d785	2026-09-30 11:50	2026-09-30 11:50	2026-09-30 11:50	AFRM	AFRM261030C00070000	call	70.0000	2026-10-30	4.3500	4.0500	4.3500	69.0000	59595.00	59595.00	0.00	137	20	138	46	3	0.552884454459018	0.552884454459018	true	false	false
f2706f98-9b02-4cc2-b7e9-4cab90fee4ae	2026-09-30 09:48	2026-09-30 09:48	2026-09-30 09:48	AFRM	AFRM261002P00069000	put	69.0000	2026-10-02	1.1000	1.0600	1.4400	69.0000	22111.00	0.00	22111.00	201	8	201	508	0.395669291338583	0.711273339506438	0.710260836460302	true	false	false
494a221b-ce88-4b2e-9553-e2c671084a3f	2026-09-29 15:08	2026-09-29 15:08	2026-09-29 15:08	AFRM	AFRM270115P00077500	put	77.5000	2027-01-15	12.9000	12.9000	13.0500	69.6600	11610.00	0.00	11610.00	9	5	15	226	0.0663716814159292	0.574233855783533	0.574233855783533	false	false	false
fab213db-3686-49bd-8115-18efc70398f7	2026-09-29 14:55	2026-09-29 14:55	2026-09-29 14:55	AFRM	AFRM270319C00075000	call	75.0000	2027-03-19	9.7500	9.5500	9.9000	69.5600	57525.00	14625.00	42900.00	59	10	154	195	0.78974358974359	0.598264338589019	0.598264338589019	false	false	false
07363905-2f81-43d4-bbcb-7524233b7281	2026-09-29 14:32	2026-09-29 14:32	2026-09-29 14:32	AFRM	AFRM261016P00070000	put	70.0000	2026-10-16	3.7000	3.7000	3.8500	69.0000	12950.00	0.00	12950.00	35	5	396	2598	0.152424942263279	0.556516797327866	0.556516797327866	false	false	false
9a137c98-3d37-45ea-b954-03cc4d247334	2026-09-29 13:23	2026-09-29 13:23	2026-09-29 13:23	AFRM	AFRM261009C00069000	call	69.0000	2026-10-09	2.4100	2.0600	2.4100	68.3600	57117.00	57117.00	0.00	237	13	247	72	3.43055555555556	0.592037993437349	0.592037993437349	false	false	false
628e81a5-2a74-46e9-bc89-d0b701abc466	2026-09-29 13:23	2026-09-29 13:23	2026-09-29 13:23	AFRM	AFRM261023P00069000	put	69.0000	2026-10-23	3.9100	3.9000	4.3000	68.3600	45386.00	0.00	45386.00	116	5	136	12	11.3333333333333	0.523018360076598	0.525878759809091	false	false	false
0387ddbc-ee10-4855-9ae9-61910ae9ad96	2026-09-29 13:23	2026-09-29 13:23	2026-09-29 13:23	AFRM	AFRM261016C00067500	call	67.5000	2026-10-16	3.8500	3.5500	3.8500	68.3600	80465.00	80465.00	0.00	209	11	209	104	2.00961538461538	0.570842902247751	0.570842902247751	false	false	false
7ec2cfb1-54ae-4d44-be48-9042f69dd7ee	2026-09-29 11:44	2026-09-29 11:43	2026-09-29 11:43	AFRM	AFRM270115C00087500	call	87.5000	2027-01-15	3.0500	2.8200	3.0500	68.4200	12810.00	12810.00	0.00	42	11	42	208	0.201923076923077	0.566428414265513	0.566428414265513	false	false	false
2f0691b9-9f70-4894-892d-7357a39ccd62	2026-09-29 11:44	2026-09-29 11:43	2026-09-29 11:43	AFRM	AFRM270115C00072500	call	72.5000	2027-01-15	7.1000	6.8000	7.1000	68.4200	41180.00	41180.00	0.00	58	14	58	378	0.153439153439153	0.567594757531538	0.567594757531538	false	false	false
6c0d1ea9-5de7-4a2d-a311-5999bf008e4d	2026-09-29 10:22	2026-09-29 10:22	2026-09-29 10:22	AFRM	AFRM261218C00075000	call	75.0000	2026-12-18	5.7000	5.4500	5.7500	69.1950	59275.00	58710.00	565.00	104	37	104	725	0.143448275862069	0.598787943315844	0.598787943315844	false	false	false
9491610a-d462-4793-bfdc-b94faddd8296	2026-09-29 10:09	2026-09-29 10:08	2026-09-29 10:08	AFRM	AFRM261016C00070000	call	70.0000	2026-10-16	3.1000	2.2500	3.1000	69.3300	101060.00	101060.00	0.00	326	5	331	1440	0.229861111111111	0.56145869557413	0.56145869557413	true	false	false
e0d85e27-421c-4c95-88d9-1aea82ef7871	2026-09-28 15:45	2026-09-28 15:45	2026-09-28 15:45	AFRM	AFRM261120P00057500	put	57.5000	2026-11-20	2.1500	2.1500	2.2100	67.7500	16340.00	0.00	16340.00	76	11	179	441	0.405895691609977	0.637579545872281	0.637579545872281	false	false	false
ecebddc3-98cc-4720-b482-48f16d729f7b	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	AFRM	AFRM261120C00087500	call	87.5000	2026-11-20	1.5200	1.3900	1.5300	68.0600	49856.00	49705.00	0.00	328	36	334	342	0.976608187134503	0.637878478980843	0.638505755020231	false	false	false
d2d60085-8988-492e-afa6-9275bb0dc647	2026-09-28 15:18	2026-09-28 15:18	2026-09-28 15:18	AFRM	AFRM261120C00085000	call	85.0000	2026-11-20	1.8500	1.7400	1.8600	68.0300	21438.00	17390.00	4048.00	116	22	159	864	0.184027777777778	0.634943993821447	0.633638043751817	false	false	false
02d0fd4c-7928-4c9f-b424-e0e750f4aa5a	2026-09-28 14:00	2026-09-28 14:00	2026-09-28 14:00	AFRM	AFRM261002C00073000	call	73.0000	2026-10-02	0.4200	0.4200	0.5000	68.4200	36246.00	0.00	36246.00	863	33	1548	201	7.70149253731343	0.637394899778292	0.637394899778292	false	false	false
7398afa9-673d-4292-a3b7-907ffd08c30f	2026-09-28 13:51	2026-09-28 13:51	2026-09-28 13:51	AFRM	AFRM261120C00075000	call	75.0000	2026-11-20	4.1500	4.1500	4.3000	68.5600	27390.00	0.00	27390.00	66	29	172	1210	0.142148760330579	0.619826994568893	0.619826994568893	true	false	false
2fde709e-1e23-4667-b11d-ba01d461de6f	2026-09-28 13:31	2026-09-28 13:31	2026-09-28 13:31	AFRM	AFRM270319C00100000	call	100.0000	2027-03-19	3.3200	3.3000	3.4500	68.5400	66350.00	0.00	66350.00	200	8	214	417	0.513189448441247	0.582673728398236	0.587977522669776	false	false	false
edb2afd5-80a7-4111-9fc6-b031c25f258e	2026-09-28 13:27	2026-09-28 13:27	2026-09-28 13:27	AFRM	AFRM261120P00060000	put	60.0000	2026-11-20	2.6900	2.5900	2.6900	68.6300	32011.00	32011.00	0.00	119	27	142	1393	0.101938262742283	0.635734170403258	0.635734170403258	false	false	false
5027c20b-6e2c-46af-9246-fe198346d810	2026-09-28 13:11	2026-09-28 13:11	2026-09-28 13:11	AFRM	AFRM270319P00075000	put	75.0000	2027-03-19	13.8000	13.8000	13.9000	68.8000	26220.00	0.00	26220.00	19	5	19	334	0.0568862275449102	0.584258073467473	0.584258073467473	false	false	false
69b25b36-e6c8-4bb4-a60f-441961f4422b	2026-09-28 12:27	2026-09-28 12:27	2026-09-28 12:27	AFRM	AFRM261016C00072500	call	72.5000	2026-10-16	2.0500	1.8100	2.0500	69.2700	12710.00	12710.00	0.00	62	8	70	463	0.151187904967603	0.537663713822546	0.537663713822546	false	false	false
8ee0516a-d9a4-4544-80b8-1de21f01d284	2026-09-28 12:23	2026-09-28 12:23	2026-09-28 12:23	AFRM	AFRM261030P00060000	put	60.0000	2026-10-30	1.0400	0.8900	1.1500	68.7300	26416.00	104.00	26312.00	254	9	260	77	3.37662337662338	0.532224984710982	0.532224984710982	false	false	false
8d3cd6ed-239a-4f12-8d1d-50ca80aa5df3	2026-09-28 11:17	2026-09-28 11:17	2026-09-28 11:17	AFRM	AFRM270319P00055000	put	55.0000	2027-03-19	4.3600	4.3000	4.5500	68.0000	43599.00	0.00	43599.00	100	5	503	3350	0.150149253731343	0.605751669592877	0.605751669592877	false	false	false
50f29300-928d-4957-8d74-9a226123dfe9	2026-09-28 11:16	2026-09-28 11:16	2026-09-28 11:16	AFRM	AFRM270319P00055000	put	55.0000	2027-03-19	4.3700	4.3000	4.5500	68.0000	43660.00	0.00	43660.00	100	5	303	3350	0.0904477611940298	0.605125125923746	0.605850745514496	false	false	false
99de1129-2156-4956-86e1-99c40257a46f	2026-09-28 11:13	2026-09-28 11:13	2026-09-28 11:13	AFRM	AFRM261218P00070000	put	70.0000	2026-12-18	7.9500	7.9000	8.0500	68.0000	11130.00	3180.00	7950.00	14	7	54	442	0.122171945701357	0.58565675242434	0.58565675242434	false	false	false
673f4a77-19ad-4883-91a7-11a3460dfd30	2026-09-28 10:27	2026-09-28 10:27	2026-09-28 10:27	AFRM	AFRM261002C00075000	call	75.0000	2026-10-02	0.3000	0.2400	0.3000	69.0000	18000.00	14910.00	0.00	600	33	693	583	1.18867924528302	0.64785571055654	0.64785571055654	false	false	false
b8259fa2-73e3-4385-878a-59f891d76b96	2026-09-28 10:23	2026-09-28 10:23	2026-09-28 10:23	AFRM	AFRM261120P00065000	put	65.0000	2026-11-20	4.3500	4.1000	4.3500	69.0000	21310.00	21310.00	0.00	49	7	49	912	0.0537280701754386	0.628790449135904	0.623627838812495	false	false	false
6cdc3f85-8a63-484b-a543-6b3a3e5a29ec	2026-09-28 10:23	2026-09-28 10:23	2026-09-28 10:23	AFRM	AFRM261120P00062500	put	62.5000	2026-11-20	3.4000	3.1500	3.6000	69.0000	88400.00	87720.00	680.00	260	43	260	298	0.87248322147651	0.634431437397035	0.634431437397035	false	false	false
9e55b67e-689a-4ecf-bd60-1696bc2310d5	2026-09-28 09:36	2026-09-28 09:36	2026-09-28 09:36	AFRM	AFRM261016C00080000	call	80.0000	2026-10-16	0.5000	0.5000	0.6500	68.3200	30000.00	0.00	30000.00	600	26	616	2300	0.267826086956522	0.572853692093047	0.572853692093047	false	false	false
c0edc2b5-f663-4c61-a142-f698196c06ef	2026-09-25 15:40	2026-09-25 15:40	2026-09-25 15:40	AFRM	AFRM261120C00075000	call	75.0000	2026-11-20	5.8000	5.8000	5.9500	71.0000	99180.00	0.00	99180.00	171	9	186	1064	0.174812030075188	0.620216959183054	0.620216959183054	false	false	false
04912ad6-8cb6-4827-8d02-0951d23a7096	2026-09-25 13:13	2026-09-25 13:12	2026-09-25 13:12	AFRM	AFRM270319P00045000	put	45.0000	2027-03-19	1.7200	1.5800	1.7200	71.8650	18576.00	18576.00	0.00	108	12	1455	115	12.6521739130435	0.645655452382463	0.645655452382463	false	false	false
cbf121f5-2a36-4365-b105-36f2ef7db735	2026-09-25 13:12	2026-09-25 13:12	2026-09-25 13:12	AFRM	AFRM270319P00045000	put	45.0000	2027-03-19	1.7300	1.5800	1.7400	71.8800	34600.00	34600.00	0.00	200	12	1347	115	11.7130434782609	0.647022531614372	0.647022531614372	false	false	false
48799bc1-9d58-4d3d-8a88-8f7c1faac5a3	2026-09-24 15:54	2026-09-24 15:53	2026-09-24 15:53	AFRM	AFRM261016P00070000	put	70.0000	2026-10-16	2.8600	2.8600	2.9900	71.6000	28600.00	0.00	28600.00	100	36	612	2961	0.206686930091185	0.531233960216602	0.531233960216602	false	false	false
2944ca86-6243-491d-b3ad-447c9a3214b1	2026-09-24 15:53	2026-09-24 15:53	2026-09-24 15:53	AFRM	AFRM261016P00070000	put	70.0000	2026-10-16	2.8500	2.8500	2.9900	71.6150	28500.00	0.00	28500.00	100	11	475	2961	0.160418777440054	0.530640550040142	0.530640550040142	false	false	false
4b8f2bc6-72d0-461e-8be0-d7b8adf5e14a	2026-09-24 15:39	2026-09-24 15:39	2026-09-24 15:39	AFRM	AFRM260925C00071000	call	71.0000	2026-09-25	1.3200	1.1000	1.3200	71.0000	26400.00	26400.00	0.00	200	6	445	458	0.971615720524017	0.683303807528647	0.683303807528647	false	false	false
75720620-afde-4f61-b471-699f2bc07904	2026-09-24 15:36	2026-09-24 15:36	2026-09-24 15:36	AFRM	AFRM261009C00070000	call	70.0000	2026-10-09	4.1000	3.9000	4.1500	71.6250	35260.00	34850.00	410.00	86	11	89	17	5.23529411764706	0.551514339215191	0.551514339215191	true	false	false
7afc1b88-aef6-48d9-b7a1-347be1cb127e	2026-09-24 14:21	2026-09-24 14:21	2026-09-24 14:21	AFRM	AFRM270115C00090000	call	90.0000	2027-01-15	3.3500	3.3500	3.6000	70.5100	128640.00	0.00	128640.00	384	27	385	1092	0.352564102564103	0.566461902527063	0.566461902527063	false	false	false
c6aafc07-791b-4c72-a767-1f2de4ff5720	2026-09-24 10:53	2026-09-24 10:53	2026-09-24 10:53	AFRM	AFRM261120P00070000	put	70.0000	2026-11-20	6.7000	6.5500	6.7000	70.0700	72360.00	72360.00	0.00	108	35	108	1162	0.0929432013769363	0.633612798590408	0.633612798590408	false	false	false
3e27777a-d8a5-4847-aa8e-f46f7d4b5c31	2026-09-24 10:53	2026-09-24 10:53	2026-09-24 10:53	AFRM	AFRM261120P00067500	put	67.5000	2026-11-20	5.4500	5.2500	5.4750	70.0700	32680.00	30520.00	2160.00	60	19	60	479	0.125260960334029	0.635055658096989	0.630320985673644	false	false	false
4b8ff948-f20e-4928-89d8-c33c676fca91	2026-09-23 13:43	2026-09-23 13:43	2026-09-23 13:43	AFRM	AFRM261120C00077500	call	77.5000	2026-11-20	3.6500	3.4500	3.7000	68.0000	12775.00	10220.00	2555.00	35	5	50	368	0.135869565217391	0.625406916554141	0.625406916554141	false	false	false
f5a60a69-6908-44d7-af44-a29a75fb9f3f	2026-09-23 13:06	2026-09-23 13:06	2026-09-23 13:06	AFRM	AFRM270319P00047500	put	47.5000	2027-03-19	2.5500	2.5500	2.7600	68.5400	17085.00	0.00	17085.00	67	9	558	1067	0.522961574507966	0.631950238611849	0.631950238611849	false	false	false
b2f00aae-5e54-4e8c-af48-06ce6c653f21	2026-09-23 13:06	2026-09-23 13:06	2026-09-23 13:06	AFRM	AFRM260925P00070000	put	70.0000	2026-09-25	2.1600	2.1300	2.1600	68.5000	12528.00	12528.00	0.00	58	19	249	926	0.26889848812095	0.627664380104311	0.627664380104311	false	false	false
921071ba-8efc-4b7d-aee3-8c711fffc97f	2026-09-23 13:06	2026-09-23 13:06	2026-09-23 13:06	AFRM	AFRM261002P00071000	put	71.0000	2026-10-02	3.8000	3.7500	4.0500	68.5675	10635.00	6840.00	3795.00	28	8	32	57	0.56140350877193	0.547645536578275	0.558315374458413	false	false	false
6d7d1540-6d3d-4bc8-9184-62872c10782b	2026-09-23 13:06	2026-09-23 13:06	2026-09-23 13:06	AFRM	AFRM260925P00078000	put	78.0000	2026-09-25	9.5000	8.4000	10.4500	68.5000	35150.00	1900.00	33250.00	37	6	37	10	3.7	0.773365604669662	0.773365604669662	false	false	false
ce397e28-cace-4d51-8021-bfed09ad0864	2026-09-23 13:04	2026-09-23 13:04	2026-09-23 13:04	AFRM	AFRM261002P00067000	put	67.0000	2026-10-02	1.5800	1.4500	1.5800	68.6650	50402.00	50402.00	0.00	319	35	331	195	1.6974358974359	0.553521804668113	0.552165072983972	false	false	false