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×

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

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	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	78577396949.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T15:08:24.285262Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
f98d7de4-ad57-42b2-969b-46d48b7c2817	2026-09-21 11:50	2026-09-21 11:50	2026-09-21 11:50	EFA	EFA261016C00109500	call	109.5000	2026-10-16	0.3400	0.3000	0.3900	106.0900	10064.00	9044.00	1020.00	296	11	799	0	0	0.121793537847169	0.121793537847169	false	false	false	true	false
935c052e-0043-4da2-a109-f1a2a09f7eee	2026-09-21 11:08	2026-09-21 11:08	2026-09-21 11:08	EFA	EFA261016C00106000	call	106.0000	2026-10-16	1.6500	1.6300	1.6500	106.0100	45870.00	34485.00	0.00	278	5	300	8273	0.0362625407953584	0.135391174028181	0.135391174028181	false	false	false	true	false
aa76c198-ab04-4634-9afc-4ec1ffcce9cd	2026-09-18 14:38	2026-09-18 14:38	2026-09-18 14:38	EFA	EFA260918C00100000	call	100.0000	2026-09-18	4.9500	4.8500	5.0000	104.9250	453915.00	422730.00	495.00	917	18	3917	14100	0.277801418439716	1.97299508784323	1.97299508784323	false	false	false	true	false
b2bceb3a-9fdb-4663-bb0a-64ec91ece8e2	2026-09-18 12:44	2026-09-18 12:44	2026-09-18 12:44	EFA	EFA261023C00105000	call	105.0000	2026-10-23	1.9400	1.9100	2.0100	104.7750	269466.00	194.00	269272.00	1389	15	1511	0	0	0.142719210341508	0.142719210341508	false	false	false	true	false
a14d74f2-4827-4d6b-8c5d-21d48162e4bd	2026-09-18 10:48	2026-09-18 10:48	2026-09-18 10:48	EFA	EFA261002C00105000	call	105.0000	2026-10-02	1.0600	1.0600	1.0800	104.6700	62540.00	0.00	62540.00	590	6	591	20	29.55	0.140107338188227	0.140107338188227	false	false	false	true	false
dd251f84-47e1-47b7-88c3-9541700b8f8a	2026-09-18 10:23	2026-09-18 10:23	2026-09-18 10:23	EFA	EFA270319P00095000	put	95.0000	2027-03-19	1.6800	1.4600	1.7900	104.8162	10069920.00	10069920.00	0.00	59940	6	59940	16	3746.25	0.207863066794504	0.207863066794504	false	true	true	false	false
196b7fbb-8f22-4376-8372-3d19d4219ec8	2026-09-17 14:49	2026-09-17 14:49	2026-09-17 14:49	EFA	EFA261016P00104000	put	104.0000	2026-10-16	0.8800	0.7800	0.9100	106.0150	747007.00	747007.00	0.00	8489	6	9173	40550	0.226214549938348	0.151109980964882	0.151109980964882	false	false	false	true	false
d5304a4d-e7cd-435a-8a02-b4bbf4187b28	2026-09-17 14:44	2026-09-17 14:44	2026-09-17 14:44	EFA	EFA261016C00108000	call	108.0000	2026-10-16	0.8700	0.8700	0.8900	105.9800	122844.00	0.00	122844.00	1412	10	1936	704	2.75	0.13065046706877	0.13065046706877	false	false	false	true	false
eb8203f0-f9dc-47d6-bb0c-fef0ad6c69cc	2026-09-17 14:16	2026-09-17 14:15	2026-09-17 14:15	EFA	EFA261016P00106000	put	106.0000	2026-10-16	1.4700	1.3800	1.4900	106.0500	226233.00	294.00	225939.00	1539	20	1576	5471	0.288064339243283	0.138992499246016	0.138992499246016	false	false	false	true	false
00b87426-e316-4560-bd44-30a26ae0e11a	2026-09-17 10:54	2026-09-17 10:53	2026-09-17 10:53	EFA	EFA261016C00107000	call	107.0000	2026-10-16	1.4300	1.4000	1.5000	106.1650	105959.00	282.00	105677.00	741	21	773	684	1.13011695906433	0.139364097769071	0.137680333690625	true	false	false	true	false
edc96ba2-a2d9-4f9e-a905-afaf9c629d05	2026-09-16 12:11	2026-09-16 12:11	2026-09-16 12:11	EFA	EFA261016P00104000	put	104.0000	2026-10-16	1.0000	0.8800	1.0800	105.9258	849996.00	849900.00	96.00	8500	5	8500	37410	0.227211975407645	0.156706310238059	0.156706310238059	false	false	false	true	false
779111dd-7c9d-4577-87b5-dbc2515674b6	2026-09-15 15:09	2026-09-15 15:09	2026-09-15 15:09	EFA	EFA270319C00105000	call	105.0000	2027-03-19	6.1000	5.6500	6.2000	105.4450	93330.00	71370.00	21960.00	153	29	153	121	1.26446280991736	0.155630912907176	0.155630912907176	false	false	false	true	false
6b7f90da-47aa-4778-80f3-d01070ee85f7	2026-09-15 14:06	2026-09-15 14:06	2026-09-15 14:06	EFA	EFA260918C00105000	call	105.0000	2026-09-18	1.0800	1.0100	1.0800	105.4250	72694.00	67500.00	0.00	674	56	676	1991	0.339527875439478	0.21286839557379	0.218257993906983	false	false	false	true	false
61b6caaf-24cc-4fb9-82e2-aa4632a464c7	2026-09-15 11:50	2026-09-15 11:50	2026-09-15 11:50	EFA	EFA290119C00090000	call	90.0000	2029-01-19	25.1500	24.8500	27.9500	105.3900	125750.00	25150.00	100600.00	50	5	1155	0	0	0.114593816103225	0.114593816103225	false	false	false	true	false
9697d52d-edd6-4ff3-b1b3-304266c64f82	2026-09-14 15:24	2026-09-14 15:24	2026-09-14 15:24	EFA	EFA260925C00106000	call	106.0000	2026-09-25	1.2300	1.2300	1.3300	106.0650	127059.00	0.00	127059.00	1033	29	1043	1	1043	0.154617302263395	0.154617302263395	false	false	false	true	false
c0f2c5eb-0fe3-499e-b41b-bf374063be5b	2026-09-14 14:47	2026-09-14 14:47	2026-09-14 14:47	EFA	EFA261023C00108000	call	108.0000	2026-10-23	1.3000	1.1700	1.5400	106.1900	122522.00	13392.00	102630.00	942	32	942	2	471	0.137185697940289	0.138681254933857	true	false	false	true	false
23be4bed-7639-46e9-b647-6c16f8e864a1	2026-09-14 09:53	2026-09-14 09:53	2026-09-14 09:53	EFA	EFA260925P00106000	put	106.0000	2026-09-25	1.1700	1.0300	1.1800	105.8150	71019.00	9594.00	58500.00	607	29	612	54	11.3333333333333	0.155183483062038	0.155183483062038	false	false	false	true	false
2e32059b-8279-48ae-8bd8-4bcbc2bc023a	2026-09-10 14:40	2026-09-10 14:40	2026-09-10 14:40	EFA	EFA260918P00104000	put	104.0000	2026-09-18	0.5000	0.4700	0.5100	105.5900	68100.00	67750.00	350.00	1362	19	1366	4772	0.286253143336127	0.185725014452699	0.185725014452699	false	false	false	true	false
f0fd64e4-c5eb-4ebb-9ce3-5f2c9ef6ae27	2026-09-10 12:36	2026-09-10 12:36	2026-09-10 12:36	EFA	EFA261016P00104000	put	104.0000	2026-10-16	1.2600	1.1600	1.2600	105.7200	154980.00	154980.00	0.00	1230	30	2090	39335	0.0531333418075505	0.164529293676863	0.164529293676863	false	false	false	true	false
9bba609f-f9c7-4b4a-8576-5d62e53dec88	2026-09-10 11:58	2026-09-10 11:58	2026-09-10 11:58	EFA	EFA260930P00105000	put	105.0000	2026-09-30	1.0800	1.0400	1.0800	105.8099	79920.00	79920.00	0.00	740	29	741	5193	0.142692085499711	0.156630888384889	0.156630888384889	false	false	false	true	false
38b6438b-73cd-42ef-9308-23a2d66dfb14	2026-09-08 12:16	2026-09-08 12:16	2026-09-08 12:16	EFA	EFA261002C00108000	call	108.0000	2026-10-02	1.6100	1.6100	1.7800	107.9900	141680.00	0.00	141680.00	880	18	880	1203	0.731504571903574	0.133864921613802	0.133864921613802	false	false	false	true	false