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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×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	expiry

96a219d9-8ea3-41c3-b061-efc8139a301f	2026-08-21 12:45	2026-08-21 12:44	2026-08-21 12:44	SPOT	SPOT260911P00550000	put	550.0000	2026-09-11	23.9000	22.7500	23.9000	538.8500	88430.00	88430.00	0.00	37	16	37	1	37	0.355646199470568	0.355646199470568	false	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-21T17:09:02.511847Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
d5ebab0a-0f19-4204-a0e8-0d36e1b36846	2026-08-21 10:15	2026-08-21 10:14	2026-08-21 10:14	SPOT	SPOT260828C00540000	call	540.0000	2026-08-28	8.3800	8.0500	8.6500	534.1600	63660.00	36940.00	1670.00	76	31	150	127	1.18110236220472	0.366058765868206	0.36777896644624	false	false	false
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
26bec5c8-32b0-467b-94d5-d25d185d1df9	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.0500	64.7500	534.4600	84181.00	71231.00	0.00	13	13	201	504	0.398809523809524	1.2051344920655	1.2051344920655	true	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
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
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
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
8faeb759-0a2b-456c-af1d-886de166c0c7	2026-08-20 15:52	2026-08-20 15:52	2026-08-20 15:52	SPOT	SPOT260828C00550000	call	550.0000	2026-08-28	5.6200	5.5500	5.9500	534.1400	110780.00	87820.00	22960.00	197	46	334	100	3.34	0.36599947133816	0.370136319045351	true	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
a1e09b82-67fd-40ce-987d-a1163331a36b	2026-08-20 10:50	2026-08-20 10:50	2026-08-20 10:50	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	22.9100	22.7500	23.3500	532.2200	201585.00	36700.00	11455.00	88	31	491	1296	0.378858024691358	0.422170390130576	0.422600449505628	false	false	false
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
43392333-865a-42c5-92c1-f7613b1024ac	2026-08-20 10:50	2026-08-20 10:50	2026-08-20 10:50	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	23.1600	22.8000	23.2000	531.9700	199190.00	180630.00	0.00	86	22	403	1296	0.310956790123457	0.424946765646697	0.425376176538309	false	false	false
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
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
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
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
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
e2bded8e-007a-42b6-a58c-e4486961fe67	2026-08-20 09:48	2026-08-20 09:48	2026-08-20 09:48	SPOT	SPOT260918C00580000	call	580.0000	2026-09-18	9.7600	9.5000	9.8000	540.2600	85880.00	74120.00	0.00	88	22	297	1621	0.183220234423196	0.384216865782088	0.385186546154936	false	false	false
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
71e32c1c-31cb-412b-a7af-d902a78bbc1d	2026-08-20 09:48	2026-08-20 09:48	2026-08-20 09:48	SPOT	SPOT260918C00580000	call	580.0000	2026-09-18	10.1300	8.8500	11.4000	541.9100	105360.00	14230.00	38585.00	104	48	106	1621	0.0653917334978408	0.38088723370526	0.382786436575437	true	false	false
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
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
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
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