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

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

19d8a567-6170-439a-8d53-3a6e53692f6d	2026-09-21 11:50	2026-09-21 11:50	2026-09-21 11:50	TMF	TMF260925C00028000	call	28.0000	2026-09-25	2.1500	1.6300	2.2300	30.1500	57405.00	57405.00	0.00	267	10	349	490	0.712244897959184	0.177259891529936	0.531340808476556	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	2154780161.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T15:52:20.515056Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
8fd4c7c4-cd30-4687-9d7a-0332b5a5450c	2026-09-17 14:12	2026-09-17 14:12	2026-09-17 14:12	TMF	TMF260925P00029500	put	29.5000	2026-09-25	0.3500	0.3300	0.3900	30.1850	23904.00	139.00	23765.00	683	5	800	989	0.808897876643074	0.365527816668856	0.35926101583244	true	false	false	true
2125e99c-a5cf-4bde-89f5-af7f1bec23a9	2026-09-17 10:54	2026-09-17 10:54	2026-09-17 10:54	TMF	TMF290119C00030000	call	30.0000	2029-01-19	6.0000	4.5500	7.4500	30.0200	15000.00	3000.00	12000.00	25	8	25	45	0.555555555555556	0.245068071230278	0.245068071230278	false	false	false	true
9708bb8f-c3fe-4c5f-bea2-b248b7498a7b	2026-09-16 13:01	2026-09-16 13:01	2026-09-16 13:01	TMF	TMF260918C00030000	call	30.0000	2026-09-18	0.3100	0.2900	0.3100	29.6200	10850.00	10850.00	0.00	350	23	957	2143	0.446570228651423	0.537987425314364	0.537987425314364	false	false	false	true
124ca9fb-7cc4-47f7-b1a1-c866ade965bc	2026-09-16 12:38	2026-09-16 12:38	2026-09-16 12:38	TMF	TMF261030C00030500	call	30.5000	2026-10-30	0.9900	0.6000	1.0000	29.5500	16727.00	9603.00	7124.00	169	7	185	25	7.4	0.326326972901765	0.326326972901765	true	false	false	true
858d4db2-cd0c-4371-a532-6d26a8414149	2026-09-16 10:07	2026-09-16 10:07	2026-09-16 10:07	TMF	TMF261016P00028000	put	28.0000	2026-10-16	0.7500	0.6600	0.7500	29.4150	15000.00	15000.00	0.00	200	10	200	552	0.36231884057971	0.419300678412667	0.419300678412667	false	false	false	true
1d6e9b2c-f56c-4097-86a1-57e8cad3854a	2026-09-14 12:29	2026-09-14 12:29	2026-09-14 12:29	TMF	TMF260925P00033000	put	33.0000	2026-09-25	3.6500	3.6000	3.9000	29.7400	10950.00	2555.00	8395.00	30	5	53	111	0.477477477477477	0.704641436801063	0.704641436801063	false	false	false	true
4ed21f5c-3af2-41f1-b054-b499d7cfec9f	2026-09-14 11:48	2026-09-14 11:48	2026-09-14 11:48	TMF	TMF261120P00028000	put	28.0000	2026-11-20	1.1000	0.9300	1.1000	29.6350	33110.00	33110.00	0.00	301	8	301	6281	0.0479223053653877	0.383556690089104	0.383556690089104	true	false	false	true
7e6e6459-b5a2-4c6e-abc2-64379be30a1b	2026-09-14 10:14	2026-09-14 10:14	2026-09-14 10:14	TMF	TMF261016C00025000	call	25.0000	2026-10-16	4.2000	3.7000	4.9000	29.1100	126000.00	50400.00	50400.00	300	10	300	300	1	0.191551082777634	0.191551082777634	true	false	false	true
a804d707-0993-4890-8f5c-790e4bca640d	2026-09-11 15:22	2026-09-11 15:22	2026-09-11 15:22	TMF	TMF260918P00031000	put	31.0000	2026-09-18	1.7400	1.7400	1.9900	29.3108	139200.00	0.00	116928.00	800	10	869	9158	0.0948897139113344	0.327882318903289	0.327882318903289	false	false	false	true
f06218ec-8101-412f-93a8-d3bc2ee773f2	2026-09-11 14:16	2026-09-11 14:16	2026-09-11 14:16	TMF	TMF261002C00031000	call	31.0000	2026-10-02	0.2700	0.2400	0.2700	29.4650	13311.00	5643.00	0.00	493	7	569	629	0.904610492845787	0.276095307805887	0.276095307805887	false	false	false	true
0330a9b5-77cc-4eea-b5cc-142edf6918c9	2026-09-11 14:06	2026-09-11 14:06	2026-09-11 14:06	TMF	TMF261016P00031000	put	31.0000	2026-10-16	2.2700	2.1300	2.3400	29.4600	11140.00	5672.00	5468.00	49	5	53	210	0.252380952380952	0.389357461418157	0.392257741485448	true	false	false	true
82e873ef-d59a-4f72-b399-36832d7ad248	2026-09-11 10:08	2026-09-11 10:08	2026-09-11 10:08	TMF	TMF261016P00029000	put	29.0000	2026-10-16	1.0000	0.8000	1.1400	29.7350	30000.00	12300.00	17700.00	300	5	301	543	0.554327808471455	0.381932356825231	0.381932356825231	false	false	false	true
719e2e9a-282d-4582-9a23-ce0c0e1b66a6	2026-09-10 10:19	2026-09-10 10:19	2026-09-10 10:19	TMF	TMF260918P00030000	put	30.0000	2026-09-18	0.8000	0.8000	0.8800	29.6300	12000.00	0.00	12000.00	150	33	302	8363	0.0361114432619873	0.34772774850917	0.34772774850917	false	false	false	true
61ad3da5-214f-44eb-bdc2-21dd44c61de7	2026-09-09 09:35	2026-09-09 09:35	2026-09-09 09:35	TMF	TMF261016C00032000	call	32.0000	2026-10-16	0.8000	0.8000	1.0300	30.9500	12000.00	0.00	80.00	150	27	150	441	0.340136054421769	0.302373540769591	0.302373540769591	false	false	false	true
19b8b981-d2f2-4c9c-851f-b414abf4e104	2026-09-04 14:57	2026-09-04 14:57	2026-09-04 14:57	TMF	TMF260918C00031000	call	31.0000	2026-09-18	0.6100	0.6100	0.6400	30.8600	16470.00	0.00	16470.00	270	21	411	705	0.582978723404255	0.271754050671284	0.271754050671284	false	false	false	true
6e93b548-e473-4167-85dd-f53cb629c035	2026-09-03 15:32	2026-09-03 15:32	2026-09-03 15:32	TMF	TMF261120C00031000	call	31.0000	2026-11-20	1.6800	1.6200	1.6800	30.8400	20999.00	20999.00	0.00	125	32	258	685	0.376642335766423	0.287300507739925	0.287300507739925	true	false	false	true
2edc1b27-2a1f-4055-80a4-46d2716dcc33	2026-09-03 14:31	2026-09-03 14:31	2026-09-03 14:31	TMF	TMF260925P00031000	put	31.0000	2026-09-25	1.1200	0.9300	1.1200	30.8800	12655.00	12655.00	0.00	113	8	120	223	0.538116591928251	0.361905765027704	0.361905765027704	true	false	false	true
df6f2366-5e56-4b17-994f-8f6e52a6e599	2026-08-31 14:18	2026-08-31 14:18	2026-08-31 14:18	TMF	TMF261120C00027000	call	27.0000	2026-11-20	4.1000	4.1000	4.2000	30.0000	78720.00	0.00	78720.00	192	23	204	12	17	0.232556653873389	0.232556653873389	true	false	false	true
90f9ccd2-6358-49cf-a71c-8b2b1195accc	2026-08-28 11:50	2026-08-28 11:50	2026-08-28 11:50	TMF	TMF260918C00030000	call	30.0000	2026-09-18	1.9700	1.9700	2.0200	31.0000	20094.00	0.00	20094.00	102	12	156	361	0.43213296398892	0.292586467439685	0.292586467439685	false	false	false	true
5bc4c17e-231b-412b-acdd-531957e691f5	2026-08-27 11:37	2026-08-27 11:37	2026-08-27 11:37	TMF	TMF260828C00029000	call	29.0000	2026-08-28	2.7500	2.6100	2.9600	31.7600	27500.00	6050.00	21450.00	100	6	116	138	0.840579710144927	1.32007478274961	1.65062221285866	false	false	false	true
df52f3e4-e6a8-440a-aa04-fd689ec456c3	2026-08-26 11:53	2026-08-26 11:53	2026-08-26 11:53	TMF	TMF260925P00032500	put	32.5000	2026-09-25	1.8500	1.3200	1.9500	31.6704	14029.00	9591.00	4438.00	76	17	76	54	1.40740740740741	0.3950645589101	0.397853753962254	true	false	false	true
d5ea89f5-f31e-47e1-9aa4-797e31cf3cce	2026-08-26 11:53	2026-08-26 11:53	2026-08-26 11:53	TMF	TMF260925P00031500	put	31.5000	2026-09-25	1.2200	1.0300	1.2200	31.6704	53435.00	53435.00	0.00	438	26	438	114	3.84210526315789	0.374448918163192	0.374448918163192	true	false	false	true
b8b3e607-8097-4f33-af2e-8358036f1346	2026-08-24 10:10	2026-08-24 10:10	2026-08-24 10:10	TMF	TMF261120C00034000	call	34.0000	2026-11-20	0.8700	0.8700	0.9500	31.0750	13050.00	0.00	13050.00	150	8	150	651	0.230414746543779	0.299286699415455	0.299286699415455	false	false	false	true
48309bcd-788e-4139-83f0-73ab80170a4a	2026-08-24 10:10	2026-08-24 10:09	2026-08-24 10:09	TMF	TMF270219C00040000	call	40.0000	2027-02-19	0.5900	0.5900	0.7700	31.0700	18408.00	0.00	18408.00	312	11	312	231	1.35064935064935	0.318187944623082	0.318187944623082	false	false	false	true
c0f24cfc-1862-4a4c-ac78-73aa68c93fc6	2026-08-21 15:05	2026-08-21 15:05	2026-08-21 15:05	TMF	TMF260904C00027500	call	27.5000	2026-09-04	3.0500	3.0000	3.0500	30.4412	13725.00	12810.00	0.00	45	11	45	0	0	0.364637543523635	0.364637543523635	true	false	false	true
5d018c43-beb7-4aa1-ba1c-8041ce66aeb8	2026-08-21 13:37	2026-08-21 13:37	2026-08-21 13:37	TMF	TMF260918P00030000	put	30.0000	2026-09-18	0.8700	0.8300	0.8700	30.4100	12267.00	12267.00	0.00	141	28	6422	1093	5.87557182067704	0.331689244739509	0.330437195871875	false	false	false	true
ffb6a2e3-a78c-4b18-87f5-14631619a38b	2026-08-21 12:20	2026-08-21 12:20	2026-08-21 12:20	TMF	TMF260918P00030000	put	30.0000	2026-09-18	0.8700	0.8700	0.8800	30.4200	45501.00	0.00	45501.00	523	19	5771	1093	5.27996340347667	0.331689244739509	0.331689244739509	false	false	false	true
3f7666b6-95f3-4df9-99db-c86c61622c96	2026-08-21 12:20	2026-08-21 12:20	2026-08-21 12:20	TMF	TMF260918P00030000	put	30.0000	2026-09-18	0.8700	0.8600	0.8700	30.4300	31320.00	31320.00	0.00	360	14	5235	1093	4.78956999085087	0.332938125698399	0.332938125698399	false	false	false	true
ad5cf23f-f56f-4a65-8fd2-9c63b27357ad	2026-08-21 12:20	2026-08-21 12:20	2026-08-21 12:20	TMF	TMF260918P00030000	put	30.0000	2026-09-18	0.8700	0.8600	0.8700	30.4300	44370.00	44370.00	0.00	510	17	4875	1093	4.46020128087832	0.332938125698399	0.332938125698399	false	false	false	true
c6920437-a39b-4cf6-98b6-e2abd096c609	2026-08-21 12:20	2026-08-21 12:20	2026-08-21 12:20	TMF	TMF260918P00030000	put	30.0000	2026-09-18	0.8700	0.8600	0.8800	30.4200	48981.00	0.00	46371.00	563	19	4215	1093	3.85635864592864	0.331689244739509	0.331689244739509	false	false	false	true
c8052725-75e3-4281-8d1b-c7056363175e	2026-08-21 12:20	2026-08-21 12:20	2026-08-21 12:20	TMF	TMF260918P00030000	put	30.0000	2026-09-18	0.8700	0.8600	0.8900	30.4200	53505.00	0.00	53070.00	615	15	3651	1093	3.34034766697164	0.331689244739509	0.331689244739509	false	false	false	true
7d19b250-a78e-427b-b69c-edb557541af9	2026-08-21 12:20	2026-08-21 12:20	2026-08-21 12:20	TMF	TMF260918P00030000	put	30.0000	2026-09-18	0.8700	0.8700	0.8800	30.4150	85608.00	0.00	85608.00	984	16	3036	1093	2.77767612076853	0.331063618258683	0.331063618258683	false	false	false	true
326c67fa-0a6d-4af0-bf09-6da320532b6e	2026-08-21 12:20	2026-08-21 12:20	2026-08-21 12:20	TMF	TMF260918P00030000	put	30.0000	2026-09-18	0.8800	0.8700	0.8800	30.4112	31680.00	31680.00	0.00	360	12	1555	1093	1.42268984446478	0.333640306258882	0.333640306258882	false	false	false	true
6a26577d-f0be-4cab-b8be-e22cf42298fb	2026-08-21 12:20	2026-08-21 12:19	2026-08-21 12:19	TMF	TMF260918P00030000	put	30.0000	2026-09-18	0.8800	0.8800	0.8900	30.4100	28336.00	0.00	28336.00	322	13	874	1093	0.799634034766697	0.333489758840537	0.333489758840537	false	false	false	true
4a0f6e68-466f-4e10-b132-5b9c066cbf52	2026-08-21 12:20	2026-08-21 12:19	2026-08-21 12:19	TMF	TMF260918P00030000	put	30.0000	2026-09-18	0.8800	0.8800	0.8900	30.4150	18216.00	0.00	18216.00	207	9	552	1093	0.505032021957914	0.334116737798489	0.334116737798489	false	false	false	true
5ea39694-5115-4daf-a6a2-f500744d50e8	2026-08-21 12:19	2026-08-21 12:19	2026-08-21 12:19	TMF	TMF260918P00030000	put	30.0000	2026-09-18	0.8800	0.8800	0.8900	30.4150	26136.00	0.00	26136.00	297	14	345	1093	0.315645013723696	0.334116737798489	0.334116737798489	false	false	false	true
37277f5f-ebaa-4148-a18a-09d3fbe053a7	2026-08-21 09:43	2026-08-21 09:43	2026-08-21 09:43	TMF	TMF260821P00033000	put	33.0000	2026-08-21	2.3600	2.3400	2.3600	30.6199	23600.00	22420.00	0.00	100	11	100	206	0.485436893203884	1.00871026360111	1.00871026360111	true	false	false	true
b72e21a1-5bcc-4300-8efc-e629139f1457	2026-08-21 09:32	2026-08-21 09:32	2026-08-21 09:32	TMF	TMF270115P00026000	put	26.0000	2027-01-15	0.9300	0.9100	0.9500	30.5750	27249.00	0.00	0.00	293	9	4353	54	80.6111111111111	0.385647427859356	0.385647427859356	false	false	false	true
227911bc-2a3f-407d-a54b-3234c7c110a8	2026-08-21 09:32	2026-08-21 09:32	2026-08-21 09:32	TMF	TMF270115P00026000	put	26.0000	2027-01-15	0.9300	0.9300	0.9300	30.5750	12927.00	0.00	0.00	139	5	4492	54	83.1851851851852	0.385647427859356	0.385647427859356	true	false	false	true
f484ee14-403b-4dc6-99dc-de3f1ca7aa74	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	TMF	TMF270115P00026000	put	26.0000	2027-01-15	0.9100	0.9100	0.9300	30.6099	30030.00	0.00	30030.00	330	17	4044	54	74.8888888888889	0.383205302469699	0.383205302469699	false	false	false	true
a99e3ada-6e7e-4db6-98d8-bae22823f842	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	TMF	TMF270115P00026000	put	26.0000	2027-01-15	0.9100	0.9000	0.9100	30.6100	19019.00	4368.00	0.00	209	18	2863	54	53.0185185185185	0.383208946553012	0.383208946553012	false	false	false	true
440d0a6b-0b3b-4082-959e-2b7a4e5a0580	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	TMF	TMF270115P00026000	put	26.0000	2027-01-15	0.9400	0.8900	0.9400	30.6100	30604.00	30604.00	0.00	325	16	2652	54	49.1111111111111	0.388781655665636	0.388781655665636	false	false	false	true
a4ee7443-4b52-471b-a1e4-3811e26832d3	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	TMF	TMF270115P00026000	put	26.0000	2027-01-15	0.9600	0.5700	1.0200	30.6300	21504.00	9984.00	1248.00	224	17	224	54	4.14814814814815	0.393208244306536	0.393208244306536	false	false	false	true
d333343f-ee66-4d8d-930c-6f147f6044bf	2026-08-20 13:03	2026-08-20 13:03	2026-08-20 13:03	TMF	TMF261002P00028000	put	28.0000	2026-10-02	0.4600	0.4600	0.5100	30.8550	14950.00	0.00	12512.00	325	12	494	31	15.9354838709677	0.374363180682434	0.374363180682434	false	false	false	true
e9b47ab7-383c-4ebb-9101-408e57b38336	2026-08-20 11:06	2026-08-20 11:06	2026-08-20 11:06	TMF	TMF260918C00032000	call	32.0000	2026-09-18	0.7500	0.6300	0.7500	31.0550	13500.00	13500.00	0.00	180	10	383	782	0.489769820971867	0.317636293051036	0.317636293051036	false	false	false	true
eb0d9613-1ee7-4b88-a611-7042ac4e5883	2026-08-20 09:35	2026-08-20 09:35	2026-08-20 09:35	TMF	TMF260828C00030000	call	30.0000	2026-08-28	1.1100	1.0400	1.1100	30.7600	26529.00	26529.00	0.00	239	15	239	234	1.02136752136752	0.358476667922281	0.358476667922281	false	false	false	true
17d19c6e-1aff-410e-bdeb-ea58283b4e42	2026-08-19 11:01	2026-08-19 11:01	2026-08-19 11:01	TMF	TMF260828C00028000	call	28.0000	2026-08-28	3.6200	3.6000	3.7000	31.5850	13756.00	0.00	13756.00	38	8	100	170	0.588235294117647	0.356693177313862	0.356693177313862	false	false	false	true
930aa5a6-0965-41f6-b71e-83b98e2517d3	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	TMF	TMF260828P00031000	put	31.0000	2026-08-28	0.4700	0.4100	0.4700	31.2950	23453.00	23453.00	0.00	499	24	501	757	0.661822985468956	0.317158574525836	0.317158574525836	false	false	false	true
e0ffc156-e975-4930-be88-014f05fc7f55	2026-08-18 15:20	2026-08-18 15:20	2026-08-18 15:20	TMF	TMF260821C00030000	call	30.0000	2026-08-21	0.4500	0.4400	0.4800	30.1850	21195.00	315.00	5175.00	471	16	1858	500	3.716	0.316246025333903	0.316246025333903	true	false	false	true