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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×source = uw_flow_alerts×

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

0dcefd2b-2aad-4bd5-a7c8-cb6c70f345fb	2026-10-02 14:33	2026-10-02 14:33	2026-10-02 14:33	SPXW	SPXW261002C07720000	call	7720.0000	2026-10-02	5.8600	5.7000	5.9000	7720.0200	15820.00	9440.00	5800.00	27	11	87226	2945	29.6183361629881	0.145481147105273	0.148005143093976	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T18:40:40.412272Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
82882cdd-3d50-4e0e-a060-cc0a8f2e7a13	2026-10-02 14:33	2026-10-02 14:32	2026-10-02 14:32	SPXW	SPXW261002C07720000	call	7720.0000	2026-10-02	5.6200	5.6000	5.7000	7719.7600	10110.00	1710.00	8400.00	18	6	87094	2945	29.5735144312394	0.143636697718464	0.143650571442112	false	false	false
fbb2d24d-ad4e-4bb4-92a3-ca9dd1e25476	2026-10-02 14:33	2026-10-02 14:32	2026-10-02 14:32	SPXW	SPXW261002P07735000	put	7735.0000	2026-10-02	16.1700	15.9000	16.2000	7719.5400	19400.00	19400.00	0.00	12	5	36554	711	51.4120956399437	0.127613491374994	0.132730477366328	false	false	false
85896e9e-9f09-4c4b-abcf-1bf6bc1c858b	2026-10-02 14:32	2026-10-02 14:32	2026-10-02 14:32	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.6500	0.6400	0.6500	769.0700	15144.00	15080.00	64.00	233	11	409352	5858	69.8791396381017	0.15226839612908	0.154817211853374	false	false	false
6354b6eb-9117-4a9e-a083-7d824aab0132	2026-10-02 14:32	2026-10-02 14:32	2026-10-02 14:32	MU	MU261002C01075000	call	1075.0000	2026-10-02	3.5000	3.3500	3.5000	1075.3150	23770.00	23770.00	0.00	68	5	10942	2981	3.67058034216706	0.586793848370836	0.603846803063685	false	false	false
73be0e7f-7d82-452c-a662-0432776931c0	2026-10-02 14:32	2026-10-02 14:32	2026-10-02 14:32	SPY	SPY261005P00769000	put	769.0000	2026-10-05	2.2400	2.2200	2.2400	768.9100	13215.00	12992.00	0.00	59	6	58771	1739	33.7958596894767	0.0831568999166596	0.0835166732260462	false	false	false
a5f588ca-3836-46ee-bf04-e3274d5ba268	2026-10-02 14:32	2026-10-02 14:32	2026-10-02 14:32	NVDA	NVDA280616C00285000	call	285.0000	2028-06-16	35.9300	35.8000	36.7000	234.4900	75458.00	0.00	75458.00	21	5	23	464	0.0495689655172414	0.379286486751702	0.380637415360259	false	false	false
6d81f522-80d8-4890-b402-e2ecc9916ab5	2026-10-02 14:32	2026-10-02 14:32	2026-10-02 14:32	ASML	ASML270115C01980000	call	1980.0000	2027-01-15	133.3400	132.3000	135.4000	1862.8900	960040.00	373510.00	586530.00	72	19	74	46	1.60869565217391	0.431584244559523	0.431584244559523	false	false	false
4d4d5a0d-f32c-463c-bac7-eb0bbb7a34f1	2026-10-02 14:31	2026-10-02 14:31	2026-10-02 14:31	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.3000	1.2800	1.3000	768.9800	12576.00	12576.00	0.00	97	7	492130	4172	117.96021093001	0.16619286419755	0.16922072763567	true	false	false
93fbbcb0-9389-4b0a-ae7f-bb64dba688cb	2026-10-02 14:31	2026-10-02 14:31	2026-10-02 14:31	SMTC	SMTC261016C00210000	call	210.0000	2026-10-16	7.0100	6.8000	7.3000	197.1050	15432.00	0.00	15432.00	22	5	3349	4471	0.749049429657795	0.774050151046213	0.774050151046213	false	false	false
fd612b0c-9508-42ec-a8a5-013099acf3f5	2026-10-02 14:30	2026-10-02 14:30	2026-10-02 14:30	SPXW	SPXW261002C07715000	call	7715.0000	2026-10-02	7.9300	7.7000	8.0000	7717.7700	12680.00	11890.00	0.00	16	11	50300	1901	26.4597580220936	0.156836061968935	0.161918021689439	false	false	false
41ed2078-4a7c-4a6a-a99c-ba5a1ef1bcf5	2026-10-02 14:30	2026-10-02 14:30	2026-10-02 14:30	SPXW	SPXW261002C07720000	call	7720.0000	2026-10-02	5.0100	4.9000	5.1000	7717.7700	40060.00	40060.00	0.00	80	26	86112	2945	29.2400679117148	0.150255167840793	0.152788628333173	false	false	false
03480107-17d7-4b4f-a430-5e54cd60cd03	2026-10-02 14:30	2026-10-02 14:30	2026-10-02 14:30	SPY	SPY261002P00770000	put	770.0000	2026-10-02	1.2000	1.2000	1.2200	769.0400	62410.00	0.00	62410.00	520	13	491708	4172	117.859060402685	0.151812725632199	0.154846750149969	false	false	false
439d5916-ff53-43f8-a555-0a24f787460f	2026-10-02 14:30	2026-10-02 14:30	2026-10-02 14:30	ORCL	ORCL261120P00120000	put	120.0000	2026-11-20	2.5700	2.5100	2.6500	141.6200	192827.00	38400.00	154427.00	751	30	1332	14227	0.0936247979194489	0.525738927445841	0.526523210328962	true	false	false
0f8eb21e-87f0-4ffd-b7be-5a88422a1139	2026-10-02 14:30	2026-10-02 14:30	2026-10-02 14:30	QQQ	QQQ261002P00748000	put	748.0000	2026-10-02	0.4500	0.4300	0.4500	748.8200	14082.00	12586.00	0.00	314	27	336470	329	1022.70516717325	0.200874493772699	0.203667241448707	true	false	false
da44467f-9040-4ce6-94ba-c92a296de400	2026-10-02 14:30	2026-10-02 14:30	2026-10-02 14:30	SPY	SPY261002C00768000	call	768.0000	2026-10-02	1.2800	1.2600	1.2800	769.0000	101366.00	101366.00	0.00	792	7	144227	9985	14.4443665498247	0.163469670281834	0.164283660483453	false	false	false
3f351cdb-fcc7-424c-bb16-6cdea2a55b45	2026-10-02 14:30	2026-10-02 14:30	2026-10-02 14:30	SPXW	SPXW261002C07715000	call	7715.0000	2026-10-02	7.6800	7.5000	7.7000	7718.0000	14600.00	13840.00	0.00	19	10	50061	1901	26.3340347185692	0.148894543362205	0.150253328823564	false	false	false
ea249104-f00b-4c8f-af15-906f3812b522	2026-10-02 14:29	2026-10-02 14:29	2026-10-02 14:29	TSLA	TSLA261002C00370000	call	370.0000	2026-10-02	1.7400	1.7200	1.7700	371.3250	14447.00	14272.00	175.00	83	10	153687	13073	11.7560621127515	0.477467629657462	0.48575390715448	true	false	false
7254668c-55ec-4561-8c51-c9dfe70c1001	2026-10-02 14:29	2026-10-02 14:29	2026-10-02 14:29	TSLA	TSLA261002C00370000	call	370.0000	2026-10-02	1.7900	1.7500	1.8000	371.3700	11629.00	11098.00	531.00	65	10	153755	13073	11.7612636732196	0.47205880398806	0.490506306021522	true	false	false
748c7e2e-f439-44c1-b58d-ac9bd12314cd	2026-10-02 14:29	2026-10-02 14:29	2026-10-02 14:29	QQQ	QQQ261002C00747000	call	747.0000	2026-10-02	2.0200	1.9700	2.0100	748.7600	60728.00	60329.00	198.00	301	7	26444	4816	5.49086378737542	0.213794281285678	0.217427629760929	true	false	false
a127a461-b8e4-470e-94ef-3193fec1d93c	2026-10-02 14:29	2026-10-02 14:29	2026-10-02 14:29	MRVL	MRVL261016P00272500	put	272.5000	2026-10-16	13.6600	13.5000	13.8000	272.4499	391962.00	52050.00	339912.00	287	46	473	11	43	0.648541247643131	0.650868625606509	false	false	false
2abae635-8b32-4a50-ba08-a3d0535aece3	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPXW	SPXW261002C07720000	call	7720.0000	2026-10-02	4.9100	4.9000	5.0000	7717.6400	15700.00	1000.00	14700.00	32	7	85071	2945	28.8865874363328	0.147480370110903	0.149974500971165	false	false	false
90f34c2f-c3a0-4afd-b531-0f7036f2703e	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	QQQ	QQQ261002C00748000	call	748.0000	2026-10-02	1.2500	1.2200	1.2700	748.8200	19003.00	18876.00	0.00	152	11	108143	5527	19.5663108377058	0.206850706293913	0.200757239679037	true	false	false
542232ea-e196-439d-b73f-a71f8e478100	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	TSLA	TSLA261002C00372500	call	372.5000	2026-10-02	0.4800	0.4600	0.4900	371.2201	12430.00	12335.00	47.00	259	9	231548	6732	34.3951277480689	0.502649844291902	0.506710658360667	true	false	false
1786a5d5-80c4-4f9f-9a9a-80ff8afc631f	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.6300	0.6100	0.6300	768.9500	39391.00	39391.00	0.00	627	18	403027	5858	68.7994195971321	0.158852853766389	0.161327963510024	true	false	false
64884dc6-507a-45a7-b264-51f310d29b59	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPXW	SPXW261002C07715000	call	7715.0000	2026-10-02	7.0800	6.9000	7.1000	7716.3800	53090.00	52390.00	700.00	75	21	49496	1901	26.0368227248816	0.154081590117778	0.154081590117778	false	false	false
416861f2-edca-4cac-9acc-cd7ed56f3f40	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPXW	SPXW261002C07730000	call	7730.0000	2026-10-02	1.4500	1.4500	1.5000	7716.5000	12495.00	750.00	11745.00	86	19	100537	2310	43.5225108225108	0.144605298608486	0.144605298608486	false	false	false
ca1c6193-2dab-4cad-92f3-3102a769968d	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	2.6400	2.5000	2.6500	7716.5900	42975.00	39620.00	3100.00	163	31	94700	4450	21.2808988764045	0.142425720547874	0.142425720547874	false	false	false
2c2866d9-5d30-4c3e-984d-1709d3b99369	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	NVDA	NVDA261009C00235000	call	235.0000	2026-10-09	3.3600	3.3500	3.4000	234.6650	34252.00	0.00	34252.00	102	5	23500	29942	0.784850711375326	0.264148213014691	0.265690869126942	false	false	false
4437ca0a-e4b9-4e8d-9854-b16118e20e7a	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	QQQ	QQQ261002C00749000	call	749.0000	2026-10-02	0.5800	0.5700	0.5900	748.6020	14126.00	14126.00	0.00	242	8	257335	5176	49.7169629057187	0.189012748349301	0.192607533722846	true	false	false
b4484450-1b63-4b46-8d59-fffeb6158533	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPXW	SPXW261002C07715000	call	7715.0000	2026-10-02	7.1900	7.0000	7.2000	7716.3200	17260.00	15840.00	0.00	24	8	49119	1901	25.8385060494477	0.157031390417781	0.159498119275994	false	false	false
530e0c1f-23cc-4804-a10b-40d1b687005f	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPXW	SPXW261005P07715000	put	7715.0000	2026-10-05	21.3800	21.2000	21.4000	7716.3200	10690.00	8560.00	0.00	5	5	2327	234	9.94444444444444	0.0831325234789987	0.0831325234789987	false	false	false
a296ba6a-af81-4885-b251-007ac7a1dd38	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	USO	USO261002P00147000	put	147.0000	2026-10-02	0.4500	0.4400	0.5000	146.9100	42275.00	42035.00	240.00	939	7	8940	3891	2.2976098689283	0.587273805739257	0.585713661327579	true	false	false
22b32a14-7bed-4a9e-980e-c9602e467863	2026-10-02 14:28	2026-10-02 14:28	2026-10-02 14:28	SPXW	SPXW261002P07715000	put	7715.0000	2026-10-02	5.4100	5.3000	5.5000	7715.8300	12450.00	11370.00	1080.00	23	8	102382	712	143.794943820225	0.143258258362794	0.145732318672324	false	false	false
872c0313-8b52-4311-be4d-88994d7e9924	2026-10-02 14:27	2026-10-02 14:27	2026-10-02 14:27	SPXW	SPXW261002P07715000	put	7715.0000	2026-10-02	7.0300	6.9000	7.1000	7714.0200	14070.00	4970.00	4200.00	20	9	102016	712	143.280898876405	0.160154712688599	0.162612293719004	false	false	false
8ac4f173-7870-4c99-9e30-1c27528b0614	2026-10-02 14:27	2026-10-02 14:27	2026-10-02 14:27	SPXW	SPXW261002P07715000	put	7715.0000	2026-10-02	6.9500	6.8000	7.0000	7714.2600	15980.00	13910.00	2070.00	23	15	101934	712	143.165730337079	0.160687045423619	0.160701436856672	false	false	false
59af318e-9a4e-4f67-9e44-07b84f093585	2026-10-02 14:27	2026-10-02 14:27	2026-10-02 14:27	SPY	SPY261006C00770000	call	770.0000	2026-10-06	2.3100	2.3200	2.3300	768.5200	11562.00	0.00	11562.00	50	5	6889	2074	3.32160077145612	0.0885006683548641	0.0885006683548641	true	false	false
7ae3cc58-6ca3-4df5-8813-4638a0415753	2026-10-02 14:27	2026-10-02 14:27	2026-10-02 14:27	TSLA	TSLA261002C00372500	call	372.5000	2026-10-02	0.4200	0.4000	0.4200	371.0200	18706.00	18706.00	0.00	450	46	230181	6732	34.1920677361854	0.496651160280585	0.502744751945193	false	false	false
c96ee135-60c0-40b9-8bb2-26ab354beab8	2026-10-02 14:27	2026-10-02 14:27	2026-10-02 14:27	QQQ	QQQ261002P00749000	put	749.0000	2026-10-02	1.0900	1.0800	1.1000	748.4200	11342.00	11342.00	0.00	104	7	382684	649	589.651771956857	0.194197369268298	0.196836855451646	true	false	false
6ab2ecdb-fdfa-4703-81b3-8f5900f831a5	2026-10-02 14:27	2026-10-02 14:27	2026-10-02 14:27	SPXW	SPXW261002P07715000	put	7715.0000	2026-10-02	6.0200	5.9000	6.2000	7715.5200	10840.00	8440.00	2400.00	18	11	101862	712	143.064606741573	0.151581298191925	0.1564875323377	false	false	false
18279669-1550-4aad-9f2a-39d56d406dc1	2026-10-02 14:27	2026-10-02 14:27	2026-10-02 14:27	MS	MS270617P00170000	put	170.0000	2027-06-17	9.9500	9.7500	10.0500	190.8800	13926.00	13926.00	0.00	14	5	57	1585	0.0359621451104101	0.34383944245347	0.34383944245347	false	false	false
14d21d26-2c5f-4956-a454-d62b0cae0c07	2026-10-02 14:27	2026-10-02 14:27	2026-10-02 14:27	MTUM	MTUM261016P00315000	put	315.0000	2026-10-16	3.7000	3.5000	3.7000	322.6350	21827.00	21827.00	0.00	59	26	4747	80	59.3375	0.281961001426248	0.281961001426248	false	false	false
0ac814b0-e426-4a9e-a958-a56d5e921fae	2026-10-02 14:26	2026-10-02 14:26	2026-10-02 14:26	SPXW	SPXW261002P07720000	put	7720.0000	2026-10-02	8.3300	8.2000	8.4000	7716.4800	10000.00	5020.00	0.00	12	6	102177	1382	73.9341534008683	0.156608386685693	0.156608386685693	false	false	false
b17b5194-95a5-4162-968c-5b973ca08001	2026-10-02 14:26	2026-10-02 14:26	2026-10-02 14:26	LLY	LLY270617C01640000	call	1640.0000	2027-06-17	31.5100	31.5000	32.5000	1143.2355	185912.00	31550.00	154362.00	59	17	63	42	1.5	0.372203510641243	0.372398314361772	false	false	false
759524da-a074-4604-a26f-af27e2cb6d09	2026-10-02 14:26	2026-10-02 14:26	2026-10-02 14:26	SPXW	SPXW261002C07725000	call	7725.0000	2026-10-02	2.5300	2.4500	2.5500	7716.5600	63195.00	60945.00	0.00	250	29	93580	4450	21.0292134831461	0.139893887184245	0.139893887184245	false	false	false
8eb3c5ae-ac7e-4ce0-8f31-a5c85e90cf30	2026-10-02 14:26	2026-10-02 14:26	2026-10-02 14:26	SPXW	SPXW261002C07710000	call	7710.0000	2026-10-02	10.1000	10.0000	10.1000	7716.6100	21200.00	20200.00	1000.00	21	8	27549	2735	10.072760511883	0.148388586627864	0.151061209240751	false	false	false
00bb6840-5dc2-4153-bdf4-bc59c4cecd10	2026-10-02 14:26	2026-10-02 14:26	2026-10-02 14:26	HD	HD270617C00360000	call	360.0000	2027-06-17	7.1000	7.0500	7.5000	283.1998	43340.00	4290.00	39050.00	61	21	69	2933	0.0235254006137061	0.272970562324076	0.273691259417959	false	false	false
f6d570ff-de57-40e8-91aa-8b03375ed490	2026-10-02 14:26	2026-10-02 14:26	2026-10-02 14:26	JBL	JBL261120P00300000	put	300.0000	2026-11-20	15.8500	15.3000	16.4000	305.6600	171130.00	77910.00	93220.00	108	18	111	57	1.94736842105263	0.43629355104362	0.438592460036911	false	false	false
78cd97b0-19a4-4e93-a6a7-8c1deab0970b	2026-10-02 14:25	2026-10-02 14:25	2026-10-02 14:25	SPY	SPY261002C00769000	call	769.0000	2026-10-02	0.5400	0.5300	0.5500	768.7695	13458.00	768.00	7776.00	249	11	393969	5858	67.2531580744281	0.156479892771545	0.157412142570033	false	false	false
678b4e0c-3594-4222-9f20-817571e7e83e	2026-10-02 14:25	2026-10-02 14:25	2026-10-02 14:25	QQQ	QQQ261023C00750000	call	750.0000	2026-10-23	12.7700	12.7100	12.7600	748.5900	348527.00	348527.00	0.00	273	21	1454	1502	0.968042609853529	0.175798922427975	0.175938592410349	true	false	false