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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 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 = HOOD×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	expiry

18840907-f01f-4958-9b48-21177acfbe0d	2026-08-18 10:43	2026-08-18 10:43	2026-08-18 10:43	HOOD	HOOD280121C00120000	call	120.0000	2028-01-21	22.6800	22.0000	22.7000	93.3700	453600.00	371880.00	0.00	200	10	201	2392	0.0840301003344482	0.660447721065976	0.658501973685313	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Technology	90392754653.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c122b767-b9fc-4fda-9d42-308cd4cb72ab	2026-08-18 11:46	2026-08-18 11:45	2026-08-18 11:45	HOOD	HOOD261120P00090000	put	90.0000	2026-11-20	9.6000	9.5500	9.8000	93.2000	472325.00	130560.00	341765.00	492	41	507	1977	0.256449165402124	0.630052379875631	0.627703800813771	false	false	false
73bcff87-07cb-4a4d-93d9-11600f81f00b	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	HOOD	HOOD261016C00110000	call	110.0000	2026-10-16	3.9500	3.6000	3.9500	94.0750	351920.00	350750.00	1170.00	891	53	910	2382	0.382031905961377	0.604555378869402	0.600757624410191	true	false	false
6f58f9d1-f453-4ac2-a578-c30748965ae7	2026-08-19 10:08	2026-08-19 10:08	2026-08-19 10:08	HOOD	HOOD260828P00100000	put	100.0000	2026-08-28	7.5500	7.3000	7.5500	93.8100	370685.00	370685.00	0.00	491	29	499	525	0.95047619047619	0.616297506105719	0.616297506105719	false	false	false	true
202857ac-a7f5-4b10-b27c-0c429ebcf874	2026-08-19 10:23	2026-08-19 10:23	2026-08-19 10:23	HOOD	HOOD260828C00090000	call	90.0000	2026-08-28	5.5500	5.3500	5.5500	93.5050	68250.00	68250.00	0.00	123	21	208	1160	0.179310344827586	0.603210209290678	0.603210209290678	false	false	false	true
735a4f95-eca3-460e-baa1-59377349246d	2026-08-19 10:25	2026-08-19 10:25	2026-08-19 10:25	HOOD	HOOD260918P00085000	put	85.0000	2026-09-18	2.5100	2.3700	2.5900	93.4300	85981.00	53973.00	32008.00	343	13	529	12638	0.0418578889064725	0.578536233119474	0.573838904110822	true	false	false
672610d2-f11b-49e7-b0b1-5d2c4ec7b9d9	2026-08-19 11:01	2026-08-19 11:01	2026-08-19 11:01	HOOD	HOOD260918C00110000	call	110.0000	2026-09-18	2.6200	2.5100	2.6300	96.9200	116003.00	89314.00	26689.00	443	47	1581	8196	0.19289897510981	0.618437272893859	0.618289901095421	true	false	false
fad8790c-6587-4934-bcff-db8aba1978a2	2026-08-19 11:01	2026-08-19 11:01	2026-08-19 11:01	HOOD	HOOD261120C00120000	call	120.0000	2026-11-20	5.9000	5.3500	5.9000	97.2100	138021.00	138021.00	0.00	234	14	248	3557	0.0697216755693	0.656082230594912	0.656082230594912	false	false	false
25ac1e40-7a07-407e-be3e-11f86e458c66	2026-08-19 11:01	2026-08-19 11:01	2026-08-19 11:01	HOOD	HOOD261016C00105000	call	105.0000	2026-10-16	6.7000	6.6500	6.9000	97.2100	215048.00	213708.00	1340.00	321	28	354	4524	0.0782493368700265	0.617438077505986	0.617438077505986	false	false	false
138b04b8-d544-456c-ad5f-233eab2548e0	2026-08-19 11:01	2026-08-19 11:01	2026-08-19 11:01	HOOD	HOOD260821C00100000	call	100.0000	2026-08-21	1.1600	1.1500	1.1900	97.1750	137114.00	22656.00	114458.00	1187	29	8508	23804	0.357418921189716	0.799926556260487	0.796162188108209	false	false	false
84af9833-fe78-4e45-af89-81e42cb7be2c	2026-08-19 11:35	2026-08-19 11:35	2026-08-19 11:35	HOOD	HOOD270416C00105000	call	105.0000	2027-04-16	18.6400	18.2000	18.6500	97.7900	141688.00	141688.00	0.00	76	12	93	624	0.149038461538462	0.65090299594734	0.65090299594734	false	false	false
31b6780d-5236-40c0-b69e-c969f268375a	2026-08-19 11:49	2026-08-19 11:49	2026-08-19 11:49	HOOD	HOOD261002C00110000	call	110.0000	2026-10-02	4.4400	4.1500	4.5000	98.0250	199983.00	159933.00	40050.00	450	32	517	75	6.89333333333333	0.631765467097331	0.631765467097331	false	false	false
6969893d-0855-4d3a-b412-bbca81f8ebbe	2026-08-19 12:37	2026-08-19 12:36	2026-08-19 12:36	HOOD	HOOD261016C00095000	call	95.0000	2026-10-16	11.7200	11.7000	12.2000	99.1600	65632.00	0.00	64437.00	56	6	670	2410	0.278008298755187	0.611868760693487	0.595831114980307	false	false	false
6c13c712-387e-44f2-837b-cd0a961e01d2	2026-08-19 15:16	2026-08-19 15:16	2026-08-19 15:16	HOOD	HOOD260821C00096000	call	96.0000	2026-08-21	1.6800	1.6400	1.6800	95.2800	69708.00	69543.00	165.00	415	5	5694	3046	1.8693368351937	0.713700061898296	0.701341597712268	false	false	false
f33baab8-72ff-4a2d-beb0-d599a3f0bd07	2026-08-19 15:43	2026-08-19 15:42	2026-08-19 15:42	HOOD	HOOD260821C00096000	call	96.0000	2026-08-21	1.9300	1.8400	1.9300	95.7700	89509.00	86834.00	2675.00	464	57	10749	3046	3.52889034799737	0.72173965837222	0.714713116203839	true	false	false
271fd4ec-a149-4537-a465-af68eb50bd4b	2026-08-20 09:41	2026-08-20 09:41	2026-08-20 09:41	HOOD	HOOD260904C00105000	call	105.0000	2026-09-04	2.2300	2.1000	2.3300	96.5800	111548.00	78398.00	33150.00	500	6	516	1133	0.455428067078552	0.66298009523395	0.66298009523395	false	false	false
7d5bbfe4-b520-4f3c-ac75-470308c64c73	2026-08-20 12:44	2026-08-20 12:44	2026-08-20 12:44	HOOD	HOOD261218C00090000	call	90.0000	2026-12-18	16.9200	16.7000	17.0000	95.1698	71050.00	23730.00	47320.00	42	5	72	1353	0.0532150776053215	0.64828909128472	0.645829214921455	false	false	false
8775db7b-491a-4028-ac88-b8e079ac70f7	2026-08-20 12:51	2026-08-20 12:51	2026-08-20 12:51	HOOD	HOOD260918P00100000	put	100.0000	2026-09-18	9.3500	9.0500	9.3500	95.0300	354345.00	354345.00	0.00	379	34	635	4259	0.149096031932378	0.618253765350123	0.618253765350123	false	false	false
8418ad7f-2867-4301-9861-5ee468d0d44c	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	HOOD	HOOD260828C00100000	call	100.0000	2026-08-28	4.9700	4.7000	5.1000	101.9850	126840.00	116500.00	10340.00	255	7	587	6054	0.0969606871489924	0.700633730950024	0.641602580812138	false	false	false
a3570c72-742c-4103-9c69-18483adb9369	2026-08-21 09:41	2026-08-21 09:41	2026-08-21 09:41	HOOD	HOOD280121C00095000	call	95.0000	2028-01-21	38.7600	37.1500	39.1000	104.6150	77520.00	38850.00	38670.00	20	5	56	1134	0.0493827160493827	0.685771385885775	0.682074988260385	true	false	false
237ecee0-b913-4d3a-9325-00cd3810ef48	2026-08-21 09:41	2026-08-21 09:41	2026-08-21 09:41	HOOD	HOOD261016C00120000	call	120.0000	2026-10-16	5.5500	5.3000	5.7000	104.1402	278015.00	278015.00	0.00	501	18	1700	10338	0.16444186496421	0.666659656056775	0.665996507763694	false	false	false
943093fc-f2ee-46d7-aaec-22876692c6ad	2026-08-21 09:44	2026-08-21 09:44	2026-08-21 09:44	HOOD	HOOD270617C00100000	call	100.0000	2027-06-17	29.8900	29.6500	30.3500	106.0700	59770.00	26990.00	32780.00	20	6	358	5616	0.0637464387464387	0.692197960294277	0.689693316506503	false	false	false
00f94a9f-e9de-42df-b76c-83be0a7d72c2	2026-08-21 09:45	2026-08-21 09:45	2026-08-21 09:45	HOOD	HOOD260828C00110000	call	110.0000	2026-08-28	3.2400	3.0000	3.2500	106.5600	129550.00	129550.00	0.00	400	28	3581	3983	0.899071051970876	0.795953507829618	0.777695601983018	false	false	false
7b657cba-5e97-4f80-9fe6-ed803dd58202	2026-08-21 09:45	2026-08-21 09:45	2026-08-21 09:45	HOOD	HOOD270219C00110000	call	110.0000	2027-02-19	20.0000	18.4000	20.2500	106.5600	205985.00	201995.00	3990.00	103	5	109	619	0.176090468497577	0.689936151018943	0.688230146542576	false	false	false
fa479c18-8703-4904-a031-b4acb5e190aa	2026-08-21 09:46	2026-08-21 09:46	2026-08-21 09:46	HOOD	HOOD260821C00105000	call	105.0000	2026-08-21	2.4000	2.3900	2.5100	106.4450	121223.00	10800.00	106085.00	505	30	10192	6648	1.53309265944645	1.40997414670186	1.39737626060551	true	false	false
a398a8f2-22bb-4124-9c8d-b5eb56624be9	2026-08-21 09:49	2026-08-21 09:49	2026-08-21 09:49	HOOD	HOOD261120P00090000	put	90.0000	2026-11-20	6.5400	6.3000	6.9000	106.3600	191489.00	0.00	191489.00	293	7	330	4510	0.0731707317073171	0.695144435858349	0.695144435858349	false	false	false
c0465b75-f025-43c0-8e96-b1e437168f06	2026-08-21 09:56	2026-08-21 09:56	2026-08-21 09:56	HOOD	HOOD281215C00220000	call	220.0000	2028-12-15	23.4200	22.5500	24.4000	106.6700	423870.00	421540.00	2330.00	181	10	205	924	0.221861471861472	0.682505494386148	0.680183261981652	false	false	false
30688185-7011-4f4a-8ff1-86bfffb8b0b7	2026-08-21 09:59	2026-08-21 09:58	2026-08-21 09:58	HOOD	HOOD260828C00102000	call	102.0000	2026-08-28	7.2500	6.8500	7.2500	106.6050	1851612.00	1851612.00	0.00	2554	62	3292	585	5.62735042735043	0.787125259709966	0.787125259709966	false	false	false
d67f434a-b859-4d28-bb9e-7e4f5fb28934	2026-08-21 10:04	2026-08-21 10:04	2026-08-21 10:04	HOOD	HOOD280121C00290000	call	290.0000	2028-01-21	9.3900	9.2000	9.6000	108.2900	69516.00	30288.00	39228.00	74	5	394	15338	0.0256878341374364	0.708907335653982	0.70548546344459	false	false	false
015d9158-6ef2-44f8-b951-9fd3af006b16	2026-08-21 10:08	2026-08-21 10:07	2026-08-21 10:07	HOOD	HOOD271217C00095000	call	95.0000	2027-12-17	41.8600	41.5500	42.1500	108.9150	251160.00	150840.00	100320.00	60	5	123	3850	0.0319480519480519	0.711346078832217	0.711346078832217	false	false	false
e76a6686-5799-48d7-9ef3-28e135a0fde1	2026-08-21 10:11	2026-08-21 10:11	2026-08-21 10:11	HOOD	HOOD260828C00110000	call	110.0000	2026-08-28	4.2400	4.2000	4.4000	108.6070	51786.00	0.00	51786.00	122	7	15169	3983	3.80843585237258	0.810237455309226	0.800224368801292	false	false	false
0f1b0134-8cea-4a14-9a6e-5a720d5a323a	2026-08-21 10:16	2026-08-21 10:16	2026-08-21 10:16	HOOD	HOOD270319P00100000	put	100.0000	2027-03-19	17.0800	17.0000	17.4500	106.6650	66600.00	22230.00	40960.00	39	12	117	331	0.353474320241692	0.696148680162576	0.694506562244461	false	false	false
4f82e1c9-e835-4fb9-815b-be55704858ff	2026-08-21 14:15	2026-08-21 14:15	2026-08-21 14:15	HOOD	HOOD260821C00103000	call	103.0000	2026-08-21	5.6000	5.4500	5.6000	108.0000	56540.00	44780.00	0.00	101	26	5795	4831	1.19954460774167	2.36290707102573	2.36290707102573	true	false	false	true
e1dfefc1-b0b2-41ab-a740-39628dc25054	2026-08-21 14:54	2026-08-21 14:54	2026-08-21 14:54	HOOD	HOOD280121C00200000	call	200.0000	2028-01-21	16.3500	15.6000	16.5500	107.8350	181505.00	179870.00	1635.00	111	5	1066	4045	0.263535228677379	0.690106371145484	0.686057705864431	false	false	false
cb52c257-e37b-48c9-8757-785957517ff1	2026-08-21 15:53	2026-08-21 15:53	2026-08-21 15:53	HOOD	HOOD261218C00150000	call	150.0000	2026-12-18	5.6500	5.4000	5.7000	107.8400	66050.00	54800.00	11250.00	117	23	605	3540	0.17090395480226	0.679640887815007	0.679640887815007	false	false	false
b3faa44b-7d78-49f2-8c84-b4c67419bb11	2026-08-21 15:54	2026-08-21 15:54	2026-08-21 15:54	HOOD	HOOD260828P00109000	put	109.0000	2026-08-28	4.6500	4.4500	4.6500	108.2300	62763.00	62763.00	0.00	135	23	739	19	38.8947368421053	0.716452180561864	0.716452180561864	false	false	false	true
7ee56b6e-885e-4083-aa4a-d4e9bd37ac79	2026-08-21 15:56	2026-08-21 15:56	2026-08-21 15:56	HOOD	HOOD260828C00115000	call	115.0000	2026-08-28	1.9700	1.9300	2.0000	108.0200	120560.00	106398.00	14162.00	613	7	19589	1798	10.8948832035595	0.758192071731696	0.745398321303518	true	false	false
8a076f0a-0404-4b20-a906-a3645255b6de	2026-08-24 10:19	2026-08-24 10:19	2026-08-24 10:19	HOOD	HOOD260828C00108000	call	108.0000	2026-08-28	3.2000	3.1000	3.2500	107.1350	96235.00	95921.00	314.00	301	14	1549	1967	0.787493645144891	0.800684514869752	0.798446816095743	false	false	false
8a6edc36-bf79-4fcd-9873-3dc3e27bba45	2026-08-24 10:30	2026-08-24 10:30	2026-08-24 10:30	HOOD	HOOD260828P00107000	put	107.0000	2026-08-28	3.7000	3.4000	3.7000	106.6800	1299669.00	1299669.00	0.00	3513	70	3749	366	10.2431693989071	0.828544376353883	0.798381249527924	false	false	false
a3972b4f-e28f-45a9-82e1-e32205645feb	2026-08-24 10:31	2026-08-24 10:31	2026-08-24 10:31	HOOD	HOOD261016C00125000	call	125.0000	2026-10-16	4.7000	4.5000	4.7500	106.8750	272101.00	264111.00	7990.00	579	57	667	2152	0.309944237918216	0.650472748848657	0.648845928795217	false	false	false
76299022-179a-4c25-b106-e67442b2a83d	2026-08-24 13:23	2026-08-24 13:23	2026-08-24 13:23	HOOD	HOOD260828C00110000	call	110.0000	2026-08-28	2.1400	2.1300	2.2000	106.8522	67859.00	3655.00	64204.00	317	8	14577	14349	1.01588960903199	0.769702606667004	0.764991225685113	true	false	false
bbcbc6d5-c6a1-44da-925d-c6025f780fd1	2026-08-24 13:23	2026-08-24 13:23	2026-08-24 13:23	HOOD	HOOD260828C00110000	call	110.0000	2026-08-28	2.1300	2.1200	2.1900	106.8400	50057.00	2769.00	47288.00	235	35	14834	14349	1.03380026482682	0.768427621131956	0.763712586427259	true	false	false
7684e6ca-c02f-49cb-ae0a-11f90b9d6db4	2026-08-24 15:44	2026-08-24 15:44	2026-08-24 15:44	HOOD	HOOD260828C00105000	call	105.0000	2026-08-28	2.6600	2.6000	2.6700	103.6206	53280.00	53280.00	0.00	200	5	2259	4086	0.552863436123348	0.756701992334698	0.754373832654696	false	false	false
207135ea-c3c8-420c-900c-d45569aea02b	2026-08-24 15:54	2026-08-24 15:53	2026-08-24 15:53	HOOD	HOOD260828C00100000	call	100.0000	2026-08-28	5.0000	5.0000	5.1500	103.2300	150012.00	0.00	150012.00	300	32	1039	4754	0.218552797644089	0.73258506896192	0.729174766228306	false	false	false
4fd1acb3-d1cb-475b-bf03-7ef1b2c22b24	2026-08-25 11:50	2026-08-25 11:50	2026-08-25 11:50	HOOD	HOOD270416C00120000	call	120.0000	2027-04-16	21.4500	21.0000	21.5000	110.8100	57905.00	53650.00	4255.00	27	7	28	67	0.417910447761194	0.680373320780094	0.674638609609906	false	false	false
99b9aba7-f22a-4dc5-9196-a9007bdbf599	2026-08-25 11:50	2026-08-25 11:50	2026-08-25 11:50	HOOD	HOOD270917C00115000	call	115.0000	2027-09-17	31.2000	30.3000	32.5000	110.7700	614565.00	102885.00	511680.00	197	9	377	4	94.25	0.692548825585438	0.690201049898209	false	false	false	true
d5b7bb14-badd-4550-9737-55897dbbe607	2026-08-25 14:11	2026-08-25 14:11	2026-08-25 14:11	HOOD	HOOD261016C00135000	call	135.0000	2026-10-16	4.1500	4.0000	4.2000	111.0000	112043.00	69303.00	5805.00	270	38	652	1100	0.592727272727273	0.664193313103518	0.66438775437121	false	false	false
45a84dff-319d-46a8-a781-d02ff53fa939	2026-08-25 14:58	2026-08-25 14:58	2026-08-25 14:58	HOOD	HOOD271217C00155000	call	155.0000	2027-12-17	24.2800	23.0000	24.9000	112.3000	63120.00	12300.00	50820.00	26	8	28	1888	0.0148305084745763	0.687253630638944	0.679449737317493	true	false	false
aaf074ac-8780-40a8-ae05-e88fbed14e71	2026-08-26 10:00	2026-08-26 10:00	2026-08-26 10:00	HOOD	HOOD260918P00110000	put	110.0000	2026-09-18	6.5200	6.5000	6.7500	110.5900	163680.00	35370.00	128310.00	251	16	659	5313	0.12403538490495	0.632664988947401	0.632256310819945	true	false	false
cf412797-1c2c-4607-b254-a988c253bb91	2026-08-26 10:00	2026-08-26 10:00	2026-08-26 10:00	HOOD	HOOD260918P00110000	put	110.0000	2026-09-18	6.4200	6.4000	6.6500	110.6200	125255.00	58050.00	67205.00	195	17	2740	5313	0.515716167890081	0.626009864851894	0.624378580734903	true	false	false