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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = SNAP×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	pricenumeric

b8c8d6e4-a26b-4499-a1ff-5051b13e38f7	2026-08-25 13:52	2026-08-25 13:52	2026-08-25 13:52	SNAP	SNAP280121C00007000	call	7.0000	2028-01-21	1.4700	1.4700	1.4900	5.7400	16318.00	148.00	16170.00	111	23	887	26688	0.0332359112709832	0.656401968328022	0.660166344275039	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-08-25T17:59:30.582778Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
bd5e7612-2bbb-489c-b67a-94755830a1f6	2026-08-25 14:12	2026-08-25 14:12	2026-08-25 14:12	SNAP	SNAP260911P00006000	put	6.0000	2026-09-11	0.4100	0.3800	0.4100	5.0000	12341.00	12341.00	0.00	301	12	302	30	10.0666666666667	0.561238178946344	0.561238178946344	false	false	false	true	false
3a53e0e3-627d-41f0-96fb-a672afe1a2e3	2026-08-25 14:22	2026-08-25 14:22	2026-08-25 14:22	SNAP	SNAP280121C00007000	call	7.0000	2028-01-21	1.4900	1.4900	1.5100	5.0000	14900.00	0.00	14900.00	100	20	1566	26688	0.0586780575539568	0.657320519881794	0.657320519881794	false	false	false	true	false
081b3416-fabb-40cb-8829-a80abb3387ac	2026-08-25 14:37	2026-08-25 14:37	2026-08-25 14:37	SNAP	SNAP280121P00005000	put	5.0000	2028-01-21	1.1200	1.1100	1.1500	5.7650	10080.00	224.00	9744.00	90	20	1993	21325	0.0934583821805393	0.660817243875824	0.660817243875824	false	false	false	true	false
c4de16c4-a702-4ac2-ba16-b83ad2c175da	2026-08-25 14:46	2026-08-25 14:46	2026-08-25 14:46	SNAP	SNAP260904C00006000	call	6.0000	2026-09-04	0.1700	0.1500	0.1800	5.8250	32712.00	5869.00	0.00	1925	16	7669	4793	1.6000417275193	0.602002168281967	0.628694428114061	false	false	false	true	false
2454d986-59df-4764-9387-eed7dcdd1b25	2026-08-25 14:52	2026-08-25 14:52	2026-08-25 14:52	SNAP	SNAP260904C00006000	call	6.0000	2026-09-04	0.1800	0.1700	0.1800	5.8300	11016.00	11016.00	0.00	612	17	8728	4793	1.82098894220739	0.649753370328636	0.649753370328636	true	false	false	true	false
4d2c3d17-af77-4d65-a873-d49f228786dc	2026-08-25 14:56	2026-08-25 14:56	2026-08-25 14:56	SNAP	SNAP260904C00006500	call	6.5000	2026-09-04	0.1000	0.0700	0.1000	5.8950	19110.00	19110.00	0.00	1911	41	2748	2178	1.26170798898072	0.764048921562604	0.764048921562604	false	false	false	true	false
306e3e89-4cd2-4128-aea7-eff66e3097e4	2026-08-25 14:59	2026-08-25 14:59	2026-08-25 14:59	SNAP	SNAP261016C00006000	call	6.0000	2026-10-16	0.5000	0.4900	0.5100	5.9288	18400.00	18350.00	0.00	368	17	10274	36396	0.282283767446972	0.580805438887614	0.580805438887614	false	false	false	true	false
ffab91b8-1157-4913-ba57-67d8e29d339d	2026-08-25 15:01	2026-08-25 15:01	2026-08-25 15:01	SNAP	SNAP261016C00007000	call	7.0000	2026-10-16	0.2200	0.2200	0.2300	5.9150	11000.00	0.00	11000.00	500	7	9640	19739	0.488373271189017	0.626633054945417	0.626633054945417	false	false	false	true	false
b96f27e4-10c0-4285-bbc6-2f6ec8a5062b	2026-08-25 15:22	2026-08-25 15:22	2026-08-25 15:22	SNAP	SNAP260828C00006000	call	6.0000	2026-08-28	0.1200	0.1100	0.1200	5.9100	48480.00	48480.00	0.00	4040	39	29334	22716	1.29133650290544	0.74418047728715	0.74418047728715	false	false	false	true	false
daff423f-95cc-4cf9-bf34-13e5826719ea	2026-08-25 15:29	2026-08-25 15:28	2026-08-25 15:28	SNAP	SNAP260904C00006000	call	6.0000	2026-09-04	0.2300	0.2200	0.2300	5.8900	88297.00	88297.00	0.00	3839	18	14594	4793	3.0448570832464	0.711042341987843	0.711042341987843	false	false	false	true	false
a1083718-8d84-4509-81ed-72930b68ed38	2026-08-25 15:29	2026-08-25 15:29	2026-08-25 15:29	SNAP	SNAP260904C00006000	call	6.0000	2026-09-04	0.2400	0.2200	0.2500	5.9000	19750.00	19726.00	0.00	823	22	15575	4793	3.24953056540789	0.699015367446417	0.724755107750983	false	false	false	true	false
f47316b7-31d8-45de-aeaa-868c10e6d1f1	2026-08-25 15:32	2026-08-25 15:32	2026-08-25 15:32	SNAP	SNAP261016C00006000	call	6.0000	2026-10-16	0.4700	0.4600	0.4800	5.8600	16732.00	94.00	16638.00	356	8	12528	36396	0.344213649851632	0.587450799393684	0.587450799393684	false	false	false	true	false
04a35a5f-38ed-487e-9d81-14f7bf11737b	2026-08-25 15:34	2026-08-25 15:34	2026-08-25 15:34	SNAP	SNAP260828C00005500	call	5.5000	2026-08-28	0.3800	0.3800	0.4000	5.8500	15200.00	0.00	15200.00	400	11	10770	13965	0.771213748657358	0.675821893903435	0.675821893903435	false	false	false	true	false
003bed1b-80f4-4053-b97b-92207c9235a3	2026-08-25 15:35	2026-08-25 15:35	2026-08-25 15:35	SNAP	SNAP261016C00006000	call	6.0000	2026-10-16	0.4500	0.4400	0.4600	5.8450	22500.00	0.00	19800.00	500	12	13047	36396	0.358473458621827	0.573403432261403	0.573403432261403	false	false	false	true	false
0097a059-4049-4115-9ab9-28735031da6b	2026-08-25 15:57	2026-08-25 15:57	2026-08-25 15:57	SNAP	SNAP270115C00006000	call	6.0000	2027-01-15	0.9400	0.9300	0.9600	5.9050	18800.00	0.00	18800.00	200	5	1650	32806	0.0502956776199476	0.642548415685313	0.642548415685313	false	false	false	true	false
413bbf5e-97fa-4210-9161-ce34d1f3bdcc	2026-08-25 15:58	2026-08-25 15:58	2026-08-25 15:58	SNAP	SNAP270115C00006000	call	6.0000	2027-01-15	0.9400	0.9400	0.9600	5.9112	23406.00	0.00	23406.00	249	17	1899	32806	0.0578857526062306	0.63853884216452	0.640062910899238	false	false	false	true	false
7bebeae7-67d9-42c5-bb41-cc7a02ecbe70	2026-08-25 15:59	2026-08-25 15:59	2026-08-25 15:59	SNAP	SNAP270115C00006000	call	6.0000	2027-01-15	0.9500	0.9500	0.9800	5.9300	28500.00	0.00	28500.00	300	21	2412	32806	0.0735231360117052	0.639419104706123	0.639419104706123	false	false	false	true	false
5684d719-7afc-4ac6-a4a8-a02e311c6d82	2026-08-26 09:39	2026-08-26 09:39	2026-08-26 09:39	SNAP	SNAP261016C00007000	call	7.0000	2026-10-16	0.1200	0.1200	0.1300	5.5400	11844.00	0.00	11844.00	987	7	1557	22916	0.0679437947285739	0.615494593517309	0.615494593517309	false	false	false	true	false
527f71f3-7003-4545-8e57-159bdf9ec94d	2026-08-26 09:46	2026-08-26 09:46	2026-08-26 09:46	SNAP	SNAP260828P00006000	put	6.0000	2026-08-28	0.4900	0.4800	0.5700	5.4850	16363.00	104.00	3666.00	331	13	3137	2150	1.45906976744186	0.728976509451091	0.728976509451091	false	false	false	true	false
f53a4025-54b3-49b6-8de1-bbb2a87229c8	2026-08-26 09:49	2026-08-26 09:49	2026-08-26 09:49	SNAP	SNAP261016C00006000	call	6.0000	2026-10-16	0.3300	0.3000	0.3300	5.5277	66000.00	66000.00	0.00	2000	22	2720	35073	0.0775525332877142	0.609308655455383	0.609308655455383	true	false	false	true	false
42e84e6b-6323-4168-b7b3-f9a4d5f624ce	2026-08-26 10:08	2026-08-26 10:08	2026-08-26 10:08	SNAP	SNAP260828C00006000	call	6.0000	2026-08-28	0.0300	0.0300	0.0400	5.5400	15000.00	0.00	15000.00	5000	38	9253	31116	0.297371127394267	0.992009220911135	0.992009220911135	false	false	false	true	false
cb6e3511-de86-42af-852d-5026774ba094	2026-08-26 10:09	2026-08-26 10:09	2026-08-26 10:09	SNAP	SNAP260904C00006000	call	6.0000	2026-09-04	0.0600	0.0600	0.0700	5.5200	18240.00	0.00	18240.00	3040	19	5631	12830	0.438893219017927	0.612443025200987	0.612443025200987	false	false	false	true	false
34cb46d3-6be3-46f2-a74e-1c1230bfcb31	2026-08-26 10:13	2026-08-26 10:13	2026-08-26 10:13	SNAP	SNAP260828P00006000	put	6.0000	2026-08-28	0.5500	0.5000	0.5500	5.5000	110000.00	110000.00	0.00	2000	24	5905	2150	2.74651162790698	1.2639454910701	1.2639454910701	true	false	false	true	false
a19e2cb5-7400-4a6c-ba28-bc1c89c5b56d	2026-08-26 10:32	2026-08-26 10:32	2026-08-26 10:32	SNAP	SNAP260828P00006000	put	6.0000	2026-08-28	0.4600	0.4600	0.4900	5.5250	13340.00	0.00	13340.00	290	5	6462	2150	3.00558139534884	0.850298752874616	0.850298752874616	false	false	false	true	false
05aabbb7-fe9f-4c42-9a78-9c78df538d87	2026-08-26 10:32	2026-08-26 10:32	2026-08-26 10:32	SNAP	SNAP260828P00006000	put	6.0000	2026-08-28	0.4600	0.4600	0.5000	5.5250	12144.00	0.00	12144.00	264	5	6172	2150	2.8706976744186	0.974134009647547	0.974134009647547	false	false	false	true	false
65d8f946-c23f-4ed4-ac27-c355ada0fe20	2026-08-26 10:32	2026-08-26 10:32	2026-08-26 10:32	SNAP	SNAP260828P00006000	put	6.0000	2026-08-28	0.4700	0.4600	0.5200	5.5300	10238.00	4128.00	6110.00	216	15	6888	2150	3.20372093023256	0.768726708033322	0.512380874447798	true	false	false	true	false
92468f13-e855-43ef-ab6b-bfc72508e1d5	2026-08-26 10:37	2026-08-26 10:36	2026-08-26 10:36	SNAP	SNAP280121C00007000	call	7.0000	2028-01-21	1.3900	1.3200	1.3900	5.5250	19182.00	19182.00	0.00	138	6	386	28379	0.0136016068219458	0.674663792703021	0.674663792703021	false	false	false	true	false
c5ea9a8c-a2c6-4bb8-b679-0ab8b16dfd74	2026-08-26 11:07	2026-08-26 11:07	2026-08-26 11:07	SNAP	SNAP260925C00005500	call	5.5000	2026-09-25	0.3700	0.3400	0.3700	5.4950	14800.00	14800.00	0.00	400	11	453	814	0.556511056511056	0.580346477847066	0.580346477847066	false	false	false	true	false
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	true	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	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	true	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	true	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	true	false
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	true	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	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	true	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	true	false
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	true	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	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	true	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	true	false
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	true	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	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	true	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	true	false
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	true	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	false
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	true	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	false