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:ticker = SPXW×sorted by created_at ↑×

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

43903932-245a-45ec-ba2e-a8c6033470d8	2026-08-28 10:57	2026-08-28 10:57	2026-08-28 10:57	SPXW	SPXW260828C07775000	call	7775.0000	2026-08-28	6.0000	5.9000	6.0000	7766.7600	229190.00	228600.00	590.00	382	56	32147	4403	7.3011583011583	0.126263760713669	0.127689192576111	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-08-28T15:11:58.135920Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
188180c6-7d80-4e87-a5b8-3ea0d9b48ec4	2026-08-28 10:57	2026-08-28 10:57	2026-08-28 10:57	SPXW	SPXW260828C07760000	call	7760.0000	2026-08-28	14.0000	13.9000	14.1000	7766.7600	140010.00	26610.00	36400.00	100	9	31223	2966	10.5269723533378	0.136795505194035	0.138192008933867	false	false	false	true	false
ba7e2ac9-c12d-4eef-94e4-5c0709ace2d4	2026-08-28 10:58	2026-08-28 10:57	2026-08-28 10:57	SPXW	SPXW260828P07765000	put	7765.0000	2026-08-28	9.5000	9.4000	9.6000	7766.9200	106400.00	77900.00	28500.00	112	29	3678	195	18.8615384615385	0.141529825461432	0.141529825461432	false	false	false	true	false
5bb4c70f-47f9-423d-ab85-7ef9b84bab99	2026-08-28 11:00	2026-08-28 11:00	2026-08-28 11:00	SPXW	SPXW260828P07765000	put	7765.0000	2026-08-28	8.8000	8.7000	8.9000	7769.2800	313230.00	0.00	313230.00	356	36	5509	195	28.2512820512821	0.146296492181144	0.1457648781053	false	false	false	true	false
dd7e25ce-e3af-415c-91ba-f7e60310b1f2	2026-08-28 11:00	2026-08-28 11:00	2026-08-28 11:00	SPXW	SPXW260831C07805000	call	7805.0000	2026-08-31	6.8000	6.7000	6.8000	7769.7200	237320.00	237320.00	0.00	349	23	1258	1719	0.731820826061664	0.0669957813229903	0.0668963498258359	false	false	false	true	false
d5249344-36c4-440e-b2ae-3e70349b2fd6	2026-08-28 11:01	2026-08-28 11:01	2026-08-28 11:01	SPXW	SPXW260828P07770000	put	7770.0000	2026-08-28	10.5200	10.3000	10.7000	7770.6000	207330.00	207330.00	0.00	197	54	3508	270	12.9925925925926	0.145801386135032	0.148507537006137	false	false	false	true	false
c77f59bb-f891-4ffa-bd57-9e3c71881f71	2026-08-28 11:01	2026-08-28 11:01	2026-08-28 11:01	SPXW	SPXW260828P07770000	put	7770.0000	2026-08-28	10.7500	10.6000	10.8000	7770.5800	215080.00	215080.00	0.00	200	58	4270	270	15.8148148148148	0.14992615265368	0.151280993614752	true	false	false	true	false
d4905cdb-8a59-4da4-9ecc-69bb89400848	2026-08-28 11:02	2026-08-28 11:02	2026-08-28 11:02	SPXW	SPXW260828P07770000	put	7770.0000	2026-08-28	11.0200	11.0000	11.2000	7769.2100	145490.00	27750.00	117740.00	132	17	4563	270	16.9	0.146143165150476	0.146143165150476	false	false	false	true	false
5506da9b-1a41-4931-be35-ab7482dbd5d2	2026-08-28 11:03	2026-08-28 11:02	2026-08-28 11:02	SPXW	SPXW260828P07765000	put	7765.0000	2026-08-28	9.6000	9.5000	9.6000	7768.3100	350280.00	338880.00	11400.00	365	51	7085	195	36.3333333333333	0.152744619467646	0.151381019281141	false	false	false	true	false
f749862f-32e8-4c29-8be7-f47eb3fa24cd	2026-08-28 11:04	2026-08-28 11:03	2026-08-28 11:03	SPXW	SPXW260828P07740000	put	7740.0000	2026-08-28	3.0500	3.0000	3.2000	7768.0000	152490.00	0.00	149700.00	500	59	26864	1348	19.9287833827893	0.169186166111724	0.167124852687759	false	false	false	true	false
d7369455-f705-41d7-974c-ee576d4599f0	2026-08-28 11:04	2026-08-28 11:04	2026-08-28 11:04	SPXW	SPXW260828P07765000	put	7765.0000	2026-08-28	9.6000	9.5000	9.7000	7767.4500	387840.00	270720.00	117120.00	404	40	8405	195	43.1025641025641	0.147815925778581	0.147815925778581	false	false	false	true	false
7a44b405-1621-48e1-8118-6487c9a0ec07	2026-08-28 11:05	2026-08-28 11:05	2026-08-28 11:05	SPXW	SPXW260828P07765000	put	7765.0000	2026-08-28	9.5000	9.4000	9.5000	7767.9900	106400.00	106400.00	0.00	112	14	8734	195	44.7897435897436	0.149944760636795	0.149944760636795	false	false	false	true	false
d2383270-2ef0-4184-9d26-dc88a4ff02df	2026-08-28 11:05	2026-08-28 11:05	2026-08-28 11:05	SPXW	SPXW260828C07775000	call	7775.0000	2026-08-28	6.5000	6.3000	6.6000	7767.6700	100700.00	100050.00	0.00	155	32	36987	4403	8.40040881217352	0.130161689249488	0.131585106268608	false	false	false	true	false
6ee1f460-d1d6-45f5-a50b-58c950b42e9e	2026-08-28 11:05	2026-08-28 11:05	2026-08-28 11:05	SPXW	SPXW260831C07740000	call	7740.0000	2026-08-31	38.0500	37.9000	38.4000	7767.6700	323420.00	201580.00	121840.00	85	20	2180	1267	1.7205998421468	0.0694153388722116	0.0689834593420356	false	false	false	true	false
7a9db3bd-50ba-469f-ad9b-7c090658194b	2026-08-28 11:05	2026-08-28 11:05	2026-08-28 11:05	SPXW	SPXW260828P07760000	put	7760.0000	2026-08-28	7.5300	7.4000	7.6000	7767.2400	124210.00	124210.00	0.00	165	33	8296	747	11.1057563587684	0.147346236929562	0.148761889431364	false	false	false	true	false
e7eb7c01-604f-4fff-a2cd-8eaa9d3feda6	2026-08-28 11:07	2026-08-28 11:07	2026-08-28 11:07	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	76.8000	76.8000	77.3000	7765.1700	145920.00	0.00	145920.00	19	5	653	22010	0.0296683325761018	0.126313434011145	0.126313434011145	false	false	false	true	false
0f949e26-397e-419d-8db6-bbeb07d667b5	2026-08-28 11:08	2026-08-28 11:08	2026-08-28 11:08	SPXW	SPXW260828P07770000	put	7770.0000	2026-08-28	13.4700	13.4000	13.7000	7763.4500	269330.00	0.00	269330.00	200	35	7129	270	26.4037037037037	0.138270088806605	0.135437811027987	false	false	false	true	false
cd360cb0-cfcb-4d30-a7a9-7652fa48cde6	2026-08-28 11:08	2026-08-28 11:08	2026-08-28 11:08	SPXW	SPXW260828P07770000	put	7770.0000	2026-08-28	13.9500	13.8000	14.1000	7762.6300	278910.00	0.00	262110.00	200	60	7409	270	27.4407407407407	0.1369359607728	0.135506045150831	true	false	false	true	false
16caa12f-4181-475e-8e34-4919c6dcb541	2026-08-28 11:09	2026-08-28 11:09	2026-08-28 11:09	SPXW	SPXW260828P07770000	put	7770.0000	2026-08-28	14.2000	14.0000	14.3000	7762.0100	248450.00	244230.00	2800.00	175	35	7664	270	28.3851851851852	0.131456551499038	0.134346404570836	false	false	false	true	false
dbb76e1f-584e-4b61-8a3b-aef333ec0ea6	2026-08-28 11:09	2026-08-28 11:09	2026-08-28 11:09	SPXW	SPXW260828C07650000	call	7650.0000	2026-08-28	109.4300	106.4000	111.1000	7760.3900	218850.00	120120.00	98730.00	20	5	258	2008	0.128486055776892	0.313001665027717	0.288589690914387	false	false	false	true	false
dae2e056-cb56-4015-bbdd-c1d7e4912a3e	2026-08-28 11:11	2026-08-28 11:11	2026-08-28 11:11	SPXW	SPXW260828P07765000	put	7765.0000	2026-08-28	12.8400	12.8000	13.0000	7759.8100	104040.00	0.00	104040.00	81	22	12166	195	62.3897435897436	0.140380186404204	0.138975267484174	false	false	false	true	false
b612e211-86f9-42e0-b482-afa9497b8500	2026-08-28 11:11	2026-08-28 11:11	2026-08-28 11:11	SPXW	SPXW260828P07745000	put	7745.0000	2026-08-28	5.4500	5.4000	5.6000	7758.1800	109070.00	0.00	109070.00	200	38	16716	412	40.5728155339806	0.150373624757451	0.150373624757451	false	false	false	true	false
358ecdd1-7a17-4aee-8c00-8212bd833f03	2026-08-28 11:12	2026-08-28 11:12	2026-08-28 11:12	SPXW	SPXW260828C07750000	call	7750.0000	2026-08-28	16.0600	15.8000	16.1000	7759.1000	165410.00	111020.00	3200.00	103	19	50029	4562	10.9664620780359	0.147058217270556	0.148530710666928	false	false	false	true	false
965f5a97-db16-4918-9d21-3777938abfc3	2026-08-28 11:13	2026-08-28 11:13	2026-08-28 11:13	SPXW	SPXW260828C07750000	call	7750.0000	2026-08-28	16.2000	16.1000	16.2000	7758.7500	157140.00	157140.00	0.00	97	18	50252	4562	11.0153441473038	0.154922165495922	0.154922165495922	false	false	false	true	false
a09ff8cc-e25a-4f35-8efc-9d59c5b9b316	2026-08-28 11:15	2026-08-28 11:15	2026-08-28 11:15	SPXW	SPXW260831P07760000	put	7760.0000	2026-08-31	18.6000	18.6000	18.7000	7761.8100	120900.00	0.00	120900.00	65	7	800	592	1.35135135135135	0.0735808829908595	0.0735808829908595	false	false	false	true	false
1214b2d8-001a-48d5-ac2e-db5f0c0fe4bc	2026-08-28 11:17	2026-08-28 11:17	2026-08-28 11:17	SPXW	SPXW260831P07760000	put	7760.0000	2026-08-31	18.9000	18.8000	18.9000	7761.5300	122850.00	122850.00	0.00	65	9	911	592	1.53885135135135	0.0741855632366528	0.0741855632366528	false	false	false	true	false
74809447-1a84-4611-85e8-78280d1b5b1e	2026-08-28 11:26	2026-08-28 11:26	2026-08-28 11:26	SPXW	SPXW260828P07755000	put	7755.0000	2026-08-28	3.8600	3.8000	4.0000	7769.0700	115660.00	0.00	115660.00	300	45	16614	452	36.7566371681416	0.132121242141302	0.132121242141302	false	false	false	true	false
60fcb51f-c421-44a1-83bf-96f1258b93f5	2026-08-28 11:28	2026-08-28 11:28	2026-08-28 11:28	SPXW	SPXW260828P07765000	put	7765.0000	2026-08-28	7.6500	7.5000	7.7000	7767.3800	152930.00	152930.00	0.00	200	37	16729	195	85.7897435897436	0.12505491717859	0.12505491717859	false	false	false	true	false
9e296f98-b8de-4cfc-8203-74ee073a3ac5	2026-08-28 11:29	2026-08-28 11:29	2026-08-28 11:29	SPXW	SPXW260831C07770000	call	7770.0000	2026-08-31	17.6000	17.5000	17.8000	7767.0600	186560.00	174240.00	12320.00	106	6	2249	2481	0.906489318823055	0.0635482224738237	0.0635482224738237	false	false	false	true	false
6ce27f12-28f8-4269-b033-6e553a0f55be	2026-08-28 11:35	2026-08-28 11:35	2026-08-28 11:35	SPXW	SPXW260828C07760000	call	7760.0000	2026-08-28	10.0800	9.9000	10.1000	7763.1100	101770.00	96770.00	1000.00	101	24	43050	2966	14.5144976399191	0.11901326206406	0.11901326206406	false	false	false	true	false
908777ae-917a-4448-a23e-22aeacd7fa7d	2026-08-28 11:38	2026-08-28 11:38	2026-08-28 11:38	SPXW	SPXW260828P07750000	put	7750.0000	2026-08-28	5.5000	5.4000	5.6000	7735.0000	124850.00	124300.00	0.00	227	34	30288	2724	11.1189427312775	0.133727343030365	0.134110733554248	false	false	false	true	false
3298638a-b440-4a42-ad00-f6a55d89d038	2026-08-28 11:39	2026-08-28 11:39	2026-08-28 11:39	SPXW	SPXW260904C07700000	call	7700.0000	2026-09-04	79.8000	79.5000	81.7000	7735.0000	199500.00	63840.00	135660.00	25	5	411	2482	0.165592264302981	0.0979610525059582	0.0979610525059582	false	false	false	true	false
f1f7cbca-7bb2-4866-86c2-519a65b3c670	2026-08-28 11:39	2026-08-28 11:39	2026-08-28 11:39	SPXW	SPXW260828P07740000	put	7740.0000	2026-08-28	4.2000	4.1000	4.2000	7735.0000	140270.00	139860.00	410.00	334	9	37035	1348	27.4740356083086	0.147309755027544	0.149074933872799	false	false	false	true	false
92f3eb1d-67bb-4b9f-8056-ae9e5701de37	2026-08-28 11:39	2026-08-28 11:39	2026-08-28 11:39	SPXW	SPXW260828P07760000	put	7760.0000	2026-08-28	12.0000	11.9000	12.0000	7735.0000	248400.00	248400.00	0.00	207	20	24196	747	32.3908969210174	0.1342800241844	0.1342800241844	false	false	false	true	false
0e8c35b8-bfe4-4ed3-938a-5ddce3e83024	2026-08-28 11:40	2026-08-28 11:40	2026-08-28 11:40	SPXW	SPXW260828P07725000	put	7725.0000	2026-08-28	2.5000	2.4500	2.5500	7730.0000	108255.00	108255.00	0.00	433	16	31771	2270	13.9960352422907	0.165892840819897	0.167064734373439	false	false	false	true	false
906f2a40-5e07-4f4b-a377-4baf9572b7db	2026-08-28 11:40	2026-08-28 11:40	2026-08-28 11:40	SPXW	SPXW260828P07740000	put	7740.0000	2026-08-28	5.9000	5.7000	6.0000	7730.0000	152240.00	18900.00	133340.00	258	43	38740	1348	28.7388724035608	0.147328448329227	0.14835396246139	false	false	false	true	false
2d1a0308-4d7b-4dd4-9b6c-c69d6bdb366f	2026-08-28 11:41	2026-08-28 11:41	2026-08-28 11:41	SPXW	SPXW260828P07750000	put	7750.0000	2026-08-28	11.3000	11.2000	11.3000	7725.0000	112990.00	111870.00	1120.00	100	7	33726	2724	12.3810572687225	0.139772569541254	0.141150470876625	false	false	false	true	false
a0e3441e-d871-4d10-80c9-f097f892b5ed	2026-08-28 11:41	2026-08-28 11:41	2026-08-28 11:41	SPXW	SPXW260828P07755000	put	7755.0000	2026-08-28	14.3200	13.9000	15.1000	7725.0000	234800.00	138530.00	96270.00	164	39	23894	452	52.8628318584071	0.132019948575489	0.121854811637073	false	false	false	true	false
75a6c95d-86a6-4bcc-9183-a2bdf6f59474	2026-08-28 11:41	2026-08-28 11:41	2026-08-28 11:41	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	49.4000	49.4000	49.5000	7725.0000	247000.00	0.00	247000.00	50	6	2943	4549	0.64695537480765	0.211374512045789	0.211374512045789	false	false	false	true	false
97722793-0959-4fbb-83c8-dcd9e5b9a30c	2026-08-28 11:41	2026-08-28 11:41	2026-08-28 11:41	SPXW	SPXW260831P07745000	put	7745.0000	2026-08-31	18.0000	18.0000	18.1000	7725.0000	154800.00	0.00	154800.00	86	8	844	134	6.29850746268657	0.0733526007955388	0.0733526007955388	false	false	false	true	false
b045dcce-b51a-4c2a-af46-7034085dfb18	2026-08-28 11:41	2026-08-28 11:41	2026-08-28 11:41	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	51.0000	50.9000	51.0000	7725.0000	255000.00	255000.00	0.00	50	5	2994	4549	0.658166630028578	0.22880610936974	0.22880610936974	false	false	false	true	false
7382fd0b-fab5-416c-82f2-cd7b29a4fb48	2026-08-28 11:45	2026-08-28 11:45	2026-08-28 11:45	SPXW	SPXW260828P07740000	put	7740.0000	2026-08-28	7.4300	7.3000	7.7000	7725.0000	187250.00	32600.00	154650.00	252	50	43270	1348	32.0994065281899	0.146951668398688	0.143378349994951	false	false	false	true	false
e7be6d17-3f0a-45b3-b8e2-4d8fb393c713	2026-08-28 11:47	2026-08-28 11:47	2026-08-28 11:47	SPXW	SPXW260828C07725000	call	7725.0000	2026-08-28	24.6000	24.5000	24.6000	7725.0000	214020.00	214020.00	0.00	87	16	10863	2946	3.68737270875764	0.158299017779214	0.163000743066398	false	false	false	true	false
85ceccc2-18bf-4135-9db4-d0f5c40cf6b3	2026-08-28 11:48	2026-08-28 11:48	2026-08-28 11:48	SPXW	SPXW260828P07740000	put	7740.0000	2026-08-28	8.5000	8.4000	8.7000	7720.0000	117320.00	102010.00	5100.00	138	24	45257	1348	33.5734421364985	0.148544615175286	0.148544615175286	false	false	false	true	false
d3c6d1a5-ad51-4874-bfb0-07ad2713d4f4	2026-08-28 11:48	2026-08-28 11:48	2026-08-28 11:48	SPXW	SPXW260828P07770000	put	7770.0000	2026-08-28	29.8000	29.7000	29.8000	7720.0000	119200.00	119200.00	0.00	40	5	14323	270	53.0481481481482	0.132178923129321	0.132178923129321	false	false	false	true	false
630721a6-bfc1-44d2-b55b-941e6e689cd6	2026-08-28 11:49	2026-08-28 11:49	2026-08-28 11:49	SPXW	SPXW261016C07750000	call	7750.0000	2026-10-16	153.8000	153.1000	153.9000	7720.0000	384500.00	276840.00	107660.00	25	5	103	301	0.3421926910299	0.122592950768303	0.122592950768303	false	false	false	true	false
9b36d33c-27c1-4b49-84fb-baf909a780e7	2026-08-28 11:50	2026-08-28 11:50	2026-08-28 11:50	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	44.1000	44.1000	44.2000	7720.0000	110250.00	0.00	110250.00	25	11	3184	4549	0.699934051439877	0.199057052092225	0.199057052092225	false	false	false	true	false
82050da2-417e-48d5-8ccf-bef73e5bfc83	2026-08-28 11:50	2026-08-28 11:50	2026-08-28 11:50	SPXW	SPXW260828C07745000	call	7745.0000	2026-08-28	8.8000	8.7000	8.9000	7720.0000	132880.00	44880.00	88000.00	151	13	33344	1594	20.9184441656211	0.149612097192628	0.149612097192628	false	false	false	true	false
52302b71-6bd9-4d4f-a2fd-3ce605589942	2026-08-28 11:50	2026-08-28 11:50	2026-08-28 11:50	SPXW	SPXW260828P07740000	put	7740.0000	2026-08-28	9.8000	9.7000	9.8000	7720.0000	313600.00	313600.00	0.00	320	15	48726	1348	36.146884272997	0.15386668968562	0.15386668968562	false	false	false	true	false
a955eee1-a611-4746-be56-b5f354268d3c	2026-08-28 11:50	2026-08-28 11:50	2026-08-28 11:50	SPXW	SPXW260828C07750000	call	7750.0000	2026-08-28	5.7500	5.7000	5.9000	7720.0000	172470.00	0.00	172470.00	300	32	59375	4562	13.0151249451995	0.146834424616983	0.146839385313808	false	false	false	true	false