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

d3b858fc-5353-4304-a0e7-fe941958f988	2026-08-19 10:03	2026-08-19 10:02	2026-08-19 10:02	SPXW	SPXW260819C07725000	call	7725.0000	2026-08-19	8.2200	8.1000	8.4000	7717.1400	127360.00	0.00	98310.00	155	30	15406	5879	2.6205136928049	0.144879630937427	0.143589893023605	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-19T14:11:54.267551Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
075ead01-0762-4d3a-8db2-fc511db85668	2026-08-19 10:04	2026-08-19 10:04	2026-08-19 10:04	SPXW	SPXW260819C07720000	call	7720.0000	2026-08-19	10.0000	9.9000	10.0000	7714.9900	189000.00	189000.00	0.00	189	7	13494	951	14.1892744479495	0.15298802582791	0.15298802582791	false	false	false	true	false
e9c76362-732d-4c67-99d5-119fce0a046f	2026-08-19 10:09	2026-08-19 10:09	2026-08-19 10:09	SPXW	SPXW260819C07725000	call	7725.0000	2026-08-19	7.1500	7.1000	7.4000	7714.4500	142940.00	0.00	142940.00	200	38	17195	5879	2.92481714577309	0.146557104661284	0.146557104661284	false	false	false	true	false
964dd37d-8bf8-4099-a9b4-bb6ff16d60ce	2026-08-19 10:11	2026-08-19 10:10	2026-08-19 10:10	SPXW	SPXW260819P07705000	put	7705.0000	2026-08-19	7.7000	7.6000	7.7000	7714.8300	154000.00	154000.00	0.00	200	14	10322	1097	9.40929808568824	0.152089396995444	0.152089396995444	false	false	false	true	false
4ce52022-8aa2-4077-97d9-e017c798cbae	2026-08-19 10:11	2026-08-19 10:11	2026-08-19 10:11	SPXW	SPXW260819P07715000	put	7715.0000	2026-08-19	12.4300	12.2000	12.6000	7712.3700	109370.00	109370.00	0.00	88	15	12689	537	23.6294227188082	0.140518749384631	0.14305112291758	false	false	false	true	false
8a8a46a3-aa61-44e7-927c-584eb02b53f6	2026-08-19 10:17	2026-08-19 10:17	2026-08-19 10:17	SPXW	SPXW260819C07730000	call	7730.0000	2026-08-19	6.1000	6.0000	6.1000	7716.7900	122610.00	122610.00	0.00	201	13	19203	2237	8.58426464014305	0.145493444383415	0.145493444383415	false	false	false	true	false
6a82cb1f-f22b-408d-9bb7-1212c34e09e6	2026-08-19 10:17	2026-08-19 10:17	2026-08-19 10:17	SPXW	SPXW260819C07720000	call	7720.0000	2026-08-19	10.8000	10.5000	10.9000	7717.9700	259190.00	144720.00	113400.00	240	34	17708	951	18.6203995793901	0.149602090721858	0.148704710757397	false	false	false	true	false
bf81af06-0f6e-45ee-b575-631bfd96fe9e	2026-08-19 10:17	2026-08-19 10:17	2026-08-19 10:17	SPXW	SPXW260819C07670000	call	7670.0000	2026-08-19	49.3000	49.2000	49.3000	7715.9700	483140.00	483140.00	0.00	98	30	542	190	2.85263157894737	0.219616102611177	0.219616102611177	false	false	false	true	false
7378ce20-e6ca-4fa4-ad97-7e99edbbd66e	2026-08-19 10:18	2026-08-19 10:18	2026-08-19 10:18	SPXW	SPXW260819C07725000	call	7725.0000	2026-08-19	8.7900	8.7000	9.0000	7718.9200	105540.00	0.00	105540.00	120	25	19648	5879	3.34206497703691	0.146500502083263	0.146500502083263	false	false	false	true	false
85920312-b7b3-4905-a5d6-6f27165edf33	2026-08-19 10:19	2026-08-19 10:19	2026-08-19 10:19	SPXW	SPXW260819C07720000	call	7720.0000	2026-08-19	11.0000	10.8000	11.0000	7718.1100	110000.00	110000.00	0.00	100	25	19032	951	20.01261829653	0.151013961013909	0.151013961013909	false	false	false	true	false
6e8b63f4-d7b8-4ba0-9b51-5c2851b9767d	2026-08-19 10:22	2026-08-19 10:21	2026-08-19 10:21	SPXW	SPXW260819P07715000	put	7715.0000	2026-08-19	10.8200	10.6000	10.9000	7715.8100	108160.00	108160.00	0.00	100	28	16415	537	30.5679702048417	0.14409187786718	0.145934151617173	false	false	false	true	false
748dce20-80c8-4154-96e9-cf722672cada	2026-08-19 10:22	2026-08-19 10:21	2026-08-19 10:21	SPXW	SPXW260819P07720000	put	7720.0000	2026-08-19	13.0000	12.9000	13.1000	7715.4400	104000.00	87100.00	0.00	80	15	14218	5428	2.61938098747237	0.136673341815106	0.136673341815106	false	false	false	true	false
c584658a-3943-4d73-af1c-7ef77087eb8b	2026-08-19 10:41	2026-08-19 10:41	2026-08-19 10:41	SPXW	SPXW260819C07730000	call	7730.0000	2026-08-19	10.9000	10.8000	11.1000	7730.7500	112300.00	3300.00	76300.00	103	15	29488	2237	13.181940098346	0.138598942280853	0.137281871018364	false	false	false	true	false
4d6798c8-83cf-46b7-b534-58dcac5b1ff4	2026-08-19 10:42	2026-08-19 10:42	2026-08-19 10:42	SPXW	SPXW260819C07720000	call	7720.0000	2026-08-19	15.2300	15.2000	15.5000	7727.8000	155330.00	0.00	147680.00	102	34	26684	951	28.0588853838065	0.143211938242145	0.141833215616782	true	false	false	true	false
913dd5b3-c311-44db-9047-e31a3864dbda	2026-08-19 10:45	2026-08-19 10:45	2026-08-19 10:45	SPXW	SPXW260828C07770000	call	7770.0000	2026-08-28	37.8300	37.6000	37.9000	7729.9000	147520.00	37900.00	109620.00	39	8	76	538	0.141263940520446	0.108406744059203	0.108619310671311	false	false	false	true	false
8042d0ba-2d68-427a-b1e6-e30a159f784d	2026-08-19 10:45	2026-08-19 10:45	2026-08-19 10:45	SPXW	SPXW260819P07740000	put	7740.0000	2026-08-19	14.5000	14.5000	14.6000	7730.5400	126150.00	0.00	126150.00	87	7	2000	604	3.3112582781457	0.120783985642517	0.120783985642517	false	false	false	true	false
c3339d16-7b82-451d-9c87-0be24a43267f	2026-08-19 10:47	2026-08-19 10:47	2026-08-19 10:47	SPXW	SPXW260819C07700000	call	7700.0000	2026-08-19	33.4700	33.4000	33.7000	7731.1300	184110.00	0.00	110400.00	55	12	4990	2637	1.89230185817217	0.159454456035161	0.15478254380543	true	false	false	true	false
e6bb7c50-e012-42ab-8f62-3fedaa67bf3c	2026-08-19 10:56	2026-08-19 10:56	2026-08-19 10:56	SPXW	SPXW260819C07735000	call	7735.0000	2026-08-19	10.3000	10.2000	10.4000	7736.3900	103000.00	47380.00	55620.00	100	13	34695	1976	17.5581983805668	0.128079952302271	0.128079952302271	false	false	false	true	false
320c175b-2dd2-482e-b80c-12ae8e4989b4	2026-08-19 10:58	2026-08-19 10:58	2026-08-19 10:58	SPXW	SPXW260819C07750000	call	7750.0000	2026-08-19	4.1300	4.1000	4.3000	7737.9600	206440.00	0.00	202660.00	500	61	42217	4447	9.49336631436924	0.120369500233421	0.118809625320743	false	false	false	true	false
a6ff1399-4041-4c0c-8e42-dc2cf7973167	2026-08-19 10:59	2026-08-19 10:59	2026-08-19 10:59	SPXW	SPXW260820C07735000	call	7735.0000	2026-08-20	21.5500	21.5000	21.7000	7739.7800	107730.00	0.00	58050.00	50	6	821	143	5.74125874125874	0.115603449139332	0.114980045933218	true	false	false	true	false
736de2d7-069c-4ec0-b035-548d629587a8	2026-08-19 11:01	2026-08-19 11:01	2026-08-19 11:01	SPXW	SPXW260820C07760000	call	7760.0000	2026-08-20	11.3000	11.3000	11.4000	7743.8300	113000.00	0.00	113000.00	100	15	3564	2276	1.56590509666081	0.110872503161301	0.110872503161301	false	false	false	true	false
8ce3d62b-f7d3-477d-882b-91970ae10b2b	2026-08-19 11:03	2026-08-19 11:02	2026-08-19 11:02	SPXW	SPXW260819P07755000	put	7755.0000	2026-08-19	17.6000	17.5000	17.7000	7740.2300	158400.00	0.00	52800.00	90	12	1427	857	1.66511085180863	0.113521616976043	0.113521616976043	false	false	false	true	false
445c62cb-5bbc-46e6-943d-3cf603dc453a	2026-08-19 11:05	2026-08-19 11:05	2026-08-19 11:05	SPXW	SPXW260819C07745000	call	7745.0000	2026-08-19	7.2000	7.2000	7.3000	7740.7800	195120.00	0.00	195120.00	271	32	32885	1561	21.0666239590006	0.124237701182112	0.124237701182112	false	false	false	true	false
2f635ac0-1024-4d21-ad3b-59eb2551f8a3	2026-08-19 11:06	2026-08-19 11:06	2026-08-19 11:06	SPXW	SPXW260819C07735000	call	7735.0000	2026-08-19	13.1000	13.1000	13.3000	7741.5700	100870.00	0.00	100870.00	77	11	38880	1976	19.6761133603239	0.128063871648812	0.128063871648812	true	false	false	true	false
8d4ff56e-36e2-4450-b1e0-d958d3c91793	2026-08-19 11:08	2026-08-19 11:08	2026-08-19 11:08	SPXW	SPXW260819C07730000	call	7730.0000	2026-08-19	13.1000	13.0000	13.2000	7736.3900	103490.00	72050.00	0.00	79	10	38756	2237	17.3249888243183	0.130276874845305	0.130276874845305	false	false	false	true	false
fff8dcb6-e537-4f85-9a7b-b7204438cede	2026-08-19 11:09	2026-08-19 11:09	2026-08-19 11:09	SPXW	SPXW260819P07755000	put	7755.0000	2026-08-19	20.3400	20.3000	20.6000	7736.8200	126120.00	0.00	95520.00	62	17	1718	857	2.0046674445741	0.117420557645149	0.115448170603684	true	false	false	true	false
3b61a4de-4467-4055-9f70-6f2f86d76500	2026-08-19 11:10	2026-08-19 11:10	2026-08-19 11:10	SPXW	SPXW260819C07745000	call	7745.0000	2026-08-19	5.0000	4.9000	5.1000	7735.7700	100000.00	74000.00	26000.00	200	22	35378	1561	22.6636771300448	0.12147778919474	0.12147778919474	false	false	false	true	false
2b12bbf3-165f-4516-b65e-e86817fa9fb6	2026-08-19 11:13	2026-08-19 11:12	2026-08-19 11:12	SPXW	SPXW260819C07735000	call	7735.0000	2026-08-19	11.1000	11.0000	11.2000	7738.5100	107670.00	0.00	104340.00	97	16	41080	1976	20.7894736842105	0.126807932030967	0.126807932030967	true	false	false	true	false
655d746a-5892-4330-a2f4-b9ecc11a8cba	2026-08-19 11:25	2026-08-19 11:24	2026-08-19 11:24	SPXW	SPXW260819P07740000	put	7740.0000	2026-08-19	13.0000	12.9000	13.0000	7731.9100	176800.00	176800.00	0.00	136	18	10819	604	17.9122516556291	0.119623705265613	0.119623705265613	false	false	false	true	false
f0629883-e990-4fe9-b850-78b4fe4bce5e	2026-08-19 11:25	2026-08-19 11:25	2026-08-19 11:25	SPXW	SPXW260819P07755000	put	7755.0000	2026-08-19	25.8000	25.7000	25.8000	7730.4000	162540.00	162540.00	0.00	63	9	2148	857	2.50641773628938	0.121015906668532	0.121015906668532	false	false	false	true	false
302f578a-7c48-470a-b2fb-90ce2a5ae943	2026-08-19 11:27	2026-08-19 11:27	2026-08-19 11:27	SPXW	SPXW260819P07755000	put	7755.0000	2026-08-19	25.3300	25.0000	25.4000	7730.9700	200140.00	114130.00	83490.00	79	13	2254	857	2.63010501750292	0.11859756510266	0.121283887160685	true	false	false	true	false
2b88dac6-0df6-4c9b-aaff-cfef02809e41	2026-08-19 11:33	2026-08-19 11:33	2026-08-19 11:33	SPXW	SPXW260820C07730000	call	7730.0000	2026-08-20	18.0000	17.8000	18.1000	7729.7200	180000.00	95400.00	84600.00	100	7	2062	361	5.71191135734072	0.109682497047999	0.109902023361589	false	false	false	true	false
8aea6c85-da94-4b97-9a87-156fc0228205	2026-08-19 11:34	2026-08-19 11:34	2026-08-19 11:34	SPXW	SPXW260819C07725000	call	7725.0000	2026-08-19	10.1000	9.9000	10.1000	7727.1800	101000.00	101000.00	0.00	100	16	34069	5879	5.79503316890628	0.128352441420925	0.128352441420925	true	false	false	true	false
e977ce11-fed7-43f4-a67c-1eac2392a130	2026-08-19 11:37	2026-08-19 11:37	2026-08-19 11:37	SPXW	SPXW260819P07755000	put	7755.0000	2026-08-19	30.0100	29.9000	30.6000	7724.9700	192060.00	0.00	192060.00	64	11	2433	857	2.8389731621937	0.0944002665146499	0.0662929496169842	true	false	false	true	false
356dd1d0-1e46-4d07-aca5-069d7cad5995	2026-08-19 11:42	2026-08-19 11:42	2026-08-19 11:42	SPXW	SPXW260820C07730000	call	7730.0000	2026-08-20	14.4000	14.3000	14.4000	7721.6000	156960.00	156960.00	0.00	109	5	2473	361	6.85041551246537	0.111234956329406	0.111234956329406	false	false	false	true	false
b934f850-ebaa-40d6-ae98-9f3f8b06bfd6	2026-08-19 11:44	2026-08-19 11:44	2026-08-19 11:44	SPXW	SPXW260819C07715000	call	7715.0000	2026-08-19	14.3900	14.1000	14.5000	7724.3800	143860.00	143860.00	0.00	100	25	17696	1618	10.9369592088999	0.128574401074554	0.128574401074554	false	false	false	true	false
90a2025e-6922-4624-8af2-5a9ef67337f1	2026-08-19 11:53	2026-08-19 11:52	2026-08-19 11:52	SPXW	SPXW260918P06975000	put	6975.0000	2026-09-18	11.2000	11.2000	11.4000	7724.0000	129920.00	0.00	129920.00	116	5	605	1201	0.503746877601998	0.229202980845065	0.229202980845065	false	false	false	true	false
73263e13-252c-4a94-8084-6b525c06db5e	2026-08-19 11:56	2026-08-19 11:56	2026-08-19 11:56	SPXW	SPXW260819P07755000	put	7755.0000	2026-08-19	32.5000	32.5000	32.7000	7723.0000	227500.00	0.00	227500.00	70	8	2808	857	3.27654609101517	0.128147862996412	0.128147862996412	false	false	false	true	false
4e559bd3-7f8d-4e70-988f-cc91e7cb8dd0	2026-08-19 12:03	2026-08-19 12:03	2026-08-19 12:03	SPXW	SPXW260930C07730000	call	7730.0000	2026-09-30	147.6000	147.4000	147.8000	7732.0400	738000.00	147600.00	590400.00	50	6	143	95	1.50526315789474	0.123418776902097	0.123418776902097	false	false	false	true	false
83e9d838-111a-4cdd-9b44-32b464167d98	2026-08-19 12:07	2026-08-19 12:07	2026-08-19 12:07	SPXW	SPXW260821C07645000	call	7645.0000	2026-08-21	96.1000	95.5000	96.6000	7734.0800	288300.00	288300.00	0.00	30	6	83	152	0.546052631578947	0.143038119143173	0.143038119143173	false	false	false	true	false
c589d468-fd1e-4789-ba4d-8629ddc65e9e	2026-08-19 12:08	2026-08-19 12:08	2026-08-19 12:08	SPXW	SPXW260819P07755000	put	7755.0000	2026-08-19	21.3000	21.2000	21.4000	7735.2800	187440.00	63900.00	0.00	88	13	3085	857	3.5997666277713	0.122414988242948	0.122414988242948	false	false	false	true	false
d28f3306-dd58-4ccf-9b72-f03b979991a0	2026-08-19 12:12	2026-08-19 12:12	2026-08-19 12:12	SPXW	SPXW260819P07755000	put	7755.0000	2026-08-19	20.9700	20.7000	21.1000	7735.7300	201300.00	201300.00	0.00	96	14	3238	857	3.77829638273045	0.122806417313186	0.12526423494403	true	false	false	true	false
d8c0d565-465c-4bac-b618-bca46bd0e9e0	2026-08-19 12:16	2026-08-19 12:16	2026-08-19 12:16	SPXW	SPXW260828P07735000	put	7735.0000	2026-08-28	49.9800	49.7000	50.0000	7737.2000	199930.00	199930.00	0.00	40	9	234	121	1.93388429752066	0.112457673678578	0.112664611989108	false	false	false	true	false
85063051-2aee-42cb-9f46-0e57c3b4fdf1	2026-08-19 12:21	2026-08-19 12:21	2026-08-19 12:21	SPXW	SPXW260819P07755000	put	7755.0000	2026-08-19	19.1100	18.8000	19.2000	7737.8700	166290.00	166290.00	0.00	87	14	3504	857	4.08868144690782	0.121780551032678	0.126400245969652	true	false	false	true	false
4fabe1db-8726-40d5-8aac-53b2d56a28de	2026-08-19 12:21	2026-08-19 12:21	2026-08-19 12:21	SPXW	SPXW260821P07730000	put	7730.0000	2026-08-21	21.5000	21.4000	21.7000	7735.7200	215000.00	154800.00	60200.00	100	10	769	740	1.03918918918919	0.109444315014778	0.109444315014778	false	false	false	true	false
940a2293-e60f-43dc-9a47-a8609b6c1c19	2026-08-19 12:29	2026-08-19 12:28	2026-08-19 12:28	SPXW	SPXW260819P07740000	put	7740.0000	2026-08-19	14.5300	14.4000	14.9000	7728.8200	194730.00	4350.00	190380.00	134	20	17517	604	29.0016556291391	0.129026206177124	0.125239609527504	true	false	false	true	false
56e99e57-f9f2-498c-ad6f-62dcbd672044	2026-08-19 12:29	2026-08-19 12:29	2026-08-19 12:29	SPXW	SPXW260820C07710000	call	7710.0000	2026-08-20	28.7500	28.7000	29.1000	7728.4200	112130.00	0.00	112130.00	39	7	1101	365	3.01643835616438	0.108830602578088	0.108147581702653	false	false	false	true	false
bbaf721d-ee8a-4973-89df-d6b810c2f70d	2026-08-19 12:32	2026-08-19 12:32	2026-08-19 12:32	SPXW	SPXW260820P07700000	put	7700.0000	2026-08-20	9.5000	9.4000	9.7000	7725.4900	170050.00	0.00	170050.00	179	16	3511	1609	2.18210068365444	0.123871188620153	0.123871188620153	false	false	false	true	false
7a1f3668-5188-4cc0-bfce-cb193b59990c	2026-08-19 12:36	2026-08-19 12:36	2026-08-19 12:36	SPXW	SPXW260828P07720000	put	7720.0000	2026-08-28	50.1000	49.9000	50.2000	7723.6900	200400.00	200400.00	0.00	40	7	180	294	0.612244897959184	0.114520766602171	0.114520766602171	false	false	false	true	false
fee418c9-9dee-42cc-8cb8-937f733e536a	2026-08-19 12:54	2026-08-19 12:54	2026-08-19 12:54	SPXW	SPXW260819P07755000	put	7755.0000	2026-08-19	37.2000	37.0000	37.2000	7718.2300	435240.00	435240.00	0.00	117	5	4254	857	4.96382730455076	0.157744562352256	0.157744562352256	false	false	false	true	false