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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = EFA×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	price

231d6706-575e-4f2f-a253-d1f8201cb07b	2026-09-21 11:59	2026-09-21 11:58	2026-09-21 11:58	EFA	EFA261130P00101000	put	101.0000	2026-11-30	0.9500	0.8800	0.9500	105.9650	20900.00	5415.00	0.00	220	12	220	495	0.444444444444444	0.166017497912734	0.166017497912734	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	77651223358.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T16:00:04.115943Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
8425351f-c314-456c-b301-5e111c4d24b8	2026-09-21 12:01	2026-09-21 12:01	2026-09-21 12:01	EFA	EFA261023P00102000	put	102.0000	2026-10-23	0.5400	0.5400	0.5700	105.9600	56052.00	0.00	56052.00	1038	19	1039	104	9.99038461538461	0.16332014181928	0.16332014181928	false	false	false	true	false
5a061293-83cc-497e-a610-2128b50e648c	2026-09-21 13:41	2026-09-21 13:41	2026-09-21 13:41	EFA	EFA261016C00104000	call	104.0000	2026-10-16	3.1000	3.1000	3.1500	106.1000	17980.00	0.00	17980.00	58	27	58	394	0.147208121827411	0.149833337105878	0.149833337105878	false	false	false	true	false
630bd318-829b-49a0-a9ed-7c5f09a4ce5d	2026-09-21 15:39	2026-09-21 15:39	2026-09-21 15:39	EFA	EFA261016P00101000	put	101.0000	2026-10-16	0.2700	0.2700	0.3100	106.3250	18684.00	0.00	18684.00	692	20	705	8605	0.0819291109819872	0.173828583071047	0.173828583071047	false	false	false	true	false
d8deeea0-fbed-4a0a-93ab-3a73f7244845	2026-09-21 15:47	2026-09-21 15:47	2026-09-21 15:47	EFA	EFA261016P00102000	put	102.0000	2026-10-16	0.3500	0.3200	0.3600	106.0000	35980.00	35.00	35945.00	1028	23	1093	14254	0.0766802301108461	0.162548175054818	0.162548175054818	false	false	false	true	false
2092b35d-4b9d-4e0a-91e0-61c98bfd94d7	2026-09-22 09:59	2026-09-22 09:59	2026-09-22 09:59	EFA	EFA260925P00106500	put	106.5000	2026-09-25	0.5800	0.5300	0.6000	106.0000	28362.00	25984.00	2378.00	489	20	537	58	9.25862068965517	0.147983298785879	0.147983298785879	false	false	false	true	false
bdb1fe7f-6c72-4468-8d30-6c19a7efd59c	2026-09-22 10:35	2026-09-22 10:35	2026-09-22 10:35	EFA	EFA261016P00108000	put	108.0000	2026-10-16	2.2000	2.1400	2.2800	106.2850	374440.00	374220.00	220.00	1702	10	1706	7275	0.234501718213058	0.124682759342284	0.124682759342284	false	false	false	true	false
77f9e584-1306-4f90-ab38-9ef8c06e78c3	2026-09-22 10:35	2026-09-22 10:35	2026-09-22 10:35	EFA	EFA260925P00108500	put	108.5000	2026-09-25	2.2800	1.9500	2.2800	106.2700	72732.00	72732.00	0.00	319	24	319	132	2.41666666666667	0.180916827102469	0.17839232266135	false	false	false	true	false
64ae25a9-f538-4493-8204-c71375033bc0	2026-09-22 11:41	2026-09-22 11:41	2026-09-22 11:41	EFA	EFA261023P00107000	put	107.0000	2026-10-23	1.9700	1.6800	1.9800	105.9250	24050.00	24050.00	0.00	122	9	122	2	61	0.129823599236416	0.129823599236416	true	false	false	true	false
56cdda7c-b8f1-4e49-acc8-c7b1c923f303	2026-09-22 13:39	2026-09-22 13:39	2026-09-22 13:39	EFA	EFA261120C00111000	call	111.0000	2026-11-20	0.6700	0.6300	0.8400	106.0000	25481.00	3036.00	22445.00	381	8	384	110	3.49090909090909	0.121833207882586	0.122612953996313	false	false	false	true	false
3be73637-c9fb-4a7d-9a18-84034b2d4c84	2026-09-22 13:39	2026-09-22 13:39	2026-09-22 13:39	EFA	EFA270115C00115000	call	115.0000	2027-01-15	0.5500	0.5500	0.7300	106.0000	17808.00	504.00	17304.00	321	39	321	1804	0.177937915742794	0.114977975599014	0.115672439142727	true	false	false	true	false
ec42eb82-aca4-4ab2-a3fa-4bd31b658e56	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	EFA	EFA261120P00115000	put	115.0000	2026-11-20	8.6500	8.6500	9.0000	106.3000	13840.00	0.00	13840.00	16	5	16	0	0	0.183651767880292	0.183651767880292	false	false	false	true	false
dd14d90b-9c90-4479-ab06-48352940fead	2026-09-22 14:23	2026-09-22 14:23	2026-09-22 14:23	EFA	EFA261016C00110000	call	110.0000	2026-10-16	0.2800	0.2200	0.2800	106.4600	18732.00	18732.00	0.00	669	13	684	15954	0.0428732606242948	0.118735398763172	0.118735398763172	false	false	false	true	false
e84ee782-18bb-406a-b437-787dd6ef8965	2026-09-22 15:37	2026-09-22 15:37	2026-09-22 15:37	EFA	EFA261016C00109500	call	109.5000	2026-10-16	0.4400	0.3900	0.4400	106.7300	14388.00	14388.00	0.00	327	43	725	1729	0.419317524580682	0.120335575866509	0.120335575866509	false	false	false	true	false
2dcaf479-2d39-4738-8acb-994bb7c4b512	2026-09-23 10:15	2026-09-23 10:15	2026-09-23 10:15	EFA	EFA261009C00106500	call	106.5000	2026-10-09	0.7100	0.7100	0.7400	105.3150	39547.00	0.00	39547.00	557	40	700	21	33.3333333333333	0.129088798023965	0.129088798023965	true	false	false	true	false
0f046aa1-0474-454c-84ca-c100df7b6c54	2026-09-23 12:42	2026-09-23 12:42	2026-09-23 12:42	EFA	EFA261016C00102000	call	102.0000	2026-10-16	3.7500	3.7500	3.8500	104.0000	31500.00	0.00	31500.00	84	17	120	116	1.03448275862069	0.163771457648403	0.163771457648403	false	false	false	true	false
88735301-e203-492a-ba1a-f08cf41fc0d3	2026-09-23 12:49	2026-09-23 12:49	2026-09-23 12:49	EFA	EFA261016P00105000	put	105.0000	2026-10-16	1.4600	1.4200	1.4600	104.7550	181040.00	181040.00	0.00	1240	33	4821	5933	0.812573740097758	0.140949873755026	0.140015475338583	false	false	false	true	false
29ef6de0-aa97-42f3-a474-714c2855df18	2026-09-23 13:13	2026-09-23 13:13	2026-09-23 13:13	EFA	EFA261016P00104000	put	104.0000	2026-10-16	1.1900	1.1200	1.2000	104.0000	10353.00	2142.00	2142.00	87	8	432	33106	0.013048994140035	0.149336991366211	0.149336991366211	false	false	false	true	false
7819e9bf-42c5-443b-8b8b-be83e9f90c54	2026-09-23 13:13	2026-09-23 13:13	2026-09-23 13:13	EFA	EFA261016P00104000	put	104.0000	2026-10-16	1.1900	1.1200	1.1900	104.0000	19514.00	19514.00	0.00	164	11	596	33106	0.0180027789524557	0.148357481278276	0.149336991366211	false	false	false	true	false
b771faab-02ad-42cc-8790-b7ab77ea1c16	2026-09-23 13:13	2026-09-23 13:13	2026-09-23 13:13	EFA	EFA261016P00105000	put	105.0000	2026-10-16	1.5300	1.5200	1.6300	104.0000	38187.00	2771.00	35416.00	250	6	5074	5933	0.855216585201416	0.146177309927884	0.135664494003345	false	false	false	true	false
baa595c3-65b5-4496-9454-530374a9338c	2026-09-23 14:28	2026-09-23 14:28	2026-09-23 14:28	EFA	EFA261016P00105000	put	105.0000	2026-10-16	1.4400	1.4100	1.4400	104.8350	72000.00	72000.00	0.00	500	7	6386	5933	1.07635260407888	0.14182148168539	0.14182148168539	false	false	false	true	false
b07e621e-c142-42a5-823e-142061c81117	2026-09-23 14:57	2026-09-23 14:57	2026-09-23 14:57	EFA	EFA270115P00085000	put	85.0000	2027-01-15	0.4200	0.3700	0.4800	104.8699	68754.00	68712.00	42.00	1637	45	1649	8694	0.189671037497124	0.268150238029723	0.268150238029723	false	false	false	true	false
612bc6d7-3b83-4ac3-9bac-45e7093d18c3	2026-09-23 15:27	2026-09-23 15:27	2026-09-23 15:27	EFA	EFA270115P00085000	put	85.0000	2027-01-15	0.4400	0.4000	0.4400	104.0000	12364.00	12364.00	0.00	281	31	1961	8694	0.225557855992639	0.270556154585768	0.270556154585768	false	false	false	true	false
e87f65a0-07a6-46e3-bb61-020228621ddd	2026-09-23 15:42	2026-09-23 15:42	2026-09-23 15:42	EFA	EFA270115P00085000	put	85.0000	2027-01-15	0.4200	0.3500	0.4500	104.8450	31920.00	31878.00	42.00	760	15	2752	8694	0.316540142627099	0.267937182745195	0.267937182745195	false	false	false	true	false
532ba146-6faf-42e5-a995-4bdbd8af8da4	2026-09-23 15:47	2026-09-23 15:47	2026-09-23 15:47	EFA	EFA260930C00105000	call	105.0000	2026-09-30	0.7700	0.6900	0.7700	104.8250	23177.00	23177.00	0.00	301	42	301	2889	0.104188300449983	0.140953235322804	0.140953235322804	true	false	false	true	false
b576c494-69a9-4b6c-9885-e29c6e1a5a0c	2026-09-23 15:47	2026-09-23 15:47	2026-09-23 15:47	EFA	EFA260930C00105000	call	105.0000	2026-09-30	0.7700	0.7300	0.7700	104.8250	12474.00	12474.00	0.00	162	20	564	2889	0.195223260643821	0.140953235322804	0.140953235322804	true	false	false	true	false
7aa1d588-d237-4640-adf4-2616c5dc1d80	2026-09-24 10:47	2026-09-24 10:47	2026-09-24 10:47	EFA	EFA261218P00105000	put	105.0000	2026-12-18	3.1000	3.0000	3.3000	104.0000	13950.00	13330.00	620.00	45	7	195	2854	0.0683251576734408	0.161922183097912	0.161922183097912	false	false	false	true	false
44a59bec-2db2-4a5f-b214-259e68fe33dc	2026-09-24 10:52	2026-09-24 10:51	2026-09-24 10:51	EFA	EFA261016P00104000	put	104.0000	2026-10-16	1.2500	1.1800	1.2500	104.2900	10250.00	10250.00	0.00	82	19	247	33216	0.0074361753371869	0.147682980058303	0.147682980058303	false	false	false	true	false
a1923d9e-a487-492f-a2b7-cf30bd0818a3	2026-09-24 11:07	2026-09-24 11:07	2026-09-24 11:07	EFA	EFA261218P00105000	put	105.0000	2026-12-18	3.2500	3.0000	3.2500	104.0600	11050.00	11050.00	0.00	34	10	229	2854	0.0802382620882971	0.1643120746979	0.1643120746979	false	false	false	true	false