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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = SPY×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

305b55c8-ce48-49ed-a9ef-e27abd938bc9	2026-10-02 14:34	2026-10-02 14:34	2026-10-02 14:34	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.2000	1.1900	1.2050	769.0800	59760.00	59760.00	0.00	498	5	496820	4172	119.084372003835	0.163871590347162	0.163871590347162	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	817569476132.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T18:40:40.412272Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
d9786462-65c5-4ba0-bea3-a92c75526819	2026-10-02 14:34	2026-10-02 14:34	2026-10-02 14:34	SPY	SPY261009C00770000	call	770.0000	2026-10-09	4.4000	4.4000	4.4300	769.0700	17601.00	0.00	17601.00	40	6	24531	7750	3.16529032258065	0.107380200209015	0.107615608218959	false	false	false	true
99b02221-a8b8-4ec6-b635-dcc1ad337aee	2026-10-02 14:34	2026-10-02 14:34	2026-10-02 14:34	SPY	SPY261002C00768000	call	768.0000	2026-10-02	1.3200	1.3200	1.3300	769.0700	14388.00	0.00	14388.00	109	5	146860	9985	14.7080620931397	0.164926488406417	0.164926488406417	false	false	false	true
aef71317-de44-4f68-aae0-84b4a08f1a73	2026-10-02 14:34	2026-10-02 14:34	2026-10-02 14:34	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.6500	0.6400	0.6500	769.0900	10725.00	10725.00	0.00	165	5	413941	5858	70.6625128030044	0.153641028139236	0.153641028139236	false	false	false	true
34c44b74-befd-40aa-8365-15ecb44a084d	2026-10-02 14:34	2026-10-02 14:34	2026-10-02 14:34	SPY	SPY261231P00764000	put	764.0000	2026-12-31	17.2000	17.2000	17.2500	768.9900	15480.00	0.00	15480.00	9	5	92	169	0.544378698224852	0.152544116482487	0.152544116482487	true	false	false	true
c571b85d-b7b8-499b-9ab2-4301dc40ef2d	2026-10-02 14:34	2026-10-02 14:34	2026-10-02 14:34	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.6100	0.6000	0.6100	768.9700	12480.00	10980.00	1500.00	205	10	413054	5858	70.5110959371799	0.158598202743635	0.156049563501752	false	false	false	true
67a85315-93f7-461d-92b7-25883e314c4b	2026-10-02 14:34	2026-10-02 14:33	2026-10-02 14:33	SPY	SPY261005P00769000	put	769.0000	2026-10-05	2.1900	2.1900	2.2100	768.9801	22121.00	220.00	21681.00	101	10	59363	1739	34.1362852213916	0.0832998583868386	0.0829399492264995	false	false	false	true
7fa95a65-5252-455f-a214-aaf81dea7e0c	2026-10-02 14:33	2026-10-02 14:33	2026-10-02 14:33	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.6000	0.6000	0.6200	769.0100	18915.00	183.00	18732.00	313	5	739205	3044	242.840013140604	0.154678223691426	0.154678223691426	true	false	false	true
4152b76b-b017-4787-bed6-ae93e51e6fb8	2026-10-02 14:33	2026-10-02 14:33	2026-10-02 14:33	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.6600	0.6500	0.6600	769.0800	13166.00	6666.00	6500.00	201	7	412401	5858	70.3996244452031	0.154151437023682	0.156697092662253	false	false	false	true
f5c3cc8d-f939-4608-b346-ff74f8430062	2026-10-02 14:33	2026-10-02 14:33	2026-10-02 14:33	SPY	SPY261005P00769000	put	769.0000	2026-10-05	2.1500	2.1400	2.1500	769.0900	32250.00	32250.00	0.00	150	5	59121	1739	33.9971247843588	0.0833929293705759	0.0833929293705759	false	false	false	true
b7ae1a46-1e6c-47c0-9508-5132dfc54c5a	2026-10-02 14:33	2026-10-02 14:33	2026-10-02 14:33	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.2400	0.2400	0.2500	769.2000	29140.00	2500.00	26640.00	1210	15	635745	3948	161.029635258359	0.172375677069933	0.172375677069933	false	false	false	true
e6233367-adf6-483b-86d0-4537411a84b5	2026-10-02 14:33	2026-10-02 14:33	2026-10-02 14:33	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.7200	0.7100	0.7400	769.2050	12994.00	10250.00	2744.00	180	10	410930	5858	70.1485148514851	0.155036832094268	0.156885299515813	false	false	false	true
f5ff82d3-bc73-46de-81bc-22ba0e9fa2a9	2026-10-02 14:33	2026-10-02 14:32	2026-10-02 14:32	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.5500	0.5500	0.5600	769.1550	15455.00	0.00	15455.00	281	5	735170	3044	241.514454664915	0.158735514603324	0.158735514603324	false	false	false	true
c4261af7-2966-48bc-8d22-5bb43cdb416c	2026-10-02 14:33	2026-10-02 14:32	2026-10-02 14:32	SPY	SPY261231P00764000	put	764.0000	2026-12-31	17.1700	17.1300	17.2000	769.1400	125341.00	120190.00	5151.00	73	8	83	169	0.49112426035503	0.152744935506864	0.152744935506864	false	false	false	true
c2ba8766-b7f9-4e79-892d-08d23009dd08	2026-10-02 14:33	2026-10-02 14:32	2026-10-02 14:32	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.5600	0.5500	0.5600	769.1550	12208.00	12208.00	0.00	218	12	734889	3044	241.422141918528	0.161265526768814	0.161265526768814	false	false	false	true
64980a46-3bac-47c5-b761-191b467b1ea4	2026-10-02 14:33	2026-10-02 14:32	2026-10-02 14:32	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.7000	0.6900	0.7100	769.1550	16660.00	15470.00	0.00	238	7	410324	5858	70.0450665756231	0.156130923291593	0.156130923291593	false	false	false	true
85896e9e-9f09-4c4b-abcf-1bf6bc1c858b	2026-10-02 14:32	2026-10-02 14:32	2026-10-02 14:32	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.6500	0.6400	0.6500	769.0700	15144.00	15080.00	64.00	233	11	409352	5858	69.8791396381017	0.15226839612908	0.154817211853374	false	false	false	true
f6468b8e-bd97-42d7-9558-d041a6518404	2026-10-02 14:32	2026-10-02 14:32	2026-10-02 14:32	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.5900	0.5900	0.6000	769.0700	14493.00	5820.00	8673.00	244	15	734265	3044	241.21714848883	0.161166590852541	0.158633188236634	false	false	false	true
0b34d666-d425-41be-9483-5f02b1aa8800	2026-10-02 14:32	2026-10-02 14:32	2026-10-02 14:32	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.2500	1.2500	1.2600	768.9400	15000.00	0.00	15000.00	120	6	493829	4172	118.36744966443	0.145372348285095	0.145372348285095	false	false	false	true
73be0e7f-7d82-452c-a662-0432776931c0	2026-10-02 14:32	2026-10-02 14:32	2026-10-02 14:32	SPY	SPY261005P00769000	put	769.0000	2026-10-05	2.2400	2.2200	2.2400	768.9100	13215.00	12992.00	0.00	59	6	58771	1739	33.7958596894767	0.0831568999166596	0.0835166732260462	false	false	false	true
697cfd13-4776-4a3c-b4a7-2baeb54239b3	2026-10-02 14:32	2026-10-02 14:32	2026-10-02 14:32	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.3000	1.3000	1.3200	768.8900	71535.00	0.00	71535.00	550	18	493534	4172	118.296740172579	0.148791327037843	0.148791327037843	true	false	false	true
301c8feb-41ef-4fa6-8388-c5fa63bd905a	2026-10-02 14:32	2026-10-02 14:32	2026-10-02 14:32	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.6900	0.6900	0.7000	768.8746	66309.00	0.00	66309.00	961	9	733267	3044	240.889290407359	0.158340031862242	0.158340031862242	false	false	false	true
f3c3268c-16dd-4884-bd9c-e7e846e1e800	2026-10-02 14:31	2026-10-02 14:31	2026-10-02 14:31	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.3500	1.3400	1.3500	768.8801	19710.00	19710.00	0.00	146	9	492715	4172	118.100431447747	0.162234038427935	0.162234038427935	false	false	false	true
c1f5455a-19f5-433a-bd94-77bccf363c9c	2026-10-02 14:31	2026-10-02 14:31	2026-10-02 14:31	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.6900	0.6800	0.6900	768.8880	15735.00	11247.00	4488.00	229	11	730424	3044	239.955321944809	0.159589734396339	0.157071561771005	true	false	false	true
4d4d5a0d-f32c-463c-bac7-eb0bbb7a34f1	2026-10-02 14:31	2026-10-02 14:31	2026-10-02 14:31	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.3000	1.2800	1.3000	768.9800	12576.00	12576.00	0.00	97	7	492130	4172	117.96021093001	0.16619286419755	0.16922072763567	true	false	false	true
fe404c68-5c68-41af-b481-0fdee3fa39f9	2026-10-02 14:31	2026-10-02 14:31	2026-10-02 14:31	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.6700	0.6600	0.6700	768.9500	10050.00	10050.00	0.00	150	9	729797	3044	239.749342969777	0.162280194558812	0.162280194558812	false	false	false	true
f8b726b7-f20a-4260-93dc-bcd5e93bdbc9	2026-10-02 14:30	2026-10-02 14:30	2026-10-02 14:30	SPY	SPY261002C00767000	call	767.0000	2026-10-02	2.1500	2.1400	2.1600	769.0350	188571.00	188571.00	0.00	877	6	55375	8148	6.79614629356897	0.19951100810738	0.181945037562766	true	false	false	true
03480107-17d7-4b4f-a430-5e54cd60cd03	2026-10-02 14:30	2026-10-02 14:30	2026-10-02 14:30	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.2000	1.2000	1.2200	769.0400	62410.00	0.00	62410.00	520	13	491708	4172	117.859060402685	0.151812725632199	0.154846750149969	false	false	false	true
8451bb26-9604-4dc2-b115-d078ae39cbba	2026-10-02 14:30	2026-10-02 14:30	2026-10-02 14:30	SPY	SPY261005P00768000	put	768.0000	2026-10-05	1.8100	1.8000	1.8100	768.9500	18100.00	18100.00	0.00	100	7	41129	1461	28.1512662559891	0.0850794940906723	0.0850794940906723	false	false	false	true
74b799bc-34aa-4dec-b2fd-b50b6e5f960b	2026-10-02 14:30	2026-10-02 14:30	2026-10-02 14:30	SPY	SPY261006C00768000	call	768.0000	2026-10-06	3.6100	3.5900	3.6100	768.9100	10830.00	10830.00	0.00	30	5	3249	1547	2.10019392372334	0.0916886708370055	0.0916886708370055	false	false	false	true
da44467f-9040-4ce6-94ba-c92a296de400	2026-10-02 14:30	2026-10-02 14:30	2026-10-02 14:30	SPY	SPY261002C00768000	call	768.0000	2026-10-02	1.2800	1.2600	1.2800	769.0000	101366.00	101366.00	0.00	792	7	144227	9985	14.4443665498247	0.163469670281834	0.164283660483453	false	false	false	true
add2160c-194e-4707-83c8-70f9bcd626ff	2026-10-02 14:30	2026-10-02 14:30	2026-10-02 14:30	SPY	SPY261106P00750000	put	750.0000	2026-11-06	6.0900	6.0600	6.1000	769.0000	175392.00	14007.00	161385.00	288	19	650	4402	0.147660154475239	0.154863393800018	0.154897368369999	false	false	false	true
8a71babf-3f2b-4f85-a03b-798d5388f121	2026-10-02 14:30	2026-10-02 14:30	2026-10-02 14:30	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.3000	0.2900	0.3100	769.0000	13490.00	0.00	13490.00	450	16	627011	3948	158.817375886525	0.170997328844518	0.168862601218601	true	false	false	true
60fb6811-6ad4-4d32-9f35-b56ae34e7c1b	2026-10-02 14:30	2026-10-02 14:30	2026-10-02 14:30	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.6200	0.6100	0.6200	768.9900	35898.00	35898.00	0.00	579	11	405283	5858	69.1845339706384	0.155064649400599	0.155064649400599	false	false	false	true
9b787086-9210-4d36-997d-a59a49493d72	2026-10-02 14:30	2026-10-02 14:29	2026-10-02 14:29	SPY	SPY261106P00750000	put	750.0000	2026-11-06	6.0900	6.0900	6.1000	768.9700	66381.00	0.00	66381.00	109	11	329	4402	0.074738755111313	0.154727461355535	0.15479543441387	false	false	false	true
66334b92-b320-44b4-8b39-c8facd494cc0	2026-10-02 14:29	2026-10-02 14:29	2026-10-02 14:29	SPY	SPY261106P00750000	put	750.0000	2026-11-06	6.0900	6.0900	6.1000	768.9350	28623.00	0.00	28623.00	47	5	197	4402	0.0447523852794184	0.154693469695315	0.154676472581743	false	false	false	true
b310e1c4-d792-4396-a86b-4167b760a9a0	2026-10-02 14:29	2026-10-02 14:29	2026-10-02 14:29	SPY	SPY261005P00766000	put	766.0000	2026-10-05	1.1900	1.1900	1.2000	768.9500	29750.00	0.00	29750.00	250	9	27439	1919	14.2985930171965	0.0889543584561526	0.0889543584561526	true	false	false	true
4363f075-aa8c-4f0f-acd1-ef3290188f09	2026-10-02 14:29	2026-10-02 14:29	2026-10-02 14:29	SPY	SPY261030P00730000	put	730.0000	2026-10-30	2.3600	2.3600	2.3700	768.9300	15340.00	0.00	15340.00	65	15	2091	17308	0.120811185578923	0.176041290216528	0.176041290216528	false	false	false	true
a16e24ec-0e5c-4e3e-89cb-ac7949ef899c	2026-10-02 14:29	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261002C00771000	call	771.0000	2026-10-02	0.0900	0.0900	0.1000	768.9500	14751.00	0.00	14751.00	1639	5	503238	8792	57.2381710646042	0.165250779353595	0.165250779353595	false	false	false	true
4d227c07-e9b3-484a-9ba5-3b3c1671137a	2026-10-02 14:29	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.6700	0.6600	0.6700	768.9800	12394.00	12328.00	66.00	185	9	726275	3044	238.592312746386	0.16406045913315	0.16406045913315	false	false	false	true
1786a5d5-80c4-4f9f-9a9a-80ff8afc631f	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.6300	0.6100	0.6300	768.9500	39391.00	39391.00	0.00	627	18	403027	5858	68.7994195971321	0.158852853766389	0.161327963510024	true	false	false	true
0d349950-46e5-4c8b-9285-2c8650a383db	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.3200	1.3100	1.3300	768.9300	66042.00	65910.00	0.00	500	20	490456	4172	117.558964525407	0.161805515232497	0.16484472749534	false	false	false	true
38cadbcb-0410-4e6e-88bd-99642e3287da	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.6000	0.6000	0.6100	768.9150	19800.00	0.00	19800.00	330	5	401784	5858	68.5872311369068	0.158016474291063	0.158016474291063	false	false	false	true
3f1a4389-36d5-4c99-9de0-4cd67c206c93	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.6000	0.5900	0.6000	768.8800	20760.00	20760.00	0.00	346	8	401364	5858	68.5155343120519	0.162119033853358	0.162119033853358	false	false	false	true
ac836b3b-593c-4800-a6c5-1d44884a2652	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261005C00772000	call	772.0000	2026-10-05	0.9400	0.9300	0.9400	768.8600	18048.00	18048.00	0.00	192	6	45500	1312	34.6798780487805	0.0742904398301987	0.0742904398301987	true	false	false	true
5b0b2fae-8dea-4090-9519-9e93992311f7	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261005P00770000	put	770.0000	2026-10-05	2.7400	2.7400	2.7600	768.8700	24940.00	0.00	24940.00	91	7	46003	1578	29.1527249683143	0.082193889567985	0.0818302771118716	false	false	false	true
647082b5-2db6-40c5-bfdc-26194cb217f1	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.5800	0.5800	0.6000	768.8850	14452.00	0.00	14452.00	249	9	400508	5858	68.3694093547286	0.158893975326368	0.15641818034035	true	false	false	true
b339b4a5-82ed-4816-9b6c-ae1f20d6f30a	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.3500	0.3400	0.3600	768.8650	25200.00	0.00	10955.00	720	6	623149	3948	157.839159067882	0.172713529867795	0.173161949883674	false	false	false	true
174baec5-e842-4121-afb4-29d9412994f3	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.3500	1.3400	1.3600	768.8800	68040.00	7695.00	52920.00	504	37	489906	4172	117.427133269415	0.1592199553792	0.1592199553792	true	false	false	true
14a95b0a-cd84-4b14-8f4a-bcc906d2a5d1	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261002C00767000	call	767.0000	2026-10-02	1.9800	1.9700	1.9900	768.8200	16038.00	0.00	12276.00	81	7	54073	8148	6.63635247913598	0.180961110793914	0.180961110793914	false	false	false	true