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

ada76338-b6da-4f34-b972-cfb902b6103d	2026-09-03 10:06	2026-09-03 10:05	2026-09-03 10:05	LITE	LITE260904C00850000	call	850.0000	2026-09-04	6.0500	5.9000	7.0000	824.1700	251624.00	73140.00	155684.00	416	66	728	365	1.99452054794521	0.916525824240233	0.893212300153459	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Technology	74902191000.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T14:10:05.195539Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e15a1440-fe0a-409f-b16f-d3b422eb6bcb	2026-09-03 10:06	2026-09-03 10:06	2026-09-03 10:06	LITE	LITE261016P00770000	put	770.0000	2026-10-16	50.6000	50.6000	53.0000	825.4450	55660.00	0.00	55660.00	11	5	85	95	0.894736842105263	0.703232661454406	0.703232661454406	false	false	false	true	false
8c9779bb-dd1c-473b-8793-27760483d45e	2026-09-03 10:06	2026-09-03 10:06	2026-09-03 10:06	LITE	LITE260904C00855000	call	855.0000	2026-09-04	5.1000	5.0000	5.3000	824.2800	81600.00	2040.00	28050.00	160	19	166	68	2.44117647058824	0.909998193478132	0.909998193478132	false	false	false	true	false
faf4f893-3152-44c1-b20b-2aed901a6ee2	2026-09-03 10:07	2026-09-03 10:07	2026-09-03 10:07	LITE	LITE260904C00855000	call	855.0000	2026-09-04	5.0000	4.7000	5.2000	824.0000	62500.00	59000.00	0.00	125	8	412	68	6.05882352941176	0.907210680529679	0.907210680529679	false	false	false	true	false
3e7c43ae-1a84-4d1a-9074-25be271429ef	2026-09-03 10:07	2026-09-03 10:07	2026-09-03 10:07	LITE	LITE260904C00855000	call	855.0000	2026-09-04	5.0000	4.7000	5.4000	823.9500	52500.00	14000.00	38500.00	105	11	287	68	4.22058823529412	0.908082109918412	0.908082109918412	false	false	false	true	false
260b9afc-95f6-4fdc-881f-4dba402269c3	2026-09-03 10:10	2026-09-03 10:10	2026-09-03 10:10	LITE	LITE260911C00900000	call	900.0000	2026-09-11	9.0000	8.5000	10.3000	825.5800	221400.00	218700.00	2700.00	246	19	283	68	4.16176470588235	0.667865325398613	0.664375517280757	false	false	false	true	false
9163a1c6-9848-4a8f-b25f-6330144f5edc	2026-09-03 10:10	2026-09-03 10:10	2026-09-03 10:10	LITE	LITE260911C00890000	call	890.0000	2026-09-11	10.0000	10.0000	11.9000	823.5801	400002.00	0.00	288002.00	400	42	400	376	1.06382978723404	0.651621371748665	0.651621371748665	false	false	false	true	false
fed6a11a-db3a-46a0-b7da-f088320c380e	2026-09-03 10:11	2026-09-03 10:11	2026-09-03 10:11	LITE	LITE260911C00900000	call	900.0000	2026-09-11	9.0000	8.0000	9.0000	827.1800	99000.00	99000.00	0.00	110	6	436	68	6.41176470588235	0.660380112050867	0.654899899489804	false	false	false	true	false
7ed1139c-2c8a-4075-ba99-4e3bd89e871e	2026-09-03 10:15	2026-09-03 10:15	2026-09-03 10:15	LITE	LITE260904C00860000	call	860.0000	2026-09-04	5.0000	4.1000	5.0000	828.0150	68500.00	68500.00	0.00	137	58	984	150	6.56	0.917042672172813	0.918853917548763	false	false	false	true	false
45cafd35-1bfb-4356-8ba9-6a864015c619	2026-09-03 10:15	2026-09-03 10:15	2026-09-03 10:15	LITE	LITE260904C00860000	call	860.0000	2026-09-04	5.0000	4.7000	5.0000	827.8400	146500.00	146500.00	0.00	293	26	1290	150	8.6	0.921870760349851	0.921870760349851	false	false	false	true	false
e4314b62-890c-4504-8c4b-9ec41a20881c	2026-09-03 10:17	2026-09-03 10:17	2026-09-03 10:17	LITE	LITE260904C00860000	call	860.0000	2026-09-04	5.1000	4.9000	5.5000	829.5900	508470.00	330480.00	136680.00	997	45	2488	150	16.5866666666667	0.899197801610285	0.899197801610285	false	false	false	true	false
b3bfc1b5-d52e-42e9-b024-2e99934985a7	2026-09-03 10:18	2026-09-03 10:18	2026-09-03 10:18	LITE	LITE260904C00865000	call	865.0000	2026-09-04	5.0000	4.9000	5.3000	834.4101	50500.00	3000.00	19000.00	101	14	166	57	2.91228070175439	0.889441355006845	0.889441355006845	false	false	false	true	false
ca8be17e-94e7-4f9c-b898-fdeb0759289f	2026-09-03 10:18	2026-09-03 10:18	2026-09-03 10:18	LITE	LITE260904C00850000	call	850.0000	2026-09-04	9.0100	8.6000	9.2000	833.9500	179200.00	4600.00	174600.00	199	8	1162	365	3.18356164383562	0.893556855393679	0.905897152807744	false	false	false	true	false
1398b322-00b3-47b8-8c8c-6e8d8eec5116	2026-09-03 10:19	2026-09-03 10:19	2026-09-03 10:19	LITE	LITE260904C00865000	call	865.0000	2026-09-04	5.0100	4.9000	5.4000	834.7250	54054.00	3550.00	40504.00	108	42	375	57	6.57894736842105	0.884004436311127	0.884004436311127	false	false	false	true	false
89c96fb2-a2f7-42c7-a76f-69bf11fce930	2026-09-03 10:19	2026-09-03 10:19	2026-09-03 10:19	LITE	LITE260904C00865000	call	865.0000	2026-09-04	5.0000	4.9000	5.3000	835.3000	50000.00	2500.00	27500.00	100	14	475	57	8.33333333333333	0.874055203849698	0.874055203849698	false	false	false	true	false
dc12b2a2-0eaa-4a6a-ba0c-0b1eea89f29e	2026-09-03 10:20	2026-09-03 10:20	2026-09-03 10:20	LITE	LITE260904C00865000	call	865.0000	2026-09-04	4.7000	4.6000	5.0000	834.6900	94473.00	40420.00	39483.00	201	39	681	57	11.9473684210526	0.861714268241491	0.861714268241491	false	false	false	true	false
e543dfc7-161e-4274-91ed-133c2e99ad0d	2026-09-03 10:21	2026-09-03 10:21	2026-09-03 10:21	LITE	LITE260904C00865000	call	865.0000	2026-09-04	4.4000	4.2000	4.4500	832.1100	64240.00	64240.00	0.00	146	7	882	57	15.4736842105263	0.878730058001385	0.881645194704983	false	false	false	true	false
c202e99d-0b97-4e8f-a75b-46755597e967	2026-09-03 10:27	2026-09-03 10:27	2026-09-03 10:27	LITE	LITE260904C00840000	call	840.0000	2026-09-04	13.3000	13.3000	13.9000	835.0000	164920.00	0.00	164920.00	124	10	324	30	10.8	0.894086718915085	0.894086718915085	false	false	false	true	false
e01745da-fae2-44c6-b10c-2e5de054ff4c	2026-09-03 10:45	2026-09-03 10:45	2026-09-03 10:45	LITE	LITE260904P00875000	put	875.0000	2026-09-04	40.5000	40.5000	42.7000	837.0200	230850.00	0.00	230850.00	57	31	61	163	0.374233128834356	0.793822598329235	0.793822598329235	false	false	false	true	false
2fb0aa47-1d21-47b7-8efc-2985d2e633cc	2026-09-03 11:00	2026-09-03 11:00	2026-09-03 11:00	LITE	LITE260918P00830000	put	830.0000	2026-09-18	36.2000	36.0000	37.2000	848.9200	86880.00	0.00	86880.00	24	13	30	367	0.0817438692098093	0.67127912313355	0.672638976864713	false	false	false	true	false
95f586f7-1fa1-4900-905f-13a93d480500	2026-09-03 11:03	2026-09-03 11:02	2026-09-03 11:02	LITE	LITE260911C00920000	call	920.0000	2026-09-11	10.0800	9.3000	10.5000	852.5825	55450.00	23310.00	32140.00	55	5	268	71	3.77464788732394	0.63797400101912	0.640600764415995	false	false	false	true	false
aa0c5bd1-a7cd-4556-bead-3322816d385b	2026-09-03 11:03	2026-09-03 11:03	2026-09-03 11:03	LITE	LITE260904C00880000	call	880.0000	2026-09-04	6.0000	5.7000	6.0000	854.8100	93600.00	93600.00	0.00	156	7	602	274	2.1970802919708	0.850691184297843	0.850691184297843	false	false	false	true	false
8871ba15-a71d-47c8-8ab1-5cd236845d40	2026-09-03 12:01	2026-09-03 12:01	2026-09-03 12:01	LITE	LITE260904C00850000	call	850.0000	2026-09-04	15.3000	15.2000	16.1500	851.9900	87234.00	0.00	87234.00	57	10	1515	365	4.15068493150685	0.795629884829931	0.79675760673393	true	false	false	true	false
6ec3e851-994c-4e48-b194-79cce6d3b1df	2026-09-03 13:04	2026-09-03 13:04	2026-09-03 13:04	LITE	LITE261016P00800000	put	800.0000	2026-10-16	54.6800	51.9000	54.7000	850.9201	82020.00	82020.00	0.00	15	6	57	397	0.143576826196474	0.701853389020886	0.700925543445472	false	false	false	true	false
fb5094fe-8e9e-41b2-aeee-c777b96eab3b	2026-09-03 15:08	2026-09-03 15:08	2026-09-03 15:08	LITE	LITE260904C00855000	call	855.0000	2026-09-04	10.4000	9.7000	10.4000	847.3200	71760.00	71760.00	0.00	69	30	546	68	8.02941176470588	0.782128766987118	0.780263888218539	false	false	false	true	false
1c975963-7718-4a95-8969-aa2d2827dee6	2026-09-03 15:49	2026-09-03 15:49	2026-09-03 15:49	LITE	LITE260904C00870000	call	870.0000	2026-09-04	4.8000	4.6000	5.0000	843.2500	51840.00	27840.00	24000.00	108	7	563	238	2.36554621848739	0.802571120486931	0.803091861622253	false	false	false	true	false
20b52bd0-3099-4a26-8576-d671b76b0e63	2026-09-03 15:49	2026-09-03 15:49	2026-09-03 15:49	LITE	LITE260904C00880000	call	880.0000	2026-09-04	3.0000	2.9500	3.4000	845.7800	62116.00	39600.00	19516.00	207	46	1115	274	4.06934306569343	0.770021397872351	0.770021397872351	true	false	false	true	false
090a3f5a-9cde-43cf-be5e-b108acba4c2f	2026-09-03 15:56	2026-09-03 15:56	2026-09-03 15:56	LITE	LITE261016P00780000	put	780.0000	2026-10-16	45.7000	45.7000	49.2000	845.6500	91400.00	0.00	91400.00	20	6	98	271	0.361623616236162	0.679394600611502	0.679394600611502	false	false	false	true	false
e00c8812-bf22-4943-869f-9ec3713d4e75	2026-09-03 15:57	2026-09-03 15:57	2026-09-03 15:57	LITE	LITE260904C00850000	call	850.0000	2026-09-04	11.0000	10.7000	11.0000	845.6700	165000.00	165000.00	0.00	150	5	1862	365	5.1013698630137	0.735002573747541	0.735002573747541	false	false	false	true	false
31358e28-da2d-440b-8eca-e4b7b64d6e54	2026-09-04 09:30	2026-09-04 09:30	2026-09-04 09:30	LITE	LITE261016P00820000	put	820.0000	2026-10-16	60.0000	53.8000	60.0000	857.6000	60000.00	60000.00	0.00	10	6	10	194	0.0515463917525773	0.698626464120749	0.698626464120749	false	false	false	true	false
fd7241f9-8304-4267-8736-6f5a72deface	2026-09-04 09:30	2026-09-04 09:30	2026-09-04 09:30	LITE	LITE260904P00865000	put	865.0000	2026-09-04	16.9000	14.2000	16.9000	851.4900	430950.00	430950.00	0.00	255	6	255	169	1.50887573964497	0.913193626502883	0.913193626502883	true	false	false	true	false
1d77267c-f0ae-4c49-98c2-0c33d03b2e6f	2026-09-04 09:34	2026-09-04 09:34	2026-09-04 09:34	LITE	LITE260904C00870000	call	870.0000	2026-09-04	4.0800	3.6000	5.3000	854.8200	84502.00	16200.00	47102.00	207	51	217	644	0.33695652173913	1.00352890856702	1.04787250545378	false	false	false	true	false
0857d78a-aafd-48eb-a44a-fae7ae8fd5d7	2026-09-04 09:36	2026-09-04 09:36	2026-09-04 09:36	LITE	LITE260911C00920000	call	920.0000	2026-09-11	8.0000	7.4000	8.0000	851.6800	60000.00	60000.00	0.00	75	6	147	665	0.221052631578947	0.627129402611407	0.627129402611407	false	false	false	true	false
eec75bfe-31a0-4fa4-8369-20b82828c6ea	2026-09-04 09:37	2026-09-04 09:37	2026-09-04 09:37	LITE	LITE260911C00920000	call	920.0000	2026-09-11	8.2200	8.1000	8.9000	856.8100	86271.00	9910.00	76361.00	105	19	333	665	0.500751879699248	0.601707927317188	0.601707927317188	false	false	false	true	false
77ef3f6f-7cc8-40ae-b9e1-5a0a8cbf4b0f	2026-09-04 09:37	2026-09-04 09:37	2026-09-04 09:37	LITE	LITE270319C01200000	call	1200.0000	2027-03-19	97.5900	88.2000	98.1000	863.1200	78070.00	78070.00	0.00	8	8	8	229	0.0349344978165939	0.748554997633919	0.748554997633919	false	false	false	true	false
87a2f9ab-9944-4972-9470-5de490d988d3	2026-09-04 09:42	2026-09-04 09:42	2026-09-04 09:42	LITE	LITE270319P00680000	put	680.0000	2027-03-19	84.3000	81.7000	90.1000	858.9500	160170.00	0.00	160170.00	19	5	24	63	0.380952380952381	0.746441648425059	0.745817064169922	false	false	false	true	false
1abecebf-1ae4-41f1-ac2c-86cab20c27a5	2026-09-04 09:47	2026-09-04 09:47	2026-09-04 09:47	LITE	LITE261218P00780000	put	780.0000	2026-12-18	82.7000	81.7000	87.1000	876.5800	90970.00	49620.00	41350.00	11	5	70	284	0.246478873239437	0.735362054294302	0.735362054294302	false	false	false	true	false
52542f52-4064-4bdf-86a6-1d72cb858d53	2026-09-04 09:50	2026-09-04 09:50	2026-09-04 09:50	LITE	LITE260911C00945000	call	945.0000	2026-09-11	7.0200	6.7000	7.4000	871.0900	112350.00	112350.00	0.00	160	5	162	87	1.86206896551724	0.611864908584403	0.614062119423902	false	false	false	true	false
66ccaa00-a349-4110-8bce-0b84a9c5fafd	2026-09-04 09:53	2026-09-04 09:53	2026-09-04 09:53	LITE	LITE260904C00880000	call	880.0000	2026-09-04	4.0000	3.9000	4.5000	865.0800	60010.00	26810.00	32400.00	150	18	250	1126	0.22202486678508	1.05343273051699	1.05343273051699	false	false	false	true	false
e1c60b8f-1754-4a1c-a3ff-dd1c093ab37d	2026-09-04 10:02	2026-09-04 10:02	2026-09-04 10:02	LITE	LITE270319C01000000	call	1000.0000	2027-03-19	151.0700	144.1000	155.1000	871.9900	226610.00	196390.00	0.00	15	15	15	276	0.0543478260869565	0.748180474976537	0.748573576818329	false	false	false	true	false
a6d7a194-3f92-406a-acbb-385cd69a74d0	2026-09-04 10:02	2026-09-04 10:02	2026-09-04 10:02	LITE	LITE270319C01000000	call	1000.0000	2027-03-19	151.0000	145.0000	155.4000	872.7750	105700.00	105700.00	0.00	7	6	22	276	0.0797101449275362	0.746558490883129	0.746558490883129	false	false	false	true	false
64ec5e7a-e0d0-4d32-ac14-ba1a113c5bde	2026-09-04 10:15	2026-09-04 10:15	2026-09-04 10:15	LITE	LITE260904P00870000	put	870.0000	2026-09-04	7.8000	6.3000	7.8000	873.7000	102954.00	102954.00	0.00	132	43	158	861	0.183507549361208	1.0713076767709	1.0713076767709	false	false	false	true	false
0389a113-5309-4098-9097-19a66d6cb292	2026-09-04 10:37	2026-09-04 10:37	2026-09-04 10:37	LITE	LITE261218P00620000	put	620.0000	2026-12-18	31.6500	30.3000	33.1000	864.0400	94950.00	47700.00	47250.00	30	10	33	277	0.11913357400722	0.74908326732755	0.751912091632021	false	false	false	true	false
cf48c7bc-4b1d-494f-ba7a-b6190df53d2f	2026-09-04 10:42	2026-09-04 10:42	2026-09-04 10:42	LITE	LITE260925C00830000	call	830.0000	2026-09-25	75.7000	75.7000	79.4000	866.1099	158970.00	0.00	158970.00	21	13	21	9	2.33333333333333	0.67499583363791	0.67499583363791	false	false	false	true	false
e19f4e45-dd28-49cf-89f6-a0267365b3b1	2026-09-04 11:09	2026-09-04 11:09	2026-09-04 11:09	LITE	LITE260904C00865000	call	865.0000	2026-09-04	7.4000	7.4000	8.2000	866.1200	77742.00	3000.00	74742.00	105	33	331	833	0.397358943577431	0.839355659873034	0.839355659873034	false	false	false	true	false
82783ed7-f5fe-4a30-a050-d62b0f8abf15	2026-09-04 11:15	2026-09-04 11:15	2026-09-04 11:15	LITE	LITE260911P00855000	put	855.0000	2026-09-11	21.0000	20.2000	21.0000	874.1800	115500.00	115500.00	0.00	55	8	59	149	0.395973154362416	0.625669234783709	0.625669234783709	false	false	false	true	false
e289ba5e-46bf-4d6c-a09e-f655917dcc9c	2026-09-04 11:46	2026-09-04 11:46	2026-09-04 11:46	LITE	LITE260918C00950000	call	950.0000	2026-09-18	17.5000	17.5000	18.4000	867.0000	112000.00	0.00	112000.00	64	10	97	605	0.160330578512397	0.671752136407919	0.671752136407919	false	false	false	true	false
66e4951a-aaa0-4448-8c99-90fa33d3687f	2026-09-04 12:17	2026-09-04 12:17	2026-09-04 12:17	LITE	LITE260918C00890000	call	890.0000	2026-09-18	39.7000	39.7000	40.8000	877.5100	1671370.00	0.00	1671370.00	421	8	439	99	4.43434343434343	0.653675438526905	0.653675438526905	false	false	false	true	false
6401b9b9-203e-4015-9c61-21dd3e4cb12a	2026-09-04 12:17	2026-09-04 12:17	2026-09-04 12:17	LITE	LITE260918C00900000	call	900.0000	2026-09-18	35.5000	35.5000	37.7000	877.5100	117150.00	0.00	117150.00	33	5	88	677	0.129985228951256	0.653315769452512	0.653315769452512	false	false	false	true	false
ef6083ac-e533-4667-80b0-7863e8dcf272	2026-09-04 12:30	2026-09-04 12:30	2026-09-04 12:30	LITE	LITE270319C01430000	call	1430.0000	2027-03-19	68.7700	68.3000	69.4000	881.2400	165040.00	165040.00	0.00	24	16	24	4	6	0.758573261226652	0.762186812802491	false	false	false	true	false