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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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

97fee639-ae87-4a28-962a-ed1c815c7203	2026-08-31 09:47	2026-08-31 09:46	2026-08-31 09:46	SPXW	SPXW260918P07550000	put	7550.0000	2026-09-18	41.2000	40.8000	41.3000	7676.7800	1030000.00	399640.00	630360.00	250	11	3767	3003	1.25441225441225	0.141932308247813	0.141932308247813	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	—	—	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
7b229fd3-434a-4100-8e10-5a9a9be16cab	2026-08-31 09:47	2026-08-31 09:47	2026-08-31 09:47	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	13.4000	13.2000	13.5000	7676.9400	210380.00	199660.00	2680.00	157	29	3640	734	4.9591280653951	0.150727938517164	0.150727938517164	false	false	false	true	false
98655102-6550-43d2-8ac6-0f26549be6e0	2026-08-31 09:47	2026-08-31 09:47	2026-08-31 09:47	SPXW	SPXW260918P07550000	put	7550.0000	2026-09-18	42.2000	41.9000	42.3000	7674.4300	1054960.00	1054960.00	0.00	250	5	4017	3003	1.33766233766234	0.142379563996059	0.142554849777935	false	false	false	true	false
d2cc7f84-6a84-4d49-aa66-5a592e84bc31	2026-08-31 09:48	2026-08-31 09:48	2026-08-31 09:48	SPXW	SPXW260918P07550000	put	7550.0000	2026-09-18	39.8500	39.4000	40.2000	7683.5700	996160.00	222100.00	774060.00	250	16	4522	3003	1.50582750582751	0.142329046782753	0.142866310139035	false	false	false	true	false
18d494cb-b818-4f07-9030-dba02f5752c8	2026-08-31 09:48	2026-08-31 09:48	2026-08-31 09:48	SPXW	SPXW260918P07550000	put	7550.0000	2026-09-18	39.8200	39.6000	39.9000	7683.1600	230930.00	230930.00	0.00	58	5	4770	3003	1.58841158841159	0.14249296843991	0.14249296843991	false	false	false	true	false
720f0722-8635-41d2-846f-b3fee3d37db3	2026-08-31 09:48	2026-08-31 09:48	2026-08-31 09:48	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	15.7200	15.6000	15.9000	7680.9800	314360.00	0.00	285920.00	200	34	4789	734	6.52452316076294	0.15184067153734	0.151844148015954	true	false	false	true	false
1ef63870-dc1f-42c8-b1f0-5bd9062d46c8	2026-08-31 09:49	2026-08-31 09:49	2026-08-31 09:49	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	15.4000	15.3000	15.4000	7679.6600	251020.00	251020.00	0.00	163	13	5006	734	6.82016348773842	0.155946063779224	0.157556329920521	false	false	false	true	false
27386195-54f6-47f5-bde8-66eca16144a1	2026-08-31 09:49	2026-08-31 09:49	2026-08-31 09:49	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	15.5700	15.4000	15.8000	7680.5200	280170.00	1550.00	277050.00	180	33	5229	734	7.12397820163488	0.155259632296962	0.15275978419512	false	false	false	true	false
fda3efa4-fbbf-4cf3-886e-75fa582b0542	2026-08-31 09:49	2026-08-31 09:49	2026-08-31 09:49	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	14.2000	14.1000	14.3000	7677.6000	284000.00	257020.00	0.00	200	10	5661	734	7.7125340599455	0.156827772329086	0.156827772329086	false	false	false	true	false
14d6c191-0569-42ea-bc57-2b52fe5404f7	2026-08-31 09:50	2026-08-31 09:49	2026-08-31 09:49	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	14.3000	14.2000	14.4000	7678.9600	265980.00	193050.00	0.00	186	30	5926	734	8.07356948228883	0.149954244680092	0.148921899022604	false	false	false	true	false
572e374d-cce7-479a-9daa-b93fffb5bb1a	2026-08-31 09:51	2026-08-31 09:51	2026-08-31 09:51	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	13.5500	13.5000	13.8000	7678.3300	271010.00	0.00	245170.00	200	42	6730	734	9.16893732970027	0.144864346469244	0.143625455133392	true	false	false	true	false
29b9c43e-99ee-4cf7-9d07-a6892ca5fc90	2026-08-31 09:51	2026-08-31 09:51	2026-08-31 09:51	SPXW	SPXW260831C07685000	call	7685.0000	2026-08-31	9.7800	9.7000	9.9000	7681.1500	103660.00	990.00	102670.00	106	15	7011	554	12.6552346570397	0.143344705485355	0.142102512188512	false	false	false	true	false
a936c3da-0d4a-4de2-b9a9-d911ee549cf9	2026-08-31 09:54	2026-08-31 09:53	2026-08-31 09:53	SPXW	SPXW260925P07695000	put	7695.0000	2026-09-25	95.1000	94.2000	95.8000	7680.2800	475500.00	38000.00	390000.00	50	8	100	0	0	0.122288399797706	0.12191400468892	false	false	false	true	false
28e9c3f3-17a1-4d3f-9caf-462fd44ffa16	2026-08-31 09:58	2026-08-31 09:57	2026-08-31 09:57	SPXW	SPXW260911P07600000	put	7600.0000	2026-09-11	30.6900	30.4000	30.8000	7680.6800	205650.00	205650.00	0.00	67	11	151	1056	0.142992424242424	0.124612924955517	0.12505067017603	false	false	false	true	false
ab9a5b56-8e55-40bd-8c19-f15c51ae0758	2026-08-31 10:02	2026-08-31 10:01	2026-08-31 10:01	SPXW	SPXW260831C07695000	call	7695.0000	2026-08-31	4.2000	4.2000	4.3000	7677.9600	102480.00	0.00	102480.00	244	10	7532	1368	5.50584795321637	0.131804067644817	0.131804067644817	false	false	false	true	false
da863bc7-9072-4d4a-8f4a-cb4a78a32e3a	2026-08-31 10:06	2026-08-31 10:06	2026-08-31 10:06	SPXW	SPXW260831P07680000	put	7680.0000	2026-08-31	13.4000	13.2000	13.5000	7675.7000	286780.00	284120.00	2660.00	214	42	13927	1920	7.25364583333333	0.140119664779211	0.14266462810742	false	false	false	true	false
2fdc8ff7-798d-48dc-b1e1-b02ad19d0cea	2026-08-31 10:06	2026-08-31 10:06	2026-08-31 10:06	SPXW	SPXW260831C07680000	call	7680.0000	2026-08-31	8.6000	8.5000	8.7000	7674.9100	148780.00	0.00	138460.00	173	16	10455	384	27.2265625	0.136925473364904	0.136925473364904	false	false	false	true	false
c9122842-94e7-42db-b050-2e8ff84b0135	2026-08-31 10:09	2026-08-31 10:09	2026-08-31 10:09	SPXW	SPXW260908C07725000	call	7725.0000	2026-09-08	24.5600	22.9000	23.1000	7675.3600	913632.00	0.00	0.00	372	7	380	318	1.19496855345912	0.0939500211802329	0.0939500211802329	false	false	false	true	false
7e0085ea-c211-4736-b827-0fb6de69f04a	2026-08-31 10:09	2026-08-31 10:09	2026-08-31 10:09	SPXW	SPXW260908P07675000	put	7675.0000	2026-09-08	40.7100	43.3000	43.6000	7675.3600	1587690.00	0.00	0.00	390	7	499	1873	0.266417512012814	0.0971812176557747	0.0971812176557747	false	false	false	true	false
6f8fee8f-0eda-47f0-a6d6-942a1557eb29	2026-08-31 10:09	2026-08-31 10:09	2026-08-31 10:09	SPXW	SPXW260911P07650000	put	7650.0000	2026-09-11	44.3400	46.5000	46.8000	7675.3600	1613976.00	0.00	0.00	364	7	443	1757	0.252134319863404	0.112931553157182	0.112931553157182	false	false	false	true	false
34feba62-3549-40ec-80ec-e5d2b5928de1	2026-08-31 10:09	2026-08-31 10:09	2026-08-31 10:09	SPXW	SPXW260911C07750000	call	7750.0000	2026-09-11	27.9300	26.2000	26.4000	7675.3600	1106028.00	0.00	0.00	396	7	518	1888	0.274364406779661	0.102278377473233	0.102278377473233	false	false	false	true	false
786aed87-fdab-45eb-82cb-68f68c4e537c	2026-08-31 10:10	2026-08-31 10:10	2026-08-31 10:10	SPXW	SPXW260831C07670000	call	7670.0000	2026-08-31	12.3000	12.1000	12.3000	7671.8300	123000.00	123000.00	0.00	100	22	3196	978	3.2678936605317	0.142727249839159	0.142727249839159	false	false	false	true	false
73559fc7-e9e4-4bb9-befd-2e2c22c587ed	2026-08-31 10:11	2026-08-31 10:11	2026-08-31 10:11	SPXW	SPXW260831C07670000	call	7670.0000	2026-08-31	13.0100	13.0000	13.2000	7673.0700	130060.00	0.00	122200.00	100	20	3408	978	3.48466257668712	0.144485001111895	0.144485001111895	false	false	false	true	false
b41052a1-168b-46d9-a74b-4cb833844973	2026-08-31 10:17	2026-08-31 10:17	2026-08-31 10:17	SPXW	SPXW260831C07680000	call	7680.0000	2026-08-31	8.9000	8.8000	8.9000	7676.6400	161980.00	161980.00	0.00	182	6	13890	384	36.171875	0.132608623303885	0.133016684767325	false	false	false	true	false
d4917cef-dfab-4bd5-97bf-df7ec2510e63	2026-08-31 10:21	2026-08-31 10:21	2026-08-31 10:21	SPXW	SPXW260831C07670000	call	7670.0000	2026-08-31	13.4000	13.3000	13.5000	7675.4800	104520.00	0.00	24120.00	78	5	5146	978	5.26175869120654	0.1331673878665	0.132780669125207	false	false	false	true	false
b279f4e4-42e8-4058-b2c2-cf5e64176e08	2026-08-31 10:23	2026-08-31 10:23	2026-08-31 10:23	SPXW	SPXW260831P07720000	put	7720.0000	2026-08-31	48.0000	47.9000	48.3000	7672.9900	115200.00	48000.00	67200.00	24	8	923	1399	0.65975696926376	0.170018101264407	0.170018101264407	false	false	false	true	false
9f8a49c1-3f32-4aac-b8ff-e581044b30eb	2026-08-31 10:23	2026-08-31 10:23	2026-08-31 10:23	SPXW	SPXW260831C07670000	call	7670.0000	2026-08-31	12.0000	11.8000	12.1000	7672.3600	120000.00	87600.00	0.00	100	20	5555	978	5.6799591002045	0.137837546266977	0.137837546266977	false	false	false	true	false
2f3c3bd2-5b7f-45d2-80ab-4ca03649cb0e	2026-08-31 10:24	2026-08-31 10:24	2026-08-31 10:24	SPXW	SPXW260831P07720000	put	7720.0000	2026-08-31	50.0000	49.3000	50.1000	7670.8200	119990.00	99990.00	20000.00	24	7	961	1399	0.686919228020014	0.1713648860574	0.169942520559829	false	false	false	true	false
0927164a-d038-46e6-bdf2-3f05595b956b	2026-08-31 10:25	2026-08-31 10:25	2026-08-31 10:25	SPXW	SPXW260831P07670000	put	7670.0000	2026-08-31	13.1000	13.0000	13.2000	7666.7400	100850.00	69430.00	22250.00	77	19	21288	1788	11.9060402684564	0.148958601753047	0.148958601753047	false	false	false	true	false
61737781-c234-4930-b144-803f810596f2	2026-08-31 10:26	2026-08-31 10:26	2026-08-31 10:26	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	6.8600	6.7000	6.9000	7666.6200	171580.00	171580.00	0.00	250	33	15326	734	20.8801089918256	0.134751142675086	0.136113704776126	false	false	false	true	false
a8b338ec-bd06-43b6-945b-879a4aef6c04	2026-08-31 10:28	2026-08-31 10:28	2026-08-31 10:28	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	7.3000	7.1000	7.4000	7667.0100	185370.00	183930.00	0.00	254	48	15932	734	21.7057220708447	0.139988446994771	0.141242548358909	false	false	false	true	false
280bccde-4c69-4e5c-b5c6-944c6de998e8	2026-08-31 10:29	2026-08-31 10:29	2026-08-31 10:29	SPXW	SPXW260928P07675000	put	7675.0000	2026-09-28	97.2000	97.0000	97.6000	7666.9300	486000.00	427680.00	58320.00	50	5	100	132	0.757575757575758	0.123230973478597	0.123230973478597	false	false	false	true	false
e4c8543a-8b74-4699-a206-e10abae503e7	2026-08-31 10:30	2026-08-31 10:30	2026-08-31 10:30	SPXW	SPXW260831P07670000	put	7670.0000	2026-08-31	11.9000	11.8000	12.1000	7667.3500	119000.00	10710.00	108290.00	100	25	23212	1788	12.9821029082774	0.138650010182859	0.138650010182859	false	false	false	true	false
e8df4439-03fc-4697-9ee0-a1125b032b12	2026-08-31 10:35	2026-08-31 10:35	2026-08-31 10:35	SPXW	SPXW260831C07640000	call	7640.0000	2026-08-31	29.9000	29.8000	30.1000	7666.5600	173420.00	161460.00	8970.00	58	7	644	137	4.7007299270073	0.159597318870446	0.159597318870446	false	false	false	true	false
652e7abb-7d74-4704-a3dc-0cd6b521b46b	2026-08-31 10:37	2026-08-31 10:36	2026-08-31 10:37	SPXW	SPXW260831C07670000	call	7670.0000	2026-08-31	12.0000	11.9000	12.1000	7672.8400	188410.00	188410.00	0.00	157	31	10741	978	10.9826175869121	0.137340065270561	0.138670531502817	false	false	false	true	false
312df8a2-c50c-4220-9d1b-5d467a3b38d1	2026-08-31 10:37	2026-08-31 10:37	2026-08-31 10:37	SPXW	SPXW260831C07670000	call	7670.0000	2026-08-31	12.5000	12.4000	12.6000	7673.8300	111260.00	111260.00	0.00	89	6	11043	978	11.2914110429448	0.136809815503945	0.138144551464707	false	false	false	true	false
83f93d6e-a23d-4c31-9470-b2aa6efdaa3e	2026-08-31 10:41	2026-08-31 10:41	2026-08-31 10:41	SPXW	SPXW260901C07670000	call	7670.0000	2026-09-01	23.5000	23.4000	23.7000	7676.8100	235000.00	70500.00	164500.00	100	17	732	130	5.63076923076923	0.121421893059851	0.121421893059851	false	false	false	true	false
687bcb4c-f1a7-490b-ba91-d1418ade9386	2026-08-31 10:43	2026-08-31 10:43	2026-08-31 10:43	SPXW	SPXW260901C07675000	call	7675.0000	2026-09-01	20.3000	20.2000	20.6000	7676.8300	101500.00	24360.00	77140.00	50	10	1957	343	5.70553935860058	0.118246144171887	0.118246144171887	false	false	false	true	false
037ab354-4b3e-4a07-accd-30183e993d57	2026-08-31 10:43	2026-08-31 10:43	2026-08-31 10:43	SPXW	SPXW260831P07680000	put	7680.0000	2026-08-31	11.3600	11.2000	11.4000	7676.9000	113600.00	113600.00	0.00	100	27	21247	1920	11.0661458333333	0.129918002959709	0.129918002959709	false	false	false	true	false
fe399f18-131a-4b70-9ae8-6ce1aad4f5e5	2026-08-31 10:44	2026-08-31 10:43	2026-08-31 10:43	SPXW	SPXW260911P07580000	put	7580.0000	2026-09-11	27.5000	27.3000	27.6000	7676.7100	203500.00	68750.00	134750.00	74	7	109	409	0.266503667481663	0.127915380423427	0.127915380423427	false	false	false	true	false
0d1ed569-b6e4-40a7-94a5-137cee650155	2026-08-31 10:44	2026-08-31 10:44	2026-08-31 10:44	SPXW	SPXW260901C07675000	call	7675.0000	2026-09-01	20.2000	20.1000	20.4000	7676.2400	101000.00	0.00	101000.00	50	10	2013	343	5.86880466472303	0.119540955155391	0.119540955155391	false	false	false	true	false
b7f02430-28e6-492c-a83c-2d4d623474e4	2026-08-31 10:46	2026-08-31 10:46	2026-08-31 10:46	SPXW	SPXW260831C07680000	call	7680.0000	2026-08-31	7.2600	7.1000	7.3000	7674.6100	132210.00	132210.00	0.00	182	38	26560	384	69.1666666666667	0.128012873983251	0.128012873983251	false	false	false	true	false
0e0b6950-a594-4aed-861d-56d7a3213d6f	2026-08-31 10:51	2026-08-31 10:51	2026-08-31 10:51	SPXW	SPXW260831C07660000	call	7660.0000	2026-08-31	18.7000	18.6000	18.8000	7673.6800	187000.00	7480.00	175780.00	100	6	5801	1799	3.22456920511395	0.13936542701735	0.13936542701735	false	false	false	true	false
ff2b2851-62e2-4459-a2c1-fc0c3b00eec1	2026-08-31 10:51	2026-08-31 10:51	2026-08-31 10:51	SPXW	SPXW260831C07660000	call	7660.0000	2026-08-31	18.2700	18.0000	18.4000	7672.9300	182680.00	182680.00	0.00	100	21	5905	1799	3.28237909949972	0.139778671434884	0.142836206712369	false	false	false	true	false
f06e0dae-2862-495a-9807-6d76a4f7cbc4	2026-08-31 10:54	2026-08-31 10:54	2026-08-31 10:54	SPXW	SPXW260901C07680000	call	7680.0000	2026-09-01	15.9200	15.8000	16.2000	7673.7100	128940.00	47700.00	81240.00	81	12	1906	101	18.8712871287129	0.116114300491967	0.115486108650354	false	false	false	true	false
6e08dfe9-66db-488f-b390-4861796d8fef	2026-08-31 10:55	2026-08-31 10:54	2026-08-31 10:54	SPXW	SPXW260831C07680000	call	7680.0000	2026-08-31	7.6000	7.5000	7.6000	7675.7400	159600.00	159600.00	0.00	210	37	29062	384	75.6822916666667	0.128806806366759	0.128806806366759	false	false	false	true	false
0e33935e-2f7e-4f97-94a5-8e5c6c87254c	2026-08-31 10:56	2026-08-31 10:56	2026-08-31 10:56	SPXW	SPXW260901C07675000	call	7675.0000	2026-09-01	20.5000	20.4000	20.7000	7677.8400	205000.00	106600.00	98400.00	100	14	2376	343	6.92711370262391	0.116163149582505	0.116163149582505	false	false	false	true	false
9feb3ee0-cc26-49e6-879c-8fd47894aa8a	2026-08-31 10:57	2026-08-31 10:57	2026-08-31 10:57	SPXW	SPXW260831C07675000	call	7675.0000	2026-08-31	11.6700	11.5000	11.7000	7678.5700	145830.00	129590.00	0.00	125	27	25009	734	34.0722070844687	0.130766970654415	0.132143370809729	false	false	false	true	false
85b33b1e-735e-4849-a855-79d8485dc471	2026-08-31 10:57	2026-08-31 10:57	2026-08-31 10:57	SPXW	SPXW260831C07680000	call	7680.0000	2026-08-31	9.3100	9.2000	9.4000	7679.0300	103350.00	72660.00	0.00	111	19	30598	384	79.6822916666667	0.131848106379424	0.133208824407431	false	false	false	true	false
e91d70b4-805f-4c7b-bd5e-dc2a909acaf0	2026-08-31 10:57	2026-08-31 10:57	2026-08-31 10:57	SPXW	SPXW260831C07680000	call	7680.0000	2026-08-31	9.8400	9.8000	10.1000	7680.7200	101340.00	1010.00	99330.00	103	14	31187	384	81.2161458333333	0.131318442841628	0.128594561413432	false	false	false	true	false