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 = RepeatedHitsDescendingFill×ticker = AAOI×

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

acc890bc-bbc3-4fb8-bc4d-db4370d9a363	2026-09-02 12:52	2026-09-02 12:51	2026-09-02 12:51	AAOI	AAOI260904P00100000	put	100.0000	2026-09-04	2.4400	2.2500	2.5000	100.9600	24398.00	24398.00	0.00	100	6	168	1089	0.154269972451791	0.999488196872773	0.962051163366055	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Technology	8098350135.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-02T16:56:20.498446Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c24125cb-6190-4c67-aa15-10be6471b271	2026-09-01 13:34	2026-09-01 13:34	2026-09-01 13:34	AAOI	AAOI270617P00090000	put	90.0000	2027-06-17	23.6000	23.6000	24.6000	103.2300	389402.00	0.00	389402.00	165	40	396	569	0.695957820738137	0.939314988969568	0.93898521266483	false	false	false	true
0ee91289-6df9-4d70-b242-7e222ac69919	2026-08-31 13:08	2026-08-31 13:08	2026-08-31 13:08	AAOI	AAOI270115C00100000	call	100.0000	2027-01-15	28.2900	27.1000	28.3000	106.9450	118802.00	115992.00	2810.00	42	7	48	2639	0.0181887078438803	0.966733050359692	0.958334344323539	false	false	false	true
4a78c233-e2b8-4ef8-b108-ccfc18b54eb1	2026-08-31 12:48	2026-08-31 12:47	2026-08-31 12:47	AAOI	AAOI270617P00115000	put	115.0000	2027-06-17	39.4500	39.4000	39.8000	107.0250	23670.00	0.00	23670.00	6	5	10	80	0.125	0.982980258039377	0.982980258039377	false	false	false	true
44c215c1-5f8a-4c22-a32e-296c71c599f0	2026-08-31 10:22	2026-08-31 10:22	2026-08-31 10:22	AAOI	AAOI280121C00200000	call	200.0000	2028-01-21	30.3000	30.1000	33.2000	104.5200	2957220.00	3020.00	2954200.00	976	54	977	349	2.79942693409742	1.00629611677933	1.00868733789502	false	false	false	true
e73133ee-a94f-4035-8680-126cff697682	2026-08-28 11:21	2026-08-28 11:21	2026-08-28 11:21	AAOI	AAOI260828P00120000	put	120.0000	2026-08-28	11.6300	10.6000	12.2000	108.7100	29084.00	29084.00	0.00	25	5	49	804	0.0609452736318408	4.24838575267691	2.8067389272726	false	false	false	true
851be289-a740-4985-a0a7-268e30d3e4fe	2026-08-26 11:58	2026-08-26 11:58	2026-08-26 11:58	AAOI	AAOI260904C00115000	call	115.0000	2026-09-04	5.6400	5.4000	6.2000	111.9900	22544.00	0.00	22544.00	40	6	132	149	0.885906040268456	0.985456468344946	0.985456468344946	false	false	false	true
55399d90-3ab4-425c-80c3-f589d32d8528	2026-08-25 14:49	2026-08-25 14:48	2026-08-25 14:48	AAOI	AAOI260828P00100000	put	100.0000	2026-08-28	0.6200	0.6000	0.7000	113.0435	12395.00	0.00	12330.00	200	17	670	1104	0.606884057971015	1.15075348126189	1.12425834823663	false	false	false	true
265cf6cd-e6f5-4890-885d-4b371366e024	2026-08-25 09:52	2026-08-25 09:52	2026-08-25 09:52	AAOI	AAOI260828C00120000	call	120.0000	2026-08-28	3.2200	3.1000	3.4000	114.0600	12860.00	0.00	12540.00	40	19	731	2138	0.341908325537886	1.29934933404448	1.34068392745256	false	false	false	true
b5f405d7-cb50-4f71-8d25-0b011ebf404c	2026-08-25 09:30	2026-08-25 09:30	2026-08-25 09:30	AAOI	AAOI260828C00116000	call	116.0000	2026-08-28	3.3500	3.1000	3.7000	110.5550	11380.00	330.00	3970.00	34	30	77	126	0.611111111111111	1.39287788511885	1.36656054736319	false	false	false	true
17c7c5e4-959a-4d1e-9938-40389e0de68e	2026-08-24 10:17	2026-08-24 10:17	2026-08-24 10:17	AAOI	AAOI270319P00080000	put	80.0000	2027-03-19	17.1500	16.8000	17.5000	106.5700	12008.00	6864.00	1714.00	7	5	9	130	0.0692307692307692	1.08952622559705	1.08952622559705	false	false	false	true
680ec12a-e4fc-4a8d-9105-8950de316fe9	2026-08-21 11:47	2026-08-21 11:46	2026-08-21 11:46	AAOI	AAOI260828C00140000	call	140.0000	2026-08-28	2.8000	2.7000	3.0000	125.6500	50685.00	565.00	50120.00	181	18	1233	2270	0.543171806167401	1.09893425763578	1.09013462733589	false	false	false	true
8627d436-8fae-42ec-aef3-daddcc556971	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	AAOI	AAOI260828C00133000	call	133.0000	2026-08-28	6.7200	6.7000	7.2000	129.4300	20170.00	0.00	14080.00	30	25	40	73	0.547945205479452	1.16363886580601	1.14960329294688	false	false	false	true
a0063e5c-1124-41c6-8f05-681e262a5935	2026-08-20 15:46	2026-08-20 15:46	2026-08-20 15:46	AAOI	AAOI260821C00130000	call	130.0000	2026-08-21	3.1100	3.0000	3.2000	129.4300	10260.00	6544.00	1236.00	33	7	5774	1815	3.18126721763085	1.25221055818638	1.25221055818638	false	false	false	true
c4406a13-7459-46f2-b39d-fdef7d2814b0	2026-08-20 10:39	2026-08-20 10:39	2026-08-20 10:39	AAOI	AAOI260828C00140000	call	140.0000	2026-08-28	4.5000	4.4000	4.5000	128.4400	20235.00	18900.00	0.00	45	5	2646	542	4.88191881918819	1.1505519897671	1.1505519897671	false	false	false	true
698fe15d-6471-4948-a52c-1c6f2014d8b8	2026-08-19 15:03	2026-08-19 15:03	2026-08-19 15:03	AAOI	AAOI260821C00113000	call	113.0000	2026-08-21	10.3100	9.9000	11.1000	122.0850	41226.00	0.00	41226.00	40	6	179	50	3.58	1.24230614742368	1.24230614742368	false	false	false	true
9e7e6c2c-227b-4b23-ac92-279643e9a288	2026-08-19 14:50	2026-08-19 14:50	2026-08-19 14:50	AAOI	AAOI260821P00110000	put	110.0000	2026-08-21	0.6500	0.4000	0.6500	122.5150	12992.00	12992.00	0.00	200	32	792	1043	0.75934803451582	1.25325678295868	1.25325678295868	false	false	false	true
3214764f-8171-49f8-a913-cfc5d3943f1f	2026-08-19 09:49	2026-08-19 09:49	2026-08-19 09:49	AAOI	AAOI260821P00115000	put	115.0000	2026-08-21	0.7000	0.3500	0.7500	132.0000	23441.00	23310.00	131.00	335	28	336	1879	0.178818520489622	1.49963156170098	1.49963156170098	true	false	false	true
56d98fff-3774-4f51-bf31-c0c1bcd9b43d	2026-08-18 12:21	2026-08-18 12:20	2026-08-18 12:20	AAOI	AAOI260821P00130000	put	130.0000	2026-08-21	4.3000	4.0000	4.4000	134.3300	77808.00	77808.00	0.00	181	20	1581	2254	0.701419698314108	1.30718576969856	1.30718576969856	false	false	false	true
01ab548c-ba8d-4954-a652-fcc3c9452edd	2026-08-18 10:02	2026-08-18 10:01	2026-08-18 10:01	AAOI	AAOI260918C00175000	call	175.0000	2026-09-18	7.7400	7.6000	8.1000	141.0200	14700.00	0.00	14700.00	19	8	753	3841	0.196042697214267	1.11129701610076	1.11129701610076	false	false	false	true
bf717205-fd90-42e9-a0d8-697cb1ea039b	2026-08-18 10:00	2026-08-18 10:00	2026-08-18 10:00	AAOI	AAOI260828C00175000	call	175.0000	2026-08-28	2.0900	2.0000	2.4500	140.2302	10436.00	0.00	10436.00	50	7	235	170	1.38235294117647	1.20258052642433	1.20258052642433	false	false	false	true
deabd6df-477a-495d-8c72-d0c17c2a1ff0	2026-08-18 09:57	2026-08-18 09:57	2026-08-18 09:57	AAOI	AAOI260918C00175000	call	175.0000	2026-09-18	7.7700	7.7000	8.1000	141.0000	13211.00	0.00	13211.00	17	7	439	3841	0.114293152824785	1.11379249790704	1.11379249790704	false	false	false	true
f4227100-d1df-490c-b31c-c957646d10b2	2026-08-18 09:57	2026-08-18 09:56	2026-08-18 09:56	AAOI	AAOI260918C00175000	call	175.0000	2026-09-18	7.8200	7.4000	8.2000	141.1653	13294.00	11734.00	0.00	17	6	375	3841	0.0976308253059099	1.1136894010327	1.1136894010327	false	false	false	true
25d21a86-34fa-4d10-b099-59017c2520ce	2026-08-18 09:55	2026-08-18 09:55	2026-08-18 09:55	AAOI	AAOI260918C00175000	call	175.0000	2026-09-18	7.6300	7.5000	7.9000	140.2500	21376.00	0.00	21376.00	28	8	257	3841	0.0669096589429836	1.12083778862732	1.12083778862732	false	false	false	true
45a3ce0e-250d-4ed5-99f0-30b3608ab967	2026-08-17 15:02	2026-08-17 15:02	2026-08-17 15:02	AAOI	AAOI260821C00160000	call	160.0000	2026-08-21	7.2200	7.1000	7.3000	157.5750	23830.00	5830.00	8640.00	33	21	3493	2007	1.74040857000498	1.27195711705623	1.25674533754875	false	false	false	true
041b5021-8114-44d5-bb46-77b0b486dca7	2026-08-17 14:01	2026-08-17 14:01	2026-08-17 14:01	AAOI	AAOI260821P00155000	put	155.0000	2026-08-21	6.2700	6.0000	6.4000	158.0000	15050.00	15050.00	0.00	24	8	619	290	2.13448275862069	1.24721460146823	1.23941804773547	false	false	false	true
5dac978a-6a02-44a1-9ca6-4583707d779e	2026-08-17 11:38	2026-08-17 11:38	2026-08-17 11:38	AAOI	AAOI260821C00180000	call	180.0000	2026-08-21	2.1000	2.0000	2.1500	156.8300	40876.00	420.00	40456.00	195	15	3723	1412	2.63668555240793	1.35031645337682	1.34494094109498	false	false	false	true
78ddf584-3673-4e6f-9b82-fa6734d9b8ef	2026-08-17 11:21	2026-08-17 11:21	2026-08-17 11:21	AAOI	AAOI260821C00200000	call	200.0000	2026-08-21	0.6000	0.5000	0.6000	157.0803	12110.00	12000.00	55.00	202	9	2152	2222	0.968496849684969	1.43014723829938	1.40477401169995	false	false	false	true
bf9ee38f-de76-4d6f-9788-8aa55b4b852f	2026-08-17 11:17	2026-08-17 11:17	2026-08-17 11:17	AAOI	AAOI260918C00200000	call	200.0000	2026-09-18	8.2800	7.9000	8.3000	156.9100	14080.00	14080.00	0.00	17	12	205	2070	0.0990338164251208	1.14068002705172	1.13792404774918	false	false	false	true
e3a2e8a8-4222-4146-8044-dc1ccf763e95	2026-08-17 10:30	2026-08-17 10:30	2026-08-17 10:30	AAOI	AAOI260828C00195000	call	195.0000	2026-08-28	2.5300	2.4000	2.7500	154.3700	63189.00	0.00	63189.00	250	9	255	156	1.63461538461538	1.22431061668377	1.22431061668377	false	false	false	true
f1f4b55a-5f62-49c8-a907-fcfc2b5af50c	2026-08-17 10:29	2026-08-17 10:29	2026-08-17 10:29	AAOI	AAOI270115C00140000	call	140.0000	2027-01-15	51.0300	50.8000	53.4000	154.5200	5102585.00	0.00	5102585.00	1000	7	1004	2287	0.439003060778312	1.16343191840258	1.16343191840258	false	false	false	true
3530efce-2804-4633-a5af-2529d9dafe05	2026-08-17 09:31	2026-08-17 09:31	2026-08-17 09:31	AAOI	AAOI260821C00160000	call	160.0000	2026-08-21	5.7500	5.5000	6.8000	151.9900	40795.00	0.00	31725.00	71	57	201	2007	0.100149476831091	1.36228733046612	1.38646166225052	false	false	false	true