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:alert_rule = RepeatedHits×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

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
57dcfadc-2f86-4d61-9d9b-8223886d23ae	2026-09-03 15:12	2026-09-03 15:12	2026-09-03 15:12	EFA	EFA260911C00108000	call	108.0000	2026-09-11	0.9300	0.9300	0.9500	108.2550	128805.00	0.00	128805.00	1385	9	1462	1661	0.880192655027092	0.116729822996353	0.116729822996353	false	false	false	true
1b806afb-7925-4cc9-895d-76da4733d122	2026-09-02 11:22	2026-09-02 11:22	2026-09-02 11:22	EFA	EFA261002C00107000	call	107.0000	2026-10-02	1.7100	1.7000	1.8900	106.8150	316349.00	0.00	316349.00	1850	27	1852	19	97.4736842105263	0.133717945697701	0.132898085436731	false	false	false	true
b63973b4-7ce4-41d5-93a4-8f5acb48a5db	2026-09-02 11:00	2026-09-02 11:00	2026-09-02 11:00	EFA	EFA260918C00108000	call	108.0000	2026-09-18	0.7400	0.7400	0.7800	106.8600	98346.00	0.00	98346.00	1329	10	1943	7510	0.258721704394141	0.128982699472831	0.128982699472831	false	false	false	true
5c0cb9e1-6d72-4e19-a592-b5d9e74de880	2026-09-02 10:56	2026-09-02 10:56	2026-09-02 10:56	EFA	EFA260918C00106500	call	106.5000	2026-09-18	1.5200	1.5200	1.6100	106.8942	111112.00	0.00	111112.00	731	43	736	0	0	0.136064651513609	0.136064651513609	false	false	false	true
3fd202dd-fc6e-4df3-823f-f4887693c311	2026-09-01 10:42	2026-09-01 10:42	2026-09-01 10:42	EFA	EFA260918C00107000	call	107.0000	2026-09-18	1.3100	1.3100	1.4200	107.0050	61832.00	0.00	61832.00	472	20	510	4816	0.105897009966777	0.131367086343869	0.131367086343869	false	false	false	true
d65b1baf-3fd1-4394-ba64-e8f5b3afec45	2026-09-01 10:11	2026-09-01 10:11	2026-09-01 10:11	EFA	EFA260911P00106000	put	106.0000	2026-09-11	0.4200	0.4200	0.4300	107.1800	68040.00	0.00	68040.00	1620	11	1655	89	18.5955056179775	0.13164671472348	0.13164671472348	false	false	false	true
25f348cb-979a-45de-84bc-33c4f4537f93	2026-08-28 15:31	2026-08-28 15:31	2026-08-28 15:31	EFA	EFA260828C00103500	call	103.5000	2026-08-28	4.2500	3.9500	4.3500	107.7425	65450.00	29325.00	36125.00	154	7	237	559	0.42397137745975	2.3747273603348	2.3747273603348	false	false	false	true
24ed7f84-d5bc-420c-b327-a1068b6b00c4	2026-08-27 14:28	2026-08-27 14:28	2026-08-27 14:28	EFA	EFA260904C00106500	call	106.5000	2026-09-04	1.7200	1.7200	1.8100	107.7950	100964.00	0.00	100964.00	587	24	587	43	13.6511627906977	0.135344950680528	0.135344950680528	false	false	false	true
e3b43ab0-9fbd-4161-921d-d59f3c748b6c	2026-08-27 12:58	2026-08-27 12:57	2026-08-27 12:57	EFA	EFA260925P00107500	put	107.5000	2026-09-25	1.1900	1.1100	1.2000	107.9550	115906.00	119.00	115787.00	974	13	974	7	139.142857142857	0.128022586380872	0.128022586380872	false	false	false	true