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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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 = ZS×

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

5202bdb2-70a1-4f7c-a2a5-95ba0209235a	2026-08-27 10:04	2026-08-27 10:04	2026-08-27 10:04	ZS	ZS261120P00180000	put	180.0000	2026-11-20	16.8500	15.8000	16.8500	189.2400	50545.00	48865.00	1680.00	30	16	30	382	0.0785340314136126	0.623147910892186	0.619811254368994	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Technology	31262477248.00	2026-11-24	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T14:11:49.813441Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
0bbb8714-33f4-4a8a-b249-26981b4e8855	2026-08-27 10:02	2026-08-27 10:02	2026-08-27 10:02	ZS	ZS261120C00240000	call	240.0000	2026-11-20	8.0000	6.9500	8.0000	188.0200	257600.00	257600.00	0.00	322	42	323	44	7.34090909090909	0.628548104899538	0.628548104899538	false	false	false	true
00be3930-1dad-4c64-b573-1ff285cb5c48	2026-08-27 10:01	2026-08-27 10:00	2026-08-27 10:00	ZS	ZS260828C00190000	call	190.0000	2026-08-28	2.7000	2.0000	2.7900	188.3050	14577.00	13770.00	807.00	54	13	389	706	0.550991501416431	0.879543453576168	0.879543453576168	true	false	false	true
bdc739cb-b2ea-4165-9340-9d158d9fceb3	2026-08-27 09:45	2026-08-27 09:45	2026-08-27 09:45	ZS	ZS260828C00185000	call	185.0000	2026-08-28	3.6500	3.6500	5.0000	186.3950	14600.00	0.00	14600.00	40	9	252	383	0.657963446475196	0.744850747746061	0.744850747746061	false	false	false	true
63b23b9e-d396-457b-afb8-3bc8dd222dac	2026-08-27 09:42	2026-08-27 09:42	2026-08-27 09:42	ZS	ZS260828C00185000	call	185.0000	2026-08-28	4.0700	3.8000	5.0000	186.7069	20741.00	0.00	20741.00	51	5	201	383	0.524804177545692	0.735546078041043	0.843934830837695	false	false	false	true
787b9bf4-4a80-4b94-a584-c29b8d9940e6	2026-08-26 15:50	2026-08-26 15:50	2026-08-26 15:50	ZS	ZS260828C00152500	call	152.5000	2026-08-28	17.9600	17.9500	18.0000	169.8000	888950.00	115305.00	127445.00	495	32	495	128	3.8671875	1.14856430302267	1.14856430302267	true	false	false	true
ac75711e-863f-430f-925e-2718055e05a1	2026-08-26 15:08	2026-08-26 15:07	2026-08-26 15:07	ZS	ZS260918C00180000	call	180.0000	2026-09-18	10.0000	9.8500	10.0000	170.3500	15000.00	6000.00	0.00	15	6	55	1427	0.0385423966362999	0.808263689815782	0.808263689815782	false	false	false	true
b4622a46-ad88-4b1c-b844-fafde0c22a39	2026-08-26 15:07	2026-08-26 15:07	2026-08-26 15:07	ZS	ZS260918C00180000	call	180.0000	2026-09-18	10.0000	9.7500	10.3500	170.3850	10000.00	4000.00	2000.00	10	6	40	1427	0.028030833917309	0.807355524713333	0.807355524713333	false	false	false	true
3a8d4124-116a-4b65-80c1-545d743a1cd8	2026-08-26 14:49	2026-08-26 14:49	2026-08-26 14:49	ZS	ZS270219C00165000	call	165.0000	2027-02-19	31.6500	31.5000	32.0000	169.8750	15825.00	12660.00	3165.00	5	5	5	38	0.131578947368421	0.600402901735775	0.600402901735775	false	false	false	true
fcc211b8-fd58-495d-8e99-18d7974fb4d4	2026-08-26 14:38	2026-08-26 14:38	2026-08-26 14:38	ZS	ZS260904C00200000	call	200.0000	2026-09-04	3.0000	2.7900	3.1500	169.2300	36000.00	6000.00	30000.00	120	6	245	742	0.330188679245283	1.12219896113578	1.12219896113578	false	false	false	true
40483720-cb0d-40ae-9919-2de5a8a4567f	2026-08-26 14:37	2026-08-26 14:37	2026-08-26 14:37	ZS	ZS261218C00195000	call	195.0000	2026-12-18	15.5100	14.8500	15.6000	169.1500	62020.00	42065.00	19955.00	40	6	88	327	0.269113149847095	0.640369823489513	0.63362337423862	false	false	false	true
7cecc1af-1c4d-4175-801e-fb9a0f14a480	2026-08-26 14:31	2026-08-26 14:31	2026-08-26 14:31	ZS	ZS261218C00195000	call	195.0000	2026-12-18	15.6300	14.8000	15.6500	169.1500	73465.00	71930.00	1535.00	47	14	48	327	0.146788990825688	0.641026984466688	0.63362337423862	false	false	false	true
28698a66-bd30-40f0-9202-20e48ba9eb1c	2026-08-26 13:33	2026-08-26 13:33	2026-08-26 13:33	ZS	ZS260828C00170000	call	170.0000	2026-08-28	2.2900	2.2900	2.8000	167.4000	34122.00	0.00	34122.00	149	9	255	276	0.923913043478261	0.686736363112203	0.688836134234297	true	false	false	true
50b3566d-7953-43b9-ac72-d8b269000282	2026-08-26 13:11	2026-08-26 13:11	2026-08-26 13:11	ZS	ZS260828P00165000	put	165.0000	2026-08-28	2.1400	2.1400	2.4600	167.6050	16294.00	0.00	16294.00	76	10	482	577	0.835355285961872	0.672759572484733	0.670615971003324	true	false	false	true
b5d5d445-3ab5-4916-a3bf-60e3342e208d	2026-08-26 12:28	2026-08-26 12:28	2026-08-26 12:28	ZS	ZS261218C00165000	call	165.0000	2026-12-18	26.1200	25.2500	26.3500	168.2100	31350.00	18310.00	13040.00	12	6	30	53	0.566037735849057	0.638717732444506	0.640099181592524	false	false	false	true
5970d9aa-8959-49ad-801f-fa35cd2efa97	2026-08-26 11:40	2026-08-26 11:39	2026-08-26 11:39	ZS	ZS260828P00172500	put	172.5000	2026-08-28	6.0000	6.0000	6.4000	168.1200	40800.00	0.00	40800.00	68	8	83	229	0.362445414847162	0.675186775173108	0.675186775173108	false	false	false	true
d639d901-f038-4926-95f0-f23ccffadd0b	2026-08-26 10:17	2026-08-26 10:17	2026-08-26 10:17	ZS	ZS261120C00160000	call	160.0000	2026-11-20	24.2900	24.1000	25.2000	168.1300	94735.00	17010.00	77725.00	39	19	39	194	0.201030927835052	0.607168220161198	0.605537508348326	true	false	false	true
eb3ca87c-1cf5-4aac-bc9a-1a40fb10b5fb	2026-08-26 09:51	2026-08-26 09:51	2026-08-26 09:51	ZS	ZS270115C00195000	call	195.0000	2027-01-15	17.3400	16.6500	17.3500	169.6000	43350.00	41630.00	1720.00	25	5	126	1151	0.109470026064292	0.609350212368703	0.606689756385701	true	false	false	true
87d62077-2ed9-40d1-8f60-5a03de1a3f78	2026-08-26 09:30	2026-08-26 09:30	2026-08-26 09:30	ZS	ZS260828C00157500	call	157.5000	2026-08-28	7.1000	5.1500	7.1000	162.4100	26980.00	26980.00	0.00	38	6	38	16	2.375	0.883333103909509	0.883333103909509	true	false	false	true	false
11b62e01-b2c7-4bb4-8bca-a6670d282c46	2026-08-26 09:30	2026-08-26 09:30	2026-08-26 09:30	ZS	ZS260828C00155000	call	155.0000	2026-08-28	9.0500	6.1500	9.0500	162.4100	24435.00	24435.00	0.00	27	6	27	52	0.519230769230769	0.929481330960576	0.929481330960576	true	false	false	true
366c9cf4-9f5b-4914-b12d-01b6923b5e64	2026-08-25 15:47	2026-08-25 15:47	2026-08-25 15:47	ZS	ZS270115C00200000	call	200.0000	2027-01-15	15.9000	15.1500	16.1000	168.4550	31795.00	17490.00	14305.00	20	9	39	1821	0.0214168039538715	0.615502481960939	0.615502481960939	false	false	false	true
b80a34f8-bdcd-47be-9679-0fab97d50263	2026-08-25 15:12	2026-08-25 15:12	2026-08-25 15:12	ZS	ZS260918C00160000	call	160.0000	2026-09-18	17.8000	17.3000	18.0000	168.0800	133500.00	126380.00	7120.00	75	23	83	835	0.0994011976047904	0.787901499478381	0.784731782843605	false	false	false	true
47284a73-ce27-4e76-98e7-2e6fd8600f0a	2026-08-25 14:37	2026-08-25 14:37	2026-08-25 14:37	ZS	ZS260904P00150000	put	150.0000	2026-09-04	4.4500	3.9000	4.4500	167.1650	10680.00	10680.00	0.00	24	6	100	291	0.343642611683849	1.05435344550362	1.05435344550362	false	false	false	true
b84f692f-560a-4ea2-b7ff-1d8ac6da557b	2026-08-25 13:57	2026-08-25 13:57	2026-08-25 13:57	ZS	ZS260904C00162500	call	162.5000	2026-09-04	14.6000	13.8500	14.6500	168.0300	11680.00	11680.00	0.00	8	5	8	50	0.16	1.05827745634079	1.05827745634079	true	false	false	true	false
78919929-f729-4b38-9940-d55b991652be	2026-08-25 13:57	2026-08-25 13:57	2026-08-25 13:57	ZS	ZS260904P00150000	put	150.0000	2026-09-04	4.3000	4.2000	4.3500	168.0300	11179.00	10749.00	430.00	26	19	73	291	0.25085910652921	1.06047698595433	1.06047698595433	false	false	false	true
57cbb219-77ad-41e6-be30-c741c65634f4	2026-08-25 13:50	2026-08-25 13:50	2026-08-25 13:50	ZS	ZS261120C00170000	call	170.0000	2026-11-20	19.4300	18.8500	19.6000	168.1000	213715.00	200065.00	0.00	110	20	116	1413	0.0820948336871904	0.601276999562794	0.6007644329694	false	false	false	true
05053328-1b85-4202-af13-f376c73693de	2026-08-25 13:42	2026-08-25 13:42	2026-08-25 13:42	ZS	ZS270115P00165000	put	165.0000	2027-01-15	22.1000	21.1500	22.5000	168.4950	28730.00	2210.00	26520.00	13	6	14	281	0.0498220640569395	0.608792055599957	0.608792055599957	false	false	false	true
9d36fffc-125c-44bc-873d-268216f468a4	2026-08-25 13:20	2026-08-25 13:20	2026-08-25 13:20	ZS	ZS261218P00145000	put	145.0000	2026-12-18	11.1000	11.1000	11.2500	170.2600	67710.00	0.00	67710.00	61	12	66	210	0.314285714285714	0.632425627950169	0.632425627950169	false	false	false	true
bdeb088e-b069-4799-bbd3-fbd28d839238	2026-08-25 12:10	2026-08-25 12:10	2026-08-25 12:10	ZS	ZS260918P00182500	put	182.5000	2026-09-18	20.1500	20.1500	20.4500	171.5900	521885.00	0.00	521885.00	259	8	259	0	0	0.793206285970545	0.793206285970545	false	false	false	true	false
433b452d-d132-4303-b30d-5f09f5928e2b	2026-08-25 11:59	2026-08-25 11:58	2026-08-25 11:58	ZS	ZS260918C00200000	call	200.0000	2026-09-18	5.3500	5.3500	5.5000	172.5150	21935.00	0.00	21935.00	41	5	116	2547	0.0455437769925402	0.800423266746995	0.800423266746995	true	false	false	true
b7738379-9422-4550-a101-c2b1ede7f9be	2026-08-25 11:46	2026-08-25 11:46	2026-08-25 11:46	ZS	ZS260911C00175000	call	175.0000	2026-09-11	12.0500	11.5500	12.0500	172.6500	21690.00	21690.00	0.00	18	6	20	99	0.202020202020202	0.873748584681234	0.873748584681234	false	false	false	true
6484de83-3aa4-493c-89bf-e9a82ac18b35	2026-08-25 10:30	2026-08-25 10:30	2026-08-25 10:30	ZS	ZS261120P00170000	put	170.0000	2026-11-20	17.9000	17.4000	18.1000	172.7100	41170.00	41170.00	0.00	23	14	23	154	0.149350649350649	0.605441250326862	0.603077468027033	true	false	false	true
1e0fa38c-06df-4368-a4d9-2bbf470e62a0	2026-08-25 09:58	2026-08-25 09:58	2026-08-25 09:58	ZS	ZS260904P00165000	put	165.0000	2026-09-04	7.9000	7.2000	7.9000	174.4047	79790.00	79790.00	0.00	101	33	104	103	1.00970873786408	1.08109743410459	1.08109743410459	false	false	false	true
4405c23f-4434-4b12-92d5-25dd8721b415	2026-08-25 09:55	2026-08-25 09:55	2026-08-25 09:55	ZS	ZS260828P00177500	put	177.5000	2026-08-28	5.1500	5.1500	6.1500	175.7000	24215.00	520.00	23695.00	47	11	60	203	0.295566502463054	0.660955988685403	0.668894885219364	true	false	false	true
efd99fce-1547-4f3f-8332-60ccaf8dcd32	2026-08-24 15:56	2026-08-24 15:56	2026-08-24 15:56	ZS	ZS261218P00165000	put	165.0000	2026-12-18	18.0500	18.0000	18.5500	176.1500	14440.00	9025.00	5415.00	8	8	15	89	0.168539325842697	0.634574039018001	0.634857478459959	false	false	false	true
0f2f78d3-7a56-4094-92b8-2b2003ede350	2026-08-24 15:12	2026-08-24 15:11	2026-08-24 15:11	ZS	ZS270617C00150000	call	150.0000	2027-06-17	51.7500	51.7500	55.3000	176.3500	517500.00	0.00	517500.00	100	1	103	233	0.44206008583691	0.594848933946673	0.594848933946673	false	true	false	true
d2fda415-456a-488a-bc85-f641a2634e82	2026-08-24 14:55	2026-08-24 14:55	2026-08-24 14:55	ZS	ZS270917C00150000	call	150.0000	2027-09-17	59.4000	58.1500	59.4000	175.9800	65340.00	65340.00	0.00	11	6	43	63	0.682539682539683	0.637764895518103	0.637764895518103	false	false	false	true
97a739c3-f72f-4914-af0b-34483ebc69f1	2026-08-24 13:41	2026-08-24 13:41	2026-08-24 13:41	ZS	ZS261120P00155000	put	155.0000	2026-11-20	10.1000	9.7000	10.1000	176.2100	341362.00	341362.00	0.00	338	62	382	657	0.581430745814307	0.602361427911237	0.602361427911237	false	false	false	true
4a544c54-d338-438e-85c5-e2278aba04a3	2026-08-24 12:21	2026-08-24 12:21	2026-08-24 12:21	ZS	ZS260904P00170000	put	170.0000	2026-09-04	9.1900	8.5000	9.2000	176.7750	14710.00	13795.00	915.00	16	7	44	29	1.51724137931034	1.03253606453141	1.02824523147596	false	false	false	true
a9c86430-1c8b-49ce-9104-cb42185cd12e	2026-08-24 12:11	2026-08-24 12:11	2026-08-24 12:11	ZS	ZS260904C00230000	call	230.0000	2026-09-04	1.1800	1.1800	1.5300	177.1300	13098.00	0.00	13098.00	111	23	114	81	1.40740740740741	1.03232710731382	1.03232710731382	false	false	false	true
43186847-08b7-4147-ab96-aff5f6b85ed1	2026-08-24 11:39	2026-08-24 11:39	2026-08-24 11:39	ZS	ZS260904C00177500	call	177.5000	2026-09-04	12.9000	12.9000	14.0000	177.1850	12900.00	0.00	12900.00	10	5	30	59	0.508474576271186	1.05694074446372	1.05694074446372	false	false	false	true
925da69d-b688-4db9-93c8-74652300f42f	2026-08-24 11:39	2026-08-24 11:38	2026-08-24 11:38	ZS	ZS260904P00177500	put	177.5000	2026-09-04	12.9500	12.9500	13.6500	177.1600	10360.00	0.00	10360.00	8	6	39	21	1.85714285714286	1.05093014162272	1.05093014162272	false	false	false	true
9d239c5a-2efd-4931-99ae-0bd5fae25336	2026-08-24 11:01	2026-08-24 11:01	2026-08-24 11:01	ZS	ZS260918C00185000	call	185.0000	2026-09-18	11.9000	11.6500	11.9000	178.2350	29750.00	29750.00	0.00	25	5	27	1675	0.0161194029850746	0.784604232170155	0.784604232170155	false	false	false	true
7c71beec-1e4a-4408-a147-32ccdb858c9b	2026-08-24 10:54	2026-08-24 10:54	2026-08-24 10:54	ZS	ZS261016C00185000	call	185.0000	2026-10-16	14.7600	14.0500	15.0500	177.6600	23620.00	16225.00	7395.00	16	5	22	8	2.75	0.646767380927417	0.648618998389867	true	false	false	true	false
e23ca7a2-4272-45b8-9f4c-10949a0e7165	2026-08-21 15:59	2026-08-21 15:59	2026-08-21 15:59	ZS	ZS260828C00190000	call	190.0000	2026-08-28	2.2000	2.1500	2.4100	181.7800	44000.00	0.00	44000.00	200	5	509	289	1.76124567474048	0.515198032985539	0.515198032985539	false	false	false	true
fa1e5ddd-6937-46b4-b911-b61004e4a679	2026-08-21 15:56	2026-08-21 15:56	2026-08-21 15:56	ZS	ZS270115C00200000	call	200.0000	2027-01-15	21.9000	20.5000	23.3500	181.6900	10950.00	4380.00	6570.00	5	5	10	1822	0.00548847420417124	0.60607609250301	0.60607609250301	false	false	false	true
9335e6e1-0845-4243-887f-33bded931d87	2026-08-21 15:41	2026-08-21 15:41	2026-08-21 15:41	ZS	ZS260828C00190000	call	190.0000	2026-08-28	2.0500	1.9500	2.0500	181.2500	25792.00	25792.00	0.00	126	7	304	289	1.05190311418685	0.512900280356217	0.514756834520172	false	false	false	true
85dd923d-6693-4e8f-ae33-f692b2a4b843	2026-08-21 14:52	2026-08-21 14:52	2026-08-21 14:52	ZS	ZS261120C00200000	call	200.0000	2026-11-20	14.1800	13.4000	14.2500	179.6800	127575.00	107765.00	19810.00	90	19	141	508	0.27755905511811	0.595298904485838	0.593960665017181	false	false	false	true
0db5f96c-71a2-45f6-811d-d830e97f76ea	2026-08-21 13:09	2026-08-21 13:09	2026-08-21 13:09	ZS	ZS261120C00200000	call	200.0000	2026-11-20	13.7500	13.4500	13.8000	178.8100	15125.00	8250.00	6875.00	11	6	44	508	0.0866141732283465	0.590237018189735	0.590237018189735	true	false	false	true
9fe1fa15-a49d-4554-84bc-1f014d6d61f5	2026-08-21 12:47	2026-08-21 12:47	2026-08-21 12:47	ZS	ZS261120C00175000	call	175.0000	2026-11-20	23.7900	23.2000	23.8000	178.7200	73750.00	71400.00	2350.00	31	13	51	132	0.386363636363636	0.600855610933605	0.600855610933605	true	false	false	true