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:endpoint = /api/option-trades/flow-alerts×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	expiry

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
e26491aa-c7e0-4835-926f-bd611daea007	2026-08-17 14:55	2026-08-17 14:55	2026-08-17 14:55	EFA	EFA270319P00110000	put	110.0000	2027-03-19	5.2800	4.6500	7.4500	108.3800	442930.00	382510.00	60420.00	839	27	839	70	11.9857142857143	0.174454325245951	0.174454325245951	false	false	false
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
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
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
204a1b68-3d73-4f44-b93e-532bf2b8210a	2026-08-19 12:40	2026-08-19 12:40	2026-08-19 12:40	EFA	EFA260831C00109000	call	109.0000	2026-08-31	0.4500	0.4300	0.5400	107.6250	56173.00	45.00	56128.00	1249	13	1326	9275	0.142964959568733	0.117501210699993	0.120442311648866	false	false	false
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
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
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
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
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
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
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
90b3a46c-fa30-4bc7-ac61-97406d96127a	2026-08-24 15:59	2026-08-24 15:59	2026-08-24 15:59	EFA	EFA260911C00108000	call	108.0000	2026-09-11	1.3000	1.3000	1.5100	108.0450	146625.00	0.00	146625.00	1126	39	1126	8	140.75	0.122610605275478	0.122610605275478	true	false	false
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
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
91c777df-9e34-4582-ad40-203442f6074d	2026-08-26 10:59	2026-08-26 10:59	2026-08-26 10:59	EFA	EFA260918C00111000	call	111.0000	2026-09-18	0.4700	0.4600	0.4800	108.4200	58134.00	48.00	58086.00	1237	12	2766	19385	0.142687645086407	0.12111476713463	0.118782957721794	false	false	false
05761bec-b01a-4737-9e00-e1a27f1cdf47	2026-08-26 12:22	2026-08-26 12:22	2026-08-26 12:22	EFA	EFA260918C00110000	call	110.0000	2026-09-18	0.6700	0.6600	0.8000	108.2900	82797.00	144.00	82653.00	1231	76	1236	55428	0.022299198960814	0.114781573240646	0.120861538437658	true	false	false
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
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
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
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
b7a3363c-77b2-4aad-b158-3a81e3864c43	2026-08-31 12:46	2026-08-31 12:46	2026-08-31 12:46	EFA	EFA261016C00112000	call	112.0000	2026-10-16	0.5400	0.4300	0.6200	107.3950	625644.00	625644.00	0.00	11586	2	11586	579	20.0103626943005	0.124367217305081	0.124367217305081	false	true	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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