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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×ticker = MOD×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

07186647-ffb8-4216-aec3-9eaa839e78b0	2026-08-24 14:25	2026-08-24 14:24	2026-08-24 14:24	MOD	MOD260918C00200000	call	200.0000	2026-09-18	10.4000	10.2000	11.0000	190.3600	83200.00	0.00	83200.00	80	6	96	475	0.202105263157895	0.713958077197525	0.713958077197525	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	9676073143.00	2026-10-27	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-24T18:49:58.488781Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
ad342dc4-c813-45e1-81ea-d173ffbd3b59	2026-08-24 13:31	2026-08-24 13:31	2026-08-24 13:31	MOD	MOD260918C00210000	call	210.0000	2026-09-18	6.7000	6.4000	6.9000	187.8125	18090.00	3350.00	4020.00	27	5	768	364	2.10989010989011	0.730937814294673	0.730937814294673	false	false	false	true
5ed1c55f-e128-4da0-863f-adcc3b7fd441	2026-08-24 11:46	2026-08-24 11:46	2026-08-24 11:46	MOD	MOD260918C00230000	call	230.0000	2026-09-18	3.1000	2.7500	3.1000	188.5950	27590.00	27590.00	0.00	89	10	95	1284	0.07398753894081	0.726435512076484	0.726435512076484	true	false	false	true
2f67c685-d76b-442d-8f93-b8d1e289bcaf	2026-08-24 10:53	2026-08-24 10:53	2026-08-24 10:53	MOD	MOD260918C00210000	call	210.0000	2026-09-18	7.1600	6.8000	7.2000	188.7300	22900.00	14380.00	8520.00	32	7	673	364	1.8489010989011	0.742387348335887	0.736792977546576	false	false	false	true
618b6eb4-30b9-413f-8ffc-77268bc48981	2026-08-24 10:53	2026-08-24 10:53	2026-08-24 10:53	MOD	MOD260918C00210000	call	210.0000	2026-09-18	7.2000	6.8000	7.3000	188.7300	10080.00	2160.00	7920.00	14	5	641	364	1.76098901098901	0.742387348335887	0.742387348335887	false	false	false	true
6f468811-50ca-4da4-9b49-bc71d589c1ba	2026-08-24 10:53	2026-08-24 10:53	2026-08-24 10:53	MOD	MOD260918C00210000	call	210.0000	2026-09-18	7.2000	6.8000	7.3000	188.7300	11520.00	2160.00	2880.00	16	5	626	364	1.71978021978022	0.742387348335887	0.742387348335887	false	false	false	true
418db78d-8483-4789-ba7a-316c77433be6	2026-08-24 10:52	2026-08-24 10:52	2026-08-24 10:52	MOD	MOD260918C00210000	call	210.0000	2026-09-18	7.0000	7.0000	7.1000	188.4900	18900.00	0.00	4200.00	27	5	602	364	1.65384615384615	0.735587340139922	0.735587340139922	false	false	false	true
2b01b24e-96db-4993-8fd1-bf6239c50eb4	2026-08-24 10:19	2026-08-24 10:19	2026-08-24 10:19	MOD	MOD260918C00195000	call	195.0000	2026-09-18	11.4000	11.4000	11.7000	187.9600	27360.00	0.00	27360.00	24	5	326	280	1.16428571428571	0.723988617484712	0.723988617484712	false	false	false	true
09871f37-6014-44c1-8b95-43e5464e8eea	2026-08-24 10:06	2026-08-24 10:06	2026-08-24 10:06	MOD	MOD260918C00195000	call	195.0000	2026-09-18	10.9000	10.2000	11.0000	185.0200	30520.00	20710.00	9810.00	28	5	302	280	1.07857142857143	0.767046793775018	0.767046793775018	true	false	false	true
b1f6c1f2-6ef5-4d65-a5fe-ff8d2e2e372e	2026-08-24 10:05	2026-08-24 10:05	2026-08-24 10:05	MOD	MOD260918C00195000	call	195.0000	2026-09-18	10.5000	10.5000	10.8000	184.8800	50400.00	0.00	50400.00	48	6	247	280	0.882142857142857	0.749302474049844	0.749302474049844	false	false	false	true
365884c0-9ef7-4771-bc44-8c2f83a8c397	2026-08-24 10:05	2026-08-24 10:04	2026-08-24 10:04	MOD	MOD260918C00195000	call	195.0000	2026-09-18	10.2000	9.4000	10.4000	184.3800	59160.00	40800.00	18360.00	58	7	169	280	0.603571428571429	0.744912354117705	0.744912354117705	true	false	false	true
3b48d2ef-d645-43a8-9f70-21f837f59642	2026-08-24 10:05	2026-08-24 10:04	2026-08-24 10:04	MOD	MOD260918C00195000	call	195.0000	2026-09-18	10.2000	9.2000	10.5000	184.6850	38760.00	11220.00	27540.00	38	5	57	280	0.203571428571429	0.737985890454955	0.737985890454955	true	false	false	true
30d2232c-b4ee-463a-8b86-efcc7fad43ac	2026-08-21 15:12	2026-08-21 15:12	2026-08-21 15:12	MOD	MOD260918C00200000	call	200.0000	2026-09-18	13.7000	13.7000	14.1000	195.9150	57540.00	0.00	57540.00	42	6	275	328	0.838414634146341	0.705682091901324	0.705682091901324	true	false	false	true
ce9b0a2e-accc-4d89-ba07-9361cf964092	2026-08-21 10:44	2026-08-21 10:44	2026-08-21 10:44	MOD	MOD260918P00190000	put	190.0000	2026-09-18	11.2000	11.2000	12.8000	194.8109	28004.00	0.00	28004.00	25	5	32	136	0.235294117647059	0.647923354531226	0.646965837037969	false	false	false	true
9d4c5f7e-cbf7-45f2-9403-a5cdb0b3557e	2026-08-21 10:42	2026-08-21 10:42	2026-08-21 10:42	MOD	MOD261120P00160000	put	160.0000	2026-11-20	12.5000	11.3000	12.5000	194.0400	120000.00	120000.00	0.00	96	22	96	8	12	0.764532450824231	0.764532450824231	false	false	false	true
6af2986a-c6fb-44f1-9d4e-541add22a281	2026-08-20 15:53	2026-08-20 15:53	2026-08-20 15:53	MOD	MOD260821C00195000	call	195.0000	2026-08-21	1.7000	1.7000	2.0000	190.3900	15980.00	0.00	15980.00	94	5	464	627	0.740031897926635	0.877559008294852	0.877559008294852	true	false	false	true
db32b1b1-fc29-409c-bdf8-a79846c235db	2026-08-20 15:51	2026-08-20 15:51	2026-08-20 15:51	MOD	MOD260821C00195000	call	195.0000	2026-08-21	1.5500	1.5000	1.7000	190.3800	16120.00	0.00	16120.00	104	6	370	627	0.590111642743222	0.835469029271752	0.835469029271752	false	false	false	true
46b68f96-f20d-4a94-806c-d836f3212213	2026-08-20 15:51	2026-08-20 15:51	2026-08-20 15:51	MOD	MOD260821C00195000	call	195.0000	2026-08-21	1.4500	1.2500	1.6000	190.2350	13630.00	7105.00	6525.00	94	5	266	627	0.424242424242424	0.81882371777785	0.81882371777785	false	false	false	true
0db54b32-948d-43f3-b463-a16ad1e25ab8	2026-08-20 12:13	2026-08-20 12:13	2026-08-20 12:13	MOD	MOD261120C00210000	call	210.0000	2026-11-20	21.0000	21.0000	21.7000	189.7600	42000.00	0.00	42000.00	20	10	20	18	1.11111111111111	0.737851290443967	0.737851290443967	false	false	false	true
7cfa0669-2eef-42c1-bfa5-ebe16c1ecab6	2026-08-19 15:09	2026-08-19 15:09	2026-08-19 15:09	MOD	MOD261120C00270000	call	270.0000	2026-11-20	9.0000	8.7000	10.8000	192.6750	24300.00	900.00	19800.00	27	6	57	21	2.71428571428571	0.746912968203777	0.746912968203777	false	false	false	true
128cf11a-84b3-4fc0-855d-f961f7187ba3	2026-08-19 15:09	2026-08-19 15:09	2026-08-19 15:09	MOD	MOD261120C00270000	call	270.0000	2026-11-20	9.1000	8.8000	9.1000	192.6750	30030.00	2730.00	0.00	33	6	90	21	4.28571428571429	0.750156138541806	0.750156138541806	false	false	false	true
c70d471a-4f4e-4e2a-8eac-f7d001408022	2026-08-19 15:09	2026-08-19 15:09	2026-08-19 15:09	MOD	MOD261120C00200000	call	200.0000	2026-11-20	27.0000	26.5000	27.1000	192.6750	56700.00	45900.00	5400.00	21	5	73	11	6.63636363636364	0.757098636799602	0.757098636799602	false	false	false	true
bb051217-237b-41d4-86cb-051bc87026ea	2026-08-19 15:09	2026-08-19 15:09	2026-08-19 15:09	MOD	MOD261120C00270000	call	270.0000	2026-11-20	9.0000	8.5000	9.5000	192.4000	23400.00	1800.00	0.00	26	6	26	21	1.23809523809524	0.749131025087144	0.749131025087144	false	false	false	true
873f4d97-7793-43b7-9a08-35d39e0f2d25	2026-08-19 15:09	2026-08-19 15:09	2026-08-19 15:09	MOD	MOD261120C00200000	call	200.0000	2026-11-20	26.9000	26.9000	27.1000	192.4000	48420.00	0.00	48420.00	18	8	52	11	4.72727272727273	0.758407057916647	0.758407057916647	false	false	false	true
9a278a81-f57d-4b92-9eba-bf6fd7694e74	2026-08-18 13:50	2026-08-18 13:50	2026-08-18 13:50	MOD	MOD261120C00320000	call	320.0000	2026-11-20	5.5000	5.5000	6.1000	201.4550	25300.00	0.00	25300.00	46	18	51	405	0.125925925925926	0.75221718763128	0.75221718763128	false	false	false	true
510d6c52-b810-4ca2-ae6e-2a2a17a48b6b	2026-08-18 13:16	2026-08-18 13:16	2026-08-18 13:16	MOD	MOD260918C00230000	call	230.0000	2026-09-18	8.2000	8.2000	8.3000	204.3800	10660.00	0.00	10660.00	13	5	737	639	1.15336463223787	0.714708186721392	0.714708186721392	false	false	false	true
dc52dbe6-ca64-4f26-afa7-59457d08a1af	2026-08-18 13:12	2026-08-18 13:11	2026-08-18 13:11	MOD	MOD260918C00230000	call	230.0000	2026-09-18	8.2000	7.5000	8.4000	204.5400	38540.00	3280.00	26240.00	47	5	697	639	1.09076682316119	0.712271934108247	0.712271934108247	false	false	false	true
db339039-b6ae-40e8-a78e-1f662d6829be	2026-08-18 13:04	2026-08-18 13:04	2026-08-18 13:04	MOD	MOD260918C00230000	call	230.0000	2026-09-18	8.2000	8.2000	8.4000	204.6950	23780.00	0.00	23780.00	29	7	643	639	1.00625978090767	0.709911295028845	0.709911295028845	true	false	false	true
b77a2bba-bf3e-4ee6-b1c1-0bf3d04b6d76	2026-08-18 13:02	2026-08-18 13:02	2026-08-18 13:02	MOD	MOD260918C00230000	call	230.0000	2026-09-18	8.2000	8.2000	8.5000	204.7100	38540.00	0.00	13940.00	47	7	588	639	0.92018779342723	0.70968281833118	0.70968281833118	false	false	false	true
04216323-915a-4366-9973-22209d60e9dc	2026-08-18 12:58	2026-08-18 12:57	2026-08-18 12:57	MOD	MOD260918C00230000	call	230.0000	2026-09-18	8.2000	7.8000	8.9000	204.7200	23780.00	0.00	23780.00	29	6	512	639	0.801251956181534	0.709530497777853	0.709530497777853	true	false	false	true
2ea73de6-8fac-409b-b460-cb843eb6bc45	2026-08-18 12:44	2026-08-18 12:44	2026-08-18 12:44	MOD	MOD260918C00230000	call	230.0000	2026-09-18	8.3000	8.2000	8.3000	204.1700	12450.00	12450.00	0.00	15	7	483	639	0.755868544600939	0.722560610777175	0.722560610777175	false	false	false	true
178bdcfb-4f24-4ab6-befb-554344bbfc6f	2026-08-18 12:43	2026-08-18 12:43	2026-08-18 12:43	MOD	MOD260918C00230000	call	230.0000	2026-09-18	8.2000	7.7000	8.4000	204.1800	25420.00	24600.00	820.00	31	5	468	639	0.732394366197183	0.717752764127075	0.717752764127075	true	false	false	true
835409c7-da34-4fed-a298-cd86219a1fe3	2026-08-18 12:35	2026-08-18 12:35	2026-08-18 12:35	MOD	MOD260918C00230000	call	230.0000	2026-09-18	8.1000	7.6000	8.3000	204.1300	45360.00	29160.00	8910.00	56	9	419	639	0.655712050078247	0.713847484221434	0.713847484221434	false	false	false	true
79805ef8-ee6b-4e11-8e87-edce6b074594	2026-08-18 11:30	2026-08-18 11:30	2026-08-18 11:30	MOD	MOD260918C00230000	call	230.0000	2026-09-18	7.8000	7.4000	8.0000	203.1800	41340.00	6240.00	12480.00	53	5	348	639	0.544600938967136	0.714078345145919	0.714078345145919	false	false	false	true
0a56c4f0-b845-41e2-bf27-e10da9b4550a	2026-08-18 11:30	2026-08-18 11:30	2026-08-18 11:30	MOD	MOD260918C00230000	call	230.0000	2026-09-18	7.6000	6.8000	7.9000	202.4200	61560.00	3800.00	25840.00	81	5	216	639	0.338028169014085	0.715924848940491	0.715924848940491	false	false	false	true
fe1d9a60-32fb-4147-83b5-bb4cbc102812	2026-08-18 10:59	2026-08-18 10:59	2026-08-18 10:59	MOD	MOD260918C00195000	call	195.0000	2026-09-18	19.7900	19.6000	20.4000	201.3600	124698.00	114838.00	5940.00	63	29	63	266	0.236842105263158	0.699521909551582	0.699521909551582	true	false	false	true
cff8afc5-871e-4552-b5d0-1fa9a3fb8f8e	2026-08-18 10:59	2026-08-18 10:59	2026-08-18 10:59	MOD	MOD260918P00190000	put	190.0000	2026-09-18	10.5000	10.2000	10.5000	201.3600	38849.00	38849.00	0.00	37	15	41	88	0.465909090909091	0.695648686753716	0.695648686753716	false	false	false	true
c00a41de-9d7b-4e2a-b3a1-02a00c1ea729	2026-08-18 10:59	2026-08-18 10:59	2026-08-18 10:59	MOD	MOD260918P00195000	put	195.0000	2026-09-18	12.7000	12.4000	12.7000	201.3600	15240.00	15240.00	0.00	12	7	14	10	1.4	0.694713761976249	0.694713761976249	false	false	false	true
1fbf7406-3607-4013-91b9-16f16be1899f	2026-08-18 10:59	2026-08-18 10:59	2026-08-18 10:59	MOD	MOD260918C00200000	call	200.0000	2026-09-18	17.1800	17.1000	17.2000	201.3600	17180.00	15480.00	1700.00	10	8	56	70	0.8	0.695629367874659	0.695629367874659	false	false	false	true
6d6e7eb5-ace8-4935-9aae-0a3cd8dd86e6	2026-08-18 10:57	2026-08-18 10:57	2026-08-18 10:57	MOD	MOD260918C00230000	call	230.0000	2026-09-18	7.0000	6.6000	7.1000	202.2300	30800.00	20300.00	9800.00	44	7	97	639	0.151799687010955	0.689717819781705	0.689717819781705	true	false	false	true
9d5610cc-a12e-463e-8497-75b1fa575073	2026-08-18 10:54	2026-08-18 10:54	2026-08-18 10:54	MOD	MOD260918C00230000	call	230.0000	2026-09-18	6.9000	6.9000	7.4000	202.1400	26220.00	0.00	14490.00	38	5	53	639	0.0829420970266041	0.686147438537857	0.686147438537857	false	false	false	true
3fee2b52-7ba0-4289-982f-c546f10987a2	2026-08-18 10:05	2026-08-18 10:05	2026-08-18 10:05	MOD	MOD260918C00250000	call	250.0000	2026-09-18	4.3000	4.3000	5.2000	207.3800	114382.00	0.00	114382.00	266	37	274	1601	0.171143035602748	0.680380641623832	0.680380641623832	false	false	false	true
2c9bff6c-830a-4e39-9a74-bbaa32c3aa18	2026-08-18 09:30	2026-08-18 09:30	2026-08-18 09:30	MOD	MOD270917P00150000	put	150.0000	2027-09-17	26.5000	25.3000	30.9500	207.5900	53000.00	0.00	53000.00	20	9	20	20	1	0.747309797804036	0.747309797804036	false	false	false	true
b3d5927a-3afd-48d1-a5b1-86394755a9c2	2026-08-17 15:26	2026-08-17 15:26	2026-08-17 15:26	MOD	MOD260918C00250000	call	250.0000	2026-09-18	7.9000	7.7000	7.9000	218.8300	146150.00	146150.00	0.00	185	23	1419	107	13.2616822429907	0.704605805355608	0.704605805355608	false	false	false	true
a8a450e5-f8c7-4ee2-9eb9-e21970414283	2026-08-17 15:26	2026-08-17 15:25	2026-08-17 15:25	MOD	MOD260918C00250000	call	250.0000	2026-09-18	7.7000	7.3000	7.9000	218.8800	121660.00	10010.00	111650.00	158	5	1233	107	11.5233644859813	0.695071959849263	0.695071959849263	false	false	false	true
abcc8f48-a252-40e7-87c0-011f37f381a3	2026-08-17 15:25	2026-08-17 15:25	2026-08-17 15:25	MOD	MOD260821P00220000	put	220.0000	2026-08-21	7.7200	7.5000	8.3000	218.8800	84887.00	60827.00	24060.00	110	29	128	213	0.60093896713615	0.7941205536331	0.7941205536331	false	false	false	true
730431ad-0c18-4fa2-bbf7-bb27a05f8f2a	2026-08-17 15:25	2026-08-17 15:25	2026-08-17 15:25	MOD	MOD260918C00250000	call	250.0000	2026-09-18	7.6000	7.6000	7.8000	218.7800	36480.00	0.00	36480.00	48	5	880	107	8.22429906542056	0.691948323220117	0.691948323220117	false	false	false	true
1890ae83-d6fd-43e7-a97a-ab9a4ad08238	2026-08-17 15:25	2026-08-17 15:24	2026-08-17 15:24	MOD	MOD260918C00250000	call	250.0000	2026-09-18	7.6000	7.6000	7.9000	218.7800	136040.00	0.00	136040.00	179	5	817	107	7.63551401869159	0.691948323220117	0.691948323220117	false	false	false	true
7bbb5873-4992-4a4b-a340-4089f9fb7aa4	2026-08-17 15:19	2026-08-17 15:19	2026-08-17 15:19	MOD	MOD260918C00250000	call	250.0000	2026-09-18	7.6000	7.2000	7.7000	218.9550	99560.00	34200.00	64600.00	131	6	174	107	1.62616822429907	0.689628965548136	0.689628965548136	true	false	false	true
30c85fc9-92c9-4a63-9730-dd7446efcbe5	2026-08-17 15:19	2026-08-17 15:19	2026-08-17 15:19	MOD	MOD260918C00250000	call	250.0000	2026-09-18	7.7000	7.2000	7.8000	219.1200	143989.00	120120.00	769.00	187	17	361	107	3.37383177570093	0.691881344695247	0.691881344695247	true	false	false	true