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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×er_time = unknown×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	expiry

76d64cec-5409-4850-8f3d-9629b97f10f0	2026-09-23 15:57	2026-09-23 15:57	2026-09-23 15:57	CRM	CRM270115C00300000	call	300.0000	2027-01-15	6.3500	6.3500	7.0500	237.6325	16510.00	0.00	16510.00	26	7	145	7534	0.0192460844173082	0.433715338037686	0.433715338037686	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	195528340000.00	2026-12-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T19:57:58.068578Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
2e37a042-f6d5-4a34-849d-cfd62109ffbe	2026-09-23 15:54	2026-09-23 15:54	2026-09-23 15:54	CRM	CRM261002C00235000	call	235.0000	2026-10-02	8.5000	7.7500	8.5000	238.2050	21250.00	21250.00	0.00	25	5	278	434	0.640552995391705	0.448416219311318	0.448416219311318	false	false	false	true
a75dee7c-d890-4192-8f2d-0ee59af70a13	2026-09-23 15:54	2026-09-23 15:54	2026-09-23 15:54	CRM	CRM260925P00237500	put	237.5000	2026-09-25	2.6300	2.5300	2.6300	238.4500	29978.00	28930.00	1048.00	114	38	633	472	1.34110169491525	0.441916344463804	0.440481173397521	false	false	false	true
0586b5f7-552e-4165-b9a3-9f0559a21285	2026-09-23 15:50	2026-09-23 15:50	2026-09-23 15:50	CRM	CRM261002C00242500	call	242.5000	2026-10-02	4.8000	4.5000	4.8000	239.2200	238080.00	238080.00	0.00	496	7	871	411	2.11922141119221	0.411382105468027	0.411382105468027	true	false	false	true
40d06feb-8f5d-4f45-a5b2-3e7c3b48f4cb	2026-09-23 15:49	2026-09-23 15:49	2026-09-23 15:49	CRM	CRM261002P00230000	put	230.0000	2026-10-02	2.5000	2.3400	2.5000	239.0700	16000.00	16000.00	0.00	64	9	404	1245	0.324497991967871	0.411721917062185	0.411721917062185	false	false	false	true
59477f42-717d-4231-8105-81e8efe89a34	2026-09-23 14:18	2026-09-23 14:18	2026-09-23 14:18	CRM	CRM270219C00270000	call	270.0000	2027-02-19	16.2000	16.1500	16.6000	239.4050	35640.00	21060.00	14580.00	22	8	32	291	0.109965635738832	0.424920039213102	0.424920039213102	false	false	false	true
2f60a926-515a-484a-b960-cfac9d1e020d	2026-09-23 13:34	2026-09-23 13:34	2026-09-23 13:34	CRM	CRM260925C00245000	call	245.0000	2026-09-25	1.3400	1.2700	1.3500	239.5850	85358.00	63382.00	21842.00	637	31	3274	2282	1.43470639789658	0.470732380637774	0.470044354884219	false	false	false	true
6aef405b-e50a-45b3-a947-6f7df15a28fa	2026-09-23 13:30	2026-09-23 13:30	2026-09-23 13:30	CRM	CRM261120C00230000	call	230.0000	2026-11-20	21.5000	21.5000	22.0000	239.0000	21500.00	0.00	21500.00	10	7	63	2243	0.0280873829692376	0.411147566733855	0.411147566733855	true	false	false	true
c49b2204-ecfb-4a5f-a38e-98265f991cdd	2026-09-23 12:59	2026-09-23 12:58	2026-09-23 12:58	CRM	CRM260925C00237500	call	237.5000	2026-09-25	5.2500	5.2000	5.4500	240.8900	339675.00	525.00	339150.00	647	63	1079	1045	1.03253588516746	0.459154979247221	0.459154979247221	false	false	false	true
631e67c1-5717-4369-ad53-989727898e7c	2026-09-23 12:55	2026-09-23 12:55	2026-09-23 12:55	CRM	CRM260925C00242500	call	242.5000	2026-09-25	2.6400	2.4700	2.6700	240.7300	11871.00	11871.00	0.00	45	5	1304	1263	1.03246239113222	0.485151251124946	0.485151251124946	false	false	false	true
3372e5e5-010f-454e-aa0b-ffca53ac87dc	2026-09-23 12:45	2026-09-23 12:45	2026-09-23 12:45	CRM	CRM270617C00270000	call	270.0000	2027-06-17	27.4000	27.4000	27.7000	239.6700	49320.00	0.00	49320.00	18	12	72	486	0.148148148148148	0.438675853824478	0.438675853824478	false	false	false	true
c6056b7f-f750-4fea-9ccd-d0ecee4f5993	2026-09-23 12:45	2026-09-23 12:45	2026-09-23 12:45	CRM	CRM270617C00270000	call	270.0000	2027-06-17	27.4000	27.4000	27.7000	239.6000	49320.00	0.00	49320.00	18	10	54	486	0.111111111111111	0.439089343245961	0.439089343245961	false	false	false	true
6a0eb6f7-e779-432c-9ee9-724f5b00af7a	2026-09-23 12:43	2026-09-23 12:43	2026-09-23 12:43	CRM	CRM261218C00260000	call	260.0000	2026-12-18	13.4000	13.2000	13.4500	239.0000	296140.00	191620.00	104520.00	221	31	246	1626	0.151291512915129	0.439864688296036	0.439864688296036	false	false	false	true
45d82bae-a91a-43bd-90e3-1aaadfdeea4f	2026-09-23 12:39	2026-09-23 12:39	2026-09-23 12:39	CRM	CRM290119P00200000	put	200.0000	2029-01-19	33.1000	32.8000	33.4000	239.0000	102610.00	99300.00	3310.00	31	7	100	44	2.27272727272727	0.470634991814668	0.470614500466837	false	false	false	true
bcc38a6d-067c-439f-bd53-869e70b57d9e	2026-09-23 12:32	2026-09-23 12:32	2026-09-23 12:32	CRM	CRM270319P00195000	put	195.0000	2027-03-19	9.4300	9.0500	9.8000	239.6900	207460.00	124740.00	82720.00	220	2	220	304	0.723684210526316	0.457138271313443	0.457138271313443	false	true	false	true
c3f410d8-4ead-4f85-8b55-7c6e6c99719e	2026-09-23 12:14	2026-09-23 12:14	2026-09-23 12:14	CRM	CRM260925C00245000	call	245.0000	2026-09-25	1.2300	1.1400	1.2300	238.9700	21525.00	21525.00	0.00	175	37	1798	2282	0.787905346187555	0.478559644154398	0.478559644154398	true	false	false	true
423f6ce9-42f7-4b3e-8023-699474af56a9	2026-09-23 11:53	2026-09-23 11:53	2026-09-23 11:53	CRM	CRM260925P00235000	put	235.0000	2026-09-25	1.8200	1.7000	1.8400	238.0000	40126.00	32194.00	7932.00	220	20	827	1511	0.547319655857048	0.474064176101989	0.475632857274106	true	false	false	true
463bb19c-b10b-468f-a5c4-2b0e64d420cc	2026-09-23 11:30	2026-09-23 11:30	2026-09-23 11:30	CRM	CRM261023C00235000	call	235.0000	2026-10-23	12.8000	12.6000	12.8000	237.0000	30720.00	30720.00	0.00	24	6	40	63	0.634920634920635	0.402682803434299	0.402682803434299	false	false	false	true
53e67b81-01e0-41f7-af93-5ba4adf426ad	2026-09-23 11:23	2026-09-23 11:23	2026-09-23 11:23	CRM	CRM260925C00240000	call	240.0000	2026-09-25	2.4700	2.4700	2.5200	238.1100	37050.00	0.00	37050.00	150	9	2812	2888	0.973684210526316	0.468659831408637	0.468659831408637	false	false	false	true
ef64d449-cfe3-4f16-9ff2-743d876b6497	2026-09-23 10:59	2026-09-23 10:59	2026-09-23 10:59	CRM	CRM261016C00260000	call	260.0000	2026-10-16	2.7000	2.7000	2.7900	238.0000	19980.00	0.00	19980.00	74	5	292	2568	0.113707165109034	0.395166235238002	0.395166235238002	false	false	false	true
9c2a5089-28a2-42ea-a6ba-ebac12ed163a	2026-09-23 10:48	2026-09-23 10:48	2026-09-23 10:48	CRM	CRM260925C00245000	call	245.0000	2026-09-25	1.1400	1.0200	1.1400	238.1450	19950.00	19950.00	0.00	175	38	808	2282	0.35407537248028	0.498022160055041	0.498022160055041	false	false	false	true
16a77ada-98c5-4abe-b7af-dbada3381459	2026-09-23 10:27	2026-09-23 10:27	2026-09-23 10:27	CRM	CRM260925P00235000	put	235.0000	2026-09-25	2.6200	2.4900	2.6900	236.8250	18600.00	18340.00	260.00	71	22	360	1511	0.238252812706817	0.49928979214022	0.496350517174815	true	false	false	true
24dbd9dc-83d9-4490-9e9a-313d595befa8	2026-09-23 10:19	2026-09-23 10:19	2026-09-23 10:19	CRM	CRM260925C00240000	call	240.0000	2026-09-25	2.3000	2.1500	2.3500	237.0000	23919.00	14719.00	9200.00	104	8	2224	2888	0.770083102493075	0.492189141259363	0.487576800950478	false	false	false	true
67737760-354b-4e44-9e3f-ecdc813e6c7a	2026-09-23 10:07	2026-09-23 10:07	2026-09-23 10:07	CRM	CRM270115C00240000	call	240.0000	2027-01-15	22.3000	22.1000	22.3000	236.0000	11150.00	11150.00	0.00	5	5	11	3430	0.00320699708454811	0.427983690101005	0.427983690101005	false	false	false	true
6b0bed31-c261-4ca8-8baf-3ebb62eb6865	2026-09-23 10:06	2026-09-23 10:05	2026-09-23 10:05	CRM	CRM270115C00240000	call	240.0000	2027-01-15	22.2000	21.9000	22.2000	236.0000	11100.00	11100.00	0.00	5	5	5	3430	0.00145772594752187	0.428980521582554	0.428980521582554	false	false	false	true
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
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