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

5375a361-e764-4b44-ba57-c9f8926e448c	2026-08-28 11:51	2026-08-28 11:50	2026-08-28 11:50	SPXW	SPXW261030P07760000	put	7760.0000	2026-10-30	155.9900	155.3000	156.2000	7720.0000	5600200.00	1887400.00	3712800.00	359	22	360	19	18.9473684210526	0.133466822032794	0.133578638885881	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-08-28T15:52:06.240394Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
85ad15eb-99da-40f4-98eb-c8472aed6922	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	SPXW	SPXW261030P07760000	put	7760.0000	2026-10-30	156.2000	155.5000	156.4000	7715.0000	3030280.00	1515140.00	1187120.00	194	10	634	19	33.3684210526316	0.133453850524921	0.133453850524921	false	false	false	true	false
4f55c219-c6b0-4db4-a952-cbf353a9db43	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	SPXW	SPXW261030P07760000	put	7760.0000	2026-10-30	156.2000	155.8000	156.4000	7715.0000	2155560.00	187440.00	1968120.00	138	10	940	19	49.4736842105263	0.133464683935492	0.133598247406523	false	false	false	true	false
4d8d7620-195c-4c61-b50f-25f0062017ed	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	SPXW	SPXW261030P07760000	put	7760.0000	2026-10-30	156.2000	155.8000	156.4000	7715.0000	2624160.00	905960.00	1390180.00	168	11	802	19	42.2105263157895	0.133464683935492	0.133464683935492	false	false	false	true	false
f79b3045-bb40-4978-952d-40ea6860383f	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	3.3000	3.2000	3.4000	7720.0000	142560.00	36300.00	106260.00	432	21	29097	1492	19.5020107238606	0.177193143727757	0.177193143727757	false	false	false	true	false
2defb202-738b-440e-a04a-50a3226e2355	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	SPXW	SPXW260831C07750000	call	7750.0000	2026-08-31	16.2900	16.0000	16.4000	7720.0000	156410.00	92840.00	63570.00	96	14	3550	3681	0.964411844607444	0.0698842891696629	0.0702451321595723	false	false	false	true	false
52c5c4b3-5863-4f67-a265-7aeb97d6eccc	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	3.3900	3.2000	3.4000	7720.0000	106890.00	99960.00	1980.00	315	31	29533	1492	19.794235924933	0.179322777461906	0.179322777461906	false	false	false	true	false
3354b729-1276-46b1-b2fc-ac7c5d7c3cc5	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	3.5000	3.4000	3.6000	7715.0000	213150.00	0.00	175350.00	609	37	30498	1492	20.441018766756	0.179084257454919	0.177880512434144	false	false	false	true	false
e467863e-e76a-4a52-8098-dd2458bad361	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	SPXW	SPXW260831C07740000	call	7740.0000	2026-08-31	20.4000	20.4000	20.5000	7715.0000	163200.00	0.00	163200.00	80	5	2596	1267	2.04893449092344	0.0713747694967341	0.0713747694967341	false	false	false	true	false
7d8a0e13-b91f-45b0-bd5e-44b51f33b929	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	SPXW	SPXW260828P07740000	put	7740.0000	2026-08-28	11.7100	11.5000	11.8000	7715.0000	106590.00	106590.00	0.00	91	23	50092	1348	37.160237388724	0.153805741460853	0.155303800277749	false	false	false	true	false
2b83ca35-7fcc-4e67-8928-7bc61ade8a1b	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	SPXW	SPXW261030P07760000	put	7760.0000	2026-10-30	157.4000	156.8000	157.9000	7715.0000	4281360.00	2803510.00	1477850.00	272	14	1266	19	66.6315789473684	0.133763502025232	0.134076812943469	false	false	false	true	false
cbce5bfb-f50c-4af1-b03c-085aedb7f16f	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	SPXW	SPXW261030P07760000	put	7760.0000	2026-10-30	157.6000	157.2000	157.8000	7715.0000	1654800.00	330960.00	330960.00	105	5	1749	19	92.0526315789474	0.134076812943469	0.134029737143329	false	false	false	true	false
9c90aa34-a5a4-4257-a2b2-7ab90845dab5	2026-08-28 11:51	2026-08-28 11:51	2026-08-28 11:51	SPXW	SPXW261030P07760000	put	7760.0000	2026-10-30	157.6000	157.2000	157.8000	7715.0000	4633440.00	1985760.00	2647680.00	294	19	1644	19	86.5263157894737	0.134076812943469	0.134076812943469	false	false	false	true	false
f0436272-4453-46cf-86ec-ca84a04065fd	2026-08-28 11:52	2026-08-28 11:51	2026-08-28 11:51	SPXW	SPXW260904C07740000	call	7740.0000	2026-09-04	42.4000	42.3000	42.6000	7715.0000	474880.00	470640.00	4240.00	112	5	486	613	0.792822185970636	0.097234549940849	0.097234549940849	false	false	false	true	false
cbc313a0-5b79-475a-b0a3-c9316648cc76	2026-08-28 11:52	2026-08-28 11:51	2026-08-28 11:51	SPXW	SPXW260828C07735000	call	7735.0000	2026-08-28	11.3000	11.2000	11.5000	7715.0000	180800.00	73450.00	107350.00	160	18	22205	1110	20.0045045045045	0.1603847644083	0.1603847644083	false	false	false	true	false
4c75b973-93d7-4b26-9283-24ecc403ad46	2026-08-28 11:52	2026-08-28 11:51	2026-08-28 11:51	SPXW	SPXW260831C07755000	call	7755.0000	2026-08-31	12.3000	12.2000	12.5000	7715.0000	123000.00	92250.00	30750.00	100	11	1310	722	1.81440443213296	0.069611498343827	0.069611498343827	false	false	false	true	false
4161b9f9-4e89-4ffb-ad4f-6999b4fe1b69	2026-08-28 11:52	2026-08-28 11:52	2026-08-28 11:52	SPXW	SPXW260831C07770000	call	7770.0000	2026-08-31	7.0000	6.9000	7.1000	7715.0000	140700.00	114800.00	10500.00	201	11	3075	2481	1.23941958887545	0.0665698340188098	0.0665698340188098	false	false	false	true	false
54efa616-d8ce-48a4-ab8a-d1fc12e1a79a	2026-08-28 11:52	2026-08-28 11:52	2026-08-28 11:52	SPXW	SPXW260828P07740000	put	7740.0000	2026-08-28	13.1000	13.0000	13.1000	7715.0000	119210.00	119210.00	0.00	91	23	50666	1348	37.5860534124629	0.15566759039612	0.15566759039612	false	false	false	true	false
a461c122-50c8-414b-aa91-5bb5dce822c0	2026-08-28 11:52	2026-08-28 11:52	2026-08-28 11:52	SPXW	SPXW260831P07675000	put	7675.0000	2026-08-31	5.9000	5.7000	6.0000	7710.0000	147500.00	50740.00	96760.00	250	16	3502	1648	2.125	0.0919524763714367	0.0919524763714367	false	false	false	true	false
0999a427-4a7a-44e8-9793-1e7c3192efab	2026-08-28 11:53	2026-08-28 11:53	2026-08-28 11:53	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	38.1000	38.0000	38.3000	7715.0000	186690.00	140970.00	45720.00	49	6	3412	4549	0.750054957133436	0.199114490437015	0.199114490437015	false	false	false	true	false
39160542-57c0-456c-b033-b7758e43debc	2026-08-28 11:53	2026-08-28 11:53	2026-08-28 11:53	SPXW	SPXW260901P07725000	put	7725.0000	2026-09-01	22.2000	22.1000	22.2000	7715.0000	222000.00	222000.00	0.00	100	11	1071	481	2.22661122661123	0.0881378700655067	0.0881378700655067	false	false	false	true	false
04149c64-0ef7-4e0f-aae4-a90dc4fdfa68	2026-08-28 11:54	2026-08-28 11:54	2026-08-28 11:54	SPXW	SPXW260828P07715000	put	7715.0000	2026-08-28	5.3000	5.3000	5.4000	7710.0000	253430.00	4860.00	248570.00	478	36	33100	1492	22.1849865951743	0.187132949768279	0.188929032444873	false	false	false	true	false
8a406273-65a4-4e94-af04-d2bba3d3c30f	2026-08-28 11:56	2026-08-28 11:55	2026-08-28 11:55	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	37.1000	37.0000	37.4000	7710.0000	185500.00	0.00	66780.00	50	7	3526	4549	0.775115409980215	0.207564277861168	0.202509093579142	false	false	false	true	false
a4a789fa-8781-4df6-a32e-a75c7b794921	2026-08-28 11:56	2026-08-28 11:56	2026-08-28 11:56	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	34.0000	33.6000	34.3000	7710.0000	170000.00	27200.00	142800.00	50	10	3607	4549	0.792921521213453	0.188144438412721	0.188144438412721	false	false	false	true	false
11529389-1432-494e-abbc-4a9622fc5975	2026-08-28 11:56	2026-08-28 11:56	2026-08-28 11:56	SPXW	SPXW260828P07730000	put	7730.0000	2026-08-28	12.0000	11.8000	12.1000	7710.0000	156030.00	21630.00	134400.00	130	28	48073	1508	31.8786472148541	0.181315242027662	0.178295423473031	false	false	false	true	false
d4174e5d-a772-44f9-a0f8-6c92c1a3ea99	2026-08-28 11:57	2026-08-28 11:57	2026-08-28 11:57	SPXW	SPXW260904P07700000	put	7700.0000	2026-09-04	31.5600	31.3000	31.7000	7705.0000	110470.00	110470.00	0.00	35	8	1251	2704	0.462647928994083	0.108844731661816	0.109089451162538	false	false	false	true	false
5eaeda2c-e23b-404a-9abe-3a7eff8d61d5	2026-08-28 11:57	2026-08-28 11:57	2026-08-28 11:57	SPXW	SPXW260828C07750000	call	7750.0000	2026-08-28	3.1600	3.1000	3.3000	7705.0000	111860.00	960.00	109940.00	354	43	72701	4562	15.936212187637	0.16824907668782	0.16824907668782	false	false	false	true	false
365cb252-548b-4cf2-902b-b6ff92c40bcd	2026-08-28 11:57	2026-08-28 11:57	2026-08-28 11:57	SPXW	SPXW260901C07750000	call	7750.0000	2026-09-01	17.2300	17.1000	17.5000	7705.0000	172250.00	43000.00	129250.00	100	16	977	861	1.13472706155633	0.0796330973550656	0.0793096865446966	false	false	false	true	false
d61833a3-cdbf-4ea9-83b1-f539b99476e0	2026-08-28 11:57	2026-08-28 11:57	2026-08-28 11:57	SPXW	SPXW260901P07750000	put	7750.0000	2026-09-01	38.2000	38.1000	38.2000	7705.0000	229200.00	229200.00	0.00	60	7	426	246	1.73170731707317	0.0861597380159009	0.0859657775948835	false	false	false	true	false
3742efe5-ecae-40f0-8d3e-783f9ab1ee0b	2026-08-28 11:58	2026-08-28 11:58	2026-08-28 11:58	SPXW	SPXW260901P07700000	put	7700.0000	2026-09-01	16.4000	16.3000	16.4000	7710.0000	123000.00	123000.00	0.00	75	7	749	575	1.30260869565217	0.0939241014007074	0.0939241014007074	false	false	false	true	false
450cf314-dcb0-42c3-b33e-5b6d4d8e3aab	2026-08-28 11:58	2026-08-28 11:58	2026-08-28 11:58	SPXW	SPXW260901C07725000	call	7725.0000	2026-09-01	30.3000	30.2000	30.6000	7705.0000	151500.00	9090.00	142410.00	50	11	302	496	0.608870967741935	0.081909406169215	0.081909406169215	false	false	false	true	false
2ad8aa00-9177-4411-a097-302ee0c5bf32	2026-08-28 12:00	2026-08-28 11:59	2026-08-28 11:59	SPXW	SPXW260828C07725000	call	7725.0000	2026-08-28	13.9000	13.8000	14.0000	7705.0000	104250.00	22240.00	79230.00	75	16	12651	2946	4.29429735234216	0.182101863683323	0.182101863683323	false	false	false	true	false
74b0aa20-99c2-4fdd-bc2a-70d97124fcc1	2026-08-28 12:01	2026-08-28 12:01	2026-08-28 12:01	SPXW	SPXW260828P07725000	put	7725.0000	2026-08-28	12.0900	11.9000	12.2000	7705.0000	193450.00	133070.00	57980.00	160	34	45418	2270	20.0079295154185	0.182124834682979	0.180122007206485	false	false	false	true	false
32cf1287-8d04-43f6-b02a-6b4720fc61c7	2026-08-28 12:01	2026-08-28 12:01	2026-08-28 12:01	SPXW	SPXW260902P07650000	put	7650.0000	2026-09-02	11.3000	11.1000	11.4000	7700.0000	169500.00	74580.00	94920.00	150	15	555	316	1.75632911392405	0.106884578069037	0.106884578069037	false	false	false	true	false
c2dda657-f057-4358-910f-c9c36a2ee08a	2026-08-28 12:01	2026-08-28 12:01	2026-08-28 12:01	SPXW	SPXW260828P07725000	put	7725.0000	2026-08-28	13.7200	13.5000	13.8000	7700.0000	126210.00	124860.00	1350.00	92	25	45872	2270	20.2079295154185	0.192455031022168	0.190928366210347	false	false	false	true	false
61816371-8545-4aea-87ae-a7497c466a7d	2026-08-28 12:01	2026-08-28 12:01	2026-08-28 12:01	SPXW	SPXW260828P07725000	put	7725.0000	2026-08-28	13.4000	13.3000	13.6000	7700.0000	151420.00	120600.00	30820.00	113	12	46054	2270	20.2881057268722	0.187409397543475	0.187409397543475	false	false	false	true	false
f0adcc5e-c3a4-441f-a151-ad6dddcc41dc	2026-08-28 12:02	2026-08-28 12:02	2026-08-28 12:02	SPXW	SPXW260901P07710000	put	7710.0000	2026-09-01	21.7000	21.4000	21.7000	7705.0000	108500.00	108500.00	0.00	50	10	270	242	1.11570247933884	0.0926533567645641	0.0926533567645641	false	false	false	true	false
944b81ef-b755-4c60-a81a-1caf31b18205	2026-08-28 12:02	2026-08-28 12:02	2026-08-28 12:02	SPXW	SPXW260901P07710000	put	7710.0000	2026-09-01	21.6000	21.3000	21.7000	7705.0000	107980.00	107980.00	0.00	50	13	321	242	1.32644628099174	0.0926302893562313	0.0932701091761597	false	false	false	true	false
a2cbe795-f8a3-418a-bd38-44648515c690	2026-08-28 12:03	2026-08-28 12:03	2026-08-28 12:03	SPXW	SPXW260828P07750000	put	7750.0000	2026-08-28	25.2100	24.8000	25.4000	7705.0000	221880.00	221880.00	0.00	88	29	42502	2724	15.6027900146843	0.158472422033721	0.16280925897697	true	false	false	true	false
8f2af134-d60b-45f6-aedc-0de0a0eb0c39	2026-08-28 12:05	2026-08-28 12:04	2026-08-28 12:04	SPXW	SPXW260918C07700000	call	7700.0000	2026-09-18	105.8000	105.4000	106.0000	7705.0000	1058000.00	571320.00	486680.00	100	8	404	3258	0.124002455494168	0.111967238785775	0.111967238785775	false	false	false	true	false
5d624e60-5d2c-4ad5-a05b-e4deb95f10ee	2026-08-28 12:07	2026-08-28 12:07	2026-08-28 12:07	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	34.3000	34.2000	34.4000	7731.1900	171500.00	30870.00	0.00	50	8	4083	4549	0.897559903275445	0.202153611429913	0.202153611429913	false	false	false	true	false
2361bfbd-c098-4684-9c1a-4bd9c77ac754	2026-08-28 12:07	2026-08-28 12:07	2026-08-28 12:07	SPXW	SPXW260828P07750000	put	7750.0000	2026-08-28	22.2000	22.1000	22.2000	7710.0000	195360.00	195360.00	0.00	88	14	42858	2724	15.7334801762115	0.155267975056881	0.155267975056881	false	false	false	true	false
a484d6f4-f05f-4324-8d33-048f47602e2d	2026-08-28 12:09	2026-08-28 12:09	2026-08-28 12:09	SPXW	SPXW260828C07730000	call	7730.0000	2026-08-28	12.8200	12.7000	12.9000	7734.1600	117990.00	116720.00	1270.00	92	26	26344	4131	6.37714839022029	0.162737137788379	0.161168861883101	false	false	false	true	false
f637aeb1-aad0-4003-8391-cab6dfd9e60b	2026-08-28 12:16	2026-08-28 12:16	2026-08-28 12:16	SPXW	SPXW260828C07730000	call	7730.0000	2026-08-28	7.9000	7.8000	8.0000	7723.0300	159560.00	158000.00	1560.00	202	31	28441	4131	6.88477366255144	0.172655131889841	0.172655131889841	false	false	false	true	false
d8a668c8-ebd1-4bd7-b04e-8ae74b4801c6	2026-08-28 12:16	2026-08-28 12:16	2026-08-28 12:16	SPXW	SPXW260901P07720000	put	7720.0000	2026-09-01	26.6000	26.4000	26.7000	7722.4400	595840.00	74480.00	521360.00	224	12	461	747	0.617135207496653	0.0910203361253946	0.0910203361253946	false	false	false	true	false
30d6d8c8-695a-43d5-8643-baf38a59ce9e	2026-08-28 12:16	2026-08-28 12:16	2026-08-28 12:16	SPXW	SPXW260831P07700000	put	7700.0000	2026-08-31	13.7000	13.5000	13.8000	7722.0600	137000.00	97270.00	39730.00	100	6	4619	8015	0.576294447910168	0.0859781953563252	0.0859781953563252	false	false	false	true	false
a8224b4c-d4f5-49b0-a358-0e3b200f24ee	2026-08-28 12:16	2026-08-28 12:16	2026-08-28 12:16	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	26.9400	26.7000	27.0000	7722.0000	134680.00	134680.00	0.00	50	9	4460	4549	0.980435260496813	0.204135859710868	0.20612244183616	false	false	false	true	false
1008a8f1-c615-4f2a-a439-af3c1d7448b9	2026-08-28 12:18	2026-08-28 12:17	2026-08-28 12:17	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	26.5600	26.3000	26.6000	7721.8600	132790.00	132790.00	0.00	50	9	4529	4549	0.995603429325126	0.198738367213536	0.198738367213536	false	false	false	true	false
76b8d825-27d7-4a86-84bc-a34de802d902	2026-08-28 12:18	2026-08-28 12:18	2026-08-28 12:18	SPXW	SPXW260828C07700000	call	7700.0000	2026-08-28	26.0000	25.9000	26.1000	7720.7800	132590.00	0.00	132590.00	51	5	4616	4549	1.01472851176083	0.205029955576975	0.203078573196664	false	false	false	true	false
a12817da-4405-48b9-979b-b464ecae0402	2026-08-28 12:18	2026-08-28 12:18	2026-08-28 12:18	SPXW	SPXW260828P07720000	put	7720.0000	2026-08-28	12.9100	12.7000	13.0000	7718.9500	108450.00	104620.00	1270.00	84	17	61546	2086	29.5043144774688	0.195071129808047	0.196653737845941	true	false	false	true	false