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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = HOOD×

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

373b9bcf-83d2-49e3-9618-7b9250b5d707	2026-09-28 11:40	2026-09-28 11:40	2026-09-28 11:40	HOOD	HOOD261030C00130000	call	130.0000	2026-10-30	4.1500	4.0500	4.1500	116.3700	12448.00	12448.00	0.00	30	6	169	1209	0.139784946236559	0.639833032476925	0.639833032476925	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Technology	92076797052.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T15:41:44.430959Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
4c5177ae-51d6-4337-bff5-a5e9a7cc61fe	2026-09-28 11:33	2026-09-28 11:33	2026-09-28 11:33	HOOD	HOOD270319C00130000	call	130.0000	2027-03-19	15.9500	15.9000	16.6500	116.2600	35090.00	30305.00	4785.00	22	5	34	1418	0.0239774330042313	0.636189188546035	0.636189188546035	false	false	false
54bc5b5a-99c6-41ab-a54f-360cc126d997	2026-09-28 11:33	2026-09-28 11:33	2026-09-28 11:33	HOOD	HOOD270319C00160000	call	160.0000	2027-03-19	8.7500	8.7000	9.3000	116.3200	80500.00	0.00	80500.00	92	10	98	967	0.10134436401241	0.643110635963723	0.641368705656372	false	false	false	true
f704c7ec-fe63-4617-b1e9-f06724ce7d97	2026-09-28 11:27	2026-09-28 11:27	2026-09-28 11:27	HOOD	HOOD261002C00117000	call	117.0000	2026-10-02	3.2800	3.2000	3.3000	116.5200	32810.00	32810.00	0.00	100	5	623	477	1.30607966457023	0.716022843668293	0.716022843668293	false	false	false	true
38ce2302-5c9b-469a-9376-0e7733c9626c	2026-09-28 11:23	2026-09-28 11:23	2026-09-28 11:23	HOOD	HOOD261002P00116000	put	116.0000	2026-10-02	3.2500	3.1500	3.2500	116.0000	13000.00	13000.00	0.00	40	6	645	1089	0.59228650137741	0.715572070963913	0.715572070963913	false	false	false	true
2c71f53f-d742-40dc-b918-e22c53749aef	2026-09-28 11:23	2026-09-28 11:23	2026-09-28 11:23	HOOD	HOOD261016C00125000	call	125.0000	2026-10-16	3.2000	3.2000	3.3000	116.0000	32000.00	0.00	32000.00	100	16	720	7632	0.0943396226415094	0.612769259573509	0.612769259573509	false	false	false
cc929c3f-2f22-4f04-8e0a-287cb49b3a72	2026-09-28 11:20	2026-09-28 11:20	2026-09-28 11:20	HOOD	HOOD261002C00120000	call	120.0000	2026-10-02	2.0800	2.0600	2.1300	116.0000	21444.00	1248.00	19364.00	103	18	2648	9641	0.27466030494762	0.726653339946653	0.722670160502406	false	false	false
47a06caf-aed2-4a12-956c-38d9bcf62e0c	2026-09-28 11:18	2026-09-28 11:18	2026-09-28 11:18	HOOD	HOOD270617C00180000	call	180.0000	2027-06-17	10.4500	10.1500	10.4500	116.0000	13585.00	13585.00	0.00	13	5	46	632	0.0727848101265823	0.651127634391505	0.651127634391505	false	false	false
643659a4-9fb0-4480-87ef-c2189e599ca7	2026-09-28 11:14	2026-09-28 11:14	2026-09-28 11:14	HOOD	HOOD261120C00120000	call	120.0000	2026-11-20	10.5000	10.5000	10.6000	116.0000	13650.00	0.00	13650.00	13	5	609	10066	0.0605006954102921	0.652666291239587	0.652666291239587	false	false	false
40e871d8-3c69-41c2-99f0-c2587dec9144	2026-09-28 11:14	2026-09-28 11:14	2026-09-28 11:14	HOOD	HOOD261002C00120000	call	120.0000	2026-10-02	2.2100	2.1800	2.2200	116.0000	44203.00	43983.00	220.00	200	28	2474	9641	0.256612384607406	0.719641572292234	0.721793752977902	false	false	false
b2e45e08-dbb6-4ba2-bc33-55edbdea6555	2026-09-28 11:12	2026-09-28 11:12	2026-09-28 11:12	HOOD	HOOD261002P00110000	put	110.0000	2026-10-02	0.9600	0.9600	0.9800	116.8300	15264.00	0.00	15264.00	159	13	2782	2893	0.961631524369167	0.703124814020878	0.703124814020878	false	false	false
adc5e10d-8307-453b-81d0-29046106f17d	2026-09-28 11:12	2026-09-28 11:12	2026-09-28 11:12	HOOD	HOOD261002P00109000	put	109.0000	2026-10-02	0.7700	0.7700	0.7900	116.8300	15246.00	0.00	15246.00	198	34	2002	348	5.75287356321839	0.705734832193214	0.705734832193214	false	false	false	true
bf9c6712-7725-4401-b258-35359528fa6f	2026-09-28 11:12	2026-09-28 11:12	2026-09-28 11:12	HOOD	HOOD261002P00109000	put	109.0000	2026-10-02	0.7800	0.7800	0.8000	116.8299	19500.00	0.00	19500.00	250	8	1604	348	4.60919540229885	0.709041579295423	0.709041579295423	false	false	false	true
58d7e77a-3d82-4511-9d77-e8f0eeefa529	2026-09-28 11:11	2026-09-28 11:11	2026-09-28 11:11	HOOD	HOOD261002P00108000	put	108.0000	2026-10-02	0.6200	0.6100	0.6400	116.9650	12752.00	0.00	12752.00	206	9	1649	978	1.68609406952965	0.714858032433934	0.718632646763874	false	false	false	true
0db31a40-0481-4f18-9488-9abccefc131a	2026-09-28 11:11	2026-09-28 11:11	2026-09-28 11:11	HOOD	HOOD261002P00108000	put	108.0000	2026-10-02	0.6000	0.6000	0.6400	117.0300	18960.00	0.00	18960.00	316	6	1442	978	1.47443762781186	0.714339154849632	0.714339154849632	false	false	false	true
92a78b30-ee59-4ea4-b4ad-6e30f0d23128	2026-09-28 11:09	2026-09-28 11:09	2026-09-28 11:09	HOOD	HOOD261023C00120000	call	120.0000	2026-10-23	6.2500	6.2000	6.3500	117.0600	14375.00	0.00	14375.00	23	6	60	1222	0.0490998363338789	0.6060852326042	0.6060852326042	true	false	false	true
231e5e3a-b20f-41a8-96c5-5cd35c031324	2026-09-28 11:09	2026-09-28 11:09	2026-09-28 11:09	HOOD	HOOD261002P00111000	put	111.0000	2026-10-02	1.1800	1.1800	1.2000	117.0000	94400.00	0.00	94400.00	800	6	1216	779	1.5609756097561	0.709840169927996	0.709840169927996	false	false	false	true
5044b387-4519-4f91-833b-52eb70092cec	2026-09-28 11:06	2026-09-28 11:06	2026-09-28 11:06	HOOD	HOOD261002P00109000	put	109.0000	2026-10-02	0.8000	0.7800	0.8000	116.8800	16800.00	16800.00	0.00	210	8	718	348	2.0632183908046	0.718352835929762	0.718352835929762	false	false	false	true
62caa3f5-2bf5-4def-889e-aca36470e13a	2026-09-28 11:04	2026-09-28 11:04	2026-09-28 11:04	HOOD	HOOD261009C00125000	call	125.0000	2026-10-09	2.3000	2.3000	2.3400	116.9999	34500.00	0.00	34500.00	150	6	405	1123	0.360641139804096	0.636983687787409	0.636983687787409	false	false	false
f28f494f-6cc5-47f6-8ba4-fb9829f2ad0d	2026-09-28 11:00	2026-09-28 10:59	2026-09-28 10:59	HOOD	HOOD270319C00155000	call	155.0000	2027-03-19	9.8500	9.8500	10.0000	117.0499	12805.00	0.00	12805.00	13	5	76	737	0.103120759837178	0.639377254990381	0.639377254990381	false	false	false	true
dc3a9b82-e495-480f-b3b7-4d5cac4d9294	2026-09-28 10:59	2026-09-28 10:59	2026-09-28 10:59	HOOD	HOOD270219C00150000	call	150.0000	2027-02-19	9.2000	9.1500	9.2000	117.0150	27600.00	27600.00	0.00	30	5	53	3301	0.016055740684641	0.641045125700252	0.641045125700252	false	false	false	true
eb5c6e31-ffed-46cb-9474-577cb0dc8069	2026-09-28 10:59	2026-09-28 10:59	2026-09-28 10:59	HOOD	HOOD261218C00140000	call	140.0000	2026-12-18	6.8000	6.8000	6.9500	117.0300	36720.00	0.00	36720.00	54	5	250	3040	0.0822368421052632	0.638320058736622	0.638320058736622	false	false	false
dc06cfcd-42dd-4199-a065-2c8862fd908a	2026-09-28 10:57	2026-09-28 10:57	2026-09-28 10:57	HOOD	HOOD261002C00117000	call	117.0000	2026-10-02	3.6500	3.6500	3.7500	117.1400	18260.00	0.00	18260.00	50	17	505	477	1.05870020964361	0.727095390240202	0.729143120399883	false	false	false	true
720948be-8ecf-4c9f-96c1-2aacf3a3aeb8	2026-09-28 10:56	2026-09-28 10:56	2026-09-28 10:56	HOOD	HOOD261009C00116000	call	116.0000	2026-10-09	5.8500	5.7000	5.8500	117.1414	17550.00	17550.00	0.00	30	7	144	511	0.281800391389432	0.642785153562305	0.642785153562305	false	false	false	true
853697c3-65a2-40a0-bace-0bf101ba858b	2026-09-28 10:51	2026-09-28 10:51	2026-09-28 10:51	HOOD	HOOD261002C00125000	call	125.0000	2026-10-02	1.1100	1.0700	1.1100	117.2900	11100.00	11100.00	0.00	100	18	7162	10863	0.659302218539998	0.744095636337343	0.744095636337343	false	false	false
df4cb36f-281c-449c-9205-03a43777795d	2026-09-28 10:51	2026-09-28 10:51	2026-09-28 10:51	HOOD	HOOD261120C00125000	call	125.0000	2026-11-20	8.8000	8.7000	8.8000	117.2400	28160.00	28160.00	0.00	32	5	116	5890	0.0196943972835314	0.654334417067786	0.654334417067786	true	false	false
787488cb-7951-427d-a400-ff4fdebeb682	2026-09-28 10:47	2026-09-28 10:47	2026-09-28 10:47	HOOD	HOOD261016C00120000	call	120.0000	2026-10-16	5.1000	5.0500	5.1500	116.8950	25497.00	22437.00	3060.00	50	7	564	15501	0.0363847493710083	0.614039196664432	0.614039196664432	false	false	false
e4261500-47e1-452f-97d1-b2e78c36c775	2026-09-28 10:44	2026-09-28 10:44	2026-09-28 10:44	HOOD	HOOD261002P00118000	put	118.0000	2026-10-02	4.0000	3.9000	4.0500	117.0350	11600.00	11200.00	0.00	29	5	883	1513	0.583608724388632	0.718525603505326	0.718525603505326	true	false	false	true
877c7d04-b2b2-451d-a9af-eced5e358a47	2026-09-28 10:41	2026-09-28 10:41	2026-09-28 10:41	HOOD	HOOD270917P00115000	put	115.0000	2027-09-17	24.8000	24.7500	24.9500	117.5103	230640.00	7440.00	223200.00	93	9	94	958	0.0981210855949896	0.645137542341462	0.645137542341462	false	false	false
39bf2f20-b1ad-4cb9-9dc7-ad543821a841	2026-09-28 10:36	2026-09-28 10:36	2026-09-28 10:36	HOOD	HOOD261002C00125000	call	125.0000	2026-10-02	1.2000	1.2000	1.2200	117.7650	10200.00	0.00	10200.00	85	9	6316	10863	0.581423179600479	0.739306742797919	0.739306742797919	false	false	false
df650b36-1abf-4219-94eb-3b31d7f6fdbb	2026-09-28 10:36	2026-09-28 10:36	2026-09-28 10:36	HOOD	HOOD261218P00115000	put	115.0000	2026-12-18	11.8500	11.6500	11.8500	117.9248	548612.00	548612.00	0.00	463	36	562	1119	0.502234137622878	0.633931837742818	0.633931837742818	false	false	false
6ff02afc-5cc7-4608-89f1-98392f2c688a	2026-09-28 10:35	2026-09-28 10:35	2026-09-28 10:35	HOOD	HOOD270319C00165000	call	165.0000	2027-03-19	8.3400	8.2500	9.0500	117.8000	15020.00	4170.00	10015.00	18	8	18	440	0.0409090909090909	0.643462130881069	0.641708455071966	true	false	false
09607ce7-380e-4b67-831a-382db086a076	2026-09-28 10:30	2026-09-28 10:30	2026-09-28 10:30	HOOD	HOOD280121C00155000	call	155.0000	2028-01-21	25.9700	25.9500	27.1500	118.0000	23375.00	2605.00	20770.00	9	5	9	386	0.0233160621761658	0.647872777128531	0.647872777128531	true	false	false
251bd38f-f002-40cf-99ea-3d648eaae9e9	2026-09-28 10:29	2026-09-28 10:29	2026-09-28 10:29	HOOD	HOOD270115C00140000	call	140.0000	2027-01-15	9.2000	9.1500	9.5000	118.0000	24845.00	20245.00	4600.00	27	5	49	10120	0.00484189723320158	0.62653475354868	0.62653475354868	false	false	false
4c3ae4f3-eb8c-4eeb-b5ba-5aa9b27c091d	2026-09-28 10:19	2026-09-28 10:19	2026-09-28 10:19	HOOD	HOOD261106P00121000	put	121.0000	2026-11-06	11.1500	11.1000	11.4500	118.9200	13380.00	2230.00	11150.00	12	5	12	0	0	0.665249687294474	0.665249687294474	false	false	false	true
5f59cf07-8d71-4a66-9f3e-f6f834bf0cff	2026-09-28 10:19	2026-09-28 10:19	2026-09-28 10:19	HOOD	HOOD261002C00117000	call	117.0000	2026-10-02	4.6000	4.6000	4.7000	118.8450	11040.00	0.00	11040.00	24	7	124	477	0.259958071278826	0.72560351637757	0.72560351637757	true	false	false	true
8b68c723-8f5a-4d43-99fb-12d63686ac8b	2026-09-28 10:18	2026-09-28 10:18	2026-09-28 10:18	HOOD	HOOD261009C00116000	call	116.0000	2026-10-09	6.8000	6.8000	6.8500	118.9600	21080.00	0.00	21080.00	31	9	107	511	0.209393346379648	0.62756074945804	0.62756074945804	false	false	false	true
2614aedb-2664-4c2e-bc50-58564077f63a	2026-09-28 10:06	2026-09-28 10:06	2026-09-28 10:06	HOOD	HOOD280121C00175000	call	175.0000	2028-01-21	21.8500	21.7000	22.7500	118.5000	34956.00	0.00	32766.00	16	8	16	568	0.028169014084507	0.649633076283169	0.647044763918438	false	false	false
028a1753-1e40-46b1-a87e-e19b348865ed	2026-09-28 10:05	2026-09-28 10:05	2026-09-28 10:05	HOOD	HOOD261002C00125000	call	125.0000	2026-10-02	1.5100	1.5000	1.5300	118.6950	13288.00	0.00	13288.00	88	7	4489	10863	0.413237595507687	0.758222578311824	0.758222578311824	true	false	false
390e6588-206a-4a71-894d-4dcdb2a21222	2026-09-28 10:03	2026-09-28 10:03	2026-09-28 10:03	HOOD	HOOD261002C00111000	call	111.0000	2026-10-02	9.1900	9.1000	9.3500	119.1100	12870.00	0.00	12870.00	14	6	85	186	0.456989247311828	0.726978292943123	0.762803141456142	true	false	false	true
8385c502-8339-4e63-858f-673ae324b618	2026-09-28 10:01	2026-09-28 10:01	2026-09-28 10:01	HOOD	HOOD261218P00095000	put	95.0000	2026-12-18	3.8500	3.8500	4.1500	119.4800	38905.00	395.00	38510.00	101	25	103	1918	0.0537017726798749	0.638344025795501	0.645275427962054	false	false	false
d96d2623-1384-4e05-8a7a-761ed7bbaeca	2026-09-28 09:59	2026-09-28 09:59	2026-09-28 09:59	HOOD	HOOD261023P00108000	put	108.0000	2026-10-23	2.7900	2.7100	2.7900	119.0000	18414.00	18414.00	0.00	66	14	67	281	0.238434163701068	0.603444551642067	0.603444551642067	false	false	false	true
1deb0e0a-ab95-4213-8fd6-b91cc614118e	2026-09-28 09:55	2026-09-28 09:54	2026-09-28 09:54	HOOD	HOOD280121C00290000	call	290.0000	2028-01-21	9.1500	9.1500	9.5500	119.3499	45750.00	0.00	45750.00	50	7	144	15347	0.00938294129145761	0.660639681168725	0.660639681168725	false	false	false
3dd03dc2-fe81-4305-86f6-1314eb42d79a	2026-09-28 09:47	2026-09-28 09:47	2026-09-28 09:47	HOOD	HOOD270115P00110000	put	110.0000	2027-01-15	10.7500	10.4500	10.7500	119.1900	2763489.00	2763489.00	0.00	2571	62	2575	4419	0.582711020592894	0.626791378691859	0.626791378691859	false	false	false
d313138d-e850-4403-a05e-f57b71b1e4c8	2026-09-28 09:47	2026-09-28 09:46	2026-09-28 09:46	HOOD	HOOD261002C00125000	call	125.0000	2026-10-02	1.6500	1.6500	1.6700	119.1900	14520.00	0.00	14520.00	88	10	2644	10863	0.243395010586394	0.758458720256304	0.758458720256304	false	false	false
fbea4315-17fa-4af5-9d82-2bf1a4ba6e95	2026-09-28 09:46	2026-09-28 09:46	2026-09-28 09:46	HOOD	HOOD261002C00125000	call	125.0000	2026-10-02	1.6500	1.6500	1.6800	119.2200	13202.00	0.00	13035.00	80	29	2463	10863	0.226732946699807	0.746217974050697	0.761096752549394	false	false	false
1cd3e66e-22c6-472a-9322-4b0b10110ea8	2026-09-28 09:46	2026-09-28 09:46	2026-09-28 09:46	HOOD	HOOD261023C00121000	call	121.0000	2026-10-23	6.9500	6.9000	7.0000	119.4700	12510.00	2085.00	10425.00	18	8	32	137	0.233576642335766	0.600699141767336	0.601511032192572	false	false	false
7536b1a3-5d8c-45fd-8426-32bf0b8dd260	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	HOOD	HOOD261002C00135000	call	135.0000	2026-10-02	0.3600	0.3600	0.3900	119.5400	10800.00	0.00	10800.00	300	12	446	3103	0.143731872381566	0.804716727006782	0.804716727006782	false	false	false
7a9de037-02a1-4ff2-b28b-55056e57e431	2026-09-28 09:43	2026-09-28 09:43	2026-09-28 09:43	HOOD	HOOD261002C00125000	call	125.0000	2026-10-02	1.8000	1.7700	1.8400	119.5700	10065.00	183.00	9882.00	56	17	1577	10863	0.145171683696953	0.757139679933726	0.773787497144233	false	false	false
2a7cc944-184d-4cdd-bc7d-d11fbb2a4593	2026-09-28 09:43	2026-09-28 09:43	2026-09-28 09:43	HOOD	HOOD261002C00125000	call	125.0000	2026-10-02	1.8300	1.8100	1.8600	119.6600	10995.00	2760.00	8235.00	60	6	1453	10863	0.133756789100617	0.767488752526407	0.769752700380024	false	false	false