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:alert_rule = RepeatedHits×ticker = JD×sorted by created_at ↑×

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

d170fa5d-27d4-4f2f-8850-d6c1b82afad7	2026-08-17 09:38	2026-08-17 09:38	2026-08-17 09:38	JD	JD260821P00028000	put	28.0000	2026-08-21	0.1700	0.1600	0.1700	28.7100	10455.00	10455.00	0.00	615	7	762	6228	0.122350674373796	0.371527245646305	0.371527245646305	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Consumer Cyclical	33071255478.00	2026-11-12	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
2300ce85-1c85-4e40-8cf9-6cc50646be23	2026-08-17 10:54	2026-08-17 10:54	2026-08-17 10:54	JD	JD260918C00034000	call	34.0000	2026-09-18	0.0800	0.0800	0.0900	28.5889	11808.00	0.00	11808.00	1476	20	1663	17135	0.0970528158739422	0.361959771787192	0.361959771787192	true	false	false	true
478015fa-ab31-4bea-b7d5-1d565c61db7b	2026-08-17 11:37	2026-08-17 11:37	2026-08-17 11:37	JD	JD271217C00035000	call	35.0000	2027-12-17	3.0500	3.0000	3.1000	28.4650	40260.00	27450.00	12505.00	132	34	142	2767	0.0513191181785327	0.35803596251676	0.35803596251676	true	false	false	true
346262a5-71da-4732-9f47-1eff52c489f1	2026-08-17 12:10	2026-08-17 12:10	2026-08-17 12:10	JD	JD261218C00033000	call	33.0000	2026-12-18	0.9900	0.9600	1.0300	28.4990	35343.00	33363.00	1980.00	357	35	357	1074	0.332402234636872	0.357199739497023	0.357199739497023	false	false	false	true
299ec0cf-c509-48a6-b443-ffe00d6715a4	2026-08-18 10:09	2026-08-18 10:09	2026-08-18 10:09	JD	JD261218C00032000	call	32.0000	2026-12-18	1.2000	1.1200	1.2100	28.4350	11160.00	11160.00	0.00	93	25	93	3320	0.0280120481927711	0.356288420527514	0.356288420527514	false	false	false	true
8d54cf94-893b-4836-b56b-baa5978ca143	2026-08-18 11:22	2026-08-18 11:22	2026-08-18 11:22	JD	JD261218C00035000	call	35.0000	2026-12-18	0.6500	0.6300	0.6500	28.3951	21385.00	21385.00	0.00	329	34	334	3482	0.0959218839747272	0.369768932821384	0.369768932821384	false	false	false	true
0a2672ca-5ddd-4874-bda7-03b3e74e57b6	2026-08-18 12:51	2026-08-18 12:51	2026-08-18 12:51	JD	JD281215C00035000	call	35.0000	2028-12-15	4.6000	4.4000	4.6000	28.4550	11500.00	11500.00	0.00	25	7	27	251	0.107569721115538	0.337159586018009	0.337159586018009	false	false	false	true
87b01d93-074f-4bff-928c-402a48639a66	2026-08-18 12:52	2026-08-18 12:52	2026-08-18 12:52	JD	JD261218C00033000	call	33.0000	2026-12-18	1.0000	0.9700	1.0000	28.4550	35100.00	35100.00	0.00	351	38	355	1261	0.28152260111023	0.362847093604914	0.362847093604914	false	false	false	true
6f75d10b-dffe-4864-bea8-d992034c7d68	2026-08-18 12:54	2026-08-18 12:54	2026-08-18 12:54	JD	JD270319P00028000	put	28.0000	2027-03-19	2.5000	2.3000	2.6400	28.4705	41000.00	17000.00	24000.00	164	14	164	85	1.92941176470588	0.3568240944589	0.3568240944589	false	false	false	true
2c96496e-b799-4a78-82ac-bd0331f4766a	2026-08-18 12:55	2026-08-18 12:55	2026-08-18 12:55	JD	JD261016C00033000	call	33.0000	2026-10-16	0.3300	0.3000	0.3300	28.4805	14190.00	14190.00	0.00	430	38	471	3292	0.143074119076549	0.341149667933493	0.341149667933493	true	false	false	true
eecbb344-01c7-4008-a14f-e95a3f8917f2	2026-08-18 13:59	2026-08-18 13:59	2026-08-18 13:59	JD	JD261218P00028000	put	28.0000	2026-12-18	1.8700	1.8300	1.8700	28.4450	31416.00	31416.00	0.00	168	22	168	1913	0.0878201777313121	0.348976695388855	0.348976695388855	false	false	false	true
c43203de-900b-4976-9264-4a28a45b1459	2026-08-18 15:01	2026-08-18 15:00	2026-08-18 15:00	JD	JD261218C00032000	call	32.0000	2026-12-18	1.2800	1.2400	1.2800	28.6100	17536.00	17536.00	0.00	137	12	247	3320	0.0743975903614458	0.359399754862462	0.359399754862462	false	false	false	true
f50a9567-56e5-4200-bc96-ce4b0a24ebc5	2026-08-19 10:09	2026-08-19 10:09	2026-08-19 10:09	JD	JD280121C00025000	call	25.0000	2028-01-21	7.7000	7.5000	7.7000	29.1300	192500.00	192500.00	0.00	250	8	250	2229	0.112157918349035	0.350982591655608	0.350982591655608	false	false	false	true
8b85271e-d5cf-40ce-8274-46e668ba2de7	2026-08-19 10:44	2026-08-19 10:44	2026-08-19 10:44	JD	JD260918P00030000	put	30.0000	2026-09-18	1.5400	1.5400	1.5700	29.0650	13244.00	0.00	13244.00	86	13	90	6180	0.0145631067961165	0.316395312587511	0.316395312587511	false	false	false	true
dfb6b21d-6fa9-4733-ae55-4f9112ae3b5e	2026-08-19 10:52	2026-08-19 10:52	2026-08-19 10:52	JD	JD261218C00035000	call	35.0000	2026-12-18	0.8200	0.7900	0.8200	29.1100	13940.00	13940.00	0.00	170	23	171	3730	0.0458445040214477	0.373012126827711	0.373012126827711	false	false	false	true
3f95661d-c4df-4731-b323-43a1af591300	2026-08-19 12:48	2026-08-19 12:47	2026-08-19 12:47	JD	JD261218C00030000	call	30.0000	2026-12-18	2.2200	2.2000	2.2200	29.1450	11100.00	11100.00	0.00	50	9	123	8164	0.0150661440470358	0.363114904172119	0.363114904172119	false	false	false	true
7784cab9-b18e-461b-af95-654cfe48ec76	2026-08-20 10:58	2026-08-20 10:58	2026-08-20 10:58	JD	JD261218C00034000	call	34.0000	2026-12-18	1.0100	0.9800	1.0100	29.1850	62115.00	62115.00	0.00	615	26	615	698	0.8810888252149	0.369629492567973	0.369629492567973	false	false	false	true
5c65fb5b-307e-4ff4-840a-06d50125f074	2026-08-20 13:48	2026-08-20 13:47	2026-08-20 13:47	JD	JD260821C00025000	call	25.0000	2026-08-21	4.3000	4.3000	4.5000	29.3100	30530.00	0.00	30530.00	71	8	174	1562	0.111395646606914	2.48328164413173	2.48328164413173	false	false	false	true
8bf75137-86df-4d82-993f-be5513f7e95f	2026-08-21 09:39	2026-08-21 09:39	2026-08-21 09:39	JD	JD260918P00029000	put	29.0000	2026-09-18	0.7800	0.7700	0.8100	29.3450	12792.00	11622.00	1170.00	164	12	313	3923	0.0797858781544736	0.304489542128994	0.304489542128994	false	false	false	true
299abb8f-ddad-4b01-8de9-c97b2f334f8c	2026-08-21 09:39	2026-08-21 09:39	2026-08-21 09:39	JD	JD260918P00029000	put	29.0000	2026-09-18	0.7800	0.7600	0.7950	29.3450	16614.00	11232.00	5382.00	213	16	600	3923	0.152944175375988	0.304489542128994	0.304489542128994	false	false	false	true
1b3e391e-a355-4f40-9089-1d8763083937	2026-08-21 10:35	2026-08-21 10:35	2026-08-21 10:35	JD	JD261016C00031000	call	31.0000	2026-10-16	0.9000	0.8600	0.9100	29.3800	10260.00	10260.00	0.00	114	32	157	977	0.160696008188332	0.321791043068797	0.321791043068797	false	false	false	true
79789562-b565-4159-8b14-ee11147f2daf	2026-08-21 13:35	2026-08-21 13:34	2026-08-21 13:34	JD	JD260918C00030000	call	30.0000	2026-09-18	0.7800	0.7700	0.8000	29.4100	10218.00	0.00	10218.00	131	12	335	9910	0.0338042381432896	0.308734664085315	0.308734664085315	false	false	false	true
578d5e21-3e18-4555-ad1a-06c526d1e490	2026-08-21 15:28	2026-08-21 15:28	2026-08-21 15:28	JD	JD260918C00031000	call	31.0000	2026-09-18	0.4800	0.4800	0.4900	29.4800	12432.00	0.00	12432.00	259	19	404	2053	0.196785192401364	0.312661546649412	0.312661546649412	false	false	false	true
7485dcc1-f66e-4f8f-b284-0e039c2809bc	2026-08-24 09:48	2026-08-24 09:48	2026-08-24 09:48	JD	JD261218C00030000	call	30.0000	2026-12-18	2.1900	2.1400	2.3500	29.1500	54750.00	0.00	27594.00	250	6	254	9362	0.0271309549241615	0.367180601644196	0.367180601644196	false	false	false	true
22269e54-2314-4a77-bd0e-95b92b917b76	2026-08-24 09:48	2026-08-24 09:48	2026-08-24 09:48	JD	JD260918P00028000	put	28.0000	2026-09-18	0.4500	0.4100	0.4900	29.1500	14535.00	14130.00	405.00	323	27	334	7750	0.0430967741935484	0.314679266363453	0.314679266363453	false	false	false	true
536e0be5-415a-421c-b76e-e09cecf352c3	2026-08-24 09:51	2026-08-24 09:51	2026-08-24 09:51	JD	JD261016P00031000	put	31.0000	2026-10-16	2.4500	2.2700	2.4600	29.0950	12985.00	8820.00	0.00	53	11	53	1025	0.0517073170731707	0.311397836849707	0.311397836849707	false	false	false	true
2fc53432-933a-4fd0-b491-099f9103ca1d	2026-08-24 09:55	2026-08-24 09:55	2026-08-24 09:55	JD	JD260918P00030000	put	30.0000	2026-09-18	1.4000	1.2500	1.5400	29.0700	14013.00	2380.00	8833.00	100	15	100	6365	0.0157109190887667	0.295906366071613	0.299497410609157	false	false	false	true
ae9ed33a-3746-413c-91d7-d05e57e93e9c	2026-08-24 10:05	2026-08-24 10:05	2026-08-24 10:05	JD	JD270917P00030000	put	30.0000	2027-09-17	4.8000	4.7000	4.9000	29.1200	15360.00	14400.00	960.00	32	7	52	0	0	0.425163836595978	0.425163836595978	false	false	false	true
f8862667-b742-4f16-8d23-017d45e8100f	2026-08-24 10:06	2026-08-24 10:05	2026-08-24 10:05	JD	JD270917P00032000	put	32.0000	2027-09-17	6.0500	5.9000	6.6000	29.1200	19360.00	18150.00	1210.00	32	12	32	0	0	0.43349273150992	0.43349273150992	false	false	false	true
e6e8f2de-eb57-4ad5-98e1-ecbcc2f3982d	2026-08-24 10:21	2026-08-24 10:21	2026-08-24 10:21	JD	JD270917P00030000	put	30.0000	2027-09-17	4.8000	4.7000	4.8500	29.1500	11520.00	11040.00	480.00	24	10	76	0	0	0.426194584171281	0.426194584171281	false	false	false	true
30718dd4-9efe-41c7-9038-60157d636d2b	2026-08-24 10:40	2026-08-24 10:40	2026-08-24 10:40	JD	JD270617P00030000	put	30.0000	2027-06-17	4.3000	4.2500	4.4000	29.2400	11610.00	11180.00	430.00	27	10	63	3311	0.0190274841437632	0.422484980273531	0.422484980273531	false	false	false	true
1a763d17-5ca3-4372-9b6d-86193cb2b566	2026-08-24 11:35	2026-08-24 11:34	2026-08-24 11:34	JD	JD261218C00030000	call	30.0000	2026-12-18	2.1700	2.1200	2.1700	29.1500	170562.00	170562.00	0.00	786	43	1056	9362	0.112796411023286	0.364129044917236	0.364129044917236	false	false	false	true
5420d893-5cad-4704-b1db-16eda02aa457	2026-08-24 12:52	2026-08-24 12:52	2026-08-24 12:52	JD	JD260918P00029000	put	29.0000	2026-09-18	0.8300	0.8100	0.8600	29.1500	24319.00	17430.00	3403.00	293	44	333	3741	0.0890136327185245	0.309608307941613	0.309608307941613	true	false	false	true
f14f9bc6-8add-4856-8a00-4903efe8a4c8	2026-08-24 12:53	2026-08-24 12:52	2026-08-24 12:52	JD	JD260918P00028000	put	28.0000	2026-09-18	0.4600	0.4400	0.4600	29.1450	11454.00	11454.00	0.00	249	10	757	7750	0.0976774193548387	0.317965101089827	0.317965101089827	false	false	false	true
fae13aed-312c-47b2-9baf-9cda70ed27ac	2026-08-24 13:48	2026-08-24 13:48	2026-08-24 13:48	JD	JD280121P00025000	put	25.0000	2028-01-21	2.8200	2.7800	2.8200	29.1050	15228.00	15228.00	0.00	54	5	523	6376	0.0820263488080301	0.416660943383753	0.416660943383753	false	false	false	true
ac28021d-226f-42f4-b327-c94a8d012d7d	2026-08-24 13:58	2026-08-24 13:58	2026-08-24 13:58	JD	JD261218P00025000	put	25.0000	2026-12-18	0.7100	0.6500	0.7300	29.1000	105932.00	105861.00	71.00	1492	43	1508	14012	0.107622038252926	0.375686473066158	0.375686473066158	false	false	false	true
30ca3f17-7065-4391-99af-147a2972f3b4	2026-08-24 14:08	2026-08-24 14:08	2026-08-24 14:08	JD	JD281215C00025000	call	25.0000	2028-12-15	8.7500	8.6500	8.8000	29.0500	51625.00	51625.00	0.00	59	12	100	404	0.247524752475248	0.317193296585696	0.317778441667983	true	false	false	true
15817a27-e2c5-418e-b5f6-ae74ae04b0c5	2026-08-24 14:52	2026-08-24 14:52	2026-08-24 14:52	JD	JD270917P00032000	put	32.0000	2027-09-17	6.0500	5.9500	6.1500	29.1150	21780.00	20570.00	1210.00	36	6	110	0	0	0.433301905712726	0.433301905712726	false	false	false	true
c5b04aab-6447-4b2c-a36f-bf1a409dc19a	2026-08-24 14:59	2026-08-24 14:58	2026-08-24 14:58	JD	JD270917P00027000	put	27.0000	2027-09-17	3.2500	3.1500	3.3000	29.1100	11700.00	11050.00	650.00	36	7	104	5	20.8	0.421052075781379	0.421052075781379	false	false	false	true
b311b9c8-1839-4e86-b8b4-66181a536685	2026-08-25 11:03	2026-08-25 11:03	2026-08-25 11:03	JD	JD270617P00028000	put	28.0000	2027-06-17	3.3000	3.1500	3.4000	29.0950	50820.00	49170.00	1650.00	154	6	441	2211	0.199457259158752	0.421137955413746	0.421137955413746	false	false	false	true
a1afa6a6-2d4d-4dc9-8058-cffd25b4b0e4	2026-08-25 11:10	2026-08-25 11:10	2026-08-25 11:10	JD	JD270617P00028000	put	28.0000	2027-06-17	3.3000	3.2000	3.3500	29.1300	86130.00	84810.00	1320.00	261	8	744	2211	0.336499321573948	0.4224050539139	0.4224050539139	false	false	false	true
c81560e9-a8a5-46fc-b385-3295e2344f99	2026-08-25 14:10	2026-08-25 14:10	2026-08-25 14:10	JD	JD270617P00028000	put	28.0000	2027-06-17	3.2000	3.2000	3.2500	29.0000	13120.00	0.00	13120.00	41	8	802	2211	0.362731795567616	0.41698029808609	0.41698029808609	false	false	false	true
995d9e48-2453-46ef-a8c8-60f8075a51e0	2026-08-26 12:01	2026-08-26 12:01	2026-08-26 12:01	JD	JD260918C00030000	call	30.0000	2026-09-18	0.4800	0.4700	0.5000	28.8200	12960.00	0.00	12960.00	270	10	515	10275	0.0501216545012165	0.316658123986236	0.316658123986236	false	false	false	true
46d0f2da-0a6f-42da-b8bd-5a54a7a3cf3d	2026-08-27 12:05	2026-08-27 12:04	2026-08-27 12:04	JD	JD260925C00031000	call	31.0000	2026-09-25	0.2500	0.2500	0.2800	28.3600	25250.00	0.00	25250.00	1010	20	1012	4076	0.248282630029441	0.323381042144471	0.323381042144471	false	false	false	true
6818f0bc-9749-43f5-a04a-7ba1425106c6	2026-08-27 14:57	2026-08-27 14:57	2026-08-27 14:57	JD	JD270115C00029000	call	29.0000	2027-01-15	2.5000	2.4400	2.5000	28.4400	18000.00	18000.00	0.00	72	7	73	67	1.08955223880597	0.363091276176038	0.363091276176038	false	false	false	true
292c1ac9-7072-45cd-8eeb-2e869455a0e1	2026-08-27 15:27	2026-08-27 15:27	2026-08-27 15:27	JD	JD261016C00030000	call	30.0000	2026-10-16	0.8200	0.7700	0.8200	28.0000	20500.00	20500.00	0.00	250	32	340	2023	0.168067226890756	0.32944493174643	0.32944493174643	false	false	false	true
f87efaf7-a240-4801-85df-7737837b55ba	2026-08-27 15:29	2026-08-27 15:29	2026-08-27 15:29	JD	JD281215P00015000	put	15.0000	2028-12-15	1.0000	0.9900	1.0500	28.0000	19800.00	3600.00	16200.00	198	12	200	120	1.66666666666667	0.461164517337063	0.461164517337063	false	false	false	true
da2e635d-9e53-496c-b388-f75df550ff25	2026-08-27 15:31	2026-08-27 15:31	2026-08-27 15:31	JD	JD260904C00029000	call	29.0000	2026-09-04	0.2700	0.2600	0.2900	28.0000	36936.00	0.00	35802.00	1368	13	1467	321	4.57009345794393	0.291434182614331	0.291434182614331	false	false	false	true
86000edb-ea4b-4587-a28c-3fb7eb4c0fa8	2026-08-27 15:46	2026-08-27 15:46	2026-08-27 15:46	JD	JD261016C00029000	call	29.0000	2026-10-16	1.1600	1.1400	1.1600	28.4400	28072.00	28072.00	0.00	242	8	574	277	2.07220216606498	0.320531368064302	0.320531368064302	false	false	false	true
715fe7d5-c9b9-40a3-86c0-f5dd654295e3	2026-08-28 14:35	2026-08-28 14:34	2026-08-28 14:34	JD	JD261016P00030000	put	30.0000	2026-10-16	2.0700	2.0700	2.1200	28.5800	65205.00	0.00	65205.00	315	20	447	712	0.627808988764045	0.314610764189253	0.314610764189253	false	false	false	true