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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:er_time = unknown×ticker = SHAZ×

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

d8b34d96-acaa-4bf9-9c5f-1e258791fabf	2026-08-24 11:29	2026-08-24 11:29	2026-08-24 11:29	SHAZ	SHAZ260918C00060000	call	60.0000	2026-09-18	5.0000	4.9000	5.0000	57.9400	28500.00	28500.00	0.00	57	5	748	3052	0.245085190039318	0.962684125986357	0.962684125986357	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	Technology	1851482483.00	2026-11-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-24T15:29:12.492303Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
1b13acfe-f91c-41bd-a480-112dd60b4eb8	2026-08-24 10:34	2026-08-24 10:34	2026-08-24 10:34	SHAZ	SHAZ260918P00060000	put	60.0000	2026-09-18	7.6000	7.6000	8.0000	57.2000	334400.00	0.00	334400.00	440	35	454	2228	0.203770197486535	1.01594444551569	1.01594444551569	false	false	false	true
41869a05-7701-4e3f-923b-768c41870cdb	2026-08-24 09:34	2026-08-24 09:34	2026-08-24 09:34	SHAZ	SHAZ260918C00060000	call	60.0000	2026-09-18	4.6000	4.2000	5.0000	56.5700	33120.00	28520.00	0.00	72	6	406	3052	0.13302752293578	1.00652102971005	1.00652102971005	false	false	false	true
d37cb72b-bb3e-4b6d-8f9b-684e24263277	2026-08-24 09:34	2026-08-24 09:34	2026-08-24 09:34	SHAZ	SHAZ260918C00060000	call	60.0000	2026-09-18	4.6000	4.1000	4.6000	56.5000	26680.00	26680.00	0.00	58	6	171	3052	0.0560288335517693	1.0120762484588	1.0120762484588	false	false	false	true
09f1f168-29af-491e-8888-dae2d18e6712	2026-08-24 09:34	2026-08-24 09:34	2026-08-24 09:34	SHAZ	SHAZ260918C00060000	call	60.0000	2026-09-18	4.6000	4.1000	5.5000	56.3500	28060.00	23920.00	4140.00	61	5	113	3052	0.0370249017038008	1.02396402918031	1.02396402918031	false	false	false	true
1bea62a7-66ff-49fb-8f47-c95fd80a2585	2026-08-21 12:21	2026-08-21 12:21	2026-08-21 12:21	SHAZ	SHAZ260918P00055000	put	55.0000	2026-09-18	4.8200	4.4000	4.9000	58.7484	24102.00	24102.00	0.00	50	11	53	2169	0.0244352236053481	1.03448370153217	1.03448370153217	false	false	false	true
41f5e4d5-9dee-4fa0-aece-02646604f791	2026-08-21 10:34	2026-08-21 10:34	2026-08-21 10:34	SHAZ	SHAZ260918P00050000	put	50.0000	2026-09-18	2.4000	2.1000	2.9000	59.0400	24000.00	2640.00	19200.00	100	6	104	335	0.31044776119403	0.984040503985548	0.984040503985548	false	false	false	true
a1305f02-8fc0-450e-a7e8-789418ac1c5d	2026-08-20 14:56	2026-08-20 14:56	2026-08-20 14:56	SHAZ	SHAZ260918P00055000	put	55.0000	2026-09-18	5.3300	4.9000	5.8000	57.9400	26665.00	2660.00	20795.00	50	23	286	2153	0.132837900603809	1.06702943671533	1.07514204431304	false	false	false	true
34df2538-87c2-4b55-bf93-bdb2fba93f90	2026-08-20 13:51	2026-08-20 13:51	2026-08-20 13:51	SHAZ	SHAZ260918P00065000	put	65.0000	2026-09-18	10.9000	10.8000	10.9000	58.7050	45780.00	45780.00	0.00	42	14	238	270	0.881481481481482	1.07867653483425	1.07867653483425	false	false	false	true
18522d0d-102f-42a2-8c32-7f44fe6e0679	2026-08-20 11:54	2026-08-20 11:53	2026-08-20 11:53	SHAZ	SHAZ260821P00060000	put	60.0000	2026-08-21	2.8000	2.2000	2.8000	58.6400	50120.00	50120.00	0.00	179	31	195	763	0.255570117955439	1.65761814021484	1.65761814021484	false	false	false	true
3c454be3-2e1e-4639-bce3-da3c82e4f466	2026-08-20 09:52	2026-08-20 09:52	2026-08-20 09:52	SHAZ	SHAZ260821P00065000	put	65.0000	2026-08-21	4.0000	3.1000	4.4000	62.3800	10390.00	7590.00	2800.00	26	7	33	1031	0.032007759456838	1.86368977151427	1.86368977151427	false	false	false	true
02350a06-9cb6-46a8-aed7-d80e82b9daf4	2026-08-20 09:45	2026-08-20 09:45	2026-08-20 09:45	SHAZ	SHAZ280121C00145000	call	145.0000	2028-01-21	16.6900	14.0000	18.2000	62.9650	15022.00	6822.00	8200.00	9	5	10	164	0.0609756097560976	1.04627371807683	1.02657524676089	false	false	false	true
368092be-5831-4e62-a46b-4e4e8a182a54	2026-08-20 09:41	2026-08-20 09:41	2026-08-20 09:41	SHAZ	SHAZ260821P00070000	put	70.0000	2026-08-21	7.3900	5.7000	8.9000	63.2650	38444.00	27364.00	11080.00	52	6	103	960	0.107291666666667	2.06013519861205	2.06013519861205	false	false	false	true
a5a60738-5e41-437f-909e-b9ab9928f995	2026-08-20 09:36	2026-08-20 09:36	2026-08-20 09:36	SHAZ	SHAZ260821P00070000	put	70.0000	2026-08-21	6.4000	6.4000	7.4000	64.2400	23040.00	0.00	23040.00	36	11	39	960	0.040625	1.82695434897507	1.82695434897507	false	false	false	true	false
f9380310-605c-45c8-b374-2ac79b816845	2026-08-19 10:44	2026-08-19 10:44	2026-08-19 10:44	SHAZ	SHAZ260821C00065000	call	65.0000	2026-08-21	3.7000	3.7000	4.2000	67.0300	45142.00	0.00	45142.00	122	15	123	8603	0.0142973381378589	1.30827301249489	1.30827301249489	false	false	false	true
0103591f-c532-49d7-ad10-02393093dd02	2026-08-19 09:47	2026-08-19 09:46	2026-08-19 09:46	SHAZ	SHAZ260821P00065000	put	65.0000	2026-08-21	2.7500	0.5500	2.9500	66.0000	13751.00	13751.00	0.00	50	5	52	1009	0.0515361744301288	1.46287091688803	1.46287091688803	false	false	false	true
fbcf8e6d-98ae-463b-8c1c-cfb6da83e887	2026-08-18 15:21	2026-08-18 15:21	2026-08-18 15:21	SHAZ	SHAZ261120P00060000	put	60.0000	2026-11-20	10.7000	10.5000	10.7000	66.7000	534978.00	534978.00	0.00	500	36	500	167	2.9940119760479	1.11783682923013	1.11653320817865	false	false	false	true
7a3d22a4-ae5c-455a-a177-139687f4bfce	2026-08-18 13:08	2026-08-18 13:08	2026-08-18 13:08	SHAZ	SHAZ260918C00080000	call	80.0000	2026-09-18	5.0000	5.0000	5.3000	70.9100	50510.00	510.00	50000.00	101	19	329	1586	0.207440100882724	0.999536510539032	0.999536510539032	false	false	false	true
81703b63-5cb1-4dff-af86-009a68adcfbc	2026-08-18 10:37	2026-08-18 10:37	2026-08-18 10:37	SHAZ	SHAZ260918C00100000	call	100.0000	2026-09-18	2.1000	2.1000	2.2000	72.8000	10290.00	0.00	10290.00	49	15	475	33	14.3939393939394	1.05901701983531	1.05901701983531	false	false	false	true
b0cae72d-3c4a-4fd2-ad6e-2441878c305a	2026-08-18 10:37	2026-08-18 10:36	2026-08-18 10:36	SHAZ	SHAZ260918C00100000	call	100.0000	2026-09-18	2.2000	2.2000	2.4500	72.8500	19360.00	0.00	19360.00	88	13	189	33	5.72727272727273	1.07435699969962	1.07435699969962	false	false	false	true
652d0ae0-397d-4f7e-a950-cd78bfe84990	2026-08-18 10:37	2026-08-18 10:37	2026-08-18 10:37	SHAZ	SHAZ260918C00100000	call	100.0000	2026-09-18	2.2000	2.1500	2.4500	72.8500	27280.00	0.00	16500.00	124	14	313	33	9.48484848484848	1.07435699969962	1.07435699969962	false	false	false	true
26bcba4a-5c12-4d67-89e5-4cf646f3a495	2026-08-18 10:10	2026-08-18 10:10	2026-08-18 10:10	SHAZ	SHAZ260821C00070000	call	70.0000	2026-08-21	5.3600	5.0000	6.3000	73.4500	53636.00	0.00	53636.00	100	6	100	1258	0.0794912559618442	1.3394520038247	1.3394520038247	false	false	false	true
73f69be3-b092-476b-be03-5ae6ae070807	2026-08-17 14:42	2026-08-17 14:42	2026-08-17 14:42	SHAZ	SHAZ270115C00100000	call	100.0000	2027-01-15	13.0200	13.0000	13.6000	76.5200	65120.00	14410.00	19510.00	50	6	51	744	0.0685483870967742	1.01408000261638	1.0191813745751	false	false	false	true
c3dd7cfc-0203-482a-a8dd-8940dc2308b0	2026-08-17 13:59	2026-08-17 13:59	2026-08-17 13:59	SHAZ	SHAZ260918C00075000	call	75.0000	2026-09-18	10.4000	10.1000	10.8000	76.0000	99840.00	79040.00	20800.00	96	5	712	1433	0.496859734822052	1.03611453411642	1.03611453411642	false	false	false	true
6ed8f5f5-fc42-4457-8008-b7a59165b913	2026-08-17 13:58	2026-08-17 13:58	2026-08-17 13:58	SHAZ	SHAZ260918C00075000	call	75.0000	2026-09-18	10.6000	9.6000	10.6000	77.0000	128260.00	24380.00	0.00	121	8	616	1433	0.42986741102582	1.04211724005218	1.04211724005218	false	false	false	true
5a8c01cc-fe70-4523-919e-39131abc4952	2026-08-17 13:53	2026-08-17 13:52	2026-08-17 13:52	SHAZ	SHAZ260918C00075000	call	75.0000	2026-09-18	10.4000	9.6000	10.4000	76.0000	156000.00	156000.00	0.00	150	8	495	1433	0.34542916957432	1.05573617746082	1.05573617746082	false	false	false	true
6583bc82-4ca9-475a-833f-09cf76cbc4fb	2026-08-17 13:52	2026-08-17 13:52	2026-08-17 13:52	SHAZ	SHAZ260918C00075000	call	75.0000	2026-09-18	10.4000	9.6000	10.4000	76.0000	206960.00	206960.00	0.00	199	11	345	1433	0.240753663642708	1.05404923723766	1.05404923723766	false	false	false	true
8a5e1e02-cdcd-4502-9d58-d4ab9e0f12a0	2026-08-17 12:45	2026-08-17 12:44	2026-08-17 12:44	SHAZ	SHAZ260918P00055000	put	55.0000	2026-09-18	1.3000	1.3000	1.5000	78.7300	19760.00	0.00	19760.00	152	15	2035	143	14.2307692307692	1.06979565018363	1.06979565018363	false	false	false	true
3f88e2c1-f46b-429a-bbfb-f647dfc4c82e	2026-08-17 12:33	2026-08-17 12:32	2026-08-17 12:32	SHAZ	SHAZ260918P00055000	put	55.0000	2026-09-18	1.4000	1.4000	1.6500	77.6900	63420.00	0.00	63420.00	453	31	947	143	6.62237762237762	1.06877522997698	1.06877522997698	false	false	false	true
77e84ec2-b6ad-4b34-93af-186d5e4f3c59	2026-08-17 11:57	2026-08-17 11:57	2026-08-17 11:57	SHAZ	SHAZ260821C00080000	call	80.0000	2026-08-21	3.4000	3.4000	3.8000	77.6300	22440.00	0.00	7480.00	66	14	694	2306	0.300954032957502	1.36002486741501	1.36002486741501	false	false	false	true
7e8692d6-49cf-4267-be6f-a5ed3749e73d	2026-08-17 11:57	2026-08-17 11:56	2026-08-17 11:56	SHAZ	SHAZ260821C00080000	call	80.0000	2026-08-21	3.4000	3.4000	3.9000	78.0400	12240.00	0.00	12240.00	36	8	614	2306	0.266261925411969	1.30274684592627	1.30274684592627	false	false	false	true