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:er_time = unknown×ticker = SG×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

d411198d-1c3c-43ba-a55a-1576b8e5efff	2026-08-17 09:42	2026-08-17 09:42	2026-08-17 09:42	SG	SG260821P00006000	put	6.0000	2026-08-21	0.2300	0.2000	0.3000	5.9850	11542.00	0.00	11542.00	500	5	509	1444	0.352493074792244	0.934343641554837	0.934343641554837	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Consumer Cyclical	776821238.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
4de6fc05-e97b-45fe-8f50-2658ece8b61a	2026-08-17 10:43	2026-08-17 10:43	2026-08-17 10:43	SG	SG260918C00005000	call	5.0000	2026-09-18	1.0900	1.0000	1.1500	5.8450	94870.00	92088.00	2782.00	871	6	876	84	10.4285714285714	0.835364090882509	0.835364090882509	false	false	false	true
2a3f2c4f-2f6d-4a6e-981c-8a1cd06c7381	2026-08-17 12:56	2026-08-17 12:56	2026-08-17 12:56	SG	SG260925C00007500	call	7.5000	2026-09-25	0.1000	0.1000	0.2000	5.7650	10230.00	0.00	10230.00	1022	36	1022	64	15.96875	0.708296897372166	0.708296897372166	false	false	false	true
3252cb45-c5c9-43d2-896d-da35c61f8677	2026-08-19 10:17	2026-08-19 10:17	2026-08-19 10:17	SG	SG270115C00007000	call	7.0000	2027-01-15	1.1000	1.1000	1.2500	6.4350	22053.00	0.00	22053.00	200	10	236	2074	0.113789778206365	0.782354711017113	0.788492040476559	false	false	false	true
f1c1e94c-0d5a-43aa-9737-920623e7256e	2026-08-19 10:43	2026-08-19 10:43	2026-08-19 10:43	SG	SG270115C00007000	call	7.0000	2027-01-15	1.2000	1.2000	1.2500	6.5050	12000.00	0.00	12000.00	100	12	339	2074	0.163452266152363	0.819851340335103	0.819851340335103	false	false	false	true
874ada78-6f1c-47f2-9f1a-e4243a8a032a	2026-08-20 10:36	2026-08-20 10:36	2026-08-20 10:36	SG	SG270115C00007000	call	7.0000	2027-01-15	1.2000	1.2000	1.2500	6.5190	11280.00	0.00	9840.00	94	5	95	2579	0.0368359829391237	0.817974426730344	0.817974426730344	false	false	false	true
247dc0d3-fa61-46e2-b3ec-2363d74c9873	2026-08-20 10:36	2026-08-20 10:36	2026-08-20 10:36	SG	SG270115C00007000	call	7.0000	2027-01-15	1.2000	1.2000	1.2500	6.5150	16320.00	0.00	16320.00	136	6	231	2579	0.0895696006203955	0.819346686643061	0.819346686643061	false	false	false	true
8dacd3ca-8706-424c-be07-bed1a3019cb4	2026-08-21 14:59	2026-08-21 14:58	2026-08-21 14:58	SG	SG270115C00007000	call	7.0000	2027-01-15	1.4500	1.4000	1.4500	6.8750	18270.00	18270.00	0.00	126	37	202	2061	0.0980106744298884	0.846466913329317	0.846466913329317	false	false	false	true
35109d5e-ca05-444a-bbae-07964ab89abc	2026-08-21 15:50	2026-08-21 15:50	2026-08-21 15:50	SG	SG270115C00009000	call	9.0000	2027-01-15	0.8100	0.7500	0.9000	6.9050	10075.00	0.00	10075.00	125	5	278	612	0.454248366013072	0.815282708767385	0.815282708767385	false	false	false	true
bf184763-cfaf-4e54-8445-8d1aa878191e	2026-08-24 15:12	2026-08-24 15:12	2026-08-24 15:12	SG	SG261016C00008000	call	8.0000	2026-10-16	0.4500	0.4000	0.4500	6.8750	10773.00	10773.00	0.00	240	49	347	753	0.460823373173971	0.791897009496005	0.791897009496005	false	false	false	true
cb460aec-5738-42a5-b3f5-fe70439c0afa	2026-08-24 15:13	2026-08-24 15:12	2026-08-24 15:12	SG	SG261016C00008000	call	8.0000	2026-10-16	0.4500	0.4000	0.4500	6.9150	10619.00	10619.00	0.00	236	55	643	753	0.853917662682603	0.782555432428245	0.776952344427067	true	false	false	true
2ddc5839-3249-45a2-9bdc-412c23dca7a4	2026-08-24 15:34	2026-08-24 15:34	2026-08-24 15:34	SG	SG261016C00007000	call	7.0000	2026-10-16	0.8000	0.7500	0.8000	6.8950	13280.00	13280.00	0.00	166	35	459	480	0.95625	0.793747058244212	0.793747058244212	false	false	false	true
d3e8443c-e7ec-4880-9bb0-475713bbe540	2026-09-01 14:42	2026-09-01 14:42	2026-09-01 14:42	SG	SG260925C00007500	call	7.5000	2026-09-25	0.2000	0.1500	0.2000	6.5100	15340.00	15340.00	0.00	767	21	2001	4230	0.473049645390071	0.779201914793715	0.779201914793715	false	false	false	true
7e2d796b-277c-448a-88f8-e0522172bc1b	2026-09-01 15:01	2026-09-01 15:01	2026-09-01 15:01	SG	SG260918C00006000	call	6.0000	2026-09-18	0.7500	0.6500	0.7500	6.4750	59100.00	59100.00	0.00	788	18	880	10141	0.0867764520264274	0.873065444593196	0.873065444593196	false	false	false	true
9a83a971-ad5c-4b6b-bd2b-003597a8b719	2026-09-08 13:06	2026-09-08 13:06	2026-09-08 13:06	SG	SG261016C00007000	call	7.0000	2026-10-16	0.5700	0.5500	0.6500	6.8200	11304.00	0.00	11304.00	200	19	241	1098	0.219489981785064	0.700368523467638	0.703255947175184	false	false	false	true
9de5b2e7-cd7d-49e2-b25c-2d31804cb1b5	2026-09-10 14:04	2026-09-10 14:04	2026-09-10 14:04	SG	SG260925C00007000	call	7.0000	2026-09-25	0.4500	0.3500	0.5500	6.9350	132648.00	120363.00	1260.00	2948	57	2948	220	13.4	0.847397599828764	0.847397599828764	true	false	false	true
5ae5c4de-3e39-4118-8839-c322a32742e2	2026-09-11 14:58	2026-09-11 14:58	2026-09-11 14:58	SG	SG270115C00008000	call	8.0000	2027-01-15	1.0600	1.0500	1.1500	7.1300	10600.00	0.00	10600.00	100	14	100	19507	0.0051263648946532	0.800362560629486	0.813853605525173	false	false	false	true
29690fbe-b93e-4222-a019-f55ec37da751	2026-09-14 11:51	2026-09-14 11:51	2026-09-14 11:51	SG	SG261016C00007000	call	7.0000	2026-10-16	0.7500	0.7000	0.8000	7.1200	28274.00	27899.00	0.00	377	25	384	871	0.440872560275545	0.813569380918894	0.813569380918894	false	false	false	true
6654d292-9049-4e30-a9a5-29d847dfcec6	2026-09-14 11:55	2026-09-14 11:55	2026-09-14 11:55	SG	SG261016C00007000	call	7.0000	2026-10-16	0.8000	0.7000	0.8000	7.2299	41839.00	41839.00	0.00	523	29	2748	871	3.15499425947187	0.816937272692049	0.795063205614464	false	false	false	true
469e9a13-b968-43ec-a1fa-74e2b52ab284	2026-09-15 12:34	2026-09-15 12:34	2026-09-15 12:34	SG	SG261016C00007000	call	7.0000	2026-10-16	0.6800	0.6000	0.7000	6.0000	59538.00	59538.00	0.00	877	7	1646	3553	0.463270475654377	0.815067733908625	0.815067733908625	false	false	false	true
3aa065ca-9874-48cc-ba28-060f2001d4cf	2026-09-15 15:34	2026-09-15 15:34	2026-09-15 15:34	SG	SG270115C00008000	call	8.0000	2027-01-15	0.9000	0.9000	1.0000	6.8750	18203.00	0.00	18203.00	202	44	207	19546	0.0105904021283127	0.799256386358444	0.799256386358444	false	false	false	true
6d73e65a-5d21-4dde-a243-eb406f5c3755	2026-09-15 15:34	2026-09-15 15:34	2026-09-15 15:34	SG	SG270115C00007000	call	7.0000	2027-01-15	1.2500	1.2500	1.3500	6.8500	21504.00	0.00	21504.00	172	54	187	2244	0.0833333333333333	0.810314698474042	0.812101441617711	true	false	false	true
79259140-4d19-46c2-98ba-90f95d8cd01c	2026-09-15 15:35	2026-09-15 15:35	2026-09-15 15:35	SG	SG261016C00008000	call	8.0000	2026-10-16	0.2500	0.2500	0.3000	6.8300	11600.00	0.00	11600.00	464	49	670	1721	0.389308541545613	0.778344485840682	0.784693998662566	true	false	false	true
9facf86b-3e1e-45ca-91cd-3e51b12aae2d	2026-09-16 10:46	2026-09-16 10:46	2026-09-16 10:46	SG	SG261009C00007000	call	7.0000	2026-10-09	0.5500	0.4500	0.5500	6.9400	55275.00	55275.00	0.00	1005	21	1005	16	62.8125	0.824453205328263	0.820639020563304	true	false	false	true
8b2bb6e5-5996-4b0d-ba44-5d0e474e9844	2026-09-18 14:57	2026-09-18 14:56	2026-09-18 14:56	SG	SG261016C00007000	call	7.0000	2026-10-16	0.7500	0.6500	0.7500	7.2150	37500.00	37500.00	0.00	500	12	512	3024	0.169312169312169	0.798414102137673	0.798414102137673	false	false	false	true
8f5df63d-a859-4cf4-ac18-192b7d5da236	2026-09-21 14:26	2026-09-21 14:26	2026-09-21 14:26	SG	SG270115P00005000	put	5.0000	2027-01-15	0.3500	0.3000	0.3500	7.6150	21000.00	21000.00	0.00	600	8	660	18107	0.036449991715911	0.919318367124786	0.919318367124786	false	false	false	true