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 = RepeatedHitsDescendingFill×ticker = SPOT×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

9abb6b5d-dcbf-4a13-8d70-49964aa6acd6	2026-08-17 13:05	2026-08-17 13:04	2026-08-17 13:04	SPOT	SPOT261016C00550000	call	550.0000	2026-10-16	14.5000	14.3500	15.4000	500.8000	88425.00	8775.00	78210.00	61	7	70	53	1.32075471698113	0.383419788812056	0.382725362192405	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	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-17T17:22:08.033203Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
7d5d771f-41a4-46e0-9195-42c42f63a37e	2026-08-20 09:48	2026-08-20 09:48	2026-08-20 09:48	SPOT	SPOT260918C00580000	call	580.0000	2026-09-18	9.6800	9.3000	9.7500	540.4900	61010.00	19300.00	8730.00	63	24	209	1621	0.128932757557064	0.381983659109516	0.378096811316127	true	false	false
86dd1bf1-c2e6-413b-8df2-d6a4d49cd6a8	2026-08-20 15:54	2026-08-20 15:54	2026-08-20 15:54	SPOT	SPOT260821C00470000	call	470.0000	2026-08-21	64.7500	63.2000	68.0500	534.5200	349662.00	0.00	103612.00	54	23	71	504	0.140873015873016	1.182088522542	1.1558581535386	false	false	false	true
e2e04a1d-2237-49ab-97e7-a914cc4101e5	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	63.2500	67.9500	534.6050	310570.00	0.00	310570.00	48	19	119	504	0.236111111111111	1.06194054582312	0.97301246343121	false	false	false
53a9a4d1-4e8b-44c2-9cdb-4085e57af6f0	2026-08-20 15:54	2026-08-20 15:54	2026-08-20 15:54	SPOT	SPOT260821C00470000	call	470.0000	2026-08-21	64.7400	64.3500	67.9000	534.6200	200700.00	6475.00	45300.00	31	20	150	504	0.297619047619048	1.03979990767928	0.932816461622682	false	false	false
2ed9f83b-145f-48ae-afb6-573cfbfac168	2026-08-21 13:51	2026-08-21 13:50	2026-08-21 13:50	SPOT	SPOT260904P00535000	put	535.0000	2026-09-04	15.1000	14.1000	15.1000	534.5500	291424.00	289919.00	1505.00	193	48	194	13	14.9230769230769	0.36566223922045	0.36566223922045	false	false	false
80de809d-52b9-4b40-8bac-58f75f5ad645	2026-08-25 09:34	2026-08-25 09:34	2026-08-25 09:34	SPOT	SPOT260918C00540000	call	540.0000	2026-09-18	23.4800	22.1500	23.9000	543.7000	251215.00	63700.00	187515.00	107	7	119	1441	0.0825815405968078	0.379142595334176	0.373691958269891	true	false	false
3c25a498-47f0-4f0d-aaef-54545bc07667	2026-08-28 10:20	2026-08-28 10:20	2026-08-28 10:20	SPOT	SPOT261016C00560000	call	560.0000	2026-10-16	22.5900	21.3500	22.7500	540.7600	99390.00	56630.00	40500.00	44	12	47	794	0.0591939546599496	0.376527407927632	0.375248378505279	false	false	false
9f11de9b-2e55-4e89-918f-1185b05a6d96	2026-08-31 14:28	2026-08-31 14:28	2026-08-31 14:28	SPOT	SPOT271217C00780000	call	780.0000	2027-12-17	55.3700	54.6500	56.8000	541.3900	337745.00	77510.00	254705.00	61	26	67	72	0.930555555555556	0.460662186906244	0.460018503567176	false	false	false
0bc57bb4-1bf0-494e-bfd1-008b7b85978f	2026-08-31 15:16	2026-08-31 15:16	2026-08-31 15:16	SPOT	SPOT261218P00500000	put	500.0000	2026-12-18	28.1600	27.9000	28.7000	542.9800	259060.00	30950.00	225315.00	92	9	117	336	0.348214285714286	0.434504128714214	0.430349544450659	false	false	false
62bc20c2-0342-4c14-b0ee-912ea942687a	2026-09-03 11:16	2026-09-03 11:16	2026-09-03 11:16	SPOT	SPOT261009C00510000	call	510.0000	2026-10-09	66.1400	62.5000	67.8500	567.5650	231475.00	231475.00	0.00	35	7	47	0	0	0.394598353160087	0.394598353160087	false	false	false	true
00fef4d4-91f3-4d13-96bc-3be8708315b5	2026-09-03 13:48	2026-09-03 13:48	2026-09-03 13:48	SPOT	SPOT270115C00480000	call	480.0000	2027-01-15	111.8700	109.0500	113.2500	564.5400	134248.00	134248.00	0.00	12	9	12	177	0.0677966101694915	0.453591597862685	0.434012748957055	false	false	false
88a01995-ac98-4390-baef-a6999b4beaa5	2026-09-04 14:43	2026-09-04 14:43	2026-09-04 14:43	SPOT	SPOT270416P00500000	put	500.0000	2027-04-16	44.2500	44.1500	45.4500	544.9650	194700.00	44250.00	150450.00	44	9	52	0	0	0.431732088357038	0.431399700921125	false	false	false	true
9bd8e5ef-dc75-44b2-b279-941f6ac92f3f	2026-09-09 11:13	2026-09-09 11:13	2026-09-09 11:13	SPOT	SPOT270115C00570000	call	570.0000	2027-01-15	40.8700	37.2000	40.9500	533.0600	232950.00	126655.00	8135.00	57	9	57	16	3.5625	0.419925338453936	0.417932213413792	true	false	false	true
737e501f-a31e-40f8-9e93-03e47d295682	2026-09-09 12:23	2026-09-09 12:23	2026-09-09 12:23	SPOT	SPOT261016P00520000	put	520.0000	2026-10-16	21.9000	20.9000	22.6500	526.7200	396398.00	394213.00	2185.00	181	53	182	414	0.439613526570048	0.394117287458457	0.39219905833732	false	false	false
8770aac5-fd35-4b14-a59e-745db9aacda6	2026-09-09 13:35	2026-09-09 13:35	2026-09-09 13:35	SPOT	SPOT270115C00640000	call	640.0000	2027-01-15	19.2500	18.7500	19.3000	527.4600	59670.00	30805.00	28865.00	31	5	33	241	0.136929460580913	0.416242860965047	0.415761053934175	false	false	false
a07a8b9d-5b57-48f0-b915-eb7791207ec2	2026-09-15 09:36	2026-09-15 09:36	2026-09-15 09:36	SPOT	SPOT261023C00595000	call	595.0000	2026-10-23	12.3600	11.0500	16.0000	550.2850	88980.00	14880.00	74100.00	72	8	74	7	10.5714285714286	0.393078195726028	0.393885657665119	true	false	false
3f4f3ce1-baa0-43a8-833f-c617aeab1028	2026-09-18 12:51	2026-09-18 12:51	2026-09-18 12:51	SPOT	SPOT261218P00480000	put	480.0000	2026-12-18	25.1500	24.4500	25.1500	518.8100	1265041.00	1265041.00	0.00	503	55	507	422	1.20142180094787	0.441791476938443	0.441791476938443	false	false	false
35af4584-a263-44b6-b7c9-ca867ac66873	2026-09-18 15:30	2026-09-18 15:30	2026-09-18 15:30	SPOT	SPOT261016P00520000	put	520.0000	2026-10-16	25.0400	21.8000	25.3500	512.0600	105170.00	80220.00	24950.00	42	13	57	596	0.0956375838926175	0.382812846307685	0.379970270149068	false	false	false
60747e80-53bf-479e-9cde-a286f24208f9	2026-09-21 15:32	2026-09-21 15:32	2026-09-21 15:32	SPOT	SPOT261120C00670000	call	670.0000	2026-11-20	4.6200	3.7000	5.0000	519.0000	55475.00	51050.00	4425.00	120	7	120	1	120	0.458635730972806	0.459402230289606	false	false	false	true
361b7534-090c-4248-800a-dbaefe699af3	2026-09-22 09:51	2026-09-22 09:51	2026-09-22 09:51	SPOT	SPOT261120P00440000	put	440.0000	2026-11-20	9.6000	8.5500	10.3500	515.2300	20162.00	11567.00	8595.00	21	11	29	26	1.11538461538462	0.473265347865783	0.473265347865783	false	false	false	true
8074742f-d6fb-4165-adf8-b35e9798c9bc	2026-09-22 11:47	2026-09-22 11:47	2026-09-22 11:47	SPOT	SPOT261030C00555000	call	555.0000	2026-10-30	12.9200	9.0000	15.4000	508.5200	419780.00	221085.00	198695.00	325	28	325	6	54.1666666666667	0.442691388589312	0.434433452592805	true	false	false
3d66727e-51a4-43b0-b0ec-db1d26b279b8	2026-09-22 11:57	2026-09-22 11:57	2026-09-22 11:57	SPOT	SPOT261016P00520000	put	520.0000	2026-10-16	26.0300	25.9000	26.3000	508.7350	203015.00	49495.00	101420.00	78	13	94	623	0.150882825040128	0.394421503975449	0.393451222858138	false	false	false
072822b9-44c2-4d34-ac9c-a594f2996b5b	2026-09-22 13:46	2026-09-22 13:46	2026-09-22 13:46	SPOT	SPOT260925P00497500	put	497.5000	2026-09-25	7.5100	5.7500	7.8000	498.9550	53308.00	40578.00	12730.00	71	12	90	56	1.60714285714286	0.467025152064697	0.465354761104013	true	false	false	true
5639e534-6efd-4e39-88e4-cb462a73a756	2026-09-22 13:47	2026-09-22 13:47	2026-09-22 13:47	SPOT	SPOT261002P00497500	put	497.5000	2026-10-02	12.5800	10.0500	12.8500	498.0050	60380.00	55370.00	5010.00	48	24	50	0	0	0.404574238633312	0.399324625847489	true	false	false	true
075668a7-bca7-4aac-8b2b-272e024a675c	2026-09-22 14:11	2026-09-22 14:11	2026-09-22 14:11	SPOT	SPOT261218P00500000	put	500.0000	2026-12-18	40.7100	40.0000	41.0000	498.7295	65135.00	36650.00	16260.00	16	6	22	475	0.0463157894736842	0.440631953058114	0.43959207806149	true	false	false
b5e7fdf2-a820-4247-9c91-235af77b95c9	2026-09-22 15:18	2026-09-22 15:18	2026-09-22 15:18	SPOT	SPOT261016C00540000	call	540.0000	2026-10-16	7.4000	7.2000	7.6000	500.4700	11105.00	5960.00	5145.00	15	5	230	317	0.725552050473186	0.401172309993858	0.401172309993858	false	false	false