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×ticker = EWZ×

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

3fd27e96-988f-41dc-8405-cfd8276697fd	2026-09-09 12:59	2026-09-09 12:59	2026-09-09 12:59	EWZ	EWZ261120C00040000	call	40.0000	2026-11-20	2.3000	2.3000	2.3100	38.0000	17020.00	0.00	17020.00	74	6	2272	105805	0.0214734653371769	0.436530992400629	0.436530992400629	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	8686956917.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
030c1cb8-cb2f-4572-9b41-5540c967e6eb	2026-09-09 12:44	2026-09-09 12:44	2026-09-09 12:44	EWZ	EWZ261120C00037000	call	37.0000	2026-11-20	3.7000	3.7000	3.7500	38.1700	29600.00	0.00	29600.00	80	12	318	47372	0.00671282614202482	0.440001592561443	0.440001592561443	true	false	false	true
a4f3d42a-a974-4e2b-8a98-809d49ff4d8c	2026-09-09 12:19	2026-09-09 12:19	2026-09-09 12:19	EWZ	EWZ260918P00037000	put	37.0000	2026-09-18	0.3300	0.3100	0.3400	38.0050	31152.00	33.00	31119.00	944	11	2081	6402	0.325054670415495	0.31346867548237	0.31346867548237	false	false	false	true
cf20dec3-2a34-4874-ad8f-048e1b2804a0	2026-09-09 12:05	2026-09-09 12:05	2026-09-09 12:05	EWZ	EWZ260918C00041000	call	41.0000	2026-09-18	0.0900	0.0900	0.1000	38.0800	15732.00	0.00	15732.00	1748	12	1887	13876	0.135990198904583	0.346838278534197	0.346838278534197	false	false	false	true
e4f63792-48d8-475f-8f12-cd535cd13edf	2026-09-09 11:45	2026-09-09 11:45	2026-09-09 11:45	EWZ	EWZ261120C00040000	call	40.0000	2026-11-20	2.2800	2.2700	2.2800	38.1200	14592.00	14592.00	0.00	64	5	1730	105805	0.0163508340815651	0.435932462580963	0.435932462580963	true	false	false	true
50072d55-1bb1-4997-8d59-bbea675caa7d	2026-09-09 11:44	2026-09-09 11:44	2026-09-09 11:44	EWZ	EWZ261120C00040000	call	40.0000	2026-11-20	2.3000	2.3000	2.3100	38.1300	23230.00	0.00	23230.00	101	7	1665	105805	0.0157364963848589	0.438231846104467	0.438231846104467	true	false	false	true
4b590939-78de-4414-a8ca-6003f71bc834	2026-09-09 11:38	2026-09-09 11:38	2026-09-09 11:38	EWZ	EWZ261120C00040000	call	40.0000	2026-11-20	2.2700	2.2700	2.2800	38.0950	56750.00	0.00	56750.00	250	5	1555	105805	0.0146968479750484	0.436137009651768	0.436137009651768	false	false	false	true
9f383d74-4215-42e6-a536-b15f33a7a857	2026-09-09 11:31	2026-09-09 11:30	2026-09-09 11:30	EWZ	EWZ261120C00040000	call	40.0000	2026-11-20	2.2300	2.2200	2.2300	38.0100	15833.00	15833.00	0.00	71	7	1265	105805	0.0119559567128208	0.435900084154171	0.435900084154171	true	false	false	true
e4408a0e-c333-4eea-8fd3-c77e4c2fead9	2026-09-09 11:20	2026-09-09 11:20	2026-09-09 11:20	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.0900	0.0900	0.1000	37.8950	32625.00	0.00	32625.00	3625	39	8605	13060	0.658882082695253	0.383464671760667	0.383464671760667	false	false	false	true
1d91de64-fd78-41a2-bbf3-6fa9bd9a6a5f	2026-09-09 11:20	2026-09-09 11:19	2026-09-09 11:19	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.1000	0.0900	0.1000	37.9100	31750.00	11080.00	0.00	3175	18	4980	13060	0.381316998468606	0.394206582200689	0.394206582200689	true	false	false	true
aabb8d39-63b0-4fa0-bb92-8eec6fe7299b	2026-09-09 11:19	2026-09-09 11:19	2026-09-09 11:19	EWZ	EWZ261016C00042000	call	42.0000	2026-10-16	0.6500	0.6100	0.6500	37.9050	19500.00	19500.00	0.00	300	6	7246	34796	0.208242326704219	0.403505513159168	0.403505513159168	false	false	false	true
81df8f83-863a-46c0-85a0-5628fb1c3d21	2026-09-09 11:19	2026-09-09 11:19	2026-09-09 11:19	EWZ	EWZ261016C00042000	call	42.0000	2026-10-16	0.6500	0.6100	0.6500	37.9068	32500.00	32500.00	0.00	500	29	6946	34796	0.19962064605127	0.403390170433701	0.403390170433701	false	false	false	true
821d2cb6-1cbd-443c-a03b-fe2dfcebeb16	2026-09-09 11:19	2026-09-09 11:19	2026-09-09 11:19	EWZ	EWZ261016C00042000	call	42.0000	2026-10-16	0.6400	0.6100	0.6900	37.9055	32000.00	27584.00	4416.00	500	5	6446	34796	0.185251178296356	0.401159633230266	0.400808361548299	false	false	false	true
f4d3ec02-7b40-4e6b-abe5-708b7862b36e	2026-09-09 11:14	2026-09-09 11:14	2026-09-09 11:14	EWZ	EWZ261016C00039000	call	39.0000	2026-10-16	1.5400	1.5100	1.5400	37.9800	210056.00	210056.00	0.00	1364	30	1710	34681	0.0493065367203945	0.398355003168128	0.398355003168128	false	false	false	true
7b50c402-4999-418b-a78e-90f9653a8d96	2026-09-09 11:14	2026-09-09 11:14	2026-09-09 11:14	EWZ	EWZ261016C00041000	call	41.0000	2026-10-16	0.8800	0.8600	0.8800	37.9800	54824.00	54824.00	0.00	623	10	891	22061	0.0403880150491818	0.398220187784499	0.398220187784499	false	false	false	true
2e8792f1-4567-4687-a627-22953ad6de50	2026-09-09 11:10	2026-09-09 11:10	2026-09-09 11:10	EWZ	EWZ261016P00036000	put	36.0000	2026-10-16	0.9900	0.9500	0.9900	37.9950	22770.00	22770.00	0.00	230	16	342	39218	0.00872048549135601	0.398503893606736	0.398503893606736	false	false	false	true
19f2249f-106e-4db3-aaae-a5862b0c98ee	2026-09-09 11:05	2026-09-09 11:05	2026-09-09 11:05	EWZ	EWZ260918P00037000	put	37.0000	2026-09-18	0.3300	0.3200	0.3300	38.0050	10197.00	10197.00	0.00	309	7	1096	6402	0.171196501093408	0.31346867548237	0.31346867548237	true	false	false	true
87991fc3-5cbb-4340-a65c-d9403c59297b	2026-09-09 11:01	2026-09-09 11:01	2026-09-09 11:01	EWZ	EWZ260918P00037000	put	37.0000	2026-09-18	0.3300	0.3200	0.3300	38.0400	10131.00	10131.00	0.00	307	6	378	6402	0.0590440487347704	0.318313351101913	0.318313351101913	true	false	false	true
ac88df67-152e-4170-8032-289c49a68336	2026-09-09 10:55	2026-09-09 10:55	2026-09-09 10:55	EWZ	EWZ261218C00045000	call	45.0000	2026-12-18	1.0800	0.8300	1.0800	38.0900	21708.00	21708.00	0.00	201	27	701	96895	0.00723463543010475	0.390752288195576	0.390752288195576	false	false	false	true
cb591b1e-3ccd-4a51-8673-2db2e76776e5	2026-09-09 10:55	2026-09-09 10:55	2026-09-09 10:55	EWZ	EWZ261218C00045000	call	45.0000	2026-12-18	1.0700	1.0300	1.0700	38.1001	53393.00	53393.00	0.00	499	19	499	96895	0.00514990453583776	0.388786931170773	0.388786931170773	false	false	false	true
dcce49dc-25c6-4ef9-8757-e1d4aa72a600	2026-09-09 10:36	2026-09-09 10:36	2026-09-09 10:36	EWZ	EWZ261218C00042000	call	42.0000	2026-12-18	1.8000	1.8000	1.8400	38.0000	78660.00	0.00	78660.00	437	5	905	80772	0.0112043777546675	0.384283030348349	0.384283030348349	false	false	false	true
623b9411-9783-421f-a1a7-afeb8a41dab8	2026-09-09 10:34	2026-09-09 10:34	2026-09-09 10:34	EWZ	EWZ270115C00050000	call	50.0000	2027-01-15	0.4700	0.4000	0.5300	38.0000	188000.00	4559.00	182266.00	4000	44	4002	26660	0.150112528132033	0.349398257897923	0.34966957836461	false	false	false	true
dfbefb32-4a23-4e64-86cd-a27f0bf269f2	2026-09-09 10:34	2026-09-09 10:34	2026-09-09 10:34	EWZ	EWZ270115C00045000	call	45.0000	2027-01-15	1.2000	0.9600	1.2100	38.0000	480000.00	479880.00	0.00	4000	51	14423	26292	0.548569907196105	0.354098363558131	0.354098363558131	false	false	false	true
c2f97a65-c48f-40eb-af1d-e076eb006559	2026-09-09 10:33	2026-09-09 10:33	2026-09-09 10:33	EWZ	EWZ261218C00040000	call	40.0000	2026-12-18	2.5000	2.4900	2.5300	38.0000	402750.00	26000.00	376750.00	1611	10	1689	102726	0.016441796624029	0.386407250410642	0.386407250410642	true	false	false	true
311e1aef-3a28-4bb1-801a-58cd51f52cde	2026-09-09 10:32	2026-09-09 10:32	2026-09-09 10:32	EWZ	EWZ261016C00042000	call	42.0000	2026-10-16	0.6600	0.6500	0.6900	38.0000	333234.00	0.00	328482.00	5049	52	5084	34796	0.146108748131969	0.384558961525295	0.384558961525295	false	false	false	true
94819b8d-95a9-4f82-b619-e5f58be0e673	2026-09-09 10:27	2026-09-09 10:27	2026-09-09 10:27	EWZ	EWZ261016C00040000	call	40.0000	2026-10-16	1.2600	1.2300	1.2600	38.0000	41328.00	41328.00	0.00	328	28	613	138027	0.00444116006288625	0.393794597229478	0.393794597229478	false	false	false	true
561b1975-5ae0-45c2-a795-8a85aaff5137	2026-09-09 09:51	2026-09-09 09:51	2026-09-09 09:51	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.2200	0.2000	0.2300	38.4000	13904.00	11814.00	2090.00	632	25	1745	13060	0.133614088820827	0.399195051768125	0.399195051768125	true	false	false	true
c3f5d769-8567-45c3-8777-0471241e7f1e	2026-09-09 09:51	2026-09-09 09:51	2026-09-09 09:51	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.2200	0.2200	0.2300	38.4150	14762.00	0.00	14762.00	671	18	716	13060	0.0548238897396631	0.394569211914695	0.394569211914695	false	false	false	true
52673d72-9599-4d96-82d7-9a97723557e9	2026-09-09 09:50	2026-09-09 09:50	2026-09-09 09:50	EWZ	EWZ261120P00041000	put	41.0000	2026-11-20	4.2500	4.2500	4.3000	38.4250	15725.00	0.00	15725.00	37	12	58	1927	0.030098598858329	0.426875373399411	0.426875373399411	false	false	false	true
70558abd-7849-44a6-9857-68151094a6a3	2026-09-09 09:31	2026-09-09 09:31	2026-09-09 09:31	EWZ	EWZ261009C00041000	call	41.0000	2026-10-09	0.9100	0.7900	1.2200	38.3950	41041.00	29575.00	11466.00	451	8	451	735	0.613605442176871	0.418805780089824	0.418805780089824	false	false	false	true
fb5d3893-13a7-43db-afb6-798bc7962cab	2026-09-09 09:30	2026-09-09 09:30	2026-09-09 09:30	EWZ	EWZ261120P00037000	put	37.0000	2026-11-20	2.1200	1.9100	2.1900	38.4200	12932.00	12932.00	0.00	61	5	61	11683	0.00522126166224429	0.435453687197964	0.435453687197964	false	false	false	true
fe17c950-815b-476a-b74c-c1e11dae8ff8	2026-09-08 15:36	2026-09-08 15:36	2026-09-08 15:36	EWZ	EWZ270115C00038000	call	38.0000	2027-01-15	3.8000	3.7500	3.8000	38.5999	152000.00	152000.00	0.00	400	9	413	8614	0.0479452054794521	0.358583442799161	0.358583442799161	false	false	false	true
80fb7fb8-b394-48b0-98f7-5d34b8cd89dd	2026-09-08 15:17	2026-09-08 15:16	2026-09-08 15:16	EWZ	EWZ261218C00046000	call	46.0000	2026-12-18	1.0300	1.0300	1.0600	38.7000	134621.00	0.00	134621.00	1307	27	40287	173813	0.231783583506412	0.386420309326911	0.386420309326911	false	false	false	true
1b5b80d5-2e41-402f-8880-d26372fa9e3f	2026-09-08 14:47	2026-09-08 14:47	2026-09-08 14:47	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.4500	0.4400	0.4600	38.8350	15885.00	6480.00	6165.00	353	9	24901	14336	1.73695591517857	0.37156032029403	0.37156032029403	true	false	false	true
47977da7-75e3-4330-afd2-d9f006236d11	2026-09-08 14:47	2026-09-08 14:47	2026-09-08 14:47	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.4500	0.4400	0.4600	38.8400	44100.00	32715.00	8100.00	980	18	24548	14336	1.71233258928571	0.369911814090643	0.369911814090643	false	false	false	true
1961e7bc-4747-41ed-9c1b-ac659d8b8273	2026-09-08 14:47	2026-09-08 14:47	2026-09-08 14:47	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.4500	0.4500	0.4600	38.8500	12825.00	0.00	12825.00	285	10	23486	14336	1.63825334821429	0.36660306586145	0.36660306586145	false	false	false	true
e2340cfd-63cc-4991-896d-1619c33a7155	2026-09-08 14:45	2026-09-08 14:44	2026-09-08 14:44	EWZ	EWZ261218C00046000	call	46.0000	2026-12-18	1.0800	1.0800	1.1100	38.8600	34668.00	0.00	34668.00	321	5	38323	173813	0.220484083469016	0.388029993743137	0.388029993743137	false	false	false	true
8c653d16-c737-4bf6-b208-c5b058c1c69e	2026-09-08 13:25	2026-09-08 13:25	2026-09-08 13:25	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.3400	0.3400	0.3600	38.5900	102000.00	0.00	102000.00	3000	57	23165	14336	1.61586216517857	0.366867079536137	0.366867079536137	false	false	false	true
4dfbabec-52d0-410c-8214-097b8bf492ab	2026-09-08 13:06	2026-09-08 13:06	2026-09-08 13:06	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.3500	0.3300	0.3600	38.5600	56980.00	21840.00	1330.00	1628	26	20083	14336	1.40087890625	0.382973004424735	0.382973004424735	true	false	false	true
b349c46c-93ac-4cc4-bc73-1b0ab9ac33f0	2026-09-08 13:04	2026-09-08 13:04	2026-09-08 13:04	EWZ	EWZ261218C00050000	call	50.0000	2026-12-18	0.5000	0.5000	0.5200	38.5565	13600.00	0.00	13600.00	272	6	84949	127293	0.667350129229416	0.392806256580254	0.392806256580254	false	false	false	true
a0dd1a11-ea52-475a-9388-bd9a69add054	2026-09-08 12:48	2026-09-08 12:48	2026-09-08 12:48	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.3400	0.3200	0.3500	38.5350	32164.00	18904.00	11934.00	946	24	18355	14336	1.28034319196429	0.382564361203276	0.382564361203276	true	false	false	true
6c150130-e697-41a6-bfe2-1f4eacd944a9	2026-09-08 12:48	2026-09-08 12:48	2026-09-08 12:48	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.3400	0.3400	0.3500	38.5550	12512.00	0.00	12512.00	368	12	17142	14336	1.19573102678571	0.376888604912782	0.376888604912782	true	false	false	true
2b88b520-ede5-4e65-ad7d-bfd6bb63a0b4	2026-09-08 12:09	2026-09-08 12:09	2026-09-08 12:09	EWZ	EWZ261016C00036000	call	36.0000	2026-10-16	3.6000	3.6000	3.6500	38.6000	288000.00	0.00	288000.00	800	12	1238	13580	0.0911634756995582	0.401814111696	0.401814111696	false	false	false	true
29ee81ee-623a-4c48-9198-0390ba931b3a	2026-09-08 11:54	2026-09-08 11:54	2026-09-08 11:54	EWZ	EWZ261218C00050000	call	50.0000	2026-12-18	0.5400	0.5300	0.5600	38.7300	24678.00	0.00	24678.00	457	6	76619	127293	0.601910552819087	0.396326789489176	0.396326789489176	false	false	false	true
66787a86-9201-45f9-a231-8377391f6256	2026-09-08 11:19	2026-09-08 11:19	2026-09-08 11:19	EWZ	EWZ261120C00044000	call	44.0000	2026-11-20	1.3500	1.3200	1.3600	38.8200	91395.00	81000.00	10395.00	677	23	9474	32884	0.288103637027126	0.43623351530414	0.436737165126183	false	false	false	true
fe17bb43-ab6d-422c-998a-153314a4958f	2026-09-08 11:16	2026-09-08 11:16	2026-09-08 11:16	EWZ	EWZ261016P00039000	put	39.0000	2026-10-16	2.0000	1.9400	2.0100	38.8600	40000.00	40000.00	0.00	200	11	2116	2745	0.770856102003643	0.40200112064725	0.40200112064725	true	false	false	true
9e88d9e5-4ab6-4d00-a0db-f23976a96050	2026-09-08 11:05	2026-09-08 11:05	2026-09-08 11:05	EWZ	EWZ260918C00040000	call	40.0000	2026-09-18	0.4400	0.4400	0.4600	38.8950	43956.00	0.00	43956.00	999	21	2360	59782	0.0394767655816132	0.334358407158444	0.334358407158444	false	false	false	true
c532d0ac-c5b5-4e47-af72-2a84ff492ccc	2026-09-08 11:05	2026-09-08 11:05	2026-09-08 11:05	EWZ	EWZ261120C00050000	call	50.0000	2026-11-20	0.4400	0.4300	0.4600	38.9000	15840.00	44.00	15796.00	360	11	25595	37672	0.679417073688681	0.437576996308318	0.437576996308318	false	false	false	true
8c96dc82-2596-43d0-ba67-67a6916ccbcc	2026-09-08 11:01	2026-09-08 11:00	2026-09-08 11:00	EWZ	EWZ261120C00044000	call	44.0000	2026-11-20	1.3500	1.3200	1.3600	38.8400	48330.00	10395.00	28890.00	358	10	8773	32884	0.266786279041479	0.435729829449603	0.435729829449603	true	false	false	true
0e82b78c-cb72-4ba5-aba1-e1b317a5bdb3	2026-09-08 11:01	2026-09-08 11:00	2026-09-08 11:00	EWZ	EWZ261120C00044000	call	44.0000	2026-11-20	1.3500	1.3200	1.3600	38.8400	266085.00	191160.00	73845.00	1971	38	8414	32884	0.255869115679358	0.435729829449603	0.435729829449603	false	false	false	true