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: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	strikenumeric	expiry

8796402a-b1cc-44f5-a9c0-a2831e101c44	2026-08-21 15:00	2026-08-21 15:00	2026-08-21 15:00	AFRM	AFRM260918P00077500	put	77.5000	2026-09-18	6.6200	6.4500	6.7000	76.3350	19860.00	19860.00	0.00	30	7	144	2574	0.0559440559440559	0.724587561078367	0.724587561078367	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	21785198372.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T19:11:44.414359Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a1d2fdbe-a193-4e45-94c4-dd82773414cb	2026-08-21 10:54	2026-08-21 10:54	2026-08-21 10:54	AFRM	AFRM270319C00095000	call	95.0000	2027-03-19	8.8500	8.0000	9.3000	76.3250	21240.00	9735.00	11505.00	24	7	24	176	0.136363636363636	0.623081213591403	0.623081213591403	false	false	false	true
09da1311-9365-4f63-a9db-875957b74180	2026-08-21 10:31	2026-08-21 10:30	2026-08-21 10:30	AFRM	AFRM260918P00077500	put	77.5000	2026-09-18	6.6900	6.6000	7.0500	75.9900	18735.00	12730.00	6005.00	28	11	32	2574	0.0124320124320124	0.708075317369556	0.71403070073766	true	false	false	true
e0cedee0-1cec-4d80-acf4-e38df5af85cb	2026-08-21 10:17	2026-08-21 10:17	2026-08-21 10:17	AFRM	AFRM261120C00090000	call	90.0000	2026-11-20	5.4500	5.4000	5.4500	76.2600	11990.00	11990.00	0.00	22	7	24	764	0.031413612565445	0.652188588836505	0.652188588836505	false	false	false	true
17b81d3d-ca79-45be-8c7b-66319fa4a7fa	2026-08-20 12:52	2026-08-20 12:52	2026-08-20 12:52	AFRM	AFRM261120P00060000	put	60.0000	2026-11-20	3.1000	3.0000	3.2000	74.9850	14880.00	0.00	11470.00	48	5	506	520	0.973076923076923	0.657741248194194	0.657741248194194	false	false	false	true
5c6a3df3-d19c-4623-a57b-e217650478e7	2026-08-20 12:50	2026-08-20 12:50	2026-08-20 12:50	AFRM	AFRM260828C00077000	call	77.0000	2026-08-28	3.7000	3.3500	3.7000	75.0000	10360.00	9990.00	0.00	28	5	33	46	0.717391304347826	1.0270526685104	1.0270526685104	false	false	false	true
90f81bc8-dec9-493d-9b52-bbfb3c3c35d6	2026-08-20 11:40	2026-08-20 11:40	2026-08-20 11:40	AFRM	AFRM260918C00075000	call	75.0000	2026-09-18	5.7500	5.5000	6.0000	74.4400	361655.00	358780.00	2875.00	629	52	638	1110	0.574774774774775	0.706354407612489	0.706354407612489	false	false	false
74ebc18e-9bc9-486f-9ea1-a2a42ecddff6	2026-08-20 10:05	2026-08-20 10:05	2026-08-20 10:05	AFRM	AFRM260918P00067500	put	67.5000	2026-09-18	2.4600	2.2100	2.4600	75.4900	14760.00	14760.00	0.00	60	12	73	744	0.0981182795698925	0.703658989264106	0.703658989264106	false	false	false	true
75911135-78ce-472e-8dea-96f9d6c30fff	2026-08-19 14:29	2026-08-19 14:29	2026-08-19 14:29	AFRM	AFRM270319C00095000	call	95.0000	2027-03-19	9.3500	8.7500	9.6500	77.4000	11220.00	935.00	10285.00	12	7	20	156	0.128205128205128	0.62128824129982	0.62128824129982	false	false	false	true
9c72f5e8-dd37-4849-9ab5-a18327f6bd2f	2026-08-19 12:04	2026-08-19 12:04	2026-08-19 12:04	AFRM	AFRM260904C00087000	call	87.0000	2026-09-04	2.5000	2.3400	2.5100	78.5450	38797.00	38797.00	0.00	155	7	313	15	20.8666666666667	0.829902943747945	0.829902943747945	false	false	false	true
d8679506-d124-4ae4-85ea-4dfa27fbff91	2026-08-19 12:04	2026-08-19 12:04	2026-08-19 12:04	AFRM	AFRM260904C00087000	call	87.0000	2026-09-04	2.5000	2.3400	2.5100	78.5450	13728.00	4750.00	7478.00	55	8	158	15	10.5333333333333	0.829902943747945	0.828182011557825	true	false	false	true
df46b91a-1e17-486a-a758-5e01a3db069f	2026-08-19 11:56	2026-08-19 11:56	2026-08-19 11:56	AFRM	AFRM261016C00092500	call	92.5000	2026-10-16	3.2000	3.2000	3.2500	78.5400	32000.00	0.00	14400.00	100	5	100	17	5.88235294117647	0.609181009727141	0.609181009727141	false	false	false	true
2b348999-ba8f-44cc-9c61-0127dde202ec	2026-08-19 11:51	2026-08-19 11:51	2026-08-19 11:51	AFRM	AFRM280121C00092500	call	92.5000	2028-01-21	20.2200	17.9000	20.3000	78.2900	10110.00	6080.00	4030.00	5	5	5	66	0.0757575757575758	0.636895499905426	0.63275673688652	false	false	false	true
fede18f0-635f-4ddc-88be-f98bc2de16a6	2026-08-19 11:12	2026-08-19 11:12	2026-08-19 11:12	AFRM	AFRM260828C00075000	call	75.0000	2026-08-28	6.3500	6.1500	6.3500	77.8600	10795.00	10160.00	0.00	17	5	187	527	0.354838709677419	0.99192404370126	0.99192404370126	false	false	false	true
b903a94f-c87d-4cac-a127-9e623d688b8a	2026-08-19 10:48	2026-08-19 10:48	2026-08-19 10:48	AFRM	AFRM260904P00055000	put	55.0000	2026-09-04	0.1300	0.1300	0.2400	76.6750	10868.00	0.00	10868.00	836	46	851	714	1.19187675070028	0.844182966610919	0.844182966610919	false	false	false	true
970b8afc-aaa4-4878-bae8-825ffcbe44cb	2026-08-18 15:26	2026-08-18 15:26	2026-08-18 15:26	AFRM	AFRM260828C00075000	call	75.0000	2026-08-28	4.2500	3.6500	4.2500	73.8900	20400.00	20400.00	0.00	48	8	449	445	1.00898876404494	0.967456003875062	0.967456003875062	false	false	false	true
e97371bd-5643-4090-bf2d-67dd1457eb4f	2026-08-18 15:20	2026-08-18 15:20	2026-08-18 15:20	AFRM	AFRM260821P00072000	put	72.0000	2026-08-21	0.8600	0.7900	0.8600	73.5250	20124.00	20124.00	0.00	234	43	293	588	0.498299319727891	0.573643974155437	0.573643974155437	false	false	false	true
d1e83dca-67b7-4e81-a5d2-52483968d908	2026-08-18 14:19	2026-08-18 14:19	2026-08-18 14:19	AFRM	AFRM261120C00075000	call	75.0000	2026-11-20	9.0000	8.9000	9.2500	73.3800	134990.00	1795.00	132300.00	150	10	170	104	1.63461538461538	0.633717197891783	0.630325807180341	true	false	false
5931da4c-75f1-4219-8978-333813732373	2026-08-18 12:46	2026-08-18 12:46	2026-08-18 12:46	AFRM	AFRM260821P00075000	put	75.0000	2026-08-21	1.6400	1.4800	1.9700	74.7400	27060.00	0.00	27060.00	165	5	247	3806	0.0648975302154493	0.561006784280263	0.561006784280263	false	false	false	true
4b4e4d05-0ce7-47b2-98fc-ad829e42558f	2026-08-18 12:46	2026-08-18 12:46	2026-08-18 12:46	AFRM	AFRM261218P00065000	put	65.0000	2026-12-18	5.5000	5.4500	5.8500	74.8650	550666.00	560.00	542956.00	1001	64	1002	180	5.56666666666667	0.623192231924249	0.625562109240851	true	false	false
eb880493-293b-4eff-a4a7-9445e3001464	2026-08-18 11:25	2026-08-18 11:25	2026-08-18 11:25	AFRM	AFRM261120C00085000	call	85.0000	2026-11-20	6.2000	6.0000	6.4000	74.8400	62000.00	4340.00	4960.00	100	19	100	258	0.387596899224806	0.636385546098173	0.636385546098173	false	false	false
d6f2da6b-d459-4e6e-b7ae-ff5a58e9e905	2026-08-18 11:13	2026-08-18 11:12	2026-08-18 11:12	AFRM	AFRM260918C00077500	call	77.5000	2026-09-18	5.0000	4.8000	5.0000	75.1978	58500.00	58500.00	0.00	117	9	127	697	0.182209469153515	0.674740831746898	0.674740831746898	false	false	false	true
884267f0-d909-47f0-a95c-e8875980f116	2026-08-18 10:37	2026-08-18 10:37	2026-08-18 10:37	AFRM	AFRM280121P00027500	put	27.5000	2028-01-21	1.7900	1.6000	1.8000	75.4150	43900.00	38500.00	0.00	245	15	245	56	4.375	0.715989072206155	0.713713973677095	false	false	false	true
9b6ee5ee-3921-461a-89e9-3de26b721f6e	2026-08-18 10:22	2026-08-18 10:22	2026-08-18 10:22	AFRM	AFRM261016C00085000	call	85.0000	2026-10-16	4.1000	4.0000	4.2000	75.3900	10660.00	7380.00	3280.00	26	5	27	59	0.457627118644068	0.61195560808376	0.61195560808376	false	false	false	true
5948703e-897b-4e2e-ad0a-cf7d959649ae	2026-08-18 09:30	2026-08-18 09:30	2026-08-18 09:30	AFRM	AFRM260821P00072500	put	72.5000	2026-08-21	2.0000	1.3300	2.2600	71.7600	32000.00	32000.00	0.00	160	6	160	586	0.273037542662116	0.619630667434875	0.619630667434875	false	false	false	true
93f55dee-22ee-464a-98b5-4026ee88008b	2026-08-17 15:24	2026-08-17 15:24	2026-08-17 15:24	AFRM	AFRM261218P00080000	put	80.0000	2026-12-18	13.1000	13.1000	13.4500	74.9600	19650.00	0.00	19650.00	15	5	15	544	0.0275735294117647	0.620407150177195	0.620407150177195	false	false	false	true
0426c2ee-3ea4-427a-803c-b44909afdc1a	2026-08-17 14:51	2026-08-17 14:51	2026-08-17 14:51	AFRM	AFRM260828P00075000	put	75.0000	2026-08-28	4.7000	4.5000	4.8500	74.8200	10810.00	10810.00	0.00	23	6	85	171	0.497076023391813	0.898233484592447	0.898233484592447	false	false	false	true
14c05455-95be-4095-9367-cd15d47a68cf	2026-08-17 14:11	2026-08-17 14:11	2026-08-17 14:11	AFRM	AFRM261218P00075000	put	75.0000	2026-12-18	10.0500	10.0500	10.2000	75.0000	83425.00	2020.00	81405.00	83	18	83	58	1.43103448275862	0.619607633789113	0.619607633789113	false	false	false	true
0e31cc9b-3456-4853-bb8a-89145498d74f	2026-08-17 12:44	2026-08-17 12:44	2026-08-17 12:44	AFRM	AFRM261218C00125000	call	125.0000	2026-12-18	1.3500	1.3500	1.5200	75.3800	29370.00	136.00	24374.00	217	18	239	91	2.62637362637363	0.622462875869272	0.620150736349985	false	false	false
074614b7-d3d7-4cbd-9408-87b70db5a4d4	2026-08-17 10:32	2026-08-17 10:32	2026-08-17 10:32	AFRM	AFRM261218C00090000	call	90.0000	2026-12-18	6.1500	6.1500	6.6000	75.4050	22140.00	0.00	22140.00	36	8	43	270	0.159259259259259	0.617094981722631	0.617094981722631	false	false	false	true
a0228452-8aa3-4090-b13e-ad061c8bef14	2026-08-17 09:39	2026-08-17 09:39	2026-08-17 09:39	AFRM	AFRM260828C00075000	call	75.0000	2026-08-28	6.0000	4.9500	6.0000	77.1600	90000.00	90000.00	0.00	150	6	150	525	0.285714285714286	0.911320579884829	0.911320579884829	false	false	false	true