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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×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

a881e1ed-13f6-415e-8c38-4f751b997069	2026-09-08 13:21	2026-09-08 13:20	2026-09-08 13:20	ZS	ZS261002C00165000	call	165.0000	2026-10-02	7.8000	7.7000	8.1000	162.7200	16380.00	780.00	13260.00	21	9	68	1	68	0.520216873346488	0.520216873346488	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-09-08T17:42:35.153326Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
9cbcfee8-e9bc-4035-951b-2cae9e71211d	2026-09-08 12:30	2026-09-08 12:30	2026-09-08 12:30	ZS	ZS261218C00165000	call	165.0000	2026-12-18	19.6800	19.3500	19.8000	163.0838	19676.00	13825.00	5851.00	10	5	33	89	0.370786516853933	0.574104688294062	0.580605427824238	false	false	false	true
b3613026-f0a3-45b4-af83-c2fd82c4a6b7	2026-09-08 12:17	2026-09-08 12:17	2026-09-08 12:17	ZS	ZS261016C00170000	call	170.0000	2026-10-16	7.5000	7.5000	7.7500	161.7100	12750.00	0.00	12750.00	17	5	80	243	0.329218106995885	0.511382129557314	0.511382129557314	true	false	false	true
c9db470c-0cf3-404f-8284-e683deb83a52	2026-09-08 12:17	2026-09-08 12:17	2026-09-08 12:17	ZS	ZS261120P00165000	put	165.0000	2026-11-20	15.4000	15.3000	15.6500	161.9000	606765.00	3085.00	603680.00	394	56	397	80	4.9625	0.499357559122279	0.499357559122279	false	false	false	true
258c62d8-abe1-4581-9c4b-0d798f72ec35	2026-09-08 11:58	2026-09-08 11:58	2026-09-08 11:58	ZS	ZS260911C00160000	call	160.0000	2026-09-11	4.1000	4.1000	4.4000	160.8600	24600.00	0.00	24600.00	60	11	352	54	6.51851851851852	0.625254485993267	0.625254485993267	false	false	false	true
af270075-18a3-4f16-b430-8910db6960d4	2026-09-08 11:55	2026-09-08 11:55	2026-09-08 11:55	ZS	ZS260911C00160000	call	160.0000	2026-09-11	4.1000	4.1000	4.4000	160.9600	12300.00	0.00	12300.00	30	13	290	54	5.37037037037037	0.61565740055026	0.61565740055026	false	false	false	true
90b8b0d0-24f0-42f9-b529-08a7238406cb	2026-09-08 11:53	2026-09-08 11:52	2026-09-08 11:52	ZS	ZS261218P00160000	put	160.0000	2026-12-18	17.4500	17.3000	17.7500	161.1000	87250.00	12215.00	75035.00	50	9	61	335	0.182089552238806	0.564519697110955	0.564519697110955	false	false	false	true
0db0760c-7857-4da6-ac2d-f8de6f480ef7	2026-09-08 10:45	2026-09-08 10:45	2026-09-08 10:45	ZS	ZS270917P00130000	put	130.0000	2027-09-17	17.6000	15.6000	19.6000	160.6050	17600.00	0.00	15840.00	10	6	10	19	0.526315789473684	0.577595679585884	0.577595679585884	false	false	false	true
e604ad4a-2f2a-4f9f-9052-5907a0c858be	2026-09-08 10:37	2026-09-08 10:36	2026-09-08 10:36	ZS	ZS260918P00160000	put	160.0000	2026-09-18	5.5500	5.0500	5.6500	159.9250	16650.00	2775.00	13875.00	30	6	122	1273	0.0958366064414768	0.530169473017879	0.530169473017879	true	false	false	true
1758b0c6-49f1-4755-b119-8d398d2b781b	2026-09-08 10:36	2026-09-08 10:36	2026-09-08 10:36	ZS	ZS261016P00165000	put	165.0000	2026-10-16	12.7500	12.5000	12.8500	160.3500	12750.00	2550.00	10200.00	10	5	34	61	0.557377049180328	0.509811312572545	0.509811312572545	true	false	false	true
fe84efc5-7b1f-4b0d-b347-a65583cfb051	2026-09-08 10:26	2026-09-08 10:26	2026-09-08 10:26	ZS	ZS260911P00152500	put	152.5000	2026-09-11	1.0000	1.0000	1.0800	160.2300	20800.00	0.00	20800.00	208	30	314	54	5.81481481481481	0.644193917363987	0.644193917363987	true	false	false	true
5133d60a-c626-4b43-a711-b6cb1d4a71be	2026-09-08 10:21	2026-09-08 10:21	2026-09-08 10:21	ZS	ZS261002P00167500	put	167.5000	2026-10-02	12.8500	12.8500	13.0500	159.6700	15420.00	0.00	15420.00	12	11	12	108	0.111111111111111	0.51756454118016	0.51756454118016	true	false	false	true
b73e6b46-dee6-416f-aa1d-1d279cdca6fa	2026-09-08 10:18	2026-09-08 10:18	2026-09-08 10:18	ZS	ZS261016C00160000	call	160.0000	2026-10-16	10.4500	10.4500	11.0500	159.6299	11495.00	0.00	11495.00	11	8	38	51	0.745098039215686	0.502754422717851	0.502754422717851	true	false	false	true
30d744d0-c8fd-408c-8b07-7b65a1371fea	2026-09-08 10:10	2026-09-08 10:10	2026-09-08 10:10	ZS	ZS260918P00165000	put	165.0000	2026-09-18	8.9500	8.9500	9.3500	159.4790	14320.00	0.00	14320.00	16	5	297	437	0.679633867276888	0.55058003808823	0.55058003808823	false	false	false	true
7becec56-ac5f-4f9a-924f-c4c64a083a7f	2026-09-08 10:07	2026-09-08 10:07	2026-09-08 10:07	ZS	ZS261120P00170000	put	170.0000	2026-11-20	19.3000	19.3000	20.5000	160.6275	94575.00	0.00	94575.00	49	19	52	260	0.2	0.509508345325323	0.509508345325323	true	false	false	true
3e70220b-0e22-43a4-8b64-f444f7285119	2026-09-08 10:07	2026-09-08 10:07	2026-09-08 10:07	ZS	ZS261016P00170000	put	170.0000	2026-10-16	15.9500	15.9000	16.4000	160.3900	30305.00	1595.00	28710.00	19	11	35	185	0.189189189189189	0.515053962241039	0.515053962241039	true	false	false	true
c24ed0ec-c67c-4285-a97e-9ddc49471024	2026-09-08 10:02	2026-09-08 10:02	2026-09-08 10:02	ZS	ZS261016P00155000	put	155.0000	2026-10-16	7.2500	7.2500	7.6500	161.1900	34800.00	0.00	34800.00	48	24	67	280	0.239285714285714	0.507885614389203	0.507885614389203	false	false	false	true
563ed70d-bc57-47f4-9125-fa0d79e330d9	2026-09-08 09:57	2026-09-08 09:57	2026-09-08 09:57	ZS	ZS260918P00160000	put	160.0000	2026-09-18	5.4000	5.2000	5.9000	160.7500	19445.00	545.00	18900.00	36	9	54	1273	0.0424194815396701	0.552562059446685	0.557300058756137	true	false	false	true
38effe57-eb09-48eb-8f06-f4d249766f8e	2026-09-08 09:57	2026-09-08 09:57	2026-09-08 09:57	ZS	ZS260918P00155000	put	155.0000	2026-09-18	3.3000	3.3000	3.7500	160.7500	17160.00	0.00	17160.00	52	20	86	697	0.12338593974175	0.555079355235348	0.555079355235348	false	false	false	true
0b9f096d-e939-43c9-ae6f-5fcbcbc97f99	2026-09-08 09:57	2026-09-08 09:57	2026-09-08 09:57	ZS	ZS260918P00165000	put	165.0000	2026-09-18	8.3500	8.3500	8.7000	160.7500	207923.00	0.00	207923.00	249	43	264	437	0.604118993135011	0.567209689720587	0.567209689720587	false	false	false	true
889c2730-2543-4b9a-b716-a226c5824da7	2026-09-08 09:54	2026-09-08 09:54	2026-09-08 09:54	ZS	ZS261016C00190000	call	190.0000	2026-10-16	2.9500	2.7000	3.0500	160.7300	29543.00	29543.00	0.00	100	6	200	192	1.04166666666667	0.554111543675468	0.546605650728272	false	false	false	true
61bd8f00-a410-4dca-ad00-795c00569e23	2026-09-08 09:45	2026-09-08 09:45	2026-09-08 09:45	ZS	ZS270319C00240000	call	240.0000	2027-03-19	8.2000	8.2000	9.1000	160.9300	42645.00	0.00	42645.00	52	16	54	154	0.350649350649351	0.582021474885891	0.582021474885891	false	false	false	true
8be1c170-bc3a-4c0b-ab7e-cb0c14ef039f	2026-09-08 09:42	2026-09-08 09:42	2026-09-08 09:42	ZS	ZS260918C00170000	call	170.0000	2026-09-18	3.4000	3.0500	3.4000	161.6400	34000.00	34000.00	0.00	100	12	178	540	0.32962962962963	0.613812231155059	0.613812231155059	false	false	false	true
1d19a143-1feb-428e-8eea-cfcbee356ec0	2026-09-08 09:39	2026-09-08 09:39	2026-09-08 09:39	ZS	ZS261009P00145000	put	145.0000	2026-10-09	2.9100	2.5900	3.2500	161.4800	23862.00	23571.00	291.00	82	19	83	12	6.91666666666667	0.503922281608822	0.503922281608822	true	false	false	true
cfd1811e-f6ff-4356-bdaa-4207a15efe9d	2026-09-08 09:32	2026-09-08 09:32	2026-09-08 09:32	ZS	ZS261002C00165000	call	165.0000	2026-10-02	8.0000	7.2500	8.0000	162.7300	10400.00	10400.00	0.00	13	5	23	1	23	0.542871952245124	0.542871952245124	true	false	false	true	false
8a7ff42f-c23d-4eda-9ce5-a5740e010d6f	2026-09-08 09:31	2026-09-08 09:31	2026-09-08 09:31	ZS	ZS260918P00167500	put	167.5000	2026-09-18	8.9500	7.2500	9.3500	162.7900	36675.00	24165.00	12510.00	41	5	41	169	0.242603550295858	0.590112882604475	0.590112882604475	true	false	false	true
85660f5c-cb35-4e92-9879-12be689349e2	2026-09-04 15:59	2026-09-04 15:59	2026-09-04 15:59	ZS	ZS260904P00177500	put	177.5000	2026-09-04	8.7500	8.7500	9.0000	168.7700	14000.00	0.00	14000.00	16	6	453	634	0.714511041009464	26.249779147736	16.6926512067854	false	false	false	true
d590bcdf-e319-4371-aaab-27d79063610f	2026-09-04 15:58	2026-09-04 15:58	2026-09-04 15:58	ZS	ZS260904P00177500	put	177.5000	2026-09-04	8.7500	8.7500	9.1000	168.7700	21875.00	0.00	21875.00	25	7	382	634	0.602523659305994	26.5876168869469	15.566183792859	false	false	false	true
4d4df601-7742-40f2-be70-097a5d3e2f64	2026-09-04 15:32	2026-09-04 15:32	2026-09-04 15:32	ZS	ZS260904P00175000	put	175.0000	2026-09-04	7.0000	6.4500	7.0000	168.1650	35000.00	35000.00	0.00	50	10	811	696	1.16522988505747	3.86976258849529	3.86976258849529	false	false	false	true
0c2a3996-2b6a-40ad-8d1f-2640bdedbf60	2026-09-04 15:31	2026-09-04 15:30	2026-09-04 15:30	ZS	ZS260918C00210000	call	210.0000	2026-09-18	0.3300	0.2600	0.3400	167.9850	11616.00	9603.00	2013.00	352	15	2326	2544	0.914308176100629	0.629204685133282	0.629204685133282	false	false	false	true
0d73e37b-7e33-4338-a841-0b39443a6610	2026-09-04 13:50	2026-09-04 13:50	2026-09-04 13:50	ZS	ZS260911C00167500	call	167.5000	2026-09-11	5.0000	4.8500	5.3500	167.9600	10000.00	0.00	10000.00	20	6	222	82	2.70731707317073	0.507870890014535	0.507870890014535	false	false	false	true
9778b60b-5d3f-4d7a-b81a-5f7c3da0b889	2026-09-04 13:36	2026-09-04 13:36	2026-09-04 13:36	ZS	ZS260911C00167500	call	167.5000	2026-09-11	4.8500	4.7000	5.3500	167.2450	43650.00	2910.00	40740.00	90	10	188	82	2.29268292682927	0.532006330156448	0.532006330156448	false	false	false	true
b407ca91-9041-4403-b5fc-6881ab2dfb97	2026-09-04 12:21	2026-09-04 12:20	2026-09-04 12:20	ZS	ZS260911C00175000	call	175.0000	2026-09-11	3.1500	2.7600	3.2000	170.2300	13545.00	13545.00	0.00	43	20	964	550	1.75272727272727	0.539489504836591	0.539489504836591	true	false	false	true
d9d7f75b-7047-4292-8486-fa94cde04cee	2026-09-04 11:30	2026-09-04 11:30	2026-09-04 11:30	ZS	ZS261120C00260000	call	260.0000	2026-11-20	0.9900	0.8100	1.0000	169.1200	25245.00	20295.00	4950.00	255	43	257	135	1.9037037037037	0.545547988564748	0.545547988564748	false	false	false	true
389bcd7d-0fe1-4d19-9288-0c0b0d8a9b57	2026-09-04 11:05	2026-09-04 11:05	2026-09-04 11:05	ZS	ZS260911C00170000	call	170.0000	2026-09-11	5.1000	4.9500	5.9500	170.6650	17340.00	0.00	10710.00	34	6	200	86	2.32558139534884	0.499234674765177	0.499234674765177	false	false	false	true
0bfabda0-e205-42bf-b369-55804ddc5ee5	2026-09-04 10:14	2026-09-04 10:14	2026-09-04 10:14	ZS	ZS260904C00150000	call	150.0000	2026-09-04	21.0000	19.8500	21.0000	170.8200	14700.00	14700.00	0.00	7	7	16	50	0.32	2.8507866703947	2.8507866703947	false	false	false	true	false
25bce9ff-4312-4867-ab91-6f0b00f28afe	2026-09-04 10:08	2026-09-04 10:08	2026-09-04 10:08	ZS	ZS260918C00177500	call	177.5000	2026-09-18	4.5500	4.2000	4.7000	170.9300	105600.00	15925.00	89675.00	232	35	394	107	3.68224299065421	0.538810322861733	0.535056555657322	true	false	false	true
5e4bb24d-1ad5-475e-8866-d2dfd39afb49	2026-09-04 09:58	2026-09-04 09:58	2026-09-04 09:58	ZS	ZS261120C00190000	call	190.0000	2026-11-20	9.5000	9.0000	10.7000	170.9400	23750.00	19000.00	4750.00	25	5	51	634	0.0804416403785489	0.512556949789797	0.512556949789797	true	false	false	true
38745b64-1493-4259-94b8-8f4dbfeaf9cd	2026-09-04 09:49	2026-09-04 09:49	2026-09-04 09:49	ZS	ZS260911C00180000	call	180.0000	2026-09-11	3.1000	2.8600	3.2500	173.2174	11465.00	6820.00	4645.00	37	5	333	434	0.767281105990783	0.598230317475656	0.598230317475656	true	false	false	true
32f63404-0c26-42fd-bf04-7d0f335cb605	2026-09-04 09:45	2026-09-04 09:45	2026-09-04 09:45	ZS	ZS260904C00175000	call	175.0000	2026-09-04	2.5000	2.2300	2.8000	174.5100	12500.00	0.00	12500.00	50	5	639	697	0.916786226685796	1.4706876606065	1.4706876606065	false	false	false	true
d15d6e59-7a96-4083-aa00-c6771e2c259a	2026-09-04 09:40	2026-09-04 09:40	2026-09-04 09:40	ZS	ZS260904P00172500	put	172.5000	2026-09-04	2.7800	2.4600	2.7800	172.5150	86735.00	86735.00	0.00	312	6	365	293	1.2457337883959	1.50847601079782	1.50847601079782	true	false	false	true
70e7c846-6185-4687-bba8-36ddb1191fdc	2026-09-04 09:37	2026-09-04 09:37	2026-09-04 09:37	ZS	ZS261016C00165000	call	165.0000	2026-10-16	14.9300	14.3500	16.5500	171.3500	22400.00	0.00	22400.00	15	5	18	16	1.125	0.486974472648847	0.486974472648847	false	false	false	true
93a6106b-f000-46ca-b329-d266b508db77	2026-09-04 09:35	2026-09-04 09:35	2026-09-04 09:35	ZS	ZS260904P00170000	put	170.0000	2026-09-04	2.7500	2.7500	3.7000	170.9900	213951.00	276.00	213675.00	778	52	941	590	1.59491525423729	1.58847299258368	1.75120832641353	false	false	false	true
59e82355-2a5a-497c-972f-c2c2999ec0fd	2026-09-04 09:33	2026-09-04 09:33	2026-09-04 09:33	ZS	ZS261016P00170000	put	170.0000	2026-10-16	11.6000	11.2500	13.0500	168.2500	52200.00	0.00	52200.00	45	14	99	161	0.614906832298137	0.486615401130957	0.486615401130957	false	false	false	true
5b6b60ed-77d8-41ed-801a-f470fb324e06	2026-09-04 09:32	2026-09-04 09:32	2026-09-04 09:32	ZS	ZS270917C00250000	call	250.0000	2027-09-17	20.0000	18.4500	23.0000	166.3389	80000.00	0.00	80000.00	40	6	40	55	0.727272727272727	0.601538466831103	0.601538466831103	false	false	false	true
779b3900-d56a-4d14-93cc-deb91ba7597d	2026-09-04 09:31	2026-09-04 09:31	2026-09-04 09:31	ZS	ZS260904P00170000	put	170.0000	2026-09-04	5.6000	5.6000	6.6500	166.7000	16800.00	0.00	16800.00	30	7	64	590	0.108474576271186	2.0385838541178	2.0385838541178	false	false	false	true
a4c17cb7-0346-4a13-88e6-8dfcbf9d4786	2026-09-03 15:57	2026-09-03 15:57	2026-09-03 15:57	ZS	ZS260911C00250000	call	250.0000	2026-09-11	0.9500	0.8500	1.0300	177.7800	11780.00	1900.00	9880.00	124	5	303	34	8.91176470588235	1.40988949249392	1.40988949249392	false	false	false	true
25eb3815-6d09-48b7-b39e-8e87e970911e	2026-09-03 15:57	2026-09-03 15:57	2026-09-03 15:57	ZS	ZS260918P00177500	put	177.5000	2026-09-18	14.3000	14.3000	14.6500	177.8200	22880.00	0.00	22880.00	16	5	246	24	10.25	1.0185819677439	1.0185819677439	false	false	false	true	false
29023ba2-739c-45c8-8b6f-09e071f69614	2026-09-03 15:55	2026-09-03 15:55	2026-09-03 15:55	ZS	ZS260904C00185000	call	185.0000	2026-09-04	10.0000	10.0000	10.5000	177.6900	21000.00	0.00	21000.00	21	10	618	474	1.30379746835443	3.52560033330849	3.52560033330849	false	false	false	true
8741af35-b9cf-4123-996f-74483e24bea0	2026-09-03 15:52	2026-09-03 15:51	2026-09-03 15:51	ZS	ZS260911C00200000	call	200.0000	2026-09-11	6.5000	6.4000	6.7500	177.9250	12350.00	650.00	11700.00	19	6	712	809	0.880098887515451	1.3459255711708	1.3459255711708	false	false	false	true