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 = 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

469c5f09-f403-4090-abcc-107462576391	2026-09-02 11:55	2026-09-02 11:55	2026-09-02 11:55	SPOT	SPOT260904C00570000	call	570.0000	2026-09-04	3.0500	3.0000	3.8500	558.7600	80245.00	915.00	79330.00	263	55	330	735	0.448979591836735	0.438221289143056	0.438221289143056	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Communication Services	114506693095.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-02T16:19:14.278097Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
14b34826-ee2d-46b4-8ddc-b7a4d8b95b3d	2026-09-02 09:45	2026-09-02 09:45	2026-09-02 09:45	SPOT	SPOT260918P00570000	put	570.0000	2026-09-18	22.5000	22.5000	24.2500	560.7950	51750.00	0.00	51750.00	23	5	26	17	1.52941176470588	0.383273722477535	0.383273722477535	false	false	false	true
e2eeee0e-4b24-45b5-a734-81c1cf8284c3	2026-09-01 15:18	2026-09-01 15:18	2026-09-01 15:18	SPOT	SPOT271217P00480000	put	480.0000	2027-12-17	64.9800	64.9500	68.9500	542.6300	97465.00	0.00	97465.00	15	5	17	25	0.68	0.463774768486259	0.464261868045175	false	false	false	true	false
85b31101-8693-456e-9858-de4934a9972e	2026-09-01 14:00	2026-09-01 14:00	2026-09-01 14:00	SPOT	SPOT280121P00320000	put	320.0000	2028-01-21	18.1000	18.1000	19.5000	542.8150	65160.00	0.00	65160.00	36	12	44	323	0.136222910216718	0.488561060718453	0.488561060718453	false	false	false	true
c90de888-c4c2-4729-9c8f-49b683fa5689	2026-09-01 12:09	2026-09-01 12:09	2026-09-01 12:09	SPOT	SPOT260904P00537500	put	537.5000	2026-09-04	5.4500	4.9000	5.7500	544.0000	101374.00	100274.00	560.00	186	52	186	12	15.5	0.438733705978757	0.435885772520045	false	false	false	true	false
adc074e4-e0c8-41ed-a5ca-373a8e0ec07d	2026-09-01 11:00	2026-09-01 11:00	2026-09-01 11:00	SPOT	SPOT270319P00450000	put	450.0000	2027-03-19	25.1500	23.3500	26.4000	546.3000	120720.00	20120.00	100600.00	48	9	48	85	0.564705882352941	0.4509729515976	0.4509729515976	false	false	false	true
1096aa10-8d4e-4418-a1cd-f5a83e1912d1	2026-08-31 15:16	2026-08-31 15:16	2026-08-31 15:16	SPOT	SPOT261218P00500000	put	500.0000	2026-12-18	28.3000	28.2000	29.3500	542.9150	67910.00	19915.00	47995.00	24	7	24	336	0.0714285714285714	0.432574077986172	0.434986449177022	false	false	false	true
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	true
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	true
7affbe0a-06c4-4323-b529-a255d5f0730a	2026-08-28 12:34	2026-08-28 12:33	2026-08-28 12:33	SPOT	SPOT261016C00560000	call	560.0000	2026-10-16	26.3000	25.8500	26.3000	548.5500	73640.00	73640.00	0.00	28	7	92	794	0.115869017632242	0.376538757261315	0.376538757261315	false	false	false	true
9c389e07-8dea-494d-b6e1-b9a54bf6475d	2026-08-28 12:28	2026-08-28 12:28	2026-08-28 12:28	SPOT	SPOT270115P00490000	put	490.0000	2027-01-15	28.4600	27.4500	28.7500	548.3800	569241.00	569241.00	0.00	200	8	205	285	0.719298245614035	0.434581349017959	0.434403660121328	false	false	false	true
c75fcad4-7010-44ff-b153-fe2a551d9f5c	2026-08-28 12:21	2026-08-28 12:21	2026-08-28 12:21	SPOT	SPOT261016C00680000	call	680.0000	2026-10-16	2.7200	2.2300	2.7200	549.9200	94928.00	94928.00	0.00	349	42	376	25	15.04	0.38562460858246	0.38562460858246	true	false	false	true	false
1d147c18-1bad-4da6-b1e0-a4b5e6386e50	2026-08-28 12:21	2026-08-28 12:21	2026-08-28 12:21	SPOT	SPOT261016C00570000	call	570.0000	2026-10-16	23.0000	22.3000	23.6000	549.9200	85100.00	85100.00	0.00	37	9	122	566	0.215547703180212	0.377951540824621	0.377951540824621	false	false	false	true
d92532e3-2d95-4d8a-85ca-f5a2f5d806b4	2026-08-28 11:33	2026-08-28 11:33	2026-08-28 11:33	SPOT	SPOT260925C00585000	call	585.0000	2026-09-25	10.6400	8.3500	11.3000	552.8900	76595.00	53150.00	23445.00	72	11	72	13	5.53846153846154	0.359767993423434	0.367120175843072	true	false	false	true
357a42ec-82e7-4925-9f89-83baa6051a89	2026-08-28 11:32	2026-08-28 11:31	2026-08-28 11:31	SPOT	SPOT260918C00580000	call	580.0000	2026-09-18	8.7000	8.5500	9.9500	550.9600	56550.00	55680.00	870.00	65	22	106	2164	0.0489833641404806	0.361390220239538	0.361390220239538	false	false	false	true
a3f5ec95-6280-465e-99b1-ba52c541227e	2026-08-28 11:24	2026-08-28 11:24	2026-08-28 11:24	SPOT	SPOT261016C00590000	call	590.0000	2026-10-16	16.1800	16.1000	16.2500	550.4200	50170.00	0.00	50170.00	31	6	95	129	0.736434108527132	0.373525004109174	0.374871781590259	false	false	false	true
879d2eea-9215-463f-8cab-7bd5fb8f0201	2026-08-28 10:27	2026-08-28 10:27	2026-08-28 10:27	SPOT	SPOT280121P00450000	put	450.0000	2028-01-21	57.6900	57.6000	62.7000	541.0000	115380.00	0.00	115380.00	20	5	22	208	0.105769230769231	0.473098301500999	0.475623842040737	false	false	false	true
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	true
b35003e1-be76-4339-a8ec-cd718e976535	2026-08-27 14:54	2026-08-27 14:53	2026-08-27 14:53	SPOT	SPOT260904P00525000	put	525.0000	2026-09-04	10.9900	9.1500	11.0000	527.7000	54955.00	54955.00	0.00	50	6	329	32	10.28125	0.401865958419347	0.402513099552248	false	false	false	true	false
d561e6e4-50e9-4b16-b980-77bb379dbc43	2026-08-27 11:24	2026-08-27 11:24	2026-08-27 11:24	SPOT	SPOT261016P00480000	put	480.0000	2026-10-16	10.0500	9.4000	10.0500	528.7600	101505.00	101505.00	0.00	101	27	112	194	0.577319587628866	0.386740120472025	0.386740120472025	false	false	false	true
ffd712a0-d3d0-48f5-87b2-5627715b6177	2026-08-27 11:09	2026-08-27 11:09	2026-08-27 11:09	SPOT	SPOT270319P00480000	put	480.0000	2027-03-19	39.9900	39.7000	41.8000	528.2500	399850.00	200100.00	199750.00	100	5	207	164	1.26219512195122	0.436927169405255	0.435476012930434	false	false	false	true
96ca730b-885e-4c5a-97b3-d1b5f00dfe36	2026-08-26 15:44	2026-08-26 15:44	2026-08-26 15:44	SPOT	SPOT260828P00542500	put	542.5000	2026-08-28	3.3000	3.3000	4.2000	551.6800	54452.00	0.00	54452.00	165	45	170	4	42.5	0.432416428731187	0.432416428731187	false	false	false	true	false
b0883fd7-6c01-4b82-a658-592b9b9ca23f	2026-08-26 12:31	2026-08-26 12:31	2026-08-26 12:31	SPOT	SPOT261218C00800000	call	800.0000	2026-12-18	4.0500	4.0500	4.7500	544.9400	74520.00	0.00	74520.00	184	42	184	248	0.741935483870968	0.428260358748693	0.428260358748693	false	false	false	true
155d4978-b407-4d8a-b4e3-4353b8a2d505	2026-08-26 10:46	2026-08-26 10:46	2026-08-26 10:46	SPOT	SPOT270617P00470000	put	470.0000	2027-06-17	44.3500	41.2000	44.4500	546.9100	62085.00	57660.00	4425.00	14	6	15	46	0.326086956521739	0.462202706867388	0.462761208998483	true	false	false	true
1a9da378-7e95-47ef-96dc-138098dbe0ab	2026-08-25 14:05	2026-08-25 14:05	2026-08-25 14:05	SPOT	SPOT260904C00570000	call	570.0000	2026-09-04	6.6000	5.5500	6.6000	549.0000	65992.00	65992.00	0.00	100	28	114	24	4.75	0.388748315712452	0.388748315712452	false	false	false	true	false
c59ddd94-5b75-4650-b317-050e3aff7d64	2026-08-25 09:50	2026-08-25 09:50	2026-08-25 09:50	SPOT	SPOT260911P00575000	put	575.0000	2026-09-11	34.9000	31.0500	34.9000	548.4500	432760.00	432760.00	0.00	124	38	124	1	124	0.404473164629796	0.404473164629796	false	false	false	true	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	true
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	true
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
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
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	true
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
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	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	true
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	true
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	true
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	false
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	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
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	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
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	true