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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 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

54c40585-e748-4864-b22a-b38593af71ca	2026-08-20 14:18	2026-08-20 14:17	2026-08-20 14:18	SPXW	SPXW260820P07640000	put	7640.0000	2026-08-20	2.9000	2.9000	2.9500	7651.3300	125280.00	0.00	125280.00	432	64	56281	1914	29.4049111807733	0.169601423587619	0.169615209963424	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-20T18:45:57.711481Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
f4b6dd51-b105-46b0-9f6e-2124568905f2	2026-08-20 14:19	2026-08-20 14:19	2026-08-20 14:19	SPXW	SPXW260820C07635000	call	7635.0000	2026-08-20	22.1000	22.1000	22.2000	7654.8900	190060.00	0.00	190060.00	86	11	1900	64	29.6875	0.20714412250659	0.20714412250659	false	false	false	true	false
7c98ea12-8311-4a88-bd5a-169ddc5aa107	2026-08-20 14:21	2026-08-20 14:21	2026-08-20 14:21	SPXW	SPXW260820C07635000	call	7635.0000	2026-08-20	23.5000	23.2000	23.8000	7656.5400	235000.00	197400.00	37600.00	100	22	2015	64	31.484375	0.210220897318654	0.210220897318654	false	false	false	true	false
00b6c561-e3c3-40dd-b45e-e9c090ba5c15	2026-08-20 14:23	2026-08-20 14:23	2026-08-20 14:23	SPXW	SPXW260824C07700000	call	7700.0000	2026-08-24	12.4100	12.3000	12.6000	7656.5600	255580.00	155000.00	96830.00	206	17	3273	542	6.03874538745387	0.0878704382687841	0.0875032270028321	false	false	false	true	false
ae789db3-dd0b-43a6-9bcf-667964c8a80a	2026-08-20 14:23	2026-08-20 14:23	2026-08-20 14:23	SPXW	SPXW260825P07675000	put	7675.0000	2026-08-25	42.6100	42.5000	42.9000	7656.3700	426100.00	340800.00	85300.00	100	9	410	457	0.897155361050328	0.0974651525011507	0.0971817197476122	false	false	false	true	false
6d6eba4b-a7cc-49a9-9e31-2c415eb125d8	2026-08-20 14:25	2026-08-20 14:25	2026-08-20 14:25	SPXW	SPXW260824P07675000	put	7675.0000	2026-08-24	38.8000	38.7000	39.0000	7654.4500	582000.00	550960.00	31040.00	150	8	687	443	1.55079006772009	0.0915316274280675	0.0915316274280675	false	false	false	true	false
796ce6f1-414e-4370-af3a-f9a43256fe97	2026-08-20 14:26	2026-08-20 14:26	2026-08-20 14:26	SPXW	SPXW260824C07685000	call	7685.0000	2026-08-24	17.3100	17.2000	17.5000	7654.0000	150630.00	53630.00	97000.00	87	11	459	54	8.5	0.0912763091083498	0.0909405951713608	false	false	false	true	false
b8c76ff1-4e94-4397-b1d2-50de3570058a	2026-08-20 14:27	2026-08-20 14:27	2026-08-20 14:27	SPXW	SPXW260820P07670000	put	7670.0000	2026-08-20	16.8000	16.8000	17.0000	7653.5900	161280.00	0.00	161280.00	96	7	80428	1635	49.1914373088685	0.11548831535674	0.11548831535674	false	false	false	true	false
2ad5bf0f-9d9f-4111-917c-bfa9fcf7f6c5	2026-08-20 14:34	2026-08-20 14:34	2026-08-20 14:34	SPXW	SPXW260820P07650000	put	7650.0000	2026-08-20	4.8200	4.7000	5.0000	7651.3600	133410.00	130590.00	2820.00	277	33	104758	4749	22.0589597810065	0.137880389788961	0.145631051046706	false	false	false	true	false
bf0380cb-37ee-421b-9ff6-2d8e7c9754ce	2026-08-20 14:49	2026-08-20 14:49	2026-08-20 14:49	SPXW	SPXW260828P07575000	put	7575.0000	2026-08-28	28.8000	28.6000	28.8000	7656.1100	230400.00	230400.00	0.00	80	10	656	938	0.699360341151386	0.140335461827561	0.140335461827561	false	false	false	true	false
dbe4d1fa-a726-4ef5-bda9-6d18fea38cc9	2026-08-20 14:49	2026-08-20 14:49	2026-08-20 14:49	SPXW	SPXW260821P07665000	put	7665.0000	2026-08-21	24.7000	24.6000	24.7000	7656.2300	170430.00	170430.00	0.00	69	9	3516	2717	1.29407434670593	0.12793289662342	0.12793289662342	false	false	false	true	false
44ef7d28-c61e-4699-943d-1e3ca34b1711	2026-08-20 15:06	2026-08-20 15:06	2026-08-20 15:06	SPXW	SPXW260911C07700000	call	7700.0000	2026-09-11	75.4600	75.4000	76.0000	7654.0000	377300.00	0.00	377300.00	50	6	497	2113	0.235210601041174	0.118551282146496	0.118417028718997	false	false	false	true	false
6d4e40ec-1334-4709-81e9-b0314852b080	2026-08-20 15:18	2026-08-20 15:18	2026-08-20 15:18	SPXW	SPXW261231P07325000	put	7325.0000	2026-12-31	151.3000	151.3000	151.6000	7653.1000	363120.00	0.00	363120.00	24	5	75	46	1.6304347826087	0.180192688623005	0.180192688623005	false	false	false	true	false
6f97b839-8abd-4a70-be7b-e836045d2ec1	2026-08-20 15:19	2026-08-20 15:19	2026-08-20 15:19	SPXW	SPXW260820P07750000	put	7750.0000	2026-08-20	98.0000	97.2000	101.8000	7651.8200	196000.00	176340.00	19660.00	20	6	1346	2057	0.654350996596986	0.389633538912208	0.389633538912208	false	false	false	true	false
3ea42815-8340-4d3f-a7e7-3b40599c8c31	2026-08-20 15:23	2026-08-20 15:23	2026-08-20 15:23	SPXW	SPXW260831C07690000	call	7690.0000	2026-08-31	46.5000	46.3000	46.5000	7653.2500	102300.00	102300.00	0.00	22	9	81	380	0.213157894736842	0.111980565494331	0.111980565494331	false	false	false	true	false
1335c0be-8ffd-40b2-80f2-d835c4dc898f	2026-08-20 15:31	2026-08-20 15:31	2026-08-20 15:31	SPXW	SPXW260820P07710000	put	7710.0000	2026-08-20	57.5800	55.3000	58.5000	7651.2600	115160.00	34420.00	80740.00	20	6	4959	1295	3.82934362934363	0.28441086908813	0.28441086908813	false	false	false	true	false
c4632687-4353-47fb-8eb8-2797cc959ced	2026-08-20 15:34	2026-08-20 15:34	2026-08-20 15:34	SPXW	SPXW260820P07670000	put	7670.0000	2026-08-20	19.5000	19.4000	19.8000	7650.0600	142360.00	93600.00	48760.00	73	16	82510	1635	50.4648318042813	0	0	false	false	false	true	false
d0a02886-351a-4af2-9c89-02fffb3ece5e	2026-08-20 15:36	2026-08-20 15:36	2026-08-20 15:36	SPXW	SPXW260820P07670000	put	7670.0000	2026-08-20	17.5400	17.4000	17.9000	7651.0600	280560.00	120750.00	159810.00	160	16	82722	1635	50.594495412844	0.14764078669565	0.14764078669565	false	false	false	true	false
3a874d80-d7f6-499a-a6ad-ce54ae7b58c0	2026-08-20 15:36	2026-08-20 15:36	2026-08-20 15:36	SPXW	SPXW260904C07675000	call	7675.0000	2026-09-04	70.8000	70.8000	71.2000	7652.5000	233640.00	0.00	233640.00	33	7	273	191	1.42931937172775	0.122704368744119	0.122704368744119	false	false	false	true	false
4576cb2f-fea2-45a9-84f7-582fba118394	2026-08-20 15:41	2026-08-20 15:40	2026-08-20 15:40	SPXW	SPXW260821C07655000	call	7655.0000	2026-08-21	21.2000	21.2000	21.4000	7652.5100	106000.00	0.00	106000.00	50	9	1990	137	14.5255474452555	0.137905695477075	0.137905695477075	false	false	false	true	false
dd21e605-9b84-405b-b6e7-8b261464a302	2026-08-20 15:41	2026-08-20 15:41	2026-08-20 15:41	SPXW	SPXW260828C07670000	call	7670.0000	2026-08-28	50.5000	50.5000	50.6000	7652.5200	232300.00	0.00	232300.00	46	5	182	82	2.21951219512195	0.123582030967212	0.123582030967212	false	false	false	true	false
911a623f-8ace-453a-baf3-6bac02854f86	2026-08-20 15:41	2026-08-20 15:41	2026-08-20 15:41	SPXW	SPXW260828C07655000	call	7655.0000	2026-08-28	59.1000	59.1000	59.2000	7652.5200	295500.00	0.00	295500.00	50	5	154	48	3.20833333333333	0.12649691842381	0.12649691842381	false	false	false	true	false
051a3c82-17e5-4572-a842-32783fc9e604	2026-08-20 15:45	2026-08-20 15:45	2026-08-20 15:45	SPXW	SPXW260821C07650000	call	7650.0000	2026-08-21	22.1900	21.9000	22.3000	7646.9900	110960.00	86540.00	24420.00	50	8	1912	1004	1.90438247011952	0.145225044586317	0.14585166020125	false	false	false	true	false
2c079862-1e14-4b85-b8ca-80d167414114	2026-08-20 15:47	2026-08-20 15:47	2026-08-20 15:47	SPXW	SPXW260821C07650000	call	7650.0000	2026-08-21	22.6000	22.5000	22.8000	7647.6200	113000.00	79100.00	33900.00	50	7	2014	1004	2.00597609561753	0.146429415651316	0.146429415651316	false	false	false	true	false
b5696742-5a4b-4c80-964e-07be49a8dbcc	2026-08-20 15:47	2026-08-20 15:47	2026-08-20 15:47	SPXW	SPXW260824C07650000	call	7650.0000	2026-08-24	32.6000	32.4000	32.7000	7648.4500	795440.00	74980.00	720460.00	244	16	623	222	2.80630630630631	0.0995293465939164	0.0995293465939164	false	false	false	true	false
0c86cc40-0c2b-43aa-8dac-d458d6a1e75b	2026-08-20 15:49	2026-08-20 15:49	2026-08-20 15:49	SPXW	SPXW260820P07645000	put	7645.0000	2026-08-20	1.2100	1.1000	1.3500	7649.7200	121330.00	50155.00	69735.00	1002	91	94927	4293	22.1120428604705	0.21009977791951	0.223366523236911	false	false	false	true	false
e6a493d7-6cfa-4bca-8009-5f1d6c7a7922	2026-08-20 15:49	2026-08-20 15:49	2026-08-20 15:49	SPXW	SPXW260825C07725000	call	7725.0000	2026-08-25	8.3000	8.2000	8.5000	7650.4800	207500.00	149400.00	58100.00	250	15	426	119	3.57983193277311	0.0889000763571576	0.0889000763571576	false	false	false	true	false
f2f75ca2-3c01-4d2d-9989-73195ea77b46	2026-08-20 15:54	2026-08-20 15:54	2026-08-20 15:54	SPXW	SPXW260824P07675000	put	7675.0000	2026-08-24	40.0000	39.9000	40.0000	7650.9900	120000.00	120000.00	0.00	30	9	1366	443	3.08352144469526	0.0886682857145155	0.0886682857145155	false	false	false	true	false
2c362938-80c0-4a26-b088-b8d2e2d0248f	2026-08-20 15:55	2026-08-20 15:55	2026-08-20 15:55	SPXW	SPXW260904P07625000	put	7625.0000	2026-09-04	64.1200	63.9000	64.8000	7645.5400	243660.00	96000.00	147660.00	38	5	197	321	0.613707165109034	0.128565742276094	0.128237246229071	false	false	false	true	false
a55a5b88-8866-46b3-8e41-a4690ff39c8d	2026-08-20 15:55	2026-08-20 15:55	2026-08-20 15:55	SPXW	SPXW260828C07675000	call	7675.0000	2026-08-28	45.3000	45.3000	45.8000	7646.2200	158550.00	0.00	158550.00	35	7	420	586	0.716723549488055	0.123389377113605	0.123389377113605	false	false	false	true	false
5edb0a7a-cea4-432f-9680-3d813e781f95	2026-08-20 15:56	2026-08-20 15:55	2026-08-20 15:55	SPXW	SPXW260820P07645000	put	7645.0000	2026-08-20	3.3700	3.0000	3.8000	7642.2200	130540.00	48290.00	81570.00	387	134	109002	4293	25.3906359189378	0.203347702995028	0.164096710424382	true	false	false	true	false
fe560bb1-21bc-4b91-a501-f15123f91725	2026-08-20 15:57	2026-08-20 15:56	2026-08-20 15:56	SPXW	SPXW260820P07650000	put	7650.0000	2026-08-20	7.2000	6.9000	7.3000	7642.4100	118060.00	116650.00	1410.00	164	19	179133	4749	37.7201516108654	0	0	false	false	false	true	false
93eeb252-bc2b-4bd9-8c8c-0ff0acb14724	2026-08-20 15:57	2026-08-20 15:57	2026-08-20 15:57	SPXW	SPXW260824C07650000	call	7650.0000	2026-08-24	29.4000	29.4000	29.5000	7641.1100	294000.00	0.00	294000.00	100	6	1060	222	4.77477477477477	0.100815541375613	0.100815541375613	false	false	false	true	false
b40f8772-830e-4290-8b69-5086db46fd52	2026-08-20 16:00	2026-08-20 16:00	2026-08-20 16:00	SPXW	SPXW260901P07640000	put	7640.0000	2026-09-01	59.7000	59.6000	60.1000	7641.8200	286560.00	0.00	286560.00	48	5	63	296	0.212837837837838	0.118014429481837	0.118014429481837	false	false	false	true	false
d9281ee1-1d15-4d50-b15d-4e3901ba084a	2026-08-20 16:01	2026-08-20 16:00	2026-08-20 16:00	SPXW	SPXW260825C07675000	call	7675.0000	2026-08-25	24.1000	24.0000	24.5000	7641.8100	361500.00	260280.00	101220.00	150	13	527	333	1.58258258258258	0.10317856826175	0.10317856826175	false	false	false	true	false
f155152c-6397-4676-aa90-27c5016dfff3	2026-08-20 16:02	2026-08-20 16:02	2026-08-20 16:02	SPXW	SPXW260923C07850000	call	7850.0000	2026-09-23	36.5900	37.4000	37.9000	7641.6300	5488500.00	0.00	0.00	1500	12	2603	69	37.7246376811594	0.108956167520191	0.108956167520191	false	false	false	true	false
7ad41f57-70dd-4804-a383-61ac7224c755	2026-08-20 16:03	2026-08-20 16:03	2026-08-20 16:03	SPXW	SPXW260821P07670000	put	7670.0000	2026-08-21	31.4000	31.3000	31.6000	7641.6300	144440.00	25120.00	119320.00	46	12	4062	1520	2.67236842105263	0.0832288713320428	0.0832288713320428	false	false	false	true	false
66428703-08c2-45e2-9203-3ce6beb0fe2e	2026-08-20 16:03	2026-08-20 16:03	2026-08-20 16:03	SPXW	SPXW260821P07640000	put	7640.0000	2026-08-21	17.5000	17.3000	17.6000	7641.6300	122500.00	66500.00	56000.00	70	15	5321	6505	0.817986164488855	0.117112723030402	0.117112723030402	false	false	false	true	false
b8ab22ed-3dbc-427c-b191-6ed43729eeef	2026-08-20 16:22	2026-08-20 16:16	2026-08-20 16:16	SPXW	SPXW260825P07620000	put	7620.0000	2026-08-25	27.7000	27.2000	27.8000	7641.1600	110800.00	83100.00	27700.00	40	6	338	255	1.32549019607843	0.109400508457227	0.109400508457227	false	false	false	true	false
bc2739ab-4236-47d0-b901-0aa5c2b12359	2026-08-20 16:39	2026-08-20 16:22	2026-08-20 16:22	SPXW	SPXW260824C07625000	call	7625.0000	2026-08-24	44.0000	43.8000	44.2000	7641.1600	220000.00	0.00	198000.00	50	10	204	599	0.340567612687813	0.104991791829795	0.104991791829795	false	false	false	true	false
59c6e850-0d4b-4177-9df2-c2f139ffa8f4	2026-08-21 09:31	2026-08-21 09:31	2026-08-21 09:31	SPXW	SPXW260821P07670000	put	7670.0000	2026-08-21	12.9000	12.8000	13.0000	7671.4100	107080.00	1300.00	41280.00	83	5	401	1623	0.247073321010474	0.165827432353332	0.164624226544063	false	false	false	true	false
ca48b108-95ec-45b0-a4b4-cea1b64e4f16	2026-08-21 09:32	2026-08-21 09:31	2026-08-21 09:31	SPXW	SPXW260821C07655000	call	7655.0000	2026-08-21	23.5300	23.4000	23.7000	7672.5500	117670.00	18880.00	98790.00	50	8	117	705	0.165957446808511	0.152728347964029	0.154133260693661	true	false	false	true	false
97756510-8297-4c37-80ff-54a5fd777fdf	2026-08-21 09:34	2026-08-21 09:34	2026-08-21 09:34	SPXW	SPXW260821P07670000	put	7670.0000	2026-08-21	13.9000	13.8000	13.9000	7670.6400	111200.00	111200.00	0.00	80	20	1695	1623	1.04436229205176	0.172833271232913	0.172833271232913	false	false	false	true	false
f92f5419-af7b-4d33-a751-f8a06bf16699	2026-08-21 09:36	2026-08-21 09:36	2026-08-21 09:36	SPXW	SPXW260821C07665000	call	7665.0000	2026-08-21	14.6000	14.4000	14.7000	7667.9100	147450.00	96370.00	0.00	101	17	1152	965	1.19378238341969	0.155788335683989	0.158218886364906	false	false	false	true	false
cabb25e7-a9d8-45d6-a6a9-00b451b62e02	2026-08-21 09:36	2026-08-21 09:36	2026-08-21 09:36	SPXW	SPXW260821C07640000	call	7640.0000	2026-08-21	30.9000	30.8000	31.1000	7666.4600	145250.00	0.00	24720.00	47	5	224	679	0.329896907216495	0.166554698048191	0.164916965492001	false	false	false	true	false
b4602ba7-fc04-460b-9653-7edd1ea40bf4	2026-08-21 09:40	2026-08-21 09:40	2026-08-21 09:40	SPXW	SPXW260930P07550000	put	7550.0000	2026-09-30	81.7900	81.2000	81.8000	7670.7500	515260.00	515260.00	0.00	63	12	110	3442	0.031958163858222	0.144818962997574	0.144927775950331	false	false	false	true	false
c5d37699-f1b3-412c-9524-f71aec4c4323	2026-08-21 09:40	2026-08-21 09:40	2026-08-21 09:40	SPXW	SPXW260821C07665000	call	7665.0000	2026-08-21	16.1000	16.0000	16.1000	7670.7000	161000.00	161000.00	0.00	100	7	1932	965	2.0020725388601	0.157321345179377	0.157321345179377	false	false	false	true	false
5ab616c1-adec-4e19-b9c5-12eb181e1bd3	2026-08-21 09:46	2026-08-21 09:46	2026-08-21 09:46	SPXW	SPXW260821C07670000	call	7670.0000	2026-08-21	12.2000	12.1000	12.3000	7670.8900	122000.00	62220.00	59780.00	100	16	4809	976	4.92725409836066	0.142680036460839	0.142680036460839	false	false	false	true	false
44b1544c-c96b-41f0-93f7-e00e0971cd78	2026-08-21 09:47	2026-08-21 09:47	2026-08-21 09:47	SPXW	SPXW260821C07670000	call	7670.0000	2026-08-21	10.8000	10.7000	10.9000	7668.0500	108000.00	0.00	60480.00	100	18	5388	976	5.52049180327869	0.143090513125843	0.143093770287719	false	false	false	true	false
8b7319aa-1012-4132-8e46-14bdd55d14f0	2026-08-21 09:48	2026-08-21 09:48	2026-08-21 09:48	SPXW	SPXW260821C07670000	call	7670.0000	2026-08-21	11.5100	11.4000	11.6000	7668.7400	127750.00	127750.00	0.00	111	24	5696	976	5.83606557377049	0.149026163993926	0.148942372632263	false	false	false	true	false