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:alert_rule = RepeatedHitsDescendingFill×ticker = SPXW×

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

3a91fb6d-00da-4d06-a92c-14258a8d01f5	2026-09-30 10:59	2026-09-30 10:59	2026-09-30 10:59	SPXW	SPXW260930C07715000	call	7715.0000	2026-09-30	11.0000	10.9000	11.2000	7715.6100	46200.00	0.00	45090.00	42	7	33084	1812	18.2582781456954	0.145451460727476	0.142731883138805	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T15:01:09.896408Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
f492615e-e58a-4005-9660-f4e029bea945	2026-09-30 10:59	2026-09-30 10:59	2026-09-30 10:59	SPXW	SPXW260930P07715000	put	7715.0000	2026-09-30	10.4700	10.4000	10.6000	7716.5500	43990.00	0.00	43990.00	42	11	18573	457	40.6411378555799	0.153992388550599	0.152632290580942	false	false	false	true
74c24f43-988e-4f7f-9346-d8fb6d215d31	2026-09-30 10:58	2026-09-30 10:58	2026-09-30 10:58	SPXW	SPXW260930P07710000	put	7710.0000	2026-09-30	8.6300	8.6000	8.8000	7717.1900	17260.00	0.00	17260.00	20	5	23209	1693	13.7088009450679	0.163267473124475	0.163267473124475	false	false	false	true
ed7b82d6-b267-4ee7-9c39-3ef8f3ab284e	2026-09-30 10:58	2026-09-30 10:58	2026-09-30 10:58	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	5.1000	5.1000	5.3000	7717.4900	51020.00	0.00	51020.00	100	18	33169	10638	3.11797330325249	0.163291417183357	0.163291417183357	false	false	false	true
b2f79b4f-6f3f-486b-b77c-8f8f57faa624	2026-09-30 10:58	2026-09-30 10:58	2026-09-30 10:58	SPXW	SPXW260930C07710000	call	7710.0000	2026-09-30	15.5600	15.4000	15.7000	7719.0900	12450.00	9360.00	3090.00	8	5	32180	2058	15.6365403304179	0.139873079682828	0.136975418449729	false	false	false	true
5cefa79f-09fd-4096-b723-5ae81d3d18db	2026-09-30 10:58	2026-09-30 10:58	2026-09-30 10:58	SPXW	SPXW260930P07650000	put	7650.0000	2026-09-30	0.6200	0.6000	0.7000	7718.6200	15500.00	0.00	14460.00	250	19	30420	8683	3.50339744327997	0.214513705657232	0.214513705657232	false	false	false	true
0d9139d9-365a-4a3a-8b95-b76ff42bb209	2026-09-30 10:58	2026-09-30 10:58	2026-09-30 10:58	SPXW	SPXW260930C07730000	call	7730.0000	2026-09-30	5.7600	5.6000	5.8000	7718.6200	12090.00	6960.00	5130.00	21	6	42253	2561	16.4986333463491	0.141741705098059	0.14025575862987	false	false	false	true
35d9f064-948a-4095-976d-c37cd36584e9	2026-09-30 10:58	2026-09-30 10:58	2026-09-30 10:58	SPXW	SPXW260930C07725000	call	7725.0000	2026-09-30	9.0200	9.0000	9.2000	7721.4400	16230.00	0.00	16230.00	18	7	41274	3294	12.5300546448087	0.144645565382713	0.143592335024325	false	false	false	true
a447ca3e-64c4-4268-b551-197eba47df87	2026-09-30 10:57	2026-09-30 10:57	2026-09-30 10:57	SPXW	SPXW260930C07720000	call	7720.0000	2026-09-30	11.5100	11.4000	11.7000	7721.3900	17260.00	0.00	16110.00	15	5	55472	3039	18.2533728200066	0.146161392671483	0.144805388844381	false	false	false	true
5e1d59b6-43e6-4707-83c9-88dd279ba346	2026-09-30 10:57	2026-09-30 10:57	2026-09-30 10:57	SPXW	SPXW260930C07735000	call	7735.0000	2026-09-30	5.4000	5.4000	5.5000	7721.3400	27010.00	550.00	26460.00	50	9	30724	2149	14.2968822708236	0.148001109013115	0.146473441617284	false	false	false	true
c4de25e2-2cf3-49fe-9b3d-3464dfdb5ccc	2026-09-30 10:57	2026-09-30 10:57	2026-09-30 10:57	SPXW	SPXW260930C07725000	call	7725.0000	2026-09-30	9.1500	9.1000	9.3000	7721.5600	64050.00	10230.00	52900.00	70	16	40973	3294	12.4386763812993	0.146822918635737	0.145460158470177	false	false	false	true
d989ab82-6e19-49f2-97d0-a119d4762578	2026-09-30 10:57	2026-09-30 10:57	2026-09-30 10:57	SPXW	SPXW260930C07730000	call	7730.0000	2026-09-30	7.2300	7.1000	7.4000	7721.3300	26030.00	0.00	8030.00	36	6	41480	2561	16.1967981257321	0.149155488851932	0.147737156940612	false	false	false	true
ab88a23d-6b32-430b-9611-bc36fd23c435	2026-09-30 10:57	2026-09-30 10:57	2026-09-30 10:57	SPXW	SPXW260930C07725000	call	7725.0000	2026-09-30	9.3300	9.3000	9.5000	7721.2800	18650.00	1880.00	14890.00	20	7	40881	3294	12.4107468123862	0.149590079522113	0.149901312928571	false	false	false	true
8e421cec-dcb5-416e-b9fa-341289b3b774	2026-09-30 10:57	2026-09-30 10:57	2026-09-30 10:57	SPXW	SPXW260930C07735000	call	7735.0000	2026-09-30	5.5000	5.4000	5.6000	7721.2800	12110.00	560.00	11000.00	22	5	30649	2149	14.2619823173569	0.149782389298877	0.148257887647545	false	false	false	true
6a3690b2-60d1-4016-904b-9218eaf0d0bf	2026-09-30 10:56	2026-09-30 10:56	2026-09-30 10:56	SPXW	SPXW260930C07720000	call	7720.0000	2026-09-30	11.2300	11.1000	11.4000	7700.0000	17960.00	0.00	14590.00	16	8	55101	3039	18.1312931885489	0.146343820774455	0.14464747461297	false	false	false	true
d9073d71-d4bc-40e6-9675-caf349c26ec1	2026-09-30 10:56	2026-09-30 10:56	2026-09-30 10:56	SPXW	SPXW260930C07740000	call	7740.0000	2026-09-30	3.5000	3.4000	3.6000	7695.0000	95660.00	3960.00	91700.00	273	5	48501	2729	17.7724441187248	0.14765604111785	0.14765604111785	false	false	false	true
810c96e1-efea-4f19-94bc-b9ec30074181	2026-09-30 10:56	2026-09-30 10:56	2026-09-30 10:56	SPXW	SPXW260930P07710000	put	7710.0000	2026-09-30	7.4000	7.4000	7.6000	7700.0000	14810.00	750.00	14060.00	20	6	22171	1693	13.0956881275842	0.164511362650626	0.163070587041327	false	false	false	true
7613a048-b49b-4ca0-bfe0-877a01329abd	2026-09-30 10:56	2026-09-30 10:56	2026-09-30 10:56	SPXW	SPXW260930P07720000	put	7720.0000	2026-09-30	11.4800	11.4000	11.5000	7700.0000	18370.00	14950.00	3420.00	16	15	10092	555	18.1837837837838	0.159701832205297	0.158351203503445	false	false	false	true
350ec728-009c-47a4-ac5a-0b3cd5d9ab84	2026-09-30 10:55	2026-09-30 10:55	2026-09-30 10:55	SPXW	SPXW260930P07735000	put	7735.0000	2026-09-30	19.9400	19.9000	20.1000	7700.0000	17950.00	2010.00	11940.00	9	6	1341	1476	0.908536585365854	0.162580062709564	0.161085653192611	false	false	false	true
404be738-197c-44bc-8247-b05e94a9c542	2026-09-30 10:55	2026-09-30 10:55	2026-09-30 10:55	SPXW	SPXW260930C07725000	call	7725.0000	2026-09-30	9.4200	9.4000	9.5000	7700.0000	27310.00	4750.00	22560.00	29	10	39785	3294	12.0780206435944	0.142506169016047	0.141152941642791	false	false	false	true
cdfd637b-616d-4620-a63b-46f1011789d0	2026-09-30 10:55	2026-09-30 10:55	2026-09-30 10:55	SPXW	SPXW261001C07730000	call	7730.0000	2026-10-01	20.2200	20.2000	20.4000	7700.0000	20220.00	0.00	16160.00	10	5	869	587	1.48040885860307	0.144413088589886	0.144413088589886	false	false	false	true
061fe0ed-d655-4855-a252-5a4434c0fda7	2026-09-30 10:55	2026-09-30 10:55	2026-09-30 10:55	SPXW	SPXW260930C07720000	call	7720.0000	2026-09-30	12.3900	12.3000	12.6000	7700.0000	58230.00	21250.00	36980.00	47	11	54483	3039	17.9279368213228	0.150918536111909	0.149564188106643	false	false	false	true
40fb7e7e-7bf4-4956-8802-f304bbe0492d	2026-09-30 10:55	2026-09-30 10:55	2026-09-30 10:55	SPXW	SPXW260930P07720000	put	7720.0000	2026-09-30	10.4500	10.4000	10.6000	7700.0000	13580.00	0.00	13580.00	13	6	9834	555	17.7189189189189	0.156382499524447	0.155029705530169	false	false	false	true
289e33a0-d114-46f2-b6df-b248d9f58b97	2026-09-30 10:55	2026-09-30 10:55	2026-09-30 10:55	SPXW	SPXW260930C07720000	call	7720.0000	2026-09-30	11.9100	11.8000	12.1000	7700.0000	15480.00	0.00	15480.00	13	5	54258	3039	17.8538993089832	0.144542623574167	0.141834113944429	false	false	false	true
2fa2f31b-0d7a-4c2a-927e-66031fd53081	2026-09-30 10:55	2026-09-30 10:55	2026-09-30 10:55	SPXW	SPXW260930C07725000	call	7725.0000	2026-09-30	9.4500	9.4000	9.7000	7700.0000	210840.00	3840.00	206050.00	223	47	39482	3294	11.9860352155434	0.148686293696008	0.148686293696008	false	false	false	true
8be696a2-9712-49ac-a257-ed8c9baa85d5	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW260930C07720000	call	7720.0000	2026-09-30	11.9800	11.9000	12.1000	7700.0000	14380.00	1210.00	13170.00	12	10	53918	3039	17.7420204014478	0.142541736041725	0.139830783169434	false	false	false	true
32efe55c-31b7-42c0-8862-c7777f41435e	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW260930C07735000	call	7735.0000	2026-09-30	5.9400	5.8000	6.1000	7700.0000	10090.00	2410.00	5910.00	17	12	29699	2149	13.8199162401117	0.147548470336064	0.147548470336064	false	false	false	true
cd0e6e60-e4be-4cb1-aea4-cac5986d26fb	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW260930C07720000	call	7720.0000	2026-09-30	12.5100	12.3000	12.7000	7700.0000	25020.00	3810.00	19960.00	20	7	53641	3039	17.6508719973676	0.149795264777746	0.147085954592918	false	false	false	true
c6d2cb83-8bbb-4bd7-a442-e3c3ded7ce5e	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW260930C07745000	call	7745.0000	2026-09-30	3.5900	3.5000	3.6000	7700.0000	12220.00	11520.00	700.00	34	5	33678	2800	12.0278571428571	0.153907283594966	0.153907283594966	false	false	false	true
6cc2ce61-4b0e-4628-a964-d08d0beb3929	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW260930C07745000	call	7745.0000	2026-09-30	3.5400	3.4500	3.6000	7700.0000	17340.00	6840.00	10500.00	49	18	33740	2800	12.05	0.153907283594966	0.150976914491262	false	false	false	true
529d85fc-5c23-4635-a008-10410366ec56	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW260930C07725000	call	7725.0000	2026-09-30	10.2600	10.1000	10.4000	7700.0000	23590.00	10300.00	11230.00	23	8	38806	3294	11.7808136004857	0.153374051537372	0.153374051537372	false	false	false	true
e590af3b-11f8-42fd-b462-d8645af3ec94	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW260930P07720000	put	7720.0000	2026-09-30	10.6000	10.6000	10.8000	7700.0000	22270.00	0.00	21200.00	21	8	9499	555	17.1153153153153	0.158248030861067	0.158248030861067	false	false	false	true
adeb8adf-3906-4a16-aa5f-90d168cc0e14	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW260930P07715000	put	7715.0000	2026-09-30	8.7100	8.7000	8.9000	7700.0000	19170.00	890.00	17400.00	22	7	16459	457	36.0153172866521	0.163523553720508	0.160753322445299	false	false	false	true
f093c523-7083-42fe-ac88-aa9faab64d50	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW261001C07740000	call	7740.0000	2026-10-01	15.5400	15.5000	16.0000	7700.0000	21760.00	0.00	21760.00	14	6	2600	456	5.70175438596491	0.142700932603185	0.142700932603185	false	false	false	true
be336026-da77-4f3f-9011-a377b01b6411	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW260930P07720000	put	7720.0000	2026-09-30	11.0100	11.0000	11.2000	7700.0000	17610.00	0.00	16500.00	16	6	9420	555	16.972972972973	0.151397289637737	0.150050875281062	false	false	false	true
bdfb857f-bd4d-435b-b7f2-e7acc294e740	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW260930P07715000	put	7715.0000	2026-09-30	8.9100	8.9000	9.1000	7700.0000	58800.00	0.00	58800.00	66	7	16380	457	35.8424507658643	0.154227910309731	0.152857847316558	false	false	false	true
5cf01278-b84d-4bfe-937c-0c1876e6ebde	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW261001C07740000	call	7740.0000	2026-10-01	15.5100	15.4000	16.1000	7700.0000	68230.00	0.00	68230.00	44	7	2570	456	5.6359649122807	0.142080430099549	0.142080430099549	false	false	false	true
0fb56218-e6b9-4550-aeb9-7c9f824855a4	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW260930P07700000	put	7700.0000	2026-09-30	4.2700	4.1000	4.7000	7700.0000	11520.00	0.00	11520.00	27	11	31304	10638	2.94265839443504	0.162010049550891	0.155176744208535	false	false	false	true
875f6b5b-a217-46be-beca-a54c9e665d98	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW260930C07710000	call	7710.0000	2026-09-30	17.3100	17.2000	17.5000	7700.0000	24240.00	1740.00	17300.00	14	7	31556	2058	15.3333333333333	0.149612346923802	0.148157193056254	false	false	false	true
f7bec506-ed7a-4b0e-8960-78ba54ff4c6a	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW260930C07720000	call	7720.0000	2026-09-30	11.5800	11.4000	11.7000	7700.0000	19690.00	4640.00	10440.00	17	11	53108	3039	17.4754853570253	0.146067324467873	0.14471956358386	false	false	false	true
e4a2a209-2053-401c-94ba-e406fb2965b9	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW260930C07710000	call	7710.0000	2026-09-30	17.9500	17.8000	18.2000	7700.0000	10770.00	5400.00	5370.00	6	5	31485	2058	15.298833819242	0.151175951076275	0.146743007765259	false	false	false	true
0b8e84f0-6164-4942-888f-464ced0d4cf8	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW260930C07725000	call	7725.0000	2026-09-30	9.6100	9.5000	9.8000	7700.0000	15380.00	2910.00	12470.00	16	5	38334	3294	11.6375227686703	0.150102146589405	0.147395327754281	false	false	false	true
d92d2160-b3e5-4543-855d-e040ecf4e1fe	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW261001C07740000	call	7740.0000	2026-10-01	15.7500	15.7000	16.1000	7700.0000	55130.00	0.00	55130.00	35	5	2518	456	5.5219298245614	0.149411156031585	0.14876011069294	false	false	false	true
f62ed27c-585d-491e-a473-1d8d9796ccac	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	SPXW	SPXW260930C07710000	call	7710.0000	2026-09-30	17.2200	17.1000	17.4000	7700.0000	22380.00	3460.00	18920.00	13	5	31391	2058	15.2531584062196	0.158111481673443	0.156691420654214	false	false	false	true
b6b5b417-b39c-4c0d-b970-6e53a727fcb5	2026-09-30 10:53	2026-09-30 10:53	2026-09-30 10:53	SPXW	SPXW260930C07710000	call	7710.0000	2026-09-30	16.8900	16.7000	17.0000	7700.0000	23640.00	0.00	21960.00	14	6	31267	2058	15.1929057337221	0.150697096225669	0.149261936467291	false	false	false	true
5a0e5bc2-4aa8-46ff-a070-f3b87d27ee23	2026-09-30 10:53	2026-09-30 10:53	2026-09-30 10:53	SPXW	SPXW260930C07720000	call	7720.0000	2026-09-30	10.9500	10.9000	11.1000	7700.0000	13140.00	0.00	12040.00	12	8	52677	3039	17.3336623889437	0.147955564199056	0.146610406737112	false	false	false	true
4feb8920-24b8-4511-8968-5cc7cab3aaf3	2026-09-30 10:53	2026-09-30 10:53	2026-09-30 10:53	SPXW	SPXW260930C07720000	call	7720.0000	2026-09-30	11.2600	11.1000	11.3000	7700.0000	21390.00	16950.00	4440.00	19	11	52655	3039	17.326423165515	0.152386430199522	0.149696245240469	false	false	false	true
8fb00323-c5f1-4eb2-8e58-9df969a644d7	2026-09-30 10:53	2026-09-30 10:53	2026-09-30 10:53	SPXW	SPXW260930C07720000	call	7720.0000	2026-09-30	11.0200	11.0000	11.2000	7700.0000	33060.00	0.00	33060.00	30	9	52569	3039	17.2981243830207	0.148068760239554	0.14672373539628	false	false	false	true
28cdfa14-d688-4cfd-b737-d635c307be2c	2026-09-30 10:53	2026-09-30 10:53	2026-09-30 10:53	SPXW	SPXW260930C07720000	call	7720.0000	2026-09-30	10.2500	10.2000	10.3000	7695.0000	12300.00	6180.00	6120.00	12	6	52194	3039	17.1747285291214	0.146038053623305	0.146038053623305	false	false	false	true
aa709b18-af8e-4ec0-87c3-c106efb8730d	2026-09-30 10:53	2026-09-30 10:53	2026-09-30 10:53	SPXW	SPXW260930C07720000	call	7720.0000	2026-09-30	10.7000	10.5000	10.8000	7695.0000	13910.00	12850.00	1060.00	13	9	52102	3039	17.1444554129648	0.151174135545342	0.149304156643123	false	false	false	true