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

0c698a54-1660-4b99-b5aa-052745104b4e	2026-09-30 15:52	2026-09-30 15:51	2026-09-30 15:51	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	4.0000	3.9000	4.0000	7650.0000	10800.00	10800.00	0.00	27	5	8575	4169	2.05684816502758	0.385880850880684	0.385880850880684	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T19:52:25.570899Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
46201356-dc45-4bbd-bd06-3cd89ad78dfc	2026-09-30 15:52	2026-09-30 15:52	2026-09-30 15:52	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	4.3100	4.3000	4.5000	7650.0000	18110.00	0.00	18110.00	42	11	8708	4169	2.08875029983209	0.408345435992479	0.399929227667215	false	false	false	true
17aaf6fa-7dd2-48d6-9075-dc1626722fd8	2026-09-30 15:52	2026-09-30 15:52	2026-09-30 15:52	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	4.3000	4.2000	4.5000	7650.0000	11190.00	0.00	10750.00	26	7	8803	4169	2.11153753897817	0.409238214018101	0.409238214018101	false	false	false	true
f27aaac8-d8e6-4afb-a316-763ea65c44e3	2026-09-30 15:52	2026-09-30 15:52	2026-09-30 15:52	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	4.4100	4.3000	4.6000	7655.0000	32600.00	450.00	31250.00	74	18	8917	4169	2.13888222595347	0.395943985957532	0.38750585528703	true	false	false	true
b6214d22-869f-4e3b-bec8-269c35fda9a7	2026-09-30 15:52	2026-09-30 15:52	2026-09-30 15:52	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	4.4900	4.4000	4.6000	7655.0000	10330.00	9450.00	880.00	23	12	8832	4169	2.11849364355961	0.399208957484976	0.390777354316959	false	false	false	true
a202432c-300b-4382-958d-9251ca2427e6	2026-09-30 15:52	2026-09-30 15:52	2026-09-30 15:52	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	4.3600	4.3000	4.5000	7655.0000	13960.00	2250.00	11270.00	32	22	9126	4169	2.18901415207484	0.390578650406363	0.382125642135772	false	false	false	true
22cec4e5-b30f-4838-8682-49bb10dbee28	2026-09-30 15:52	2026-09-30 15:52	2026-09-30 15:52	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	4.6600	4.5000	4.7000	7655.0000	71270.00	64390.00	900.00	153	32	9077	4169	2.17726073398897	0.393891116939884	0.402336678501382	false	false	false	true
cb0f3df7-c78d-4230-965c-6c91059d3caf	2026-09-30 15:52	2026-09-30 15:52	2026-09-30 15:52	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	4.9100	4.9000	5.0000	7655.0000	14740.00	2000.00	12740.00	30	12	9234	4169	2.2149196449988	0.422483300083725	0.422483300083725	false	false	false	true
0ead08b7-9f84-484c-ba4b-5b499b8c583a	2026-09-30 15:52	2026-09-30 15:52	2026-09-30 15:52	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	5.0200	4.9000	5.2000	7655.0000	19060.00	1040.00	17510.00	38	12	9333	4169	2.23866634684577	0.408850894245531	0.408850894245531	true	false	false	true
4a226f57-b05e-4526-907f-3ba6ddd6ef43	2026-09-30 15:52	2026-09-30 15:52	2026-09-30 15:52	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	5.0500	4.9000	5.2000	7655.0000	64150.00	30110.00	32510.00	127	23	9469	4169	2.27128807867594	0.400316942610046	0.42049411796433	true	false	false	true
d65b312f-200b-45de-96c4-d56b5f633980	2026-09-30 15:52	2026-09-30 15:52	2026-09-30 15:52	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	5.1700	5.0000	5.3000	7655.0000	27910.00	2080.00	22200.00	54	12	9635	4169	2.31110578076277	0.370557927892128	0.370557927892128	false	false	false	true
c20dc3a2-f21e-409f-bfaf-4f7010baf090	2026-09-30 15:52	2026-09-30 15:52	2026-09-30 15:52	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	5.5000	5.4000	5.5000	7655.0000	20900.00	20900.00	0.00	38	18	9724	4169	2.33245382585752	0.419033754845365	0.419033754845365	false	false	false	true
2a2705f0-6894-4bb1-8334-ec264e7c5da7	2026-09-30 15:52	2026-09-30 15:52	2026-09-30 15:52	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	6.0000	5.9000	6.1000	7655.0000	18000.00	0.00	600.00	30	11	9927	4169	2.38114655792756	0.439722383276399	0.439722383276399	false	false	false	true
245ddbfb-63c0-470a-94fd-6e8ae45254f8	2026-09-30 15:52	2026-09-30 15:52	2026-09-30 15:52	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	5.1100	4.7000	6.0000	7655.0000	19930.00	0.00	19930.00	39	26	9997	4169	2.39793715519309	0.389622813089798	0.309014574757941	false	false	false	true
de4ae27a-020f-4d5c-bfef-710ecaee4f3c	2026-09-30 15:52	2026-09-30 15:52	2026-09-30 15:52	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	4.8300	4.7000	5.1000	7655.0000	10630.00	970.00	9660.00	22	12	10049	4169	2.41041017030463	0.409637232890187	0.412989495727613	false	false	false	true
254c92a6-37a5-4160-b29d-748b253c3e12	2026-09-30 15:53	2026-09-30 15:53	2026-09-30 15:53	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	5.1600	5.1000	5.4000	7655.0000	13420.00	0.00	13420.00	26	5	10291	4169	2.46845766370832	0.435319052136002	0.444274467481049	false	false	false	true
6705bda6-d5a4-4be6-bf46-031a8e30bf96	2026-09-30 15:53	2026-09-30 15:53	2026-09-30 15:53	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	6.0800	5.8000	6.1000	7655.0000	60790.00	60790.00	0.00	100	15	10662	4169	2.55744782921564	0.464950773914415	0.464950773914415	false	false	false	true
25b3588b-bf97-452a-8709-88b186c13b1f	2026-09-30 15:53	2026-09-30 15:53	2026-09-30 15:53	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	5.7000	5.7000	5.8000	7655.0000	11970.00	0.00	11970.00	21	5	10786	4169	2.58719117294315	0.422308170929155	0.422308170929155	false	false	false	true
8c278796-67c4-44d3-8c3d-6da175e7bab5	2026-09-30 15:54	2026-09-30 15:54	2026-09-30 15:54	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	2.3400	2.3000	2.4500	7669.0000	10315.00	2925.00	6210.00	44	12	12066	4169	2.89421923722715	0.483856828833632	0.483856828833632	false	false	false	true
d5a65972-c0f4-4592-a4f4-e587e1efc59f	2026-09-30 15:54	2026-09-30 15:54	2026-09-30 15:54	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	2.1900	2.1000	2.2500	7669.4800	10095.00	1985.00	7890.00	46	10	12291	4169	2.94818901415207	0.457824252547198	0.463674811935129	false	false	false	true
6d63838c-26cf-45a9-b484-5bf1ee8112f1	2026-09-30 15:54	2026-09-30 15:54	2026-09-30 15:54	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	1.5800	1.5000	1.6500	7666.6400	13455.00	11105.00	2350.00	85	20	12541	4169	3.00815543295754	0.477750390841363	0.491329368344126	false	false	false	true
1db5f747-6d74-438f-8e35-81537fb6254b	2026-09-30 15:55	2026-09-30 15:55	2026-09-30 15:55	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	0.8000	0.7500	0.8500	7664.9500	11920.00	640.00	6400.00	149	7	15120	4169	3.62676900935476	0.450944701662831	0.450944701662831	false	false	false	true
c03c6bd7-dc01-42c5-a3f9-cff0f93aba30	2026-09-30 15:56	2026-09-30 15:56	2026-09-30 15:56	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	1.2000	1.1500	1.2500	7667.4700	16920.00	16800.00	0.00	141	27	17113	4169	4.10482130007196	0.513630423186923	0.513630423186923	false	false	false	true
ee41eb54-d55b-45d5-b4bb-70a36452b2d4	2026-09-30 15:58	2026-09-30 15:58	2026-09-30 15:58	SPXW	SPXW260930C07675000	call	7675.0000	2026-09-30	0.5500	0.5000	0.6000	7666.4600	11115.00	60.00	10285.00	202	10	18809	4169	4.51163348524826	0.535337230554786	0.550564191239136	false	false	false	true