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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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 = 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

d486f76a-806a-43d3-811e-7a9a4e49dfa8	2026-09-04 13:47	2026-09-04 13:47	2026-09-04 13:47	TGT	TGT261120C00150000	call	150.0000	2026-11-20	19.6000	18.8500	19.8500	164.5150	50960.00	23520.00	15680.00	26	6	30	874	0.034324942791762	0.341368291192348	0.341368291192348	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-04T18:01:17.201510Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
962969d4-c8d0-4e31-9c44-3af0dd5cf5ed	2026-09-04 12:03	2026-09-04 12:03	2026-09-04 12:03	TGT	TGT261218P00165000	put	165.0000	2026-12-18	12.0000	12.0000	12.3000	164.0400	189600.00	0.00	189600.00	158	28	184	202	0.910891089108911	0.356417621542836	0.356417621542836	false	false	false	true
33b45cf8-2c33-4d7e-b3eb-c558ac13c5a2	2026-09-03 14:20	2026-09-03 14:20	2026-09-03 14:20	TGT	TGT270115C00155000	call	155.0000	2027-01-15	19.0500	19.0500	19.6500	164.3500	93345.00	0.00	93345.00	49	13	55	2268	0.0242504409171076	0.327668707579218	0.327668707579218	false	false	false	true
2d93aaac-efd6-450e-8527-67d13a473855	2026-09-03 10:56	2026-09-03 10:55	2026-09-03 10:55	TGT	TGT261218P00170000	put	170.0000	2026-12-18	14.8500	14.8500	15.1000	164.0700	74250.00	0.00	74250.00	50	5	643	36	17.8611111111111	0.358406547540474	0.358406547540474	false	false	false	true
1873cae8-4fc8-42c2-aab8-a5d61ba88a23	2026-09-02 15:57	2026-09-02 15:57	2026-09-02 15:57	TGT	TGT261218P00175000	put	175.0000	2026-12-18	18.7000	18.3500	18.7000	163.4700	56100.00	56100.00	0.00	30	7	358	30	11.9333333333333	0.369907217369931	0.369907217369931	false	false	false	true
d88f0935-d2f4-450d-862b-7ae7a22b1830	2026-09-02 13:32	2026-09-02 13:32	2026-09-02 13:32	TGT	TGT261218P00175000	put	175.0000	2026-12-18	18.0500	17.8500	18.0500	164.5550	55955.00	55955.00	0.00	31	6	241	30	8.03333333333333	0.368877824926705	0.368877824926705	false	false	false	true
32068b5f-ed91-4232-86e0-f0a6c33bc74a	2026-09-01 15:34	2026-09-01 15:34	2026-09-01 15:34	TGT	TGT270617P00140000	put	140.0000	2027-06-17	9.7000	9.7000	10.2000	162.7750	90210.00	0.00	90210.00	93	11	189	436	0.43348623853211	0.390889415343116	0.390889415343116	false	false	false	true
5ad0a4e4-2507-40b0-b081-6eb07a17cea4	2026-09-01 12:27	2026-09-01 12:27	2026-09-01 12:27	TGT	TGT261016C00160000	call	160.0000	2026-10-16	8.8500	8.7500	8.8500	163.0050	69030.00	69030.00	0.00	78	7	93	1805	0.0515235457063712	0.301455660368568	0.301455660368568	false	false	false	true
20968266-71dd-4a0f-b830-e3552dadc289	2026-09-01 12:27	2026-09-01 12:27	2026-09-01 12:27	TGT	TGT270917C00170000	call	170.0000	2027-09-17	22.4500	21.6000	23.4500	163.0500	166130.00	127965.00	38165.00	74	19	74	375	0.197333333333333	0.336273156754425	0.335660586478571	false	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
dbb928a0-1e7b-4cfe-b9c2-6efba8972ee3	2026-08-19 11:33	2026-08-19 11:33	2026-08-19 11:33	TGT	TGT260918C00175000	call	175.0000	2026-09-18	1.2600	1.2600	1.4600	160.4801	50274.00	0.00	252.00	399	48	562	901	0.623751387347392	0.299492118654266	0.299492118654266	true	false	false	true
ac71af8e-85f0-4c96-b5e7-d64c11202394	2026-08-19 11:07	2026-08-19 11:07	2026-08-19 11:07	TGT	TGT260918C00155000	call	155.0000	2026-09-18	9.0000	8.8000	9.1500	160.3500	63000.00	36000.00	0.00	70	5	246	4003	0.0614539095678241	0.311643672431131	0.311643672431131	false	false	false	true
3a7f8584-efc5-4042-a547-0bb6e44fbfcd	2026-08-19 09:56	2026-08-19 09:56	2026-08-19 09:56	TGT	TGT260918C00165000	call	165.0000	2026-09-18	3.8000	3.5500	3.8000	160.1500	60420.00	29260.00	0.00	159	35	311	1535	0.202605863192182	0.307618612160033	0.307618612160033	true	false	false	true
bdde2058-0dae-415c-b0db-f5affbd86c36	2026-08-19 09:49	2026-08-19 09:49	2026-08-19 09:49	TGT	TGT261120C00140000	call	140.0000	2026-11-20	24.5500	22.9000	25.7500	160.6000	66285.00	24550.00	41735.00	27	7	28	269	0.104089219330855	0.330269038095973	0.330269038095973	false	false	false	true
a7dc3c0a-5149-4b87-89ce-d7e660bba113	2026-08-19 09:31	2026-08-19 09:31	2026-08-19 09:31	TGT	TGT260918C00150000	call	150.0000	2026-09-18	7.5600	5.0500	8.4500	153.2500	60470.00	60470.00	0.00	80	7	88	3312	0.0265700483091787	0.357222521925975	0.344302480552146	true	false	false	true