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

b2c07c4e-6dad-40c8-b55c-66c54fb429c5	2026-08-27 15:19	2026-08-27 15:19	2026-08-27 15:19	SPXW	SPXW260901C07725000	call	7725.0000	2026-09-01	32.5400	32.4000	32.7000	7700.0000	325440.00	123880.00	182000.00	100	13	1087	169	6.43195266272189	0.0911506418922468	0.0911506418922468	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	—	—	—	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T19:35:44.109119Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f8314322-c6b1-4326-9309-c3a7e058222f	2026-08-27 15:24	2026-08-27 15:24	2026-08-27 15:24	SPXW	SPXW260901P07725000	put	7725.0000	2026-09-01	35.9000	35.7000	36.0000	7700.0000	359000.00	64620.00	294380.00	100	5	756	214	3.53271028037383	0.0984429994739556	0.0984429994739556	false	false	false	true	false
4e592b76-5c1a-4120-854c-96304e20f900	2026-08-27 15:24	2026-08-27 15:24	2026-08-27 15:24	SPXW	SPXW260827C07710000	call	7710.0000	2026-08-27	10.3000	10.1000	10.4000	7700.0000	103000.00	33990.00	69010.00	100	10	56155	1324	42.4131419939577	0.155193920805379	0.155193920805379	false	false	false	true	false
597e16f4-baea-4514-b98b-77e7c202aa42	2026-08-27 15:24	2026-08-27 15:24	2026-08-27 15:24	SPXW	SPXW260901P07725000	put	7725.0000	2026-09-01	36.1300	33.8000	36.6000	7700.0000	317910.00	43200.00	274710.00	88	19	856	214	4	0.0986039838062268	0.0977716250540752	false	false	false	true	false
81f9bda7-7957-43d5-831f-029bc7e05854	2026-08-27 15:28	2026-08-27 15:28	2026-08-27 15:28	SPXW	SPXW260901P07720000	put	7720.0000	2026-09-01	34.8000	34.7000	34.9000	7695.0000	348000.00	267960.00	0.00	100	8	1797	89	20.1910112359551	0.098345050655516	0.098345050655516	false	false	false	true	false
769dae0f-2378-4400-b242-e3913ca8087d	2026-08-27 15:31	2026-08-27 15:31	2026-08-27 15:31	SPXW	SPXW260901P07720000	put	7720.0000	2026-09-01	32.9000	32.8000	32.9000	7700.0000	329000.00	329000.00	0.00	100	5	1997	89	22.438202247191	0.0968714005629387	0.0968714005629387	false	false	false	true	false
39f41ecd-f74f-4c7a-9eaa-29c22210bd0c	2026-08-27 15:34	2026-08-27 15:34	2026-08-27 15:34	SPXW	SPXW260901P07720000	put	7720.0000	2026-09-01	32.0000	31.9000	32.2000	7700.0000	192000.00	0.00	192000.00	60	7	2184	89	24.5393258426966	0.0964184565070914	0.0964184565070914	false	false	false	true	false
8d0dd46e-0d46-4529-ae9c-78123a17f6f1	2026-08-27 15:36	2026-08-27 15:35	2026-08-27 15:35	SPXW	SPXW260901P07725000	put	7725.0000	2026-09-01	33.3000	33.1000	33.4000	7723.6900	333000.00	143190.00	189810.00	100	9	957	214	4.47196261682243	0.0960352322743511	0.0960352322743511	false	false	false	true	false
0225841a-ca0e-4180-8410-1e40feff59c7	2026-08-27 15:39	2026-08-27 15:39	2026-08-27 15:39	SPXW	SPXW260901P07725000	put	7725.0000	2026-09-01	33.6000	33.5000	33.6000	7723.5800	235200.00	235200.00	0.00	70	7	1028	214	4.80373831775701	0.0967193908922763	0.0967193908922763	false	false	false	true	false
be1a41fd-a250-4251-86ad-7a855ccf8fc0	2026-08-27 15:43	2026-08-27 15:43	2026-08-27 15:43	SPXW	SPXW260901C07725000	call	7725.0000	2026-09-01	33.2000	33.0000	33.3000	7723.2100	192560.00	146080.00	23240.00	58	12	1458	169	8.62721893491124	0.0889810905194321	0.0889810905194321	false	false	false	true	false
c3b3d0eb-71b4-4b3f-892a-86b5a4dae8d5	2026-08-27 15:49	2026-08-27 15:49	2026-08-27 15:49	SPXW	SPXW260901P07730000	put	7730.0000	2026-09-01	34.3000	34.1000	34.4000	7726.1600	343000.00	157780.00	185220.00	100	9	509	138	3.68840579710145	0.0953037106060516	0.0953037106060516	false	false	false	true	false
8f0ac971-5982-4148-b55f-23e8cbb356bb	2026-08-27 15:50	2026-08-27 15:50	2026-08-27 15:50	SPXW	SPXW260901P07730000	put	7730.0000	2026-09-01	35.6000	35.5000	35.8000	7723.3500	320400.00	224280.00	96120.00	90	7	609	138	4.41304347826087	0.0949849307665085	0.0949849307665085	false	false	false	true	false
13ecfc9d-1b54-4933-842c-ed2fccd93f2b	2026-08-27 15:51	2026-08-27 15:51	2026-08-27 15:51	SPXW	SPXW260901P07725000	put	7725.0000	2026-09-01	34.1300	33.8000	34.3000	7722.9800	341290.00	341290.00	0.00	100	17	1307	214	6.10747663551402	0.0972953009857362	0.0975727216707343	true	false	false	true	false
e3301118-42b9-43bf-bfc0-fcded3670b3a	2026-08-27 15:52	2026-08-27 15:52	2026-08-27 15:52	SPXW	SPXW260901P07725000	put	7725.0000	2026-09-01	31.5000	31.4000	31.5000	7727.4500	201600.00	201600.00	0.00	64	5	1409	214	6.58411214953271	0.0960148731939988	0.0960148731939988	false	false	false	true	false
94104c49-fe3e-4f42-b517-3c2a84769f00	2026-08-27 15:53	2026-08-27 15:52	2026-08-27 15:52	SPXW	SPXW260827C07725000	call	7725.0000	2026-08-27	3.7900	3.4000	4.0000	7727.4400	141830.00	70320.00	65220.00	374	247	181425	4314	42.0549374130737	0.19764203690752	0.201262956620596	false	false	false	true	false
518738c4-bc7d-47e1-add2-cf82af2f63e6	2026-08-27 15:53	2026-08-27 15:53	2026-08-27 15:53	SPXW	SPXW260827C07725000	call	7725.0000	2026-08-27	4.2900	3.9000	4.6000	7728.1500	133420.00	57890.00	69020.00	311	181	181872	4314	42.1585535465925	0.21256554827179	0.234125742961729	false	false	false	true	false
9f53eaad-5e50-4a89-88fc-30407a5d50f5	2026-08-27 15:54	2026-08-27 15:54	2026-08-27 15:54	SPXW	SPXW260827C07730000	call	7730.0000	2026-08-27	2.5400	2.3500	2.8000	7730.4400	151330.00	53355.00	92380.00	595	220	220218	2566	85.82151208106	0.226812438804006	0.256760561871774	false	false	false	true	false
8ca3ae15-1f88-4193-8d06-54653698de56	2026-08-27 15:54	2026-08-27 15:54	2026-08-27 15:54	SPXW	SPXW260827C07725000	call	7725.0000	2026-08-27	5.6500	5.4000	5.8000	7730.2300	141140.00	89600.00	50410.00	250	87	184891	4314	42.8583681038479	0.255262176494809	0.217055778682853	false	false	false	true	false
3b19785a-1814-4721-bd9a-dcf973148505	2026-08-27 15:54	2026-08-27 15:54	2026-08-27 15:54	SPXW	SPXW260827C07730000	call	7730.0000	2026-08-27	2.0700	1.7000	2.5000	7730.2300	146265.00	112260.00	28185.00	706	385	219601	2566	85.5810600155885	0.199313029817553	0.231898637196976	false	false	false	true	false
3e212f8b-aa69-4eff-9adf-e143eb0e3e7f	2026-08-27 15:55	2026-08-27 15:54	2026-08-27 15:54	SPXW	SPXW260911P07610000	put	7610.0000	2026-09-11	27.6000	27.4000	28.0000	7731.7500	151800.00	41400.00	110400.00	55	11	158	557	0.283662477558348	0.123496104449384	0.123496104449384	false	false	false	true	false
9a5e08d5-2f28-42bd-9787-c12321c98581	2026-08-27 16:00	2026-08-27 15:59	2026-08-27 15:59	SPXW	SPXW260904P07650000	put	7650.0000	2026-09-04	22.3800	21.8000	22.5000	7729.7100	154420.00	87220.00	67200.00	69	8	2903	3441	0.843650101714618	0.120759571248882	0.121295159533251	false	false	false	true	false
1bd54a0e-7f93-42a5-9639-2e437c5da10b	2026-08-27 16:04	2026-08-27 16:03	2026-08-27 16:03	SPXW	SPXW260828C07740000	call	7740.0000	2026-08-28	14.7900	14.6000	14.9000	7730.8200	147940.00	75480.00	63640.00	100	13	5403	904	5.97676991150442	0.115080519772166	0.115709669920733	false	false	false	true	false
6fd07b51-7521-4cfe-903d-35d3804a7a83	2026-08-27 16:09	2026-08-27 16:08	2026-08-27 16:08	SPXW	SPXW260828C07770000	call	7770.0000	2026-08-28	4.3100	4.2000	4.5000	7730.9900	129320.00	76110.00	52770.00	300	22	6011	1990	3.02060301507538	0.105898743423388	0.104977972024948	false	false	false	true	false
2456063a-205d-44eb-a22b-5b1740df9406	2026-08-27 16:14	2026-08-27 16:13	2026-08-27 16:13	SPXW	SPXW260828P07725000	put	7725.0000	2026-08-28	21.3100	20.9000	21.5000	7730.9900	257840.00	257840.00	0.00	121	20	5095	1539	3.31059129304743	0.15087859821853	0.153372637307586	false	false	false	true	false
4ef49e1b-4b35-430f-8f2e-80905c6d8092	2026-08-27 16:14	2026-08-27 16:14	2026-08-27 16:14	SPXW	SPXW260904C07725000	call	7725.0000	2026-09-04	49.8200	49.8000	50.3000	7730.9900	124560.00	0.00	124560.00	25	8	1158	860	1.34651162790698	0.095140795338238	0.095140795338238	false	false	false	true	false
48771725-e3ec-4bab-b735-676ae4ae728c	2026-08-27 16:19	2026-08-27 16:14	2026-08-27 16:14	SPXW	SPXW260904P07725000	put	7725.0000	2026-09-04	46.8000	46.7000	47.1000	7730.9900	117000.00	88920.00	28080.00	25	6	431	1841	0.234111895708854	0.115681829521879	0.115681829521879	false	false	false	true	false
d16fc7f7-efcc-4322-89c1-6b6bea4c9bc6	2026-08-28 09:32	2026-08-28 09:32	2026-08-28 09:32	SPXW	SPXW260831C07740000	call	7740.0000	2026-08-31	23.3000	23.3000	23.7000	7736.8900	202750.00	0.00	202750.00	87	12	288	1267	0.227308602999211	0.0848405026805713	0.0848405026805713	false	false	false	true	false
292ef0f4-f66a-4eb7-82a9-81edce0e187a	2026-08-28 09:35	2026-08-28 09:35	2026-08-28 09:35	SPXW	SPXW260828C07720000	call	7720.0000	2026-08-28	28.5200	28.5000	28.8000	7739.4800	114080.00	0.00	114080.00	40	14	290	1978	0.146612740141557	0.203322414126617	0.203322414126617	false	false	false	true	false
f90961ef-bf04-488b-a681-97d5cef6d6aa	2026-08-28 09:35	2026-08-28 09:35	2026-08-28 09:35	SPXW	SPXW260831C07735000	call	7735.0000	2026-08-31	26.3000	26.2000	26.5000	7736.7600	236700.00	202510.00	34190.00	90	5	245	697	0.351506456241033	0.08633340914034	0.08633340914034	false	false	false	true	false
7c600e3d-5030-4bb4-a53b-88cb3abf740d	2026-08-28 09:38	2026-08-28 09:38	2026-08-28 09:38	SPXW	SPXW260828P07735000	put	7735.0000	2026-08-28	14.9000	14.9000	15.0000	7740.3200	119200.00	0.00	119200.00	80	26	2104	463	4.54427645788337	0.210712187365941	0.210712187365941	false	false	false	true	false
94efed80-cee3-4c16-82b4-cc064a03a64f	2026-08-28 09:39	2026-08-28 09:39	2026-08-28 09:39	SPXW	SPXW260828P07785000	put	7785.0000	2026-08-28	47.5900	47.4000	47.7000	7741.1400	104700.00	76140.00	28560.00	22	11	86	539	0.159554730983302	0.213250932346235	0.215182429760582	true	false	false	true	false
e179f122-60da-4c18-846c-c3cbddaa8f72	2026-08-28 09:42	2026-08-28 09:42	2026-08-28 09:42	SPXW	SPXW260828C07755000	call	7755.0000	2026-08-28	11.1000	11.1000	11.2000	7744.4300	107670.00	0.00	107670.00	97	21	1927	2340	0.823504273504273	0.189871485606511	0.189871485606511	false	false	false	true	false
fc12e653-b546-42af-8332-fedf3f46a3d3	2026-08-28 09:43	2026-08-28 09:43	2026-08-28 09:43	SPXW	SPXW260828P07740000	put	7740.0000	2026-08-28	15.0000	14.8000	15.0000	7744.7900	193480.00	192000.00	1480.00	129	33	2449	1348	1.81676557863501	0.207898784886946	0.210334514228882	false	false	false	true	false
06085236-9f1c-4442-a623-c25b18883367	2026-08-28 09:43	2026-08-28 09:43	2026-08-28 09:43	SPXW	SPXW260828C07760000	call	7760.0000	2026-08-28	9.3000	9.3000	9.4000	7744.9200	127410.00	0.00	127410.00	137	31	2568	2966	0.865812542144302	0.188771388606892	0.188771388606892	false	false	false	true	false
5ec2df70-3f4c-4703-aa10-2d1307eee63b	2026-08-28 09:45	2026-08-28 09:45	2026-08-28 09:45	SPXW	SPXW260831C07745000	call	7745.0000	2026-08-31	23.6000	23.6000	23.7000	7743.2600	155760.00	0.00	155760.00	66	5	248	484	0.512396694214876	0.0830434608153766	0.0830434608153766	false	false	false	true	false
c06adefe-697d-476f-b754-c60c0d7c8693	2026-08-28 09:46	2026-08-28 09:46	2026-08-28 09:46	SPXW	SPXW260828P07740000	put	7740.0000	2026-08-28	15.8900	15.8000	16.1000	7741.6700	300410.00	17490.00	171620.00	189	28	3156	1348	2.34124629080119	0.204243098218648	0.203027824006348	false	false	false	true	false
ec710acf-db5d-4cd7-9857-54743f18fd50	2026-08-28 09:47	2026-08-28 09:47	2026-08-28 09:47	SPXW	SPXW260828P07735000	put	7735.0000	2026-08-28	14.3000	14.2000	14.3000	7741.4200	143000.00	143000.00	0.00	100	22	3497	463	7.55291576673866	0.211795876527063	0.211795876527063	true	false	false	true	false
7e25d66e-603b-42fe-8edd-d4409b1cf999	2026-08-28 09:48	2026-08-28 09:47	2026-08-28 09:47	SPXW	SPXW260828P07735000	put	7735.0000	2026-08-28	12.9100	12.9000	13.1000	7743.7300	129120.00	0.00	127820.00	100	17	3708	463	8.00863930885529	0.208153472560464	0.206909185558907	false	false	false	true	false
35a68139-cee1-4602-8169-cee8bef34d07	2026-08-28 09:48	2026-08-28 09:48	2026-08-28 09:48	SPXW	SPXW260831C07745000	call	7745.0000	2026-08-31	23.8600	23.8000	24.2000	7743.8500	238580.00	0.00	238580.00	100	22	377	484	0.778925619834711	0.0834011820505766	0.0826868642030615	false	false	false	true	false
5217d99e-84c8-421b-9aa3-e1cc9341268b	2026-08-28 09:48	2026-08-28 09:48	2026-08-28 09:48	SPXW	SPXW260828P07750000	put	7750.0000	2026-08-28	18.9000	18.9000	19.0000	7745.7800	113400.00	0.00	113400.00	60	9	1542	2724	0.566079295154185	0.204587571108557	0.204587571108557	false	false	false	true	false
5d872929-10ad-4c22-82a2-08680e77b708	2026-08-28 09:48	2026-08-28 09:48	2026-08-28 09:48	SPXW	SPXW260828C07730000	call	7730.0000	2026-08-28	26.0000	25.9000	26.0000	7744.8300	106600.00	106600.00	0.00	41	8	1611	4131	0.389978213507625	0.212716079144535	0.212716079144535	false	false	false	true	false
8896002f-8050-45bf-a565-2106d6381c25	2026-08-28 09:49	2026-08-28 09:49	2026-08-28 09:49	SPXW	SPXW260828P07735000	put	7735.0000	2026-08-28	14.8500	14.6000	14.9000	7740.7800	118790.00	98070.00	0.00	80	20	4080	463	8.81209503239741	0.215233493573251	0.215233493573251	false	false	false	true	false
22e62396-acca-4590-9b54-7d1f02bbfab0	2026-08-28 09:50	2026-08-28 09:50	2026-08-28 09:50	SPXW	SPXW260828P07735000	put	7735.0000	2026-08-28	16.1000	16.1000	16.2000	7737.1200	106260.00	0.00	106260.00	66	21	4505	463	9.73002159827214	0.210686885019119	0.210686885019119	true	false	false	true	false
dfa346df-07e7-4e04-b06d-100dacb11617	2026-08-28 09:51	2026-08-28 09:50	2026-08-28 09:50	SPXW	SPXW260828C07750000	call	7750.0000	2026-08-28	11.5000	11.4000	11.6000	7738.8500	115000.00	70150.00	44850.00	100	24	6580	4562	1.44234984655853	0.200236828198689	0.200236828198689	false	false	false	true	false
ddfa2761-516f-44b0-978e-78e51dd634e1	2026-08-28 09:52	2026-08-28 09:52	2026-08-28 09:52	SPXW	SPXW260904C07845000	call	7845.0000	2026-09-04	7.5000	7.4000	7.7000	7736.4400	243000.00	8250.00	234750.00	324	12	387	1027	0.37682570593963	0.0911626807479321	0.0911626807479321	false	false	false	true	false
4d852b00-cd08-4bf2-a5a2-2cea769dcdbe	2026-08-28 09:53	2026-08-28 09:53	2026-08-28 09:53	SPXW	SPXW260828C07745000	call	7745.0000	2026-08-28	12.9000	12.8000	13.0000	7737.2300	130290.00	0.00	30960.00	101	8	5995	1594	3.76097867001255	0.201080278988444	0.201080278988444	false	false	false	true	false
baa9e9a5-f391-4a24-99e7-6a6240c1226a	2026-08-28 09:53	2026-08-28 09:53	2026-08-28 09:53	SPXW	SPXW260828C07750000	call	7750.0000	2026-08-28	10.7000	10.6000	10.8000	7737.0300	100580.00	0.00	84530.00	94	11	7393	4562	1.62056115738711	0.199802999917814	0.199802999917814	false	false	false	true	false
e529f1a6-9bd7-4c2e-9a45-92a8d1c99431	2026-08-28 09:54	2026-08-28 09:54	2026-08-28 09:54	SPXW	SPXW260828C07485000	call	7485.0000	2026-08-28	252.0000	252.0000	252.7000	7738.1200	403200.00	0.00	403200.00	16	6	19	42	0.452380952380952	0.469246688450934	0.469246688450934	false	false	false	true	false
cb4e91f5-3ace-417e-b194-9148d599bf87	2026-08-28 09:55	2026-08-28 09:55	2026-08-28 09:55	SPXW	SPXW260831C07735000	call	7735.0000	2026-08-31	25.9100	25.8000	26.3000	7736.4100	259100.00	0.00	259100.00	100	23	855	697	1.22668579626973	0.0859206954286622	0.0855624924632823	false	false	false	true	false
9afe07e1-a3bd-4e81-a0d7-c7c2f42247f0	2026-08-28 09:56	2026-08-28 09:56	2026-08-28 09:56	SPXW	SPXW260828C07755000	call	7755.0000	2026-08-28	8.8300	8.8000	8.9000	7737.5100	7064000.00	0.00	0.00	8000	14	12267	2340	5.24230769230769	0.196932415313114	0.196932415313114	false	false	false	true	false