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:er_time = unknown×ticker = SNAP×

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

e1834ef9-b900-49f4-8cda-20629969d62d	2026-09-14 13:32	2026-09-14 13:32	2026-09-14 13:32	SNAP	SNAP280121C00015000	call	15.0000	2028-01-21	0.5100	0.5100	0.5200	5.8750	10200.00	0.00	10200.00	200	7	556	51864	0.0107203455190498	0.701358043407393	0.701358043407393	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Communication Services	8392357277.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
4292839e-acbd-4d86-93ab-39713fa7c310	2026-09-14 13:07	2026-09-14 13:07	2026-09-14 13:07	SNAP	SNAP270416C00006000	call	6.0000	2027-04-16	1.2000	1.2000	1.2300	5.8550	48000.00	0.00	2400.00	400	7	508	1838	0.276387377584331	0.67709204919575	0.67709204919575	false	false	false	true
3e009509-6c1d-46a5-8d15-4af0c2dcaced	2026-09-14 13:07	2026-09-14 13:07	2026-09-14 13:07	SNAP	SNAP260918C00005500	call	5.5000	2026-09-18	0.4000	0.4000	0.4300	5.8600	20000.00	0.00	20000.00	500	5	2403	9432	0.254770992366412	0.659703445984888	0.659703445984888	false	false	false	true
daea3c87-088a-4456-ac48-56e42619ccdc	2026-09-14 13:06	2026-09-14 13:06	2026-09-14 13:06	SNAP	SNAP270115P00005000	put	5.0000	2027-01-15	0.4200	0.4200	0.4300	5.8600	11046.00	0.00	11046.00	263	13	447	35977	0.0124246046084999	0.645704126425773	0.645704126425773	false	false	false	true
b8b6c646-ffe4-4dfe-b96a-e1ed93f54f70	2026-09-14 13:05	2026-09-14 13:05	2026-09-14 13:05	SNAP	SNAP280121P00005000	put	5.0000	2028-01-21	1.0900	1.0600	1.0900	5.8650	43600.00	43600.00	0.00	400	5	411	23796	0.0172718103883006	0.675445711194952	0.675445711194952	false	false	false	true
e50f84e5-9827-486f-b521-4e38532ed234	2026-09-14 12:59	2026-09-14 12:59	2026-09-14 12:59	SNAP	SNAP280121C00007000	call	7.0000	2028-01-21	1.6000	1.5700	1.6000	5.8900	13760.00	13760.00	0.00	86	5	1928	30267	0.0636997389896587	0.683041191779868	0.683041191779868	false	false	false	true
6153ad4a-f697-4f62-8661-0423097cb60d	2026-09-14 12:47	2026-09-14 12:46	2026-09-14 12:46	SNAP	SNAP260918C00005500	call	5.5000	2026-09-18	0.4100	0.4100	0.4300	5.8700	20500.00	0.00	20500.00	500	12	1145	9432	0.121395250212044	0.670589291636221	0.670589291636221	false	false	false	true
0645c6f4-b0df-4c0f-9ea2-2ae2b89d8e1a	2026-09-14 12:07	2026-09-14 12:07	2026-09-14 12:07	SNAP	SNAP261120P00005000	put	5.0000	2026-11-20	0.3300	0.3300	0.3500	5.7450	37125.00	0.00	37125.00	1125	16	1182	0	0	0.711369777353546	0.711369777353546	false	false	false	true	false
5d725b0a-76c6-4635-9cc2-d76938f5ff59	2026-09-14 09:46	2026-09-14 09:46	2026-09-14 09:46	SNAP	SNAP261016C00005000	call	5.0000	2026-10-16	0.8500	0.7700	0.8500	5.0000	17000.00	17000.00	0.00	200	6	820	4808	0.170549084858569	0.691392618624137	0.691392618624137	false	false	false	true
d6572aff-8d19-46ef-b1b3-5754750fa880	2026-09-14 09:44	2026-09-14 09:43	2026-09-14 09:43	SNAP	SNAP261016C00005000	call	5.0000	2026-10-16	0.8500	0.7800	0.8500	5.0000	17000.00	17000.00	0.00	200	15	620	4808	0.128951747088186	0.653256660057695	0.653256660057695	false	false	false	true
c00bba73-40f9-46b0-bac9-ca396f8b303d	2026-09-14 09:41	2026-09-14 09:41	2026-09-14 09:41	SNAP	SNAP261016C00005000	call	5.0000	2026-10-16	0.8600	0.7800	0.8600	5.0000	17179.00	15394.00	0.00	200	12	420	4808	0.0873544093178037	0.680891505292562	0.680891505292562	false	false	false	true
5f7ab8ae-3d1b-45a5-9e70-db51d4c9a12a	2026-09-14 09:34	2026-09-14 09:34	2026-09-14 09:34	SNAP	SNAP261016C00005000	call	5.0000	2026-10-16	0.9200	0.8400	0.9200	5.7300	18400.00	18400.00	0.00	200	12	210	4808	0.0436772046589018	0.715196493251207	0.715196493251207	false	false	false	true
95f8d800-01b5-413b-a8cd-d3fd300e6375	2026-09-11 15:24	2026-09-11 15:24	2026-09-11 15:24	SNAP	SNAP270115C00006000	call	6.0000	2027-01-15	0.7700	0.7400	0.7700	5.7050	11781.00	11781.00	0.00	153	5	412	33857	0.0121688277165726	0.646546220495751	0.646546220495751	false	false	false	true
f45fa6da-ad9e-4916-980d-b480080d7943	2026-09-11 15:22	2026-09-11 15:22	2026-09-11 15:22	SNAP	SNAP260918C00005000	call	5.0000	2026-09-18	0.7100	0.6800	0.7200	5.6900	14200.00	3550.00	7100.00	200	5	3891	14656	0.265488537117904	0.653052431703869	0.653052431703869	false	false	false	true
3df11748-0363-41f5-97df-94c5984663aa	2026-09-11 14:23	2026-09-11 14:23	2026-09-11 14:23	SNAP	SNAP261016C00006000	call	6.0000	2026-10-16	0.2500	0.2500	0.2600	5.6350	10075.00	0.00	10075.00	403	24	1316	40091	0.0328253223915592	0.555486795698742	0.555486795698742	false	false	false	true
0a65c4f5-ae7e-4e25-8e44-4f59d8f849d3	2026-09-11 12:24	2026-09-11 12:24	2026-09-11 12:24	SNAP	SNAP260918C00005000	call	5.0000	2026-09-18	0.6600	0.6600	0.7000	5.6500	13200.00	0.00	7590.00	200	13	3247	14656	0.221547489082969	0.510779838112873	0.510779838112873	false	false	false	true
218d644d-bc85-4602-8d9c-f7967062ec53	2026-09-11 12:21	2026-09-11 12:21	2026-09-11 12:21	SNAP	SNAP260918C00005000	call	5.0000	2026-09-18	0.6800	0.6700	0.6900	5.6750	13600.00	1972.00	11628.00	200	7	2161	14656	0.147448144104804	0.407777911864931	0.407777911864931	false	false	false	true
fb84f35a-e5d2-4657-99c0-7cb9d69fc949	2026-09-11 12:20	2026-09-11 12:20	2026-09-11 12:20	SNAP	SNAP260918C00005000	call	5.0000	2026-09-18	0.6800	0.6700	0.7200	5.6701	23865.00	10200.00	9180.00	350	16	1847	14656	0.126023471615721	0.273846016575074	0.520971206747748	false	false	false	true
eaf8e205-f8d1-41a5-8c6d-c68f4ef6eea3	2026-09-11 12:19	2026-09-11 12:19	2026-09-11 12:19	SNAP	SNAP260918C00005000	call	5.0000	2026-09-18	0.6700	0.6700	0.7200	5.6850	13400.00	0.00	13400.00	200	8	1447	14656	0.0987308951965065	0.770831267218738	0.770831267218738	false	false	false	true
c414a1e6-1cf1-4d5c-85cc-5c75ded1d25e	2026-09-10 15:38	2026-09-10 15:38	2026-09-10 15:38	SNAP	SNAP280121C00005000	call	5.0000	2028-01-21	2.0300	1.9200	2.0500	5.4850	10150.00	10150.00	0.00	50	9	606	26598	0.0227836679449583	0.708024195455923	0.684676195958488	false	false	false	true
bfb376cd-fb88-4050-bbe5-94adb85a52ef	2026-09-10 15:24	2026-09-10 15:24	2026-09-10 15:24	SNAP	SNAP260918C00005000	call	5.0000	2026-09-18	0.4800	0.4300	0.4800	5.4000	11950.00	11950.00	0.00	250	24	550	14813	0.0371295483696753	0.727078183191594	0.679878705165078	false	false	false	true
fb31bbfa-6a91-4ac2-9fc3-6003a7efb9c0	2026-09-09 12:22	2026-09-09 12:21	2026-09-09 12:21	SNAP	SNAP270115C00005000	call	5.0000	2027-01-15	0.9400	0.9200	0.9400	5.2300	28200.00	28200.00	0.00	300	10	1045	40502	0.0258011950027159	0.655590901503639	0.655045024930059	false	false	false	true
f56fa30c-ce0d-42bd-bde6-9d33ffb8cc2e	2026-09-09 11:41	2026-09-09 11:41	2026-09-09 11:41	SNAP	SNAP261016C00005000	call	5.0000	2026-10-16	0.5100	0.5100	0.5400	5.2350	10200.00	0.00	10200.00	200	5	1011	5692	0.177617709065355	0.569194844501721	0.569194844501721	false	false	false	true
aca07739-a534-411a-b91b-299ad05d291b	2026-09-09 11:37	2026-09-09 11:36	2026-09-09 11:36	SNAP	SNAP261016P00006000	put	6.0000	2026-10-16	0.9100	0.8900	0.9100	5.2350	11284.00	11284.00	0.00	124	14	138	3487	0.0395755663894465	0.626179824065416	0.626179824065416	false	false	false	true
b3e49817-b9fc-48c1-9d6f-3c6371ce97ee	2026-09-09 11:31	2026-09-09 11:31	2026-09-09 11:31	SNAP	SNAP270115C00009000	call	9.0000	2027-01-15	0.1500	0.1500	0.1600	5.2800	21570.00	0.00	21570.00	1438	31	1518	14836	0.102318684281477	0.712746444120519	0.712746444120519	false	false	false	true
bad1c4df-28ef-4502-a601-6ebc38c78431	2026-09-09 11:21	2026-09-09 11:20	2026-09-09 11:20	SNAP	SNAP270115C00006000	call	6.0000	2027-01-15	0.5900	0.5900	0.6200	5.3250	14573.00	0.00	14573.00	247	7	452	33900	0.0133333333333333	0.647131576357993	0.647131576357993	false	false	false	true
3cd81742-69e4-4538-86bd-799c9d5200c8	2026-09-09 09:41	2026-09-09 09:40	2026-09-09 09:40	SNAP	SNAP270115C00005000	call	5.0000	2027-01-15	1.0000	0.9700	1.0000	5.3100	19999.00	19999.00	0.00	200	8	240	40502	0.00592563330205916	0.662415675023891	0.653830319210235	false	false	false	true
d97d39b6-1007-42ea-bc90-91ee5822eac8	2026-09-09 09:32	2026-09-09 09:32	2026-09-09 09:32	SNAP	SNAP261016C00005000	call	5.0000	2026-10-16	0.5100	0.5000	0.6000	5.2650	14000.00	1540.00	12460.00	275	57	276	5692	0.0484891075193254	0.602355933931005	0.602355933931005	false	false	false	true
4e150d0f-9791-42c6-a0e2-1bf9053d4d7e	2026-09-08 09:59	2026-09-08 09:58	2026-09-08 09:58	SNAP	SNAP270115P00005000	put	5.0000	2027-01-15	0.5200	0.5200	0.6100	5.4300	260001.00	53.00	259948.00	5000	8	5018	30137	0.166506287951687	0.608822261171018	0.617403817697752	false	false	false	true
a146d201-063b-4e10-8567-2ee4991c9be6	2026-09-08 09:31	2026-09-08 09:30	2026-09-08 09:30	SNAP	SNAP261002P00005000	put	5.0000	2026-10-02	0.1200	0.0900	0.1500	5.4500	52320.00	8376.00	43944.00	4360	12	4361	1226	3.55709624796085	0.554175675746741	0.554175675746741	false	false	false	true
983bea66-3f4b-4a24-a0d6-9279c2d0affa	2026-09-04 15:49	2026-09-04 15:49	2026-09-04 15:49	SNAP	SNAP260925C00006500	call	6.5000	2026-09-25	0.0700	0.0600	0.0700	5.4750	17500.00	17500.00	0.00	2500	21	2604	2513	1.03621169916435	0.664617300240763	0.664617300240763	false	false	false	true
760ccb49-c9fd-48ae-9e13-7de534883256	2026-09-04 14:59	2026-09-04 14:59	2026-09-04 14:59	SNAP	SNAP260918C00005500	call	5.5000	2026-09-18	0.2200	0.2200	0.2300	5.4850	22000.00	0.00	22000.00	1000	29	1983	4885	0.405936540429887	0.521410908776094	0.521410908776094	true	false	false	true
df05d1b0-31ba-4b6c-b9c2-8f8f97115369	2026-09-04 14:27	2026-09-04 14:27	2026-09-04 14:27	SNAP	SNAP261016P00006000	put	6.0000	2026-10-16	0.7500	0.7400	0.7500	5.4650	45000.00	45000.00	0.00	600	7	626	2872	0.217966573816156	0.58298273697355	0.58298273697355	false	false	false	true
30e33999-740f-44a6-b34f-f60265eba335	2026-09-04 12:01	2026-09-04 12:01	2026-09-04 12:01	SNAP	SNAP280121C00005000	call	5.0000	2028-01-21	2.0100	1.9700	2.0100	5.4950	40200.00	33366.00	0.00	200	10	792	25507	0.0310502999176697	0.682338594349902	0.682338594349902	false	false	false	true
c662b68f-cab4-427a-bf9b-9071ecab709b	2026-09-04 11:58	2026-09-04 11:58	2026-09-04 11:58	SNAP	SNAP270115P00006000	put	6.0000	2027-01-15	1.1200	1.1100	1.1300	5.4900	18816.00	5936.00	12880.00	168	5	191	11669	0.0163681549404405	0.654006971374937	0.654006971374937	false	false	false	true
b6597661-6589-4e1f-a09d-8f95c1c8fd33	2026-09-04 10:19	2026-09-04 10:19	2026-09-04 10:19	SNAP	SNAP280121C00005000	call	5.0000	2028-01-21	2.0600	2.0200	2.0600	5.5650	41200.00	41200.00	0.00	200	6	541	25507	0.0212098639589132	0.681954582503796	0.681954582503796	false	false	false	true
2e4ad8e9-2a36-444f-ab96-30e2eacc01bb	2026-09-04 09:42	2026-09-04 09:42	2026-09-04 09:42	SNAP	SNAP260911C00005000	call	5.0000	2026-09-11	0.6000	0.5500	0.6100	5.5800	30000.00	26100.00	3900.00	500	8	500	610	0.819672131147541	0.579381609688462	0.579381609688462	false	false	false	true
f83bd13a-5abb-41ed-95b0-a18ce0457946	2026-09-03 11:02	2026-09-03 11:02	2026-09-03 11:02	SNAP	SNAP270115C00005000	call	5.0000	2027-01-15	1.2700	1.2700	1.3100	5.7050	15875.00	0.00	15875.00	125	7	604	40778	0.0148119083819707	0.645900063305341	0.645900063305341	false	false	false	true
3aacc3e7-9016-43db-b1eb-518c87c6426f	2026-09-03 10:01	2026-09-03 10:01	2026-09-03 10:01	SNAP	SNAP261016C00007000	call	7.0000	2026-10-16	0.1900	0.1900	0.2000	5.9325	30039.00	0.00	30039.00	1581	10	6351	20561	0.308885754583921	0.63997045804354	0.63997045804354	true	false	false	true
af3163c6-68b9-4c80-95eb-2fab309c1fb2	2026-09-03 09:48	2026-09-03 09:48	2026-09-03 09:48	SNAP	SNAP260911C00005500	call	5.5000	2026-09-11	0.5100	0.5000	0.6000	5.9800	10200.00	0.00	10200.00	200	7	367	5479	0.0669830260996532	0.491975271309938	0.491975271309938	false	false	false	true
1472311a-1c92-47b7-a885-43ef31b3d5cf	2026-09-03 09:46	2026-09-03 09:46	2026-09-03 09:46	SNAP	SNAP261016C00006000	call	6.0000	2026-10-16	0.5000	0.4800	0.5000	6.0101	19950.00	19950.00	0.00	399	5	1538	38867	0.0395708441608563	0.587992214499598	0.587992214499598	false	false	false	true
27dc1c51-bd04-4fe1-830d-d2c60ff38b33	2026-09-02 13:54	2026-09-02 13:54	2026-09-02 13:54	SNAP	SNAP270115C00006000	call	6.0000	2027-01-15	0.7700	0.7600	0.8000	5.6600	13398.00	4774.00	8624.00	174	5	987	35605	0.0277208257267238	0.638277216023232	0.638277216023232	false	false	false	true
ee674b15-3ceb-413a-b2e8-44299a36e679	2026-09-02 13:45	2026-09-02 13:45	2026-09-02 13:45	SNAP	SNAP270115P00006000	put	6.0000	2027-01-15	1.0800	1.0100	1.0800	5.6410	19440.00	19440.00	0.00	180	5	239	11669	0.0204816179621219	0.674348064982495	0.674348064982495	false	false	false	true
cd18a2ff-cce5-4efe-b4ad-89c6adbd5900	2026-09-02 12:33	2026-09-02 12:32	2026-09-02 12:32	SNAP	SNAP270115C00007000	call	7.0000	2027-01-15	0.4700	0.4600	0.4800	5.6050	13395.00	7144.00	6251.00	285	11	1070	67899	0.0157587004226866	0.655486216040157	0.655486216040157	false	false	false	true
1be1b98e-eac0-4f11-845e-913999c0685b	2026-09-02 12:32	2026-09-02 12:32	2026-09-02 12:32	SNAP	SNAP270115C00007000	call	7.0000	2027-01-15	0.4700	0.4600	0.4700	5.6050	26931.00	26931.00	0.00	573	9	783	67899	0.0115318340476296	0.655486216040157	0.655486216040157	false	false	false	true
5a43be12-0424-44bb-8671-440dd128d955	2026-09-02 12:20	2026-09-02 12:20	2026-09-02 12:20	SNAP	SNAP260918P00005500	put	5.5000	2026-09-18	0.2300	0.2200	0.2300	5.5900	25369.00	25369.00	0.00	1103	54	3690	1000	3.69	0.603133235181262	0.598568340618176	false	false	false	true	false
e77f9502-afee-492e-b764-36e8616cd248	2026-09-01 13:50	2026-09-01 13:50	2026-09-01 13:50	SNAP	SNAP270416P00006000	put	6.0000	2027-04-16	1.4200	1.4100	1.4300	5.3177	22010.00	10650.00	11360.00	155	5	484	593	0.816188870151771	0.6544650139553	0.6544650139553	false	false	false	true
42f7ada8-4e69-469e-b4a1-88447746a407	2026-09-01 11:42	2026-09-01 11:42	2026-09-01 11:42	SNAP	SNAP270115C00006000	call	6.0000	2027-01-15	0.6300	0.6300	0.6400	5.3755	12474.00	0.00	12474.00	198	17	743	36174	0.0205396140874661	0.638932539751248	0.638932539751248	false	false	false	true
c13c076e-3bcd-485e-b720-a2e4d0b3e672	2026-09-01 11:09	2026-09-01 11:09	2026-09-01 11:09	SNAP	SNAP261016C00006000	call	6.0000	2026-10-16	0.2200	0.2100	0.2200	5.3590	11000.00	11000.00	0.00	500	9	795	38175	0.0208251473477407	0.585309435265536	0.585309435265536	false	false	false	true
b8686217-c5bf-4be5-8b05-c896fea827cf	2026-09-01 10:59	2026-09-01 10:59	2026-09-01 10:59	SNAP	SNAP270115C00005000	call	5.0000	2027-01-15	1.0400	1.0400	1.0900	5.4000	30809.00	0.00	30809.00	295	9	401	41045	0.0097697648921915	0.624832320292354	0.624832320292354	false	false	false	true