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 = LITE×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	price

c120744f-1325-45db-87ab-a05c5c0db027	2026-09-01 11:23	2026-09-01 11:23	2026-09-01 11:23	LITE	LITE270319P00670000	put	670.0000	2027-03-19	84.8000	84.8000	91.6000	866.4150	101760.00	0.00	101760.00	12	6	12	70	0.171428571428571	0.769070669595102	0.769070669595102	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	74902191000.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-01T15:45:30.323966Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
bc2d915e-e5de-4806-8374-37e0661229b3	2026-09-01 11:41	2026-09-01 11:40	2026-09-01 11:40	LITE	LITE260904C00930000	call	930.0000	2026-09-04	6.0000	5.9000	6.3000	869.0500	154800.00	151200.00	3600.00	258	13	876	389	2.25192802056555	0.790722013741628	0.790984686480522	false	false	false	true	false
456e59ae-9dba-464f-8aa0-83019b6c6d9b	2026-09-01 11:41	2026-09-01 11:40	2026-09-01 11:40	LITE	LITE260904C00930000	call	930.0000	2026-09-04	6.0000	5.9000	6.3000	868.6900	79200.00	75000.00	4200.00	132	9	609	389	1.56555269922879	0.794135718506555	0.794135718506555	false	false	false	true	false
a229c674-15c8-4de8-822f-4340ef835a28	2026-09-01 11:52	2026-09-01 11:51	2026-09-01 11:51	LITE	LITE260911P00980000	put	980.0000	2026-09-11	114.0000	106.9000	114.0000	874.0457	239400.00	239400.00	0.00	21	7	21	10	2.1	0.693893359500657	0.693893359500657	false	false	false	true	false
6422fa6f-313e-4425-a88b-983fb8684179	2026-09-01 12:04	2026-09-01 12:03	2026-09-01 12:03	LITE	LITE260918C00850000	call	850.0000	2026-09-18	61.4300	60.6000	61.5000	868.3500	98290.00	98290.00	0.00	16	9	616	391	1.57544757033248	0.688850703400438	0.690224051459085	false	false	false	true	false
a8d1fa44-e6c4-423b-add8-82512265d9ac	2026-09-01 12:34	2026-09-01 12:34	2026-09-01 12:34	LITE	LITE260904P00875000	put	875.0000	2026-09-04	32.5000	32.5000	34.0000	860.3900	113750.00	0.00	113750.00	35	16	60	140	0.428571428571429	0.786430870400114	0.786430870400114	false	false	false	true	false
d7c1abb5-2ce3-4034-8370-e72b98fcf255	2026-09-01 12:35	2026-09-01 12:34	2026-09-01 12:34	LITE	LITE260918C00920000	call	920.0000	2026-09-18	29.2000	29.2000	30.0000	861.2550	93440.00	0.00	93440.00	32	12	60	202	0.297029702970297	0.691794154144023	0.691794154144023	true	false	false	true	false
afa3d59e-be06-4928-9113-b505c1ba25cb	2026-09-01 13:13	2026-09-01 13:13	2026-09-01 13:13	LITE	LITE281215P00320000	put	320.0000	2028-12-15	56.0000	56.0000	58.0000	863.2600	330400.00	0.00	140000.00	59	36	59	509	0.115913555992141	0.799239305372992	0.799239305372992	false	false	false	true	false
a84f8bb2-1b02-4303-9e6b-a48957ded80c	2026-09-01 13:56	2026-09-01 13:56	2026-09-01 13:56	LITE	LITE260918P00900000	put	900.0000	2026-09-18	70.1200	69.5000	70.1000	863.8600	63110.00	42080.00	0.00	9	9	38	359	0.105849582172702	0.672519741469869	0.673890699254241	false	false	false	true	false
49c54156-1720-4aa2-bcba-0a02194bd7e3	2026-09-01 13:56	2026-09-01 13:56	2026-09-01 13:56	LITE	LITE260918P00900000	put	900.0000	2026-09-18	69.9600	69.5000	70.0000	863.8600	83950.00	76950.00	0.00	12	12	50	359	0.139275766016713	0.669777256299843	0.671148594263948	false	false	false	true	false
3a791bce-1c4b-41f7-be8d-b5070bd44233	2026-09-01 13:56	2026-09-01 13:56	2026-09-01 13:56	LITE	LITE260918P00900000	put	900.0000	2026-09-18	69.8000	69.4000	69.8000	863.8600	125640.00	48860.00	0.00	18	18	69	359	0.192200557103064	0.668405726229354	0.668405726229354	false	false	false	true	false
ab3d9011-c86f-4ebc-8c54-393ef58a37e6	2026-09-01 13:56	2026-09-01 13:56	2026-09-01 13:56	LITE	LITE260918P00940000	put	940.0000	2026-09-18	97.2900	97.2000	97.8000	864.1100	165400.00	19460.00	19440.00	17	17	45	280	0.160714285714286	0.669131636944036	0.670653076215702	false	false	false	true	false
31205749-951e-45ef-a59e-14b03bc788f8	2026-09-01 13:56	2026-09-01 13:56	2026-09-01 13:56	LITE	LITE260918P00940000	put	940.0000	2026-09-18	97.3300	95.9000	98.4000	864.1400	233600.00	165520.00	29190.00	24	24	28	280	0.1	0.669447030053365	0.674006676162322	false	false	false	true	false
c03fc260-a628-4a77-b17a-4fd4a049aa5d	2026-09-01 14:12	2026-09-01 14:12	2026-09-01 14:12	LITE	LITE280915P00440000	put	440.0000	2028-09-15	89.3600	86.2000	93.1000	869.3840	205530.00	116480.00	89050.00	23	5	26	20	1.3	0.775972337013182	0.775972337013182	false	false	false	true	false
89c0ae51-f953-4a54-9225-a8d0cbcfa1f9	2026-09-01 14:12	2026-09-01 14:12	2026-09-01 14:12	LITE	LITE280915P00450000	put	450.0000	2028-09-15	93.5000	88.6000	96.3000	869.3840	280510.00	280510.00	0.00	30	7	46	6	7.66666666666667	0.774214920616012	0.775481114854841	false	false	false	true	false
1d8cbc23-3f01-4c0e-a37c-e336ee9d1ffd	2026-09-01 14:34	2026-09-01 14:33	2026-09-01 14:33	LITE	LITE270115P00860000	put	860.0000	2027-01-15	143.2000	139.5000	144.5000	867.4300	630080.00	529840.00	100240.00	44	9	52	38	1.36842105263158	0.735946294882969	0.735946294882969	false	false	false	true	false
65006f46-fd83-4a1f-904a-50e1677d5642	2026-09-01 14:45	2026-09-01 14:45	2026-09-01 14:45	LITE	LITE260918C00850000	call	850.0000	2026-09-18	58.0000	56.8000	58.1000	861.8300	348010.00	348010.00	0.00	60	5	1356	391	3.46803069053708	0.694986061032539	0.695537160028568	false	false	false	true	false
ca4ea7c2-2326-4d79-af3a-dc5fe3ae9525	2026-09-01 14:46	2026-09-01 14:46	2026-09-01 14:46	LITE	LITE260918C00850000	call	850.0000	2026-09-18	58.4200	57.8000	58.6000	862.2200	356350.00	356350.00	0.00	61	5	1489	391	3.80818414322251	0.69694698878874	0.697962443256046	false	false	false	true	false
0eee810c-ab1c-4ae4-a49f-d170d191174b	2026-09-01 14:46	2026-09-01 14:46	2026-09-01 14:46	LITE	LITE260918P00850000	put	850.0000	2026-09-18	44.6300	42.7000	44.9000	862.2200	276730.00	93860.00	93470.00	62	7	1413	294	4.80612244897959	0.69521684573597	0.694061295001429	false	false	false	true	false
1384b144-7c1b-4688-9a9d-b21f2eef8ebc	2026-09-01 14:55	2026-09-01 14:55	2026-09-01 14:55	LITE	LITE260918P00850000	put	850.0000	2026-09-18	43.2000	43.2000	43.5000	865.9900	90720.00	0.00	90720.00	21	5	1567	294	5.32993197278912	0.697485217078327	0.698056628256744	false	false	false	true	false
eb9501b9-8117-4c93-ab30-f205000ef4ee	2026-09-01 14:55	2026-09-01 14:55	2026-09-01 14:55	LITE	LITE260918P00850000	put	850.0000	2026-09-18	43.4000	42.7000	43.5000	865.9100	65100.00	60760.00	4340.00	15	15	1626	294	5.53061224489796	0.70034203831602	0.70034203831602	true	false	false	true	false
e3ff4f90-3e8f-4609-a4db-7893e5afeeae	2026-09-01 14:57	2026-09-01 14:57	2026-09-01 14:57	LITE	LITE260918C00850000	call	850.0000	2026-09-18	60.6000	59.9000	60.6000	864.9950	109080.00	109080.00	0.00	18	5	1718	391	4.39386189258312	0.704826358789701	0.704826358789701	true	false	false	true	false
844a2df2-9c00-471c-8de4-5f995adc4807	2026-09-01 14:58	2026-09-01 14:58	2026-09-01 14:58	LITE	LITE260904C00920000	call	920.0000	2026-09-04	8.0000	7.8000	8.3000	866.0401	72020.00	59210.00	12810.00	90	13	1267	396	3.19949494949495	0.817562867315423	0.826503195099848	false	false	false	true	false
78980251-a053-4c79-bc53-cf522305c0d4	2026-09-01 15:00	2026-09-01 15:00	2026-09-01 15:00	LITE	LITE260904C00920000	call	920.0000	2026-09-04	8.0000	7.8000	8.0000	868.2300	78400.00	78400.00	0.00	98	5	1366	396	3.44949494949495	0.80564382293313	0.80564382293313	false	false	false	true	false
7706e169-47ee-4d00-868c-fc99d9388dc9	2026-09-01 15:30	2026-09-01 15:30	2026-09-01 15:30	LITE	LITE260911C00970000	call	970.0000	2026-09-11	10.0000	8.7000	10.0000	873.2700	71000.00	71000.00	0.00	71	13	156	387	0.403100775193798	0.681599582444554	0.681599582444554	false	false	false	true	false
23101588-42ca-4366-bdfe-c8e7b9704590	2026-09-01 15:31	2026-09-01 15:31	2026-09-01 15:31	LITE	LITE280915C01600000	call	1600.0000	2028-09-15	241.4000	234.9000	241.4000	871.5100	120700.00	120700.00	0.00	5	5	18	49	0.36734693877551	0.783181473426288	0.783181473426288	false	false	false	true	false
dad5aa6a-863d-4117-8dad-86debaa2e29e	2026-09-01 15:57	2026-09-01 15:57	2026-09-01 15:57	LITE	LITE260911C00970000	call	970.0000	2026-09-11	9.0000	8.2000	10.0000	867.3100	66600.00	9000.00	13500.00	74	17	230	387	0.594315245478036	0.684376706208866	0.684376706208866	false	false	false	true	false
0c0114b4-ba66-4721-b344-3b02fb640d96	2026-09-02 09:32	2026-09-02 09:32	2026-09-02 09:32	LITE	LITE261016P00860000	put	860.0000	2026-10-16	77.9000	76.0000	81.1000	869.7550	194750.00	85690.00	109060.00	25	25	31	136	0.227941176470588	0.705251128070277	0.709739515406544	false	false	false	true	false
c9aff44e-5176-4c2e-b2cd-bc131ebde0a7	2026-09-02 09:32	2026-09-02 09:32	2026-09-02 09:32	LITE	LITE261016P00860000	put	860.0000	2026-10-16	79.0400	77.1000	81.1000	866.5500	165990.00	71100.00	94890.00	21	7	52	136	0.382352941176471	0.71412292164782	0.70996847169079	false	false	false	true	false
52e44d0c-8a70-4e84-9484-14c5f92b05e5	2026-09-02 09:35	2026-09-02 09:35	2026-09-02 09:35	LITE	LITE260904P00900000	put	900.0000	2026-09-04	40.0000	38.2000	40.6000	871.0100	80000.00	80000.00	0.00	20	7	24	589	0.0407470288624788	0.899791859767438	0.870684232811862	false	false	false	true	false
bd4abcad-f9ea-4d2e-ad5f-3977f060146d	2026-09-02 09:39	2026-09-02 09:39	2026-09-02 09:39	LITE	LITE260904C00900000	call	900.0000	2026-09-04	11.4000	11.1000	12.0000	872.1900	183540.00	123120.00	49020.00	161	21	171	938	0.182302771855011	0.868663677421387	0.862944045365055	false	false	false	true	false
1dbf66b0-3a23-4d9a-bfaa-15b2af06204b	2026-09-02 09:40	2026-09-02 09:40	2026-09-02 09:40	LITE	LITE260904C00900000	call	900.0000	2026-09-04	12.4900	12.0000	13.3000	877.0000	261020.00	113380.00	78200.00	209	45	421	938	0.448827292110874	0.844942895947395	0.836637763190082	false	false	false	true	false
d2bcf7ef-7fd9-40c6-9ad5-061d90c66141	2026-09-02 09:40	2026-09-02 09:40	2026-09-02 09:40	LITE	LITE260904C00910000	call	910.0000	2026-09-04	10.0000	9.8000	10.3000	878.7600	196000.00	68000.00	128000.00	196	11	201	276	0.728260869565217	0.838867437867988	0.838867437867988	false	false	false	true	false
abc47c50-7a27-4842-873d-e5d561c959ff	2026-09-02 09:41	2026-09-02 09:41	2026-09-02 09:41	LITE	LITE260904C00910000	call	910.0000	2026-09-04	9.2000	9.0000	9.9000	875.7400	184930.00	134320.00	40490.00	201	23	406	276	1.47101449275362	0.839207617243832	0.84222791584613	true	false	false	true	false
dd8de04b-6378-4b4a-ba91-b919612f2ca1	2026-09-02 09:42	2026-09-02 09:42	2026-09-02 09:42	LITE	LITE270319P00740000	put	740.0000	2027-03-19	109.6000	109.0000	113.9000	879.4700	153440.00	109600.00	43840.00	14	5	30	36	0.833333333333333	0.762299659219864	0.762999312653568	false	false	false	true	false
bcbfe0d7-f8fc-4f49-9f50-2f8c17d1fd00	2026-09-02 09:42	2026-09-02 09:42	2026-09-02 09:42	LITE	LITE270319P00740000	put	740.0000	2027-03-19	109.1000	109.1000	113.9000	880.6900	109100.00	0.00	109100.00	10	7	55	36	1.52777777777778	0.762162582563152	0.762162582563152	false	false	false	true	false
19057a71-1208-4c15-bfd9-f0afa677aa46	2026-09-02 10:00	2026-09-02 10:00	2026-09-02 10:00	LITE	LITE281215C01250000	call	1250.0000	2028-12-15	314.0000	306.2000	317.3000	859.5500	188400.00	62800.00	31400.00	6	6	6	9	0.666666666666667	0.772792690287186	0.772792690287186	false	false	false	true	false
779f8904-1b0b-4894-b762-63f8179268f9	2026-09-02 10:21	2026-09-02 10:21	2026-09-02 10:21	LITE	LITE260904C00930000	call	930.0000	2026-09-04	5.0000	4.8000	5.4000	873.4900	101000.00	6000.00	95000.00	202	9	288	890	0.323595505617978	0.86304491256082	0.86304491256082	false	false	false	true	false
e03d7fb8-8f17-45e3-a529-507b1a688381	2026-09-02 10:26	2026-09-02 10:26	2026-09-02 10:26	LITE	LITE261218P00940000	put	940.0000	2026-12-18	178.7900	177.2000	184.7000	867.2000	125151.00	0.00	125151.00	7	5	7	27	0.259259259259259	0.757098680537799	0.757098680537799	false	false	false	true	false
f248aecd-5246-460d-a3bd-4c6d8987297b	2026-09-02 10:34	2026-09-02 10:33	2026-09-02 10:33	LITE	LITE270716C01420000	call	1420.0000	2027-07-16	118.5000	118.5000	121.6000	863.0100	106650.00	0.00	106650.00	9	5	27	0	0	0.770676035914108	0.770676035914108	false	false	false	true	false
dc6f936a-a939-4dde-8d30-266a08de645d	2026-09-02 10:34	2026-09-02 10:34	2026-09-02 10:34	LITE	LITE260904C00920000	call	920.0000	2026-09-04	5.0300	4.9000	5.5000	865.4600	100610.00	51000.00	40110.00	200	25	449	1171	0.383432963279249	0.850159725462448	0.851914689457777	false	false	false	true	false
ef43cc6b-1ecf-4179-b9b7-35c1b05e84a6	2026-09-02 10:46	2026-09-02 10:45	2026-09-02 10:45	LITE	LITE270319P00800000	put	800.0000	2027-03-19	145.1000	144.0000	148.0000	860.7424	304710.00	246670.00	58040.00	21	6	87	188	0.462765957446808	0.763503096556255	0.763503096556255	false	false	false	true	false
49e85984-d3c0-4f0b-a258-abc9b2124838	2026-09-02 11:01	2026-09-02 11:01	2026-09-02 11:01	LITE	LITE260918C00850000	call	850.0000	2026-09-18	53.2700	52.7000	55.5000	853.8400	340920.00	0.00	340920.00	64	6	150	1204	0.124584717607973	0.710731913341599	0.711927526617935	false	false	false	true	false
cebcd8f1-5626-4a58-8f80-bf3f8ff138f3	2026-09-02 11:24	2026-09-02 11:24	2026-09-02 11:24	LITE	LITE261016C00860000	call	860.0000	2026-10-16	83.6200	82.6000	85.4000	853.9000	83624.00	0.00	83624.00	10	6	37	74	0.5	0.716965624390141	0.716965624390141	false	false	false	true	false
5522acec-21a5-4791-acf7-a9254938f904	2026-09-02 12:04	2026-09-02 12:04	2026-09-02 12:04	LITE	LITE270319P00690000	put	690.0000	2027-03-19	91.5000	91.5000	97.0000	861.7199	128100.00	0.00	128100.00	14	12	15	3	5	0.761700300422675	0.761700300422675	false	false	false	true	false
a5d77a61-5e34-4999-ae37-85f006fbe8bd	2026-09-02 13:04	2026-09-02 13:04	2026-09-02 13:04	LITE	LITE261218P00750000	put	750.0000	2026-12-18	76.9000	76.9000	80.0000	858.5850	76900.00	0.00	76900.00	10	7	48	663	0.0723981900452489	0.741331064191107	0.741331064191107	false	false	false	true	false
879d2406-2fad-4d7d-9337-693dca82f5a5	2026-09-02 15:54	2026-09-02 15:54	2026-09-02 15:54	LITE	LITE260918C00920000	call	920.0000	2026-09-18	28.1000	27.4000	29.0000	866.0000	53390.00	47770.00	5620.00	19	9	55	224	0.245535714285714	0.671800751473827	0.671800751473827	true	false	false	true	false
947e3e82-2b9f-4984-98b7-7c7a546d8886	2026-09-03 10:04	2026-09-03 10:03	2026-09-03 10:03	LITE	LITE260904C00860000	call	860.0000	2026-09-04	5.0200	4.9000	5.7000	823.0500	103470.00	5180.00	56790.00	206	45	222	150	1.48	1.01163253915803	1.00359181836797	false	false	false	true	false
83efcaf9-ffa9-4704-a2d3-ffc9904dc0a1	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	LITE	LITE260904C00860000	call	860.0000	2026-09-04	4.0100	3.9000	4.5000	821.6900	82582.00	5380.00	48002.00	206	52	440	150	2.93333333333333	0.942364825053	0.942364825053	false	false	false	true	false
b34bc8eb-e060-4f7a-b677-16a97e85dd3c	2026-09-03 10:05	2026-09-03 10:05	2026-09-03 10:05	LITE	LITE260904C00850000	call	850.0000	2026-09-04	6.1200	6.0000	6.6000	822.4950	121160.00	79420.00	40520.00	198	34	298	365	0.816438356164384	0.938719949662038	0.931549171067964	false	false	false	true	false