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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = OPEN×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	expirydate

e04f3d25-b87c-4de7-b3d4-21b25295028d	2026-08-17 09:40	2026-08-17 09:40	2026-08-17 09:40	OPEN	OPEN260821C00003500	call	3.5000	2026-08-21	0.1600	0.1600	0.1900	3.5950	16000.00	0.00	16000.00	1000	8	1128	8440	0.133649289099526	0.707626982968082	0.707626982968082	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Real Estate	2709344030.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
8e4eab72-acfa-470b-9741-919cec81b11c	2026-08-17 10:56	2026-08-17 10:56	2026-08-17 10:56	OPEN	OPEN260828C00003500	call	3.5000	2026-08-28	0.2500	0.2400	0.2600	3.6150	50925.00	50625.00	300.00	2037	24	3087	2204	1.40063520871143	0.749562863533432	0.749562863533432	false	false	false	true
42a7806d-5ce0-4602-9bac-b43ae8a04e24	2026-08-17 10:57	2026-08-17 10:57	2026-08-17 10:57	OPEN	OPEN260821C00003500	call	3.5000	2026-08-21	0.1800	0.1700	0.1900	3.6200	10152.00	3222.00	6930.00	564	39	4741	8440	0.561729857819905	0.731140298141013	0.731140298141013	false	false	false	true
8f90e1c4-90cb-40b6-b1b6-7ede4947d30a	2026-08-17 11:11	2026-08-17 11:10	2026-08-17 11:10	OPEN	OPEN260925C00003500	call	3.5000	2026-09-25	0.5200	0.4500	0.5200	3.6850	12116.00	12116.00	0.00	233	7	246	1023	0.240469208211144	0.88612587090298	0.88612587090298	false	false	false	true
cb3b0cfa-b5ae-4b5d-a0e9-9c65427d8e9a	2026-08-17 13:29	2026-08-17 13:29	2026-08-17 13:29	OPEN	OPEN261120C00003000	call	3.0000	2026-11-20	0.8900	0.8900	0.9000	3.5100	12816.00	0.00	12816.00	144	19	1250	1336	0.93562874251497	0.88976261636588	0.88976261636588	true	false	false	true
cda849fc-1623-4ae0-bcb7-62f080b61062	2026-08-17 15:22	2026-08-17 15:22	2026-08-17 15:22	OPEN	OPEN270115C00003000	call	3.0000	2027-01-15	0.9900	0.9700	1.0300	3.4750	16434.00	12474.00	3960.00	166	6	336	3027	0.111000991080278	0.848685519112447	0.85815935177047	false	false	false	true
4c5af4e2-abff-4648-8181-06044ce50564	2026-08-18 09:55	2026-08-18 09:55	2026-08-18 09:55	OPEN	OPEN260821C00003500	call	3.5000	2026-08-21	0.0900	0.0900	0.1000	3.4801	18000.00	0.00	18000.00	2000	27	2850	9852	0.289281364190012	0.785544076769827	0.785544076769827	true	false	false	true
d32068ff-457b-4ed3-bd3c-ce8e7f0500cf	2026-08-18 11:18	2026-08-18 11:18	2026-08-18 11:18	OPEN	OPEN260821C00003500	call	3.5000	2026-08-21	0.0900	0.0800	0.0900	3.4300	18405.00	18405.00	0.00	2045	39	6840	9852	0.694275274056029	0.968835523476204	0.968835523476204	false	false	false	true
0d92ecf6-e036-4791-8d08-c5ba5880f055	2026-08-18 11:53	2026-08-18 11:53	2026-08-18 11:53	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5800	0.5600	0.5800	3.4350	25752.00	25752.00	0.00	444	14	502	6880	0.0729651162790698	0.867176940099163	0.867176940099163	false	false	false	true
6c3f7f23-98bf-45cb-81f1-86753ddd25e6	2026-08-18 12:00	2026-08-18 11:59	2026-08-18 11:59	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5800	0.5600	0.5900	3.4350	20358.00	20358.00	0.00	351	11	986	6880	0.143313953488372	0.867176940099163	0.867176940099163	false	false	false	true
3bf36978-31a5-485e-8d43-98f1776d9685	2026-08-18 12:44	2026-08-18 12:44	2026-08-18 12:44	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5800	0.5600	0.5800	3.4450	15022.00	15022.00	0.00	259	13	1271	6880	0.184738372093023	0.861335632762637	0.861335632762637	false	false	false	true
022edca1-9521-4d94-9c9f-7edb3b5010c8	2026-08-18 15:35	2026-08-18 15:34	2026-08-18 15:34	OPEN	OPEN261016C00004000	call	4.0000	2026-10-16	0.2500	0.2400	0.2500	3.4170	12500.00	12500.00	0.00	500	19	1958	4653	0.42080378250591	0.81178377486437	0.81178377486437	true	false	false	true
82d7fa37-e498-4c4c-b5e1-109218b85cb7	2026-08-19 09:58	2026-08-19 09:58	2026-08-19 09:58	OPEN	OPEN260821C00003500	call	3.5000	2026-08-21	0.0900	0.0800	0.0900	3.5000	15543.00	15543.00	0.00	1727	6	5306	12709	0.417499409867023	0.867482522888655	0.867482522888655	true	false	false	true
1f17cfa5-8c97-479b-bea3-83d9165459bb	2026-08-19 10:46	2026-08-19 10:46	2026-08-19 10:46	OPEN	OPEN260911C00003500	call	3.5000	2026-09-11	0.3100	0.2600	0.3100	3.5601	15500.00	15500.00	0.00	500	14	541	247	2.19028340080972	0.770345856421325	0.778466447679146	false	false	false	true
a00b78ac-5f5f-4b77-b5ae-b8ea26c190e1	2026-08-19 10:50	2026-08-19 10:50	2026-08-19 10:50	OPEN	OPEN260911C00003500	call	3.5000	2026-09-11	0.3300	0.3200	0.3300	3.6000	16500.00	16500.00	0.00	500	14	2541	247	10.2874493927126	0.768409562794009	0.768409562794009	false	false	false	true
77f88eba-d7ef-451d-ae7f-db4f5eb385b3	2026-08-19 10:50	2026-08-19 10:50	2026-08-19 10:50	OPEN	OPEN260911C00003500	call	3.5000	2026-09-11	0.3300	0.3000	0.3300	3.6050	16500.00	16500.00	0.00	500	6	3041	247	12.3117408906883	0.776989580686606	0.759780499276991	false	false	false	true
cb2e50ba-b7ea-41ff-9714-ca0488fa05cc	2026-08-19 11:35	2026-08-19 11:35	2026-08-19 11:35	OPEN	OPEN260828C00003500	call	3.5000	2026-08-28	0.2400	0.2200	0.2400	3.6150	12000.00	12000.00	0.00	500	17	2645	5540	0.477436823104693	0.784074559869587	0.784074559869587	false	false	false	true
dd101240-b54b-4b83-9f0d-12291b7ec7f2	2026-08-19 11:35	2026-08-19 11:35	2026-08-19 11:35	OPEN	OPEN260828C00003500	call	3.5000	2026-08-28	0.2400	0.2200	0.2400	3.6137	12000.00	12000.00	0.00	500	23	3145	5540	0.567689530685921	0.787889007342983	0.787889007342983	false	false	false	true
b3a48090-326a-40db-a4ce-d05d48c3756a	2026-08-19 15:17	2026-08-19 15:17	2026-08-19 15:17	OPEN	OPEN260828P00004000	put	4.0000	2026-08-28	0.5000	0.4900	0.5200	3.5400	10800.00	0.00	10800.00	216	5	901	1416	0.636299435028249	0.81160733592924	0.81160733592924	false	false	false	true
797373fa-0471-4845-9aec-378729fb8556	2026-08-20 09:40	2026-08-20 09:40	2026-08-20 09:40	OPEN	OPEN260911C00003500	call	3.5000	2026-09-11	0.2500	0.2100	0.4700	3.4950	12500.00	9125.00	3375.00	500	5	500	2733	0.182949140139041	0.719387473166968	0.727290336340938	false	false	false	true
93a42978-2206-444c-adc7-9fbc46d44ee4	2026-08-20 09:40	2026-08-20 09:40	2026-08-20 09:40	OPEN	OPEN260911C00003500	call	3.5000	2026-09-11	0.2400	0.2300	0.2900	3.5001	15552.00	0.00	9792.00	648	12	1300	2733	0.475667764361507	0.689912877724894	0.689912877724894	false	false	false	true
88b5cffc-3f54-468e-9829-294d65daa05a	2026-08-20 09:41	2026-08-20 09:41	2026-08-20 09:41	OPEN	OPEN260911C00003500	call	3.5000	2026-09-11	0.2400	0.2400	0.2900	3.5060	12072.00	0.00	12072.00	503	11	2503	2733	0.915843395536041	0.680561417318825	0.680561417318825	false	false	false	true
b1863075-903a-42ae-a1f1-69199d19d958	2026-08-20 09:42	2026-08-20 09:41	2026-08-20 09:41	OPEN	OPEN260911C00003500	call	3.5000	2026-09-11	0.2400	0.2300	0.2900	3.4900	12000.00	2640.00	9360.00	500	8	3003	2733	1.09879253567508	0.705796732626929	0.705796732626929	false	false	false	true
80b5f0cd-d73c-4684-9444-028760b897fb	2026-08-20 09:42	2026-08-20 09:42	2026-08-20 09:42	OPEN	OPEN260911C00003500	call	3.5000	2026-09-11	0.2400	0.2400	0.2900	3.4900	12000.00	0.00	12000.00	500	5	3503	2733	1.28174167581412	0.705796732626929	0.705796732626929	false	false	false	true
79d181be-7a43-4cdb-b811-f1ee745776ed	2026-08-20 10:22	2026-08-20 10:22	2026-08-20 10:22	OPEN	OPEN261218C00008000	call	8.0000	2026-12-18	0.1000	0.0900	0.1000	3.4501	12940.00	12940.00	0.00	1294	22	1294	884	1.46380090497738	1.00848398274491	1.00848398274491	false	false	false	true
f17c08a0-e93f-4588-a938-6b75a6a398d9	2026-08-20 12:43	2026-08-20 12:43	2026-08-20 12:43	OPEN	OPEN261120C00005000	call	5.0000	2026-11-20	0.2400	0.2300	0.2500	3.4550	10560.00	9840.00	0.00	440	10	644	7883	0.08169478624889	0.929114028956684	0.929114028956684	false	false	false	true
5c3e2a9f-eaa1-489e-8bd6-f12b506256e2	2026-08-20 13:20	2026-08-20 13:20	2026-08-20 13:20	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5700	0.5600	0.5700	3.4450	28500.00	28500.00	0.00	500	26	539	7117	0.0757341576506955	0.856053503671567	0.856053503671567	false	false	false	true
4533a56c-a5d5-467d-9a63-c7c0ef770ab4	2026-08-21 09:39	2026-08-21 09:39	2026-08-21 09:39	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.6200	0.5500	0.6200	3.4750	31000.00	31000.00	0.00	500	9	503	8146	0.0617480972256322	0.89846485575037	0.89846485575037	false	false	false	true
be34c78d-551c-4a4e-a39c-c97c445ce1cb	2026-08-21 15:36	2026-08-21 15:36	2026-08-21 15:36	OPEN	OPEN261120C00003000	call	3.0000	2026-11-20	0.8500	0.8500	0.8800	3.5050	13515.00	0.00	13515.00	159	8	516	2625	0.196571428571429	0.848061848033688	0.848061848033688	true	false	false	true
d2982fc1-94dc-42a6-b148-1c2c0d62d36f	2026-08-24 13:39	2026-08-24 13:39	2026-08-24 13:39	OPEN	OPEN270115P00003000	put	3.0000	2027-01-15	0.4500	0.4200	0.4500	3.4900	21555.00	21555.00	0.00	479	23	1011	3223	0.31368290412659	0.860880035793685	0.860880035793685	false	false	false	true
b8688c9c-128d-4ffe-a7e9-347a92b179b2	2026-08-24 14:08	2026-08-24 14:08	2026-08-24 14:08	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5800	0.5800	0.6400	3.4900	29000.00	0.00	29000.00	500	6	1718	8753	0.196275562664229	0.853284764649039	0.853284764649039	false	false	false	true
79e0ad36-5496-4ecb-af1c-fd92d447788e	2026-08-25 09:38	2026-08-25 09:38	2026-08-25 09:38	OPEN	OPEN261120C00004000	call	4.0000	2026-11-20	0.4400	0.4000	0.4600	3.4901	39512.00	34760.00	4752.00	898	5	918	12772	0.0718759787034137	0.903058284362367	0.903058284362367	false	false	false	true
ab5758e4-21bf-42dd-b35f-c285f697390b	2026-08-25 10:46	2026-08-25 10:46	2026-08-25 10:46	OPEN	OPEN260911C00004000	call	4.0000	2026-09-11	0.0800	0.0700	0.0800	3.5500	27272.00	27272.00	0.00	3409	37	3940	3377	1.16671602013622	0.737526033415509	0.737526033415509	false	false	false	true
3ec55f8c-da1e-464c-8ae0-872a06c61669	2026-08-25 11:28	2026-08-25 11:28	2026-08-25 11:28	OPEN	OPEN261120C00005000	call	5.0000	2026-11-20	0.2500	0.2400	0.2600	3.5500	23625.00	0.00	23300.00	945	32	992	8596	0.11540251279665	0.925105325662944	0.925105325662944	false	false	false	true
b4a0c077-c9e7-429a-8cc7-ebdb0dc7dad2	2026-08-25 11:41	2026-08-25 11:41	2026-08-25 11:41	OPEN	OPEN260828C00003500	call	3.5000	2026-08-28	0.1300	0.1200	0.1300	3.5550	12792.00	12792.00	0.00	984	42	5098	10298	0.495047582054768	0.779779133131885	0.779779133131885	false	false	false	true
eb97c05f-f8ca-4cbb-b5c4-ba54a55a053a	2026-08-25 14:22	2026-08-25 14:22	2026-08-25 14:22	OPEN	OPEN261120C00004000	call	4.0000	2026-11-20	0.4600	0.4400	0.4800	3.0000	55798.00	32844.00	11638.00	1213	15	2363	12772	0.185014093329158	0.890339100538043	0.890339100538043	false	false	false	true
3ef62cea-a672-436d-bffd-737b2d0c6875	2026-08-25 15:00	2026-08-25 15:00	2026-08-25 15:00	OPEN	OPEN270115P00004000	put	4.0000	2027-01-15	1.0200	1.0000	1.0300	3.5650	26826.00	26826.00	0.00	263	5	503	5771	0.0871599376191301	0.887054921975403	0.887054921975403	false	false	false	true
0fcc4b16-dbc8-4213-a604-124ad6d94282	2026-08-25 15:57	2026-08-25 15:57	2026-08-25 15:57	OPEN	OPEN260918C00003500	call	3.5000	2026-09-18	0.3000	0.2900	0.3000	3.5700	15000.00	15000.00	0.00	500	5	1802	102	17.6666666666667	0.717418259755688	0.717418259755688	false	false	false	true
f3fa89d3-4ed0-4da5-b002-2f1a03b72b44	2026-08-26 11:57	2026-08-26 11:57	2026-08-26 11:57	OPEN	OPEN260828C00003000	call	3.0000	2026-08-28	0.4300	0.4300	0.4500	3.4300	12384.00	0.00	12384.00	288	8	908	1202	0.75540765391015	1.49454377921652	1.49454377921652	false	false	false	true
9b07b044-ba5b-4a17-b5fe-8db277d19d8d	2026-08-26 13:06	2026-08-26 13:05	2026-08-26 13:05	OPEN	OPEN280915C00007000	call	7.0000	2028-09-15	1.2100	1.1600	1.2900	3.4300	14520.00	1210.00	13310.00	120	12	453	7288	0.0621569703622393	0.959985043984324	0.959985043984324	true	false	false	true
7be8378c-3a4a-4536-8cf4-0f659a683883	2026-08-26 13:06	2026-08-26 13:05	2026-08-26 13:05	OPEN	OPEN280915C00007000	call	7.0000	2028-09-15	1.2100	1.2000	1.2800	3.4200	12221.00	0.00	12221.00	101	11	563	7288	0.0772502744237102	0.963067452773444	0.963067452773444	true	false	false	true
117426bb-fb99-4376-a984-e8bf5da0868c	2026-08-26 13:06	2026-08-26 13:05	2026-08-26 13:05	OPEN	OPEN280915C00007000	call	7.0000	2028-09-15	1.2100	1.1900	1.2800	3.4300	12221.00	1210.00	11011.00	101	11	674	7288	0.0924807903402854	0.959985043984324	0.959985043984324	true	false	false	true
fa287e9d-4b53-455f-88a1-370a65cbb4cc	2026-08-27 09:34	2026-08-27 09:34	2026-08-27 09:34	OPEN	OPEN260918C00003500	call	3.5000	2026-09-18	0.2000	0.2000	0.2800	3.4150	10000.00	0.00	10000.00	500	7	1003	1893	0.529846804014791	0.700096509769888	0.700096509769888	false	false	false	true
6a6cbcd9-4a22-490a-9ed6-3e9b6a10fedf	2026-08-27 14:10	2026-08-27 14:10	2026-08-27 14:10	OPEN	OPEN261120C00003000	call	3.0000	2026-11-20	0.7600	0.7200	0.7800	3.3850	11400.00	7600.00	3800.00	150	6	326	3281	0.0993599512343798	0.871586791932118	0.871586791932118	false	false	false	true
a10152c5-83b9-46e9-aa1f-fbd70e7bc147	2026-08-27 14:21	2026-08-27 14:20	2026-08-27 14:20	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5500	0.5500	0.5800	3.3800	27390.00	0.00	27390.00	498	17	1567	9025	0.173628808864266	0.895049871847274	0.895049871847274	false	false	false	true
b7d4b6da-1873-4724-98ac-a1de7013a388	2026-08-28 09:33	2026-08-28 09:33	2026-08-28 09:33	OPEN	OPEN260828C00003500	call	3.5000	2026-08-28	0.0200	0.0100	0.0200	3.3900	10000.00	10000.00	0.00	5000	26	6144	16082	0.382042034572814	1.5962630222226	1.5962630222226	false	false	false	true
bb7f8352-c271-4e89-bbb0-5b6a3ee465cd	2026-08-28 11:12	2026-08-28 11:12	2026-08-28 11:12	OPEN	OPEN261120C00004000	call	4.0000	2026-11-20	0.3400	0.3400	0.3600	3.3689	33184.00	0.00	33184.00	976	24	1003	16358	0.0613155642499083	0.849503020561714	0.849503020561714	false	false	false	true
5f690b18-4043-4872-915b-4521c4869769	2026-08-28 12:01	2026-08-28 12:01	2026-08-28 12:01	OPEN	OPEN270115C00004000	call	4.0000	2027-01-15	0.5000	0.5000	0.5500	3.0000	25000.00	0.00	25000.00	500	20	509	9666	0.0526588040554521	0.877700343000204	0.877700343000204	false	false	false	true
7d2086d5-f981-4197-9323-0e5de59b8569	2026-08-31 09:34	2026-08-31 09:34	2026-08-31 09:34	OPEN	OPEN260911P00003000	put	3.0000	2026-09-11	0.0700	0.0700	0.1000	3.2300	15022.00	0.00	15022.00	2146	5	2151	1531	1.40496407576747	0.744941507552831	0.744941507552831	false	false	false	true
2e37cbee-13e5-4d3e-83ff-b8d16a29fe68	2026-08-31 09:39	2026-08-31 09:39	2026-08-31 09:39	OPEN	OPEN280616C00004000	call	4.0000	2028-06-16	1.4500	1.4150	1.5200	3.2450	14790.00	0.00	12035.00	102	7	107	35	3.05714285714286	0.962676988772194	0.962676988772194	false	false	false	true