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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = SPXW260930C07700000×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

584ebee7-de7f-48c4-aae1-01fa13cbf4a5	2026-09-30 15:48	2026-09-30 15:48	2026-09-30 15:48	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	0.3700	0.2500	0.4000	7682.8600	10085.00	10085.00	0.00	273	41	130620	10804	12.0899666790078	0.314838038843594	0.324792395829827	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-09-30T19:50:15.606466Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
2cc4d2af-e5ef-48ea-9ff5-51a71ef27da5	2026-09-30 15:37	2026-09-30 15:37	2026-09-30 15:37	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	1.0000	0.9500	1.0500	7690.0300	13400.00	0.00	13200.00	134	84	120565	10804	11.1592928544983	0.208337494348599	0.210763182012773	false	false	false	true
4e738c4c-a97c-4648-ad6b-2fe98437af3a	2026-09-30 15:37	2026-09-30 15:37	2026-09-30 15:37	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	1.0500	1.0000	1.0500	7690.1500	10500.00	10500.00	0.00	100	7	120324	10804	11.1369863013699	0.212479738896229	0.212479738896229	false	false	false	true
6bd6b179-2d0e-4ab6-906d-b9707591c056	2026-09-30 15:35	2026-09-30 15:35	2026-09-30 15:35	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	1.5500	1.5000	1.5500	7692.5700	48205.00	48205.00	0.00	311	28	119037	10804	11.0178637541651	0.205294497509975	0.205294497509975	false	false	false	true
e19190cd-5747-4ad0-a649-89871cde6cd2	2026-09-30 15:35	2026-09-30 15:35	2026-09-30 15:35	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	1.5500	1.5500	1.6000	7692.8000	17220.00	480.00	16740.00	111	25	118570	10804	10.9746390225842	0.201362772305895	0.201362772305895	false	false	false	true
99fd5818-ee7a-44dd-b332-07489f5b97aa	2026-09-30 15:35	2026-09-30 15:35	2026-09-30 15:35	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	1.2800	1.1500	1.3000	7690.5600	19265.00	19265.00	0.00	150	31	117489	10804	10.8745834875972	0.208578147822312	0.215136319120094	false	false	false	true
8dd182b3-772a-4415-a271-b00457662b0e	2026-09-30 15:34	2026-09-30 15:34	2026-09-30 15:34	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	1.2100	1.1500	1.2500	7690.6500	54470.00	54230.00	0.00	450	47	116679	10804	10.7996112550907	0.20437100587913	0.207713258002954	false	false	false	true
2b7ade95-fe04-463a-b051-d3ac404b2d14	2026-09-30 15:33	2026-09-30 15:33	2026-09-30 15:33	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	1.1100	1.1000	1.2000	7690.2400	56670.00	1040.00	53330.00	509	54	115610	10804	10.7006664198445	0.20358109094933	0.206960298072581	false	false	false	true
798b9450-80b2-41c3-bc6d-87ff24d2f490	2026-09-30 15:31	2026-09-30 15:31	2026-09-30 15:31	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	1.4900	1.4500	1.5500	7692.1000	11925.00	600.00	11325.00	80	40	113096	10804	10.4679748241392	0.191922632538606	0.192113443663339	false	false	false	true
1207001b-d7e8-4790-bf9b-bc1d072d821c	2026-09-30 15:28	2026-09-30 15:28	2026-09-30 15:28	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	1.6000	1.6000	1.6500	7692.2500	10560.00	0.00	10560.00	66	38	111280	10804	10.2998889300259	0.186554924472786	0.186554924472786	false	false	false	true
41f54006-f445-44cb-b080-ede3f0d370d8	2026-09-30 15:27	2026-09-30 15:27	2026-09-30 15:27	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	1.9500	1.9000	2.0000	7693.2400	42900.00	23595.00	19305.00	220	33	110368	10804	10.2154757497223	0.188059983494325	0.188059983494325	false	false	false	true
de46bc64-88c0-4040-bec7-c835d0b14c6d	2026-09-30 15:25	2026-09-30 15:25	2026-09-30 15:25	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	2.1600	2.1000	2.2000	7694.1800	23560.00	13295.00	10050.00	109	40	109209	10804	10.1082006664198	0.181651767064705	0.179400840333832	false	false	false	true
bbc7f8dd-c0dc-4ce1-b0a8-12ca672f851e	2026-09-30 15:25	2026-09-30 15:25	2026-09-30 15:25	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	2.1500	2.1000	2.2000	7693.6400	18490.00	16340.00	2150.00	86	8	109013	10804	10.0900592373195	0.1867115952222	0.186575036313513	false	false	false	true
feb9af71-5ea2-4504-abb4-9ef301982f6e	2026-09-30 15:24	2026-09-30 15:24	2026-09-30 15:24	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	1.9500	1.9000	2.0000	7692.7300	34710.00	195.00	34515.00	178	20	108402	10804	10.0335061088486	0.187266141935289	0.187266141935289	false	false	false	true
e4887e3e-601e-4800-8381-d51fb7888b34	2026-09-30 15:24	2026-09-30 15:24	2026-09-30 15:24	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	1.9500	1.9000	1.9500	7692.8100	40510.00	38610.00	1900.00	208	25	108141	10804	10.0093483894854	0.1861852232993	0.1861852232993	false	false	false	true
9856f9a8-adeb-4575-8b95-87a3a020f1fd	2026-09-30 15:24	2026-09-30 15:24	2026-09-30 15:24	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	1.9500	1.9000	1.9500	7692.8100	15210.00	15210.00	0.00	78	5	108219	10804	10.0165679378008	0.1861852232993	0.1861852232993	false	false	false	true
ef2a1638-5d82-4eb3-a64e-b2b5708e8e79	2026-09-30 15:23	2026-09-30 15:23	2026-09-30 15:23	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	1.7000	1.6500	1.7500	7692.4000	35700.00	8160.00	27540.00	210	33	107115	10804	9.91438356164384	0.176614875380642	0.176614875380642	false	false	false	true
b4e6bc57-68a7-4104-bc7e-c8f664452e95	2026-09-30 15:23	2026-09-30 15:23	2026-09-30 15:23	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	1.8000	1.8000	1.8500	7670.0000	22330.00	370.00	21960.00	124	33	106603	10804	9.8669937060348	0.175292872646356	0.175292872646356	false	false	false	true
5f3706d5-b639-4b0d-b446-57e96ec09e04	2026-09-30 15:23	2026-09-30 15:23	2026-09-30 15:23	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	2.0000	1.9000	2.0500	7675.0000	18400.00	200.00	17400.00	92	51	106171	10804	9.82700851536468	0.161600379243681	0.161600379243681	false	false	false	true
031bba28-83b3-4d2f-bd1e-e66190299b63	2026-09-30 15:20	2026-09-30 15:20	2026-09-30 15:20	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	2.3000	2.2500	2.3000	7675.0000	17020.00	17020.00	0.00	74	21	104791	10804	9.69927804516846	0.171702652678418	0.171702652678418	false	false	false	true
5520add6-90fb-498c-bcd2-3093f87c8d47	2026-09-30 15:18	2026-09-30 15:18	2026-09-30 15:18	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	2.4000	2.3500	2.4000	7670.0000	17280.00	17280.00	0.00	72	14	103510	10804	9.58071084783414	0.172919867682909	0.172919867682909	false	false	false	true
94b6a636-001f-4eaf-8745-2560444e10be	2026-09-30 15:17	2026-09-30 15:17	2026-09-30 15:17	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	2.4500	2.4250	2.5000	7675.0000	11515.00	0.00	11515.00	47	10	103071	10804	9.54007774898186	0.172282648621422	0.172282648621422	false	false	false	true
aedb0b2d-608a-4f95-a8cd-0be016d2e49e	2026-09-30 15:16	2026-09-30 15:16	2026-09-30 15:16	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	2.4800	2.4000	2.6000	7675.0000	30550.00	2940.00	27355.00	123	34	102629	10804	9.49916697519437	0.168565685742275	0.164598997436489	false	false	false	true
28310092-e097-453a-bb2c-94fc70c85480	2026-09-30 15:16	2026-09-30 15:16	2026-09-30 15:16	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	2.7500	2.7000	2.8500	7675.0000	52800.00	52525.00	275.00	192	42	102253	10804	9.46436504998149	0.172324862555518	0.172324862555518	false	false	false	true
a600e5ba-2ce9-485d-a0e8-2025ac27f9f0	2026-09-30 15:14	2026-09-30 15:14	2026-09-30 15:14	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.7000	3.6000	3.7000	7696.7600	10730.00	10730.00	0.00	29	13	100796	10804	9.32950758978156	0.180681545401385	0.180681545401385	false	false	false	true
1afbc1d3-537c-4491-b482-3cd7550838c1	2026-09-30 15:14	2026-09-30 15:14	2026-09-30 15:14	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.0000	3.0000	3.1000	7695.5700	15000.00	0.00	15000.00	50	8	100193	10804	9.27369492780452	0.170430646938161	0.170430646938161	false	false	false	true
dc87e1a7-626d-4afb-a28a-64d348b1db38	2026-09-30 15:14	2026-09-30 15:14	2026-09-30 15:14	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	2.9700	2.9000	3.0000	7695.0100	11275.00	11275.00	0.00	38	18	100104	10804	9.26545723805998	0.175876223255681	0.177755985981719	false	false	false	true
4831a0a7-5458-40b4-bffe-5d1ce930b12a	2026-09-30 15:13	2026-09-30 15:13	2026-09-30 15:13	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	2.8900	2.7500	2.9500	7695.0100	11555.00	5850.00	5140.00	40	14	99805	10804	9.2377823028508	0.172925216095153	0.169172864409664	false	false	false	true
a9b7f4c2-b231-4c5c-90e4-bcdc9e671bad	2026-09-30 15:13	2026-09-30 15:13	2026-09-30 15:13	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	2.8500	2.8500	2.9500	7694.7600	14250.00	0.00	14250.00	50	10	99735	10804	9.23130322102925	0.174113193386281	0.174113193386281	false	false	false	true
24e64ea5-58a7-4b64-97b3-23dd029e4a74	2026-09-30 15:12	2026-09-30 15:11	2026-09-30 15:11	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	2.8000	2.7500	2.8500	7695.0200	12035.00	0.00	11755.00	43	11	98912	10804	9.1551277304702	0.166224565509434	0.164374972605869	false	false	false	true
e53e594b-ceae-4122-97db-138980c05bd4	2026-09-30 15:11	2026-09-30 15:11	2026-09-30 15:11	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.2000	3.1000	3.2000	7695.7100	12800.00	12800.00	0.00	40	5	98648	10804	9.13069233617179	0.171499994097347	0.171499994097347	false	false	false	true
6ad4df7d-5b63-461e-b10f-ad00fce586f7	2026-09-30 15:11	2026-09-30 15:11	2026-09-30 15:11	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.1000	3.1000	3.2000	7695.6800	14570.00	0.00	14570.00	47	7	98697	10804	9.13522769344687	0.168323761261294	0.168323761261294	false	false	false	true
06e1c551-051f-4b1e-9b9d-e5ba959b896a	2026-09-30 15:11	2026-09-30 15:11	2026-09-30 15:11	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.1000	3.0000	3.2000	7695.9000	33480.00	0.00	19220.00	108	15	98550	10804	9.12162162162162	0.16435991289461	0.16518497131336	false	false	false	true
2e8dc800-08bf-4eef-8f3d-8307f79526dc	2026-09-30 15:10	2026-09-30 15:10	2026-09-30 15:10	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.0000	3.0000	3.1000	7695.5800	16200.00	0.00	16200.00	54	31	97848	10804	9.05664568678267	0.164150089675381	0.164150089675381	false	false	false	true
be96b1c5-3844-495d-a6d1-12926e97560b	2026-09-30 15:10	2026-09-30 15:10	2026-09-30 15:10	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.4000	3.3000	3.4000	7695.8000	10200.00	10200.00	0.00	30	6	97699	10804	9.04285449833395	0.175265825057413	0.175265825057413	false	false	false	true
13ec0b02-50af-46ce-87cd-7b2662cfdf14	2026-09-30 15:09	2026-09-30 15:09	2026-09-30 15:09	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.5000	3.4000	3.7000	7696.6300	18560.00	0.00	18200.00	53	19	96909	10804	8.9697334320622	0.168583560680645	0.161728345920274	false	false	false	true
3047fdb5-7d6f-4fb3-973e-4acfa2cb49b4	2026-09-30 15:08	2026-09-30 15:08	2026-09-30 15:08	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.8000	3.7000	3.8000	7696.7800	11780.00	11780.00	0.00	31	9	96690	10804	8.94946316179193	0.172961844686927	0.172961844686927	false	false	false	true
1499cedb-0520-4549-a1c4-c78fc0f08424	2026-09-30 15:08	2026-09-30 15:08	2026-09-30 15:08	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.8000	3.7000	3.8000	7696.8900	14440.00	14440.00	0.00	38	14	96343	10804	8.9173454276194	0.17058317379371	0.17058317379371	false	false	false	true
da507564-8b2d-45fb-a3b3-c4638ed86df4	2026-09-30 15:08	2026-09-30 15:08	2026-09-30 15:08	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.5000	3.5000	3.6000	7696.6100	35720.00	720.00	35000.00	102	16	96246	10804	8.90836727138097	0.165836395542508	0.167484092804302	false	false	false	true
6faf66d3-b4b8-473f-9a0c-77b2cff17b6a	2026-09-30 15:06	2026-09-30 15:06	2026-09-30 15:06	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.6000	3.5000	3.7000	7696.3300	20880.00	19800.00	0.00	58	12	95357	10804	8.82608293224732	0.16832049183246	0.16832049183246	false	false	false	true
f7ee7d59-e12d-41bb-a0fd-aad9ec5b8480	2026-09-30 15:05	2026-09-30 15:05	2026-09-30 15:05	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.4000	3.4000	3.5000	7696.6600	11900.00	0.00	11900.00	35	7	94707	10804	8.76592002961866	0.155426858121658	0.155426858121658	false	false	false	true
12220b47-7212-4243-8997-d532f0e54705	2026-09-30 15:04	2026-09-30 15:04	2026-09-30 15:04	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.6000	3.6000	3.7000	7696.7300	10440.00	0.00	10440.00	29	7	94216	10804	8.72047389855609	0.159677311499979	0.159677311499979	false	false	false	true
dcd42c84-f089-4e5a-a6c0-4877b8ab94c8	2026-09-30 15:04	2026-09-30 15:03	2026-09-30 15:03	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.5000	3.4000	3.6000	7696.2700	12250.00	11900.00	0.00	35	10	94088	10804	8.70862643465383	0.16196683307844	0.16196683307844	false	false	false	true
6021e758-b1d2-4ba8-86ff-38054258688c	2026-09-30 15:03	2026-09-30 15:03	2026-09-30 15:03	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.6400	3.6000	3.8000	7697.1500	13110.00	0.00	13110.00	36	14	93771	10804	8.6792854498334	0.155857698007911	0.152646986079101	false	false	false	true
401015db-d894-4add-b067-4c0db52cdfa1	2026-09-30 15:03	2026-09-30 15:03	2026-09-30 15:03	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.9000	3.8000	4.0000	7697.1500	11310.00	0.00	6240.00	29	7	93726	10804	8.67512032580526	0.162221498792485	0.162221498792485	false	false	false	true
1a8683ac-cacd-4d48-8428-6663eec2aaea	2026-09-30 15:02	2026-09-30 15:02	2026-09-30 15:02	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.9000	3.8000	3.9000	7696.5300	21450.00	21450.00	0.00	55	18	93329	10804	8.63837467604591	0.169798712031729	0.169798712031729	false	false	false	true
f419b2f6-00f3-46a2-8bc1-d2ebf91f11ae	2026-09-30 15:02	2026-09-30 15:02	2026-09-30 15:02	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.8000	3.7000	3.8000	7696.4800	11780.00	11780.00	0.00	31	13	93271	10804	8.6330062939652	0.16719668548917	0.16719668548917	false	false	false	true
8db8a1c4-4113-4fb3-a552-2e10e7f102cb	2026-09-30 15:02	2026-09-30 15:02	2026-09-30 15:02	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.5000	3.5000	3.6000	7696.8000	10500.00	0.00	10500.00	30	8	93038	10804	8.61144020733062	0.152950355588863	0.152950355588863	false	false	false	true
b171fe41-dc17-4b3c-a063-9fdfde2606e1	2026-09-30 15:01	2026-09-30 15:01	2026-09-30 15:01	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.7000	3.6000	3.7000	7696.5700	14060.00	14060.00	0.00	38	9	92463	10804	8.55821917808219	0.161618372380267	0.161618372380267	false	false	false	true
318bd5f9-53b0-491b-a3e7-ae235d3194b2	2026-09-30 15:01	2026-09-30 15:01	2026-09-30 15:01	SPXW	SPXW260930C07700000	call	7700.0000	2026-09-30	3.8000	3.7000	3.8000	7696.6600	12540.00	12540.00	0.00	33	15	92513	10804	8.56284709366901	0.163687510788377	0.163687510788377	false	false	false	true