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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×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

6476222d-e3b9-4c46-b828-11f1333ec7be	2026-09-17 15:56	2026-09-17 15:56	2026-09-17 15:56	CRM	CRM260918C00242500	call	242.5000	2026-09-18	2.8200	2.6400	3.0500	243.0000	56400.00	45684.00	10716.00	200	11	764	120	6.36666666666667	0.485504404262358	0.485504404262358	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	199865550000.00	2026-12-02	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-17	2026-09-17 21:15	2026-09-17 21:15
89e4791e-94dd-48cc-b00e-9e04c53b31cd	2026-09-17 10:58	2026-09-17 10:58	2026-09-17 10:58	CRM	CRM260918P00242500	put	242.5000	2026-09-18	2.6100	2.5800	2.6100	242.8200	84363.00	84363.00	0.00	323	7	870	1111	0.783078307830783	0.548628030573237	0.548628030573237	false	false	false	true
79cb97fa-7c7d-4f3b-adbc-5f92470acdcc	2026-09-17 10:24	2026-09-17 10:24	2026-09-17 10:24	CRM	CRM260918P00247500	put	247.5000	2026-09-18	5.2500	4.7500	5.2500	243.8800	358575.00	358575.00	0.00	683	53	1230	344	3.57558139534884	0.610332538202564	0.610332538202564	false	false	false	true
adbaebfb-5b51-4011-b272-5b0d3b6a0540	2026-09-17 10:19	2026-09-17 10:19	2026-09-17 10:19	CRM	CRM260918P00247500	put	247.5000	2026-09-18	6.0500	5.5500	6.0500	242.6300	283745.00	283745.00	0.00	469	56	547	344	1.59011627906977	0.592765430364424	0.592765430364424	false	false	false	true
dab12e5b-733e-4496-8485-eba5aed0d14a	2026-09-17 10:01	2026-09-17 10:01	2026-09-17 10:01	CRM	CRM260918P00240000	put	240.0000	2026-09-18	2.0700	1.6800	2.0700	242.3150	353141.00	352935.00	0.00	1706	54	3360	8370	0.401433691756272	0.615847574742771	0.615847574742771	false	false	false	true
e7463e77-c9c5-4e96-9c60-6dbd9b684075	2026-09-17 09:37	2026-09-17 09:37	2026-09-17 09:37	CRM	CRM260918P00240000	put	240.0000	2026-09-18	1.5500	1.5200	1.7800	243.6400	77740.00	0.00	77740.00	500	31	1180	8370	0.140979689366786	0.594936411410694	0.601617629654257	true	false	false	true
ec9d2a45-75d6-47c9-b1ca-2e5250e1ee8a	2026-09-16 15:47	2026-09-16 15:47	2026-09-16 15:47	CRM	CRM260918P00245000	put	245.0000	2026-09-18	2.7200	2.7100	2.7200	250.0000	111248.00	111248.00	0.00	409	6	2548	3813	0.668240230789405	0.688511770507454	0.688511770507454	true	false	false	true
80b11fad-85d7-4fb2-ad75-27cf75dc5aad	2026-09-16 14:56	2026-09-16 14:56	2026-09-16 14:56	CRM	CRM261218P00240000	put	240.0000	2026-12-18	15.7500	14.9000	15.8000	252.0500	50400.00	50400.00	0.00	32	11	35	3082	0.0113562621674238	0.453431924352726	0.453431924352726	false	false	false	true
43cff1e1-ad50-4099-8f61-ed7dd139d3e8	2026-09-16 13:56	2026-09-16 13:56	2026-09-16 13:56	CRM	CRM261030C00280000	call	280.0000	2026-10-30	5.1000	5.1000	5.4000	251.0000	198900.00	0.00	198900.00	390	17	391	22	17.7727272727273	0.408932329451444	0.408932329451444	true	false	false	true
448d052b-33aa-4d7b-b678-10ad01aab171	2026-09-16 11:58	2026-09-16 11:58	2026-09-16 11:58	CRM	CRM260918C00260000	call	260.0000	2026-09-18	1.4300	1.3400	1.5000	250.2000	80080.00	67782.00	12298.00	560	65	2651	11867	0.223392601331423	0.638963116411514	0.638963116411514	true	false	false	true
d5e371f5-4b8e-47c2-bd74-4174c6729eb2	2026-09-16 11:58	2026-09-16 11:58	2026-09-16 11:58	CRM	CRM260918C00260000	call	260.0000	2026-09-18	1.4000	1.3400	1.4300	250.1000	69914.00	69914.00	0.00	500	6	2091	11867	0.176202915648437	0.635532472694285	0.635532472694285	false	false	false	true
31b87741-9fac-48e0-9fa1-0064b082c6a9	2026-09-16 11:29	2026-09-16 11:29	2026-09-16 11:29	CRM	CRM260918C00252500	call	252.5000	2026-09-18	4.6000	4.5500	4.9500	252.1450	174805.00	0.00	174805.00	380	52	618	214	2.88785046728972	0.637435924581149	0.637435924581149	false	false	false	true
c23863ac-def4-4efa-bfcd-0b8639c811e8	2026-09-16 10:34	2026-09-16 10:34	2026-09-16 10:34	CRM	CRM270319P00220000	put	220.0000	2027-03-19	15.0500	13.8500	15.2500	252.4800	123441.00	123441.00	0.00	82	8	82	265	0.309433962264151	0.457307787030708	0.457481021433801	false	false	false	true
e56639d7-f7be-4e36-9bbb-22efe816321c	2026-09-16 10:00	2026-09-16 09:59	2026-09-16 09:59	CRM	CRM270319P00240000	put	240.0000	2027-03-19	22.3000	22.3000	22.7000	255.2900	254220.00	0.00	254220.00	114	7	147	450	0.326666666666667	0.456300778779052	0.456300778779052	false	false	false	true
9babfb11-b076-45fc-82be-bab49ff181e0	2026-09-15 15:20	2026-09-15 15:20	2026-09-15 15:20	CRM	CRM261120P00250000	put	250.0000	2026-11-20	14.3000	14.2000	14.4000	256.6300	61490.00	2860.00	58630.00	43	5	159	830	0.191566265060241	0.426337190110888	0.426337190110888	false	false	false	true
e0ed0890-8c06-46dc-8e64-5c3d76ec896a	2026-09-15 15:05	2026-09-15 15:04	2026-09-15 15:04	CRM	CRM270115C00300000	call	300.0000	2027-01-15	12.2500	12.0500	12.3000	256.9500	75950.00	75950.00	0.00	62	11	412	7111	0.0579384052875826	0.431928708737887	0.431928708737887	false	false	false	true
a7a18393-0372-4a48-bb56-1a8c3b818414	2026-09-15 12:58	2026-09-15 12:58	2026-09-15 12:58	CRM	CRM270115C00320000	call	320.0000	2027-01-15	9.3700	9.1500	9.5000	260.7900	93700.00	93700.00	0.00	100	5	102	4254	0.0239774330042313	0.436620634086149	0.436620634086149	false	false	false	true
32b4c4bc-d963-49d2-bcb2-4c5dc59aec28	2026-09-15 12:56	2026-09-15 12:56	2026-09-15 12:56	CRM	CRM271217P00270000	put	270.0000	2027-12-17	51.2100	49.8500	51.3000	260.5050	327720.00	35840.00	250880.00	64	7	64	472	0.135593220338983	0.475124513390159	0.475574951509666	true	false	false	true
e064ab26-2f7c-47fe-a6ab-425f254c5218	2026-09-15 12:56	2026-09-15 12:56	2026-09-15 12:56	CRM	CRM271217P00280000	put	280.0000	2027-12-17	57.0000	56.1000	57.0500	260.4600	222305.00	216605.00	5700.00	39	15	39	64	0.609375	0.47604981300491	0.476491989056909	false	false	false	true
58e4d18a-021b-45c3-88ce-1be54438b8fb	2026-09-15 12:53	2026-09-15 12:53	2026-09-15 12:53	CRM	CRM260918P00260000	put	260.0000	2026-09-18	5.5500	5.5000	5.7000	260.7000	84915.00	40515.00	44400.00	153	14	571	3652	0.156352683461117	0.63035344812043	0.63035344812043	false	false	false	true
98509b7c-9d32-4ecc-b8d7-a451c429c298	2026-09-15 12:34	2026-09-15 12:34	2026-09-15 12:34	CRM	CRM270917C00250000	call	250.0000	2027-09-17	57.2500	55.3500	57.3000	262.0000	561055.00	555355.00	5700.00	98	17	98	180	0.544444444444444	0.448901504156997	0.448692460083296	true	false	false	true
3d544d7a-866f-4f12-a92d-6f5bb520c187	2026-09-15 12:16	2026-09-15 12:16	2026-09-15 12:16	CRM	CRM270617C00300000	call	300.0000	2027-06-17	29.4800	28.4500	29.5500	261.3700	61900.00	61900.00	0.00	21	5	24	6817	0.00352061023910811	0.447082092627594	0.446528029645204	false	false	false	true
191f9e57-7a56-4a63-89cd-3e018e6d679d	2026-09-15 12:03	2026-09-15 12:03	2026-09-15 12:03	CRM	CRM260918C00260000	call	260.0000	2026-09-18	6.1500	6.1500	6.3000	260.9700	92895.00	0.00	92895.00	151	14	1214	12010	0.101082431307244	0.600655400927059	0.595330590927834	true	false	false	true
e85753ad-a505-415b-818c-cc38c6bae509	2026-09-15 11:54	2026-09-15 11:54	2026-09-15 11:54	CRM	CRM261016P00260000	put	260.0000	2026-10-16	12.1000	11.7500	12.1000	260.6900	77440.00	77440.00	0.00	64	16	210	1239	0.169491525423729	0.427714730925811	0.42643024355973	true	false	false	true
9d35644a-e094-40a6-934b-3b56583ea466	2026-09-15 11:53	2026-09-15 11:53	2026-09-15 11:53	CRM	CRM260918C00267500	call	267.5000	2026-09-18	3.0500	2.8100	3.0500	260.7950	142710.00	142710.00	0.00	468	51	1046	714	1.46498599439776	0.603627413348461	0.603627413348461	false	false	false	true
4de747b4-d3a8-41b9-abd7-56b0394555c6	2026-09-15 11:44	2026-09-15 11:44	2026-09-15 11:44	CRM	CRM260918P00260000	put	260.0000	2026-09-18	5.8700	5.7000	6.0500	260.1150	58080.00	24696.00	33384.00	99	7	243	3652	0.066538882803943	0.629489130619558	0.629489130619558	false	false	false	true
f18df9d9-1caa-4c17-b2f2-9251be613c3d	2026-09-15 11:26	2026-09-15 11:26	2026-09-15 11:26	CRM	CRM260918C00267500	call	267.5000	2026-09-18	2.4000	2.2100	2.4000	258.9800	59756.00	59520.00	236.00	249	31	545	714	0.763305322128851	0.592845334821529	0.587815928062315	false	false	false	true
295ab3a4-a6a0-46c7-a5a9-4af2b7256daa	2026-09-15 10:50	2026-09-15 10:49	2026-09-15 10:49	CRM	CRM261218C00240000	call	240.0000	2026-12-18	33.1200	33.0000	33.5000	256.6200	211990.00	102755.00	109235.00	64	6	65	1852	0.035097192224622	0.445025269945712	0.443956777258474	true	false	false
fc24ad44-6ce1-4706-9d90-f09eedd61765	2026-09-15 10:22	2026-09-15 10:21	2026-09-15 10:21	CRM	CRM270115C00300000	call	300.0000	2027-01-15	11.9000	11.9000	12.2500	256.4250	264193.00	0.00	264193.00	222	27	223	7111	0.0313598649978906	0.42860809280693	0.42860809280693	false	false	false	true
d11a63cf-44f1-4f18-b91b-cdedbb40e994	2026-09-15 10:22	2026-09-15 10:21	2026-09-15 10:21	CRM	CRM270115C00280000	call	280.0000	2027-01-15	17.6500	17.5000	18.1000	256.4250	1288518.00	5325.00	1283193.00	730	46	732	2521	0.290360967869893	0.430064859766549	0.431780986455366	false	false	false
82296246-2e2c-4c97-9d1b-dbae11051f36	2026-09-15 10:09	2026-09-15 10:09	2026-09-15 10:09	CRM	CRM260918P00250000	put	250.0000	2026-09-18	2.8900	2.7800	2.9500	256.6300	55294.00	36266.00	19028.00	191	21	213	5365	0.0397017707362535	0.620339682061426	0.607445403820152	true	false	false	true
3e2cb242-663d-4cb5-8add-93a1ed825817	2026-09-14 15:31	2026-09-14 15:31	2026-09-14 15:31	CRM	CRM270319C00270000	call	270.0000	2027-03-19	30.5000	30.5000	31.0500	259.9400	97608.00	0.00	97608.00	32	7	43	657	0.0654490106544901	0.443954614432744	0.443954614432744	false	false	false	true
6aa1b056-d7b5-4666-84f1-81bbe0903a89	2026-09-14 14:11	2026-09-14 14:10	2026-09-14 14:10	CRM	CRM270917C00280000	call	280.0000	2027-09-17	42.4500	40.0000	42.7000	258.9000	127350.00	123105.00	4245.00	30	9	33	290	0.113793103448276	0.455249332566595	0.455249332566595	false	false	false	true
2361a623-ff91-491f-b0f0-06fbea52579d	2026-09-14 14:01	2026-09-14 14:00	2026-09-14 14:00	CRM	CRM260918C00247500	call	247.5000	2026-09-18	12.7900	12.3000	13.0000	258.5850	127882.00	127882.00	0.00	100	9	825	500	1.65	0.513473616300804	0.513473616300804	false	false	false	true
495f2dd9-9182-4e59-9d25-29a24d7140b0	2026-09-14 13:37	2026-09-14 13:37	2026-09-14 13:37	CRM	CRM261016C00260000	call	260.0000	2026-10-16	11.9300	11.8500	12.3000	258.8400	95420.00	37355.00	58065.00	80	6	472	1921	0.245705361790734	0.391494430946377	0.398044037859409	false	false	false	true
b7259d1d-0049-4f4d-a87a-ed94d90af7e2	2026-09-14 12:23	2026-09-14 12:22	2026-09-14 12:22	CRM	CRM260918C00220000	call	220.0000	2026-09-18	37.7900	37.4000	38.0000	257.6600	113384.00	113384.00	0.00	30	6	58	7411	0.00782620429091891	0.616347259773966	0.616347259773966	false	false	false	true
17fa7b72-0bd1-4422-b9ca-eabb05f76fa6	2026-09-14 12:05	2026-09-14 12:05	2026-09-14 12:05	CRM	CRM260918C00265000	call	265.0000	2026-09-18	2.4900	2.4100	2.5600	257.0000	74606.00	51294.00	23312.00	300	5	1282	2435	0.526488706365503	0.509851889989725	0.509851889989725	false	false	false	true
a69ed39a-6187-48cd-8f66-80d25fb5d987	2026-09-14 11:51	2026-09-14 11:51	2026-09-14 11:51	CRM	CRM260918C00247500	call	247.5000	2026-09-18	11.6400	11.3000	11.8000	257.1929	364432.00	267737.00	96695.00	313	8	335	500	0.67	0.529918571484442	0.511865513973455	false	false	false	true
56859c5e-6e34-4885-9608-94714abc1109	2026-09-14 11:34	2026-09-14 11:34	2026-09-14 11:34	CRM	CRM260918C00260000	call	260.0000	2026-09-18	4.0000	3.6500	4.0000	256.2700	79600.00	79600.00	0.00	199	39	3300	10689	0.308728599494808	0.521945093237831	0.521945093237831	false	false	false	true
198670ec-c258-42e3-a50c-867c49994de1	2026-09-14 11:26	2026-09-14 11:26	2026-09-14 11:26	CRM	CRM260918C00265000	call	265.0000	2026-09-18	2.3600	2.2400	2.4000	256.2000	118052.00	118052.00	0.00	500	8	900	2435	0.369609856262834	0.519631596224902	0.522956083892199	false	false	false	true
033dff59-3ac9-41a8-922f-5d6bd7dffe64	2026-09-14 11:17	2026-09-14 11:17	2026-09-14 11:17	CRM	CRM260918C00262500	call	262.5000	2026-09-18	2.9100	2.8000	2.9500	255.6100	62858.00	61403.00	873.00	216	49	894	487	1.83572895277207	0.523859158630348	0.525931141188969	true	false	false	true
2925eece-82fe-480c-9739-51e699fd7840	2026-09-14 10:27	2026-09-14 10:27	2026-09-14 10:27	CRM	CRM280121C00300000	call	300.0000	2028-01-21	41.2000	41.2000	42.0000	252.8000	127712.00	0.00	127712.00	31	5	37	3001	0.012329223592136	0.454754695693695	0.455436921860335	true	false	false	true
86d1bb30-3760-4b65-b0d4-670758aaf0a4	2026-09-14 10:25	2026-09-14 10:25	2026-09-14 10:25	CRM	CRM260918C00250000	call	250.0000	2026-09-18	6.7300	6.5500	7.0000	252.0000	67280.00	0.00	67280.00	100	9	336	8561	0.0392477514309076	0.505003923976533	0.505003923976533	false	false	false	true
3f5cff1e-245a-4850-8abf-8c5eab475640	2026-09-14 10:10	2026-09-14 10:10	2026-09-14 10:10	CRM	CRM260918C00255000	call	255.0000	2026-09-18	4.6000	4.6000	4.9000	253.3900	412276.00	0.00	412276.00	896	41	1052	2032	0.517716535433071	0.500963113420403	0.500963113420403	false	false	false	true
44c76b39-8fd6-415e-bd1b-e3457ffc29b1	2026-09-11 15:41	2026-09-11 15:41	2026-09-11 15:41	CRM	CRM260918P00260000	put	260.0000	2026-09-18	13.1400	13.0000	14.1500	248.7000	69650.00	3990.00	65660.00	53	12	160	2313	0.0691742325983571	0.416178653630219	0.434933127911398	true	false	false	true
e90648f0-cb1c-47df-9128-07e6c5de619d	2026-09-11 14:54	2026-09-11 14:54	2026-09-11 14:54	CRM	CRM261016P00230000	put	230.0000	2026-10-16	4.6000	4.3000	4.6000	248.7350	132940.00	132940.00	0.00	289	37	512	4513	0.113450033237314	0.404675174849602	0.404675174849602	false	false	false	true
a6ff6773-f9e8-40b2-81d6-60696c1cbe26	2026-09-11 14:54	2026-09-11 14:54	2026-09-11 14:54	CRM	CRM261016P00240000	put	240.0000	2026-10-16	7.7500	7.6000	7.7500	248.7350	110825.00	110825.00	0.00	143	31	181	2449	0.073907717435688	0.397331720473362	0.397331720473362	false	false	false	true
069d8f93-f227-4c5d-bdcb-6832bd36e5c7	2026-09-11 14:20	2026-09-11 14:20	2026-09-11 14:20	CRM	CRM260918P00240000	put	240.0000	2026-09-18	2.5800	2.4500	2.6800	248.2300	129153.00	87580.00	41573.00	500	13	1592	7681	0.207264679078245	0.427747575335311	0.432135384043359	false	false	false	true
63467dd1-c698-495c-bf01-32b594cf50f6	2026-09-11 13:54	2026-09-11 13:54	2026-09-11 13:54	CRM	CRM260918P00240000	put	240.0000	2026-09-18	2.4500	2.4000	2.5100	248.4050	85750.00	17150.00	68600.00	350	5	788	7681	0.102590808488478	0.42659523582077	0.42659523582077	false	false	false	true
f5d3e55b-4fbb-4912-9d0c-4e1bfe1a50dc	2026-09-11 11:50	2026-09-11 11:50	2026-09-11 11:50	CRM	CRM261016P00250000	put	250.0000	2026-10-16	12.3000	11.8000	12.3000	248.7500	418200.00	418200.00	0.00	340	29	359	2485	0.144466800804829	0.395532915907866	0.395532915907866	false	false	false	true