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: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	price

8e01faec-ab5a-4ac6-b30f-ebb07ff32429	2026-08-18 10:46	2026-08-18 10:46	2026-08-18 10:46	SPY	SPY260918P00770000	put	770.0000	2026-09-18	11.7200	11.6700	11.7200	768.2200	137124.00	137124.00	0.00	117	6	9295	20274	0.458468975041926	0.135250982762552	0.135250982762552	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-18T14:49:07.673043Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
83ec8bdc-1eb9-4ce3-9ffa-9b531ee85de9	2026-08-18 10:47	2026-08-18 10:47	2026-08-18 10:47	SPY	SPY261030C00731000	call	731.0000	2026-10-30	50.2400	50.2400	52.0000	768.3725	296417.00	0.00	291392.00	59	11	61	87	0.701149425287356	0.168852499665675	0.16887230547493	false	false	false	true	false
bf60663f-8f5b-474e-b617-e1ecd3087c93	2026-08-18 10:49	2026-08-18 10:49	2026-08-18 10:49	SPY	SPY271217P00810000	put	810.0000	2027-12-17	68.7800	68.7700	69.0400	768.3450	1602573.00	0.00	1602573.00	233	6	233	324	0.719135802469136	0.198416810570084	0.198388307296196	true	false	false	true	false
5af2b0e6-861b-42f6-be92-214d22a7177a	2026-08-18 10:49	2026-08-18 10:49	2026-08-18 10:49	SPY	SPY271217P00820000	put	820.0000	2027-12-17	73.7600	73.7400	74.0200	768.3450	1519456.00	7375.00	1512081.00	206	10	392	1917	0.204486176317162	0.197761430122204	0.19773308141837	false	false	false	true	false
1e80b8f8-9f1e-4af7-bbb8-35cf42a696f1	2026-08-18 10:50	2026-08-18 10:50	2026-08-18 10:50	SPY	SPY271217P00825000	put	825.0000	2027-12-17	76.2500	76.2300	76.5200	768.5900	1242863.00	0.00	1242863.00	163	7	552	597	0.924623115577889	0.197516689736329	0.197500920167085	true	false	false	true	false
2027ec43-febb-47b0-8bb1-ebc165aee493	2026-08-18 10:50	2026-08-18 10:50	2026-08-18 10:50	SPY	SPY271217P00815000	put	815.0000	2027-12-17	71.1000	71.1000	71.3400	768.5400	1727730.00	0.00	1727730.00	243	5	245	193	1.26943005181347	0.197931297050633	0.197931297050633	false	false	false	true	false
12a7848a-14b7-495c-9c19-b6a79bc4e342	2026-08-18 10:54	2026-08-18 10:53	2026-08-18 10:53	SPY	SPY260918P00747000	put	747.0000	2026-09-18	5.3500	5.3300	5.3500	768.1452	190995.00	190995.00	0.00	357	5	835	2416	0.345612582781457	0.160504117154718	0.160504117154718	false	false	false	true	false
137d651f-a170-4787-bea7-9acedba07f8f	2026-08-18 10:55	2026-08-18 10:55	2026-08-18 10:55	SPY	SPY260918P00760000	put	760.0000	2026-09-18	8.3200	8.3200	8.3400	767.9850	166400.00	0.00	166400.00	200	5	15775	33276	0.474065392475057	0.145191469325496	0.145191469325496	false	false	false	true	false
e1b5df3f-9b48-4c50-b7c4-f5abdfb4e8bb	2026-08-18 10:55	2026-08-18 10:55	2026-08-18 10:55	SPY	SPY260818P00767000	put	767.0000	2026-08-18	0.6800	0.6700	0.6800	768.0350	152262.00	143820.00	8442.00	2241	29	170516	3808	44.7783613445378	0.153942752677437	0.153232202529918	false	false	false	true	false
78aed72d-2b76-4cf9-89b8-9c6459489177	2026-08-18 10:56	2026-08-18 10:56	2026-08-18 10:56	SPY	SPY260821P00759000	put	759.0000	2026-08-21	0.9900	0.9800	0.9900	767.7700	198000.00	198000.00	0.00	2000	38	2823	1985	1.42216624685139	0.143801322576505	0.143801322576505	false	false	false	true	false
e072b5bc-1e05-41d0-aa9e-e7993acb361c	2026-08-18 10:56	2026-08-18 10:56	2026-08-18 10:56	SPY	SPY260930C00800000	call	800.0000	2026-09-30	2.3800	2.3700	2.3900	767.8300	204680.00	151844.00	8806.00	860	13	84141	93145	0.903333512265822	0.106458481768061	0.106458481768061	false	false	false	true	false
a68ead34-4377-4d58-9639-d8ea5c1e9abc	2026-08-18 10:56	2026-08-18 10:56	2026-08-18 10:56	SPY	SPY260930C00800000	call	800.0000	2026-09-30	2.3900	2.3900	2.4000	767.8500	104682.00	0.00	104682.00	438	5	85174	93145	0.91442374791991	0.106562104907467	0.106562104907467	false	false	false	true	false
6730d6e7-36d3-4855-8b78-cb65e2eaf885	2026-08-18 10:56	2026-08-18 10:56	2026-08-18 10:56	SPY	SPY260930C00800000	call	800.0000	2026-09-30	2.3900	2.3900	2.4000	767.8500	142205.00	0.00	142205.00	595	9	84736	93145	0.909721402114982	0.106562104907467	0.106562104907467	false	false	false	true	false
4382f930-d62f-4eff-a24f-c989cda8f2da	2026-08-18 10:57	2026-08-18 10:57	2026-08-18 10:57	SPY	SPY260828P00769000	put	769.0000	2026-08-28	6.0600	6.0000	6.0600	768.0600	302964.00	295728.00	0.00	500	16	1210	523	2.31357552581262	0.117480203890205	0.118071714432239	false	false	false	true	false
d1307153-65dd-4b6d-81a5-a57a65cd3125	2026-08-18 11:00	2026-08-18 10:59	2026-08-18 10:59	SPY	SPY260818P00767000	put	767.0000	2026-08-18	0.7600	0.7500	0.7700	767.8100	144155.00	141267.00	2888.00	1887	18	184976	3808	48.5756302521008	0.153826379073179	0.153826379073179	false	false	false	true	false
71e82327-cd67-4472-8a0e-b7aa1c0a4ae1	2026-08-18 11:01	2026-08-18 11:01	2026-08-18 11:01	SPY	SPY260918P00730000	put	730.0000	2026-09-18	3.3700	3.3500	3.3700	767.6000	168500.00	168500.00	0.00	500	11	4530	39714	0.114065568817042	0.184255550466148	0.184255550466148	false	false	false	true	false
3eef7e2b-1d16-48be-8f74-2054a81d6470	2026-08-18 11:01	2026-08-18 11:01	2026-08-18 11:01	SPY	SPY261030C00780000	call	780.0000	2026-10-30	15.1000	15.0800	15.1000	767.4842	185730.00	185730.00	0.00	123	6	346	5854	0.059104885548343	0.132128566960487	0.132128566960487	false	false	false	true	false
13fb043d-e523-4510-b899-b3b9f8981138	2026-08-18 11:04	2026-08-18 11:04	2026-08-18 11:04	SPY	SPY260818P00768000	put	768.0000	2026-08-18	1.0300	1.0300	1.0400	768.0800	178105.00	104.00	178001.00	1730	44	347934	4728	73.5901015228426	0.146250253488894	0.148262380940268	true	false	false	true	false
fed94f90-93b6-4601-9e37-77d2ef66f843	2026-08-18 11:04	2026-08-18 11:04	2026-08-18 11:04	SPY	SPY260918P00670000	put	670.0000	2026-09-18	0.9000	0.9000	0.9100	768.2200	166140.00	0.00	166140.00	1846	16	16882	72682	0.232272089375636	0.273107219497135	0.273107219497135	false	false	false	true	false
e73144a5-0b22-4413-8a31-68cc7bcb9892	2026-08-18 11:06	2026-08-18 11:06	2026-08-18 11:06	SPY	SPY261016P00675000	put	675.0000	2026-10-16	2.6100	2.6100	2.6300	768.2100	107532.00	0.00	107532.00	412	8	689	7136	0.0965526905829596	0.24224772027971	0.24224772027971	false	false	false	true	false
731f4551-0eb3-4b8a-9b2e-064dcecb4eab	2026-08-18 11:07	2026-08-18 11:07	2026-08-18 11:07	SPY	SPY261231P00480000	put	480.0000	2026-12-31	1.2700	1.2700	1.2800	768.2300	127000.00	0.00	127000.00	1000	12	1000	15150	0.066006600660066	0.400492733097149	0.400492733097149	true	false	false	true	false
83f9b9c7-cef7-41dc-bfd5-87575310a4ef	2026-08-18 11:07	2026-08-18 11:07	2026-08-18 11:07	SPY	SPY261016P00675000	put	675.0000	2026-10-16	2.6100	2.6100	2.6200	768.1400	107271.00	0.00	107271.00	411	12	2083	7136	0.291900224215247	0.242127662260513	0.242127662260513	false	false	false	true	false
336eba63-fac8-4af3-ae6b-5d2ee6389a2a	2026-08-18 11:08	2026-08-18 11:08	2026-08-18 11:08	SPY	SPY261120C00700000	call	700.0000	2026-11-20	80.9900	80.9900	82.7800	768.0600	1044771.00	0.00	1044771.00	129	6	133	3375	0.0394074074074074	0.199296857911719	0.199296857911719	false	false	false	true	false
834ab7b7-a887-4861-b605-f7785644b61c	2026-08-18 11:09	2026-08-18 11:09	2026-08-18 11:09	SPY	SPY261016P00760000	put	760.0000	2026-10-16	13.0700	13.0700	13.1200	767.8694	133314.00	0.00	133314.00	102	7	522	3417	0.152765583845479	0.152922838758333	0.152922838758333	false	false	false	true	false
198e5770-0bbe-4290-9666-8bc1480784ef	2026-08-18 11:14	2026-08-18 11:14	2026-08-18 11:14	SPY	SPY270917C00855000	call	855.0000	2027-09-17	28.2900	28.2900	28.3600	767.7575	1691742.00	0.00	1691742.00	598	10	642	1520	0.422368421052632	0.149387199293566	0.149387199293566	false	false	false	true	false
0c53ba76-1b9b-447f-8e27-689ca2eb190b	2026-08-18 11:14	2026-08-18 11:14	2026-08-18 11:14	SPY	SPY261016P00730000	put	730.0000	2026-10-16	6.8700	6.8500	6.8700	767.6750	227397.00	227397.00	0.00	331	12	1291	17179	0.075149892310379	0.181767296891407	0.181767296891407	true	false	false	true	false
373784fe-a896-4363-afdf-2d5be94a12e2	2026-08-18 11:14	2026-08-18 11:14	2026-08-18 11:14	SPY	SPY260918P00750000	put	750.0000	2026-09-18	6.0600	6.0500	6.0600	767.7400	126048.00	126048.00	0.00	208	5	2953	31192	0.09467171069505	0.157570134647098	0.157533416090532	false	false	false	true	false
88315291-5aa8-44a6-9a08-491e8862981f	2026-08-18 11:15	2026-08-18 11:15	2026-08-18 11:15	SPY	SPY260821P00765000	put	765.0000	2026-08-21	2.1700	2.1700	2.1900	767.7599	126077.00	0.00	126077.00	581	18	15284	54512	0.280378632227766	0.125014640369766	0.125014640369766	true	false	false	true	false
13a58c14-344f-434a-939e-05073db62fb3	2026-08-18 11:19	2026-08-18 11:19	2026-08-18 11:19	SPY	SPY260918P00750000	put	750.0000	2026-09-18	6.0500	6.0500	6.0600	767.7900	453750.00	0.00	453750.00	750	5	3734	31192	0.119710182097974	0.15758254118653	0.15758254118653	true	false	false	true	false
c2b2c9ab-e7c7-4448-972e-9bfeb08c6f46	2026-08-18 11:20	2026-08-18 11:19	2026-08-18 11:19	SPY	SPY260831P00765000	put	765.0000	2026-08-31	5.2800	5.2600	5.3100	767.4900	132000.00	121440.00	10560.00	250	10	3974	12898	0.308109784462707	0.119659310112278	0.119659310112278	true	false	false	true	false
b5c89365-920d-45e5-93d7-f9488ed70736	2026-08-18 11:21	2026-08-18 11:21	2026-08-18 11:21	SPY	SPY260911P00786000	put	786.0000	2026-09-11	19.5400	19.5200	20.9500	767.5303	439757.00	203320.00	236437.00	225	11	440	258	1.70542635658915	0.113276862295439	0.112824575152511	true	false	false	true	false
a6127ad6-4b72-4a9d-849a-7db67800ea2f	2026-08-18 11:21	2026-08-18 11:21	2026-08-18 11:21	SPY	SPY260911P00789000	put	789.0000	2026-09-11	22.0000	21.9800	23.4200	767.5400	1064567.00	527997.00	536570.00	484	16	488	59	8.27118644067797	0.114751400505017	0.114751400505017	true	false	false	true	false
9be754e0-b4f1-453f-b8b6-613527d3c8f2	2026-08-18 11:22	2026-08-18 11:22	2026-08-18 11:22	SPY	SPY261120C00730000	call	730.0000	2026-11-20	54.5500	54.5500	54.7900	767.3900	152741.00	5456.00	147285.00	28	12	193	787	0.245235069885642	0.175082929509674	0.175305840090135	false	false	false	true	false
4bc8b3a8-a145-45bf-869d-2e4cb92a9604	2026-08-18 11:22	2026-08-18 11:22	2026-08-18 11:22	SPY	SPY260818P00770000	put	770.0000	2026-08-18	2.7100	2.7100	2.7500	767.4048	135721.00	0.00	134633.00	500	26	52619	11560	4.55181660899654	0.127191070547353	0.124409793234715	false	false	false	true	false
fe8534b7-7dc7-468b-8347-5713f36cefc0	2026-08-18 11:23	2026-08-18 11:23	2026-08-18 11:23	SPY	SPY260818C00768000	call	768.0000	2026-08-18	0.8100	0.8000	0.8100	767.6400	100845.00	100845.00	0.00	1245	7	127032	184	690.391304347826	0.138378321140026	0.138382546873381	false	false	false	true	false
bdaf81d2-99fd-4216-ae22-9dfc84b82c60	2026-08-18 11:25	2026-08-18 11:24	2026-08-18 11:24	SPY	SPY260918P00755000	put	755.0000	2026-09-18	7.1900	7.1500	7.1900	767.6500	14357811.00	14357093.00	0.00	19964	39	20971	14022	1.4955783768364	0.15191349673305	0.151608757850563	true	false	false	true	false
6def9f4b-3f1b-47ea-967e-3910762ffc44	2026-08-18 11:25	2026-08-18 11:24	2026-08-18 11:24	SPY	SPY260918P00755000	put	755.0000	2026-09-18	7.1900	7.1400	7.1900	767.7100	210667.00	210667.00	0.00	293	7	1007	14022	0.0718157181571816	0.151973315113653	0.151973315113653	false	false	false	true	false
4f0309d1-4d23-4ee1-a47d-de577be9a870	2026-08-18 11:29	2026-08-18 11:29	2026-08-18 11:29	SPY	SPY260831C00770000	call	770.0000	2026-08-31	5.9600	5.9600	5.9900	768.0314	119200.00	0.00	119200.00	200	7	947	8644	0.109555761221657	0.110860098273873	0.110860098273873	false	false	false	true	false
c8d01cde-3d94-42b7-9c0d-6ed96f7fc7e5	2026-08-18 11:30	2026-08-18 11:30	2026-08-18 11:30	SPY	SPY260831P00767000	put	767.0000	2026-08-31	5.8200	5.8200	5.8600	767.8999	116400.00	0.00	116400.00	200	9	338	769	0.439531859557867	0.116783014575971	0.116783014575971	false	false	false	true	false
b60f0ee9-c704-445a-99ed-e574aaff1efe	2026-08-18 11:35	2026-08-18 11:35	2026-08-18 11:35	SPY	SPY261120C00730000	call	730.0000	2026-11-20	54.8800	54.8800	55.1500	767.8150	400624.00	0.00	400624.00	73	7	279	787	0.354510800508259	0.17534750135511	0.17534750135511	false	false	false	true	false
360ba8ea-3bfc-4cd2-9e79-8b5fc3362178	2026-08-18 11:41	2026-08-18 11:40	2026-08-18 11:40	SPY	SPY261002P00650000	put	650.0000	2026-10-02	1.2200	1.2100	1.2200	767.9200	213500.00	213500.00	0.00	1750	16	1910	97	19.6907216494845	0.2837452629749	0.2837452629749	true	false	false	true	false
ecb616ee-ae68-4ad8-b247-de2275558290	2026-08-18 11:42	2026-08-18 11:42	2026-08-18 11:42	SPY	SPY260818C00768000	call	768.0000	2026-08-18	0.9900	0.9800	0.9900	768.1900	100672.00	99594.00	1078.00	1017	20	162263	184	881.864130434783	0.132298919824036	0.130320818075502	false	false	false	true	false
4ac4edcd-6754-4b0e-8c24-a280e2ebed7b	2026-08-18 11:45	2026-08-18 11:45	2026-08-18 11:45	SPY	SPY260918P00670000	put	670.0000	2026-09-18	0.9000	0.9000	0.9100	768.1550	185760.00	0.00	185760.00	2064	22	18976	72682	0.26108252387111	0.272975041723814	0.272975041723814	false	false	false	true	false
e795e452-c764-4165-bb3d-7b09a68b1943	2026-08-18 11:47	2026-08-18 11:47	2026-08-18 11:47	SPY	SPY260824P00766000	put	766.0000	2026-08-24	2.7300	2.7300	2.7400	768.4000	110019.00	0.00	110019.00	403	12	1307	4095	0.319169719169719	0.102097285267543	0.102097285267543	false	false	false	true	false
ec5b57d6-bfb3-4dd5-8bef-cd3a85eb78f6	2026-08-18 11:49	2026-08-18 11:49	2026-08-18 11:49	SPY	SPY260821C00690000	call	690.0000	2026-08-21	78.7600	78.7200	78.7600	768.3899	307164.00	212652.00	0.00	39	39	233	5746	0.0405499477897668	0.536929863562824	0.53250471531165	false	false	false	true	false
c376b9a2-dd84-4853-8bf9-975043f6b6bd	2026-08-18 11:52	2026-08-18 11:52	2026-08-18 11:52	SPY	SPY260821C00768000	call	768.0000	2026-08-21	3.5900	3.5600	3.5800	768.2550	107658.00	107658.00	0.00	300	11	6553	3293	1.98997874278773	0.11977683745185	0.11977683745185	true	false	false	true	false
b28360db-43d6-41e7-90fe-6e53e49c7d6e	2026-08-18 11:53	2026-08-18 11:52	2026-08-18 11:52	SPY	SPY260821C00700000	call	700.0000	2026-08-21	68.8700	68.8100	68.8800	768.4500	902233.00	902233.00	0.00	131	19	330	5624	0.0586770981507824	0.488403141606472	0.491871342369168	false	false	false	true	false
4d73444e-ae46-4fc7-ba14-6ed3816b7a56	2026-08-18 11:53	2026-08-18 11:53	2026-08-18 11:53	SPY	SPY260821C00700000	call	700.0000	2026-08-21	69.0100	68.9500	69.0200	768.5750	6369616.00	5672622.00	696994.00	923	49	1253	5624	0.222795163584637	0.490929635381558	0.494290574362418	true	false	false	true	false
b63ce818-7e0e-4233-bcfc-db271208b9b4	2026-08-18 11:55	2026-08-18 11:55	2026-08-18 11:55	SPY	SPY260827P00771000	put	771.0000	2026-08-27	6.1800	6.1800	6.3200	768.4700	123600.00	0.00	123600.00	200	7	444	18	24.6666666666667	0.108415800446625	0.108415800446625	false	false	false	true	false
4d88fa77-fddc-4a55-80a9-f34d4e7fcbe2	2026-08-18 11:58	2026-08-18 11:57	2026-08-18 11:57	SPY	SPY270630C00950000	call	950.0000	2027-06-30	3.1900	3.1600	3.1900	768.1200	159500.00	159500.00	0.00	500	11	500	7665	0.0652315720808871	0.130121964658205	0.130121964658205	false	false	false	true	false