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:source = uw_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	expirydate

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	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-25T19:21:53.483381Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
6831308f-83ff-405e-82a7-249d67ecf772	2026-08-24 15:19	2026-08-24 15:18	2026-08-24 15:18	SNAP	SNAP261002P00005500	put	5.5000	2026-10-02	0.3700	0.3300	0.4100	5.4550	18500.00	0.00	0.00	500	9	502	97	5.17525773195876	0.503524396876069	0.503524396876069	false	false	false	true
8a0a8f10-0793-4ee0-88ef-c04e6d355c92	2026-08-24 14:24	2026-08-24 14:24	2026-08-24 14:24	SNAP	SNAP260918C00006000	call	6.0000	2026-09-18	0.1400	0.1300	0.1400	5.4695	16646.00	16646.00	0.00	1189	35	6782	28449	0.238391507610109	0.563919536892126	0.563919536892126	false	false	false	true
b0ab5dc6-bc87-4679-8457-20b185cf155a	2026-08-24 14:11	2026-08-24 14:11	2026-08-24 14:11	SNAP	SNAP260828C00005500	call	5.5000	2026-08-28	0.1100	0.1100	0.1300	5.4600	16500.00	0.00	16500.00	1500	13	12468	8623	1.44590049866636	0.559363973731275	0.559363973731275	false	false	false	true
c2c69ee7-3ab1-4e7c-a28e-a423b3189fa2	2026-08-24 13:17	2026-08-24 13:17	2026-08-24 13:17	SNAP	SNAP260828P00005500	put	5.5000	2026-08-28	0.1400	0.1300	0.1500	5.4865	73402.00	73318.00	84.00	5243	21	6736	1122	6.00356506238859	0.585703864957766	0.585703864957766	false	false	false	true
f434917a-9a4d-4316-87bf-b4c56162f468	2026-08-24 12:57	2026-08-24 12:57	2026-08-24 12:57	SNAP	SNAP270416C00008000	call	8.0000	2027-04-16	0.5100	0.4900	0.5100	5.4600	27336.00	27336.00	0.00	536	7	1866	36	51.8333333333333	0.662807010016992	0.661742350617324	false	false	false	true
81416e25-a8b1-4b47-8d3b-64f093ecd685	2026-08-24 11:57	2026-08-24 11:57	2026-08-24 11:57	SNAP	SNAP260918P00006000	put	6.0000	2026-09-18	0.6700	0.6400	0.6700	5.4600	12060.00	12060.00	0.00	180	11	248	3669	0.0675933496865631	0.580921185109666	0.580921185109666	false	false	false	true
8b49e291-3aba-4cae-a070-ce25c7872fe6	2026-08-24 11:50	2026-08-24 11:50	2026-08-24 11:50	SNAP	SNAP270416C00008000	call	8.0000	2027-04-16	0.5100	0.4900	0.5100	5.4750	10200.00	10200.00	0.00	200	5	772	36	21.4444444444444	0.658553274782625	0.658553274782625	false	false	false	true
5f29e226-afc1-4ce3-9cae-f974d5e2a7b0	2026-08-24 11:19	2026-08-24 11:19	2026-08-24 11:19	SNAP	SNAP270115C00007000	call	7.0000	2027-01-15	0.4100	0.4000	0.4200	5.4150	21074.00	18655.00	0.00	514	11	728	67620	0.0107660455486542	0.640156371062271	0.640156371062271	false	false	false	true
741f015f-f844-47ec-9b61-5c8e340d2fd0	2026-08-24 11:15	2026-08-24 11:15	2026-08-24 11:15	SNAP	SNAP270115C00006000	call	6.0000	2027-01-15	0.6400	0.6400	0.6600	5.3850	25472.00	0.00	25472.00	398	7	763	32212	0.0236868247857941	0.623911021182095	0.623911021182095	false	false	false	true
b3f95eb3-9fc8-43f4-a9a3-7a1bcc69951c	2026-08-24 10:49	2026-08-24 10:48	2026-08-24 10:48	SNAP	SNAP260904P00005500	put	5.5000	2026-09-04	0.2500	0.2400	0.2500	5.3950	116375.00	116375.00	0.00	4655	29	4683	1098	4.26502732240437	0.514263231972209	0.521917191460065	false	false	false	true
6d9c659c-b445-45db-b5f6-9d92dfebfc91	2026-08-24 10:28	2026-08-24 10:28	2026-08-24 10:28	SNAP	SNAP260918C00005500	call	5.5000	2026-09-18	0.2400	0.2400	0.2600	5.3750	12000.00	0.00	12000.00	500	9	1714	0	0	0.515457607927581	0.515457607927581	false	false	false	true
f07b640f-da5d-4546-b5c1-36d274dfd39a	2026-08-24 10:28	2026-08-24 10:28	2026-08-24 10:28	SNAP	SNAP260918C00005500	call	5.5000	2026-09-18	0.2400	0.2400	0.2500	5.3650	12000.00	0.00	12000.00	500	16	1214	0	0	0.52377757835272	0.52377757835272	false	false	false	true
1b3c0a3f-316e-4248-a3bd-193962c6a6f5	2026-08-24 10:28	2026-08-24 10:28	2026-08-24 10:28	SNAP	SNAP260918C00005500	call	5.5000	2026-09-18	0.2400	0.2400	0.2500	5.3600	12000.00	0.00	12000.00	500	15	714	0	0	0.527919550263039	0.527919550263039	false	false	false	true
b0a00f98-2758-4658-a981-86156d74a573	2026-08-24 10:16	2026-08-24 10:16	2026-08-24 10:16	SNAP	SNAP261016C00007000	call	7.0000	2026-10-16	0.1000	0.0800	0.1000	5.3150	10000.00	10000.00	0.00	1000	33	1197	15244	0.0785226974547363	0.640007554591104	0.640007554591104	false	false	false	true
71b0d308-5249-4b5f-b696-44f33cad6678	2026-08-20 14:33	2026-08-20 14:33	2026-08-20 14:33	SNAP	SNAP280121C00007000	call	7.0000	2028-01-21	1.1700	1.1300	1.1700	5.1350	117000.00	117000.00	0.00	1000	8	1138	25743	0.0442061919745173	0.668275679460323	0.668275679460323	false	false	false	true
6f0ee5a0-d619-4f84-8644-373614b1bd10	2026-08-19 15:49	2026-08-19 15:49	2026-08-19 15:49	SNAP	SNAP280121P00005000	put	5.0000	2028-01-21	1.2600	1.2600	1.2800	5.2400	21294.00	0.00	21294.00	169	5	560	20631	0.0271436188260385	0.654290907247804	0.654290907247804	false	false	false	true
0ede1018-26a3-4cff-9898-5ef68e6f5835	2026-08-19 15:48	2026-08-19 15:48	2026-08-19 15:48	SNAP	SNAP280121P00005000	put	5.0000	2028-01-21	1.2600	1.2600	1.2900	5.2450	37800.00	0.00	37800.00	300	11	361	20631	0.0174979399932141	0.654978919107266	0.654978919107266	false	false	false	true
60d65617-b04c-47d6-a78e-02c711d665c2	2026-08-19 15:07	2026-08-19 15:07	2026-08-19 15:07	SNAP	SNAP260821C00005000	call	5.0000	2026-08-21	0.3000	0.2800	0.3100	5.2705	30000.00	12840.00	2160.00	1000	6	2407	14807	0.162558249476599	0.775732933485915	0.775732933485915	true	false	false	true
2bb1d537-1ed1-4d2d-a0dc-64dd4b4ce63d	2026-08-19 14:24	2026-08-19 14:24	2026-08-19 14:24	SNAP	SNAP270115C00006000	call	6.0000	2027-01-15	0.6000	0.5800	0.6000	5.2250	11160.00	11160.00	0.00	186	10	616	27512	0.0223902297179413	0.63909365524684	0.63909365524684	false	false	false	true
9dcd19af-81cb-46a3-9c8a-692574621c5b	2026-08-19 14:02	2026-08-19 14:02	2026-08-19 14:02	SNAP	SNAP261016C00006000	call	6.0000	2026-10-16	0.2300	0.2100	0.2300	5.2650	23000.00	23000.00	0.00	1000	5	2748	32542	0.0844447175957224	0.566645692549179	0.566645692549179	false	false	false	true
75b60f60-656e-414f-8dc3-4303635119ca	2026-08-19 13:50	2026-08-19 13:50	2026-08-19 13:50	SNAP	SNAP280121C00010000	call	10.0000	2028-01-21	0.7400	0.7000	0.7400	5.2400	14800.00	14800.00	0.00	200	5	562	57101	0.00984220941839898	0.676597276546285	0.676597276546285	false	false	false	true
50f8c13e-1387-41a6-96eb-f3f530e82c82	2026-08-19 13:31	2026-08-19 13:31	2026-08-19 13:31	SNAP	SNAP260918C00006000	call	6.0000	2026-09-18	0.1000	0.0900	0.1000	5.2550	10690.00	10690.00	0.00	1069	5	2594	27030	0.0959674435812061	0.545207864748042	0.545207864748042	false	false	false	true