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:alert_rule = RepeatedHits×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	expirydate

5e8d88c9-cfd0-43f8-9764-1db355acc8b3	2026-10-02 13:14	2026-10-02 13:14	2026-10-02 13:14	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.6200	0.6200	0.6300	769.0000	21824.00	0.00	21824.00	352	6	541675	3044	177.948423127464	0.157826202699739	0.157826202699739	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	817569476132.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T17:17:42.648638Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
ffb76d26-2075-4fe3-871d-e9efd03927af	2026-10-02 13:13	2026-10-02 13:13	2026-10-02 13:13	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.1400	1.1300	1.1400	769.0000	56959.00	52326.00	4633.00	500	5	428113	4172	102.615771812081	0.154734909882637	0.154734909882637	false	false	false	true
f03bd877-6ead-45eb-a9d2-143fe66905c8	2026-10-02 13:13	2026-10-02 13:13	2026-10-02 13:13	SPY	SPY261002C00770000	call	770.0000	2026-10-02	0.5800	0.5800	0.5900	769.0000	52200.00	0.00	52200.00	900	7	468391	18665	25.0946155906777	0.149498331093119	0.149498331093119	false	false	false	true
c14a17f5-c3ad-4cab-8cd3-86c81a9d238e	2026-10-02 13:12	2026-10-02 13:12	2026-10-02 13:12	SPY	SPY261007P00766000	put	766.0000	2026-10-07	2.3900	2.3800	2.3900	769.0000	13145.00	13145.00	0.00	55	5	1392	379	3.67282321899736	0.112601171020138	0.112601171020138	false	false	false	true
f40807b1-a3ff-4db6-afbb-48ddd8ce1c0a	2026-10-02 13:12	2026-10-02 13:12	2026-10-02 13:12	SPY	SPY261008C00775000	call	775.0000	2026-10-08	1.8900	1.8700	1.8900	769.0000	33075.00	33075.00	0.00	175	6	1122	464	2.41810344827586	0.0991458771187679	0.0991458771187679	false	false	false	true
dc5db68b-3b30-40ed-8b96-59a9706169c7	2026-10-02 13:12	2026-10-02 13:12	2026-10-02 13:12	SPY	SPY261009C00780000	call	780.0000	2026-10-09	1.0600	1.0500	1.0600	769.0000	15158.00	15158.00	0.00	143	5	19564	50715	0.385763580794637	0.10094386939271	0.10094386939271	false	false	false	true
adf2e4c0-89bb-4f49-9914-5a0a9844eedd	2026-10-02 13:12	2026-10-02 13:12	2026-10-02 13:12	SPY	SPY261008P00770000	put	770.0000	2026-10-08	4.3000	4.2900	4.3000	769.0000	15480.00	15480.00	0.00	36	6	1428	166	8.60240963855422	0.109425913171758	0.109425913171758	false	false	false	true
575a7bd3-b16a-4b2e-95ae-abc0f4b12e81	2026-10-02 13:12	2026-10-02 13:12	2026-10-02 13:12	SPY	SPY261009C00772000	call	772.0000	2026-10-09	3.7600	3.7400	3.7600	769.0000	35720.00	35720.00	0.00	95	5	9397	2368	3.9683277027027	0.109196599225602	0.109196599225602	false	false	false	true
d2ad5d26-9f7e-4f6d-ab87-75c9f7c0bc69	2026-10-02 13:12	2026-10-02 13:11	2026-10-02 13:11	SPY	SPY261002C00769000	call	769.0000	2026-10-02	1.1200	1.1200	1.1300	769.0000	12320.00	0.00	12320.00	110	6	258912	5858	44.1980198019802	0.154401134906612	0.157610560485567	true	false	false	true
e93093e3-ee3c-4e90-96db-ff76374ad1ac	2026-10-02 13:11	2026-10-02 13:11	2026-10-02 13:11	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.0700	1.0600	1.0700	769.0000	53500.00	53500.00	0.00	500	7	425564	4172	102.004793863854	0.156910479256453	0.156910479256453	false	false	false	true
f8523beb-44af-4793-b0db-4dae7f6a067a	2026-10-02 13:11	2026-10-02 13:10	2026-10-02 13:10	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.6000	0.6000	0.6100	769.0000	15725.00	305.00	15420.00	262	11	537784	3044	176.670170827858	0.161957751169519	0.161957751169519	false	false	false	true
dc38cf01-9248-424b-a6c5-8b59d0e47c6d	2026-10-02 13:10	2026-10-02 13:10	2026-10-02 13:10	SPY	SPY261005P00765000	put	765.0000	2026-10-05	0.9300	0.9300	0.9400	769.0000	32643.00	0.00	32643.00	351	16	39749	2714	14.6459100957996	0.0972242846700198	0.0972242846700198	false	false	false	true
ed910bcd-0501-4967-ae5a-4cadb95bfe00	2026-10-02 13:10	2026-10-02 13:10	2026-10-02 13:10	SPY	SPY261002C00771000	call	771.0000	2026-10-02	0.3000	0.3000	0.3100	769.0000	13710.00	0.00	13710.00	457	10	395522	8792	44.9865787079163	0.155173351025892	0.155173351025892	false	false	false	true
1e6c92ca-9e4b-477b-be2a-7cb97332673d	2026-10-02 13:10	2026-10-02 13:10	2026-10-02 13:10	SPY	SPY261002C00769000	call	769.0000	2026-10-02	1.1600	1.1600	1.1700	769.0000	23200.00	0.00	23200.00	200	13	257963	5858	44.0360191191533	0.156608108196211	0.156608108196211	false	false	false	true
5737ed35-3c69-432c-af87-65f16576d15b	2026-10-02 13:09	2026-10-02 13:09	2026-10-02 13:09	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.1300	1.1200	1.1400	769.5250	65653.00	65540.00	0.00	581	16	424320	4172	101.706615532119	0.158876779318141	0.158876779318141	false	false	false	true
affda0be-a423-4c5a-93ed-bc4cf0087003	2026-10-02 13:09	2026-10-02 13:09	2026-10-02 13:09	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.1400	1.1300	1.1400	769.4800	11400.00	11400.00	0.00	100	6	423288	4172	101.459252157239	0.155785975165415	0.155785975165415	false	false	false	true
ffd9f1f4-ac61-4e5a-b67d-1f6677be0cd2	2026-10-02 13:09	2026-10-02 13:09	2026-10-02 13:09	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.1100	1.1100	1.1200	769.5400	53280.00	0.00	53280.00	480	5	423155	4172	101.427372962608	0.156687407789235	0.156687407789235	false	false	false	true
b73d19d5-fd39-4be6-a07a-1f3244fadb52	2026-10-02 13:09	2026-10-02 13:08	2026-10-02 13:08	SPY	SPY261002C00772000	call	772.0000	2026-10-02	0.1400	0.1400	0.1500	769.4000	12600.00	0.00	12600.00	900	18	475451	18822	25.260386781426	0.162042461395248	0.162042461395248	false	false	false	true
1384b7d7-ed83-46a8-b170-12c63e1efba7	2026-10-02 13:08	2026-10-02 13:08	2026-10-02 13:08	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.6900	0.6800	0.6900	769.4700	13800.00	13800.00	0.00	200	5	534510	3044	175.594612352168	0.164185825514542	0.164185825514542	false	false	false	true
6e55a475-773a-4330-b097-be276f286dff	2026-10-02 13:08	2026-10-02 13:08	2026-10-02 13:08	SPY	SPY261002C00770000	call	770.0000	2026-10-02	0.6200	0.6200	0.6300	769.4417	15500.00	0.00	15500.00	250	12	460003	18665	24.6452183230646	0.156166195440126	0.156166195440126	false	false	false	true
6feb7fde-d057-4c98-aab4-ebb12b813ddb	2026-10-02 13:08	2026-10-02 13:08	2026-10-02 13:08	SPY	SPY261002C00770000	call	770.0000	2026-10-02	0.6200	0.6100	0.6200	769.4300	63974.00	63364.00	610.00	1032	24	459702	18665	24.6290918832039	0.156254475400612	0.156999189589514	true	false	false	true
16832113-0ce5-4946-adbc-9e57ecb5da42	2026-10-02 13:07	2026-10-02 13:07	2026-10-02 13:07	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.3300	1.3300	1.3400	769.2050	11173.00	134.00	11039.00	84	8	421875	4172	101.120565675935	0.158854770190561	0.158854770190561	true	false	false	true
81a2dd99-a6d2-4ae2-96c0-c81d17113085	2026-10-02 13:07	2026-10-02 13:07	2026-10-02 13:07	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.3400	1.3300	1.3500	769.2300	14184.00	10720.00	2794.00	106	9	421739	4172	101.087967401726	0.163774259733016	0.163774259733016	true	false	false	true
02ff2e2d-8b55-48e7-ae8d-0252695766a1	2026-10-02 13:07	2026-10-02 13:07	2026-10-02 13:07	SPY	SPY261002C00770000	call	770.0000	2026-10-02	0.5600	0.5600	0.5700	769.2300	16016.00	0.00	16016.00	286	7	458210	18665	24.5491561746585	0.159919009595199	0.159919009595199	false	false	false	true
bdc52a6c-6fb8-44ac-9060-fa06f0ccde6f	2026-10-02 13:07	2026-10-02 13:07	2026-10-02 13:07	SPY	SPY261002C00769000	call	769.0000	2026-10-02	1.0400	1.0300	1.0400	769.2350	10902.00	9048.00	1854.00	105	5	255230	5858	43.5694776374189	0.162387599529238	0.164198241626712	false	false	false	true
a5de862d-f8f5-45e4-bbb2-95162603cd5c	2026-10-02 13:07	2026-10-02 13:07	2026-10-02 13:07	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.7500	0.7400	0.7500	769.3600	12600.00	12600.00	0.00	168	6	530120	3044	174.152431011827	0.166079273396812	0.166079273396812	false	false	false	true
2dc9533d-68af-4dc6-9d9a-397835be2e77	2026-10-02 13:07	2026-10-02 13:07	2026-10-02 13:07	SPY	SPY261005P00770000	put	770.0000	2026-10-05	2.6500	2.6500	2.6600	769.4400	10600.00	0.00	10600.00	40	5	41792	1578	26.4841571609632	0.089655790390009	0.089655790390009	false	false	false	true
d8d8f79d-856a-49d0-92a0-1aca9b9b0865	2026-10-02 13:07	2026-10-02 13:07	2026-10-02 13:07	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.7100	0.7000	0.7100	769.4490	15478.00	15478.00	0.00	218	5	529714	3044	174.019053876478	0.16570256853015	0.165710492834492	false	false	false	true
10625506-a0e1-49ed-a33b-8156881a1664	2026-10-02 13:07	2026-10-02 13:07	2026-10-02 13:07	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.2000	1.1900	1.2000	769.4400	60000.00	60000.00	0.00	500	11	420890	4172	100.884467881112	0.161436839889315	0.161436839889315	false	false	false	true
c2ed2ce4-ecb9-437f-9dec-d7f967806204	2026-10-02 13:07	2026-10-02 13:07	2026-10-02 13:07	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.6900	0.6900	0.7000	769.4800	27738.00	0.00	27738.00	402	5	529428	3044	173.925098554534	0.164352137257214	0.164352137257214	false	false	false	true
cc930170-be2c-48a8-9e62-0efdac50ef65	2026-10-02 13:07	2026-10-02 13:07	2026-10-02 13:07	SPY	SPY261005C00769000	call	769.0000	2026-10-05	2.7100	2.7100	2.7200	769.4600	13550.00	0.00	13550.00	50	8	25664	1938	13.2425180598555	0.0843124092273886	0.0839144729212189	false	false	false	true
763d62d7-f93c-47f1-a28c-ae4e960fa222	2026-10-02 13:07	2026-10-02 13:07	2026-10-02 13:07	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.4100	0.4100	0.4200	769.4500	14104.00	0.00	14104.00	344	5	429229	3948	108.720618034448	0.174440307701565	0.174440307701565	false	false	false	true
4822fa0d-f090-4103-b960-d2611b32f71e	2026-10-02 13:07	2026-10-02 13:06	2026-10-02 13:06	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.4000	0.3900	0.4000	769.4400	25800.00	25800.00	0.00	645	16	428750	3948	108.599290780142	0.171638479552763	0.171638479552763	true	false	false	true
20145780-0cce-46f3-b837-38f2b9d56299	2026-10-02 13:07	2026-10-02 13:06	2026-10-02 13:06	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.7000	0.6900	0.7100	769.4300	14210.00	13790.00	420.00	203	11	528190	3044	173.518396846255	0.162207331922205	0.162207331922205	true	false	false	true
e530feb8-dd11-4e3b-a984-8257d2d95c9e	2026-10-02 13:06	2026-10-02 13:06	2026-10-02 13:06	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.6900	0.6900	0.7000	769.4700	14430.00	630.00	13800.00	209	12	526792	3044	173.059132720105	0.163284432934059	0.163284432934059	false	false	false	true
2879bc75-ef91-4d2e-a012-15b27d93c5b5	2026-10-02 13:06	2026-10-02 13:06	2026-10-02 13:06	SPY	SPY261002P00768000	put	768.0000	2026-10-02	0.3900	0.3900	0.4000	769.4700	16029.00	0.00	16029.00	411	7	427737	3948	108.342705167173	0.171059642987514	0.171059642987514	false	false	false	true
0c47a362-5fa7-4164-b93c-a515acc3fcc4	2026-10-02 13:06	2026-10-02 13:06	2026-10-02 13:06	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.1000	1.0900	1.1100	769.5850	22650.00	22650.00	0.00	205	8	418142	4172	100.225790987536	0.15823709372366	0.160059117374993	false	false	false	true
4ff465e8-ce55-4d87-bf3d-cf610e63b31a	2026-10-02 13:06	2026-10-02 13:06	2026-10-02 13:06	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.0600	1.0500	1.0600	769.6750	14734.00	14734.00	0.00	139	7	417716	4172	100.12368168744	0.160161554490708	0.160161554490708	true	false	false	true
9788c019-ba97-43a2-9f7a-fef2fbf8e6ca	2026-10-02 13:05	2026-10-02 13:05	2026-10-02 13:05	SPY	SPY261005P00765000	put	765.0000	2026-10-05	0.9200	0.9100	0.9200	769.7800	39008.00	39008.00	0.00	424	11	39275	2714	14.4712601326455	0.0983874342495682	0.0983874342495682	false	false	false	true
fe54a604-6d3b-4511-9446-183f4069017d	2026-10-02 13:04	2026-10-02 13:04	2026-10-02 13:04	SPY	SPY261002C00766000	call	766.0000	2026-10-02	3.8700	3.8600	3.8700	769.7725	46440.00	46440.00	0.00	120	11	21286	8940	2.38098434004474	0.18670862319171	0.18670862319171	false	false	false	true
380ba01b-a2d2-4d77-848d-042bafa3c35f	2026-10-02 13:04	2026-10-02 13:04	2026-10-02 13:04	SPY	SPY261002P00772000	put	772.0000	2026-10-02	2.4700	2.4700	2.4800	769.7400	11362.00	0.00	11362.00	46	7	157106	3107	50.5651754103637	0.168963465368143	0.168963465368143	false	false	false	true
117a2ec0-59f1-4b9f-87ff-ac8481d406c6	2026-10-02 13:04	2026-10-02 13:04	2026-10-02 13:04	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.5900	0.5900	0.6000	769.7200	10570.00	540.00	10030.00	179	5	521013	3044	171.160643889619	0.161904449121196	0.163786300638452	false	false	false	true
a37eff57-6da6-49f0-9723-5323c01bfd8b	2026-10-02 13:04	2026-10-02 13:04	2026-10-02 13:04	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.5900	0.5900	0.6000	769.7500	11859.00	0.00	11859.00	201	7	520565	3044	171.013469119579	0.16396172952077	0.16396172952077	false	false	false	true
e22e7a48-324f-4c6c-8c04-8d7be3e2df61	2026-10-02 13:04	2026-10-02 13:04	2026-10-02 13:04	SPY	SPY261009P00770000	put	770.0000	2026-10-09	4.5500	4.5400	4.5500	769.8400	178360.00	178360.00	0.00	392	5	20997	4625	4.53989189189189	0.112100817269881	0.112100817269881	false	false	false	true
a8954c6e-4d9a-420a-b698-56df283ac7c2	2026-10-02 13:04	2026-10-02 13:03	2026-10-02 13:03	SPY	SPY261002P00770000	put	770.0000	2026-10-02	0.9800	0.9700	0.9800	769.8400	49485.00	49000.00	485.00	505	9	414837	4172	99.4336049856184	0.160699164161942	0.160699164161942	false	false	false	true
7c076b74-49a5-4f35-95d0-dddb20091521	2026-10-02 13:03	2026-10-02 13:03	2026-10-02 13:03	SPY	SPY261002C00773000	call	773.0000	2026-10-02	0.1000	0.1000	0.1100	769.8600	19000.00	0.00	19000.00	1900	21	477346	10274	46.4615534358575	0.166340420882074	0.166340420882074	false	false	false	true
57545e41-6cb5-4263-a39b-fc855a6a4a64	2026-10-02 13:03	2026-10-02 13:03	2026-10-02 13:03	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.5700	0.5600	0.5700	769.8000	57057.00	57057.00	0.00	1001	18	518646	3044	170.383048620237	0.163251517760722	0.163251517760722	true	false	false	true
0d119842-89f7-4a3f-b436-7f53c503ce0f	2026-10-02 13:03	2026-10-02 13:03	2026-10-02 13:03	SPY	SPY261002C00773000	call	773.0000	2026-10-02	0.1000	0.1000	0.1100	769.8200	10000.00	0.00	10000.00	1000	5	475397	10274	46.2718512750633	0.167680161483831	0.167680161483831	false	false	false	true
7e8a25dc-ba62-4e6e-b010-3f2190dea76b	2026-10-02 13:02	2026-10-02 13:02	2026-10-02 13:02	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.5300	0.5300	0.5400	769.9200	10600.00	0.00	10600.00	200	11	517128	3044	169.884362680683	0.163527663751164	0.163527663751164	false	false	false	true
40ca5cd1-fb0f-47a7-bba2-5b2f19df6a18	2026-10-02 13:02	2026-10-02 13:02	2026-10-02 13:02	SPY	SPY261002P00769000	put	769.0000	2026-10-02	0.5400	0.5300	0.5400	769.9700	13875.00	13716.00	159.00	257	5	516300	3044	169.6123521682	0.168557861392096	0.168565709599549	false	false	false	true