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

ed2b400a-5247-4ba3-a8bd-b8fd577a1033	2026-08-28 09:47	2026-08-28 09:47	2026-08-28 09:47	CRM	CRM260828P00260000	put	260.0000	2026-08-28	3.1500	2.9200	3.2000	259.0100	60470.00	47250.00	13220.00	192	15	645	55	11.7272727272727	0.953887843416813	0.917184549892001	false	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-08-28T13:57:11.446067Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
aa8ce0e1-496d-4995-bf6c-a5d5565f4fc1	2026-08-28 09:46	2026-08-28 09:46	2026-08-28 09:46	CRM	CRM260918C00260000	call	260.0000	2026-09-18	9.3500	8.9500	9.3500	258.3000	59840.00	59840.00	0.00	64	10	729	5836	0.124914324880055	0.400100283719767	0.400100283719767	true	false	false	true
4c59f68d-da96-44e0-9176-6b2cf775e35c	2026-08-28 09:44	2026-08-28 09:44	2026-08-28 09:44	CRM	CRM261120P00260000	put	260.0000	2026-11-20	21.0000	20.7500	22.0500	256.2300	168000.00	77700.00	90300.00	80	7	88	61	1.44262295081967	0.411493562002377	0.411493562002377	false	false	false	true
b49769ef-bea9-4011-b24a-c656871ed476	2026-08-28 09:33	2026-08-28 09:33	2026-08-28 09:33	CRM	CRM260828C00260000	call	260.0000	2026-08-28	1.3500	1.2300	1.3800	256.2220	116100.00	116100.00	0.00	860	29	5095	8816	0.577926497277677	1.04606942170685	1.01969577854171	true	false	false	true
0ae48822-aac8-4114-afad-569350d2eefb	2026-08-27 15:56	2026-08-27 15:56	2026-08-27 15:56	CRM	CRM260828C00237500	call	237.5000	2026-08-28	16.1000	14.7500	16.1000	253.3700	161000.00	161000.00	0.00	100	8	4435	1629	2.72252915899325	0.755094838734728	0.755094838734728	true	false	false	true
0de615bd-48fc-4d28-b102-a2cf050ab65f	2026-08-27 15:43	2026-08-27 15:43	2026-08-27 15:43	CRM	CRM270115P00200000	put	200.0000	2027-01-15	6.0000	6.0000	6.5500	253.4450	118800.00	0.00	118800.00	198	9	6671	3101	2.15124153498871	0.443804662289356	0.443804662289356	false	false	false	true
35970929-8fbc-42b4-b5e7-e75bed7785ec	2026-08-27 15:27	2026-08-27 15:26	2026-08-27 15:26	CRM	CRM270115C00270000	call	270.0000	2027-01-15	21.0000	21.0000	21.4500	251.0000	58800.00	0.00	58800.00	28	6	2196	2301	0.954367666232073	0.428169534199349	0.428169534199349	false	false	false	true
7addec35-5c2d-49a6-bbe8-5d88fd7c7104	2026-08-27 15:26	2026-08-27 15:26	2026-08-27 15:26	CRM	CRM260828C00252500	call	252.5000	2026-08-28	3.6000	3.5000	3.7500	252.0000	72000.00	50760.00	21240.00	200	5	12459	128	97.3359375	0.714562684770385	0.714562684770385	false	false	false	true
060a3757-c6f0-4144-bed1-24974186e37c	2026-08-27 15:24	2026-08-27 15:23	2026-08-27 15:23	CRM	CRM260828C00250000	call	250.0000	2026-08-28	5.1000	5.0500	5.3000	252.0000	107612.00	0.00	107612.00	211	6	30077	2614	11.5061208875287	0.724679030557804	0.734157946535387	false	false	false	true
359c936c-5192-4e66-848b-3f074667419f	2026-08-27 15:20	2026-08-27 15:20	2026-08-27 15:20	CRM	CRM270617C00300000	call	300.0000	2027-06-17	26.5000	26.3000	26.5000	252.0000	53000.00	53000.00	0.00	20	12	292	7779	0.0375369584779535	0.446628003197065	0.446628003197065	false	false	false	true
63a2501b-9a48-4f74-bda1-311215375856	2026-08-27 15:14	2026-08-27 15:14	2026-08-27 15:14	CRM	CRM261218C00300000	call	300.0000	2026-12-18	10.0000	9.7000	10.0000	252.0000	107000.00	107000.00	0.00	107	9	1038	2259	0.459495351925631	0.436100177256391	0.436100177256391	false	false	false	true
3c9cd619-70f6-4f33-8352-193be7415540	2026-08-27 14:53	2026-08-27 14:53	2026-08-27 14:53	CRM	CRM260918C00260000	call	260.0000	2026-09-18	7.0200	6.9000	7.0500	251.9100	140400.00	140400.00	0.00	200	5	6451	2200	2.93227272727273	0.413072639326099	0.413072639326099	false	false	false	true
15178f32-e6e1-4ee7-b009-f090f46ff6aa	2026-08-27 14:52	2026-08-27 14:52	2026-08-27 14:52	CRM	CRM271217C00260000	call	260.0000	2027-12-17	54.2900	53.3000	54.3500	251.6950	222585.00	114035.00	108550.00	41	5	1042	278	3.74820143884892	0.458677755278482	0.459134050840616	false	false	false	true
03da4953-a471-4fe3-9d10-26cd5154f670	2026-08-27 14:52	2026-08-27 14:52	2026-08-27 14:52	CRM	CRM271217C00260000	call	260.0000	2027-12-17	54.3500	53.3000	54.3500	251.6950	108700.00	108700.00	0.00	20	12	1062	278	3.82014388489209	0.459134050840616	0.459134050840616	false	false	false	true
d0c7a1e4-14c5-4f32-8879-d117ce925039	2026-08-27 14:52	2026-08-27 14:52	2026-08-27 14:52	CRM	CRM271217C00250000	call	250.0000	2027-12-17	58.3000	57.1500	58.3000	251.6500	99105.00	93280.00	5825.00	17	6	796	872	0.912844036697248	0.458498888319155	0.458498888319155	false	false	false	true
8e55f031-7b4a-4806-8409-554074a88441	2026-08-27 14:16	2026-08-27 14:15	2026-08-27 14:15	CRM	CRM270319C00220000	call	220.0000	2027-03-19	50.7000	50.1000	50.9500	249.5850	157165.00	136885.00	20280.00	31	10	174	995	0.174874371859296	0.441567538509581	0.4407557177066	false	false	false	true
4858341c-0fa3-4963-b032-c0e2f9128d99	2026-08-27 14:08	2026-08-27 14:08	2026-08-27 14:08	CRM	CRM261218C00250000	call	250.0000	2026-12-18	24.8000	24.8000	25.5000	249.2800	52080.00	0.00	52080.00	21	8	2199	5775	0.380779220779221	0.430389947295739	0.430389947295739	false	false	false	true
bd2a0896-270a-470d-9309-703919e83d52	2026-08-27 14:07	2026-08-27 14:06	2026-08-27 14:06	CRM	CRM260828C00252500	call	252.5000	2026-08-28	2.4400	2.4200	2.6700	249.7875	54900.00	0.00	54900.00	225	10	10734	128	83.859375	0.692062181005059	0.691478429324034	false	false	false	true
46199109-5827-4d51-94d4-dd744adac536	2026-08-27 14:02	2026-08-27 14:01	2026-08-27 14:01	CRM	CRM261218C00250000	call	250.0000	2026-12-18	25.4000	25.3500	26.0500	250.3036	58420.00	0.00	58420.00	23	10	2177	5775	0.376969696969697	0.430765637808951	0.430765637808951	false	false	false	true
b04b5ca7-5835-48eb-b0e4-767e5c02bfd0	2026-08-27 13:42	2026-08-27 13:42	2026-08-27 13:42	CRM	CRM260828C00252500	call	252.5000	2026-08-28	3.5000	3.4000	3.5000	251.7004	74550.00	74550.00	0.00	213	5	8798	128	68.734375	0.736063507490822	0.736063507490822	false	false	false	true
954d7cc7-1d43-45e9-a5b0-c43214191a30	2026-08-27 13:41	2026-08-27 13:41	2026-08-27 13:41	CRM	CRM260828C00252500	call	252.5000	2026-08-28	3.4000	3.3000	3.4000	251.5200	97580.00	97580.00	0.00	287	20	8271	128	64.6171875	0.733226007414232	0.733234952905828	false	false	false	true
9eef8ab3-8fc8-4727-b9ac-5111094c080c	2026-08-27 13:33	2026-08-27 13:33	2026-08-27 13:33	CRM	CRM271217C00250000	call	250.0000	2027-12-17	56.7900	55.3500	56.8500	249.9500	244200.00	130650.00	113550.00	43	6	556	872	0.637614678899083	0.454719250302042	0.454719250302042	false	false	false	true
1c5247f4-5f99-42fb-97a3-b7fdb9c019da	2026-08-27 13:14	2026-08-27 13:14	2026-08-27 13:14	CRM	CRM270617C00370000	call	370.0000	2027-06-17	11.6500	11.4500	11.7000	249.5400	92035.00	76890.00	15145.00	79	7	98	157	0.624203821656051	0.443783704690505	0.443783704690505	false	false	false	true
76cf62af-8b71-43b5-8f66-a4840c12dc30	2026-08-27 13:11	2026-08-27 13:11	2026-08-27 13:11	CRM	CRM261016C00250000	call	250.0000	2026-10-16	14.8500	14.6500	14.9500	249.4900	96525.00	1485.00	95040.00	65	5	1048	963	1.08826583592939	0.393290848539113	0.393290848539113	true	false	false	true
56631536-44f5-4afa-ba1a-98d962f92dd9	2026-08-27 13:10	2026-08-27 13:10	2026-08-27 13:10	CRM	CRM260918P00210000	put	210.0000	2026-09-18	0.5600	0.5600	0.6700	249.4000	64960.00	0.00	64960.00	1160	50	1888	3978	0.474610356963298	0.440661182788082	0.440661182788082	false	false	false	true
e2156ee8-8ad6-4396-9ee9-f699bddd8e81	2026-08-27 13:00	2026-08-27 13:00	2026-08-27 13:00	CRM	CRM281215P00240000	put	240.0000	2028-12-15	51.8500	51.3500	51.8500	248.4988	124440.00	10370.00	0.00	24	5	124	5	24.8	0.478461846854464	0.478461846854464	false	false	false	true
6424fc75-be01-4619-b38a-37b3f35d44f6	2026-08-27 12:59	2026-08-27 12:59	2026-08-27 12:59	CRM	CRM281215P00240000	put	240.0000	2028-12-15	51.8500	51.3500	51.8500	248.7350	186660.00	186660.00	0.00	36	5	89	5	17.8	0.478994989454105	0.478994989454105	false	false	false	true
0782cbf2-aabf-441c-9df3-119b4dce2042	2026-08-27 12:34	2026-08-27 12:34	2026-08-27 12:34	CRM	CRM260828C00250000	call	250.0000	2026-08-28	3.5500	3.5000	3.6000	249.4800	88748.00	710.00	88038.00	250	15	20417	2614	7.8106350420811	0.727194140817656	0.727194140817656	true	false	false	true
28dc7ced-04a5-48e0-96e4-b6de19b58118	2026-08-27 12:10	2026-08-27 12:09	2026-08-27 12:09	CRM	CRM260828C00247500	call	247.5000	2026-08-28	2.5300	2.4400	2.5400	245.0536	114863.00	23531.00	45792.00	454	8	7241	401	18.0573566084788	0.702440933999701	0.704456467435383	false	false	false	true
5652f551-db07-4b95-9355-6169cdeb55ff	2026-08-27 11:59	2026-08-27 11:59	2026-08-27 11:59	CRM	CRM260918C00245000	call	245.0000	2026-09-18	9.2000	9.1000	9.2500	244.4000	53365.00	1845.00	51520.00	58	15	2777	2187	1.26977594878829	0.385273308408537	0.385273308408537	false	false	false	true
c33b7c83-c21e-465e-a064-9a5711a54c25	2026-08-27 11:58	2026-08-27 11:58	2026-08-27 11:58	CRM	CRM261218C00220000	call	220.0000	2026-12-18	38.0500	37.2500	38.8500	244.4200	60880.00	19025.00	15220.00	16	8	171	2272	0.0752640845070423	0.429260061199207	0.429260061199207	false	false	false	true
d2525ed1-020d-44f7-aa1b-4ac6f114e7b7	2026-08-27 11:53	2026-08-27 11:53	2026-08-27 11:53	CRM	CRM260828P00242500	put	242.5000	2026-08-28	2.8600	2.8300	2.8600	243.9000	80080.00	80080.00	0.00	280	5	4536	28	162	0.694563973713675	0.694563973713675	false	false	false	true
fe37cb74-7a93-4e16-a7f8-f19810702729	2026-08-27 11:48	2026-08-27 11:47	2026-08-27 11:47	CRM	CRM260904P00240000	put	240.0000	2026-09-04	4.1000	3.9500	4.1000	244.6100	184500.00	184500.00	0.00	450	10	6126	2	3063	0.434256748096905	0.434256748096905	false	false	false	true
44fd3bc1-beba-4c87-810e-d3ae9f5e35b2	2026-08-27 11:45	2026-08-27 11:45	2026-08-27 11:45	CRM	CRM260918C00245000	call	245.0000	2026-09-18	9.5000	9.5000	9.8000	245.3500	75051.00	0.00	75051.00	79	19	2640	2187	1.20713305898491	0.376917885843759	0.376917885843759	true	false	false	true
4829dc7a-9e06-441c-bc36-466894264eff	2026-08-27 11:44	2026-08-27 11:43	2026-08-27 11:43	CRM	CRM260925P00240000	put	240.0000	2026-09-25	7.8000	7.6000	8.0000	245.6299	136495.00	135720.00	775.00	175	6	1699	0	0	0.391845624709768	0.38995607019232	true	false	false	true
15c55d7d-4701-408f-95a3-e1f5f22bbfb6	2026-08-27 11:35	2026-08-27 11:35	2026-08-27 11:35	CRM	CRM260918C00250000	call	250.0000	2026-09-18	8.7500	8.7500	9.0500	248.3000	61250.00	0.00	61250.00	70	18	9128	8758	1.04224708837634	0.381814442674197	0.381814442674197	true	false	false	true
ad662f1a-e395-4942-ab61-5e02834dfa9d	2026-08-27 11:34	2026-08-27 11:34	2026-08-27 11:34	CRM	CRM260904C00245000	call	245.0000	2026-09-04	7.6500	7.6500	8.0500	247.6800	72685.00	775.00	71910.00	95	11	2678	771	3.47341115434501	0.419496875059833	0.42649775695533	true	false	false	true
41e88cd2-f840-409e-bbdf-09f76e070ec2	2026-08-27 11:33	2026-08-27 11:32	2026-08-27 11:32	CRM	CRM260925C00250000	call	250.0000	2026-09-25	9.4500	9.4500	10.1000	247.0600	148365.00	0.00	148365.00	157	17	1307	167	7.82634730538922	0.37670607418704	0.37670607418704	true	false	false	true
5f5b2368-108b-44e0-bb6b-1e453a661c93	2026-08-27 11:21	2026-08-27 11:21	2026-08-27 11:21	CRM	CRM260925C00250000	call	250.0000	2026-09-25	11.3000	11.3000	11.4500	250.4050	127690.00	0.00	127690.00	113	31	1031	167	6.17365269461078	0.381441594378132	0.381441594378132	true	false	false	true
fc8faeb0-aea2-43bb-afee-5e2558b485ba	2026-08-27 11:06	2026-08-27 11:06	2026-08-27 11:06	CRM	CRM260828C00212500	call	212.5000	2026-08-28	36.9500	36.9500	38.7500	249.5500	229090.00	0.00	229090.00	62	23	565	1312	0.430640243902439	2.49492635707539	2.53850304664836	true	false	false	true
741bebef-1980-48c0-b378-9828a549203b	2026-08-27 11:05	2026-08-27 11:05	2026-08-27 11:05	CRM	CRM260828C00227500	call	227.5000	2026-08-28	23.0000	22.0500	23.1500	250.3500	124200.00	43700.00	69000.00	54	5	470	1772	0.265237020316027	0.955149440840631	0.955149440840631	false	false	false	true
549def72-ae54-4f2c-a8c9-9791fce8495a	2026-08-27 11:05	2026-08-27 11:05	2026-08-27 11:05	CRM	CRM260828C00252500	call	252.5000	2026-08-28	3.0500	3.0000	3.0500	250.4500	106750.00	106750.00	0.00	350	5	3748	128	29.28125	0.758064478511213	0.758064478511213	false	false	false	true
0958b49e-a032-459f-9feb-9ddb44c7dd0d	2026-08-27 11:03	2026-08-27 11:02	2026-08-27 11:02	CRM	CRM260828C00252500	call	252.5000	2026-08-28	2.7500	2.5900	2.7500	249.6201	62938.00	52800.00	10138.00	229	8	3319	128	25.9296875	0.766245173359376	0.766245173359376	false	false	false	true
ce3e01b9-ad13-412d-9791-2c81e170e85e	2026-08-27 10:58	2026-08-27 10:58	2026-08-27 10:58	CRM	CRM260828C00220000	call	220.0000	2026-08-28	30.3500	30.3500	30.7000	250.3150	75880.00	0.00	75880.00	25	7	4325	5741	0.753353074377286	0.915712225371759	0.915712225371759	false	false	false	true
2aa231f0-0537-44c4-b889-036e8e5490ec	2026-08-27 10:53	2026-08-27 10:53	2026-08-27 10:53	CRM	CRM260925C00250000	call	250.0000	2026-09-25	10.9000	10.9000	11.6000	249.4100	75210.00	0.00	75210.00	69	14	819	167	4.90419161676647	0.386034581267173	0.386034581267173	true	false	false	true
daad6e73-7532-4276-b78e-e486b9da9fb9	2026-08-27 10:53	2026-08-27 10:53	2026-08-27 10:53	CRM	CRM260918C00245000	call	245.0000	2026-09-18	12.1500	12.1500	12.5000	249.2200	156736.00	0.00	156736.00	129	32	1800	2187	0.823045267489712	0.396040721072662	0.396040721072662	true	false	false	true
7b23571a-7b13-414a-b4bf-e85cb4bf4090	2026-08-27 10:47	2026-08-27 10:47	2026-08-27 10:47	CRM	CRM260918C00245000	call	245.0000	2026-09-18	12.1500	11.7000	12.6000	248.7300	98415.00	95985.00	2430.00	81	5	1663	2187	0.760402377686328	0.409408700239409	0.408295030058307	true	false	false	true
67bd1ca0-7191-4668-8e86-d7fa12f78b39	2026-08-27 10:42	2026-08-27 10:42	2026-08-27 10:42	CRM	CRM260925C00250000	call	250.0000	2026-09-25	11.3500	11.3500	11.7000	249.6800	94205.00	0.00	94205.00	83	34	685	167	4.10179640718563	0.397030704171781	0.397030704171781	true	false	false	true
08e84bba-df58-45ec-9572-89651df13804	2026-08-27 10:41	2026-08-27 10:41	2026-08-27 10:41	CRM	CRM260828C00250000	call	250.0000	2026-08-28	3.5500	3.3500	3.5500	248.9100	85200.00	3905.00	0.00	240	10	14653	2614	5.60558530986993	0.779478478912305	0.779478478912305	true	false	false	true
37e5601d-e414-4640-a0b8-d2a07ab02914	2026-08-27 10:39	2026-08-27 10:39	2026-08-27 10:39	CRM	CRM260918P00240000	put	240.0000	2026-09-18	6.0000	6.0000	6.4000	248.7000	80400.00	0.00	80400.00	134	34	2214	90	24.6	0.415490344522522	0.41636688224286	true	false	false	true