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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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 = SPOT×

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

92dc3189-aca8-4f37-92c3-d34a9840cfb9	2026-08-21 10:18	2026-08-21 10:18	2026-08-21 10:18	SPOT	SPOT261016C00540000	call	540.0000	2026-10-16	30.2500	30.2500	31.6500	533.2050	163350.00	0.00	163350.00	54	33	57	138	0.41304347826087	0.383689207869558	0.383689207869558	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Communication Services	114506693095.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T14:24:12.053362Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
900ddc9f-f68e-454e-8edf-8666a9fe43d3	2026-08-21 09:31	2026-08-21 09:31	2026-08-21 09:31	SPOT	SPOT270115C00640000	call	640.0000	2027-01-15	23.6300	23.6000	28.3500	532.7750	70880.00	0.00	33040.00	30	6	30	237	0.126582278481013	0.410391791228595	0.410391791228595	false	false	false	true
fabe49e6-81c0-4ca4-80a1-acf0d291e947	2026-08-20 15:54	2026-08-20 15:54	2026-08-20 15:54	SPOT	SPOT260821C00470000	call	470.0000	2026-08-21	64.7000	64.3500	67.7500	534.6200	213510.00	0.00	213510.00	33	16	183	504	0.363095238095238	0.932816461622682	0.932816461622682	false	false	false	true
cf59f00a-54ba-40c4-a37b-c2b6f25e42dd	2026-08-20 15:54	2026-08-20 15:54	2026-08-20 15:54	SPOT	SPOT260821C00470000	call	470.0000	2026-08-21	64.7000	64.7000	68.2000	534.7200	109990.00	0.00	84110.00	17	17	17	504	0.0337301587301587	2.13378155495856	2.12442177272829	false	false	false	true
25f190f2-ced0-4d68-97a3-53a7a0942c0f	2026-08-20 15:44	2026-08-20 15:43	2026-08-20 15:43	SPOT	SPOT260918C00520000	call	520.0000	2026-09-18	31.5000	31.5000	32.6500	535.1750	81905.00	0.00	81905.00	26	11	34	189	0.17989417989418	0.37387311143098	0.37387311143098	true	false	false	true
10221171-613e-4701-9f65-f68ada851a5d	2026-08-20 14:54	2026-08-20 14:53	2026-08-20 14:53	SPOT	SPOT270917C00590000	call	590.0000	2027-09-17	92.0000	90.4500	92.0000	535.9100	625600.00	625600.00	0.00	68	5	123	0	0	0.467802279345641	0.467802279345641	false	false	false	true
84ac700a-0e83-4cac-85ea-b051dc86070a	2026-08-20 10:50	2026-08-20 10:50	2026-08-20 10:50	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	23.1000	22.8500	23.1000	531.9700	200970.00	200970.00	0.00	87	18	314	1296	0.242283950617284	0.4245171610806	0.4245171610806	false	false	false	true
c1cd393a-812c-4a99-a3d8-3b902892fee9	2026-08-20 10:50	2026-08-20 10:50	2026-08-20 10:50	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	23.0500	22.9000	23.0500	531.9700	53015.00	53015.00	0.00	23	6	227	1296	0.175154320987654	0.424087362043627	0.424087362043627	false	false	false	true
46721389-6ffa-4fcc-a7f3-0eace0f2e84d	2026-08-20 10:50	2026-08-20 10:50	2026-08-20 10:50	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	23.2000	23.1000	23.2000	531.9700	102080.00	102080.00	0.00	44	9	150	1296	0.115740740740741	0.425376176538309	0.425376176538309	false	false	false	true
b7be56bb-4282-4700-9dc8-a45cca951940	2026-08-20 10:50	2026-08-20 10:50	2026-08-20 10:50	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	23.4000	22.9500	23.4000	532.1257	121680.00	121680.00	0.00	52	16	96	1296	0.0740740740740741	0.426699736677459	0.426699736677459	false	false	false	true
c1c7e530-e4a0-4373-9052-456f6ba33c4a	2026-08-20 10:47	2026-08-20 10:47	2026-08-20 10:47	SPOT	SPOT260918C00530000	call	530.0000	2026-09-18	25.0800	24.4000	26.0000	532.4100	60190.00	0.00	60190.00	24	23	37	115	0.321739130434783	0.386599466532744	0.382391683860963	false	false	false	true
e2e1ae67-c48e-46f6-a09c-e3a8779a7ebe	2026-08-20 09:48	2026-08-20 09:48	2026-08-20 09:48	SPOT	SPOT260918C00580000	call	580.0000	2026-09-18	9.5000	9.3000	10.1500	539.7000	66500.00	8550.00	8550.00	70	18	375	1621	0.231338679827267	0.382411381192953	0.382411381192953	false	false	false	true
6cff7e4d-93dc-4e95-b17d-d4cefbcbacde	2026-08-19 14:39	2026-08-19 14:39	2026-08-19 14:39	SPOT	SPOT260918P00490000	put	490.0000	2026-09-18	6.3500	6.3000	6.9000	538.3100	88261.00	0.00	88261.00	139	51	168	1282	0.131045241809672	0.399511549990395	0.395214781458079	true	false	false	true
e3ed6988-5089-42ca-a674-773983717734	2026-08-19 12:59	2026-08-19 12:59	2026-08-19 12:59	SPOT	SPOT261016P00460000	put	460.0000	2026-10-16	6.7500	6.7500	7.1000	540.5750	96525.00	0.00	96525.00	143	33	150	279	0.537634408602151	0.416528442526253	0.416528442526253	false	false	false	true
b3c7bd92-6aec-49e9-913f-6a4e90de7cdd	2026-08-18 12:19	2026-08-18 12:19	2026-08-18 12:19	SPOT	SPOT260821C00520000	call	520.0000	2026-08-21	11.5000	11.0000	11.9000	524.8900	57500.00	57500.00	0.00	50	6	127	2233	0.0568741603224362	0.462791257712942	0.462791257712942	false	false	false	true
10fffe9b-e5fa-4006-9351-8418d1268e35	2026-08-18 10:59	2026-08-18 10:59	2026-08-18 10:59	SPOT	SPOT260918P00520000	put	520.0000	2026-09-18	23.2500	22.1500	23.4000	518.1400	355715.00	353385.00	2330.00	153	41	156	165	0.945454545454545	0.384626692327159	0.387120222054036	false	false	false	true
90936e86-142d-4a8a-bf44-5b506d2ab0ba	2026-08-17 15:13	2026-08-17 15:12	2026-08-17 15:12	SPOT	SPOT261016P00400000	put	400.0000	2026-10-16	3.1000	2.6500	3.1000	495.9500	56420.00	56420.00	0.00	182	47	184	302	0.609271523178808	0.408760575285017	0.408760575285017	true	false	false	true
44fa47ce-fba0-4b68-a76e-faec16fb5025	2026-08-17 14:21	2026-08-17 14:21	2026-08-17 14:21	SPOT	SPOT261016P00480000	put	480.0000	2026-10-16	22.5000	21.5000	23.8500	494.0400	51755.00	49495.00	2260.00	23	15	23	158	0.145569620253165	0.386602792105768	0.387039772159101	true	false	false	true