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

c51321ec-052f-4e48-85fa-fab9013b0f06	2026-08-18 09:45	2026-08-18 09:44	2026-08-18 09:44	SPY	SPY260818P00772000	put	772.0000	2026-08-18	3.4500	3.4300	3.4700	768.0000	138000.00	135585.00	2415.00	400	39	3603	10300	0.349805825242718	0.151414111052441	0.148292969490614	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	802935622223.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
5d8d44db-d441-40fe-af58-d86f8975af43	2026-08-18 09:46	2026-08-18 09:45	2026-08-18 09:45	SPY	SPY260821C00770000	call	770.0000	2026-08-21	2.9000	2.8900	2.9200	768.0000	100632.00	100632.00	0.00	347	7	3716	26477	0.140348226762851	0.119706622949485	0.12042959243911	false	false	false	true	false
a8243838-af9f-4ec7-a0ab-07a26f9d3ad0	2026-08-18 09:47	2026-08-18 09:47	2026-08-18 09:47	SPY	SPY260831P00746000	put	746.0000	2026-08-31	1.4900	1.4700	1.4900	768.0000	381589.00	381589.00	0.00	2561	8	9212	962	9.57588357588358	0.151578092116724	0.151578092116724	false	false	false	true	false
a214a4f4-8f05-44bb-9736-bba3f5cd5f10	2026-08-18 09:47	2026-08-18 09:47	2026-08-18 09:47	SPY	SPY260831P00746000	put	746.0000	2026-08-31	1.4900	1.4700	1.4900	768.0000	598682.00	598682.00	0.00	4018	37	6651	962	6.91372141372141	0.151578092116724	0.151727334041171	false	false	false	true	false
526919ac-8dfe-4e5e-8c37-3aa0955f575f	2026-08-18 09:47	2026-08-18 09:47	2026-08-18 09:47	SPY	SPY260831P00746000	put	746.0000	2026-08-31	1.4900	1.4600	1.4900	768.0000	391870.00	391870.00	0.00	2630	11	2633	962	2.73700623700624	0.151578092116724	0.151578092116724	false	false	false	true	false
4d7a9707-ffa4-4246-8330-345c61a7dff3	2026-08-18 09:47	2026-08-18 09:47	2026-08-18 09:47	SPY	SPY260821P00752000	put	752.0000	2026-08-21	0.3600	0.3500	0.3700	768.0000	224836.00	0.00	224116.00	6308	132	7709	21370	0.360739354234909	0.167675021455012	0.166702533921194	false	false	false	true	false
5f68f99a-edc1-4f8b-ba8b-9f3035a2c451	2026-08-18 09:48	2026-08-18 09:48	2026-08-18 09:48	SPY	SPY260821P00752000	put	752.0000	2026-08-21	0.3500	0.3400	0.3500	768.0000	115780.00	115780.00	0.00	3308	11	14578	21370	0.682171268132897	0.166330869066207	0.166330869066207	true	false	false	true	false
e2e7e112-d8fd-4724-abf9-5ada36b5e044	2026-08-18 09:48	2026-08-18 09:48	2026-08-18 09:48	SPY	SPY260918C00770000	call	770.0000	2026-09-18	12.0700	12.0000	12.0900	768.0000	905223.00	269161.00	636062.00	750	8	942	14991	0.0628377026215729	0.127604295132374	0.127374235273104	true	false	false	true	false
ea2c5800-223c-4c6b-82dc-1f7c88a16add	2026-08-18 09:48	2026-08-18 09:48	2026-08-18 09:48	SPY	SPY261120P00740000	put	740.0000	2026-11-20	12.7400	12.6900	12.7400	769.0000	3241032.00	3241032.00	0.00	2544	22	2561	7195	0.355941626129256	0.178639263556261	0.178628587131818	true	false	false	true	false
3f080e86-8174-4e59-bddc-7eb581c78376	2026-08-18 09:50	2026-08-18 09:49	2026-08-18 09:49	SPY	SPY260827P00771000	put	771.0000	2026-08-27	6.3900	6.3000	6.3900	768.0000	127800.00	127800.00	0.00	200	11	203	18	11.2777777777778	0.113272466429943	0.113272466429943	false	false	false	true	false
0ad2fb71-563d-47a3-955e-74857283e98e	2026-08-18 09:50	2026-08-18 09:50	2026-08-18 09:50	SPY	SPY260818P00768000	put	768.0000	2026-08-18	1.0700	1.0700	1.0900	768.0000	114725.00	1192.00	112993.00	1072	40	78089	4728	16.5162859560068	0.159537917979627	0.160091055923651	false	false	false	true	false
604111ab-a776-489d-82b5-e5542be09429	2026-08-18 09:52	2026-08-18 09:52	2026-08-18 09:52	SPY	SPY260911P00786000	put	786.0000	2026-09-11	18.9200	18.8400	19.2200	768.3801	183530.00	5680.00	177850.00	97	14	125	258	0.484496124031008	0.113382110428608	0.11370241991879	true	false	false	true	false
0c89f8be-6fa3-4b53-a31f-7bc36a4d60b9	2026-08-18 09:52	2026-08-18 09:52	2026-08-18 09:52	SPY	SPY260904P00786000	put	786.0000	2026-09-04	18.2800	18.1800	18.5300	768.3700	349182.00	1832.00	347350.00	191	6	193	471	0.409766454352442	0.112636212715881	0.113284792834043	true	false	false	true	false
50e04a78-3318-4b4d-971b-0f63302d59c5	2026-08-18 09:53	2026-08-18 09:53	2026-08-18 09:53	SPY	SPY270917P00600000	put	600.0000	2027-09-17	13.7800	13.7200	13.7800	768.4800	689000.00	689000.00	0.00	500	6	501	2615	0.191586998087954	0.267174234216142	0.267174234216142	false	false	false	true	false
47a75124-9087-4587-ae28-a515f16cfc85	2026-08-18 09:54	2026-08-18 09:54	2026-08-18 09:54	SPY	SPY261120C00730000	call	730.0000	2026-11-20	55.3100	55.3100	55.6000	768.3599	254426.00	0.00	254426.00	46	8	128	787	0.162642947903431	0.175449431937103	0.175449431937103	false	false	false	true	false
e1709a93-0131-49ce-b3e0-53d60b015f88	2026-08-18 09:54	2026-08-18 09:54	2026-08-18 09:54	SPY	SPY260831P00765000	put	765.0000	2026-08-31	4.8600	4.8400	4.9000	768.5500	242807.00	0.00	242807.00	500	7	1335	12898	0.103504419289812	0.119609390968106	0.119609390968106	false	false	false	true	false
c79177e2-e891-43f0-a2a2-24b12ca546f7	2026-08-18 09:58	2026-08-18 09:58	2026-08-18 09:58	SPY	SPY260828P00771000	put	771.0000	2026-08-28	6.7700	6.7300	6.7700	768.5950	328345.00	328345.00	0.00	485	6	1063	2587	0.410900657131813	0.116780913504731	0.116780913504731	false	false	false	true	false
ed3aac79-3b19-4d0f-96aa-0f1426fe45f9	2026-08-18 09:59	2026-08-18 09:58	2026-08-18 09:58	SPY	SPY260828C00772000	call	772.0000	2026-08-28	4.6800	4.6800	4.7300	768.6400	180180.00	0.00	180180.00	385	12	420	1631	0.257510729613734	0.115478486581296	0.115478486581296	false	false	false	true	false
9aac7780-d91a-4e07-b4ab-a2913b67c446	2026-08-18 10:01	2026-08-18 10:01	2026-08-18 10:01	SPY	SPY260821P00768000	put	768.0000	2026-08-21	2.9700	2.9500	2.9700	768.4200	332640.00	332640.00	0.00	1120	14	5011	5183	0.966814586147019	0.118397230624864	0.118397230624864	false	false	false	true	false
1a44ac9e-9013-43ec-9335-100a5f9582e4	2026-08-18 10:01	2026-08-18 10:01	2026-08-18 10:01	SPY	SPY261016C00780000	call	780.0000	2026-10-16	12.4500	12.4200	12.4500	768.2801	201690.00	201690.00	0.00	162	6	195	5020	0.0388446215139442	0.126580609478429	0.126580609478429	false	false	false	true	false
ddc649dd-12c7-4cf4-a3fe-4d55631d8a20	2026-08-18 10:01	2026-08-18 10:01	2026-08-18 10:01	SPY	SPY260821P00768000	put	768.0000	2026-08-21	2.9700	2.9500	2.9700	768.4600	200475.00	200475.00	0.00	675	20	5686	5183	1.09704804167471	0.118565443439229	0.119069217024588	false	false	false	true	false
81432db5-96a8-4c4e-ab92-e13496d6d1ee	2026-08-18 10:03	2026-08-18 10:03	2026-08-18 10:03	SPY	SPY260818P00773000	put	773.0000	2026-08-18	4.0000	3.9900	4.0300	769.1200	306008.00	304010.00	1998.00	765	9	4996	13043	0.383040711492755	0.14841510941099	0.15201049105937	true	false	false	true	false
a3b75437-bf55-46ed-a785-9f605e67f704	2026-08-18 10:07	2026-08-18 10:07	2026-08-18 10:07	SPY	SPY260818C00768000	call	768.0000	2026-08-18	1.7600	1.7600	1.7800	768.9900	211814.00	0.00	205088.00	1202	28	34247	184	186.125	0.150927483037561	0.149593973007564	true	false	false	true	false
b59f36f1-8f5c-4466-a446-ad4c8640ffc7	2026-08-18 10:10	2026-08-18 10:09	2026-08-18 10:09	SPY	SPY260818P00768000	put	768.0000	2026-08-18	0.8900	0.8900	0.9000	768.5900	428446.00	0.00	428446.00	4814	61	147813	4728	31.2633248730964	0.147585650668137	0.147855081877586	false	false	false	true	false
8b3492ab-691d-4fd5-a5e5-d00c09660bce	2026-08-18 10:11	2026-08-18 10:11	2026-08-18 10:11	SPY	SPY260820P00767000	put	767.0000	2026-08-20	2.2500	2.2400	2.2600	768.0700	113175.00	112950.00	0.00	503	5	4431	2551	1.73696589572717	0.124522279120399	0.124522279120399	false	false	false	true	false
6e69fd5a-cd59-4621-8155-5804c4498a89	2026-08-18 10:12	2026-08-18 10:11	2026-08-18 10:11	SPY	SPY260925P00732000	put	732.0000	2026-09-25	4.4300	4.4300	4.4500	767.9600	117395.00	0.00	117395.00	265	7	320	210	1.52380952380952	0.180308411202735	0.180308411202735	false	false	false	true	false
6cf266e7-cf3e-4d87-9dcc-e352c4fb72f2	2026-08-18 10:12	2026-08-18 10:12	2026-08-18 10:12	SPY	SPY260828C00772000	call	772.0000	2026-08-28	4.3700	4.3700	4.3800	767.8600	220685.00	0.00	220685.00	505	11	1047	1631	0.641937461679951	0.115901930043557	0.115901930043557	false	false	false	true	false
fa091dd7-e888-48f6-886b-8edcdc45e448	2026-08-18 10:14	2026-08-18 10:13	2026-08-18 10:13	SPY	SPY260819P00775000	put	775.0000	2026-08-19	7.2000	7.0500	7.2000	767.8950	141120.00	141120.00	0.00	196	5	2335	4215	0.553973902728351	0.122842481896866	0.122842481896866	true	false	false	true	false
0451dc54-c1f5-49f2-94f1-f54f9f7fca8c	2026-08-18 10:14	2026-08-18 10:14	2026-08-18 10:14	SPY	SPY260819P00765000	put	765.0000	2026-08-19	1.1500	1.1400	1.1500	767.8550	155250.00	155250.00	0.00	1350	13	14200	2247	6.31953716065866	0.145643470118708	0.14553491227342	true	false	false	true	false
cdd3db26-be78-442e-9d6b-27d8374b4b51	2026-08-18 10:15	2026-08-18 10:15	2026-08-18 10:15	SPY	SPY260818C00768000	call	768.0000	2026-08-18	1.4100	1.4000	1.4200	768.3850	121829.00	120701.00	1128.00	864	20	46749	184	254.070652173913	0.153684621844151	0.153903965151556	true	false	false	true	false
f2106a60-a788-4232-9c91-f0d0b5ee4dd5	2026-08-18 10:18	2026-08-18 10:18	2026-08-18 10:18	SPY	SPY260911C00754000	call	754.0000	2026-09-11	21.3600	21.2000	22.6400	768.2400	241382.00	106950.00	134432.00	113	9	113	280	0.403571428571429	0.149037775693641	0.148340953871377	false	false	false	true	false
e960463b-5c05-4b74-a49a-4ea20b2720c2	2026-08-18 10:19	2026-08-18 10:19	2026-08-18 10:19	SPY	SPY260918P00732000	put	732.0000	2026-09-18	3.3700	3.3700	3.3900	768.7700	271593.00	0.00	271593.00	805	17	20405	12774	1.5973853139189	0.181567094831278	0.181379917368417	false	false	false	true	false
0ecca22c-a09d-477d-ab7a-c20536e107bf	2026-08-18 10:19	2026-08-18 10:19	2026-08-18 10:19	SPY	SPY260918P00732000	put	732.0000	2026-09-18	3.3700	3.3700	3.4000	768.7500	434682.00	0.00	434682.00	1289	9	19600	12774	1.53436668232347	0.18132184029324	0.181508987663478	false	false	false	true	false
7bcb70e2-5a99-4f6b-b80a-f3d709410348	2026-08-18 10:20	2026-08-18 10:20	2026-08-18 10:20	SPY	SPY260918P00730000	put	730.0000	2026-09-18	3.2100	3.1800	3.2100	768.7200	320923.00	320923.00	0.00	1000	21	3715	39714	0.0935438384448809	0.184412305833548	0.184218250731325	false	false	false	true	false
f464db45-1812-48fa-8f76-01ddf656287b	2026-08-18 10:23	2026-08-18 10:22	2026-08-18 10:22	SPY	SPY260930C00800000	call	800.0000	2026-09-30	2.4900	2.4800	2.5100	768.2675	329427.00	0.00	324696.00	1323	22	2001	93145	0.0214826346019647	0.107030091689375	0.107030091689375	false	false	false	true	false
6cad0baa-ff63-4b3a-835b-da604d634744	2026-08-18 10:23	2026-08-18 10:23	2026-08-18 10:23	SPY	SPY260831P00746000	put	746.0000	2026-08-31	1.5300	1.5200	1.5300	768.4100	153000.00	153000.00	0.00	1000	10	14246	962	14.8087318087318	0.151288862298666	0.151288862298666	false	false	false	true	false
e0d164c7-a1c5-4e64-a04a-15de946f001d	2026-08-18 10:23	2026-08-18 10:23	2026-08-18 10:23	SPY	SPY260930C00800000	call	800.0000	2026-09-30	2.5100	2.4900	2.5300	768.4400	1313625.00	0.00	1307601.00	5238	38	7239	93145	0.0777175371732245	0.10689259845308	0.106592007169439	false	false	false	true	false
25be800e-e856-4456-9835-794afbfb47dd	2026-08-18 10:23	2026-08-18 10:23	2026-08-18 10:23	SPY	SPY260930C00800000	call	800.0000	2026-09-30	2.4900	2.4800	2.5100	768.4100	162099.00	0.00	162099.00	651	8	7890	93145	0.0847066401846583	0.106668222920068	0.106668222920068	false	false	false	true	false
853e3fdc-b632-4303-a153-f5bdbb0529d1	2026-08-18 10:23	2026-08-18 10:23	2026-08-18 10:23	SPY	SPY260930C00800000	call	800.0000	2026-09-30	2.4700	2.4700	2.5000	768.4000	443932.00	0.00	443684.00	1796	17	9725	93145	0.104407107198454	0.106542950181745	0.106392070299146	false	false	false	true	false
6bc8e8c8-0e11-451a-bf1a-d1f8d59cc581	2026-08-18 10:23	2026-08-18 10:23	2026-08-18 10:23	SPY	SPY270331C00865000	call	865.0000	2027-03-31	8.2100	8.1800	8.2100	768.3600	248763.00	227417.00	0.00	303	14	388	416	0.932692307692308	0.131490696400407	0.131490696400407	false	false	false	true	false
ecf561bd-d33c-4a14-b6ab-101d6dd47926	2026-08-18 10:27	2026-08-18 10:27	2026-08-18 10:27	SPY	SPY260818C00769000	call	769.0000	2026-08-18	1.0500	1.0400	1.0600	768.8100	109641.00	2226.00	93345.00	1044	13	121377	435	279.027586206897	0.144445832699324	0.146890291706836	true	false	false	true	false
126ef214-c570-4be4-8622-51203b07f31c	2026-08-18 10:27	2026-08-18 10:27	2026-08-18 10:27	SPY	SPY260904P00770000	put	770.0000	2026-09-04	7.8800	7.8800	7.9600	768.8700	492768.00	3950.00	488818.00	625	21	1585	8487	0.186756215388241	0.1207735867681	0.1209246950974	true	false	false	true	false
7c97fc93-d256-43b4-acd0-c05398f4ac71	2026-08-18 10:27	2026-08-18 10:27	2026-08-18 10:27	SPY	SPY260831P00765000	put	765.0000	2026-08-31	4.7200	4.7200	4.7600	768.8600	236000.00	0.00	236000.00	500	8	2526	12898	0.195844316948364	0.119432801136599	0.119432801136599	false	false	false	true	false
f2c20195-7e64-4685-82b8-4745189e3d95	2026-08-18 10:28	2026-08-18 10:27	2026-08-18 10:27	SPY	SPY260918P00732000	put	732.0000	2026-09-18	3.3600	3.3600	3.3800	768.8500	336000.00	0.00	336000.00	1000	10	21409	12774	1.67598246438077	0.181395659486289	0.181424667894803	false	false	false	true	false
54d9b7fc-31f1-43d3-a3d5-87c15d6997f6	2026-08-18 10:32	2026-08-18 10:31	2026-08-18 10:31	SPY	SPY270115C00770000	call	770.0000	2027-01-15	35.5400	35.5300	35.6200	768.9700	287874.00	0.00	287874.00	81	7	193	7447	0.0259164764334631	0.151223928144055	0.151223928144055	false	false	false	true	false
064fdaf1-127e-4e92-9865-1f530801ab99	2026-08-18 10:32	2026-08-18 10:32	2026-08-18 10:32	SPY	SPY260821P00767000	put	767.0000	2026-08-21	2.3700	2.3700	2.3800	768.9300	106650.00	0.00	106650.00	450	20	3859	2804	1.3762482168331	0.120379506554669	0.120379506554669	true	false	false	true	false
57056702-1802-4d06-aa90-44afe8e3bf2c	2026-08-18 10:42	2026-08-18 10:42	2026-08-18 10:42	SPY	SPY260818P00765000	put	765.0000	2026-08-18	0.2000	0.1900	0.2000	768.7800	195800.00	195800.00	0.00	9790	69	101812	7714	13.1983406792844	0.17423531297266	0.173915623343906	true	false	false	true	false
6b1aa60b-24ea-44f8-8dd9-77abe1f4b437	2026-08-18 10:45	2026-08-18 10:44	2026-08-18 10:44	SPY	SPY260821P00764000	put	764.0000	2026-08-21	1.6400	1.6400	1.6500	768.4050	102664.00	0.00	102664.00	626	21	2579	7291	0.353723769030311	0.125591579636525	0.125591579636525	false	false	false	true	false
6e019e2a-9988-48c3-97f7-3e9153b5fa15	2026-08-18 10:45	2026-08-18 10:45	2026-08-18 10:45	SPY	SPY260820P00767000	put	767.0000	2026-08-20	2.0300	2.0300	2.0400	768.3900	102515.00	0.00	102515.00	505	5	9710	2551	3.80635045080361	0.120656764362591	0.120656764362591	false	false	false	true	false
3a80bbc5-bda9-4ec5-a533-56365da2fa30	2026-08-18 10:46	2026-08-18 10:45	2026-08-18 10:45	SPY	SPY281215C01190000	call	1190.0000	2028-12-15	4.6300	4.6300	4.7000	768.3500	125010.00	0.00	125010.00	270	8	540	54	10	0.140189562150377	0.140189562150377	false	false	false	true	false