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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×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

c864f769-48c6-4f33-9f5c-02441c4b1598	2026-09-28 15:51	2026-09-28 15:51	2026-09-28 15:51	CRM	CRM261002C00232500	call	232.5000	2026-10-02	2.4500	2.4000	2.5200	227.6350	25728.00	10820.00	14908.00	105	27	497	263	1.88973384030418	0.455485257865908	0.462341415625604	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Technology	187043210000.00	2026-12-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T19:53:15.788869Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
a9f2fbb5-cda5-4d64-b1ed-c010c103b5e0	2026-09-28 13:20	2026-09-28 13:20	2026-09-28 13:20	CRM	CRM261016P00227500	put	227.5000	2026-10-16	6.9500	6.9000	7.3000	229.0300	14605.00	11125.00	3480.00	21	7	43	34	1.26470588235294	0.391254543920212	0.393744199468738	true	false	false	true
e5f13bab-2cc6-4bd3-81fb-0a874a8f4ceb	2026-09-28 12:16	2026-09-28 12:16	2026-09-28 12:16	CRM	CRM261030C00200000	call	200.0000	2026-10-30	30.5100	30.1000	32.7500	227.8850	73220.00	36660.00	36560.00	24	8	101	5	20.2	0.413951967669052	0.422679765440386	false	false	false	true
b81b4bef-03f8-4829-91d5-08e83d4cb8b5	2026-09-28 12:16	2026-09-28 12:16	2026-09-28 12:16	CRM	CRM261030C00210000	call	210.0000	2026-10-30	22.3600	21.9000	24.2000	227.8850	44725.00	22375.00	22350.00	20	6	22	1	22	0.405667778506909	0.406642239339749	false	false	false	true
9db3e23a-844c-4dea-a4df-9f3424a88f78	2026-09-28 12:16	2026-09-28 12:16	2026-09-28 12:16	CRM	CRM261023C00215000	call	215.0000	2026-10-23	17.5000	17.5000	19.7500	227.9950	43756.00	1755.00	42001.00	25	16	25	15	1.66666666666667	0.396222190943168	0.398804521363726	false	false	false	true
6d5af80c-2a72-4a13-9842-e7ec5673ede1	2026-09-28 12:16	2026-09-28 12:16	2026-09-28 12:16	CRM	CRM261030C00215000	call	215.0000	2026-10-30	18.6600	18.6500	20.3000	227.9950	78355.00	1885.00	76470.00	42	18	115	11	10.4545454545455	0.395746077829743	0.404561553316615	false	false	false	true
4873dc30-e9bd-42c5-93ec-3d40aa5b6d9a	2026-09-28 12:16	2026-09-28 12:16	2026-09-28 12:16	CRM	CRM261106C00215000	call	215.0000	2026-11-06	19.9500	19.7000	21.0500	227.8850	23945.00	12000.00	11945.00	12	10	234	0	0	0.403672678110293	0.410191905951638	false	false	false	true
163c6366-ccd7-475e-8f7f-9d30806ea845	2026-09-28 11:53	2026-09-28 11:53	2026-09-28 11:53	CRM	CRM261030P00205000	put	205.0000	2026-10-30	2.6900	2.5400	2.8000	228.2050	12628.00	7290.00	5338.00	47	6	63	468	0.134615384615385	0.415098970182802	0.418042132748331	true	false	false	true
4a7cec3c-45d6-4b7e-8919-814655853619	2026-09-28 11:21	2026-09-28 11:21	2026-09-28 11:21	CRM	CRM261002C00230000	call	230.0000	2026-10-02	4.3800	4.3000	4.7000	229.0000	17512.00	0.00	17512.00	40	16	511	119	4.29411764705882	0.474424569752982	0.486952810738844	false	false	false	true
db0454e4-5a17-4f5d-8c2c-5bc99e3420e4	2026-09-28 11:12	2026-09-28 11:12	2026-09-28 11:12	CRM	CRM261030C00200000	call	200.0000	2026-10-30	32.1200	31.4500	34.3500	230.1331	48185.00	25760.00	22425.00	15	6	15	5	3	0.37442335195407	0.39638264566791	true	false	false	true
31bd833b-51fe-4b99-82ed-b15c197ddae9	2026-09-28 11:12	2026-09-28 11:12	2026-09-28 11:12	CRM	CRM261030C00200000	call	200.0000	2026-10-30	32.0300	31.6500	34.3000	229.8000	198575.00	99375.00	99200.00	62	7	77	5	15.4	0.404522368791738	0.408518964861158	true	false	false	true
b446962e-f57e-4d1a-a597-360560191302	2026-09-28 11:12	2026-09-28 11:12	2026-09-28 11:12	CRM	CRM261030C00225000	call	225.0000	2026-10-30	13.8200	13.4500	14.8000	230.1331	59440.00	29190.00	30250.00	43	8	48	12	4	0.391634143939684	0.397377557320761	true	false	false	true
a278d5fa-711c-4831-b84f-414438a64d90	2026-09-28 11:12	2026-09-28 11:12	2026-09-28 11:12	CRM	CRM261023C00225000	call	225.0000	2026-10-23	12.5300	12.2500	13.1500	230.1331	12530.00	6280.00	6250.00	10	6	246	18	13.6666666666667	0.39391387643416	0.396088420317811	true	false	false	true
1ba55ad6-216c-4311-8c50-3f3ab2a8d407	2026-09-28 11:12	2026-09-28 11:12	2026-09-28 11:12	CRM	CRM261030C00220000	call	220.0000	2026-10-30	16.8300	16.4000	17.8000	230.1331	67300.00	33800.00	33500.00	40	5	61	29	2.10344827586207	0.391210972781713	0.397389660548941	true	false	false	true
18d2653e-e6aa-4d83-b7c4-09d5832e0af4	2026-09-28 11:11	2026-09-28 11:11	2026-09-28 11:11	CRM	CRM261106C00215000	call	215.0000	2026-11-06	21.3000	21.3000	22.8000	229.9150	29826.00	2135.00	27691.00	14	5	200	0	0	0.404141140214785	0.404542262576606	true	false	false	true
5e555786-bcb5-4ec3-ae36-686f7a31aa5e	2026-09-28 11:11	2026-09-28 11:11	2026-09-28 11:11	CRM	CRM261106C00215000	call	215.0000	2026-11-06	21.2600	21.0500	22.8000	229.9150	236005.00	123690.00	112315.00	111	9	186	0	0	0.398110253483798	0.404141140214785	true	false	false	true
45f7af08-6c3e-4b9c-8932-cdc69570d63c	2026-09-28 11:10	2026-09-28 11:10	2026-09-28 11:10	CRM	CRM261023C00225000	call	225.0000	2026-10-23	12.2100	12.1500	12.9500	229.7100	54940.00	1245.00	53695.00	45	20	188	18	10.4444444444444	0.392159667864255	0.402993386866854	true	false	false	true
1e8cd8d6-a0a8-4434-b5e8-f20815edb810	2026-09-28 11:10	2026-09-28 11:10	2026-09-28 11:10	CRM	CRM261106C00215000	call	215.0000	2026-11-06	20.5100	20.5000	22.6500	229.7100	153850.00	2135.00	151715.00	75	26	75	0	0	0.377854213961126	0.412080643296069	true	false	false	true
5f5de905-6e29-4bcd-b5ce-7fde24920c92	2026-09-28 11:08	2026-09-28 11:08	2026-09-28 11:08	CRM	CRM270115C00240000	call	240.0000	2027-01-15	17.5000	17.6000	17.5000	229.9650	124230.00	0.00	0.00	71	5	557	3384	0.164598108747045	0.409270113620747	0.409270113620747	false	false	false	true
07082e31-2af0-4fb5-98ee-0924ff90c41e	2026-09-28 10:48	2026-09-28 10:48	2026-09-28 10:48	CRM	CRM261016C00247500	call	247.5000	2026-10-16	2.4400	2.4200	2.6100	229.0000	12663.00	6104.00	6559.00	52	15	60	49	1.22448979591837	0.401918144971794	0.403256407085638	false	false	false	true
7e3c0438-3c1b-45e2-9403-a101562fefae	2026-09-28 10:31	2026-09-28 10:31	2026-09-28 10:31	CRM	CRM270917C00390000	call	390.0000	2027-09-17	8.3500	7.3500	8.9000	229.0000	10855.00	7515.00	3340.00	13	7	14	604	0.0231788079470199	0.443058918398445	0.444722210010309	false	false	false	true
af6929ad-6976-415e-a7fe-76820dd684b7	2026-09-28 09:50	2026-09-28 09:50	2026-09-28 09:50	CRM	CRM261002P00220000	put	220.0000	2026-10-02	2.6300	2.5700	2.8800	224.3075	230390.00	528.00	229862.00	876	56	5263	7505	0.70126582278481	0.479616492699544	0.485621397422864	false	false	false	true
1fc7be15-761d-4163-a6da-0068e0ecbd55	2026-09-28 09:30	2026-09-28 09:30	2026-09-28 09:30	CRM	CRM261002P00230000	put	230.0000	2026-10-02	6.6600	6.6500	8.4000	224.8700	23980.00	0.00	23980.00	36	6	82	1647	0.0497874924104432	0.378035223739502	0.384176376693819	false	false	false	true
942b7b78-eb05-4f4a-b9b1-5c314fb530c4	2026-09-25 15:26	2026-09-25 15:26	2026-09-25 15:26	CRM	CRM261002P00220000	put	220.0000	2026-10-02	0.7800	0.7300	0.8100	233.5900	11625.00	0.00	9854.00	150	8	520	7474	0.0695745250200696	0.3853873591848	0.386909430573133	false	false	false	true
5a6f1d59-1f6f-46bb-b2df-441b3d7a8113	2026-09-25 10:08	2026-09-25 10:08	2026-09-25 10:08	CRM	CRM270115P00240000	put	240.0000	2027-01-15	23.0700	23.0500	23.8000	236.0000	13840.00	0.00	13840.00	6	6	16	2818	0.0056777856635912	0.433688221378416	0.43610835039763	false	false	false	true
798b08fc-46df-45c0-8218-8b7279ec1916	2026-09-24 13:50	2026-09-24 13:50	2026-09-24 13:50	CRM	CRM280121P00210000	put	210.0000	2028-01-21	27.9900	27.6500	28.0000	238.0000	25195.00	22400.00	2795.00	9	6	34	1669	0.0203714799281007	0.465502650927416	0.466057687946913	false	false	false	true
70f01bd8-0fa8-46b3-9286-7db951bd1cae	2026-09-24 11:33	2026-09-24 11:32	2026-09-24 11:32	CRM	CRM270115C00240000	call	240.0000	2027-01-15	25.4000	25.0000	25.4500	241.7560	449595.00	444515.00	5080.00	177	35	239	3333	0.0717071707170717	0.432195385770114	0.431243887553778	true	false	false	true
cc19b5ae-3577-4f6b-bce8-dabab16831e0	2026-09-24 10:24	2026-09-24 10:24	2026-09-24 10:24	CRM	CRM261002P00245000	put	245.0000	2026-10-02	8.7300	8.5500	8.8000	239.2300	378160.00	266575.00	111585.00	433	28	439	215	2.04186046511628	0.36889252075436	0.379647738158251	false	false	false	true
c10f915e-128e-4d26-b52f-5a35ea0e1308	2026-09-24 09:44	2026-09-24 09:43	2026-09-24 09:43	CRM	CRM260925C00245000	call	245.0000	2026-09-25	0.5200	0.5000	0.6600	237.5300	16232.00	1567.00	14665.00	312	48	1227	2180	0.562844036697248	0.555722494114539	0.555722494114539	true	false	false	true
6e0561e9-02b1-485b-9741-3940e4d86912	2026-09-23 13:00	2026-09-23 13:00	2026-09-23 13:00	CRM	CRM270319P00240000	put	240.0000	2027-03-19	26.4200	26.3500	26.9000	241.0200	15850.00	5285.00	10565.00	6	6	20	615	0.032520325203252	0.444340749752125	0.445108435900903	false	false	false	true
9e342cf5-60d2-4589-9ed4-d1073a8dd346	2026-09-23 12:54	2026-09-23 12:54	2026-09-23 12:54	CRM	CRM280121C00300000	call	300.0000	2028-01-21	34.4800	34.0000	35.3000	240.8500	24134.00	17234.00	3450.00	7	5	45	2931	0.015353121801433	0.441636498106011	0.44208857572499	true	false	false	true
c2594004-b294-43b2-b36e-9c57b697ae3f	2026-09-23 11:29	2026-09-23 11:29	2026-09-23 11:29	CRM	CRM261009C00240000	call	240.0000	2026-10-09	7.4000	7.2500	7.7000	238.0000	36990.00	0.00	36990.00	50	7	92	113	0.814159292035398	0.405656480859827	0.405656480859827	false	false	false	true
ad59850b-a641-4bd4-8804-775bc43fc34a	2026-09-23 09:42	2026-09-23 09:41	2026-09-23 09:41	CRM	CRM261016C00240000	call	240.0000	2026-10-16	8.7400	8.6000	9.4000	238.4200	844998.00	49735.00	779418.00	967	130	1130	3045	0.371100164203612	0.378004189804803	0.383916358233806	true	false	false	true
69913a99-a42c-414f-bf6f-f542a039aa68	2026-09-23 09:42	2026-09-23 09:41	2026-09-23 09:41	CRM	CRM261016C00240000	call	240.0000	2026-10-16	8.7200	8.6500	9.3000	238.5250	28770.00	5280.00	23490.00	33	9	1270	3045	0.417077175697865	0.381704560957064	0.38589115573088	true	false	false	true
54c25932-e93a-4435-96ff-70844fa0e43b	2026-09-22 15:11	2026-09-22 15:11	2026-09-22 15:11	CRM	CRM261016C00240000	call	240.0000	2026-10-16	6.6100	6.1500	6.7500	232.9100	534417.00	518562.00	14525.00	809	100	1179	1518	0.776679841897233	0.396695733084819	0.39495075221159	true	false	false	true
7ffd706a-d566-4887-b40e-df6329b6320d	2026-09-22 13:48	2026-09-22 13:48	2026-09-22 13:48	CRM	CRM260925C00237500	call	237.5000	2026-09-25	1.6200	1.5100	1.6300	232.0850	19759.00	19438.00	321.00	122	13	994	985	1.00913705583756	0.43198934291488	0.434775042332325	false	false	false	true
21d508f5-9253-4e16-b5dd-f49dcad7073a	2026-09-22 13:39	2026-09-22 13:39	2026-09-22 13:39	CRM	CRM260925P00230000	put	230.0000	2026-09-25	2.7200	2.6000	2.7200	231.0000	150409.00	150409.00	0.00	553	54	2910	2534	1.1483820047356	0.417900008693028	0.426467633344317	false	false	false	true
259d40f9-2e10-4aac-8a02-8249112ee5ad	2026-09-22 13:19	2026-09-22 13:19	2026-09-22 13:19	CRM	CRM281215P00200000	put	200.0000	2028-12-15	34.1100	34.0500	34.6500	231.4918	545750.00	102450.00	443300.00	160	21	204	110	1.85454545454545	0.470251697202125	0.470251697202125	false	false	false	true
3c164d0e-0ef2-4619-84a5-692eead8e89f	2026-09-22 12:36	2026-09-22 12:36	2026-09-22 12:36	CRM	CRM260925C00232500	call	232.5000	2026-09-25	3.1500	3.1000	3.4500	231.9450	161471.00	5440.00	150911.00	512	65	3504	59	59.3898305084746	0.403024314392123	0.408988746681926	true	false	false	true
36ae1792-fd40-4c75-9d45-43a81715b995	2026-09-22 12:36	2026-09-22 12:36	2026-09-22 12:36	CRM	CRM260925C00232500	call	232.5000	2026-09-25	3.1700	3.1500	3.4500	231.9500	105638.00	0.00	105638.00	333	54	2983	59	50.5593220338983	0.402735124207431	0.407506491195253	true	false	false	true
719fd2ff-919a-4009-8e54-4ded14f2c15c	2026-09-22 12:36	2026-09-22 12:36	2026-09-22 12:36	CRM	CRM260925C00232500	call	232.5000	2026-09-25	3.2600	3.1500	3.4500	231.9000	162793.00	0.00	162793.00	500	12	2649	59	44.8983050847458	0.405621863850948	0.419941533149528	false	false	false	true
aef7f8a0-a6e8-4648-87ee-c506615a4c5e	2026-09-22 12:36	2026-09-22 12:35	2026-09-22 12:35	CRM	CRM260925C00235000	call	235.0000	2026-09-25	2.3000	2.2700	2.4500	232.1000	103193.00	233.00	102960.00	448	50	3194	319	10.012539184953	0.403563744803182	0.422175584792831	true	false	false	true
9d3b70e7-5bc4-4de2-90a2-ac442f4d2d89	2026-09-22 12:35	2026-09-22 12:35	2026-09-22 12:35	CRM	CRM260925C00235000	call	235.0000	2026-09-25	2.3800	2.1600	2.5600	232.4700	91781.00	22272.00	69509.00	386	16	2739	319	8.58620689655172	0.380464142537251	0.415440865590416	true	false	false	true
802ee4b6-d25e-442c-af07-bbabe3b190a9	2026-09-22 12:35	2026-09-22 12:35	2026-09-22 12:35	CRM	CRM260925C00232500	call	232.5000	2026-09-25	3.5300	3.5000	3.7500	232.4100	67070.00	12530.00	54540.00	190	17	2141	59	36.2881355932203	0.409968565960969	0.420812985044417	true	false	false	true
37b90f39-14de-4f6d-899a-8754730daacb	2026-09-22 12:35	2026-09-22 12:35	2026-09-22 12:35	CRM	CRM260925C00230000	call	230.0000	2026-09-25	4.8900	4.8500	5.2500	232.5300	485686.00	45232.00	439964.00	993	38	2203	546	4.03479853479853	0.390149601147255	0.405323920693489	true	false	false	true
1e1c1c39-dd92-4472-87a5-877e4afa54d0	2026-09-22 11:40	2026-09-22 11:40	2026-09-22 11:40	CRM	CRM260925P00232500	put	232.5000	2026-09-25	4.6600	4.6500	5.0000	230.3450	23305.00	0.00	22835.00	50	7	591	346	1.70809248554913	0.419786500102259	0.425928761023599	false	false	false	true
8332cd9b-fdae-4dc2-9db7-b9a14d8d835a	2026-09-22 11:36	2026-09-22 11:36	2026-09-22 11:36	CRM	CRM260925C00232500	call	232.5000	2026-09-25	2.7100	2.6000	2.7900	230.4200	34979.00	34979.00	0.00	129	31	1317	59	22.3220338983051	0.442258695426013	0.44282967866154	true	false	false	true
1456d72c-f75a-4198-89b5-8d7c89e80a55	2026-09-22 11:30	2026-09-22 11:29	2026-09-22 11:29	CRM	CRM260925C00230000	call	230.0000	2026-09-25	4.0600	3.8500	4.1500	230.0000	81158.00	81158.00	0.00	200	8	771	546	1.41208791208791	0.444643040452992	0.444643040452992	false	false	false	true
d830dac9-81d6-4fde-a9a9-fa0caf6df55b	2026-09-22 11:05	2026-09-22 11:05	2026-09-22 11:05	CRM	CRM260925C00232500	call	232.5000	2026-09-25	3.5100	3.2500	3.5500	231.9500	105240.00	105240.00	0.00	300	9	1119	59	18.9661016949153	0.442094721641244	0.442094721641244	false	false	false	true
2f25dabb-8bc5-4beb-9346-b0ebfcfed8eb	2026-09-22 10:53	2026-09-22 10:53	2026-09-22 10:53	CRM	CRM260925C00235000	call	235.0000	2026-09-25	2.4900	2.4200	2.5100	232.1450	24894.00	24894.00	0.00	100	5	680	319	2.13166144200627	0.438638470374199	0.438638470374199	false	false	false	true