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:alert_rule = RepeatedHits×endpoint = /api/option-trades/flow-alerts×ticker = FUTU×

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

6906c132-fa3e-49f1-b421-1402fc153212	2026-10-02 15:40	2026-10-02 15:40	2026-10-02 15:40	FUTU	FUTU270521C00160000	call	160.0000	2027-05-21	3.8000	3.8000	4.1500	102.7000	73721.00	0.00	73721.00	194	43	195	0	0	0.499258924100044	0.499956804339628	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Financial Services	9780082358.00	2026-11-17	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T19:44:29.221756Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
09086286-4a72-4c4d-bf01-9d2bbb7acefc	2026-10-02 10:38	2026-10-02 10:37	2026-10-02 10:37	FUTU	FUTU261002P00110000	put	110.0000	2026-10-02	5.9500	4.3500	6.5000	104.0050	17850.00	5355.00	12495.00	30	5	32	381	0.083989501312336	2.27655645041889	2.27655645041889	true	false	false
bc76e198-b2b9-4554-8011-1d3a106c2f80	2026-10-02 10:32	2026-10-02 10:32	2026-10-02 10:32	FUTU	FUTU261016C00110000	call	110.0000	2026-10-16	1.6000	1.6000	1.8000	104.4700	10240.00	0.00	10240.00	64	17	77	388	0.198453608247423	0.439137546868749	0.439137546868749	false	false	false
58172b3d-4845-4cd4-b0a7-57944e2720f6	2026-10-02 09:40	2026-10-02 09:40	2026-10-02 09:40	FUTU	FUTU261120C00122450	call	122.4500	2026-11-20	2.1000	1.7000	2.1000	104.8200	84000.00	84000.00	0.00	400	32	450	953	0.472193074501574	0.47380014032929	0.47380014032929	false	false	false
f6d54dfd-1605-471d-a442-20bac3ccaaac	2026-10-01 15:49	2026-10-01 15:49	2026-10-01 15:49	FUTU	FUTU261009P00105000	put	105.0000	2026-10-09	2.0600	2.0300	2.0600	106.4750	11536.00	11536.00	0.00	56	18	122	213	0.572769953051643	0.444398854840045	0.444398854840045	false	false	false
de6dd5fb-be2a-4518-9e4a-489a9377a744	2026-10-01 14:20	2026-10-01 14:20	2026-10-01 14:20	FUTU	FUTU270115P00107450	put	107.4500	2027-01-15	9.6000	9.6000	9.9000	107.0000	15360.00	0.00	15360.00	16	7	31	100	0.31	0.450840559862793	0.450840559862793	false	false	false
abbffd59-fb51-45dc-8412-6946150193ce	2026-10-01 11:28	2026-10-01 11:28	2026-10-01 11:28	FUTU	FUTU270617P00110000	put	110.0000	2027-06-17	17.1000	17.1000	17.5000	109.0000	13680.00	0.00	11970.00	8	8	10	74	0.135135135135135	0.511951240391998	0.511951240391998	false	false	false
527fe98b-8c46-4d31-8a31-fc4013c6d9db	2026-10-01 11:18	2026-10-01 11:18	2026-10-01 11:18	FUTU	FUTU261009C00110000	call	110.0000	2026-10-09	2.2800	2.2800	2.6900	109.1100	37164.00	0.00	37164.00	163	34	167	21	7.95238095238095	0.41099262878989	0.41099262878989	false	false	false
419be33a-a73e-4f0a-9884-8d7a523876be	2026-09-30 14:22	2026-09-30 14:22	2026-09-30 14:22	FUTU	FUTU261120C00132450	call	132.4500	2026-11-20	1.6900	1.6900	2.0700	111.2300	10647.00	0.00	10647.00	63	20	63	304	0.207236842105263	0.450765745235454	0.450765745235454	false	false	false
cdee64bb-4cc7-4ccf-a43f-968f033e7419	2026-09-30 12:14	2026-09-30 12:14	2026-09-30 12:14	FUTU	FUTU270115P00105500	put	105.5000	2027-01-15	7.3000	6.8500	7.3000	111.6450	14600.00	14600.00	0.00	20	11	25	728	0.0343406593406593	0.456883198394465	0.456883198394465	false	false	false
26f31e2d-9b9a-45ed-995e-784e72b2ad46	2026-09-30 12:09	2026-09-30 12:09	2026-09-30 12:09	FUTU	FUTU270115C00150500	call	150.5000	2027-01-15	2.0000	2.0000	2.6000	111.6850	33800.00	0.00	33800.00	169	36	270	400	0.675	0.460388213057725	0.460388213057725	false	false	false
e6fc20bf-3eef-4a3b-b562-af246204278c	2026-09-30 11:04	2026-09-30 11:04	2026-09-30 11:04	FUTU	FUTU280121C00152450	call	152.4500	2028-01-21	17.1000	16.7500	18.2000	112.0800	20520.00	11970.00	8550.00	12	7	14	83	0.168674698795181	0.526713907690501	0.526713907690501	false	false	false
4869050d-90a5-4db8-8166-f78b9fcad1d6	2026-09-29 15:17	2026-09-29 15:17	2026-09-29 15:17	FUTU	FUTU261120P00102450	put	102.4500	2026-11-20	3.1000	2.9200	3.1000	113.1300	11780.00	11780.00	0.00	38	19	130	733	0.177353342428377	0.459357683580222	0.459357683580222	false	false	false
a4911391-99a0-4125-8458-80b69074c848	2026-09-29 13:53	2026-09-29 13:53	2026-09-29 13:53	FUTU	FUTU261120C00102450	call	102.4500	2026-11-20	13.6500	13.2500	13.8500	112.0900	16380.00	15015.00	0.00	12	7	12	642	0.0186915887850467	0.461984063548942	0.461984063548942	false	false	false
7f19e9c9-f59c-4672-8170-c6f776abea4c	2026-09-29 12:21	2026-09-29 12:21	2026-09-29 12:21	FUTU	FUTU261023P00106000	put	106.0000	2026-10-23	2.2300	2.2300	2.5500	112.0900	20739.00	0.00	20739.00	93	24	93	4	23.25	0.426834781156004	0.426834781156004	false	false	false
5b44c408-902e-4939-82a6-f9f26c6fd219	2026-09-25 14:22	2026-09-25 14:22	2026-09-25 14:22	FUTU	FUTU261002C00117000	call	117.0000	2026-10-02	0.9500	0.8200	1.1200	112.7000	19475.00	95.00	19380.00	205	13	260	29	8.96551724137931	0.39644648744152	0.39644648744152	false	false	false
9d1e98de-bf8b-4409-a0ce-9805289d39e9	2026-09-25 11:54	2026-09-25 11:54	2026-09-25 11:54	FUTU	FUTU270115C00127450	call	127.4500	2027-01-15	5.8500	5.0000	5.8500	111.0000	17550.00	1755.00	0.00	30	19	30	47	0.638297872340426	0.440412371195112	0.440412371195112	false	false	false
8f95f5c6-ec07-47b0-a69b-74b6fa8e3fed	2026-09-24 14:36	2026-09-24 14:36	2026-09-24 14:36	FUTU	FUTU260925C00110000	call	110.0000	2026-09-25	0.9000	0.9000	1.1000	109.4400	10260.00	0.00	10260.00	114	30	273	273	1	0.503433254304688	0.503433254304688	false	false	false
a22c4969-4b8f-480c-8a0e-1fca03ea6f23	2026-09-24 12:37	2026-09-24 12:37	2026-09-24 12:37	FUTU	FUTU270219P00100000	put	100.0000	2027-02-19	7.3000	7.3000	7.9000	109.7700	30660.00	0.00	30660.00	42	19	188	224	0.839285714285714	0.462659586856787	0.46377314898248	false	false	false
0dc70f2e-82ba-41aa-95a7-2358abce791d	2026-09-24 11:42	2026-09-24 11:42	2026-09-24 11:42	FUTU	FUTU260925C00109000	call	109.0000	2026-09-25	1.2900	1.2900	2.2600	109.0000	11610.00	0.00	11610.00	90	24	90	118	0.76271186440678	0.564190619955404	0.564190619955404	true	false	false
85d6b66b-e8b7-455b-bf00-3e76eccc4989	2026-09-23 13:57	2026-09-23 13:57	2026-09-23 13:57	FUTU	FUTU261016C00124000	call	124.0000	2026-10-16	1.3200	1.3200	1.7700	111.2250	23364.00	0.00	23364.00	177	34	177	0	0	0.461309186285695	0.461309186285695	false	false	false
38cb2556-34c9-451c-b84d-dd0afdb12862	2026-09-23 12:26	2026-09-23 12:26	2026-09-23 12:26	FUTU	FUTU270219P00105000	put	105.0000	2027-02-19	8.8000	8.8000	9.6000	112.4700	37840.00	0.00	37840.00	43	18	51	372	0.137096774193548	0.471889655587364	0.471889655587364	false	false	false
c9bf9c56-9f7e-42ef-8bc2-0a4a477fdc6e	2026-09-23 12:26	2026-09-23 12:26	2026-09-23 12:26	FUTU	FUTU261002C00116000	call	116.0000	2026-10-02	1.8000	1.5200	2.1800	112.4300	13140.00	10080.00	3060.00	73	8	85	16	5.3125	0.453058812268767	0.453058812268767	false	false	false
c5b500a0-59a6-4950-a4bc-2f84868ea2fd	2026-09-22 11:42	2026-09-22 11:42	2026-09-22 11:42	FUTU	FUTU261016P00100000	put	100.0000	2026-10-16	0.8300	0.8300	1.0000	113.7550	34362.00	0.00	34362.00	414	36	415	447	0.92841163310962	0.458887966510706	0.458887966510706	false	false	false
ad362f53-ac1d-4f41-b27a-82707ba5e623	2026-09-22 10:44	2026-09-22 10:44	2026-09-22 10:44	FUTU	FUTU261016C00120000	call	120.0000	2026-10-16	3.6000	3.2000	4.0500	115.0000	12600.00	1800.00	10800.00	35	7	48	245	0.195918367346939	0.469895257309032	0.469895257309032	true	false	false
94f1d03e-da5f-4240-b118-cd188fdc5734	2026-09-21 15:41	2026-09-21 15:41	2026-09-21 15:41	FUTU	FUTU261030C00140000	call	140.0000	2026-10-30	0.9200	0.9200	1.0200	114.7550	14812.00	0.00	14812.00	161	20	171	2	85.5	0.466032159527248	0.466032159527248	false	false	false
5ecb98fb-314f-47a7-9f96-1e2eff6ed6dd	2026-09-21 10:00	2026-09-21 10:00	2026-09-21 10:00	FUTU	FUTU261120C00117450	call	117.4500	2026-11-20	7.2100	7.0000	8.0500	112.8700	10090.00	3565.00	6525.00	14	7	16	248	0.0645161290322581	0.486690072171374	0.47845306780031	true	false	false
bc49dbf9-7c95-4dde-bc18-0393edd34b38	2026-09-18 14:48	2026-09-18 14:47	2026-09-18 14:47	FUTU	FUTU261016P00095000	put	95.0000	2026-10-16	0.5900	0.3000	0.6000	112.6800	14573.00	14573.00	0.00	247	31	247	656	0.376524390243902	0.474696282986001	0.476789987714247	true	false	false
015ce1a4-d8ed-42d9-a579-8777abace5aa	2026-09-18 13:53	2026-09-18 13:53	2026-09-18 13:53	FUTU	FUTU270617C00120000	call	120.0000	2027-06-17	19.0500	19.0500	20.6000	112.8200	15240.00	0.00	15240.00	8	8	8	99	0.0808080808080808	0.528701181823905	0.528701181823905	false	false	false
6e31e391-a731-4876-bff4-1cd7a55a9727	2026-09-18 10:09	2026-09-18 10:09	2026-09-18 10:09	FUTU	FUTU261016C00125000	call	125.0000	2026-10-16	1.5700	1.5700	1.8000	112.4850	46629.00	0.00	46629.00	297	26	297	187	1.58823529411765	0.435428947720127	0.435428947720127	false	false	false
aac5e4e0-9e7b-4500-9fde-839a9d0cecdf	2026-09-17 14:15	2026-09-17 14:15	2026-09-17 14:15	FUTU	FUTU261120C00122450	call	122.4500	2026-11-20	5.4000	5.0500	5.4000	111.8200	17820.00	17820.00	0.00	33	6	103	867	0.118800461361015	0.487779712690164	0.487779712690164	false	false	false
b6f9b5fd-f67d-47d0-8331-40315d062fbf	2026-09-17 12:26	2026-09-17 12:25	2026-09-17 12:25	FUTU	FUTU270219P00115000	put	115.0000	2027-02-19	14.9000	14.3500	15.2500	111.5400	11920.00	5960.00	5960.00	8	8	8	13	0.615384615384615	0.482075223143354	0.482075223143354	false	false	false
dbb22628-8ac9-4dd0-9d74-b2c4c1c875d6	2026-09-17 11:46	2026-09-17 11:45	2026-09-17 11:45	FUTU	FUTU260925C00109000	call	109.0000	2026-09-25	4.3500	4.3500	5.0000	111.5200	23055.00	0.00	23055.00	53	18	53	67	0.791044776119403	0.43901976132203	0.43901976132203	false	false	false
7035c3e2-d815-4a86-851e-f09af0bd8eb1	2026-09-17 11:46	2026-09-17 11:45	2026-09-17 11:45	FUTU	FUTU260925C00110000	call	110.0000	2026-09-25	3.7000	3.7000	4.3500	111.5200	21460.00	0.00	21460.00	58	19	59	168	0.351190476190476	0.431576768158067	0.431576768158067	false	false	false
24aea6fc-ec50-4fbf-a8e2-6ab3d569a373	2026-09-16 15:48	2026-09-16 15:47	2026-09-16 15:47	FUTU	FUTU261016P00105000	put	105.0000	2026-10-16	3.3500	3.3500	3.9000	109.0000	22450.00	0.00	22450.00	67	25	67	1041	0.0643611911623439	0.445192313691649	0.445192313691649	false	false	false
c478be0d-6e62-4ca5-a303-36b7d6de45f2	2026-09-16 13:48	2026-09-16 13:47	2026-09-16 13:47	FUTU	FUTU261120P00107450	put	107.4500	2026-11-20	7.3700	6.6500	7.8500	110.0000	35380.00	35380.00	0.00	48	2	54	1295	0.0416988416988417	0.495998957029951	0.495998957029951	false	true	false
70c0c6af-3aec-4542-ab1e-d01d52c0b0a1	2026-09-16 10:47	2026-09-16 10:47	2026-09-16 10:47	FUTU	FUTU260925P00104000	put	104.0000	2026-09-25	1.1300	1.1300	1.4900	109.4400	18758.00	0.00	18758.00	166	17	167	46	3.6304347826087	0.472591569362059	0.472591569362059	false	false	false
a3a21d2c-c907-492f-80dc-65e7ed56309a	2026-09-15 15:31	2026-09-15 15:31	2026-09-15 15:31	FUTU	FUTU270115C00197450	call	197.4500	2027-01-15	0.6600	0.5500	0.6700	108.7775	24222.00	24157.00	0.00	367	43	367	525	0.699047619047619	0.5586522549144	0.560177902161534	false	false	false
a0cdf307-cfbb-4591-926d-221593d293f2	2026-09-15 14:40	2026-09-15 14:40	2026-09-15 14:40	FUTU	FUTU261002P00110000	put	110.0000	2026-10-02	4.8000	4.3500	4.9000	108.8600	55686.00	3840.00	51846.00	116	21	141	28	5.03571428571429	0.458560909165819	0.458560909165819	false	false	false
6e056e3c-6491-4f03-8d70-def5e509c190	2026-09-15 11:23	2026-09-15 11:23	2026-09-15 11:23	FUTU	FUTU270115P00092450	put	92.4500	2027-01-15	4.7500	4.4500	4.7500	110.0500	35150.00	35150.00	0.00	74	22	74	100	0.74	0.515366558032402	0.515366558032402	false	false	false
296aae63-2bbc-44a1-90dd-9b32d1aeb175	2026-09-14 15:02	2026-09-14 15:01	2026-09-14 15:01	FUTU	FUTU270219P00110000	put	110.0000	2027-02-19	12.7500	12.7500	13.0000	111.2550	19125.00	0.00	19125.00	15	10	109	120	0.908333333333333	0.494372225997264	0.494372225997264	true	false	false
9bb2445d-3604-49ad-818a-c2d620ae274e	2026-09-14 15:01	2026-09-14 15:01	2026-09-14 15:01	FUTU	FUTU270219P00110000	put	110.0000	2027-02-19	12.7500	12.7000	13.0500	111.2000	15300.00	5100.00	10200.00	12	10	79	120	0.658333333333333	0.493589287610476	0.493589287610476	false	false	false
c21be194-2550-4c44-ad3b-d090db70e9a1	2026-09-14 14:20	2026-09-14 14:20	2026-09-14 14:20	FUTU	FUTU270115P00080500	put	80.5000	2027-01-15	1.9900	1.5000	1.9900	111.2150	20894.00	20894.00	0.00	105	20	105	525	0.2	0.528374278814163	0.52752886861562	false	false	false
a7c3404b-7fba-4723-ac73-8fcdef708632	2026-09-14 14:18	2026-09-14 14:18	2026-09-14 14:18	FUTU	FUTU270115P00105500	put	105.5000	2027-01-15	9.1000	9.1000	9.5000	111.2550	10920.00	0.00	10920.00	12	6	100	773	0.129366106080207	0.494704232666659	0.494704232666659	false	false	false
53930aad-a96d-4ccc-9a49-d641e8ca77d5	2026-09-14 13:28	2026-09-14 13:28	2026-09-14 13:28	FUTU	FUTU270115P00077450	put	77.4500	2027-01-15	1.5300	1.1500	1.5300	111.6300	17136.00	17136.00	0.00	112	16	112	270	0.414814814814815	0.533532760684478	0.533532760684478	false	false	false
fad5ad12-e334-4b65-a5d7-fe118786bc77	2026-09-14 11:56	2026-09-14 11:56	2026-09-14 11:56	FUTU	FUTU270917C00140000	call	140.0000	2027-09-17	16.6000	15.5500	17.2000	111.1500	16600.00	8300.00	8300.00	10	6	11	6	1.83333333333333	0.553565383645174	0.553565383645174	false	false	false
8aa22c22-0e6c-4743-be02-fd9a54f9b4b8	2026-09-14 10:11	2026-09-14 10:11	2026-09-14 10:11	FUTU	FUTU261016P00090000	put	90.0000	2026-10-16	0.6200	0.2600	0.6200	111.3850	31801.00	31496.00	0.00	513	55	514	1641	0.313223644119439	0.533726819519892	0.534767696060744	false	false	false
9fed1c88-8b32-4bfb-9b7f-2a2990719e49	2026-09-11 13:16	2026-09-11 13:16	2026-09-11 13:16	FUTU	FUTU260925P00115000	put	115.0000	2026-09-25	5.3000	5.3000	5.5500	112.3550	24380.00	0.00	24380.00	46	5	100	321	0.311526479750779	0.444192349996708	0.444192349996708	false	false	false
6224e786-db01-40f7-999f-92746a6485de	2026-09-11 12:25	2026-09-11 12:25	2026-09-11 12:25	FUTU	FUTU261120C00122450	call	122.4500	2026-11-20	6.1000	6.1000	6.3500	112.4050	76860.00	0.00	76860.00	126	21	176	718	0.245125348189415	0.491825838240884	0.491825838240884	false	false	false
9c2eda4b-a613-4110-8ddd-9d26bc295548	2026-09-11 11:13	2026-09-11 11:13	2026-09-11 11:13	FUTU	FUTU270115C00145500	call	145.5000	2027-01-15	4.3500	4.3500	4.6500	113.9600	14790.00	0.00	14355.00	34	17	45	242	0.18595041322314	0.487714710331613	0.487714710331613	false	false	false