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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 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 = ELF×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

50085508-b274-4813-8da8-e1b5cde7ebfb	2026-09-21 15:26	2026-09-21 15:26	2026-09-21 15:26	ELF	ELF261016P00100000	put	100.0000	2026-10-16	6.2000	5.8500	6.5000	98.5150	47120.00	46500.00	620.00	76	24	106	1210	0.087603305785124	0.539620748219015	0.538882450403463	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	5770391929.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T19:30:17.874351Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
a31e8cfc-bd67-4608-8562-1fdd649f4bcb	2026-09-21 10:46	2026-09-21 10:46	2026-09-21 10:46	ELF	ELF270115C00110000	call	110.0000	2027-01-15	8.3000	7.8000	8.3000	96.1000	25730.00	25730.00	0.00	31	16	34	330	0.103030303030303	0.595475559554368	0.595475559554368	false	false	false	true
e935565c-bccc-400d-9494-b315f18f7156	2026-09-18 15:42	2026-09-18 15:41	2026-09-18 15:41	ELF	ELF261009C00103000	call	103.0000	2026-10-09	2.5200	2.0300	2.5200	96.7500	25704.00	25704.00	0.00	102	33	108	1	108	0.519862043005061	0.519862043005061	false	false	false	true
73d70ed3-8c98-470c-adb3-6c8169b53396	2026-09-18 14:46	2026-09-18 14:46	2026-09-18 14:46	ELF	ELF260918C00090000	call	90.0000	2026-09-18	6.7000	5.0000	6.7000	96.5650	20100.00	20100.00	0.00	30	8	39	702	0.0555555555555556	4.01907321488241	4.01907321488241	false	false	false	true
e55eecde-8423-4761-b220-b16f73fd5a3a	2026-09-18 14:20	2026-09-18 14:20	2026-09-18 14:20	ELF	ELF260925C00100000	call	100.0000	2026-09-25	1.3100	1.0400	1.3100	95.8400	24366.00	24366.00	0.00	186	45	884	671	1.31743666169896	0.537760562789382	0.537760562789382	true	false	false	true
d0ecb903-da49-4a90-9a1a-39e4fbcd6f60	2026-09-18 10:49	2026-09-18 10:49	2026-09-18 10:49	ELF	ELF260925C00092000	call	92.0000	2026-09-25	4.1000	4.0500	4.4000	94.5400	30750.00	28700.00	2050.00	75	13	638	632	1.00949367088608	0.502625131004451	0.502625131004451	false	false	false	true
99315a1f-0e3a-43f2-93d5-8ef3465e5044	2026-09-18 09:40	2026-09-18 09:40	2026-09-18 09:40	ELF	ELF260925C00092000	call	92.0000	2026-09-25	3.4000	3.2000	3.4000	93.7200	31960.00	31960.00	0.00	94	11	253	632	0.400316455696203	0.467986599503918	0.467986599503918	false	false	false	true
2c43d080-00ea-4230-8929-5f4884d502b3	2026-09-18 09:40	2026-09-18 09:40	2026-09-18 09:40	ELF	ELF260925C00092000	call	92.0000	2026-09-25	3.4000	3.1500	3.4000	93.7200	24135.00	18355.00	0.00	71	9	159	632	0.251582278481013	0.467986599503918	0.457779776744128	true	false	false	true
ac20eef7-92a3-4521-9959-d2ef84e90e32	2026-09-17 10:32	2026-09-17 10:32	2026-09-17 10:32	ELF	ELF270115C00095000	call	95.0000	2027-01-15	11.5500	11.1000	11.9000	91.4700	58900.00	40425.00	17325.00	51	12	52	543	0.0957642725598527	0.598688730925795	0.599208288825342	false	false	false	true
c593ba32-16c3-4b2b-9ef8-ef081bd6a136	2026-09-16 15:54	2026-09-16 15:54	2026-09-16 15:54	ELF	ELF280121C00100000	call	100.0000	2028-01-21	27.0000	27.0000	27.5500	93.0000	218700.00	0.00	178200.00	81	5	140	422	0.33175355450237	0.645512684422983	0.645512684422983	false	false	false	true
64460351-d596-4615-98fc-bcb27e1a464b	2026-09-16 14:50	2026-09-16 14:50	2026-09-16 14:50	ELF	ELF261218P00050000	put	50.0000	2026-12-18	0.3000	0.3000	0.4100	93.3200	10920.00	0.00	10920.00	364	13	697	705	0.988652482269504	0.683798930469879	0.683798930469879	false	false	false	true
4b6c98fd-7551-4198-b357-6cc21ffa4e0e	2026-09-16 10:58	2026-09-16 10:58	2026-09-16 10:58	ELF	ELF270115C00150000	call	150.0000	2027-01-15	1.8900	1.5800	1.8900	95.1350	15687.00	15687.00	0.00	83	14	83	344	0.241279069767442	0.596207642066228	0.596207642066228	false	false	false	true
068bc47b-1204-41fa-a5f9-910aef7ec563	2026-09-16 10:58	2026-09-16 10:58	2026-09-16 10:58	ELF	ELF270115C00145000	call	145.0000	2027-01-15	2.2700	1.9400	2.2700	95.1350	13393.00	13393.00	0.00	59	9	59	170	0.347058823529412	0.595266714725174	0.595266714725174	false	false	false	true
b65e9040-2678-4a19-b388-0d33a6f1c3d3	2026-09-15 12:09	2026-09-15 12:09	2026-09-15 12:09	ELF	ELF261016P00100000	put	100.0000	2026-10-16	7.7000	7.3500	8.1000	96.7500	43890.00	41580.00	2310.00	57	8	68	1219	0.0557834290401969	0.538186354777667	0.538186354777667	false	false	false	true
76eeedfa-dee6-4d39-a6ae-6b08f8ff6212	2026-09-15 11:24	2026-09-15 11:24	2026-09-15 11:24	ELF	ELF270115P00075000	put	75.0000	2027-01-15	3.9000	3.7000	3.9000	97.1500	12480.00	12480.00	0.00	32	14	32	517	0.0618955512572534	0.62175922350348	0.62175922350348	false	false	false	true
29a4e5a3-692a-425b-8cd8-d9aa401bbb51	2026-09-14 10:20	2026-09-14 10:20	2026-09-14 10:20	ELF	ELF261016P00090000	put	90.0000	2026-10-16	3.5000	3.5000	3.5500	95.0000	88550.00	0.00	88550.00	253	24	362	437	0.82837528604119	0.557111283860873	0.557111283860873	false	false	false	true
aefd5383-037b-4c0d-8e69-122f54d31bf1	2026-09-14 10:20	2026-09-14 10:19	2026-09-14 10:19	ELF	ELF261016P00090000	put	90.0000	2026-10-16	3.5500	3.5500	3.6000	95.0000	28400.00	0.00	28400.00	80	6	94	437	0.215102974828375	0.562076276571212	0.562076276571212	false	false	false	true
9f14e3b0-5c50-4399-bc55-6071877601e5	2026-09-11 12:31	2026-09-11 12:30	2026-09-11 12:30	ELF	ELF260911C00091000	call	91.0000	2026-09-11	6.2000	4.2500	6.2500	97.3300	13020.00	13020.00	0.00	21	9	21	2	10.5	0.52165692572637	0.52165692572637	true	false	false	true
71b7c0d5-74b0-4c52-9d96-022e2bbe9bb2	2026-09-11 12:31	2026-09-11 12:30	2026-09-11 12:30	ELF	ELF260911C00090000	call	90.0000	2026-09-11	7.2000	5.4000	7.2000	97.3300	13680.00	13680.00	0.00	19	7	19	12	1.58333333333333	0.52165692572637	0.52165692572637	true	false	false	true
4a4a712e-ff07-4a8f-94da-83ac5fb27f66	2026-09-10 11:50	2026-09-10 11:50	2026-09-10 11:50	ELF	ELF260918C00098000	call	98.0000	2026-09-18	3.0500	3.0500	3.4000	97.7323	37210.00	0.00	37210.00	122	32	122	4	30.5	0.543969105560968	0.543969105560968	false	false	false	true
50cfc0a3-0d1d-4cb5-989a-f93147d82e33	2026-09-10 10:12	2026-09-10 10:12	2026-09-10 10:12	ELF	ELF270219P00090000	put	90.0000	2027-02-19	11.3000	10.1500	11.3000	96.7400	11300.00	1130.00	0.00	10	10	10	32	0.3125	0.618453516267469	0.618453516267469	false	false	false	true
cb6bbf4c-ee41-43c2-9cb6-09caf4b91871	2026-09-09 15:44	2026-09-09 15:44	2026-09-09 15:44	ELF	ELF261016P00110000	put	110.0000	2026-10-16	12.5000	12.5000	12.9000	100.5200	125000.00	0.00	1250.00	100	10	104	130	0.8	0.531387718584386	0.531387718584386	false	false	false	true
54b769b5-0633-4ba1-b4da-160b8dcf128e	2026-09-09 13:36	2026-09-09 13:36	2026-09-09 13:36	ELF	ELF261120P00100000	put	100.0000	2026-11-20	10.4500	10.4500	10.7500	100.4800	10450.00	0.00	10450.00	10	10	41	151	0.271523178807947	0.625283060845401	0.627481673368728	true	false	false	true
dfbe7b4f-df52-43d8-bcdc-25d56325f82b	2026-09-09 13:26	2026-09-09 13:26	2026-09-09 13:26	ELF	ELF261016P00095000	put	95.0000	2026-10-16	4.2000	3.9500	4.2000	100.3150	60060.00	60060.00	0.00	143	25	147	1201	0.122398001665279	0.538945279456287	0.538945279456287	true	false	false	true
3617c38b-763e-49d4-a681-aa4160c47b47	2026-09-09 12:56	2026-09-09 12:55	2026-09-09 12:55	ELF	ELF270115C00125000	call	125.0000	2027-01-15	6.6500	6.4500	6.6500	100.0000	40565.00	40565.00	0.00	61	22	73	264	0.276515151515151	0.587173042047162	0.587173042047162	false	false	false	true
6ca50f8e-a4db-4f66-8d1c-88bbbb282ce2	2026-09-09 10:35	2026-09-09 10:35	2026-09-09 10:35	ELF	ELF260918C00107000	call	107.0000	2026-09-18	1.6800	1.6800	1.8800	102.0000	12600.00	0.00	12600.00	75	23	77	26	2.96153846153846	0.540455641250432	0.540455641250432	false	false	false	true
93b3195c-44ee-4a1d-a6c9-adc5b56c132c	2026-09-08 12:06	2026-09-08 12:06	2026-09-08 12:06	ELF	ELF261016C00110000	call	110.0000	2026-10-16	5.3500	5.1500	5.3500	105.2400	102720.00	102720.00	0.00	192	29	217	293	0.74061433447099	0.52914732770545	0.52914732770545	false	false	false	true
eec5d924-398f-4069-8c91-7c809ef16f46	2026-09-04 13:02	2026-09-04 13:02	2026-09-04 13:02	ELF	ELF261016C00120000	call	120.0000	2026-10-16	3.2000	2.9800	3.2000	108.5200	21760.00	21760.00	0.00	68	27	89	1879	0.047365620010644	0.482105052485652	0.482105052485652	false	false	false	true
09008dcc-6cb0-47f3-93a4-f94bafcaf26a	2026-09-04 11:00	2026-09-04 11:00	2026-09-04 11:00	ELF	ELF260918C00115000	call	115.0000	2026-09-18	1.4500	1.2800	1.5000	107.6700	17836.00	17545.00	147.00	123	33	138	559	0.246869409660107	0.46813903839277	0.471083634231263	false	false	false	true
9ee6ba30-ea40-4e21-8489-8eca2c56003e	2026-09-03 12:11	2026-09-03 12:11	2026-09-03 12:11	ELF	ELF270219P00105000	put	105.0000	2027-02-19	15.4000	14.9000	16.1500	107.3400	32340.00	30800.00	1540.00	21	5	100	78	1.28205128205128	0.611924111721724	0.611924111721724	false	false	false	true
effa85da-7680-45a1-9bfe-4cf53eef9817	2026-09-01 14:20	2026-09-01 14:20	2026-09-01 14:20	ELF	ELF261016C00115000	call	115.0000	2026-10-16	3.9000	3.9000	4.7000	106.0600	39000.00	0.00	39000.00	100	5	527	3228	0.163258983890954	0.476410520105875	0.476410520105875	false	false	false	true
7662644d-b7e0-4ce2-91de-81c0f0e89d94	2026-09-01 13:51	2026-09-01 13:51	2026-09-01 13:51	ELF	ELF260918C00108000	call	108.0000	2026-09-18	4.3000	4.3000	4.6500	107.0000	67510.00	0.00	67510.00	157	18	167	108	1.5462962962963	0.507683352614941	0.507683352614941	false	false	false	true
00748113-7ace-434c-9169-2c0f57d7aa5b	2026-09-01 11:28	2026-09-01 11:28	2026-09-01 11:28	ELF	ELF280121C00155000	call	155.0000	2028-01-21	20.4000	19.1000	20.4500	108.4850	122400.00	91800.00	30600.00	60	8	98	75	1.30666666666667	0.62111964451503	0.62111964451503	false	false	false	true
f3eb4578-ea14-4f13-98c9-dc579095e2ab	2026-08-31 15:25	2026-08-31 15:25	2026-08-31 15:25	ELF	ELF280121C00210000	call	210.0000	2028-01-21	11.7000	11.1500	11.8000	108.7900	37440.00	4680.00	32760.00	32	5	404	408	0.990196078431373	0.612724988675418	0.612724988675418	true	false	false	true
5deca495-cbdf-4150-ab15-7f0293bea4ae	2026-08-31 15:22	2026-08-31 15:22	2026-08-31 15:22	ELF	ELF280121C00210000	call	210.0000	2028-01-21	11.7500	11.7500	11.9500	108.9800	29375.00	0.00	7050.00	25	7	247	408	0.605392156862745	0.612484664865076	0.612484664865076	false	false	false	true
e15699e3-3a33-427d-965c-fc3702018e96	2026-08-31 13:55	2026-08-31 13:55	2026-08-31 13:55	ELF	ELF261218C00150000	call	150.0000	2026-12-18	3.5500	3.1500	3.5500	108.0000	14555.00	14555.00	0.00	41	15	44	16	2.75	0.5820394374635	0.5820394374635	false	false	false	true
2226a9c9-cd5d-4f99-9944-6d1c6156617f	2026-08-31 11:51	2026-08-31 11:51	2026-08-31 11:51	ELF	ELF261016C00125000	call	125.0000	2026-10-16	2.9400	2.7100	2.9400	109.2999	140238.00	140238.00	0.00	477	43	485	222	2.18468468468468	0.510287750903022	0.510287750903022	false	false	false	true
913c210b-9bd4-40ea-897b-4a262952c2fb	2026-08-31 11:43	2026-08-31 11:43	2026-08-31 11:43	ELF	ELF280121P00050000	put	50.0000	2028-01-21	4.3500	4.1000	4.6500	109.2050	10440.00	5655.00	1305.00	24	7	24	344	0.0697674418604651	0.691566526264691	0.691566526264691	false	false	false	true
73771857-ce3c-4a77-ac11-03f28ecc658a	2026-08-31 10:52	2026-08-31 10:52	2026-08-31 10:52	ELF	ELF260918C00108000	call	108.0000	2026-09-18	5.1000	3.0500	5.1500	108.2050	53500.00	51000.00	2500.00	105	36	105	6	17.5	0.523065313603808	0.50114884104116	true	false	false	true
cb1a635b-36ff-4187-8183-320d59d12ee4	2026-08-31 10:35	2026-08-31 10:35	2026-08-31 10:35	ELF	ELF260911C00115000	call	115.0000	2026-09-11	1.0100	1.0000	1.0700	107.2700	10278.00	2163.00	8115.00	102	12	139	101	1.37623762376238	0.472582261288549	0.472582261288549	false	false	false	true
bd3cfb32-e317-49a2-ae3b-374650c70b1a	2026-08-27 10:58	2026-08-27 10:58	2026-08-27 10:58	ELF	ELF261218P00065000	put	65.0000	2026-12-18	1.1000	1.1000	1.3900	106.6300	56650.00	0.00	56650.00	515	26	515	9	57.2222222222222	0.652874181535974	0.652874181535974	false	false	false	true
419ed570-fc00-4cad-9419-5df8348997bc	2026-08-26 13:40	2026-08-26 13:40	2026-08-26 13:40	ELF	ELF260918C00105000	call	105.0000	2026-09-18	7.1500	6.2500	7.1500	107.0350	21450.00	21450.00	0.00	30	5	95	867	0.10957324106113	0.560375551920877	0.560375551920877	false	false	false	true
3d04ba9c-00b9-4515-b3e8-394fd253d3c9	2026-08-26 12:46	2026-08-26 12:46	2026-08-26 12:46	ELF	ELF261120C00115000	call	115.0000	2026-11-20	9.7000	8.7000	10.0500	106.9300	36860.00	3880.00	32980.00	38	5	38	89	0.426966292134831	0.606062270726659	0.606062270726659	false	false	false	true
f52f9416-41e5-4508-932f-998beedf1636	2026-08-25 13:15	2026-08-25 13:15	2026-08-25 13:15	ELF	ELF260904P00109000	put	109.0000	2026-09-04	5.7500	5.7500	5.9500	105.2700	44850.00	0.00	44850.00	78	23	148	5	29.6	0.513049976244137	0.517948836695733	false	false	false	true
ddacb919-27aa-4ae8-988e-1b946fdd4a5d	2026-08-24 12:59	2026-08-24 12:59	2026-08-24 12:59	ELF	ELF261016P00105000	put	105.0000	2026-10-16	8.0500	8.0000	8.3500	105.0600	27370.00	6440.00	20930.00	34	21	114	5	22.8	0.526655458335481	0.526231217063017	false	false	false	true
b08c1403-f5ae-4207-90cf-718097e796ac	2026-08-24 12:54	2026-08-24 12:54	2026-08-24 12:54	ELF	ELF260918P00105000	put	105.0000	2026-09-18	5.6500	5.6000	6.0000	104.7025	10170.00	565.00	9605.00	18	16	27	9	3	0.516048929006747	0.516048929006747	false	false	false	true
d73e0806-37ce-438e-af95-40f929e8a906	2026-08-24 11:24	2026-08-24 11:24	2026-08-24 11:24	ELF	ELF261120C00125000	call	125.0000	2026-11-20	6.2000	5.6000	6.2000	104.8899	39060.00	39060.00	0.00	63	20	64	235	0.272340425531915	0.612087256813334	0.612087256813334	false	false	false	true
737b8638-c1a5-47d0-8edb-bfd97c306eed	2026-08-21 15:01	2026-08-21 15:01	2026-08-21 15:01	ELF	ELF270219C00110000	call	110.0000	2027-02-19	14.6000	13.7000	15.2000	100.7700	21900.00	2920.00	18980.00	15	5	17	98	0.173469387755102	0.614578906238237	0.614578906238237	false	false	false	true
fca4cd0b-538e-4e69-9e11-293765f738eb	2026-08-21 12:16	2026-08-21 12:16	2026-08-21 12:16	ELF	ELF260918C00110000	call	110.0000	2026-09-18	2.6200	2.6100	2.8100	101.0500	11004.00	0.00	11004.00	42	5	60	398	0.150753768844221	0.513385513843629	0.513385513843629	false	false	false	true
7c061987-cbfb-4d9a-9a15-75665256e6ad	2026-08-21 11:23	2026-08-21 11:23	2026-08-21 11:23	ELF	ELF261016C00125000	call	125.0000	2026-10-16	2.0400	1.8000	2.0500	101.4300	29988.00	29784.00	204.00	147	26	147	80	1.8375	0.534079652035461	0.532220958141908	true	false	false	true