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 = CRM×

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

f4bf55c7-0051-4df5-89df-85369ae4f1dc	2026-09-22 15:48	2026-09-22 15:48	2026-09-22 15:48	CRM	CRM260925C00237500	call	237.5000	2026-09-25	2.1100	2.0600	2.1100	233.9200	15614.00	15614.00	0.00	74	10	1217	985	1.23553299492386	0.421560784491856	0.421560784491856	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	191989440000.00	2026-12-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:49:40.866869Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
0a730e6f-4e33-4bf2-8106-8bfe3f2f827a	2026-09-22 15:48	2026-09-22 15:48	2026-09-22 15:48	CRM	CRM260925C00240000	call	240.0000	2026-09-25	1.3800	1.3200	1.3800	233.9200	44574.00	44574.00	0.00	323	23	3674	2416	1.52069536423841	0.422027971771816	0.422027971771816	false	false	false	true
2176fc51-9e94-4521-8c21-4b7cf8a0329d	2026-09-22 15:42	2026-09-22 15:41	2026-09-22 15:41	CRM	CRM260925P00232500	put	232.5000	2026-09-25	3.2000	3.2000	3.7000	232.7350	44800.00	0.00	44800.00	140	26	1044	346	3.01734104046243	0.398626807811494	0.398626807811494	false	false	false	true
c98b79ff-1496-4da6-b8a8-86d05401ec3e	2026-09-22 15:39	2026-09-22 15:39	2026-09-22 15:39	CRM	CRM260925P00232500	put	232.5000	2026-09-25	3.6500	3.2000	3.6500	232.2750	51100.00	51100.00	0.00	140	5	904	346	2.61271676300578	0.42541866411126	0.42541866411126	false	false	false	true
234beff8-27cf-4514-8f5c-bb9c4d9ca32e	2026-09-22 15:29	2026-09-22 15:29	2026-09-22 15:29	CRM	CRM261009P00230000	put	230.0000	2026-10-09	5.8500	5.7500	5.9500	233.0000	45045.00	14625.00	30420.00	77	22	310	223	1.39013452914798	0.387695721751583	0.387695721751583	false	false	false	true
d10b43ad-4189-4e0e-a439-07736ee3e94c	2026-09-22 15:27	2026-09-22 15:27	2026-09-22 15:27	CRM	CRM260925P00225000	put	225.0000	2026-09-25	0.8100	0.8100	0.8500	233.4775	33372.00	0.00	33372.00	412	49	2883	660	4.36818181818182	0.430562333602383	0.430562333602383	false	false	false	true
45dc4ec0-320b-429a-8afa-7215d01046de	2026-09-22 15:21	2026-09-22 15:21	2026-09-22 15:21	CRM	CRM261016P00230000	put	230.0000	2026-10-16	7.3000	7.3000	7.6500	233.1900	43800.00	0.00	43800.00	60	14	265	5519	0.0480159449175575	0.383423698712343	0.383423698712343	false	false	false	true
80fac271-86b8-4fd9-b8bc-57b07a0a33ff	2026-09-22 15:19	2026-09-22 15:19	2026-09-22 15:19	CRM	CRM260925C00240000	call	240.0000	2026-09-25	1.1600	1.1600	1.2300	232.8700	12180.00	0.00	12180.00	105	13	3019	2416	1.24958609271523	0.427338061182697	0.427338061182697	false	false	false	true
fed2a67d-4d53-4e11-8a30-a91ed9c194f4	2026-09-22 15:11	2026-09-22 15:11	2026-09-22 15:11	CRM	CRM261016C00240000	call	240.0000	2026-10-16	6.6500	6.4000	6.6500	232.9100	37905.00	37905.00	0.00	57	15	1260	1518	0.8300395256917	0.39495075221159	0.39495075221159	true	false	false	true
bc88aa50-221c-4b3e-b1d0-4e57514deab7	2026-09-22 15:11	2026-09-22 15:11	2026-09-22 15:11	CRM	CRM261016C00240000	call	240.0000	2026-10-16	6.7000	6.4000	6.7000	232.9100	64320.00	64320.00	0.00	96	11	1481	1518	0.97562582345191	0.3971001425585	0.3971001425585	true	false	false	true
b21cea9d-0673-4d54-8402-d920f0bf5668	2026-09-22 15:11	2026-09-22 15:11	2026-09-22 15:11	CRM	CRM261016C00240000	call	240.0000	2026-10-16	6.7000	6.4000	6.7000	232.9100	83750.00	83750.00	0.00	125	26	1385	1518	0.912384716732543	0.3971001425585	0.3971001425585	true	false	false	true
cb5a6bf6-046a-4d04-9664-9b50695116ed	2026-09-22 14:29	2026-09-22 14:29	2026-09-22 14:29	CRM	CRM261016P00230000	put	230.0000	2026-10-16	7.9000	7.5500	7.9000	232.1350	15010.00	15010.00	0.00	19	6	163	5519	0.0295343359304222	0.389963453168272	0.389963453168272	true	false	false	true
bc1688fb-86db-4d1c-aee5-d216c47341ab	2026-09-22 13:51	2026-09-22 13:51	2026-09-22 13:51	CRM	CRM261030P00205000	put	205.0000	2026-10-30	2.4800	2.3500	2.6000	232.1400	74400.00	52080.00	22320.00	300	11	492	37	13.2972972972973	0.407351410603246	0.407351410603246	false	false	false	true
da7fa965-dae9-48a4-8f2b-d950d4735a07	2026-09-22 13:42	2026-09-22 13:42	2026-09-22 13:42	CRM	CRM260925P00227500	put	227.5000	2026-09-25	1.7400	1.7100	1.8700	231.8700	17400.00	3480.00	13920.00	100	9	1304	1016	1.28346456692913	0.424482311702742	0.424482311702742	false	false	false	true
2c117bd9-8620-4415-a90e-cc29b9254929	2026-09-22 13:39	2026-09-22 13:39	2026-09-22 13:39	CRM	CRM260925P00227500	put	227.5000	2026-09-25	1.8200	1.7100	1.8200	231.0000	30212.00	30212.00	0.00	166	34	1204	1016	1.18503937007874	0.430603974284784	0.430603974284784	false	false	false	true
9faab313-5ab6-4cca-896f-b143fcbc52f0	2026-09-22 13:20	2026-09-22 13:20	2026-09-22 13:20	CRM	CRM261120C00260000	call	260.0000	2026-11-20	5.8000	5.8000	5.8500	231.4500	23780.00	0.00	23780.00	41	9	183	4179	0.0437903804737976	0.400641097696804	0.400641097696804	true	false	false	true
5a3abb1b-440b-4290-b1a0-a534043e9216	2026-09-22 13:20	2026-09-22 13:20	2026-09-22 13:20	CRM	CRM281215P00200000	put	200.0000	2028-12-15	34.2700	34.1000	34.6000	231.4500	315255.00	257030.00	58225.00	92	8	339	110	3.08181818181818	0.471557858880689	0.471557858880689	false	false	false	true
06702242-0489-4089-a9d5-1cb4f7957eb0	2026-09-22 13:14	2026-09-22 13:13	2026-09-22 13:13	CRM	CRM260925C00230000	call	230.0000	2026-09-25	4.6000	4.3000	4.6000	231.6450	27600.00	27600.00	0.00	60	10	2307	546	4.22527472527473	0.440455438856558	0.440455438856558	false	false	false	true
10c59f68-6466-43db-b14d-c43f5dc5e686	2026-09-22 12:32	2026-09-22 12:32	2026-09-22 12:32	CRM	CRM260925P00220000	put	220.0000	2026-09-25	0.3800	0.3800	0.4100	232.5500	22838.00	0.00	22838.00	601	16	1450	1240	1.16935483870968	0.455255818182229	0.455255818182229	false	false	false	true
debb9609-4357-49d5-8ee3-fbf340dc6b5e	2026-09-22 11:48	2026-09-22 11:48	2026-09-22 11:48	CRM	CRM281215P00230000	put	230.0000	2028-12-15	49.2500	49.2000	50.5000	230.8350	29550.00	0.00	29550.00	6	5	7	33	0.212121212121212	0.474024814925221	0.474024814925221	false	false	false	true
87e341f0-89eb-41b5-bd5f-9006ca06e2b0	2026-09-22 11:37	2026-09-22 11:37	2026-09-22 11:37	CRM	CRM261030P00205000	put	205.0000	2026-10-30	2.8200	2.6000	2.8200	230.1583	51324.00	51324.00	0.00	182	40	185	37	5	0.409039242882538	0.409039242882538	true	false	false	true
79e48ed3-3e5b-4d80-8688-58756cc61e93	2026-09-22 11:13	2026-09-22 11:13	2026-09-22 11:13	CRM	CRM261016P00220000	put	220.0000	2026-10-16	4.5000	4.3500	4.6500	230.7500	22950.00	18900.00	4050.00	51	12	163	2611	0.0624281884335504	0.393608624235099	0.393608624235099	false	false	false	true
0d169ffb-89a6-4ece-bddc-aab695658765	2026-09-22 11:13	2026-09-22 11:13	2026-09-22 11:13	CRM	CRM260925C00235000	call	235.0000	2026-09-25	2.1200	2.0100	2.1200	230.9100	16748.00	16748.00	0.00	79	12	1633	319	5.11912225705329	0.450392430882608	0.450392430882608	true	false	false	true
d7505242-f2be-42dd-8a8b-2560f64afcee	2026-09-22 10:52	2026-09-22 10:52	2026-09-22 10:52	CRM	CRM261016P00210000	put	210.0000	2026-10-16	1.8800	1.7600	1.9100	232.2150	80088.00	79900.00	188.00	426	46	572	1765	0.324079320113314	0.401282618399535	0.401282618399535	false	false	false	true
fc99137b-af31-43c3-b286-f786a883e150	2026-09-22 10:48	2026-09-22 10:47	2026-09-22 10:47	CRM	CRM261002C00247500	call	247.5000	2026-10-02	1.4200	1.1700	1.6500	232.1800	71569.00	284.00	71142.00	504	52	508	75	6.77333333333333	0.395593713084571	0.395481036603362	false	false	false	true
869444a3-3d9f-4ac7-9543-aecde5d10a17	2026-09-22 10:48	2026-09-22 10:47	2026-09-22 10:47	CRM	CRM261002C00242500	call	242.5000	2026-10-02	2.3800	2.3800	2.6400	232.2300	87346.00	0.00	87346.00	367	33	379	87	4.35632183908046	0.391246796203501	0.391246796203501	false	false	false	true
0326ec20-9e6d-4f1a-8a4b-271b56ae60d8	2026-09-22 10:43	2026-09-22 10:43	2026-09-22 10:43	CRM	CRM260925C00250000	call	250.0000	2026-09-25	0.1700	0.1700	0.2000	232.2050	13601.00	0.00	13601.00	800	6	2178	1526	1.42726081258191	0.466699384577183	0.466699384577183	false	false	false	true
dfd25744-c839-42a6-b162-a0b21c829b83	2026-09-22 09:59	2026-09-22 09:59	2026-09-22 09:59	CRM	CRM270917P00210000	put	210.0000	2027-09-17	24.1000	23.2500	24.1000	235.0000	106035.00	103625.00	0.00	44	11	44	64	0.6875	0.454529737126795	0.454529737126795	false	false	false	true
0130b058-f3c8-401e-b088-e307b3d2bbf7	2026-09-22 09:49	2026-09-22 09:49	2026-09-22 09:49	CRM	CRM270319C00280000	call	280.0000	2027-03-19	15.8000	15.5500	15.8000	236.6000	17380.00	6320.00	0.00	11	9	11	450	0.0244444444444444	0.438938250103902	0.438938250103902	false	false	false	true
3ec85e3a-f914-4560-9fa5-6d8ff77e6f60	2026-09-22 09:43	2026-09-22 09:43	2026-09-22 09:43	CRM	CRM270617P00145000	put	145.0000	2027-06-17	3.7000	3.0000	3.7500	237.0000	18500.00	18130.00	370.00	50	19	50	1281	0.039032006245121	0.48602755965531	0.48602755965531	true	false	false	true
143653e4-c12e-438d-8c1f-55275581d15b	2026-09-22 09:31	2026-09-22 09:30	2026-09-22 09:30	CRM	CRM260925C00250000	call	250.0000	2026-09-25	1.2800	0.9400	1.2800	241.4600	102400.00	102400.00	0.00	800	6	816	1526	0.534731323722149	0.476169575386226	0.476169575386226	false	false	false	true
546af2b6-1b3c-4015-a9de-e75a59eec831	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	CRM	CRM260925C00242500	call	242.5000	2026-09-25	2.9800	2.9800	4.0500	241.5800	39932.00	0.00	39932.00	134	14	167	1628	0.102579852579853	0.386635843641872	0.386635843641872	true	false	false	true
a1618aca-fb94-4321-b1a2-e517c957fc2c	2026-09-21 15:28	2026-09-21 15:28	2026-09-21 15:28	CRM	CRM261016C00220000	call	220.0000	2026-10-16	21.4000	21.1000	21.4000	237.6300	21400.00	8560.00	0.00	10	6	37	1542	0.0239948119325551	0.405933597832741	0.405933597832741	false	false	false	true
bffa00c7-8f29-48e2-824e-c507113ef9fd	2026-09-21 14:48	2026-09-21 14:48	2026-09-21 14:48	CRM	CRM261016P00237500	put	237.5000	2026-10-16	9.4500	9.3000	9.4500	237.0000	565110.00	565110.00	0.00	598	42	622	0	0	0.386838606122297	0.386838606122297	false	false	false	true
e026ffe7-3a6d-4c3c-a72a-dacf3ee6a9a9	2026-09-21 14:36	2026-09-21 14:36	2026-09-21 14:36	CRM	CRM260925C00242500	call	242.5000	2026-09-25	1.9500	1.9000	2.0000	236.9500	27300.00	7800.00	0.00	140	12	1383	451	3.06651884700665	0.410810925099242	0.410810925099242	false	false	false	true
3c41e491-7fd1-42dc-960f-e0bfb82e06e4	2026-09-21 14:35	2026-09-21 14:35	2026-09-21 14:35	CRM	CRM261016P00240000	put	240.0000	2026-10-16	10.7500	10.5000	10.7500	237.0400	153725.00	153725.00	0.00	143	28	319	3494	0.09129937034917	0.384231771940011	0.384231771940011	false	false	false	true
2b6d896f-6ea4-4fd8-8792-f39998ed7f25	2026-09-21 14:35	2026-09-21 14:35	2026-09-21 14:35	CRM	CRM261016P00230000	put	230.0000	2026-10-16	6.0500	5.9000	6.0500	237.0400	194202.00	194202.00	0.00	321	50	400	5241	0.0763213127265789	0.385791995192072	0.385791995192072	false	false	false	true
4c53c4f2-d905-4617-8a87-8327284f18f7	2026-09-21 14:35	2026-09-21 14:35	2026-09-21 14:35	CRM	CRM261016C00235000	call	235.0000	2026-10-16	11.0200	10.8500	11.1500	237.2300	18734.00	18734.00	0.00	17	5	114	0	0	0.386750920063105	0.386750920063105	false	false	false	true
24e97776-013d-4db2-84f4-6c98f6fc05c8	2026-09-21 14:13	2026-09-21 14:13	2026-09-21 14:13	CRM	CRM260925P00235000	put	235.0000	2026-09-25	2.7000	2.7000	2.8100	237.8050	15120.00	0.00	15120.00	56	5	1398	1273	1.09819324430479	0.403858685550511	0.403858685550511	false	false	false	true
bcc36602-d850-4dca-bf57-1957e3afdc28	2026-09-21 13:34	2026-09-21 13:34	2026-09-21 13:34	CRM	CRM260925C00242500	call	242.5000	2026-09-25	2.4100	2.3600	2.4600	238.0000	24077.00	0.00	3592.00	100	5	667	451	1.47893569844789	0.415886831749537	0.415886831749537	false	false	false	true
62e55ee1-fa66-41d0-a33f-96fab4a92d55	2026-09-21 12:58	2026-09-21 12:58	2026-09-21 12:58	CRM	CRM270319P00220000	put	220.0000	2027-03-19	18.3500	18.1000	18.5000	237.8550	12845.00	1835.00	11010.00	7	7	7	318	0.0220125786163522	0.444394629272518	0.446488142810585	false	false	false	true
ff71456c-9141-4be1-b7ef-5367d5cc14d6	2026-09-21 12:54	2026-09-21 12:54	2026-09-21 12:54	CRM	CRM261016C00265000	call	265.0000	2026-10-16	1.9700	1.9700	2.0200	237.0000	22852.00	0.00	22852.00	116	13	339	0	0	0.391181075748804	0.391181075748804	false	false	false	true
a2e4dcfb-1fe7-4628-9774-d35eb4dbdc3f	2026-09-21 12:54	2026-09-21 12:54	2026-09-21 12:54	CRM	CRM261016C00265000	call	265.0000	2026-10-16	1.9600	1.9600	2.0600	237.0000	39984.00	0.00	39984.00	204	25	223	0	0	0.390257054629974	0.390257054629974	false	false	false	true
9a6dcbc4-fd64-4dd4-ab06-35009819c7b5	2026-09-21 12:46	2026-09-21 12:46	2026-09-21 12:46	CRM	CRM261016C00237500	call	237.5000	2026-10-16	10.1500	10.1500	10.6500	238.0200	20300.00	0.00	20300.00	20	5	20	0	0	0.385646244763439	0.385646244763439	false	false	false	true
974433a3-cc28-4999-b80f-945767d7bcca	2026-09-21 12:07	2026-09-21 12:07	2026-09-21 12:07	CRM	CRM270115C00260000	call	260.0000	2027-01-15	15.1000	15.1000	15.5000	237.6000	37750.00	0.00	37750.00	25	7	548	8902	0.0615592001797349	0.42143960553829	0.42143960553829	false	false	false	true
8f6b4e65-6393-4b61-8c40-085a525d0294	2026-09-21 11:55	2026-09-21 11:54	2026-09-21 11:54	CRM	CRM270319P00210000	put	210.0000	2027-03-19	14.5000	14.5000	14.8000	237.7600	42050.00	0.00	42050.00	29	10	250	647	0.386398763523957	0.448643429568445	0.448643429568445	false	false	false	true
157a1d27-5b2d-460b-8eb6-c631fe9f2c66	2026-09-21 11:50	2026-09-21 11:50	2026-09-21 11:50	CRM	CRM261120P00240000	put	240.0000	2026-11-20	15.5900	15.3500	15.6000	238.2200	90425.00	73320.00	17105.00	58	25	73	2817	0.0259140930067448	0.402985510634933	0.402985510634933	false	false	false	true
287196a4-4a08-402a-9e89-c88a6dbfa07d	2026-09-21 11:30	2026-09-21 11:30	2026-09-21 11:30	CRM	CRM261120P00220000	put	220.0000	2026-11-20	7.1000	7.1000	7.2500	237.9750	117150.00	0.00	117150.00	165	7	346	547	0.63254113345521	0.402722702024434	0.402722702024434	true	false	false	true
354deaf1-97f9-4242-99ea-f29c69f178e1	2026-09-21 11:28	2026-09-21 11:28	2026-09-21 11:28	CRM	CRM261009P00240000	put	240.0000	2026-10-09	9.0000	8.6500	9.0500	238.1200	580500.00	579600.00	900.00	645	55	645	98	6.58163265306122	0.39125161996908	0.39125161996908	false	false	false	true
2d53ee45-df87-4d4d-be5d-abc1c056f086	2026-09-21 11:28	2026-09-21 11:28	2026-09-21 11:28	CRM	CRM261009P00235000	put	235.0000	2026-10-09	6.5500	6.2500	6.5500	238.1200	207630.00	207630.00	0.00	317	30	320	176	1.81818181818182	0.392543833041129	0.392543833041129	false	false	false	true