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

b573ee13-8b8d-4cd9-951d-21f8d8e5d177	2026-09-21 14:31	2026-09-21 14:31	2026-09-21 14:31	CRM	CRM260925C00242500	call	242.5000	2026-09-25	2.0600	2.0200	2.0800	237.0000	45089.00	43859.00	0.00	219	6	1243	451	2.75609756097561	0.409045972307397	0.409045972307397	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Technology	194573660000.00	2026-12-02	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T18:32:54.184324Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
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
d4046a42-ce16-4d0f-97b7-a5cfcfc5d447	2026-09-21 14:08	2026-09-21 14:07	2026-09-21 14:07	CRM	CRM260925C00237500	call	237.5000	2026-09-25	4.5000	4.3500	4.6500	238.0000	241317.00	31124.00	210193.00	536	56	625	310	2.01612903225806	0.410894908251123	0.4134609895075	false	false	false	true
492e41d2-0c32-4860-99a6-8893e96eaca8	2026-09-21 14:08	2026-09-21 14:07	2026-09-21 14:07	CRM	CRM260925C00235000	call	235.0000	2026-09-25	5.9000	5.8500	6.1500	238.0000	152832.00	18290.00	134542.00	259	29	303	118	2.56779661016949	0.407875834586845	0.408555480754686	false	false	false	true
66e24686-cb78-4fa4-a566-172fd2571b29	2026-09-21 13:40	2026-09-21 13:39	2026-09-21 13:39	CRM	CRM260925C00242500	call	242.5000	2026-09-25	2.2800	2.2300	2.2800	237.7600	22828.00	22828.00	0.00	100	5	967	451	2.14412416851441	0.418583561283788	0.418583561283788	false	false	false	true
eae0a5bf-7bd0-4369-bce4-d62e59b5d2e5	2026-09-21 13:35	2026-09-21 13:35	2026-09-21 13:35	CRM	CRM260925C00242500	call	242.5000	2026-09-25	2.4000	2.3400	2.4300	238.0000	24020.00	24020.00	0.00	100	7	867	451	1.92239467849224	0.417595734051935	0.417595734051935	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
3eafe5c5-b9ca-46c3-a5a3-d21aeca4f357	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.6200	37753.00	0.00	37753.00	25	11	523	8902	0.0587508425073017	0.421279379707932	0.421279379707932	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
fc80fc14-3f98-42b7-af9b-7789e58ee5e5	2026-09-21 11:20	2026-09-21 11:20	2026-09-21 11:20	CRM	CRM260925P00230000	put	230.0000	2026-09-25	1.2900	1.2500	1.3000	238.4200	12850.00	12850.00	0.00	100	13	473	2351	0.201190982560613	0.437332932180951	0.434521132619729	false	false	false	true
b7ba433a-c54e-49b2-a89f-c18596c39d1c	2026-09-21 11:02	2026-09-21 11:02	2026-09-21 11:02	CRM	CRM260925C00242500	call	242.5000	2026-09-25	2.7300	2.7200	2.8100	239.2150	17170.00	0.00	17170.00	63	8	334	451	0.740576496674058	0.410339872016676	0.409297027543993	false	false	false	true
a93fa785-74cd-4e7c-91e5-1a7220831f35	2026-09-21 10:57	2026-09-21 10:57	2026-09-21 10:57	CRM	CRM260925C00250000	call	250.0000	2026-09-25	1.0000	0.9600	1.0000	239.7000	14400.00	14400.00	0.00	144	32	1576	1940	0.812371134020619	0.421441653643095	0.421441653643095	true	false	false	true
ef944bef-4487-489c-81e7-70b89709a002	2026-09-21 10:55	2026-09-21 10:55	2026-09-21 10:55	CRM	CRM261016P00220000	put	220.0000	2026-10-16	2.6500	2.5900	2.7400	239.4450	39750.00	0.00	39750.00	150	5	213	2696	0.0790059347181009	0.396538360398254	0.396538360398254	false	false	false	true
a0a52459-263f-4a84-bfd8-b02092a0e948	2026-09-21 10:53	2026-09-21 10:53	2026-09-21 10:53	CRM	CRM260925C00250000	call	250.0000	2026-09-25	0.9500	0.9100	0.9500	239.4900	21375.00	21375.00	0.00	225	41	1359	1940	0.700515463917526	0.419398339202162	0.419398339202162	true	false	false	true
0c83ae86-f4be-416d-83ee-4c7c30f551ad	2026-09-21 10:51	2026-09-21 10:51	2026-09-21 10:51	CRM	CRM260925C00250000	call	250.0000	2026-09-25	0.9400	0.9000	0.9500	239.3700	10716.00	10716.00	0.00	114	16	1134	1940	0.584536082474227	0.421051041297498	0.421051041297498	true	false	false	true
6119a5d0-b88f-4462-96bd-52053c18c257	2026-09-21 10:50	2026-09-21 10:50	2026-09-21 10:50	CRM	CRM260925C00250000	call	250.0000	2026-09-25	0.9200	0.8400	0.9200	239.3150	45080.00	45080.00	0.00	490	50	925	1940	0.47680412371134	0.419354864425041	0.419354864425041	true	false	false	true
007fd2f6-cc7b-4815-a5fd-3fca8df3841e	2026-09-21 10:49	2026-09-21 10:49	2026-09-21 10:49	CRM	CRM260925C00260000	call	260.0000	2026-09-25	0.2100	0.1700	0.2100	239.4050	13608.00	13608.00	0.00	648	36	981	1810	0.541988950276243	0.45705166176699	0.45705166176699	true	false	false	true
893dc370-8ce3-4368-b16b-1da247ca2c38	2026-09-21 10:46	2026-09-21 10:46	2026-09-21 10:46	CRM	CRM270319C00320000	call	320.0000	2027-03-19	8.7600	8.7500	8.8500	238.9550	13145.00	0.00	13145.00	15	8	183	407	0.44963144963145	0.441647345563067	0.440674283735328	false	false	false	true
b3d01ed4-0f20-47a2-a494-d29b907a58c4	2026-09-21 10:41	2026-09-21 10:40	2026-09-21 10:40	CRM	CRM260925P00235000	put	235.0000	2026-09-25	2.2900	2.2600	2.3900	239.3800	20157.00	687.00	19470.00	88	31	899	1273	0.706205813040063	0.419273425722124	0.420381307214619	true	false	false	true
3705e4c3-f01d-43f1-bc06-eb53fcf6ff9c	2026-09-21 10:24	2026-09-21 10:24	2026-09-21 10:24	CRM	CRM261002P00220000	put	220.0000	2026-10-02	0.9000	0.9000	0.9900	240.2300	15030.00	0.00	15030.00	167	30	496	7488	0.0662393162393162	0.42051997496173	0.42051997496173	false	false	false	true
952aaeca-a57e-4a05-9dcb-50fd0a8ecced	2026-09-21 10:08	2026-09-21 10:08	2026-09-21 10:08	CRM	CRM261002P00222500	put	222.5000	2026-10-02	1.3100	1.3100	1.4500	239.8900	12838.00	0.00	12838.00	98	20	127	53	2.39622641509434	0.423542351123972	0.423542351123972	false	false	false	true
001d7e5a-b1cd-40f8-9e61-bff6a1f1f80c	2026-09-21 10:08	2026-09-21 10:08	2026-09-21 10:08	CRM	CRM261002P00220000	put	220.0000	2026-10-02	1.0000	1.0000	1.1200	239.8900	17900.00	0.00	17900.00	179	37	327	7488	0.0436698717948718	0.428696590296729	0.428696590296729	false	false	false	true
1fbeb081-b366-4dcd-b961-94676b9fa204	2026-09-21 09:57	2026-09-21 09:57	2026-09-21 09:57	CRM	CRM260925P00235000	put	235.0000	2026-09-25	2.4500	2.3300	2.4500	239.4000	119282.00	111230.00	8052.00	487	57	592	1273	0.465043205027494	0.437666414179727	0.437666414179727	false	false	false	true
b56794fd-0638-4ba2-9a61-e67cb0eca530	2026-09-18 15:11	2026-09-18 15:10	2026-09-18 15:10	CRM	CRM261218C00240000	call	240.0000	2026-12-18	20.8000	20.8000	21.0500	238.2150	3240769.00	0.00	3240769.00	1558	59	1622	1880	0.862765957446809	0.430500272686303	0.432073825002708	false	false	false
84cbaace-c67f-4a8e-99d4-5caeac9d3eda	2026-09-18 15:00	2026-09-18 15:00	2026-09-18 15:00	CRM	CRM260918C00237500	call	237.5000	2026-09-18	1.3100	1.2300	1.5500	238.5500	52501.00	137.00	52364.00	401	33	1485	171	8.68421052631579	0.559894626825891	0.660267364940512	true	false	false	true
93f1fb46-dc5e-4969-b90d-f51114c2333c	2026-09-18 14:32	2026-09-18 14:31	2026-09-18 14:31	CRM	CRM261016C00250000	call	250.0000	2026-10-16	5.7500	5.7500	5.8500	239.1050	94875.00	0.00	94875.00	165	19	714	2616	0.272935779816514	0.371524480421237	0.371305619507681	true	false	false	true
e68d9689-a294-4b16-b5d9-6666126dc3bc	2026-09-18 14:22	2026-09-18 14:22	2026-09-18 14:22	CRM	CRM270319P00260000	put	260.0000	2027-03-19	39.2600	39.0000	39.6500	238.5868	62810.00	7855.00	54955.00	16	6	70	314	0.222929936305732	0.444443643554957	0.444443643554957	false	false	false	true
4715c8d8-f23c-472b-90b2-5398161d0a41	2026-09-18 14:20	2026-09-18 14:19	2026-09-18 14:19	CRM	CRM270319C00250000	call	250.0000	2027-03-19	26.7000	26.3000	26.7500	238.4400	242940.00	242940.00	0.00	91	17	124	1090	0.113761467889908	0.437811025609811	0.437811025609811	false	false	false	true
4113c807-0175-4271-97ae-bf8f4f248894	2026-09-18 14:18	2026-09-18 14:18	2026-09-18 14:18	CRM	CRM260925P00230000	put	230.0000	2026-09-25	1.5100	1.5000	1.5700	238.4150	51890.00	31408.00	20482.00	344	13	956	2250	0.424888888888889	0.353097509020991	0.354121704784487	true	false	false	true
3670d1f6-09e0-4425-8aec-5524adc26c46	2026-09-18 14:11	2026-09-18 14:11	2026-09-18 14:11	CRM	CRM270115P00240000	put	240.0000	2027-01-15	22.4500	22.2500	22.4500	238.1950	94290.00	94290.00	0.00	42	7	61	2943	0.0207271491675161	0.429687167219279	0.429687167219279	false	false	false	true
c93c4937-bc76-481c-8281-55160880b7b4	2026-09-18 13:47	2026-09-18 13:47	2026-09-18 13:47	CRM	CRM261002P00220000	put	220.0000	2026-10-02	1.3800	1.1300	1.3100	238.6350	418504.00	418504.00	0.00	3024	38	7273	447	16.2706935123043	0.397296438943448	0.405097941138833	true	false	false	true
95a924df-d5eb-48a9-942a-8d4a9f9cc0ab	2026-09-18 13:45	2026-09-18 13:45	2026-09-18 13:45	CRM	CRM261002P00220000	put	220.0000	2026-10-02	1.3300	1.1400	1.3600	238.5450	75501.00	55698.00	19803.00	568	70	3616	447	8.08948545861297	0.39609853689626	0.400014239349584	true	false	false	true
9dba0ce2-c38c-47b7-8b11-a2e2b575d006	2026-09-18 13:09	2026-09-18 13:09	2026-09-18 13:09	CRM	CRM260918P00240000	put	240.0000	2026-09-18	1.3700	1.3700	1.5100	239.0400	55485.00	0.00	55485.00	405	55	1308	8204	0.159434422233057	0.465589859314787	0.465589859314787	true	false	false	true
3cde02c7-fac0-4ecd-8720-f2af8afbba7b	2026-09-18 12:22	2026-09-18 12:22	2026-09-18 12:22	CRM	CRM280121C00310000	call	310.0000	2028-01-21	31.7000	31.7000	32.1500	239.0000	66580.00	3175.00	63405.00	21	6	21	638	0.0329153605015674	0.442205258327872	0.442659752522241	false	false	false	true
de9b02b0-1845-40df-ad12-fea0d46b3fdc	2026-09-18 11:26	2026-09-18 11:26	2026-09-18 11:26	CRM	CRM270319P00210000	put	210.0000	2027-03-19	14.0000	13.8500	14.0500	240.7850	98000.00	85400.00	12600.00	70	6	228	432	0.527777777777778	0.451841214118338	0.451841214118338	false	false	false	true
d6340193-0bea-417b-914e-5de488801c19	2026-09-18 10:43	2026-09-18 10:43	2026-09-18 10:43	CRM	CRM280121C00210000	call	210.0000	2028-01-21	68.5500	68.5000	69.0000	239.1450	89109.00	0.00	89109.00	13	5	18	1402	0.0128388017118402	0.447471982601877	0.447471982601877	false	false	false	true
4ed3664a-8112-4ca5-bc42-498aa1552e7e	2026-09-18 10:31	2026-09-18 10:31	2026-09-18 10:31	CRM	CRM280121C00230000	call	230.0000	2028-01-21	58.5000	57.3500	59.8000	238.6800	58500.00	35100.00	23400.00	10	5	13	727	0.0178817056396149	0.445770640412055	0.445770640412055	false	false	false	true
9c72a291-8031-4e43-8923-239d51dd4769	2026-09-18 10:21	2026-09-18 10:21	2026-09-18 10:21	CRM	CRM271217C00320000	call	320.0000	2027-12-17	26.2000	26.2000	29.5000	239.0100	196500.00	0.00	196500.00	75	8	75	120	0.625	0.435117613542295	0.435117613542295	false	false	false	true
6b9e81a2-d580-4028-bbfd-861a6be365f1	2026-09-18 10:05	2026-09-18 10:05	2026-09-18 10:05	CRM	CRM260918P00242500	put	242.5000	2026-09-18	4.8500	4.6500	5.0500	237.8400	53835.00	0.00	48500.00	111	5	741	1206	0.614427860696517	0.604191086189417	0.604191086189417	true	false	false	true
f3c997b7-f555-434d-8ed1-530c25d42003	2026-09-18 10:05	2026-09-18 10:05	2026-09-18 10:05	CRM	CRM260918P00242500	put	242.5000	2026-09-18	4.9500	4.9500	5.2500	237.8670	68805.00	0.00	62865.00	139	7	630	1206	0.522388059701492	0.699645079992612	0.699645079992612	true	false	false	true
e0990d16-c0c4-4a95-9fa9-a3b45a8a682c	2026-09-18 09:55	2026-09-18 09:55	2026-09-18 09:55	CRM	CRM260918P00242500	put	242.5000	2026-09-18	4.0000	4.0000	4.2000	238.9400	53200.00	0.00	53200.00	133	23	383	1206	0.317578772802653	0.652030639149868	0.652030639149868	true	false	false	true