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 = RepeatedHitsAscendingFill×ticker = AS×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

21ad322e-4f41-497c-821e-d377e5ad577c	2026-08-17 10:14	2026-08-17 10:14	2026-08-17 10:14	AS	AS260918P00030000	put	30.0000	2026-09-18	1.0300	0.8000	1.2000	32.2750	24805.00	3470.00	630.00	240	41	241	6346	0.0379766782225024	0.535437428322602	0.550742597287634	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Consumer Cyclical	15363736512.00	2026-11-17	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a98ad1e2-51a0-4c78-8b34-c221e0b4f0ef	2026-08-17 13:20	2026-08-17 13:20	2026-08-17 13:20	AS	AS260821P00032500	put	32.5000	2026-08-21	1.7900	1.5500	1.8000	32.4100	17888.00	17888.00	0.00	100	6	1118	10853	0.103012991799502	1.28606158674427	1.30085629958229	false	false	false	true
0ec250f1-e239-4240-afe2-88fea9a1fbc3	2026-08-17 13:33	2026-08-17 13:33	2026-08-17 13:33	AS	AS260821P00032500	put	32.5000	2026-08-21	1.7900	1.6500	1.8000	32.3950	17896.00	17896.00	0.00	100	6	1225	10853	0.112872016953838	1.28072492686307	1.29552377947628	false	false	false	true
5f44e9b1-1854-4f56-b7b5-7a121cebd5bd	2026-08-17 13:59	2026-08-17 13:59	2026-08-17 13:59	AS	AS260821P00032500	put	32.5000	2026-08-21	1.7600	1.6000	1.8000	32.0000	17615.00	17615.00	0.00	100	9	1460	10853	0.134525016124574	1.31408975305623	1.32884904602496	false	false	false	true
44158273-eda8-462d-8117-cd1a66b43d5c	2026-08-17 15:55	2026-08-17 15:55	2026-08-17 15:55	AS	AS260821C00032500	call	32.5000	2026-08-21	1.8300	1.6500	1.9000	32.5600	53558.00	48008.00	5550.00	292	22	4780	29895	0.159892958688744	1.30142415523605	1.33588098593834	true	false	false	true
6bedaa33-a955-4f80-81f6-e17c54371c26	2026-08-18 09:33	2026-08-18 09:33	2026-08-18 09:33	AS	AS260821C00030000	call	30.0000	2026-08-21	4.5200	3.9000	4.6000	34.3800	45152.00	45152.00	0.00	100	7	102	2352	0.0433673469387755	1.06660282503921	1.06660282503921	false	false	false	true
49dd6db7-453d-4716-b1ad-fb5c72ee5ff2	2026-08-18 10:09	2026-08-18 10:09	2026-08-18 10:09	AS	AS260821C00035000	call	35.0000	2026-08-21	0.2000	0.1500	0.4500	33.8150	63682.00	4050.00	59532.00	3142	75	3413	10841	0.314823355778987	0.467643947816527	0.548472184975603	true	false	false	true
eadab151-5536-40fc-976c-ee9f864332f7	2026-08-18 10:09	2026-08-18 10:09	2026-08-18 10:09	AS	AS260918C00040000	call	40.0000	2026-09-18	0.3000	0.2500	0.3500	33.7950	80916.00	3032.00	77884.00	2693	8	41340	5299	7.8014719758445	0.480713061087371	0.480713061087371	false	false	false	true
881072ef-8c7e-426e-995d-c16f716fa5ca	2026-08-18 10:59	2026-08-18 10:59	2026-08-18 10:59	AS	AS260918C00030000	call	30.0000	2026-09-18	4.1900	4.1000	4.5000	33.7200	29340.00	0.00	29340.00	70	7	171	3316	0.0515681544028951	0.419049170660801	0.440548663864833	false	false	false	true
bc6a574d-192c-4fb5-940b-911e4dc4da7e	2026-08-18 11:11	2026-08-18 11:11	2026-08-18 11:11	AS	AS260918C00035000	call	35.0000	2026-09-18	1.2000	1.1500	1.2000	33.4700	59995.00	59995.00	0.00	500	8	2822	29022	0.0972365791468541	0.453456199259192	0.456105278920097	false	false	false	true
05a87f5d-2018-444f-a4ef-84fee965f184	2026-08-18 11:13	2026-08-18 11:13	2026-08-18 11:13	AS	AS260821C00032500	call	32.5000	2026-08-21	1.3000	1.1500	1.3000	33.3700	38958.00	38958.00	0.00	300	27	2729	29524	0.0924332746240347	0.647800041263506	0.657103716654748	false	false	false	true
7451298a-8ff7-453e-a60e-17b1e3775a78	2026-08-18 13:26	2026-08-18 13:25	2026-08-18 13:25	AS	AS260918C00035000	call	35.0000	2026-09-18	1.1000	1.0000	1.1000	33.3700	54994.00	54994.00	0.00	500	11	5057	29022	0.174247122872304	0.437326053346659	0.440009437247461	false	false	false	true
d04d42fb-adec-44f8-ba49-d7c5032ab7a1	2026-08-19 09:55	2026-08-19 09:54	2026-08-19 09:54	AS	AS260918C00035000	call	35.0000	2026-09-18	1.4000	1.2500	1.5500	34.0600	102520.00	98880.00	3640.00	734	49	970	30308	0.0320047512207998	0.454260692303157	0.453026061857035	false	false	false	true
d52940a6-6449-44bb-b09d-7d4c866b92b5	2026-08-19 10:40	2026-08-19 10:40	2026-08-19 10:40	AS	AS260918C00035000	call	35.0000	2026-09-18	1.3500	1.3000	1.4000	33.9500	147926.00	147791.00	0.00	1092	28	5434	30308	0.179292596014254	0.452810565978777	0.465817615220442	false	false	false	true
35441e86-b4d5-416a-9836-9651179ec6bd	2026-08-19 10:41	2026-08-19 10:41	2026-08-19 10:41	AS	AS260918C00035000	call	35.0000	2026-09-18	1.3900	1.3000	1.4500	33.9700	51524.00	50969.00	280.00	370	47	5805	30308	0.191533588491487	0.453385728877604	0.463501090768348	false	false	false	true
3e173be7-ef1d-49dc-8c06-da1166f39cd9	2026-08-19 12:38	2026-08-19 12:37	2026-08-19 12:37	AS	AS260821C00032500	call	32.5000	2026-08-21	1.9000	1.9000	2.1500	34.3900	156010.00	0.00	156010.00	821	36	6182	21255	0.290849211950129	0.336698764715807	0.336698764715807	false	false	false	true
7fa47f64-de2f-4b17-8c75-243fdbdd2442	2026-08-19 15:46	2026-08-19 15:46	2026-08-19 15:46	AS	AS261218C00040000	call	40.0000	2026-12-18	1.9300	1.8000	1.9500	34.5100	11600.00	11600.00	0.00	60	5	393	59	6.66101694915254	0.463941393271341	0.463941393271341	false	false	false	true
5a6ed4b7-46c3-4186-8f1d-15f50967b6fc	2026-08-20 11:33	2026-08-20 11:33	2026-08-20 11:33	AS	AS260918C00032500	call	32.5000	2026-09-18	1.6000	1.5000	1.6000	32.3500	58362.00	58362.00	0.00	365	38	3087	7723	0.399715136604946	0.444226165691454	0.446978505272918	false	false	false	true
0a5d2523-07f5-4ae2-b2c7-e0adcaffa961	2026-08-20 15:51	2026-08-20 15:50	2026-08-20 15:50	AS	AS260918C00035000	call	35.0000	2026-09-18	0.8500	0.8000	0.8500	32.7550	11966.00	11966.00	0.00	141	9	19913	33146	0.600766306643336	0.447418582651628	0.450405488685901	false	false	false	true
f9777910-571c-458e-bc1c-9429cfa62a37	2026-08-20 15:52	2026-08-20 15:51	2026-08-20 15:51	AS	AS260918C00035000	call	35.0000	2026-09-18	0.8500	0.8000	0.8500	32.7650	10265.00	10265.00	0.00	121	15	20419	33146	0.616032100404272	0.446430702605567	0.449415168082815	false	false	false	true
fd27cddb-774d-4b5b-a735-f728fc8ae7ad	2026-08-20 15:52	2026-08-20 15:52	2026-08-20 15:52	AS	AS260918C00035000	call	35.0000	2026-09-18	0.8500	0.8000	0.8500	32.7400	10769.00	10769.00	0.00	127	23	20581	33146	0.620919567972003	0.448899539484787	0.451890107384269	false	false	false	true
b9adde71-eaf5-43e7-9f15-4b34bf57d56e	2026-08-24 10:21	2026-08-24 10:21	2026-08-24 10:21	AS	AS260918P00030000	put	30.0000	2026-09-18	0.6000	0.5500	0.6500	32.0100	38294.00	7800.00	29234.00	638	44	640	7017	0.0912070685478125	0.432707918683682	0.43461640853763	false	false	false	true
70171a79-b2cf-41cf-aebf-2fd6c4759a35	2026-08-24 11:11	2026-08-24 11:11	2026-08-24 11:11	AS	AS260918C00032500	call	32.5000	2026-09-18	1.0900	1.0000	1.1000	31.5600	21890.00	21890.00	0.00	200	10	2693	11048	0.24375452570601	0.439900066346656	0.446060901403654	false	false	false	true
5f6ab3b5-f662-475c-8192-d6a86d8b2aba	2026-08-25 09:50	2026-08-25 09:49	2026-08-25 09:49	AS	AS260918C00030000	call	30.0000	2026-09-18	2.0400	1.6500	2.0500	31.0000	86711.00	86711.00	0.00	426	8	526	10287	0.0511324973267231	0.455449738570612	0.455449738570612	false	false	false	true
74f7b03e-733a-4861-8137-5aeeeb24dc3b	2026-08-25 11:10	2026-08-25 11:09	2026-08-25 11:09	AS	AS261016C00032500	call	32.5000	2026-10-16	1.5500	1.4500	1.5500	31.1100	15480.00	15480.00	0.00	100	14	415	78	5.32051282051282	0.438451906571969	0.440610070539879	false	false	false	true
8ac1b96b-4797-4ccc-a150-e4a08ef6edfb	2026-08-25 11:12	2026-08-25 11:12	2026-08-25 11:12	AS	AS261016C00032500	call	32.5000	2026-10-16	1.5300	1.4500	1.5500	31.1000	15292.00	15292.00	0.00	100	9	515	78	6.6025641025641	0.437243510521773	0.441562533812024	false	false	false	true
9b840d20-f6b9-4092-b2c9-721ee663017a	2026-08-25 11:45	2026-08-25 11:44	2026-08-25 11:44	AS	AS261016C00032500	call	32.5000	2026-10-16	1.5400	1.4500	1.5500	31.1250	15433.00	15433.00	0.00	100	7	620	78	7.94871794871795	0.432709232048012	0.439180274204446	false	false	false	true
46501cd4-a0a4-432e-ab21-680066a7c947	2026-08-25 14:48	2026-08-25 14:48	2026-08-25 14:48	AS	AS260918C00032500	call	32.5000	2026-09-18	1.0500	1.0000	1.0500	31.4750	38102.00	38102.00	0.00	363	18	6079	17055	0.356435063031369	0.452194059155162	0.451367454321291	false	false	false	true
7fd4b10c-02e1-4570-975b-edc839686da4	2026-08-26 11:46	2026-08-26 11:46	2026-08-26 11:46	AS	AS260918C00030000	call	30.0000	2026-09-18	1.9000	1.8000	1.9500	30.9100	322509.00	316169.00	1900.00	1699	42	3714	10854	0.342177998894417	0.440259147723342	0.444392417352057	false	false	false	true
86224d4c-05de-403c-a73b-ccfa4556f4f0	2026-08-26 11:47	2026-08-26 11:46	2026-08-26 11:46	AS	AS260918C00030000	call	30.0000	2026-09-18	1.9400	1.8000	1.9500	30.9100	58500.00	58500.00	0.00	301	11	4015	10854	0.369909710705731	0.451245608033356	0.461510319844365	false	false	false	true
20c9a3c0-2836-46fb-b05d-21420b8a7e79	2026-08-27 11:40	2026-08-27 11:40	2026-08-27 11:40	AS	AS261016C00035000	call	35.0000	2026-10-16	0.5000	0.5000	0.6500	30.6200	18889.00	0.00	18829.00	376	48	429	14544	0.029496699669967	0.393727568425722	0.416965380139335	false	false	false	true
b99af803-9f70-44ba-bb82-f70a1a9205b3	2026-08-27 14:40	2026-08-27 14:40	2026-08-27 14:40	AS	AS260918P00030000	put	30.0000	2026-09-18	1.1000	1.1000	1.2000	30.3500	12433.00	0.00	12433.00	113	27	178	7147	0.0249055547782286	0.440053631166955	0.440053631166955	false	false	false	true
f68b5dd5-f463-4551-8342-ea5e3445ec6d	2026-09-03 12:40	2026-09-03 12:40	2026-09-03 12:40	AS	AS261002C00027000	call	27.0000	2026-10-02	2.3600	2.0000	2.4500	28.4200	1177746.00	833989.00	334122.00	5001	51	5001	0	0	0.485361527951175	0.475900776754573	false	false	false	true
10b1acb5-3a92-49b1-9101-bd442deb5afa	2026-09-03 14:06	2026-09-03 14:06	2026-09-03 14:06	AS	AS261016C00030000	call	30.0000	2026-10-16	1.3400	1.2500	1.3500	28.6700	13012.00	13012.00	0.00	97	5	2030	1335	1.52059925093633	0.461036830335259	0.468797466733165	false	false	false	true
6c0f61f6-1b35-42a1-8c20-bdf0cbcec9e5	2026-09-03 14:56	2026-09-03 14:56	2026-09-03 14:56	AS	AS260918C00029000	call	29.0000	2026-09-18	1.0500	0.9500	1.0500	28.5950	10455.00	10455.00	0.00	100	13	1890	1603	1.17903930131004	0.516393275089212	0.525060170061524	false	false	false	true
ccf3f93f-b40f-473d-bace-c6eeb05dfba1	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	AS	AS261002C00027000	call	27.0000	2026-10-02	2.0000	1.7000	2.0500	28.0000	395959.00	387959.00	8000.00	1981	76	2741	6530	0.419754977029096	0.492262536400206	0.509919211196692	false	false	false	true
0643e8a9-38e3-495f-8fab-5c27719a24ff	2026-09-11 13:36	2026-09-11 13:36	2026-09-11 13:36	AS	AS261016C00027500	call	27.5000	2026-10-16	1.9500	1.9500	2.0000	28.1450	11511.00	0.00	11511.00	59	10	1203	135	8.91111111111111	0.452236866094336	0.452236866094336	false	false	false	true
41b7dd21-e2bf-442b-82a9-f3eb23256578	2026-09-14 12:39	2026-09-14 12:39	2026-09-14 12:39	AS	AS261016C00032500	call	32.5000	2026-10-16	0.2500	0.2500	0.3500	27.8700	16863.00	0.00	16863.00	674	45	1660	6277	0.264457543412458	0.445181148833786	0.445181148833786	false	false	false	true
1ba4f757-aed2-47b6-ad69-c795328afdc8	2026-09-14 13:22	2026-09-14 13:22	2026-09-14 13:22	AS	AS261002C00027000	call	27.0000	2026-10-02	1.5800	1.5500	1.6500	27.7900	11399.00	0.00	11399.00	72	5	9566	17971	0.532302042179066	0.457842239384635	0.457842239384635	false	false	false	true
706c4005-3b04-497f-9dd4-cae140b26d40	2026-09-16 14:09	2026-09-16 14:09	2026-09-16 14:09	AS	AS260918P00028000	put	28.0000	2026-09-18	0.8200	0.7500	0.9500	27.7450	171119.00	0.00	171119.00	2080	62	2145	4180	0.513157894736842	0.745847722596638	0.811954311842548	true	false	false	true
0273afe3-30ee-4b07-bbcf-b4a3f42783f7	2026-09-16 15:17	2026-09-16 15:16	2026-09-16 15:16	AS	AS260918P00028000	put	28.0000	2026-09-18	1.1500	1.1000	1.2500	27.2200	120419.00	230.00	109264.00	1047	63	3196	4180	0.764593301435407	0.802664887733152	0.853403412566077	true	false	false	true
0d0939bc-9990-45ba-9cd1-6b3592d968d5	2026-09-17 12:57	2026-09-17 12:57	2026-09-17 12:57	AS	AS260918P00030000	put	30.0000	2026-09-18	3.4800	3.2000	3.6000	26.5700	34830.00	34830.00	0.00	100	8	100	7438	0.013444474321054	1.40750231261594	1.40750231261594	false	false	false	true