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 = TGT×

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

895b08df-c098-4548-ba27-093132673a92	2026-09-01 10:29	2026-09-01 10:29	2026-09-01 10:29	TGT	TGT261218P00165000	put	165.0000	2026-12-18	12.2500	11.9500	12.2500	164.0200	99225.00	99225.00	0.00	81	15	83	118	0.703389830508475	0.358838982509979	0.358838982509979	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	72096892003.00	2026-11-18	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
0502bfc3-021c-41a9-9877-52440211199c	2026-08-31 12:20	2026-08-31 12:19	2026-08-31 12:19	TGT	TGT261120P00160000	put	160.0000	2026-11-20	9.5000	9.5000	9.6500	161.3250	51300.00	0.00	51300.00	54	24	70	256	0.2734375	0.359602095237274	0.359602095237274	false	false	false	true	false
67bb7142-eff1-4ba1-88d9-54402dbcfdf3	2026-08-28 11:59	2026-08-28 11:59	2026-08-28 11:59	TGT	TGT260904C00167500	call	167.5000	2026-09-04	1.1500	1.0900	1.1500	164.0000	53935.00	53935.00	0.00	469	5	610	484	1.2603305785124	0.267901988524237	0.267901988524237	false	false	false	true	false
1dde3153-8003-4dd4-b822-e92c0f6a5e77	2026-08-28 11:45	2026-08-28 11:45	2026-08-28 11:45	TGT	TGT260911C00165000	call	165.0000	2026-09-11	3.0000	2.7000	3.0000	164.0000	59399.00	59100.00	299.00	198	36	231	284	0.813380281690141	0.262172670925177	0.262172670925177	true	false	false	true
dffc9fb3-aae3-4e23-9b7f-e10f193fec60	2026-08-28 09:51	2026-08-28 09:51	2026-08-28 09:51	TGT	TGT261120P00175000	put	175.0000	2026-11-20	17.6500	17.5500	18.2000	163.2000	51180.00	24770.00	26410.00	29	10	29	13	2.23076923076923	0.365774783385928	0.369084619465115	true	false	false	true
1c23cd79-0f95-4d6f-a709-b8f3ee40e3ae	2026-08-27 12:13	2026-08-27 12:13	2026-08-27 12:13	TGT	TGT261218P00160000	put	160.0000	2026-12-18	9.5000	9.5000	9.7500	165.5200	132050.00	0.00	132050.00	139	25	140	60	2.33333333333333	0.359143182270062	0.359143182270062	false	false	false	true	false
895fc6fa-f6f4-4207-82ba-a1d07df26a38	2026-08-27 10:31	2026-08-27 10:31	2026-08-27 10:31	TGT	TGT260918C00165000	call	165.0000	2026-09-18	5.4000	5.3000	5.6000	165.8900	153900.00	0.00	153900.00	285	29	523	2992	0.174799465240642	0.291832362046403	0.292871905371208	false	false	false	true
659f0206-09bc-4e62-96dc-86ecc7c6c604	2026-08-27 10:08	2026-08-27 10:08	2026-08-27 10:08	TGT	TGT260918C00177500	call	177.5000	2026-09-18	1.4900	1.3000	1.4900	166.9700	87761.00	87761.00	0.00	589	57	639	1522	0.419842312746386	0.29939933104539	0.297223311788091	true	false	false	true
defff502-cdee-4b34-80fc-77ac0dc2dcf7	2026-08-26 11:38	2026-08-26 11:38	2026-08-26 11:38	TGT	TGT260918C00167500	call	167.5000	2026-09-18	3.3500	3.0500	3.5000	163.9900	233802.00	233132.00	335.00	698	63	698	1508	0.462864721485411	0.287881008868722	0.286215293494377	false	false	false	true
ffe812d2-9507-4527-8a25-dad42d58bdca	2026-08-26 11:03	2026-08-26 11:03	2026-08-26 11:03	TGT	TGT261016C00165000	call	165.0000	2026-10-16	6.8500	6.6000	6.9000	163.4399	430162.00	408242.00	21920.00	628	63	704	1432	0.491620111731844	0.294447209073929	0.294447209073929	false	false	false	true
a015e22b-6f52-401b-a112-a20cf24244d6	2026-08-26 10:57	2026-08-26 10:57	2026-08-26 10:57	TGT	TGT260918P00165000	put	165.0000	2026-09-18	5.5000	5.3750	5.6000	162.8950	60500.00	550.00	59950.00	110	10	116	2116	0.054820415879017	0.280182078498933	0.280182078498933	true	false	false	true
29eeee37-a34d-4b45-a983-68032e679d51	2026-08-26 10:29	2026-08-26 10:29	2026-08-26 10:29	TGT	TGT261120C00165000	call	165.0000	2026-11-20	10.1000	10.1000	10.4500	162.4500	116161.00	0.00	116161.00	115	35	118	583	0.202401372212693	0.33686530534665	0.33686530534665	true	false	false	true
6915b4a6-1bde-48ac-9d1d-1fe484629777	2026-08-25 15:59	2026-08-25 15:59	2026-08-25 15:59	TGT	TGT260918P00165000	put	165.0000	2026-09-18	5.5500	5.5500	5.7000	163.2700	52170.00	0.00	52170.00	94	13	3372	1431	2.35639412997904	0.289987667826764	0.289987667826764	false	false	false	true	false
bdbfc3c2-d905-4cf4-8760-e6d334ac69f5	2026-08-25 15:54	2026-08-25 15:54	2026-08-25 15:54	TGT	TGT260918C00165000	call	165.0000	2026-09-18	4.4000	4.3000	4.5000	163.5427	115223.00	114343.00	880.00	262	38	1278	2352	0.543367346938776	0.291153252435785	0.292350067580744	false	false	false	true
08f4b6aa-7178-47a4-b6e1-62620800cf79	2026-08-25 15:46	2026-08-25 15:46	2026-08-25 15:46	TGT	TGT260918P00165000	put	165.0000	2026-09-18	5.5700	5.4500	5.7000	163.2400	166982.00	112396.00	54586.00	300	5	2906	1431	2.03074772886094	0.290235988876159	0.290235988876159	false	false	false	true
29e194ae-ae35-465e-9b8a-f89c4abb32b5	2026-08-25 15:35	2026-08-25 15:35	2026-08-25 15:35	TGT	TGT260918P00165000	put	165.0000	2026-09-18	5.5900	5.5000	5.6000	163.1200	152048.00	152048.00	0.00	272	5	1472	1431	1.02865129280224	0.287605128345724	0.287605128345724	false	false	false	true
58dd966d-12a0-4828-8d82-924bf2dbf951	2026-08-25 14:17	2026-08-25 14:17	2026-08-25 14:17	TGT	TGT281215P00160000	put	160.0000	2028-12-15	29.3000	29.3000	29.7500	163.0000	131850.00	0.00	131850.00	45	5	172	3	57.3333333333333	0.410819703009931	0.410819703009931	false	false	false	true	false
e90ba134-0ebf-4443-b985-3e1726a54ca3	2026-08-25 14:14	2026-08-25 14:14	2026-08-25 14:14	TGT	TGT281215P00160000	put	160.0000	2028-12-15	29.2500	29.2500	29.7500	163.0000	131625.00	0.00	131625.00	45	5	127	3	42.3333333333333	0.410141673611719	0.410141673611719	false	false	false	true	false
ac4b7ece-3ce9-4cdb-822e-f434d4cf36ea	2026-08-25 13:04	2026-08-25 13:04	2026-08-25 13:04	TGT	TGT261120C00180000	call	180.0000	2026-11-20	5.4500	5.4500	5.6000	163.5950	65400.00	0.00	65400.00	120	31	146	328	0.445121951219512	0.340879149223951	0.340879149223951	false	false	false	true
5e29da92-8834-47e5-b203-3595108d799f	2026-08-25 11:46	2026-08-25 11:46	2026-08-25 11:46	TGT	TGT281215P00160000	put	160.0000	2028-12-15	29.2500	29.2500	29.8500	163.4400	52650.00	0.00	52650.00	18	5	37	3	12.3333333333333	0.410388295520448	0.410388295520448	false	false	false	true	false
9384e862-b363-4229-a514-9cd35680a5f2	2026-08-25 11:22	2026-08-25 11:21	2026-08-25 11:21	TGT	TGT260828P00165000	put	165.0000	2026-08-28	2.3500	2.3500	2.4600	164.4050	80605.00	0.00	80605.00	343	9	1160	802	1.44638403990025	0.342942231733583	0.347029128295762	true	false	false	true	false
0b12f955-645c-4ee7-8edb-8223665ae5a7	2026-08-25 11:21	2026-08-25 11:20	2026-08-25 11:20	TGT	TGT261120C00160000	call	160.0000	2026-11-20	13.8900	13.0000	13.9000	164.1570	79180.00	77800.00	1380.00	57	15	63	785	0.0802547770700637	0.347135761242656	0.344262444962673	true	false	false	true
b9c493ff-1c9b-4e0e-b35e-5b6d7ec312a7	2026-08-25 11:17	2026-08-25 11:17	2026-08-25 11:17	TGT	TGT260918C00165000	call	165.0000	2026-09-18	4.6500	4.6500	4.7500	163.8450	186000.00	0.00	186000.00	400	7	530	2352	0.225340136054422	0.298503015621921	0.298503015621921	false	false	false	true
d35d7149-f87b-415e-81f8-9ef70bb23c0d	2026-08-25 09:31	2026-08-25 09:31	2026-08-25 09:31	TGT	TGT260904P00165000	put	165.0000	2026-09-04	3.2500	2.9600	3.2500	165.2530	63700.00	63700.00	0.00	196	8	213	256	0.83203125	0.31733453661318	0.31733453661318	true	false	false	true	false
af0fb78e-d865-46eb-acf2-d1d8f11c02aa	2026-08-24 15:10	2026-08-24 15:10	2026-08-24 15:10	TGT	TGT281215P00150000	put	150.0000	2028-12-15	22.8000	21.6500	23.3000	168.9200	114000.00	59280.00	15960.00	50	11	50	263	0.190114068441065	0.407546837248707	0.407546837248707	false	false	false	true
b4a8b2f6-3307-4311-8b13-c3ae1060c6cd	2026-08-24 13:02	2026-08-24 13:02	2026-08-24 13:02	TGT	TGT260925P00170000	put	170.0000	2026-09-25	5.9000	5.5000	5.9000	170.1800	64900.00	64900.00	0.00	110	6	206	0	0	0.312483322094685	0.312483322094685	false	false	false	true	false
f24b0a31-7caa-4392-9ef8-1b873b5e4acf	2026-08-24 12:29	2026-08-24 12:29	2026-08-24 12:29	TGT	TGT280121P00190000	put	190.0000	2028-01-21	37.7500	37.2000	38.4500	170.5000	135900.00	101925.00	33975.00	36	7	36	0	0	0.406714416041496	0.406714416041496	false	false	false	true	false
a63cebb1-3e72-45cf-a614-c9accbb19d10	2026-08-24 12:29	2026-08-24 12:28	2026-08-24 12:28	TGT	TGT280121P00170000	put	170.0000	2028-01-21	26.0500	25.6000	26.3000	170.5700	169325.00	127645.00	41680.00	65	9	76	65	1.16923076923077	0.399368653937421	0.399368653937421	false	false	false	true
9baf711d-251c-4006-8b69-81b2286c93d0	2026-08-24 10:45	2026-08-24 10:45	2026-08-24 10:45	TGT	TGT270617C00145000	call	145.0000	2027-06-17	36.9100	36.5500	37.0000	170.1200	62745.00	62745.00	0.00	17	6	20	129	0.155038759689922	0.327597046828666	0.327597046828666	false	false	false	true
b14dabe7-1600-4603-9abc-bc84ff9e25de	2026-08-24 10:15	2026-08-24 10:15	2026-08-24 10:15	TGT	TGT261218C00190000	call	190.0000	2026-12-18	6.2000	5.8000	6.2000	169.8700	240546.00	240546.00	0.00	388	56	412	659	0.625189681335357	0.329976211759582	0.329976211759582	false	false	false	true
cdf3391e-fb24-46aa-af86-3c3645f43726	2026-08-24 09:35	2026-08-24 09:35	2026-08-24 09:35	TGT	TGT261016C00165000	call	165.0000	2026-10-16	9.6500	9.4500	10.2500	167.7700	55970.00	0.00	55970.00	58	15	63	1427	0.0441485634197617	0.305887322691422	0.304292642329838	true	false	false	true
b7e554be-3e52-4da0-b7c8-99d7e93740cc	2026-08-24 09:30	2026-08-24 09:30	2026-08-24 09:30	TGT	TGT280121C00240000	call	240.0000	2028-01-21	9.1000	8.9000	9.9000	166.3681	91000.00	0.00	91000.00	100	7	100	4	25	0.326633679225997	0.326633679225997	false	false	false	true	false
1196e9cc-3983-437b-970c-a6913e513ff8	2026-08-21 15:52	2026-08-21 15:51	2026-08-21 15:51	TGT	TGT261016C00145000	call	145.0000	2026-10-16	22.4400	21.5500	23.1500	165.4100	157100.00	26928.00	127927.00	70	7	77	3489	0.0220693608483806	0.308778832132935	0.309569885136474	true	false	false	true
c61a439e-f1af-4a99-a172-6fc6a09c4697	2026-08-21 15:18	2026-08-21 15:18	2026-08-21 15:18	TGT	TGT261120C00165000	call	165.0000	2026-11-20	10.9500	10.5500	11.0000	164.0000	66785.00	4380.00	2180.00	61	7	271	410	0.660975609756098	0.327050395011776	0.327050395011776	false	false	false	true
a163cae7-e10b-4620-84a2-aa30f56cddf1	2026-08-21 15:03	2026-08-21 15:03	2026-08-21 15:03	TGT	TGT271217P00160000	put	160.0000	2027-12-17	22.6000	22.1500	22.6000	163.6100	79100.00	79100.00	0.00	35	5	96	1	96	0.395126117429106	0.395126117429106	false	false	false	true	false
e15763c4-f2b4-4629-b07e-e4bcdff6384f	2026-08-21 14:59	2026-08-21 14:59	2026-08-21 14:59	TGT	TGT281215P00150000	put	150.0000	2028-12-15	23.8000	23.8000	24.1000	163.6150	107100.00	0.00	107100.00	45	5	128	246	0.520325203252033	0.401370832207181	0.401370832207181	false	false	false	true
130165d4-eaf0-4b68-b6d8-bbd265d8fc14	2026-08-21 14:54	2026-08-21 14:54	2026-08-21 14:54	TGT	TGT281215P00150000	put	150.0000	2028-12-15	23.8000	23.8000	24.1000	163.5925	107100.00	0.00	107100.00	45	5	78	246	0.317073170731707	0.401296834818377	0.401296834818377	false	false	false	true
527a6134-e9cb-49bf-bf2d-135a40d67713	2026-08-21 14:40	2026-08-21 14:40	2026-08-21 14:40	TGT	TGT260918C00165000	call	165.0000	2026-09-18	4.4500	4.3500	4.5500	163.3200	51175.00	41385.00	9790.00	115	5	746	1453	0.513420509291122	0.277620407043037	0.277620407043037	false	false	false	true
6e9821d3-243d-4c50-8b2d-2d4b03583add	2026-08-21 14:36	2026-08-21 14:36	2026-08-21 14:36	TGT	TGT260918C00165000	call	165.0000	2026-09-18	4.4000	4.3000	4.4750	163.3300	56760.00	56760.00	0.00	129	5	616	1453	0.42395044735031	0.274580403655426	0.274580403655426	true	false	false	true
a80dda39-b3c3-4b63-89b4-15155ec4a6fc	2026-08-21 14:13	2026-08-21 14:13	2026-08-21 14:13	TGT	TGT260911P00167500	put	167.5000	2026-09-11	6.6000	6.3000	6.9000	163.0000	216490.00	215820.00	670.00	328	42	338	0	0	0.278855408178669	0.275416780455061	true	false	false	true	false
3401011d-c631-42bb-bd84-c51f47342810	2026-08-21 11:24	2026-08-21 11:24	2026-08-21 11:24	TGT	TGT260925C00165000	call	165.0000	2026-09-25	5.5000	5.2000	6.1500	163.7750	55540.00	540.00	55000.00	101	10	103	36	2.86111111111111	0.286604387522111	0.281661794445986	true	false	false	true
63462dd6-e66a-4f1f-ac88-f9ab367d491c	2026-08-21 10:54	2026-08-21 10:54	2026-08-21 10:54	TGT	TGT261120P00170000	put	170.0000	2026-11-20	14.0600	14.0500	15.1000	163.5000	63273.00	0.00	63273.00	45	5	530	0	0	0.347616939525308	0.347616939525308	false	false	false	true	false
be34f1e4-430f-449f-a9a2-285226add9b6	2026-08-21 10:30	2026-08-21 10:30	2026-08-21 10:30	TGT	TGT261120P00170000	put	170.0000	2026-11-20	15.1000	14.8000	15.1000	162.4600	77000.00	77000.00	0.00	51	6	279	0	0	0.361561623332247	0.362183199662453	false	false	false	true	false
c041e79a-220d-4931-9139-9881ad16a6f3	2026-08-21 10:29	2026-08-21 10:29	2026-08-21 10:29	TGT	TGT261120P00170000	put	170.0000	2026-11-20	14.9500	14.5500	14.9500	162.5850	61295.00	61295.00	0.00	41	5	163	0	0	0.359628870842132	0.359628870842132	false	false	false	true	false
fc593b43-018c-4513-81de-dddcd929ffc6	2026-08-20 15:11	2026-08-20 15:11	2026-08-20 15:11	TGT	TGT270617P00165000	put	165.0000	2027-06-17	21.9000	21.5500	22.8000	159.4200	54750.00	30660.00	24090.00	25	5	152	81	1.87654320987654	0.378820147245982	0.378820147245982	false	false	false	true
27c17103-d063-41c2-af4d-cb1db860dcc8	2026-08-20 13:03	2026-08-20 13:03	2026-08-20 13:03	TGT	TGT261120P00160000	put	160.0000	2026-11-20	10.4900	10.3000	10.6500	159.9458	52470.00	52470.00	0.00	50	6	77	122	0.631147540983607	0.352839224272727	0.352839224272727	false	false	false	true	false
b8efdc5f-51c1-4790-9f1c-fa095be09f62	2026-08-20 10:48	2026-08-20 10:47	2026-08-20 10:47	TGT	TGT260828P00157500	put	157.5000	2026-08-28	2.3600	2.0300	2.3600	158.7900	51681.00	50976.00	705.00	219	44	346	335	1.03283582089552	0.323173258731912	0.323173258731912	false	false	false	true
3726669d-14c9-4ce5-bf63-d41e16aea6f0	2026-08-19 15:54	2026-08-19 15:54	2026-08-19 15:54	TGT	TGT260821C00162500	call	162.5000	2026-08-21	0.8800	0.8400	0.9900	159.7150	98915.00	355.00	98560.00	1124	53	2474	1459	1.69568197395476	0.411079884339422	0.411079884339422	false	false	false	true
9fded0ac-5e13-4003-85b5-e19914c9881d	2026-08-19 13:47	2026-08-19 13:47	2026-08-19 13:47	TGT	TGT261120C00160000	call	160.0000	2026-11-20	12.4000	12.4000	12.7500	161.5400	212040.00	0.00	212040.00	171	30	209	433	0.482678983833718	0.334753817319069	0.334753817319069	false	false	false	true
48ea69c9-dee4-452e-b8f0-9e72f816ea7a	2026-08-19 12:38	2026-08-19 12:38	2026-08-19 12:38	TGT	TGT270115C00200000	call	200.0000	2027-01-15	3.0000	3.0000	3.2000	160.4200	60000.00	0.00	49200.00	200	8	214	1295	0.165250965250965	0.31937105260921	0.31937105260921	false	false	false	true