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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×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	expiry

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	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-08T14:00:31.869599Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
5f161d44-dc39-4a1d-9648-d0a1b3aa6a23	2026-09-01 09:49	2026-09-01 09:49	2026-09-01 09:49	SNAP	SNAP260918C00005500	call	5.5000	2026-09-18	0.2200	0.2000	0.2200	5.3800	11000.00	11000.00	0.00	500	5	603	3358	0.179571173317451	0.580651824473266	0.580651824473266	false	false	false	true
ca2045e5-18e3-4e89-9e93-a67f72ab61a6	2026-09-01 09:46	2026-09-01 09:46	2026-09-01 09:46	SNAP	SNAP261016C00007000	call	7.0000	2026-10-16	0.0800	0.0800	0.0900	5.3650	20000.00	0.00	20000.00	2500	39	2862	21909	0.130631247432562	0.63337392342764	0.63337392342764	false	false	false	true
95c54391-a574-462d-8054-b3c1f78768f9	2026-08-31 15:34	2026-08-31 15:33	2026-08-31 15:33	SNAP	SNAP260918C00006000	call	6.0000	2026-09-18	0.1300	0.1200	0.1300	5.5400	13000.00	13000.00	0.00	1000	8	1735	30760	0.0564044213263979	0.593930050499578	0.593930050499578	false	false	false
aa4fe42c-0d0f-4825-8615-b10269791cce	2026-08-31 11:29	2026-08-31 11:29	2026-08-31 11:29	SNAP	SNAP270115P00006000	put	6.0000	2027-01-15	1.0800	1.0600	1.1000	5.5599	11556.00	5184.00	6372.00	107	5	192	11725	0.0163752665245203	0.64209034975644	0.64209034975644	false	false	false	true
fa572885-0e23-4356-9b86-3acc2f9b2cd4	2026-08-31 11:15	2026-08-31 11:15	2026-08-31 11:15	SNAP	SNAP270416C00007000	call	7.0000	2027-04-16	0.7400	0.6800	0.7800	5.5550	20646.00	8732.00	11914.00	279	7	285	726	0.392561983471074	0.662834360574327	0.662834360574327	false	false	false	true
e9359fd0-73fa-45d1-b5e3-29ff0dc5e971	2026-08-31 10:54	2026-08-31 10:53	2026-08-31 10:53	SNAP	SNAP260904C00005500	call	5.5000	2026-09-04	0.1200	0.1100	0.1200	5.4399	29616.00	29616.00	0.00	2468	22	6211	8740	0.710640732265446	0.644146565432056	0.644146565432056	false	false	false
e790838d-1ac2-49c1-8bf2-4c2ce15fb550	2026-08-31 10:11	2026-08-31 10:11	2026-08-31 10:11	SNAP	SNAP261016C00006000	call	6.0000	2026-10-16	0.2700	0.2700	0.3000	5.4850	27000.00	0.00	27000.00	1000	22	1619	38155	0.0424321845105491	0.585503710651755	0.585503710651755	false	false	false
ab388243-4c3d-4d29-9398-f89e6672c827	2026-08-31 09:56	2026-08-31 09:56	2026-08-31 09:56	SNAP	SNAP261016C00006000	call	6.0000	2026-10-16	0.3000	0.2800	0.3000	5.5150	12030.00	12030.00	0.00	401	12	553	38155	0.014493513301009	0.609974229983829	0.609974229983829	false	false	false	true
1bccbf33-4f13-4f16-b711-a45e89e290c3	2026-08-31 09:35	2026-08-31 09:35	2026-08-31 09:35	SNAP	SNAP270115C00005000	call	5.0000	2027-01-15	1.2100	1.1500	1.2100	5.5900	35695.00	35695.00	0.00	295	9	303	40650	0.00745387453874539	0.655688603283067	0.655688603283067	false	false	false
51647e56-7c27-4258-af12-7b5cbfb7f397	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	SNAP	SNAP260904C00005000	call	5.0000	2026-09-04	0.5900	0.5500	0.5900	5.5550	29500.00	29500.00	0.00	500	5	501	2104	0.238117870722433	0.673560212072355	0.673560212072355	false	false	false	true
cad82374-d7f7-4e55-b100-690fb1a71dca	2026-08-27 13:40	2026-08-27 13:40	2026-08-27 13:40	SNAP	SNAP261016C00006000	call	6.0000	2026-10-16	0.2800	0.2800	0.3000	5.4810	13972.00	0.00	13972.00	499	48	2869	36827	0.0779047981100823	0.571219227250923	0.575685985633892	false	false	false
9ce5c8d0-3da8-4a63-a678-605ca783f5d1	2026-08-27 13:06	2026-08-27 13:06	2026-08-27 13:06	SNAP	SNAP270115C00005000	call	5.0000	2027-01-15	1.1700	1.1400	1.1700	5.5034	19773.00	19773.00	0.00	169	5	371	40540	0.00915145535273804	0.662277442551131	0.662277442551131	false	false	false
5a479508-f95f-4177-a634-f06f24f5686e	2026-08-27 11:35	2026-08-27 11:35	2026-08-27 11:35	SNAP	SNAP280121C00007000	call	7.0000	2028-01-21	1.3800	1.3600	1.5000	5.4950	103914.00	2484.00	101430.00	753	8	1569	29538	0.053118017469023	0.680198461719643	0.677972924439372	false	false	false
365bbeab-1650-42e8-ba83-10c85eec626c	2026-08-27 11:24	2026-08-27 11:24	2026-08-27 11:24	SNAP	SNAP261016C00006000	call	6.0000	2026-10-16	0.3000	0.2800	0.3000	5.4900	30000.00	30000.00	0.00	1000	5	2104	36827	0.0571319955467456	0.59687001065112	0.59687001065112	false	false	false	true
78f2a915-d65f-4003-a541-0f9f7527084c	2026-08-27 11:19	2026-08-27 11:19	2026-08-27 11:19	SNAP	SNAP280121C00005000	call	5.0000	2028-01-21	2.0000	1.9500	2.0300	5.4900	110000.00	14400.00	95600.00	550	6	558	24986	0.0223325062034739	0.675096247743382	0.675096247743382	false	false	false
664f27c3-af7a-41e1-bc91-d3c11e00b3a2	2026-08-27 09:33	2026-08-27 09:33	2026-08-27 09:33	SNAP	SNAP261016C00006000	call	6.0000	2026-10-16	0.2600	0.2400	0.2600	5.3450	12974.00	12974.00	0.00	499	27	586	36827	0.0159122383034187	0.613367083149564	0.615731480964475	false	false	false
4effd457-37e9-419b-8b93-90fff9cadb46	2026-08-26 15:33	2026-08-26 15:32	2026-08-26 15:32	SNAP	SNAP270115C00006000	call	6.0000	2027-01-15	0.7200	0.7100	0.7200	5.4600	144000.00	144000.00	0.00	2000	39	5578	32065	0.173959145485732	0.660393852015838	0.660393852015838	true	false	false
0896bf1b-7970-4895-9522-f7b872b5ac22	2026-08-26 15:20	2026-08-26 15:20	2026-08-26 15:20	SNAP	SNAP270416C00006000	call	6.0000	2027-04-16	1.0000	0.9500	1.0000	5.4499	75000.00	75000.00	0.00	750	7	1078	403	2.67493796526055	0.668239708420306	0.668239708420306	false	false	false	true
63a82e0f-ea38-4e48-a589-adeb9f5fb82c	2026-08-26 14:04	2026-08-26 14:04	2026-08-26 14:04	SNAP	SNAP280121C00010000	call	10.0000	2028-01-21	0.8200	0.8000	0.8300	5.3900	20500.00	20500.00	0.00	250	21	696	56991	0.0122124545980944	0.691141312184047	0.691141312184047	false	false	false
91f8ebe9-5bf0-4a4f-b11d-265aec32c26d	2026-08-26 14:02	2026-08-26 14:02	2026-08-26 14:02	SNAP	SNAP260918C00006000	call	6.0000	2026-09-18	0.1300	0.1200	0.1300	5.3850	26000.00	26000.00	0.00	2000	52	7141	30406	0.234854962836282	0.618955646681457	0.618955646681457	true	false	false
fa0af8ec-43c4-4cfe-9caf-ff54f995a7eb	2026-08-26 13:11	2026-08-26 13:11	2026-08-26 13:11	SNAP	SNAP261016C00007000	call	7.0000	2026-10-16	0.1100	0.1100	0.1200	5.3495	13156.00	0.00	13156.00	1196	10	10573	22916	0.461380694711119	0.661201517954785	0.661201517954785	false	false	false
436987c8-d7c4-40b7-9860-2a7c930326a2	2026-08-26 12:36	2026-08-26 12:35	2026-08-26 12:35	SNAP	SNAP280121C00005000	call	5.0000	2028-01-21	1.9200	1.9200	1.9400	5.3701	14784.00	0.00	14784.00	77	16	530	24716	0.0214435992879107	0.67738475972479	0.67738475972479	false	false	false	true
f9f74bae-422d-4681-9b14-23e39de5670d	2026-08-26 12:30	2026-08-26 12:30	2026-08-26 12:30	SNAP	SNAP270115C00006000	call	6.0000	2027-01-15	0.6800	0.6600	0.6900	5.3900	14960.00	2176.00	12784.00	220	6	2230	32065	0.0695462342117574	0.656637594188575	0.656637594188575	false	false	false
20055c92-f73c-4e67-bc91-849976a6217d	2026-08-26 12:17	2026-08-26 12:17	2026-08-26 12:17	SNAP	SNAP280121C00007000	call	7.0000	2028-01-21	1.3400	1.3100	1.3400	5.4000	53600.00	53600.00	0.00	400	12	1613	28379	0.0568378026005145	0.682823059498025	0.682823059498025	false	false	false
b5d4c6cc-33f3-4f54-a444-b9016ffef301	2026-08-26 12:14	2026-08-26 12:14	2026-08-26 12:14	SNAP	SNAP280121C00007000	call	7.0000	2028-01-21	1.3400	1.3000	1.3400	5.4250	53600.00	53600.00	0.00	400	21	1212	28379	0.0427076359279749	0.677263775892406	0.677263775892406	false	false	false
df82b4cb-b100-4878-b409-431d125bd3e1	2026-08-26 11:29	2026-08-26 11:28	2026-08-26 11:28	SNAP	SNAP270115C00006000	call	6.0000	2027-01-15	0.7000	0.7000	0.7100	5.4750	14027.00	1917.00	12110.00	200	12	1429	32065	0.0445657258693279	0.638280468792451	0.647469124768466	false	false	false
90c9d3b7-d81e-4034-b238-e4ebcef34217	2026-08-26 11:12	2026-08-26 11:12	2026-08-26 11:12	SNAP	SNAP260925P00006000	put	6.0000	2026-09-25	0.6600	0.6200	0.6700	5.5250	26400.00	21384.00	5016.00	400	9	400	21	19.047619047619	0.593885343566963	0.593885343566963	false	false	false	true
0ff9dd36-3855-455b-979d-a92bca4a52cb	2026-08-26 11:11	2026-08-26 11:11	2026-08-26 11:11	SNAP	SNAP260918C00006000	call	6.0000	2026-09-18	0.1500	0.1400	0.1500	5.5188	32400.00	32400.00	0.00	2160	28	4653	30406	0.153029007432744	0.578220476100749	0.578220476100749	false	false	false