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 = KLAR×sorted by created_at ↑×

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

e14b1ff9-fa1a-424a-8571-246834059a80	2026-08-17 09:31	2026-08-17 09:30	2026-08-17 09:30	KLAR	KLAR270319P00020000	put	20.0000	2027-03-19	3.7000	3.7000	3.9000	20.5950	69560.00	0.00	69560.00	188	7	405	27	15	0.694581846453805	0.694581846453805	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	5379487718.00	2026-11-17	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e889e252-b998-46da-9648-eeddbd735b53	2026-08-17 09:31	2026-08-17 09:31	2026-08-17 09:31	KLAR	KLAR270319P00020000	put	20.0000	2027-03-19	3.8000	3.7000	3.8000	20.5000	18240.00	18240.00	0.00	48	6	453	27	16.7777777777778	0.705796183763107	0.705796183763107	false	false	false	true
c7fa1eb1-ed65-4433-9933-d38d1abae2d5	2026-08-17 09:31	2026-08-17 09:31	2026-08-17 09:31	KLAR	KLAR270319P00020000	put	20.0000	2027-03-19	3.7000	3.7000	3.9000	20.4950	109890.00	0.00	109890.00	297	10	750	27	27.7777777777778	0.68846965008461	0.68846965008461	false	false	false	true
2ad6facc-db43-4e28-b0f9-6a8ba97197e8	2026-08-17 09:31	2026-08-17 09:31	2026-08-17 09:31	KLAR	KLAR280121P00020000	put	20.0000	2028-01-21	5.5000	5.4000	5.6000	20.5150	272802.00	27500.00	245302.00	496	20	496	1385	0.35812274368231	0.690706170738903	0.690706170738903	false	false	false	true
27aa90a9-ca9d-4407-be2c-7a2d584cd0bf	2026-08-17 09:31	2026-08-17 09:31	2026-08-17 09:31	KLAR	KLAR270319P00020000	put	20.0000	2027-03-19	3.7000	3.6000	3.7000	20.5800	39960.00	39960.00	0.00	108	6	858	27	31.7777777777778	0.693669733180563	0.693669733180563	false	false	false	true
3056bd4f-680e-4d09-87f1-f2d04b8f30cb	2026-08-17 09:31	2026-08-17 09:31	2026-08-17 09:31	KLAR	KLAR270319P00020000	put	20.0000	2027-03-19	3.7000	3.6000	3.7000	20.5489	18500.00	18500.00	0.00	50	6	908	27	33.6296296296296	0.691773342340986	0.691773342340986	false	false	false	true
3892b2cf-d757-4e49-a9af-8d17daee8859	2026-08-17 09:31	2026-08-17 09:31	2026-08-17 09:31	KLAR	KLAR270319P00020000	put	20.0000	2027-03-19	3.7000	3.6000	3.9000	20.5700	114700.00	108410.00	6290.00	310	18	1248	27	46.2222222222222	0.693060739520095	0.693060739520095	false	false	false	true
36d27cf4-5791-44b5-b300-2db699ad44f9	2026-08-17 09:31	2026-08-17 09:31	2026-08-17 09:31	KLAR	KLAR270319P00020000	put	20.0000	2027-03-19	3.7000	3.6000	3.7000	20.5700	93240.00	72520.00	0.00	252	18	1500	27	55.5555555555556	0.693060739520095	0.693060739520095	false	false	false	true
336fd193-d4a2-40ea-96bc-5df33e42a30e	2026-08-17 09:32	2026-08-17 09:32	2026-08-17 09:32	KLAR	KLAR260821C00022000	call	22.0000	2026-08-21	1.0000	0.9500	1.0000	20.4550	10000.00	10000.00	0.00	100	5	105	778	0.134961439588689	1.87199415472221	1.87199415472221	false	false	false	true
317dd82b-6c20-4968-9a03-96ea1f7007b4	2026-08-17 10:18	2026-08-17 10:18	2026-08-17 10:18	KLAR	KLAR260821C00020500	call	20.5000	2026-08-21	1.0000	1.0000	1.0500	19.3600	11200.00	0.00	11200.00	112	13	326	661	0.493192133131619	1.80359383875682	1.80359383875682	false	false	false	true
61cf3a36-def8-4e65-b500-223375db022f	2026-08-17 10:22	2026-08-17 10:22	2026-08-17 10:22	KLAR	KLAR260918C00022500	call	22.5000	2026-09-18	0.9000	0.8500	0.9500	19.4500	15210.00	180.00	15030.00	169	23	276	1078	0.256029684601113	0.833926927048554	0.833926927048554	false	false	false	true
352e91eb-dc50-44ee-9746-26cb4164705c	2026-08-17 12:05	2026-08-17 12:05	2026-08-17 12:05	KLAR	KLAR260918P00015000	put	15.0000	2026-09-18	0.2600	0.2500	0.3500	19.4000	12853.00	0.00	12853.00	500	6	2036	1666	1.22208883553421	0.78559474300525	0.776151352480603	false	false	false	true
5283e18f-cc29-4667-8f29-721cfc058aef	2026-08-17 14:27	2026-08-17 14:27	2026-08-17 14:27	KLAR	KLAR260821C00021500	call	21.5000	2026-08-21	0.8000	0.7000	0.8000	19.5700	60000.00	60000.00	0.00	750	25	997	404	2.46782178217822	1.84460932074188	1.84460932074188	false	false	false	true
e6c29f9a-e3ca-46cc-a606-b6dd921ca8cd	2026-08-17 14:46	2026-08-17 14:45	2026-08-17 14:45	KLAR	KLAR260918P00017500	put	17.5000	2026-09-18	0.9000	0.8500	0.9500	19.5750	28170.00	360.00	27810.00	313	11	412	4751	0.0867185855609345	0.810330973858129	0.810330973858129	false	false	false	true
e84a621a-f451-4e8f-9720-988951663c43	2026-08-17 15:55	2026-08-17 15:55	2026-08-17 15:55	KLAR	KLAR260821C00020000	call	20.0000	2026-08-21	1.3500	1.3000	1.3500	19.5600	41850.00	41850.00	0.00	310	28	2508	10547	0.237792737271262	1.88753835317097	1.88753835317097	false	false	false	true
f0b66c0d-ed3f-405e-8c8c-4ce2b4d6cdc0	2026-08-18 09:38	2026-08-18 09:38	2026-08-18 09:38	KLAR	KLAR260821P00015500	put	15.5000	2026-08-21	0.4000	0.4000	0.4500	15.7650	20082.00	0.00	20082.00	501	14	1499	2633	0.569312571211546	0.927034545831375	0.945110806715203	false	false	false	true
be2f5a8c-9c44-4b7a-89e1-a5a505e53c4c	2026-08-18 09:58	2026-08-18 09:58	2026-08-18 09:58	KLAR	KLAR260821P00016000	put	16.0000	2026-08-21	0.8000	0.8000	0.9000	15.4300	15200.00	0.00	15200.00	190	15	552	3453	0.159860990443093	0.816347754859215	0.816347754859215	false	false	false	true
bcdf09ac-d680-49e0-b2ad-1418c96bca5a	2026-08-18 09:59	2026-08-18 09:59	2026-08-18 09:59	KLAR	KLAR270319C00017500	call	17.5000	2027-03-19	2.4000	2.4000	2.7000	15.3794	300000.00	0.00	300000.00	1250	5	1295	30	43.1666666666667	0.650872725193949	0.650872725193949	false	false	false	true
471b994e-5e34-462a-880f-2aa9e9803934	2026-08-18 10:54	2026-08-18 10:54	2026-08-18 10:54	KLAR	KLAR270115C00015000	call	15.0000	2027-01-15	2.9000	2.9000	3.1000	15.7705	14500.00	0.00	14500.00	50	18	152	1059	0.143531633616619	0.608469845937426	0.608469845937426	false	false	false	true
e0fb2680-abda-48ab-b16c-a48af9002a5a	2026-08-18 11:55	2026-08-18 11:55	2026-08-18 11:55	KLAR	KLAR270115P00012500	put	12.5000	2027-01-15	1.0000	0.9000	1.0000	15.2600	12000.00	12000.00	0.00	120	6	313	6107	0.0512526608809563	0.621171711356871	0.621171711356871	false	false	false	true
384dff2e-517b-4c47-9a24-022b6c6dd225	2026-08-18 13:21	2026-08-18 13:21	2026-08-18 13:21	KLAR	KLAR260821C00016000	call	16.0000	2026-08-21	0.3000	0.2000	0.3000	15.4698	14760.00	14760.00	0.00	492	14	3764	46	81.8260869565217	0.916038342964747	0.916038342964747	false	false	false	true
cf098524-a937-4dfd-ad5a-5da6fa91d248	2026-08-18 13:48	2026-08-18 13:48	2026-08-18 13:48	KLAR	KLAR270319P00010000	put	10.0000	2027-03-19	0.6500	0.5500	0.6500	15.2550	21710.00	21710.00	0.00	334	18	399	0	0	0.670453225157392	0.670453225157392	false	false	false	true
006a8935-dbb4-4b52-920d-08ac08cc1e37	2026-08-18 14:30	2026-08-18 14:30	2026-08-18 14:30	KLAR	KLAR260918C00015000	call	15.0000	2026-09-18	1.1000	1.0500	1.1500	15.2000	11000.00	8800.00	0.00	100	8	432	5667	0.0762308099523557	0.55274762817988	0.55439606580714	false	false	false	true
64ed48cd-8ae7-4a88-91c9-98bd5898f4b8	2026-08-18 14:43	2026-08-18 14:43	2026-08-18 14:43	KLAR	KLAR280121C00045000	call	45.0000	2028-01-21	0.8500	0.8000	0.8500	15.1750	17000.00	17000.00	0.00	200	15	651	2139	0.304347826086957	0.658321897090954	0.658321897090954	false	false	false	true
795d7858-27b3-46be-a62c-be855276bae9	2026-08-19 09:39	2026-08-19 09:39	2026-08-19 09:39	KLAR	KLAR261218C00017500	call	17.5000	2026-12-18	1.0000	1.0000	1.3000	14.4900	17011.00	0.00	17011.00	170	10	203	577	0.351819757365685	0.581313083375699	0.581313083375699	false	false	false	true
c88dcd46-4edb-4aa4-b817-cfbb4b64d71a	2026-08-19 09:42	2026-08-19 09:42	2026-08-19 09:42	KLAR	KLAR260918P00015000	put	15.0000	2026-09-18	1.1000	1.0500	1.1000	14.5588	39600.00	13200.00	0.00	360	6	390	3633	0.107349298100743	0.527137695573818	0.527137695573818	false	false	false	true
547bbc90-39d3-4707-b76d-a02953c950f3	2026-08-19 09:45	2026-08-19 09:45	2026-08-19 09:45	KLAR	KLAR260918P00015000	put	15.0000	2026-09-18	1.1000	1.0000	1.1000	14.5550	17050.00	17050.00	0.00	155	33	562	3633	0.154693091109276	0.527529009424019	0.525896736858132	false	false	false	true
060b80ff-d255-4eb5-8d8f-05bd6c47b765	2026-08-19 09:45	2026-08-19 09:45	2026-08-19 09:45	KLAR	KLAR260918P00015000	put	15.0000	2026-09-18	1.1000	1.0500	1.1000	14.5300	16830.00	16830.00	0.00	153	28	734	3633	0.202036884117809	0.521004143045363	0.517662979788779	false	false	false	true
102c9860-9d9f-4d0b-88c9-0ae2e84cbc09	2026-08-19 09:45	2026-08-19 09:45	2026-08-19 09:45	KLAR	KLAR260918P00015000	put	15.0000	2026-09-18	1.1000	1.0500	1.1000	14.5200	12540.00	12540.00	0.00	114	23	857	3633	0.23589320121112	0.514334744021015	0.514334744021015	false	false	false	true
6f38adf2-f085-4a48-8560-c4c0b94610cf	2026-08-19 09:54	2026-08-19 09:54	2026-08-19 09:54	KLAR	KLAR260918P00015000	put	15.0000	2026-09-18	1.1000	1.0500	1.1000	14.5593	16940.00	16940.00	0.00	154	28	1180	3633	0.324800440407377	0.527300776040079	0.527300776040079	false	false	false	true
73ed7f96-14bc-4b48-80a2-504d552f9620	2026-08-19 10:19	2026-08-19 10:19	2026-08-19 10:19	KLAR	KLAR261218C00015000	call	15.0000	2026-12-18	2.0000	1.9500	2.0500	14.7686	12600.00	8600.00	4000.00	63	8	98	287	0.341463414634146	0.597159358589554	0.597159358589554	false	false	false	true
1e88f75d-799f-4b0d-847f-340d4ddcdaf5	2026-08-19 12:36	2026-08-19 12:36	2026-08-19 12:36	KLAR	KLAR260821P00017000	put	17.0000	2026-08-21	2.1500	2.0500	2.1500	14.8600	13760.00	13760.00	0.00	64	13	147	971	0.151390319258496	0.969093042892065	0.969093042892065	false	false	false	true
d36e66eb-42da-43f4-94dd-bad5defd4971	2026-08-19 15:52	2026-08-19 15:52	2026-08-19 15:52	KLAR	KLAR261016C00015000	call	15.0000	2026-10-16	1.1200	1.0500	1.1500	14.6250	11200.00	11200.00	0.00	100	5	519	5539	0.093699223686586	0.53629317916794	0.53629317916794	false	false	false	true
24005423-4f6c-45ad-b0b5-1348291acfd1	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	KLAR	KLAR260918P00015000	put	15.0000	2026-09-18	1.3000	1.2500	1.3000	14.1150	76050.00	76050.00	0.00	585	18	659	5287	0.124645356534897	0.497155185062985	0.497155185062985	false	false	false	true
23223508-496b-4e3f-9e43-cae909050578	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	KLAR	KLAR260821P00014500	put	14.5000	2026-08-21	0.4500	0.4000	0.4500	14.1350	22275.00	22275.00	0.00	495	16	800	1651	0.484554815263477	0.744736587397059	0.744736587397059	false	false	false	true
eb548194-d251-4f5b-bf50-eb5d73c2f8f6	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	KLAR	KLAR260918P00015000	put	15.0000	2026-09-18	1.3000	1.3000	1.4000	14.1200	26520.00	0.00	26520.00	204	11	863	5287	0.163230565538112	0.499268180806637	0.499268180806637	false	false	false	true
7d922058-cdc1-47cb-8713-d7b1b0df9be3	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	KLAR	KLAR260918P00015000	put	15.0000	2026-09-18	1.3000	1.2500	1.3500	14.1300	45630.00	19760.00	130.00	351	19	1216	5287	0.229998108568186	0.501371496758618	0.503465285314503	false	false	false	true
1dfa80fc-6d01-4203-b8c1-99885725b55d	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	KLAR	KLAR260918P00015000	put	15.0000	2026-09-18	1.3000	1.2500	1.3000	14.1300	23920.00	5980.00	0.00	184	8	1403	5287	0.2653678834878	0.503465285314503	0.503465285314503	false	false	false	true
8aa3ed63-6659-4902-8c26-0217bcc7855b	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	KLAR	KLAR260918P00015000	put	15.0000	2026-09-18	1.3000	1.2500	1.3500	14.1300	96330.00	96200.00	0.00	741	21	2144	5287	0.405522980896539	0.503465285314503	0.503465285314503	false	false	false	true
5f163fd6-ccfa-46c2-a1e7-f784d98a525b	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	KLAR	KLAR260918P00015000	put	15.0000	2026-09-18	1.3000	1.2500	1.3000	14.1300	20930.00	5980.00	0.00	161	7	2305	5287	0.435975033100057	0.503465285314503	0.503465285314503	false	false	false	true
38bb1e64-5a08-4038-8859-987064143051	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	KLAR	KLAR260918P00015000	put	15.0000	2026-09-18	1.3000	1.2500	1.3000	14.1201	28860.00	28860.00	0.00	222	12	2528	5287	0.47815396254965	0.499310341472957	0.499310341472957	false	false	false	true
4bf77bad-a6d2-4bdb-99b8-23a29f8a1d0e	2026-08-20 10:36	2026-08-20 10:36	2026-08-20 10:36	KLAR	KLAR260918P00015000	put	15.0000	2026-09-18	1.3000	1.2500	1.3000	14.1150	36400.00	5200.00	0.00	280	7	2826	5287	0.534518630603367	0.497155185062985	0.497155185062985	false	false	false	true
85a48281-2ba6-4545-8af2-fdb6d1203359	2026-08-20 10:53	2026-08-20 10:53	2026-08-20 10:53	KLAR	KLAR260918P00015000	put	15.0000	2026-09-18	1.3000	1.2500	1.3000	14.1350	32500.00	32500.00	0.00	250	15	3076	5287	0.581804425950444	0.507500616884805	0.505549694781858	false	false	false	true
d23c0868-613d-4dc7-b9cc-aed20227d388	2026-08-20 11:11	2026-08-20 11:11	2026-08-20 11:11	KLAR	KLAR260918P00015000	put	15.0000	2026-09-18	1.3000	1.2500	1.3000	14.1200	30680.00	30680.00	0.00	236	6	3321	5287	0.628144505390581	0.499268180806637	0.499268180806637	false	false	false	true
fc9b31e0-2811-42d4-a6dd-e53823343715	2026-08-20 11:38	2026-08-20 11:38	2026-08-20 11:38	KLAR	KLAR260821P00016000	put	16.0000	2026-08-21	2.0000	1.9500	2.0500	14.0100	30600.00	29200.00	0.00	153	35	231	3287	0.0702768481898388	1.41980454663699	1.33637726473128	false	false	false	true
5cfc5073-2a57-4995-b0d6-4fb63e05b9d8	2026-08-20 13:09	2026-08-20 13:09	2026-08-20 13:09	KLAR	KLAR261218P00015000	put	15.0000	2026-12-18	2.5000	2.4000	2.5000	13.8950	22500.00	22500.00	0.00	90	7	231	631	0.36608557844691	0.615468820910328	0.615468820910328	false	false	false	true
db8776e3-7a83-4284-b9e8-503b77d08607	2026-08-20 14:01	2026-08-20 14:01	2026-08-20 14:01	KLAR	KLAR260821P00016000	put	16.0000	2026-08-21	2.1000	2.0000	2.1000	13.9200	21000.00	18690.00	0.00	100	13	1281	3287	0.38971706723456	1.5546452293497	1.5546452293497	false	false	false	true
165b325d-b11a-4b35-a4be-eae1da79ba6a	2026-08-20 14:05	2026-08-20 14:05	2026-08-20 14:05	KLAR	KLAR260821P00016000	put	16.0000	2026-08-21	2.1000	2.0500	2.1000	13.9400	32340.00	32340.00	0.00	154	34	1635	3287	0.497414055369638	1.76881577845063	1.76881577845063	true	false	false	true
091cf124-c996-4963-915b-bc263c7c48c8	2026-08-21 10:09	2026-08-21 10:09	2026-08-21 10:09	KLAR	KLAR270115P00012500	put	12.5000	2027-01-15	1.1000	1.0500	1.2000	14.5001	11000.00	110.00	110.00	100	18	101	6702	0.0150701283199045	0.597398993533987	0.597398993533987	false	false	false	true
ffacbe7c-7c67-49f1-b53b-8181baf6947a	2026-08-21 10:12	2026-08-21 10:11	2026-08-21 10:11	KLAR	KLAR260821P00016000	put	16.0000	2026-08-21	1.5000	1.4000	1.5000	14.5100	14399.00	14399.00	0.00	96	25	129	497	0.259557344064386	2.06261680477103	2.06261680477103	false	false	false	true