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

ba523cf2-1b37-4899-bcf4-8e149df10899	2026-09-04 10:47	2026-09-04 10:47	2026-09-04 10:47	CRM	CRM260911C00267500	call	267.5000	2026-09-11	2.1600	2.0500	2.1600	259.7700	60479.00	60479.00	0.00	280	31	664	898	0.739420935412027	0.347555069333649	0.346735083194107	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	213510890000.00	2026-12-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
43cdbb49-e027-4c0f-b3e2-3253755677f5	2026-09-04 10:13	2026-09-04 10:13	2026-09-04 10:13	CRM	CRM260911C00262500	call	262.5000	2026-09-11	4.0500	4.0500	4.2000	260.2100	100845.00	0.00	100845.00	249	8	421	273	1.54212454212454	0.348465163649552	0.348465163649552	true	false	false	true
786bfe30-7dfb-4c10-89c5-f8fde0297538	2026-09-04 10:03	2026-09-04 10:03	2026-09-04 10:03	CRM	CRM260918P00260000	put	260.0000	2026-09-18	7.7500	7.7500	7.8000	260.3600	155000.00	0.00	155000.00	200	5	675	2274	0.296833773087071	0.399490718636274	0.399490718636274	false	false	false	true
594bfa38-f4fe-49cf-a5ed-79755588d7f2	2026-09-04 10:02	2026-09-04 10:01	2026-09-04 10:01	CRM	CRM260925P00260000	put	260.0000	2026-09-25	9.6000	9.6000	9.9000	259.3991	471360.00	0.00	471360.00	491	6	493	2149	0.22940902745463	0.386289639434237	0.386289639434237	true	false	false	true
dde15761-3fab-4532-ad4d-a6aa81258cd6	2026-09-04 09:50	2026-09-04 09:50	2026-09-04 09:50	CRM	CRM260911C00270000	call	270.0000	2026-09-11	1.9000	1.9000	2.0900	260.0800	87020.00	0.00	87020.00	458	48	468	765	0.611764705882353	0.370018121926452	0.371210227866497	false	false	false	true
045b9158-5d11-47f2-9187-57c98bb3eb00	2026-09-03 15:49	2026-09-03 15:48	2026-09-03 15:48	CRM	CRM261002P00260000	put	260.0000	2026-10-02	8.8000	8.4000	8.8000	264.7700	54545.00	51920.00	0.00	62	11	491	59	8.32203389830508	0.38578361086798	0.38578361086798	false	false	false	true
260eff13-d110-4ed4-b90a-f49362920dc3	2026-09-03 15:39	2026-09-03 15:39	2026-09-03 15:39	CRM	CRM261218P00240000	put	240.0000	2026-12-18	12.0500	12.0500	12.3500	265.5000	51815.00	0.00	51815.00	43	10	367	3022	0.121442753143613	0.435239815338949	0.435239815338949	false	false	false	true
d707d098-32f2-4b99-95b0-a27c0fd2c9e9	2026-09-03 15:01	2026-09-03 15:01	2026-09-03 15:01	CRM	CRM261120P00300000	put	300.0000	2026-11-20	40.5000	40.2500	41.4500	266.1800	68850.00	60750.00	8100.00	17	17	19	22	0.863636363636364	0.407918748421375	0.407918748421375	false	false	false	true
63c7ed6a-6b2b-40cc-a174-2b6795c359af	2026-09-03 14:37	2026-09-03 14:37	2026-09-03 14:37	CRM	CRM260918C00230000	call	230.0000	2026-09-18	38.0500	37.9000	38.4000	267.5200	60880.00	57075.00	3805.00	16	8	132	6227	0.0211980086719126	0.381028419290142	0.381028419290142	false	false	false	true
d8b06908-8d9b-4134-9d2f-91d31ca97657	2026-09-03 14:09	2026-09-03 14:09	2026-09-03 14:09	CRM	CRM260918C00275000	call	275.0000	2026-09-18	4.8000	4.6000	4.8000	266.3700	208794.00	208794.00	0.00	435	47	740	1734	0.426758938869666	0.377816691125973	0.377816691125973	false	false	false	true
f6888b07-304a-4299-8d4d-eb2bb4e566bc	2026-09-03 13:54	2026-09-03 13:54	2026-09-03 13:54	CRM	CRM261002P00265000	put	265.0000	2026-10-02	10.8000	10.5000	11.3000	265.5360	305625.00	298080.00	7545.00	283	51	303	6	50.5	0.384713889993746	0.384713889993746	false	false	false	true
f1cce86a-2d0c-43f4-95ee-b41dd313013e	2026-09-03 13:37	2026-09-03 13:37	2026-09-03 13:37	CRM	CRM261016P00260000	put	260.0000	2026-10-16	10.8000	10.8000	11.0000	265.6079	108000.00	0.00	108000.00	100	8	773	837	0.923536439665472	0.387772296505898	0.387772296505898	true	false	false	true
34315d0c-0ac1-4618-a3ea-ca67b423180a	2026-09-03 12:18	2026-09-03 12:18	2026-09-03 12:18	CRM	CRM271217P00290000	put	290.0000	2027-12-17	60.0500	59.5000	60.0500	266.1900	246205.00	246205.00	0.00	41	14	71	174	0.408045977011494	0.463475336670173	0.463475336670173	false	false	false	true
3b238a68-252a-4a0c-94ef-45b61939acd2	2026-09-03 12:02	2026-09-03 12:02	2026-09-03 12:02	CRM	CRM270917C00290000	call	290.0000	2027-09-17	41.6000	40.5500	41.7000	264.7200	174715.00	141440.00	29115.00	42	16	43	131	0.32824427480916	0.435148465913429	0.434680562244011	true	false	false	true
994d13d5-a971-43bd-bc9e-f5990b8beee4	2026-09-03 11:41	2026-09-03 11:41	2026-09-03 11:41	CRM	CRM261016P00210000	put	210.0000	2026-10-16	0.9000	0.9000	0.9900	263.9400	65340.00	0.00	65340.00	726	58	784	1206	0.650082918739635	0.435806771067057	0.435806771067057	false	false	false	true
5098aa8d-949f-4672-813b-c151cc549dc2	2026-09-03 11:03	2026-09-03 11:03	2026-09-03 11:03	CRM	CRM260911P00262500	put	262.5000	2026-09-11	5.1000	5.0500	5.2500	263.9350	60690.00	2550.00	58140.00	119	14	359	174	2.0632183908046	0.37912335205691	0.37912335205691	true	false	false	true
ceae541b-171f-4945-a66d-001edf24a80d	2026-09-03 10:46	2026-09-03 10:46	2026-09-03 10:46	CRM	CRM270115P00200000	put	200.0000	2027-01-15	4.3000	4.3000	4.5000	265.0000	430000.00	0.00	430000.00	1000	30	5338	9021	0.591730406828511	0.447712717699246	0.447712717699246	false	false	false	true
46f063b0-48a6-4331-8e5d-04afc8e8e4d3	2026-09-03 10:43	2026-09-03 10:43	2026-09-03 10:43	CRM	CRM270115P00200000	put	200.0000	2027-01-15	4.4000	4.3500	4.6500	264.7700	433400.00	404360.00	29040.00	985	14	2313	9021	0.256401729298304	0.450171971143761	0.450171971143761	false	false	false	true
58c02b9d-b91d-41a2-85c0-2aed5f69543b	2026-09-03 10:43	2026-09-03 10:42	2026-09-03 10:42	CRM	CRM270115P00200000	put	200.0000	2027-01-15	4.3500	4.3500	4.6500	265.0400	435000.00	0.00	391500.00	1000	31	1328	9021	0.147212060747146	0.449512393108713	0.449512393108713	false	false	false	true
cb45c95f-8f5f-4830-aedd-49f9354cbed6	2026-09-03 10:42	2026-09-03 10:42	2026-09-03 10:42	CRM	CRM260925C00270000	call	270.0000	2026-09-25	7.6500	7.6000	8.1500	264.8400	155320.00	19920.00	135400.00	203	22	450	611	0.736497545008183	0.372868829370609	0.370922159636437	true	false	false	true
bd988154-f191-4026-af44-00a877ae20cc	2026-09-03 10:30	2026-09-03 10:30	2026-09-03 10:30	CRM	CRM260925C00270000	call	270.0000	2026-09-25	8.3500	8.3500	8.6500	266.1400	87675.00	0.00	87675.00	105	22	239	611	0.391162029459902	0.377046044026134	0.377046044026134	true	false	false	true
c3a80771-614f-4c37-abe3-74166f7e169d	2026-09-03 10:29	2026-09-03 10:29	2026-09-03 10:29	CRM	CRM260911P00247500	put	247.5000	2026-09-11	0.9800	0.9400	1.1700	265.9100	96530.00	294.00	96236.00	985	72	1180	124	9.51612903225806	0.422239896862741	0.421852565113333	false	false	false	true
3b3159f5-035c-4816-bfea-22703383a91f	2026-09-03 10:08	2026-09-03 10:08	2026-09-03 10:08	CRM	CRM260925P00260000	put	260.0000	2026-09-25	6.8000	6.1000	6.8000	266.5900	159120.00	159120.00	0.00	234	5	297	1638	0.181318681318681	0.387832678129905	0.387832678129905	false	false	false	true
5f7cfdd7-1a0c-4946-a1ca-b624bd4c3648	2026-09-03 09:59	2026-09-03 09:59	2026-09-03 09:59	CRM	CRM261218P00250000	put	250.0000	2026-12-18	15.7500	15.4000	15.7500	265.9000	63000.00	63000.00	0.00	40	5	91	2436	0.0373563218390805	0.43415207603003	0.43415207603003	false	false	false	true
5b907f7e-8b2f-4253-a073-0db813c25c68	2026-09-03 09:35	2026-09-03 09:35	2026-09-03 09:35	CRM	CRM260918C00260000	call	260.0000	2026-09-18	11.0700	10.7500	11.1500	264.6600	102945.00	102945.00	0.00	93	11	298	7485	0.039812959251837	0.396564684596788	0.395213804157558	false	false	false	true
6581b039-8cf5-4ce6-b0cc-daa778d08a59	2026-09-02 15:17	2026-09-02 15:17	2026-09-02 15:17	CRM	CRM270319C00320000	call	320.0000	2027-03-19	14.6500	13.1000	14.6500	258.1950	57135.00	57135.00	0.00	39	12	43	7	6.14285714285714	0.4258801866047	0.4258801866047	false	false	false	true
0fc4a62a-c14f-41e8-bab4-75135e28198e	2026-09-02 14:16	2026-09-02 14:16	2026-09-02 14:16	CRM	CRM260925C00255000	call	255.0000	2026-09-25	10.2000	10.2000	10.3500	255.9900	63240.00	0.00	63240.00	62	8	76	127	0.598425196850394	0.366944923333397	0.366944923333397	false	false	false	true
30046381-7626-415c-8f1e-d0acbacf502d	2026-09-02 14:05	2026-09-02 14:05	2026-09-02 14:05	CRM	CRM271217P00250000	put	250.0000	2027-12-17	41.4000	41.1500	41.4000	255.7400	231840.00	231840.00	0.00	56	24	66	470	0.140425531914894	0.458896801806626	0.458896801806626	false	false	false	true
b182ddc2-9c21-40a0-b03e-c4e08e5cd93c	2026-09-02 13:22	2026-09-02 13:22	2026-09-02 13:22	CRM	CRM261120C00270000	call	270.0000	2026-11-20	12.7500	12.7500	12.9500	254.1400	255000.00	0.00	255000.00	200	5	827	2062	0.401066925315228	0.388047740268801	0.388047740268801	false	false	false	true
584f62b0-168c-4ced-a077-d717c19c9cef	2026-09-02 13:02	2026-09-02 13:02	2026-09-02 13:02	CRM	CRM260918C00220000	call	220.0000	2026-09-18	35.4500	35.2000	35.4500	254.7300	88625.00	88625.00	0.00	25	5	102	7657	0.013321144051195	0.410417151825527	0.410417151825527	true	false	false	true
04ece835-7447-4874-907e-d61a3942a490	2026-09-02 12:58	2026-09-02 12:58	2026-09-02 12:58	CRM	CRM260904P00252500	put	252.5000	2026-09-04	2.3200	2.2400	2.3200	255.0900	115536.00	115536.00	0.00	498	53	1477	402	3.67412935323383	0.469001452215645	0.464825421695034	false	false	false	true
7296f5ec-e3ea-44f3-a5a2-7ea0bfa25d16	2026-09-02 12:03	2026-09-02 12:03	2026-09-02 12:03	CRM	CRM261120C00270000	call	270.0000	2026-11-20	12.8500	12.3000	13.1000	254.2551	179900.00	60395.00	119505.00	140	7	461	2062	0.22356935014549	0.389158501275859	0.389158501275859	false	false	false	true
0637c047-2c02-48a6-aa36-8401415ec5e2	2026-09-02 10:46	2026-09-02 10:46	2026-09-02 10:46	CRM	CRM260918C00255000	call	255.0000	2026-09-18	9.4500	9.4500	9.8500	257.1700	76545.00	0.00	76545.00	81	14	94	582	0.161512027491409	0.378334746907937	0.378334746907937	false	false	false	true
cdf952d4-2da0-4753-b19a-bd6779ba98eb	2026-09-02 10:40	2026-09-02 10:40	2026-09-02 10:40	CRM	CRM260918C00260000	call	260.0000	2026-09-18	6.8500	6.7000	6.8500	256.6000	295920.00	295920.00	0.00	432	5	1693	5600	0.302321428571429	0.382648756604564	0.382648756604564	false	false	false	true
626c7795-d15b-4e97-8cd4-0632c6df56d1	2026-09-02 10:08	2026-09-02 10:08	2026-09-02 10:08	CRM	CRM260925P00260000	put	260.0000	2026-09-25	9.7000	9.1000	10.3000	259.8500	423890.00	413220.00	10670.00	437	5	1092	222	4.91891891891892	0.380945029959452	0.382405128146601	true	false	false	true
e81ccd0f-3288-4019-9a65-4eb3f8b954e0	2026-09-02 10:07	2026-09-02 10:07	2026-09-02 10:07	CRM	CRM261016C00240000	call	240.0000	2026-10-16	27.4500	27.2000	28.2000	261.2800	65870.00	2735.00	63135.00	24	20	74	1028	0.0719844357976654	0.386451000360572	0.382822880082243	true	false	false	true
ba522d41-e97d-4b06-9cf1-c10be9eb68ef	2026-09-02 10:07	2026-09-02 10:06	2026-09-02 10:06	CRM	CRM261016C00240000	call	240.0000	2026-10-16	27.4500	27.4500	28.3000	261.3250	118040.00	2750.00	19215.00	43	26	50	1028	0.0486381322957198	0.385196105068091	0.385196105068091	false	false	false	true
d783e1c4-4300-4b55-ab58-2e75ae470244	2026-09-02 10:01	2026-09-02 10:00	2026-09-02 10:00	CRM	CRM260925C00265000	call	265.0000	2026-09-25	8.8500	8.0500	9.8500	262.5600	665520.00	336300.00	329220.00	752	7	761	253	3.00790513833992	0.368446662553838	0.368632744134506	true	false	false	true
709e3372-5def-4d53-bd18-8077f34a0955	2026-09-02 09:54	2026-09-02 09:54	2026-09-02 09:54	CRM	CRM260904P00260000	put	260.0000	2026-09-04	3.0000	3.0000	3.3000	261.7650	60000.00	0.00	60000.00	200	7	731	2141	0.341429238673517	0.49871408302836	0.49871408302836	false	false	false	true
df15dcdd-3d49-442d-90bb-4d07f89b52eb	2026-09-02 09:34	2026-09-02 09:34	2026-09-02 09:34	CRM	CRM261120C00270000	call	270.0000	2026-11-20	18.0000	17.8000	18.3500	264.2150	408600.00	14400.00	394200.00	227	7	294	2062	0.142580019398642	0.39971057504149	0.39971057504149	false	false	false	true
5ffa0ef8-6cce-446c-9002-dfd664c03a39	2026-09-01 15:31	2026-09-01 15:30	2026-09-01 15:30	CRM	CRM270617P00280000	put	280.0000	2027-06-17	48.4500	47.7000	48.4500	258.7150	62985.00	62985.00	0.00	13	8	26	297	0.0875420875420875	0.44124588605174	0.44124588605174	false	false	false	true
d37eeca2-dd01-417c-8857-46045980d098	2026-09-01 14:57	2026-09-01 14:57	2026-09-01 14:57	CRM	CRM260904C00257500	call	257.5000	2026-09-04	4.2000	3.9500	4.2000	257.1000	177240.00	177240.00	0.00	422	49	1179	408	2.88970588235294	0.468345160830834	0.468345160830834	false	false	false	true
16a0f5f1-b6b1-4975-9ef9-b6c09586a1c2	2026-09-01 12:44	2026-09-01 12:44	2026-09-01 12:44	CRM	CRM260904P00260000	put	260.0000	2026-09-04	7.1500	7.0000	7.5000	254.9700	895816.00	7060.00	888756.00	1253	72	2700	1068	2.52808988764045	0.466254154640446	0.453590487404152	false	false	false	true
ec222897-fb8c-4665-b791-368384d68fa8	2026-09-01 12:42	2026-09-01 12:42	2026-09-01 12:42	CRM	CRM260918P00275000	put	275.0000	2026-09-18	22.5000	20.8500	23.1500	254.6700	216000.00	216000.00	0.00	96	7	265	77	3.44155844155844	0.415068485178218	0.415068485178218	false	false	false	true
2cadde78-dfdd-4be6-bab4-bb998c67327d	2026-09-01 11:48	2026-09-01 11:47	2026-09-01 11:47	CRM	CRM261016C00260000	call	260.0000	2026-10-16	13.5000	13.5000	13.6500	258.3700	135000.00	0.00	135000.00	100	13	273	1614	0.169144981412639	0.378357627788525	0.378357627788525	true	false	false	true
a2797dd9-2d44-4d49-bd1f-0fcfd494d28b	2026-09-01 11:40	2026-09-01 11:40	2026-09-01 11:40	CRM	CRM260904P00250000	put	250.0000	2026-09-04	1.3500	1.3500	1.4100	257.8800	103950.00	0.00	103950.00	770	8	3021	1813	1.66629895201324	0.455018815659922	0.455018815659922	false	false	false	true
607fa54f-a69f-4cc8-b2ac-7cb9abfb782c	2026-09-01 10:34	2026-09-01 10:34	2026-09-01 10:34	CRM	CRM261218C00300000	call	300.0000	2026-12-18	11.5000	11.0000	11.5000	261.0450	115000.00	115000.00	0.00	100	5	116	2690	0.0431226765799256	0.421141563479218	0.421141563479218	false	false	false	true
e1fa1533-2873-4860-aa3d-9b36c75e7cdd	2026-09-01 10:25	2026-09-01 10:25	2026-09-01 10:25	CRM	CRM260911P00260000	put	260.0000	2026-09-11	6.6000	6.3500	6.6000	259.4050	50820.00	50820.00	0.00	77	5	341	1281	0.266198282591725	0.375972219164943	0.375538334063417	false	false	false	true
763572aa-04aa-4bbc-b1f7-5562601148b0	2026-09-01 10:23	2026-09-01 10:23	2026-09-01 10:23	CRM	CRM260904P00267500	put	267.5000	2026-09-04	9.6000	9.6000	10.0000	259.0650	177600.00	0.00	177600.00	185	8	185	459	0.403050108932462	0.436699516670059	0.436699516670059	false	false	false	true
f9147f7f-a0b4-4d96-b02d-74e1c750d640	2026-08-31 15:53	2026-08-31 15:53	2026-08-31 15:53	CRM	CRM270617P00260000	put	260.0000	2027-06-17	37.1000	36.6000	37.2000	258.8100	115010.00	115010.00	0.00	31	7	187	450	0.415555555555556	0.450655489790194	0.450655489790194	false	false	false	true