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×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

3fbcbf89-9a93-4d74-aa3f-40d2112b72e9	2026-08-17 14:08	2026-08-17 14:08	2026-08-17 14:08	EFA	EFA261120P00110000	put	110.0000	2026-11-20	3.6000	3.1500	3.6000	108.0000	115560.00	114840.00	0.00	321	7	321	1	321	0.150812593455641	0.150812593455641	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	78086187165.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
81f34150-b16a-4a2e-a083-690bfcaa9521	2026-08-17 14:55	2026-08-17 14:55	2026-08-17 14:55	EFA	EFA270319P00110000	put	110.0000	2027-03-19	5.3000	4.9500	7.3000	108.3900	202455.00	182850.00	19605.00	382	11	1221	70	17.4428571428571	0.174590794967856	0.174590794967856	false	false	false	true
7d3a1235-4ab9-49a5-95ae-db55f55c6f8d	2026-08-17 15:46	2026-08-17 15:46	2026-08-17 15:46	EFA	EFA260821C00109000	call	109.0000	2026-08-21	0.3500	0.3500	0.3800	108.4851	55860.00	0.00	55860.00	1596	48	6710	22791	0.294414461848975	0.121882650032341	0.121882650032341	false	false	false	true
23614642-7712-460d-8998-4fa53698ea4b	2026-08-18 10:48	2026-08-18 10:48	2026-08-18 10:48	EFA	EFA260918P00107000	put	107.0000	2026-09-18	1.3500	1.3300	1.5200	107.5700	57093.00	19162.00	37931.00	424	30	424	111	3.81981981981982	0.141376217708173	0.142196811857404	true	false	false	true
5c051ab0-7feb-4027-8a09-54c2e3c6c8ce	2026-08-20 10:53	2026-08-20 10:53	2026-08-20 10:53	EFA	EFA260918C00110000	call	110.0000	2026-09-18	0.7400	0.6600	0.7500	107.5500	93462.00	1258.00	92204.00	1263	14	1268	54390	0.0233131090273947	0.129301372033483	0.129301372033483	false	false	false	true
1a5f7f79-0a97-4d84-8b71-055fac7a90bb	2026-08-20 11:39	2026-08-20 11:39	2026-08-20 11:39	EFA	EFA260918C00108000	call	108.0000	2026-09-18	1.5500	1.5500	1.6400	107.4050	120125.00	0.00	120125.00	775	23	775	2589	0.29934337582078	0.139137879479757	0.139137879479757	false	false	false	true
e52f9cf2-f69c-45d2-b952-777712320881	2026-08-20 14:56	2026-08-20 14:56	2026-08-20 14:56	EFA	EFA260821C00106000	call	106.0000	2026-08-21	1.3500	1.3500	1.5000	107.2400	68580.00	0.00	405.00	508	5	519	18131	0.0286250068942695	0.22030615707491	0.22030615707491	true	false	false	true
237e62a0-66fe-4f08-8ade-186f6b3060c0	2026-08-21 10:00	2026-08-21 10:00	2026-08-21 10:00	EFA	EFA260821C00105000	call	105.0000	2026-08-21	3.3000	3.1000	3.3000	108.2850	88110.00	88110.00	0.00	267	10	400	14329	0.0279154162886454	0.577819436885858	0.577819436885858	true	false	false	true
fcf09585-b63e-4f18-a6c9-594256325b0c	2026-08-21 15:36	2026-08-21 15:36	2026-08-21 15:36	EFA	EFA260918C00110000	call	110.0000	2026-09-18	0.9200	0.9200	0.9300	108.2150	94208.00	0.00	94208.00	1024	13	1139	55661	0.0204631609205728	0.12818900448512	0.12818900448512	false	false	false	true
f9fe0f71-03e2-458e-81ad-274799573981	2026-08-24 10:50	2026-08-24 10:50	2026-08-24 10:50	EFA	EFA260918C00109000	call	109.0000	2026-09-18	1.1300	1.1300	1.1400	107.9500	125769.00	0.00	125769.00	1113	17	1304	23254	0.0560763739571687	0.13102106734365	0.13102106734365	false	false	false	true
65c45561-36bc-4635-8785-af48eb4d31b3	2026-08-24 11:15	2026-08-24 11:15	2026-08-24 11:15	EFA	EFA260918C00109000	call	109.0000	2026-09-18	1.1200	1.1200	1.1500	107.9100	134960.00	0.00	134960.00	1205	11	2514	23254	0.108110432613744	0.131647016188542	0.131647016188542	false	false	false	true
b87b1da3-aab9-4c11-8316-a9b9c435bb5b	2026-08-25 12:04	2026-08-25 12:04	2026-08-25 12:04	EFA	EFA260918P00108000	put	108.0000	2026-09-18	1.1000	1.0600	1.1100	108.6050	118690.00	110.00	118580.00	1079	8	1353	1218	1.11083743842365	0.135247027225798	0.135247027225798	false	false	false	true
3a278b4d-4935-4d57-9355-27eb50c50f05	2026-08-25 12:44	2026-08-25 12:44	2026-08-25 12:44	EFA	EFA260918P00108000	put	108.0000	2026-09-18	1.1000	1.0400	1.1300	108.5651	137940.00	5060.00	132880.00	1254	10	2608	1218	2.14121510673235	0.133755717650065	0.133755717650065	false	false	false	true
69f8cc83-9b7c-4269-a116-5f1655da6258	2026-08-27 11:32	2026-08-27 11:31	2026-08-27 11:31	EFA	EFA260918C00108000	call	108.0000	2026-09-18	1.3200	1.3200	1.4100	107.7900	103884.00	0.00	103884.00	787	15	796	4088	0.194716242661448	0.123293560113718	0.123293560113718	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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