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

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	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-26T15:22:15.766686Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
654067e3-d10f-499c-9f11-6cae3e75b7ce	2026-08-25 13:52	2026-08-25 13:51	2026-08-25 13:51	SNAP	SNAP280121P00005000	put	5.0000	2028-01-21	1.1100	1.1100	1.1500	5.7400	11135.00	1456.00	9679.00	100	16	869	21325	0.0407502930832356	0.657887650593527	0.657887650593527	false	false	false	true
12636102-37e1-4781-bb01-b9d75107d637	2026-08-25 12:12	2026-08-25 12:12	2026-08-25 12:12	SNAP	SNAP261016C00007000	call	7.0000	2026-10-16	0.1500	0.1400	0.1600	5.6850	28695.00	23460.00	825.00	1913	42	5544	19739	0.280865292061401	0.611363478734672	0.609660140317309	true	false	false
85fd1c0e-0155-4b54-b718-1a55c429ec87	2026-08-25 11:39	2026-08-25 11:39	2026-08-25 11:39	SNAP	SNAP260828C00005500	call	5.5000	2026-08-28	0.2500	0.2300	0.2500	5.6900	10575.00	10575.00	0.00	423	6	8200	13965	0.58718224131758	0.655985163346468	0.655985163346468	false	false	false	true
9f43ff51-0c8f-4ec6-a0be-2ff505dc2bbe	2026-08-25 11:33	2026-08-25 11:33	2026-08-25 11:33	SNAP	SNAP261016C00006000	call	6.0000	2026-10-16	0.3400	0.3400	0.3600	5.6412	16989.00	0.00	16989.00	499	46	7008	36396	0.192548631717771	0.568977218257317	0.557056133148362	false	false	false
19a08b89-05ca-47fa-92b7-0476122b8587	2026-08-25 11:32	2026-08-25 11:31	2026-08-25 11:31	SNAP	SNAP260918C00005000	call	5.0000	2026-09-18	0.7300	0.7300	0.7400	5.6601	10951.00	0.00	10877.00	150	6	1087	15948	0.068159016804615	0.49793574691781	0.527240944445144	false	false	false	true
74baa0c6-0fc4-4883-a1ea-6f7c1777648c	2026-08-25 11:23	2026-08-25 11:23	2026-08-25 11:23	SNAP	SNAP261016C00006000	call	6.0000	2026-10-16	0.3500	0.3300	0.3600	5.6550	77245.00	14000.00	63210.00	2207	94	6209	36396	0.17059566985383	0.554149412685431	0.561756946506678	false	false	false
4f32a605-64df-4ace-b853-e576f7b60e7e	2026-08-25 11:19	2026-08-25 11:19	2026-08-25 11:19	SNAP	SNAP260918P00006000	put	6.0000	2026-09-18	0.5300	0.5100	0.5300	5.6712	17172.00	17172.00	0.00	324	12	1018	3496	0.291189931350114	0.588046836708719	0.589362164892011	false	false	false	true
1eccf250-4f50-47f9-93de-6c2990982513	2026-08-25 11:18	2026-08-25 11:18	2026-08-25 11:18	SNAP	SNAP280121P00005000	put	5.0000	2028-01-21	1.1600	1.1300	1.1600	5.6705	11600.00	11600.00	0.00	100	7	539	21325	0.0252754982415006	0.667767690031535	0.667767690031535	false	false	false	true
a0b9b3c3-d21c-44a6-b98f-20f10ca6375d	2026-08-25 10:55	2026-08-25 10:55	2026-08-25 10:55	SNAP	SNAP280121C00005000	call	5.0000	2028-01-21	2.1100	2.1000	2.1200	5.6250	21114.00	12084.00	9030.00	100	6	368	24286	0.0151527629086717	0.682850657561157	0.673731900460816	false	false	false
9001156f-eec7-4b0d-894d-2bb2bd23f67a	2026-08-25 10:51	2026-08-25 10:51	2026-08-25 10:51	SNAP	SNAP260918C00006000	call	6.0000	2026-09-18	0.2100	0.1900	0.2100	5.6400	40656.00	40656.00	0.00	1936	27	3382	30526	0.110790801284151	0.59991712839802	0.59991712839802	false	false	false	true
a9a1066c-d987-484a-9d24-ed00e7e012a3	2026-08-25 10:46	2026-08-25 10:46	2026-08-25 10:46	SNAP	SNAP260918P00006000	put	6.0000	2026-09-18	0.5400	0.5200	0.5400	5.6650	16632.00	16632.00	0.00	308	8	341	3496	0.0975400457665904	0.600511203528142	0.600511203528142	false	false	false	true
e39acbb0-f350-460e-a6d6-ebd0127db47c	2026-08-25 10:22	2026-08-25 10:21	2026-08-25 10:21	SNAP	SNAP280121C00007000	call	7.0000	2028-01-21	1.4400	1.3700	1.4400	5.6200	28800.00	28800.00	0.00	200	11	253	26688	0.00947991606714628	0.671487026082633	0.671487026082633	false	false	false
ac75fa4b-9b8f-4a03-9dff-bf0275863f7b	2026-08-25 10:06	2026-08-25 10:06	2026-08-25 10:06	SNAP	SNAP270115P00004000	put	4.0000	2027-01-15	0.1600	0.1600	0.2300	5.5750	16000.00	0.00	16000.00	1000	21	1004	17643	0.0569064218103497	0.590797393947615	0.590797393947615	false	false	false	true
e4938221-4b1c-4c40-8682-ca86c75f4971	2026-08-25 09:59	2026-08-25 09:59	2026-08-25 09:59	SNAP	SNAP260918C00005000	call	5.0000	2026-09-18	0.7200	0.6700	0.7600	5.6200	10656.00	8208.00	2448.00	148	6	163	15948	0.0102207173313268	0.563258807961827	0.563258807961827	false	false	false
21efc71e-5510-44d0-9741-5755915a88b2	2026-08-25 09:52	2026-08-25 09:52	2026-08-25 09:52	SNAP	SNAP261016C00006000	call	6.0000	2026-10-16	0.3200	0.3200	0.3300	5.5600	16064.00	0.00	16064.00	502	23	2265	36396	0.062232113419057	0.574532625038868	0.574532625038868	false	false	false
da1b73e2-55a4-4a5b-9a4a-738f30a6434c	2026-08-24 15:59	2026-08-24 15:59	2026-08-24 15:59	SNAP	SNAP270115C00005000	call	5.0000	2027-01-15	1.1800	1.1800	1.2100	5.5400	11800.00	0.00	11800.00	100	12	993	40989	0.0242260118568396	0.642281636016679	0.642281636016679	false	false	false
56232fb1-713d-4859-88b8-e2d936e72026	2026-08-24 15:59	2026-08-24 15:59	2026-08-24 15:59	SNAP	SNAP260828P00006000	put	6.0000	2026-08-28	0.4900	0.4700	0.4900	5.5450	24500.00	24500.00	0.00	500	13	929	49	18.9591836734694	0.748163653276878	0.748163653276878	true	false	false	true
3672e377-f85f-45d1-b325-8df984cf99f6	2026-08-24 15:55	2026-08-24 15:55	2026-08-24 15:55	SNAP	SNAP260828P00006000	put	6.0000	2026-08-28	0.5000	0.4700	0.5200	5.5250	20000.00	19800.00	200.00	400	14	428	49	8.73469387755102	0.69751154378007	0.69751154378007	false	false	false	true
a4c629a1-84b5-4130-bf53-a4836235719c	2026-08-24 15:53	2026-08-24 15:52	2026-08-24 15:52	SNAP	SNAP261016C00007000	call	7.0000	2026-10-16	0.1300	0.1300	0.1400	5.5600	10400.00	0.00	10400.00	800	8	12717	15244	0.83422986092889	0.613918204458882	0.613918204458882	false	false	false	true
6e5cf4b0-3039-47bb-82c0-55046188a200	2026-08-24 15:51	2026-08-24 15:51	2026-08-24 15:51	SNAP	SNAP261016C00007000	call	7.0000	2026-10-16	0.1100	0.0900	0.1100	5.5250	10692.00	10692.00	0.00	972	6	4899	15244	0.321372343217003	0.59059695768767	0.59059695768767	false	false	false	true
d740c0ba-58b1-4aba-ad35-430dabda20fe	2026-08-24 15:46	2026-08-24 15:46	2026-08-24 15:46	SNAP	SNAP260828C00005500	call	5.5000	2026-08-28	0.1300	0.1200	0.1300	5.4850	13000.00	13000.00	0.00	1000	12	16363	8623	1.89759944334918	0.594247933546692	0.594247933546692	false	false	false