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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×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	strike

2f1aa885-a862-497f-9aac-e86ff0a7d6ee	2026-10-01 15:57	2026-10-01 15:57	2026-10-01 15:57	HOOD	HOOD261002C00118000	call	118.0000	2026-10-02	0.1000	0.1000	0.1200	111.0500	15430.00	0.00	15430.00	1543	6	7531	4010	1.87805486284289	0.721556934506426	0.722412884740536	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	87878550509.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T19:58:45.768472Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
9589cb8a-6ee4-4aad-8cd8-02ae73e830a8	2026-10-01 15:54	2026-10-01 15:54	2026-10-01 15:54	HOOD	HOOD261002P00109000	put	109.0000	2026-10-02	0.5900	0.5700	0.5900	111.1750	17641.00	17641.00	0.00	299	13	1217	2687	0.45292147376256	0.619677182093039	0.619677182093039	false	false	false
4ff00d1f-b447-47e4-90d4-ab92271b6a04	2026-10-01 15:54	2026-10-01 15:54	2026-10-01 15:54	HOOD	HOOD261002C00114000	call	114.0000	2026-10-02	0.5300	0.5300	0.5500	111.1750	12773.00	0.00	12773.00	241	46	5836	1979	2.94896412329459	0.6577215543579	0.6577215543579	true	false	false
34629e84-9ce8-4083-9342-018b41349151	2026-10-01 15:54	2026-10-01 15:54	2026-10-01 15:54	HOOD	HOOD261002C00114000	call	114.0000	2026-10-02	0.5400	0.5400	0.5700	111.1700	16146.00	0.00	16146.00	299	32	5595	1979	2.82718544719555	0.661263451101889	0.663910566797077	true	false	false
cfa391dd-dffb-4b8d-bd5e-9200ade2fa44	2026-10-01 15:53	2026-10-01 15:53	2026-10-01 15:53	HOOD	HOOD261120P00085000	put	85.0000	2026-11-20	1.4000	1.3600	1.4100	111.2000	21140.00	21140.00	0.00	151	8	1364	2933	0.465052846914422	0.640570750865276	0.640570750865276	false	false	false
3f45edf8-a890-4d70-a62d-dabf6be350bf	2026-10-01 15:47	2026-10-01 15:47	2026-10-01 15:47	HOOD	HOOD261016P00107000	put	107.0000	2026-10-16	2.8500	2.8500	2.8800	111.5500	26505.00	0.00	26505.00	93	5	304	530	0.573584905660377	0.549769292492098	0.549769292492098	false	false	false
d1929e01-6000-403f-b549-19450751a833	2026-10-01 15:41	2026-10-01 15:41	2026-10-01 15:41	HOOD	HOOD270115C00150000	call	150.0000	2027-01-15	4.6000	4.6000	4.6500	111.9200	58420.00	0.00	58420.00	127	6	656	15149	0.0433031883292627	0.6103856753525	0.6103856753525	false	false	false
5d6a7a7d-be3d-4555-887a-2a0805af6fd1	2026-10-01 15:30	2026-10-01 15:30	2026-10-01 15:30	HOOD	HOOD270115C00115000	call	115.0000	2027-01-15	13.6500	13.5500	13.8000	111.0000	13650.00	10920.00	2730.00	10	6	291	2952	0.0985772357723577	0.600964886448773	0.600964886448773	false	false	false
672eeebf-a8a0-4a7d-86ca-ee8b55e843e0	2026-10-01 14:41	2026-10-01 14:41	2026-10-01 14:41	HOOD	HOOD261002C00118000	call	118.0000	2026-10-02	0.1400	0.1300	0.1400	111.7800	14000.00	14000.00	0.00	1000	36	4434	4010	1.10573566084788	0.711535094307014	0.711535094307014	false	false	false
02d6402a-5f4b-455a-8dde-9691a94bbeb0	2026-10-01 14:41	2026-10-01 14:41	2026-10-01 14:41	HOOD	HOOD261009C00117000	call	117.0000	2026-10-09	1.6900	1.6800	1.7200	111.6800	45778.00	42250.00	3528.00	271	7	2834	581	4.87779690189329	0.551522313885015	0.551522313885015	false	false	false
1d0bda52-5bb8-4d93-ba15-dcc4fdefb321	2026-10-01 14:40	2026-10-01 14:40	2026-10-01 14:40	HOOD	HOOD270219C00155000	call	155.0000	2027-02-19	5.9500	5.8000	5.9500	111.7450	16065.00	16065.00	0.00	27	6	54	383	0.140992167101828	0.621320106109263	0.621320106109263	false	false	false
6f219214-3495-49a1-b559-09b2f8d6bc21	2026-10-01 14:29	2026-10-01 14:29	2026-10-01 14:29	HOOD	HOOD261009P00114000	put	114.0000	2026-10-09	4.8500	4.8500	5.0000	111.7100	16490.00	0.00	16490.00	34	5	169	311	0.543408360128617	0.544603135392053	0.548191989389355	false	false	false
0f259016-3cb4-4e3f-9f88-660379bfe124	2026-10-01 14:29	2026-10-01 14:29	2026-10-01 14:29	HOOD	HOOD261009C00112000	call	112.0000	2026-10-09	3.5500	3.5500	3.6500	111.7000	217260.00	0.00	217260.00	612	49	1482	349	4.24641833810888	0.552887668110912	0.552887668110912	false	false	false
d6d8be0b-b3b4-4ac8-baf2-09522f8bee41	2026-10-01 14:06	2026-10-01 14:06	2026-10-01 14:06	HOOD	HOOD261023C00105000	call	105.0000	2026-10-23	9.8000	9.8000	9.9000	111.3015	31360.00	0.00	31360.00	32	5	42	163	0.257668711656442	0.563669693177684	0.563669693177684	false	false	false
597abad2-cb37-4cb2-84bc-eb846e7e11d9	2026-10-01 13:49	2026-10-01 13:49	2026-10-01 13:49	HOOD	HOOD261002C00113000	call	113.0000	2026-10-02	1.1000	1.0900	1.1100	111.0000	22000.00	19360.00	0.00	200	6	7676	1767	4.34408602150538	0.673228830113174	0.673228830113174	false	false	false
d18504ed-cd8e-4d67-910a-8128b93c0e3a	2026-10-01 13:47	2026-10-01 13:47	2026-10-01 13:47	HOOD	HOOD261030P00103000	put	103.0000	2026-10-30	3.4500	3.1500	3.4500	112.0200	16215.00	16215.00	0.00	47	8	59	642	0.0919003115264797	0.595582246682467	0.595582246682467	false	false	false
883ae0fa-a5d6-4da7-9241-7a89920aec80	2026-10-01 13:47	2026-10-01 13:47	2026-10-01 13:47	HOOD	HOOD261030P00104000	put	104.0000	2026-10-30	3.8000	3.5000	3.8000	112.0200	99180.00	99180.00	0.00	261	10	284	1056	0.268939393939394	0.596394332103763	0.596394332103763	false	false	false
ae2f14fb-6f92-440b-b8c9-792042a39763	2026-10-01 13:44	2026-10-01 13:44	2026-10-01 13:44	HOOD	HOOD261002C00115000	call	115.0000	2026-10-02	0.5600	0.5400	0.5600	112.0000	11144.00	11144.00	0.00	199	9	9886	5395	1.832437442076	0.688756666166336	0.688756666166336	false	false	false
9664cc6a-fce6-4afc-9822-b50e4deb870e	2026-10-01 13:39	2026-10-01 13:39	2026-10-01 13:39	HOOD	HOOD261023C00110000	call	110.0000	2026-10-23	7.0000	7.0000	7.1000	111.6700	14000.00	0.00	14000.00	20	7	86	404	0.212871287128713	0.5521622898343	0.5521622898343	true	false	false
831b7cb9-d20d-4d04-bb2e-44903d9eeaac	2026-10-01 13:33	2026-10-01 13:33	2026-10-01 13:33	HOOD	HOOD261009C00112000	call	112.0000	2026-10-09	3.9000	3.9000	3.9500	112.0000	14040.00	0.00	14040.00	36	5	764	349	2.189111747851	0.549661260425721	0.549661260425721	false	false	false
c38c1563-6fb4-4fed-a847-2dec8c364c11	2026-10-01 13:31	2026-10-01 13:31	2026-10-01 13:31	HOOD	HOOD261106C00125000	call	125.0000	2026-11-06	4.6500	4.6000	4.8000	112.0000	16275.00	0.00	15345.00	35	12	61	250	0.244	0.635009089994104	0.635009089994104	true	false	false
4c467f2b-b72f-4a95-ad12-ecc30ecfc8b8	2026-10-01 13:31	2026-10-01 13:31	2026-10-01 13:31	HOOD	HOOD261106C00123000	call	123.0000	2026-11-06	5.2000	5.2000	5.3500	112.0000	11440.00	0.00	11440.00	22	7	52	19	2.73684210526316	0.633309845870914	0.633309845870914	true	false	false
01565b9f-9861-4c74-b888-4d3bd49d30fc	2026-10-01 13:31	2026-10-01 13:31	2026-10-01 13:31	HOOD	HOOD261106C00122000	call	122.0000	2026-11-06	5.5000	5.4500	5.6500	112.0000	13200.00	0.00	13200.00	24	12	36	41	0.878048780487805	0.632785262325349	0.632785262325349	true	false	false
f9663fce-f4e2-43a7-9978-3d35e772b193	2026-10-01 13:30	2026-10-01 13:30	2026-10-01 13:30	HOOD	HOOD261023C00115000	call	115.0000	2026-10-23	5.3000	5.2000	5.3000	112.0000	49814.00	49814.00	0.00	94	11	141	380	0.371052631578947	0.558118230829393	0.558118230829393	true	false	false
c1c70e6a-cbe8-46f2-8e78-2bb78a53eb91	2026-10-01 13:30	2026-10-01 13:30	2026-10-01 13:30	HOOD	HOOD261023C00120000	call	120.0000	2026-10-23	3.5000	3.4000	3.5000	112.0000	11200.00	11200.00	0.00	32	6	263	1727	0.152287203242617	0.559804573720436	0.559804573720436	false	false	false
b84e5d88-ee91-46ef-bca6-4820a15a69e4	2026-10-01 13:30	2026-10-01 13:30	2026-10-01 13:30	HOOD	HOOD261023C00116000	call	116.0000	2026-10-23	4.9000	4.7500	4.9000	112.0000	42625.00	42625.00	0.00	87	13	140	301	0.465116279069767	0.559085875750817	0.559085875750817	false	false	false
b6dc0b8f-6655-4f7f-8880-5c58adff8022	2026-10-01 13:30	2026-10-01 13:30	2026-10-01 13:30	HOOD	HOOD261023C00122000	call	122.0000	2026-10-23	3.0500	3.0500	3.1000	112.0000	55205.00	0.00	55205.00	181	6	194	148	1.31081081081081	0.572304176621734	0.572304176621734	true	false	false
2e866d22-069a-48d3-89c4-80b169b64ca7	2026-10-01 13:30	2026-10-01 13:30	2026-10-01 13:30	HOOD	HOOD261023C00111000	call	111.0000	2026-10-23	7.2000	7.0000	7.2000	112.0000	11520.00	11520.00	0.00	16	5	89	141	0.631205673758865	0.558615573513391	0.558615573513391	false	false	false
23fccd0b-67d0-41e3-8c31-8dfc4ac9ca94	2026-10-01 13:30	2026-10-01 13:30	2026-10-01 13:30	HOOD	HOOD261023C00118000	call	118.0000	2026-10-23	4.1500	4.0500	4.1500	112.0000	17845.00	17845.00	0.00	43	7	67	519	0.129094412331407	0.559030761855703	0.559030761855703	false	false	false
dc420057-b33c-4080-a0d9-d3cf7ca6634a	2026-10-01 13:30	2026-10-01 13:30	2026-10-01 13:30	HOOD	HOOD261106C00126000	call	126.0000	2026-11-06	4.3500	4.2000	4.4000	112.0000	43065.00	42630.00	435.00	99	14	103	21	4.90476190476191	0.631726726080274	0.631726726080274	false	false	false
c1449f1d-07f5-4163-b2fa-9bc50174b0dc	2026-10-01 13:30	2026-10-01 13:30	2026-10-01 13:30	HOOD	HOOD261106C00123000	call	123.0000	2026-11-06	5.1500	5.0000	5.1500	112.0000	10300.00	10300.00	0.00	20	5	26	19	1.36842105263158	0.628880839107517	0.628602502345243	false	false	false
87e40b0f-d315-4227-a2a7-07560446d828	2026-10-01 13:30	2026-10-01 13:30	2026-10-01 13:30	HOOD	HOOD261106C00128000	call	128.0000	2026-11-06	3.8900	3.7500	3.9500	112.0000	10904.00	8954.00	1950.00	28	7	52	62	0.838709677419355	0.63524603726109	0.63524603726109	false	false	false
77e7f39b-4fbd-48f3-9398-4626b4e23e65	2026-10-01 13:30	2026-10-01 13:30	2026-10-01 13:30	HOOD	HOOD261106C00118000	call	118.0000	2026-11-06	6.8000	6.7500	6.8000	112.0000	36040.00	36040.00	0.00	53	5	60	35	1.71428571428571	0.626404961593134	0.626404961593134	false	false	false
67fc7c41-5604-4219-a8e4-e95c825a491f	2026-10-01 13:30	2026-10-01 13:30	2026-10-01 13:30	HOOD	HOOD261106C00127000	call	127.0000	2026-11-06	4.1000	3.9500	4.1500	112.0000	18040.00	17630.00	410.00	44	9	56	26	2.15384615384615	0.631960378427225	0.631960378427225	false	false	false
5f274f26-6779-498d-ba71-7d4d04787f27	2026-10-01 13:30	2026-10-01 13:30	2026-10-01 13:30	HOOD	HOOD261002C00116000	call	116.0000	2026-10-02	0.5000	0.4900	0.5100	112.0000	10000.00	9750.00	0.00	200	43	4491	3740	1.20080213903743	0.69890416888398	0.696400197178172	false	false	false
ad5f013e-e317-42e7-8ed3-030c4d3ccdaf	2026-10-01 13:28	2026-10-01 13:28	2026-10-01 13:28	HOOD	HOOD261016C00115000	call	115.0000	2026-10-16	3.8500	3.8000	3.9000	112.2050	15785.00	13475.00	0.00	41	8	1248	3705	0.336842105263158	0.5499850404649	0.5499850404649	true	false	false
0d5b2d0f-8e9d-44d5-9940-f07e4101533e	2026-10-01 13:23	2026-10-01 13:22	2026-10-01 13:22	HOOD	HOOD261120C00120000	call	120.0000	2026-11-20	7.2000	7.1500	7.2500	111.9950	12960.00	1440.00	2880.00	18	5	385	10534	0.0365483197265996	0.613799864881205	0.613799864881205	false	false	false
c01d894d-0dc7-40e5-9aa4-42815b36c289	2026-10-01 13:23	2026-10-01 13:22	2026-10-01 13:22	HOOD	HOOD261009C00112000	call	112.0000	2026-10-09	3.6500	3.6000	3.7000	111.9600	10950.00	3650.00	0.00	30	7	682	349	1.9541547277937	0.547825667818088	0.547825667818088	false	false	false
2ed4b892-e287-44ff-b5e0-ec50cd103507	2026-10-01 13:22	2026-10-01 13:22	2026-10-01 13:22	HOOD	HOOD261009C00122000	call	122.0000	2026-10-09	0.8300	0.7900	0.8300	111.9300	16600.00	16600.00	0.00	200	11	964	1763	0.546795235394214	0.576108196667792	0.576108196667792	false	false	false
578500db-ab9a-4ac0-b8a3-93c9ec4069ac	2026-10-01 13:21	2026-10-01 13:21	2026-10-01 13:21	HOOD	HOOD270617P00100000	put	100.0000	2027-06-17	14.9000	14.8500	14.9500	111.7600	59600.00	2980.00	0.00	40	8	141	805	0.175155279503106	0.62289214186518	0.62289214186518	false	false	false
3bb3d62c-33df-434b-a08c-4a328c4566c1	2026-10-01 13:14	2026-10-01 13:13	2026-10-01 13:13	HOOD	HOOD261002P00112000	put	112.0000	2026-10-02	1.8400	1.8300	1.8900	111.0000	62584.00	0.00	62584.00	341	6	3953	2696	1.46624629080119	0.636354231017424	0.640708609062491	false	false	false
bbf3ca03-1909-40f1-83f5-6119f501c49a	2026-10-01 13:13	2026-10-01 13:13	2026-10-01 13:13	HOOD	HOOD261030P00110000	put	110.0000	2026-10-30	6.4000	6.3500	6.4000	111.0000	48605.00	48605.00	0.00	76	9	181	914	0.198030634573304	0.582639637123838	0.582639637123838	true	false	false
b5013c16-17bf-4340-bc8c-88cabf399956	2026-10-01 13:13	2026-10-01 13:13	2026-10-01 13:13	HOOD	HOOD261120P00120000	put	120.0000	2026-11-20	14.9000	14.8000	14.9500	111.0000	70030.00	68540.00	0.00	47	12	202	2096	0.0963740458015267	0.615416188567157	0.615416188567157	false	false	false
a856a8e5-7382-428c-93a1-6cc7e7c77d94	2026-10-01 13:13	2026-10-01 13:13	2026-10-01 13:13	HOOD	HOOD261120P00115000	put	115.0000	2026-11-20	11.7500	11.7000	11.7500	111.0000	14100.00	14100.00	0.00	12	5	218	1318	0.165402124430956	0.613305181651222	0.613305181651222	false	false	false
775cd54b-59d0-4d78-9cb3-83618b34e701	2026-10-01 13:13	2026-10-01 13:13	2026-10-01 13:13	HOOD	HOOD261030C00120000	call	120.0000	2026-10-30	4.2000	4.1500	4.4000	111.0000	15115.00	14690.00	425.00	36	15	202	984	0.205284552845528	0.587689891528823	0.591928306008202	true	false	false
311796b8-b387-4810-886b-3a1150c0b990	2026-10-01 13:13	2026-10-01 13:13	2026-10-01 13:13	HOOD	HOOD261030C00118000	call	118.0000	2026-10-30	4.8000	4.7500	4.8000	111.0000	25440.00	25440.00	0.00	53	5	64	109	0.587155963302752	0.584274517599084	0.584274517599084	true	false	false
8be4dd96-d7f9-4d21-b767-25cd01df44b9	2026-10-01 13:08	2026-10-01 13:08	2026-10-01 13:08	HOOD	HOOD261218P00100000	put	100.0000	2026-12-18	6.4500	6.4000	6.5500	111.0000	18060.00	9675.00	8385.00	28	8	51	16576	0.00307673745173745	0.59935952651236	0.59935952651236	true	false	false
ba6b3ad3-0c4f-49d2-80e4-1b8d0e68f142	2026-10-01 13:04	2026-10-01 13:04	2026-10-01 13:04	HOOD	HOOD270917C00160000	call	160.0000	2027-09-17	15.0000	15.0000	15.3500	111.1650	171000.00	0.00	171000.00	114	5	252	1979	0.12733703890854	0.627454878262043	0.627454878262043	false	false	false
689794a9-c130-40f3-b57f-a1905d3b4aa5	2026-10-01 13:03	2026-10-01 13:02	2026-10-01 13:02	HOOD	HOOD261009P00110000	put	110.0000	2026-10-09	2.8000	2.8000	2.8400	111.3400	12320.00	0.00	12320.00	44	5	1016	2598	0.391070053887606	0.531436282434998	0.531436282434998	false	false	false
f1894c93-3a80-404a-9960-b1ad510f8ec5	2026-10-01 13:02	2026-10-01 13:02	2026-10-01 13:02	HOOD	HOOD261002P00112000	put	112.0000	2026-10-02	1.9800	1.9400	1.9800	111.1300	31680.00	31680.00	0.00	160	5	3434	2696	1.27373887240356	0.662099082517626	0.649365285391347	false	false	false