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

e54b3085-e375-4a89-96ea-fd003f36c766	2026-09-08 10:53	2026-09-08 10:53	2026-09-08 10:53	EWZ	EWZ261016C00041000	call	41.0000	2026-10-16	1.2300	1.2100	1.2700	38.9350	123000.00	0.00	123000.00	1000	10	3181	18878	0.168503019387647	0.397774340696658	0.397774340696658	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	8633146199.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
abfcfc32-ac66-4194-be68-2a77a82c3940	2026-09-08 10:52	2026-09-08 10:52	2026-09-08 10:52	EWZ	EWZ261016C00041000	call	41.0000	2026-10-16	1.2300	1.2300	1.2800	38.9600	98400.00	0.00	84009.00	800	18	2081	18878	0.110234134971925	0.395788837748596	0.395788837748596	false	false	false	true
05ac0117-4c84-4586-a80a-84b24cabed32	2026-09-08 10:42	2026-09-08 10:42	2026-09-08 10:42	EWZ	EWZ260918C00040000	call	40.0000	2026-09-18	0.4500	0.4500	0.4600	38.8900	33210.00	0.00	33210.00	738	6	1345	59782	0.0224984108929109	0.339380743443395	0.339380743443395	false	false	false	true
52f7e27a-12aa-4db0-bd08-689b4e1f93bf	2026-09-08 10:42	2026-09-08 10:41	2026-09-08 10:41	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.4900	0.4900	0.5200	38.8950	122500.00	0.00	122500.00	2500	38	16633	14336	1.16022600446429	0.379987380621368	0.379987380621368	false	false	false	true
ed0e5acf-e651-4578-8bbd-6622224cb6cc	2026-09-08 10:33	2026-09-08 10:32	2026-09-08 10:32	EWZ	EWZ261009C00041000	call	41.0000	2026-10-09	1.1000	0.9100	1.3800	39.0050	77220.00	22000.00	49720.00	702	9	703	41	17.1463414634146	0.406916495427686	0.406916495427686	true	false	false	true
ab37610e-a5a7-4aa5-b03c-aaf82e4b30b9	2026-09-08 10:29	2026-09-08 10:29	2026-09-08 10:29	EWZ	EWZ261218C00044000	call	44.0000	2026-12-18	1.6100	1.6000	1.6100	38.9900	48300.00	48300.00	0.00	300	22	25304	7614	3.32335172051484	0.394424425383711	0.394424425383711	false	false	false	true
3440aa75-6671-486f-b8c2-11bbbbc749f4	2026-09-08 10:17	2026-09-08 10:17	2026-09-08 10:17	EWZ	EWZ261023C00044000	call	44.0000	2026-10-23	0.6500	0.5000	0.7200	38.8450	30940.00	9360.00	21580.00	476	12	478	0	0	0.404746312899421	0.404746312899421	false	false	false	true
0bc40c21-a11f-4c81-a49d-286e69ebc592	2026-09-08 10:17	2026-09-08 10:16	2026-09-08 10:16	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.4900	0.4900	0.5200	38.9099	122500.00	0.00	122500.00	2500	50	13170	14336	0.918666294642857	0.374885304203209	0.374885304203209	false	false	false	true
2d414f80-d9a8-4f53-8332-619386301d6a	2026-09-08 10:14	2026-09-08 10:14	2026-09-08 10:14	EWZ	EWZ261120C00044000	call	44.0000	2026-11-20	1.3500	1.3400	1.3600	38.9100	59940.00	59805.00	0.00	444	16	6024	32884	0.183189393017881	0.432202984884132	0.432202984884132	false	false	false	true
f3c95d81-7f49-4018-82a0-d0d20a4d6b97	2026-09-08 10:14	2026-09-08 10:14	2026-09-08 10:14	EWZ	EWZ261120C00044000	call	44.0000	2026-11-20	1.3500	1.3200	1.3600	38.9300	110025.00	110025.00	0.00	815	38	4825	32884	0.146727891983944	0.431194967071137	0.431194967071137	false	false	false	true
54cbd2d1-7a01-4863-8590-d9df8cf0427d	2026-09-08 10:14	2026-09-08 10:14	2026-09-08 10:14	EWZ	EWZ261120C00044000	call	44.0000	2026-11-20	1.3500	1.3500	1.3600	38.9301	39285.00	0.00	39285.00	291	8	4010	32884	0.121943802457122	0.431189926580858	0.431189926580858	true	false	false	true
744ccd08-300b-451c-a972-155e05c8eede	2026-09-08 10:14	2026-09-08 10:14	2026-09-08 10:14	EWZ	EWZ261120C00044000	call	44.0000	2026-11-20	1.3500	1.3500	1.3600	38.9500	16470.00	0.00	16470.00	122	13	3627	32884	0.110296800875806	0.430186788445708	0.430186788445708	false	false	false	true
13ead4f6-e52d-41ea-860f-f810f2d50276	2026-09-08 10:14	2026-09-08 10:13	2026-09-08 10:13	EWZ	EWZ261120C00044000	call	44.0000	2026-11-20	1.3500	1.3500	1.3600	38.9600	13635.00	0.00	13635.00	101	12	3471	32884	0.10555285245104	0.429682637765119	0.429682637765119	false	false	false	true
83b92521-e7f1-49b4-b1ea-a78f6ad9684b	2026-09-08 10:04	2026-09-08 10:04	2026-09-08 10:04	EWZ	EWZ260911C00037500	call	37.5000	2026-09-11	1.7400	1.6300	1.7400	39.0400	34785.00	34278.00	507.00	200	10	203	286	0.70979020979021	0.513362207029458	0.458068706794971	false	false	false	true
2f586641-010e-45c3-801e-8b630038aae5	2026-09-08 10:00	2026-09-08 09:59	2026-09-08 09:59	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.5400	0.5400	0.5700	38.9950	25002.00	0.00	25002.00	463	9	10122	14336	0.7060546875	0.380404044737549	0.380404044737549	false	false	false	true
b8e31ba6-1ae8-4b30-98ad-1823c783d411	2026-09-08 09:57	2026-09-08 09:57	2026-09-08 09:57	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.5500	0.5400	0.5600	39.0100	66440.00	24035.00	42405.00	1208	35	9608	14336	0.670200892857143	0.38205767453622	0.38205767453622	true	false	false	true
bbe1d89f-7524-41b4-82e8-63683f15abec	2026-09-08 09:57	2026-09-08 09:57	2026-09-08 09:57	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.5500	0.5400	0.5500	38.9950	12705.00	12705.00	0.00	231	5	8270	14336	0.576869419642857	0.387496199169897	0.387496199169897	true	false	false	true
a0d92b02-0058-4597-a148-1f07172d4b27	2026-09-08 09:57	2026-09-08 09:57	2026-09-08 09:57	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.5700	0.5600	0.6000	39.0200	46740.00	23028.00	23712.00	820	6	7927	14336	0.552943638392857	0.392589545118855	0.392589545118855	false	false	false	true
00f106ee-7c14-4835-ad02-065054a24d20	2026-09-08 09:54	2026-09-08 09:54	2026-09-08 09:54	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.6000	0.5900	0.6300	39.0663	114420.00	56460.00	57960.00	1907	30	6979	14336	0.48681640625	0.396696372020411	0.396696372020411	true	false	false	true
429a1585-cf0c-4652-9ef5-dee9ba440f65	2026-09-08 09:50	2026-09-08 09:49	2026-09-08 09:49	EWZ	EWZ261120C00044000	call	44.0000	2026-11-20	1.3500	1.3000	1.3600	38.9300	60210.00	52245.00	7965.00	446	24	3165	32884	0.096247415156307	0.431194967071137	0.431194967071137	false	false	false	true
d9a1eb3b-8fad-44d4-bc73-21b6cfeceaa6	2026-09-08 09:49	2026-09-08 09:49	2026-09-08 09:49	EWZ	EWZ261120C00044000	call	44.0000	2026-11-20	1.3500	1.2900	1.3600	38.9114	154575.00	141615.00	12960.00	1145	25	2523	32884	0.0767242427928476	0.432132428800719	0.432132428800719	false	false	false	true
33e87646-61d6-4af2-97ae-91bf3994379e	2026-09-08 09:49	2026-09-08 09:49	2026-09-08 09:49	EWZ	EWZ261120C00044000	call	44.0000	2026-11-20	1.3500	1.3300	1.3700	38.9300	68040.00	0.00	61560.00	504	9	1262	32884	0.0383773263593237	0.431194967071137	0.431194967071137	false	false	false	true
0abe8d08-e170-4b5d-97f5-552e1cfcfacd	2026-09-08 09:48	2026-09-08 09:48	2026-09-08 09:48	EWZ	EWZ270115C00040000	call	40.0000	2027-01-15	3.0500	2.9800	3.0500	38.9850	23790.00	23790.00	0.00	78	13	84	27790	0.00302267002518892	0.355017842225013	0.355017842225013	false	false	false	true
217d6a42-b897-48fe-95ce-ac866e92e448	2026-09-08 09:48	2026-09-08 09:47	2026-09-08 09:47	EWZ	EWZ261120C00044000	call	44.0000	2026-11-20	1.3500	1.3200	1.3500	38.9600	65205.00	65205.00	0.00	483	14	758	32884	0.023050723756234	0.429682637765119	0.429682637765119	false	false	false	true
39c24016-8174-4c81-8dbc-99a9bd693325	2026-09-08 09:48	2026-09-08 09:47	2026-09-08 09:47	EWZ	EWZ261120C00044000	call	44.0000	2026-11-20	1.3500	1.3200	1.3600	38.9705	22005.00	22005.00	0.00	163	19	275	32884	0.00836272959493979	0.429153234897901	0.429153234897901	false	false	false	true
66b339c9-ea5e-4efd-af86-a8640491556e	2026-09-08 09:41	2026-09-08 09:41	2026-09-08 09:41	EWZ	EWZ261120P00039000	put	39.0000	2026-11-20	2.8600	2.8400	2.8600	38.8595	50050.00	50050.00	0.00	175	7	175	847	0.206611570247934	0.425726932166446	0.425726932166446	true	false	false	true
d2d08ca3-677f-4dce-847d-860cb3630f53	2026-09-08 09:32	2026-09-08 09:32	2026-09-08 09:32	EWZ	EWZ261120C00041000	call	41.0000	2026-11-20	2.1000	2.0900	2.1200	38.6850	37170.00	9870.00	27300.00	177	7	182	214958	0.000846677025279357	0.423400293466167	0.423400293466167	false	false	false	true
6a009620-1c5d-40ba-840e-b634123b7451	2026-09-04 15:53	2026-09-04 15:53	2026-09-04 15:53	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.2000	0.1800	0.2100	37.8350	68680.00	38260.00	30420.00	3434	27	13444	317	42.410094637224	0.285723051186882	0.285723051186882	true	false	false	true
8fd6d732-702d-438e-8bd8-88e6c37fe6af	2026-09-04 15:53	2026-09-04 15:53	2026-09-04 15:53	EWZ	EWZ260911C00039000	call	39.0000	2026-09-11	0.2000	0.1800	0.2100	37.8300	200000.00	200000.00	0.00	10000	76	10010	317	31.5772870662461	0.285723051186882	0.286450166978609	true	false	false	true
0bdf337b-90b9-49f5-b051-0d61260ab7a1	2026-09-04 15:50	2026-09-04 15:50	2026-09-04 15:50	EWZ	EWZ261120P00037000	put	37.0000	2026-11-20	2.2800	2.2800	2.2900	37.8350	40812.00	0.00	40812.00	179	10	482	11410	0.0422436459246275	0.412475939190301	0.412475939190301	true	false	false	true
d2cc257d-e6e0-461d-9704-ef1716eb48fc	2026-09-04 15:24	2026-09-04 15:23	2026-09-04 15:23	EWZ	EWZ261016C00037000	call	37.0000	2026-10-16	2.4200	2.4100	2.4300	37.8550	24200.00	0.00	0.00	100	6	5124	83366	0.0614639061487897	0.369325139204871	0.369325139204871	false	false	false	true
c4bd9ecc-8e35-4b0f-97f4-dcf932bb9e9d	2026-09-04 15:18	2026-09-04 15:17	2026-09-04 15:17	EWZ	EWZ261218C00046000	call	46.0000	2026-12-18	0.8200	0.8200	1.0800	37.8600	20418.00	0.00	20418.00	249	29	1421	172367	0.00824403743175898	0.375247154819533	0.375247154819533	false	false	false	true
bd1ec9b9-4217-4d59-9832-f7e6295eb8ca	2026-09-04 15:18	2026-09-04 15:17	2026-09-04 15:17	EWZ	EWZ261218C00045000	call	45.0000	2026-12-18	0.9800	0.9800	1.0200	37.8600	50960.00	0.00	50960.00	520	21	618	92725	0.0066648692369911	0.374059975255173	0.374059975255173	false	false	false	true
518f80e2-1238-48e7-b257-07d58b6e0602	2026-09-04 14:59	2026-09-04 14:59	2026-09-04 14:59	EWZ	EWZ260904P00038000	put	38.0000	2026-09-04	0.1300	0.1200	0.1500	37.8950	17420.00	5421.00	11999.00	1340	38	21461	6104	3.51589121887287	0.397188066408914	0.397188066408914	true	false	false	true
f756194e-04ee-45ec-8ac2-eed371e8dd7a	2026-09-04 14:58	2026-09-04 14:57	2026-09-04 14:57	EWZ	EWZ260918P00036000	put	36.0000	2026-09-18	0.2000	0.1900	0.2000	37.8900	20000.00	20000.00	0.00	1000	8	3603	15816	0.227807283763278	0.289825108959729	0.289825108959729	false	false	false	true
c54ab178-e805-4534-a443-e7648c0a676b	2026-09-04 14:45	2026-09-04 14:45	2026-09-04 14:45	EWZ	EWZ261023C00042500	call	42.5000	2026-10-23	0.6700	0.4400	0.7200	37.9100	39664.00	17420.00	22244.00	592	9	593	292	2.03082191780822	0.375521275125368	0.375521275125368	false	false	false	true
46cc221f-ee66-4414-9dbf-751a688e1bad	2026-09-04 14:22	2026-09-04 14:22	2026-09-04 14:22	EWZ	EWZ261016C00038000	call	38.0000	2026-10-16	1.9800	1.9400	1.9800	37.9550	198000.00	198000.00	0.00	1000	33	3170	34901	0.0908283430274204	0.374002222287242	0.374002222287242	false	false	false	true
d0db6120-63e2-4987-a0ac-b06dd6c13f24	2026-09-04 14:22	2026-09-04 14:22	2026-09-04 14:22	EWZ	EWZ260918C00039000	call	39.0000	2026-09-18	0.4200	0.4100	0.4200	37.9550	21084.00	21084.00	0.00	502	6	928	23235	0.0399397460727351	0.273373426211315	0.273373426211315	true	false	false	true
a39fef6e-42d5-419c-9378-c6d7850e46eb	2026-09-04 14:20	2026-09-04 14:20	2026-09-04 14:20	EWZ	EWZ261016C00041000	call	41.0000	2026-10-16	0.8900	0.8800	0.9000	37.9400	65593.00	65504.00	0.00	737	17	1412	18441	0.0765685158071688	0.377417119517907	0.377417119517907	false	false	false	true
018ad1b8-8b78-4502-9b2b-98e922891da6	2026-09-04 14:14	2026-09-04 14:13	2026-09-04 14:13	EWZ	EWZ261016C00040000	call	40.0000	2026-10-16	1.1500	1.1500	1.1600	37.9500	48530.00	0.00	48530.00	422	21	3545	131987	0.02685870578163	0.369682547343511	0.369682547343511	false	false	false	true
1cdbcf4d-5f66-48f2-a69d-2d1d556628a1	2026-09-04 14:13	2026-09-04 14:13	2026-09-04 14:13	EWZ	EWZ261016C00040000	call	40.0000	2026-10-16	1.1600	1.1500	1.1800	37.9350	164952.00	116.00	164836.00	1422	25	3120	131987	0.023638691689333	0.372883765821921	0.372883765821921	false	false	false	true
5bae6045-72ba-4e1a-8947-414709054420	2026-09-04 13:52	2026-09-04 13:52	2026-09-04 13:52	EWZ	EWZ260904P00038000	put	38.0000	2026-09-04	0.1400	0.1200	0.1400	37.9400	19600.00	19600.00	0.00	1400	29	19324	6104	3.16579292267366	0.455085649830779	0.455085649830779	false	false	false	true
e0f9bbd6-9d3f-497e-8753-38c641e5ced3	2026-09-04 13:51	2026-09-04 13:51	2026-09-04 13:51	EWZ	EWZ261023P00035000	put	35.0000	2026-10-23	0.8100	0.6000	0.8500	37.9450	40905.00	14013.00	26892.00	505	9	507	2	253.5	0.375914951961119	0.375914951961119	false	false	false	true
572c6969-cb21-41ca-b5e8-b608558bac00	2026-09-04 13:37	2026-09-04 13:37	2026-09-04 13:37	EWZ	EWZ261218C00041000	call	41.0000	2026-12-18	2.0300	2.0300	2.0700	37.9900	71456.00	0.00	71456.00	352	8	576	7907	0.0728468445681042	0.374367430276367	0.374367430276367	false	false	false	true
9cede116-7be9-4e01-a33a-d88bb8a54f8d	2026-09-04 13:33	2026-09-04 13:33	2026-09-04 13:33	EWZ	EWZ261120C00042000	call	42.0000	2026-11-20	1.5200	1.5100	1.5400	37.9800	71592.00	71440.00	152.00	471	10	13391	106885	0.125284183936006	0.413133133726234	0.413133133726234	false	false	false	true
bc55ecdd-d058-4604-bae6-308923917ca3	2026-09-04 13:33	2026-09-04 13:33	2026-09-04 13:33	EWZ	EWZ260918P00036000	put	36.0000	2026-09-18	0.1900	0.1600	0.1900	37.9701	19000.00	19000.00	0.00	1000	19	2224	15816	0.140617096611027	0.291593347519981	0.291593347519981	true	false	false	true
c940f856-c7a2-4274-9de7-2f5bfff8dd77	2026-09-04 13:26	2026-09-04 13:26	2026-09-04 13:26	EWZ	EWZ261120C00040000	call	40.0000	2026-11-20	2.1700	2.1700	2.1900	38.0000	57071.00	0.00	57071.00	263	12	1192	112887	0.0105592317981699	0.412537349333554	0.412537349333554	true	false	false	true
16ece7fa-9898-48b9-bcbd-f53d300ac2e6	2026-09-04 13:18	2026-09-04 13:18	2026-09-04 13:18	EWZ	EWZ261120C00050000	call	50.0000	2026-11-20	0.3300	0.3000	0.3300	38.0401	16170.00	16170.00	0.00	490	14	12135	17817	0.681091092776562	0.422023089734233	0.422023089734233	true	false	false	true
3e9050cb-5cc9-491f-89a0-545c068a6919	2026-09-04 13:03	2026-09-04 13:02	2026-09-04 13:02	EWZ	EWZ270319P00027000	put	27.0000	2027-03-19	0.3700	0.3100	0.3700	38.1450	18130.00	18130.00	0.00	490	6	490	1928	0.254149377593361	0.376638600961558	0.376638600961558	false	false	false	true
a6d84758-8c30-4d7a-9eb6-5ffef22cfaee	2026-09-04 12:44	2026-09-04 12:44	2026-09-04 12:44	EWZ	EWZ261016C00046000	call	46.0000	2026-10-16	0.2200	0.1800	0.2200	38.1950	21582.00	21582.00	0.00	981	14	983	29787	0.0330009735790781	0.391968509451983	0.391968509451983	false	false	false	true