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

d3978db7-686a-4282-81a2-aa44f8a37dcf	2026-09-21 10:04	2026-09-21 10:04	2026-09-21 10:04	SPOT	SPOT261002P00515000	put	515.0000	2026-10-02	16.3500	15.9000	20.9000	510.2500	71925.00	36065.00	35860.00	44	7	44	137	0.321167883211679	0.398511769809902	0.401350995882082	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Communication Services	106368074978.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T14:04:59.983035Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
5c1651b5-ce00-4fda-8aa1-1f550b6f877d	2026-09-21 10:04	2026-09-21 10:04	2026-09-21 10:04	SPOT	SPOT261002P00517500	put	517.5000	2026-10-02	17.7300	17.3500	22.2500	510.2500	47870.00	1790.00	46080.00	27	10	27	40	0.675	0.397568497017376	0.403293002722445	true	false	false	true
4aa2510e-c82d-42cd-b0ff-f3b1bcc74708	2026-09-18 15:30	2026-09-18 15:30	2026-09-18 15:30	SPOT	SPOT261016P00540000	put	540.0000	2026-10-16	37.6000	37.2000	38.0500	512.0600	56400.00	41320.00	15080.00	15	11	19	124	0.153225806451613	0.378300464687058	0.382165935147759	true	false	false	true
5e58909e-6c89-4304-ae8c-2fd80577f796	2026-09-18 14:35	2026-09-18 14:34	2026-09-18 14:34	SPOT	SPOT261120C00520000	call	520.0000	2026-11-20	37.5800	37.0500	40.1500	513.5700	180400.00	3760.00	176640.00	48	9	49	0	0	0.452430010219901	0.457139563095731	false	false	false	true
39488fca-72d4-42ce-8137-e1919aaffe4f	2026-09-17 12:01	2026-09-17 12:00	2026-09-17 12:00	SPOT	SPOT261218C00640000	call	640.0000	2026-12-18	14.9200	14.9000	15.8000	536.2025	50720.00	4515.00	43215.00	34	16	39	143	0.272727272727273	0.418572052046745	0.420337174905843	true	false	false	true
99c75550-d01c-4a52-ba3a-09cfc41b673b	2026-09-17 10:21	2026-09-17 10:21	2026-09-17 10:21	SPOT	SPOT270319P00560000	put	560.0000	2027-03-19	70.7500	70.1000	72.7500	541.1200	106125.00	49540.00	21210.00	15	7	16	46	0.347826086956522	0.439993194140621	0.440322560336246	false	false	false	true
27f335c2-b2fd-4b46-a84c-13c8fba3317c	2026-09-16 09:50	2026-09-16 09:50	2026-09-16 09:50	SPOT	SPOT261016P00600000	put	600.0000	2026-10-16	48.5200	46.4500	50.6000	559.1600	97045.00	48645.00	48400.00	20	6	22	4	5.5	0.36476129396906	0.367549864513906	false	false	false	true
10d2f8bb-24df-48de-9f1a-95f9431de6a9	2026-09-15 10:02	2026-09-15 10:02	2026-09-15 10:02	SPOT	SPOT261016C00560000	call	560.0000	2026-10-16	22.3400	22.0500	23.3500	553.6450	67015.00	15715.00	51300.00	30	16	33	742	0.0444743935309973	0.377744614720964	0.377744614720964	true	false	false	true
bfc5bd73-c5ff-4888-899b-ee4c8370cbea	2026-09-15 09:51	2026-09-15 09:51	2026-09-15 09:51	SPOT	SPOT261218C00580000	call	580.0000	2026-12-18	39.6100	38.0000	40.3000	554.4500	71305.00	35690.00	35615.00	18	8	30	106	0.283018867924528	0.426041296666749	0.42916313442036	true	false	false	true
6a55902d-8bde-4712-a7b4-fb2271d6dedd	2026-09-11 12:36	2026-09-11 12:35	2026-09-11 12:35	SPOT	SPOT261218C00620000	call	620.0000	2026-12-18	17.3100	17.3000	18.1500	526.1175	67505.00	1755.00	64015.00	39	10	41	206	0.199029126213592	0.417908337440063	0.420654366686644	false	false	false	true
7dbed918-b1cf-49f5-af7d-e844c68532ea	2026-09-09 15:39	2026-09-09 15:39	2026-09-09 15:39	SPOT	SPOT270617P00350000	put	350.0000	2027-06-17	13.1900	11.7000	13.5000	523.6800	277090.00	275815.00	1275.00	210	18	211	95	2.22105263157895	0.473542552579844	0.474739156242027	true	false	false	true
4155e4a9-3a65-4d8f-b43f-f8fd4c2415c7	2026-09-09 09:37	2026-09-09 09:37	2026-09-09 09:37	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	17.0400	16.5000	17.5000	525.8100	294740.00	264070.00	0.00	173	26	725	955	0.759162303664921	0.416564928114548	0.416493110283446	false	false	false	true
3566ae5b-a0d1-4d53-89c8-411a0c0f75c4	2026-09-09 09:37	2026-09-09 09:37	2026-09-09 09:37	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	16.9400	16.4500	17.5000	525.8600	382860.00	142420.00	79650.00	226	53	552	955	0.578010471204188	0.414336270897241	0.415860024906346	true	false	false	true
8004d486-e4ad-44d7-a4f2-3340e7a6b682	2026-09-09 09:37	2026-09-09 09:37	2026-09-09 09:37	SPOT	SPOT270115C00650000	call	650.0000	2027-01-15	17.3400	16.7000	18.1500	527.2600	72825.00	57255.00	15570.00	42	5	252	955	0.263874345549738	0.415360275172861	0.415862767308847	false	false	false	true
68bc127a-3696-4ae4-bcd5-ea65d1342078	2026-09-04 10:06	2026-09-04 10:06	2026-09-04 10:06	SPOT	SPOT270115C00690000	call	690.0000	2027-01-15	16.4300	16.3500	17.1000	554.2200	164280.00	49650.00	114630.00	100	6	109	46	2.3695652173913	0.400564152719939	0.400564152719939	true	false	false	true
7ef7e95b-6838-434b-9104-19c8da464dc0	2026-09-04 10:06	2026-09-04 10:06	2026-09-04 10:06	SPOT	SPOT261218C00690000	call	690.0000	2026-12-18	12.6400	12.1000	15.2500	554.2200	85980.00	44575.00	41405.00	68	7	68	62	1.09677419354839	0.411015798906373	0.413393255820296	false	false	false	true
5fe059c5-504c-4137-8ce3-a091d8b192d7	2026-09-03 13:34	2026-09-03 13:34	2026-09-03 13:34	SPOT	SPOT261009C00520000	call	520.0000	2026-10-09	55.8900	51.4000	56.0000	565.2650	340925.00	184560.00	156365.00	61	5	68	1	68	0.377560833812652	0.378527888598435	false	false	false	true
0fc09a87-4346-411b-a084-8d14cb3522f3	2026-09-03 11:24	2026-09-03 11:24	2026-09-03 11:24	SPOT	SPOT261016C00570000	call	570.0000	2026-10-16	27.3000	27.1500	27.8500	566.7300	51870.00	27300.00	16350.00	19	6	197	549	0.358834244080146	0.356114154375519	0.357404391280897	true	false	false	true
14418161-01c1-4bf0-b079-9a9e730dccda	2026-09-03 10:23	2026-09-03 10:23	2026-09-03 10:23	SPOT	SPOT261016C00550000	call	550.0000	2026-10-16	41.3500	40.7500	42.2500	569.6100	1116454.00	8270.00	1108184.00	270	64	289	172	1.68023255813953	0.37203200605323	0.379764957069898	true	false	false	true
30deb5fc-59f0-4dbf-8c0d-60a2b404bb37	2026-09-02 14:14	2026-09-02 14:14	2026-09-02 14:14	SPOT	SPOT261009P00510000	put	510.0000	2026-10-09	8.3100	7.5500	9.9500	560.6500	77310.00	37510.00	39800.00	93	9	118	1	118	0.394304269930955	0.39530975468913	false	false	false	true
1fc59430-f842-46b2-8f15-49352134f6d7	2026-09-02 13:38	2026-09-02 13:38	2026-09-02 13:38	SPOT	SPOT261218C00550000	call	550.0000	2026-12-18	58.2500	57.7000	59.5500	558.6300	1095097.00	11640.00	1083457.00	188	51	194	75	2.58666666666667	0.423607103824468	0.423461843525051	false	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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	true