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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = SPY×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	expirydate	pricenumeric

df2337fd-2a37-4945-b4a1-907dfd5ba4ff	2026-08-17 14:18	2026-08-17 14:17	2026-08-17 14:17	SPY	SPY270917C01000000	call	1000.0000	2027-09-17	3.3800	3.3500	3.3800	773.7500	109850.00	109850.00	0.00	325	6	328	3343	0.0981154651510619	0.133790445624256	0.133790445624256	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	802935622223.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
0b14137d-c616-4f8a-8420-77b3c3544628	2026-08-17 14:18	2026-08-17 14:18	2026-08-17 14:18	SPY	SPY261120P00705000	put	705.0000	2026-11-20	6.9600	6.9600	6.9900	773.6900	348110.00	0.00	348110.00	500	5	4274	7001	0.610484216540494	0.209249674374879	0.209142930806383	false	false	false	true	false
a22debbe-74dd-48f4-881b-b9df90995901	2026-08-17 14:19	2026-08-17 14:19	2026-08-17 14:19	SPY	SPY261016P00700000	put	700.0000	2026-10-16	3.4700	3.4700	3.4800	773.5400	154415.00	0.00	154415.00	445	10	2860	26054	0.109772011975129	0.215251117232912	0.215251117232912	false	false	false	true	false
a6197b6f-9fd2-4832-ba73-ec2ab31486f2	2026-08-17 14:20	2026-08-17 14:20	2026-08-17 14:20	SPY	SPY261016P00700000	put	700.0000	2026-10-16	3.4700	3.4700	3.4800	773.4099	296685.00	0.00	296685.00	855	13	3916	26054	0.150303216396715	0.215012265306687	0.215012265306687	false	false	false	true	false
15f081e4-3b23-4c20-aedc-10fd4117c7e8	2026-08-17 14:22	2026-08-17 14:22	2026-08-17 14:22	SPY	SPY260918C00749000	call	749.0000	2026-09-18	31.3600	31.3600	33.0300	773.6100	310470.00	0.00	310470.00	99	5	201	1788	0.11241610738255	0.153327937618352	0.153479609872277	true	false	false	true	false
4aad6013-f16c-4c81-aa58-876025f7d9c2	2026-08-17 14:24	2026-08-17 14:24	2026-08-17 14:24	SPY	SPY260828C00774000	call	774.0000	2026-08-28	6.2100	6.2100	6.2200	773.7250	188163.00	0.00	188163.00	303	6	1780	5701	0.312225925276267	0.110163224039844	0.110163224039844	true	false	false	true	false
11f5eb40-969a-48dc-be23-50650a0b91c9	2026-08-17 14:24	2026-08-17 14:24	2026-08-17 14:24	SPY	SPY260828C00774000	call	774.0000	2026-08-28	6.2100	6.1800	6.2100	773.7250	122313.00	122313.00	0.00	197	5	1977	5701	0.346781266444483	0.109976365792025	0.110163224039844	false	false	false	true	false
931e788c-6a34-424a-916d-eaead33f5ac1	2026-08-17 14:25	2026-08-17 14:25	2026-08-17 14:25	SPY	SPY260925P00715000	put	715.0000	2026-09-25	2.4200	2.4200	2.4300	773.7100	112530.00	0.00	112530.00	465	7	1034	142	7.28169014084507	0.201465532093353	0.201465532093353	false	false	false	true	false
128a6b96-b043-423c-84c7-cd036ac17122	2026-08-17 14:27	2026-08-17 14:26	2026-08-17 14:26	SPY	SPY261120P00705000	put	705.0000	2026-11-20	6.9300	6.9300	6.9600	773.5600	623700.00	0.00	623700.00	900	16	5275	7001	0.753463790887016	0.208625164556272	0.20860872452428	true	false	false	true	false
5c0157a6-003d-4422-b219-b3725add9954	2026-08-17 14:27	2026-08-17 14:27	2026-08-17 14:27	SPY	SPY260817C00773000	call	773.0000	2026-08-17	0.7500	0.7500	0.7600	773.4800	177000.00	0.00	177000.00	2360	40	128991	2264	56.9748233215548	0.117894954530677	0.114424202860655	false	false	false	true	false
e083d335-f6b8-484d-a681-3d99e59982d1	2026-08-17 14:37	2026-08-17 14:37	2026-08-17 14:37	SPY	SPY260904C00776000	call	776.0000	2026-09-04	7.3800	7.3300	7.3900	773.3400	100368.00	100368.00	0.00	136	6	886	739	1.19891745602165	0.116253678053445	0.116253678053445	false	false	false	true	false
ed548dbd-7cb9-45b2-a79e-d45ebfac7dcc	2026-08-17 14:38	2026-08-17 14:38	2026-08-17 14:38	SPY	SPY260817C00773000	call	773.0000	2026-08-17	0.7300	0.7300	0.7400	773.4900	219740.00	740.00	219000.00	3010	45	145295	2264	64.1762367491166	0.117011571795354	0.114143314352009	false	false	false	true	false
0f063ad7-42b8-41f3-893b-3ca3d03b0af3	2026-08-17 14:43	2026-08-17 14:43	2026-08-17 14:43	SPY	SPY260820C00774000	call	774.0000	2026-08-20	2.6000	2.5800	2.6000	773.5950	117000.00	117000.00	0.00	450	7	1647	312	5.27884615384615	0.0958167587289733	0.0958167587289733	false	false	false	true	false
5f276c63-2d03-459e-8e5c-092e3abab4fc	2026-08-17 14:47	2026-08-17 14:46	2026-08-17 14:46	SPY	SPY260820C00774000	call	774.0000	2026-08-20	2.5800	2.5800	2.6000	773.5900	116100.00	0.00	116100.00	450	6	2123	312	6.80448717948718	0.0951897012929158	0.0951897012929158	false	false	false	true	false
1c686b5f-0182-4ef3-ad32-1edc65b89436	2026-08-17 14:56	2026-08-17 14:56	2026-08-17 14:56	SPY	SPY280616C00925000	call	925.0000	2028-06-16	33.0200	33.0200	33.1300	773.5650	693420.00	0.00	693420.00	210	5	235	252	0.932539682539683	0.151570696391197	0.151570696391197	false	false	false	true	false
d30b87a2-2143-4ba5-8d2e-8d19b9d50a93	2026-08-17 15:04	2026-08-17 15:03	2026-08-17 15:03	SPY	SPY260918C00760000	call	760.0000	2026-09-18	22.0500	21.9900	22.1600	773.3100	123480.00	119070.00	4410.00	56	14	117	21068	0.00555344598443137	0.139061699188501	0.139061699188501	false	false	false	true	false
d00633ca-0756-48fb-88cb-dfed2bd64d97	2026-08-17 15:04	2026-08-17 15:03	2026-08-17 15:03	SPY	SPY260918C00760000	call	760.0000	2026-09-18	22.0500	22.0300	22.0500	773.3300	105840.00	26460.00	0.00	48	7	251	21068	0.0119138029238656	0.138885923498882	0.138885923498882	false	false	false	true	false
823e61e4-13e3-437c-a096-92665a89cac6	2026-08-17 15:04	2026-08-17 15:04	2026-08-17 15:04	SPY	SPY260918C00760000	call	760.0000	2026-09-18	22.0400	21.9700	22.0400	773.3200	132240.00	17632.00	0.00	60	7	311	21068	0.0147617239415227	0.138848243992817	0.138848243992817	true	false	false	true	false
4cdcb651-bd06-4e4c-8c65-7353d5de9d16	2026-08-17 15:04	2026-08-17 15:04	2026-08-17 15:04	SPY	SPY260918C00760000	call	760.0000	2026-09-18	22.0500	22.0100	22.1300	773.3250	105840.00	99225.00	6615.00	48	7	406	21068	0.0192709322194798	0.138929887851212	0.138929887851212	true	false	false	true	false
445376ca-e0cb-4a2f-81a0-84830e3a3eaa	2026-08-17 15:04	2026-08-17 15:04	2026-08-17 15:04	SPY	SPY260918C00760000	call	760.0000	2026-09-18	22.0400	22.0100	22.1300	773.3250	103588.00	13224.00	2204.00	47	7	358	21068	0.0169925954053541	0.138804273655842	0.138804273655842	true	false	false	true	false
d207e9ea-9801-4f08-8f69-be1b19d3421a	2026-08-17 15:04	2026-08-17 15:04	2026-08-17 15:04	SPY	SPY260918C00760000	call	760.0000	2026-09-18	22.0600	22.0200	22.1500	773.3550	108094.00	105888.00	2206.00	49	6	514	21068	0.0243971900512626	0.138884891473086	0.138791600117558	true	false	false	true	false
a61ac464-60e3-4451-93e9-d7d06981f94e	2026-08-17 15:04	2026-08-17 15:04	2026-08-17 15:04	SPY	SPY260918C00760000	call	760.0000	2026-09-18	22.0600	22.0300	22.1300	773.3550	110300.00	13236.00	4412.00	50	7	564	21068	0.0267704575659768	0.138791600117558	0.138791600117558	false	false	false	true	false
29810160-6498-4290-b176-c5399817c140	2026-08-17 15:04	2026-08-17 15:04	2026-08-17 15:04	SPY	SPY260918C00760000	call	760.0000	2026-09-18	22.0800	22.0500	22.1500	773.3900	128064.00	19872.00	4416.00	58	5	622	21068	0.0295234478830454	0.138734721411939	0.138734721411939	false	false	false	true	false
a3039404-3f98-4aca-8c5b-2c41cc446634	2026-08-17 15:04	2026-08-17 15:04	2026-08-17 15:04	SPY	SPY260918C00760000	call	760.0000	2026-09-18	22.0700	22.0300	22.1400	773.3650	101522.00	8828.00	2207.00	46	6	668	21068	0.0317068539965825	0.138829246895472	0.138829246895472	false	false	false	true	false
0f68516c-290e-4b5f-8657-9a3806676695	2026-08-17 15:04	2026-08-17 15:04	2026-08-17 15:04	SPY	SPY260918C00760000	call	760.0000	2026-09-18	22.0700	22.0400	22.1500	773.3750	116971.00	6621.00	6621.00	53	5	723	21068	0.0343174482627682	0.138741164376363	0.138741164376363	false	false	false	true	false
84999480-d332-4a94-9250-5a1d58b38323	2026-08-17 15:04	2026-08-17 15:04	2026-08-17 15:04	SPY	SPY260918C00760000	call	760.0000	2026-09-18	22.0700	21.9900	22.0700	773.3800	114760.00	103725.00	0.00	52	11	775	21068	0.036785646478071	0.138571329090452	0.138697102510648	false	false	false	true	false
ab419ac0-8c7f-4e67-afd5-926fd7e93677	2026-08-17 15:05	2026-08-17 15:04	2026-08-17 15:04	SPY	SPY260918C00760000	call	760.0000	2026-09-18	22.0600	22.0400	22.2500	773.3750	103682.00	97064.00	6618.00	47	6	1061	21068	0.0503607366622366	0.138615410810957	0.138615410810957	false	false	false	true	false
a0a62cd5-6d83-44f6-a3bc-b2ed126c8019	2026-08-17 15:17	2026-08-17 15:17	2026-08-17 15:17	SPY	SPY261120P00700000	put	700.0000	2026-11-20	6.5800	6.5800	6.6000	773.4100	153314.00	0.00	153314.00	233	6	1540	21441	0.0718250081619327	0.214026907174876	0.214026907174876	false	false	false	true	false
075abfa0-18cd-4889-ab38-4c9edda4b870	2026-08-17 15:30	2026-08-17 15:30	2026-08-17 15:30	SPY	SPY260819C00774000	call	774.0000	2026-08-19	1.7300	1.7300	1.7500	773.0201	103800.00	0.00	103800.00	600	8	17605	890	19.7808988764045	0.0923801009209851	0.0925731911726943	false	false	false	true	false
1743bd41-d14e-48f8-8ab1-21ca7bda19bc	2026-08-17 15:31	2026-08-17 15:30	2026-08-17 15:30	SPY	SPY260828C00774000	call	774.0000	2026-08-28	5.8000	5.7900	5.8400	772.9700	245898.00	11620.00	234278.00	424	24	2898	5701	0.508331871601473	0.109884594387442	0.109510993911936	false	false	false	true	false
42c1a1d5-e980-403c-a835-a75ff9ec2ae6	2026-08-17 15:31	2026-08-17 15:31	2026-08-17 15:31	SPY	SPY260818C00774000	call	774.0000	2026-08-18	1.0800	1.0700	1.1000	773.0100	134353.00	134244.00	109.00	1244	6	53361	1125	47.432	0.0928253829994658	0.0929448614287854	true	false	false	true	false
8241abf5-8679-42b1-b2e6-80de31471e24	2026-08-17 15:31	2026-08-17 15:31	2026-08-17 15:31	SPY	SPY260918P00732000	put	732.0000	2026-09-18	2.8900	2.8800	2.8900	772.9550	100572.00	100572.00	0.00	348	7	942	12321	0.07645483321159	0.181153098426988	0.181153098426988	false	false	false	true	false
58aa64f5-55db-4933-aae2-13489780c32d	2026-08-17 15:31	2026-08-17 15:31	2026-08-17 15:31	SPY	SPY260828P00750000	put	750.0000	2026-08-28	1.0700	1.0500	1.0800	772.9550	1610483.00	1532694.00	36594.00	15000	79	15811	5017	3.15148495116604	0.148506100097708	0.148901680977287	false	false	false	true	false
8aa074b4-9a52-41b3-8e06-8fc6ce6d9aa3	2026-08-17 15:32	2026-08-17 15:31	2026-08-17 15:31	SPY	SPY260821P00751000	put	751.0000	2026-08-21	0.2000	0.2000	0.2100	772.9500	200000.00	0.00	200000.00	10000	88	10595	11230	0.943455031166518	0.158702044336495	0.158680963237995	false	false	false	true	false
a32196a8-a457-48ae-a051-bd4ab9f7087c	2026-08-17 15:32	2026-08-17 15:32	2026-08-17 15:32	SPY	SPY260817C00773000	call	773.0000	2026-08-17	0.2800	0.2700	0.2900	772.9100	107108.00	107108.00	0.00	3821	68	245772	2264	108.556537102473	0.144865838508016	0.148376679325185	true	false	false	true	false
afe70f94-c09c-4665-875c-bc96e02c017a	2026-08-17 15:33	2026-08-17 15:32	2026-08-17 15:32	SPY	SPY260824C00772000	call	772.0000	2026-08-24	4.5900	4.5900	4.6700	772.7800	203337.00	0.00	203337.00	443	5	2338	434	5.38709677419355	0.0910228055442813	0.0910228055442813	false	false	false	true	false
ca4940ea-4106-4619-8251-3d06c87dc36d	2026-08-17 15:34	2026-08-17 15:34	2026-08-17 15:34	SPY	SPY260925P00740000	put	740.0000	2026-09-25	4.6200	4.5900	4.6200	772.9800	184800.00	184800.00	0.00	400	8	895	374	2.39304812834225	0.171082646953424	0.171082646953424	false	false	false	true	false
418b6331-5efe-4ae5-89af-06758d3a4ce8	2026-08-17 15:36	2026-08-17 15:36	2026-08-17 15:36	SPY	SPY260817P00773000	put	773.0000	2026-08-17	0.2300	0.2200	0.2500	773.0000	103037.00	275.00	44.00	4479	6	786032	7797	100.812107220726	0.111077782954943	0.120792455374477	false	false	false	true	false
20f700c2-3b2f-4378-b9c5-3e8d6ac2f2be	2026-08-17 15:39	2026-08-17 15:39	2026-08-17 15:39	SPY	SPY260918P00773000	put	773.0000	2026-09-18	10.9200	10.9200	10.9400	773.0050	255528.00	0.00	255528.00	234	18	910	3174	0.286704473850032	0.133488737021422	0.133488737021422	false	false	false	true	false
e008c490-bf0d-4f7a-8c8d-ec260373a228	2026-08-17 15:39	2026-08-17 15:39	2026-08-17 15:39	SPY	SPY260918P00773000	put	773.0000	2026-09-18	10.9200	10.9200	10.9300	773.0200	501228.00	0.00	501228.00	459	35	1369	3174	0.431316950220542	0.133539208984181	0.133564440362972	true	false	false	true	false
96c67164-9095-4e03-beff-16d1f8ce6a4f	2026-08-17 15:40	2026-08-17 15:40	2026-08-17 15:40	SPY	SPY260918P00773000	put	773.0000	2026-09-18	10.9300	10.9100	10.9500	773.0100	233902.00	148648.00	14209.00	214	14	1597	3174	0.503150598613737	0.133624090513495	0.133624090513495	false	false	false	true	false
89ac364b-9117-4e29-a984-4a7d4d4df953	2026-08-17 15:41	2026-08-17 15:41	2026-08-17 15:41	SPY	SPY260821C00775000	call	775.0000	2026-08-21	2.3900	2.3900	2.4100	772.8800	144460.00	21360.00	123100.00	604	7	22313	54464	0.409683460634548	0.0996275198893492	0.0993102630340692	false	false	false	true	false
3ef02da3-e283-4b0c-bb3e-ffaf2552be30	2026-08-17 15:43	2026-08-17 15:43	2026-08-17 15:43	SPY	SPY270917C01000000	call	1000.0000	2027-09-17	3.2900	3.2900	3.3100	772.8500	106925.00	0.00	106925.00	325	8	653	3343	0.19533353275501	0.133575784503545	0.133575784503545	false	false	false	true	false
146338d2-76a1-4b08-aac7-9c1c6131b2d1	2026-08-17 15:43	2026-08-17 15:43	2026-08-17 15:43	SPY	SPY270115C00780000	call	780.0000	2027-01-15	32.0300	32.0300	32.0600	772.9150	240225.00	0.00	240225.00	75	12	172	7293	0.0235842588783765	0.147609583449397	0.14765143675178	false	false	false	true	false
ebd20c68-c9a5-42cc-afdf-ad5d618948d9	2026-08-17 15:45	2026-08-17 15:45	2026-08-17 15:45	SPY	SPY260817C00773000	call	773.0000	2026-08-17	0.2400	0.2300	0.2500	773.0000	112020.00	2100.00	109920.00	4664	73	282927	2264	124.967756183746	0.154630459158648	0.146245022632853	true	false	false	true	false
06188f29-37a7-4c70-ad0c-39bb7b7db056	2026-08-17 15:47	2026-08-17 15:47	2026-08-17 15:47	SPY	SPY260918P00739000	put	739.0000	2026-09-18	3.4500	3.4500	3.4700	773.2200	172500.00	0.00	172500.00	500	5	2248	21209	0.105992738931586	0.171333948061235	0.171305061938271	false	false	false	true	false
cdaff17d-e87c-4d25-a7c3-5a6a456a29ff	2026-08-17 15:47	2026-08-17 15:47	2026-08-17 15:47	SPY	SPY260817P00776000	put	776.0000	2026-08-17	2.7600	2.7600	2.8200	773.2299	112608.00	0.00	112608.00	408	26	342281	13337	25.6640173952163	0.480178942960072	0.255716678292839	true	false	false	true	false
3137b3eb-263e-46cd-b27d-2fc0c06d5e3f	2026-08-17 15:48	2026-08-17 15:48	2026-08-17 15:48	SPY	SPY261016P00730000	put	730.0000	2026-10-16	5.9800	5.9800	6.0000	773.2700	119600.00	0.00	119600.00	200	11	824	17378	0.0474162734491886	0.182831491226559	0.182831491226559	false	false	false	true	false
49e13056-c290-4306-bd24-3689527bb5a9	2026-08-17 15:50	2026-08-17 15:50	2026-08-17 15:50	SPY	SPY260818C00773000	call	773.0000	2026-08-18	1.7000	1.6400	1.7000	773.3150	108970.00	108970.00	0.00	641	9	32764	2177	15.0500689021589	0.09254612911025	0.09254612911025	false	false	false	true	false
9a741088-780e-41ed-aa4f-8898dd33fc8c	2026-08-17 15:50	2026-08-17 15:50	2026-08-17 15:50	SPY	SPY261130C00800000	call	800.0000	2026-11-30	14.0700	14.0500	14.0800	773.1600	140700.00	112560.00	28140.00	100	5	428	1510	0.283443708609272	0.130817639876689	0.130817639876689	false	false	false	true	false