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:ticker = SN×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	pricenumeric

e9c8934e-1f3b-4bd8-ba1b-f98d5086d8c2	2026-08-20 09:33	2026-08-20 09:33	2026-08-20 09:33	SN	SN260821C00165000	call	165.0000	2026-08-21	13.6000	12.5000	16.0000	178.5000	10880.00	0.00	10880.00	8	5	8	64	0.125	0.799074223340314	0.799074223340314	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	23894632650.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a1026508-cacb-4592-b38e-407cf4bfa8c8	2026-08-20 12:13	2026-08-20 12:13	2026-08-20 12:13	SN	SN261016C00185000	call	185.0000	2026-10-16	8.5000	8.5000	9.3000	178.3600	11900.00	0.00	11900.00	14	8	14	0	0	0.387397411087239	0.387397411087239	false	false	false	true	false
45606bad-6edf-4e84-9898-2400460861c9	2026-08-25 13:26	2026-08-25 13:26	2026-08-25 13:26	SN	SN260918P00190000	put	190.0000	2026-09-18	10.8000	10.2000	10.8000	182.9700	138240.00	138240.00	0.00	128	30	129	920	0.140217391304348	0.369727281158971	0.369727281158971	false	false	false	true	false
fb9d747d-b568-4a6e-9aaf-b5c332fd305f	2026-08-26 10:33	2026-08-26 10:32	2026-08-26 10:32	SN	SN260918P00180000	put	180.0000	2026-09-18	3.8600	3.1000	4.0000	188.8757	383298.00	383298.00	0.00	993	3	1333	383	3.48041775456919	0.413657963711985	0.413657963711985	false	true	true	false	true
06427671-71ef-4cf2-9ef7-6639a5dc07a8	2026-08-26 11:11	2026-08-26 11:11	2026-08-26 11:11	SN	SN260918P00190000	put	190.0000	2026-09-18	7.6000	6.9000	7.6000	188.3500	264473.00	264473.00	0.00	348	45	348	1045	0.333014354066986	0.379830863850588	0.369293135513356	false	false	false	true	false
932e24b1-fc69-47c3-8d86-96d62094d7bb	2026-08-27 13:14	2026-08-27 13:14	2026-08-27 13:14	SN	SN270115C00210000	call	210.0000	2027-01-15	14.1200	13.8000	14.5000	191.3600	22588.00	0.00	22588.00	16	8	19	9	2.11111111111111	0.425653422342177	0.425653422342177	false	false	false	true	false
0a71a409-afbd-4ff9-ad54-781ffac058aa	2026-08-27 14:21	2026-08-27 14:21	2026-08-27 14:21	SN	SN261016C00190000	call	190.0000	2026-10-16	12.2000	12.2000	12.7000	191.5900	128110.00	0.00	128110.00	105	21	109	53	2.05660377358491	0.390523314592517	0.386939337707096	false	false	false	true	false
d803ad03-c3c6-464c-9970-008e55e97f0f	2026-08-28 10:51	2026-08-28 10:50	2026-08-28 10:50	SN	SN261016C00195000	call	195.0000	2026-10-16	11.0000	11.0000	11.5000	194.5300	132030.00	3330.00	128700.00	120	30	142	38	3.73684210526316	0.378363969166686	0.378363969166686	false	false	false	true	false
cfc798b1-4c5e-472d-9e15-f9900dd564f5	2026-08-28 12:18	2026-08-28 12:18	2026-08-28 12:18	SN	SN260918C00195000	call	195.0000	2026-09-18	5.9000	5.9000	6.2000	192.7800	223020.00	0.00	223020.00	378	16	600	1503	0.399201596806387	0.355581399566116	0.364799319790647	false	false	false	true	false
69b62931-f289-4bdc-9209-13a9ad1a1831	2026-08-28 12:26	2026-08-28 12:25	2026-08-28 12:25	SN	SN270319P00190000	put	190.0000	2027-03-19	21.8800	20.3000	23.2000	192.2700	218800.00	32700.00	186100.00	100	6	100	1	100	0.445039892932544	0.447940468382012	false	false	false	true	false
628f4485-ce2d-45d3-b8cb-6aaa2180f725	2026-09-01 14:19	2026-09-01 14:19	2026-09-01 14:19	SN	SN260918C00185000	call	185.0000	2026-09-18	2.9000	2.4500	2.9000	176.4650	24360.00	24360.00	0.00	84	32	99	53	1.86792452830189	0.395853164186156	0.395853164186156	false	false	false	true	false
a4a6887d-7c57-4a5d-9152-de954a734dee	2026-09-02 10:27	2026-09-02 10:27	2026-09-02 10:27	SN	SN270319C00150000	call	150.0000	2027-03-19	36.5200	36.5000	38.6000	173.2225	21910.00	3660.00	10950.00	6	5	6	6	1	0.439731753929617	0.439731753929617	false	false	false	true	false
bc500ad5-d94d-4e63-8605-c413c28d083f	2026-09-08 10:29	2026-09-08 10:29	2026-09-08 10:29	SN	SN261016P00190000	put	190.0000	2026-10-16	15.8000	14.9000	15.9000	179.5300	180115.00	180115.00	0.00	114	22	114	20	5.7	0.431323092499084	0.431323092499084	false	false	false	true	false
9e38a987-ce25-4023-ad0b-59b532d092d7	2026-09-08 12:32	2026-09-08 12:32	2026-09-08 12:32	SN	SN261016P00190000	put	190.0000	2026-10-16	15.4900	15.0000	15.5000	179.6550	110010.00	110010.00	0.00	71	7	185	20	9.25	0.421233137111717	0.421233137111717	false	false	false	true	false
c119ac8d-f1b4-452c-b958-ed01e6c58b57	2026-09-09 12:22	2026-09-09 12:22	2026-09-09 12:22	SN	SN261218P00165000	put	165.0000	2026-12-18	13.4000	12.7000	13.6000	169.5400	174200.00	172860.00	1340.00	130	24	180	11	16.3636363636364	0.472714238025736	0.472714238025736	false	false	false	true	false
8ba6a55a-b9f8-4e2a-a0e6-3e9a782fbf82	2026-09-09 12:36	2026-09-09 12:36	2026-09-09 12:36	SN	SN261218P00165000	put	165.0000	2026-12-18	13.5000	13.5000	13.5000	169.6900	33750.00	0.00	0.00	25	5	216	11	19.6363636363636	0.477367253616114	0.477367253616114	false	false	false	true	false
4b55b794-d158-4c5e-8abe-720a3d3d1afd	2026-09-10 09:45	2026-09-10 09:45	2026-09-10 09:45	SN	SN261218P00165000	put	165.0000	2026-12-18	15.0000	14.1000	15.0000	165.9300	129000.00	109500.00	0.00	86	9	86	282	0.304964539007092	0.47625099272871	0.47625099272871	false	false	false	true	false
98e25a4b-e8ac-4523-946d-5cb326a6fb57	2026-09-10 10:21	2026-09-10 10:21	2026-09-10 10:21	SN	SN261016C00175000	call	175.0000	2026-10-16	6.2000	6.2000	6.7000	167.9450	39061.00	0.00	39061.00	63	24	63	17	3.70588235294118	0.422284326863221	0.422284326863221	false	false	false	true	false
df925d49-3104-4fd2-9c6c-cc068a92fdf8	2026-09-11 09:36	2026-09-11 09:36	2026-09-11 09:36	SN	SN261016P00165000	put	165.0000	2026-10-16	8.2000	7.4000	10.3000	165.0000	59040.00	41000.00	9020.00	72	7	74	143	0.517482517482518	0.421343052929815	0.421343052929815	false	false	false	true	false
91433948-93c8-4052-90e7-39294a909837	2026-09-11 10:06	2026-09-11 10:05	2026-09-11 10:05	SN	SN261016P00145000	put	145.0000	2026-10-16	2.4000	1.9500	2.4000	161.5900	29760.00	29760.00	0.00	124	32	124	3	41.3333333333333	0.440160462788346	0.440160462788346	false	false	false	true	false
df7e886a-9271-4865-9469-7e63f8e59998	2026-09-11 11:01	2026-09-11 11:01	2026-09-11 11:01	SN	SN260918P00155000	put	155.0000	2026-09-18	2.0000	1.7000	2.0500	159.8500	34400.00	33400.00	0.00	172	10	312	4278	0.0729312762973352	0.460486522799147	0.460486522799147	true	false	false	true	false
db6a39c0-74df-4480-8134-3a11cbc43477	2026-09-11 11:01	2026-09-11 11:01	2026-09-11 11:01	SN	SN260918P00155000	put	155.0000	2026-09-18	2.0000	1.7500	2.0000	159.9300	11400.00	11400.00	0.00	57	17	136	4278	0.0317905563347359	0.463594558687698	0.463594558687698	false	false	false	true	false
43f1360a-1383-4831-ac7a-0ee69b911e0c	2026-09-11 11:04	2026-09-11 11:04	2026-09-11 11:04	SN	SN261016P00155000	put	155.0000	2026-10-16	6.1000	5.6000	6.1000	159.1700	30500.00	30500.00	0.00	50	17	52	282	0.184397163120567	0.427043450837071	0.427043450837071	true	false	false	true	false
7e326795-0711-430c-8a50-0dd34256f301	2026-09-11 11:47	2026-09-11 11:47	2026-09-11 11:47	SN	SN261016P00155000	put	155.0000	2026-10-16	6.4000	5.9000	6.4000	159.2450	96638.00	96638.00	0.00	151	40	208	282	0.737588652482269	0.444502452631161	0.444502452631161	false	false	false	true	false
c3cad06b-aa27-47a7-8483-515f59e2c296	2026-09-11 12:09	2026-09-11 12:09	2026-09-11 12:09	SN	SN260918C00160000	call	160.0000	2026-09-18	3.8000	3.8000	4.2000	159.7550	14440.00	0.00	4940.00	38	11	38	17	2.23529411764706	0.437487226659986	0.437487226659986	false	false	false	true	false
b957406d-811d-4e33-873c-9cfe592bafe2	2026-09-14 11:06	2026-09-14 11:06	2026-09-14 11:06	SN	SN270115C00160000	call	160.0000	2027-01-15	22.5000	21.3000	22.5000	165.9800	110250.00	110250.00	0.00	49	22	59	34	1.73529411764706	0.484836182502637	0.484836182502637	false	false	false	true	false
6c4a0eaf-373c-4bf7-9b01-2ff40b73f9e5	2026-09-14 14:41	2026-09-14 14:41	2026-09-14 14:41	SN	SN260918C00175000	call	175.0000	2026-09-18	1.8000	1.7500	1.9500	169.1700	54000.00	180.00	53820.00	300	26	377	462	0.816017316017316	0.562728825339682	0.562728825339682	false	false	false	true	false
b6d734da-64e3-4ee4-bdb7-ea87ba2086d1	2026-09-14 15:26	2026-09-14 15:26	2026-09-14 15:26	SN	SN270115C00170000	call	170.0000	2027-01-15	19.0000	18.0000	19.0000	168.8400	127300.00	127300.00	0.00	67	21	67	23	2.91304347826087	0.473769263190348	0.473769263190348	false	false	false	true	false
4e7e3f49-2e6f-4d55-99c2-66ebbe76d7f2	2026-09-15 09:49	2026-09-15 09:49	2026-09-15 09:49	SN	SN260918C00165000	call	165.0000	2026-09-18	5.5000	5.3000	5.5000	168.2650	31350.00	550.00	0.00	57	18	70	2127	0.0329102021626704	0.597538048347256	0.597538048347256	false	false	false	true	false
9f4c18c4-85ee-4d6d-8e27-1b1594f824e8	2026-09-15 10:59	2026-09-15 10:59	2026-09-15 10:59	SN	SN270115C00185000	call	185.0000	2027-01-15	11.2000	10.3000	11.2000	164.0000	192640.00	192640.00	0.00	172	34	173	100	1.73	0.470598265136976	0.470598265136976	false	false	false	true	false
4ba5c0e1-4422-4904-912a-f1193e53f6d7	2026-09-15 11:32	2026-09-15 11:32	2026-09-15 11:32	SN	SN270115C00175000	call	175.0000	2027-01-15	15.5000	15.0000	15.5000	166.0300	575050.00	575050.00	0.00	371	52	373	24	15.5416666666667	0.477598809983249	0.477598809983249	false	false	false	true	false
36b50065-814f-4027-9afd-f252ac20e114	2026-09-15 12:24	2026-09-15 12:24	2026-09-15 12:24	SN	SN261218C00180000	call	180.0000	2026-12-18	12.0000	11.0000	12.0000	167.0000	10800.00	9600.00	0.00	9	5	15	281	0.0533807829181495	0.480467666730216	0.480467666730216	false	false	false	true	false
031ccf29-0516-4f24-880a-f618cfc4f11a	2026-09-15 12:25	2026-09-15 12:24	2026-09-15 12:24	SN	SN261218C00180000	call	180.0000	2026-12-18	12.0000	11.0000	12.0000	167.0000	10800.00	4800.00	0.00	9	5	24	281	0.0854092526690391	0.480467666730216	0.480467666730216	false	false	false	true	false
3c915590-37a2-460a-9195-f99199a75d59	2026-09-15 12:25	2026-09-15 12:25	2026-09-15 12:25	SN	SN261218C00180000	call	180.0000	2026-12-18	12.0000	11.0000	12.4000	167.0000	13200.00	4800.00	2400.00	11	5	35	281	0.124555160142349	0.481401282228902	0.481401282228902	false	false	false	true	false
41d8889d-aeec-4f30-aa8f-ca2dbff42374	2026-09-16 09:58	2026-09-16 09:58	2026-09-16 09:58	SN	SN260918C00170000	call	170.0000	2026-09-18	3.3000	2.7000	3.3000	171.1550	18480.00	18480.00	0.00	56	19	57	3124	0.0182458386683739	0.528519591977872	0.528519591977872	false	false	false	true	false
b0f82fdc-557e-4f15-977a-8a2961e2257a	2026-09-16 11:59	2026-09-16 11:59	2026-09-16 11:59	SN	SN261016P00170000	put	170.0000	2026-10-16	7.4000	7.4000	8.4000	173.2300	38480.00	0.00	38480.00	52	8	56	194	0.288659793814433	0.468071495398801	0.468071495398801	false	false	false	true	false
fbd7ea68-bb2e-4f5c-9c90-6068a0f81f58	2026-09-16 15:24	2026-09-16 15:24	2026-09-16 15:24	SN	SN260918C00170000	call	170.0000	2026-09-18	2.4000	2.4000	3.1000	169.3100	714000.00	0.00	714000.00	2975	1	3078	3124	0.985275288092189	0.541840567448305	0.541840567448305	false	true	false	true	false
b85900d9-948e-4a78-9a8e-5e1ec78f6bbd	2026-09-16 15:49	2026-09-16 15:49	2026-09-16 15:49	SN	SN270115C00175000	call	175.0000	2027-01-15	18.3700	17.6000	18.4000	170.0000	12860.00	12860.00	0.00	7	6	7	378	0.0185185185185185	0.490765746243254	0.490765746243254	false	false	false	true	false
b900bddd-c27e-43a0-b02c-7a2bff710bf2	2026-09-17 11:01	2026-09-17 11:01	2026-09-17 11:01	SN	SN261218C00180000	call	180.0000	2026-12-18	12.0100	10.7000	12.4000	167.2600	48040.00	44430.00	2400.00	40	15	40	382	0.104712041884817	0.49198718402278	0.488976188349235	false	false	false	true	false
5ba2d2f3-b11a-4aa1-a9e8-1d57b4c54694	2026-09-17 14:43	2026-09-17 14:42	2026-09-17 14:42	SN	SN260918P00190000	put	190.0000	2026-09-18	21.1000	21.1000	23.5000	167.7000	270080.00	0.00	270080.00	128	2	128	1310	0.0977099236641221	2.08236158583566	2.08236158583566	false	true	true	false	false
4e1b8874-8ede-4be3-af88-e024584e1d65	2026-09-18 14:12	2026-09-18 14:12	2026-09-18 14:12	SN	SN261016P00175000	put	175.0000	2026-10-16	13.8000	13.8000	14.2000	164.6900	190440.00	0.00	190440.00	138	33	139	318	0.437106918238994	0.426018521571094	0.426018521571094	false	false	false	true	false
20ccac77-0d0a-451d-8764-97d3bd1b2d54	2026-09-21 10:20	2026-09-21 10:20	2026-09-21 10:20	SN	SN261016C00165000	call	165.0000	2026-10-16	9.9900	9.9000	10.0000	168.3550	41960.00	34000.00	0.00	42	27	639	21	30.4285714285714	0.457983173782886	0.457983173782886	false	false	false	true	false
b2063783-ee93-4154-8af7-25034a282a50	2026-09-21 15:02	2026-09-21 15:01	2026-09-21 15:01	SN	SN261016C00165000	call	165.0000	2026-10-16	9.3000	9.3000	9.7000	167.0000	46500.00	0.00	46500.00	50	8	919	21	43.7619047619048	0.435941157927142	0.435941157927142	false	false	false	true	false
e63ccc54-ca04-4554-b900-71bbdd2b1432	2026-09-22 09:43	2026-09-22 09:43	2026-09-22 09:43	SN	SN261016C00170000	call	170.0000	2026-10-16	8.4100	8.4000	8.5000	170.0000	30265.00	0.00	26040.00	36	17	226	240	0.941666666666667	0.442052901732208	0.442052901732208	false	false	false	true	false
2d8ce3e8-8547-48f0-8fdb-f63f2c65f10f	2026-09-22 09:45	2026-09-22 09:45	2026-09-22 09:45	SN	SN261016C00170000	call	170.0000	2026-10-16	8.4200	8.3000	8.7000	170.0000	15995.00	0.00	15995.00	19	10	311	240	1.29583333333333	0.440304231305244	0.440304231305244	false	false	false	true	false