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:er_time = unknown×ticker = JD×

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

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	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-24T18:20:03.734818Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
b0d646b0-9fef-4f07-8846-1a4cc17bfe82	2026-08-19 11:54	2026-08-19 11:53	2026-08-19 11:53	JD	JD261218C00029000	call	29.0000	2026-12-18	2.6800	2.6500	2.8800	29.2000	26804.00	0.00	26804.00	100	11	154	2205	0.0698412698412698	0.354581348803507	0.360665311606374	false	false	false	true	false
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	false
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	false
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	false
44d494f9-2bfe-4418-b801-9a29b560f2cb	2026-08-19 09:54	2026-08-19 09:53	2026-08-19 09:53	JD	JD260925C00031000	call	31.0000	2026-09-25	0.5700	0.5700	0.6500	29.1900	209115.00	14573.00	14878.00	3656	48	3660	124	29.5161290322581	0.332551163440236	0.333196404813302	true	false	false	true	false
b55501c2-1a6f-4ddc-8c77-6f1cc011ddc5	2026-08-18 15:50	2026-08-18 15:50	2026-08-18 15:50	JD	JD260925C00028000	call	28.0000	2026-09-25	1.6900	1.3400	1.7000	28.0000	11634.00	4409.00	7225.00	69	22	69	1	69	0.332541216651369	0.329676910070505	true	false	false	true	false
45896d8a-834a-4c4a-be5d-dfd8c8e05e0a	2026-08-18 15:49	2026-08-18 15:49	2026-08-18 15:49	JD	JD260828C00030000	call	30.0000	2026-08-28	0.2100	0.1900	0.2200	28.0000	55651.00	42633.00	10290.00	2597	52	3566	601	5.93344425956739	0.332342722764043	0.339165670803277	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
71b9b495-0397-4c42-84c8-517d811a3827	2026-08-17 12:10	2026-08-17 12:10	2026-08-17 12:10	JD	JD260911P00028000	put	28.0000	2026-09-11	0.6200	0.6100	0.6500	28.5050	11278.00	8821.00	2457.00	181	12	183	54	3.38888888888889	0.298374566286265	0.30188915688941	true	false	false	true	false
dfe748b3-084e-4f5f-b5ef-faf902d1c0c6	2026-08-17 12:10	2026-08-17 12:10	2026-08-17 12:10	JD	JD261218C00032000	call	32.0000	2026-12-18	1.2100	1.1900	1.2300	28.4990	12784.00	12663.00	121.00	106	15	116	3012	0.0385126162018592	0.351070087211824	0.352711367918851	true	false	false	true	false
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	false
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	false
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	false
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