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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 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	pricenumeric

4316825f-6b69-4ba6-b0bb-03c977e8e2eb	2026-08-17 13:11	2026-08-17 13:11	2026-08-17 13:11	SPXW	SPXW260817P07770000	put	7770.0000	2026-08-17	5.7600	5.7000	6.0000	7766.1700	152740.00	0.00	151560.00	265	42	100962	1003	100.660019940179	0.0674441696782799	0.0674441696782799	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-08-17T17:22:08.033203Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
ad24c0c1-c41e-4f1c-b3c1-b7677404c786	2026-08-17 13:12	2026-08-17 13:12	2026-08-17 13:12	SPXW	SPXW260817P07770000	put	7770.0000	2026-08-17	6.2000	6.0000	6.3000	7766.5400	186620.00	157490.00	20450.00	301	63	101457	1003	101.153539381854	0.0759680664383702	0.0778671772586114	true	false	false	true	false
db37bb68-a201-4ba2-ad05-b41041c99414	2026-08-17 13:13	2026-08-17 13:12	2026-08-17 13:12	SPXW	SPXW260817P07770000	put	7770.0000	2026-08-17	6.9000	6.8000	7.1000	7764.9700	207800.00	134550.00	71850.00	301	24	102033	1003	101.727816550349	0.0735671561343338	0.0715244143951526	false	false	false	true	false
815146f1-cb5b-4f29-964f-5c82c9850e82	2026-08-17 13:15	2026-08-17 13:14	2026-08-17 13:14	SPXW	SPXW260817P07765000	put	7765.0000	2026-08-17	4.4000	4.2000	4.5000	7764.9300	156740.00	142980.00	2580.00	356	44	67655	873	77.4971363115693	0.0785014864420698	0.0821472665834793	false	false	false	true	false
a6c87f5f-fa18-4d3d-98dc-46feb6004a63	2026-08-17 13:15	2026-08-17 13:15	2026-08-17 13:15	SPXW	SPXW260817P07765000	put	7765.0000	2026-08-17	5.7500	5.6000	5.9000	7763.6500	107010.00	41260.00	59950.00	186	102	68537	873	78.5074455899198	0.0944917404386826	0.0937842381149587	false	false	false	true	false
a3511378-6520-437f-a94c-bafd3cc0fec8	2026-08-17 13:15	2026-08-17 13:14	2026-08-17 13:14	SPXW	SPXW260821C07770000	call	7770.0000	2026-08-21	30.0000	30.0000	30.1000	7764.4300	168000.00	0.00	168000.00	56	7	365	622	0.586816720257235	0.0960723788534507	0.0960723788534507	false	false	false	true	false
6960ae82-f3f7-4c02-9cef-ae3556afcb76	2026-08-17 13:15	2026-08-17 13:15	2026-08-17 13:15	SPXW	SPXW260817P07765000	put	7765.0000	2026-08-17	4.9400	4.8000	5.2000	7764.1000	176880.00	1010.00	161320.00	358	92	69237	873	79.3092783505155	0.0848201373507822	0.0817487696285298	false	false	false	true	false
010fe7cb-113b-441c-8802-d3d1cb6cbda0	2026-08-17 13:17	2026-08-17 13:17	2026-08-17 13:17	SPXW	SPXW260817P07760000	put	7760.0000	2026-08-17	4.4000	4.3000	4.6000	7761.6400	106490.00	0.00	105160.00	242	49	66864	2006	33.3320039880359	0.0958303987892872	0.0958303987892872	false	false	false	true	false
cea6e875-527e-42fd-a9e9-f52f64a2f96f	2026-08-17 13:23	2026-08-17 13:23	2026-08-17 13:23	SPXW	SPXW260818C07750000	call	7750.0000	2026-08-18	23.0000	23.0000	23.1000	7761.4500	184000.00	0.00	184000.00	80	7	468	513	0.912280701754386	0.0996504725876984	0.0996504725876984	false	false	false	true	false
9c5ca017-f6ab-4248-812f-a3e4defd5f08	2026-08-17 13:23	2026-08-17 13:23	2026-08-17 13:23	SPXW	SPXW260817P07760000	put	7760.0000	2026-08-17	5.4900	5.3000	5.6000	7760.0900	112020.00	35770.00	75700.00	204	77	73223	2006	36.5019940179462	0.107055626124803	0.104486038142365	false	false	false	true	false
b57c8d53-6cfe-412a-9924-6e861c3f8454	2026-08-17 13:23	2026-08-17 13:23	2026-08-17 13:23	SPXW	SPXW260817P07760000	put	7760.0000	2026-08-17	5.8100	5.4000	6.0000	7760.0200	148190.00	127670.00	19940.00	255	58	74281	2006	37.0294117647059	0.109624623908497	0.111497449552961	false	false	false	true	false
39f95970-efee-49cf-877f-82af355973d0	2026-08-17 13:23	2026-08-17 13:23	2026-08-17 13:23	SPXW	SPXW260818C07775000	call	7775.0000	2026-08-18	8.8300	8.6000	9.2000	7759.7600	264780.00	7040.00	257740.00	300	58	4185	418	10.011961722488	0.0933128067737374	0.0919857174418138	false	false	false	true	false
7ee38bed-77cb-4c6d-8d38-47db2bdc4e95	2026-08-17 13:25	2026-08-17 13:25	2026-08-17 13:25	SPXW	SPXW260817P07755000	put	7755.0000	2026-08-17	5.3800	5.2000	5.5000	7757.9400	191130.00	173070.00	2120.00	355	76	52988	5404	9.80532938564027	0.126453679468571	0.130285574724479	true	false	false	true	false
3acf9d58-f9d7-4b5f-b69d-fc697a400024	2026-08-17 13:26	2026-08-17 13:26	2026-08-17 13:26	SPXW	SPXW260817P07755000	put	7755.0000	2026-08-17	5.5000	5.4000	5.8000	7757.1200	189840.00	0.00	189840.00	345	66	54244	5404	10.0377498149519	0.125533574826864	0.125533574826864	false	false	false	true	false
3fe890f4-1e23-4897-9860-ea5c7cc6de97	2026-08-17 13:28	2026-08-17 13:28	2026-08-17 13:28	SPXW	SPXW260818C07760000	call	7760.0000	2026-08-18	15.0000	14.8000	15.1000	7756.5600	223500.00	4500.00	219000.00	149	19	1367	350	3.90571428571429	0.100515889042303	0.100515889042303	false	false	false	true	false
ee9d1b59-9871-4c3a-86ea-ecd25c578eba	2026-08-17 13:28	2026-08-17 13:28	2026-08-17 13:28	SPXW	SPXW260817P07770000	put	7770.0000	2026-08-17	14.4300	14.3000	14.8000	7756.7500	288670.00	0.00	285730.00	200	22	108584	1003	108.259222333001	0.112792111167846	0.101021955467992	false	false	false	true	false
621312ee-f46e-4e05-a80e-4f92b63e2cbf	2026-08-17 13:31	2026-08-17 13:31	2026-08-17 13:31	SPXW	SPXW260817C07750000	call	7750.0000	2026-08-17	9.9100	9.8000	10.1000	7756.0100	100080.00	59400.00	39680.00	101	19	4790	1111	4.31143114311431	0.125105970210634	0.125105970210634	false	false	false	true	false
eaceeec1-c354-4634-9c87-0d0744230bc1	2026-08-17 13:36	2026-08-17 13:36	2026-08-17 13:36	SPXW	SPXW260817C07735000	call	7735.0000	2026-08-17	20.9500	20.7000	21.1000	7754.5500	209510.00	205350.00	0.00	100	10	871	174	5.00574712643678	0.137435281900819	0.144513795684699	true	false	false	true	false
c88a67aa-4932-41ae-bb70-b879da8583cd	2026-08-17 13:36	2026-08-17 13:36	2026-08-17 13:36	SPXW	SPXW260818C07760000	call	7760.0000	2026-08-18	13.9000	13.8000	14.1000	7754.6800	104250.00	68110.00	36140.00	75	10	1782	350	5.09142857142857	0.099126679356435	0.099126679356435	false	false	false	true	false
d719c22d-5a40-4ce8-b68d-ef5f67975ea3	2026-08-17 13:39	2026-08-17 13:39	2026-08-17 13:39	SPXW	SPXW260828P07600000	put	7600.0000	2026-08-28	19.0000	18.9000	19.0000	7753.8500	110200.00	110200.00	0.00	58	6	324	1091	0.296975252062328	0.138005812566217	0.138005812566217	false	false	false	true	false
320a84a3-5e37-4c67-93a6-4e1aabf64d0a	2026-08-17 13:40	2026-08-17 13:40	2026-08-17 13:40	SPXW	SPXW260817P07770000	put	7770.0000	2026-08-17	17.3000	17.0000	17.5000	7753.5700	171270.00	131480.00	1730.00	99	10	110530	1003	110.199401794616	0.11494540642695	0.11494540642695	false	false	false	true	false
6cfb2e4b-f129-4014-aa94-da25d54d18c8	2026-08-17 13:46	2026-08-17 13:46	2026-08-17 13:46	SPXW	SPXW260817C07760000	call	7760.0000	2026-08-17	3.7700	3.6000	3.8000	7735.0000	152630.00	137510.00	1800.00	405	63	29516	496	59.508064516129	0.102039800619415	0.105206231025227	true	false	false	true	false
c719f2dc-b971-465c-bcdf-a0d074cef25f	2026-08-17 13:54	2026-08-17 13:54	2026-08-17 13:54	SPXW	SPXW260817P07760000	put	7760.0000	2026-08-17	6.5500	6.4000	6.9000	7735.0000	334800.00	183950.00	150850.00	511	61	91889	2006	45.8070787637089	0.0988290510286241	0.0944487610798843	false	false	false	true	false
f826a9f0-d1bd-4f40-8b83-c6a661da95b0	2026-08-17 14:02	2026-08-17 14:02	2026-08-17 14:02	SPXW	SPXW260817P07755000	put	7755.0000	2026-08-17	5.2300	5.0000	5.3000	7730.0000	183610.00	178410.00	0.00	351	59	77393	5404	14.3214285714286	0.103935221917774	0.103935221917774	true	false	false	true	false
3b0050aa-0cca-4ba9-b733-f94a30c91992	2026-08-17 14:03	2026-08-17 14:03	2026-08-17 14:03	SPXW	SPXW260817C07685000	call	7685.0000	2026-08-17	69.0000	69.0000	70.3000	7735.0000	1304100.00	0.00	1304100.00	189	7	265	320	0.828125	0.288131177761308	0.288131177761308	false	false	false	true	false
2d83c621-be15-4956-a1b8-2be17eccf3bc	2026-08-17 14:03	2026-08-17 14:03	2026-08-17 14:03	SPXW	SPXW260817C07685000	call	7685.0000	2026-08-17	69.0000	69.0000	70.3000	7735.0000	420900.00	0.00	420900.00	61	5	76	320	0.2375	0.232201579075931	0.232201579075931	false	false	false	true	false
af894438-6c1c-4302-9a66-11f9b0bf4eb8	2026-08-17 14:03	2026-08-17 14:03	2026-08-17 14:03	SPXW	SPXW260817P07755000	put	7755.0000	2026-08-17	5.2800	5.2000	5.5000	7730.0000	111320.00	0.00	111320.00	211	31	78509	5404	14.5279422649889	0.10321234141869	0.0988376242621295	false	false	false	true	false
7cb49789-92c5-436a-a429-3f9251f0f227	2026-08-17 14:06	2026-08-17 14:06	2026-08-17 14:06	SPXW	SPXW260821C07800000	call	7800.0000	2026-08-21	14.4000	14.3000	14.4000	7735.0000	178560.00	178560.00	0.00	124	5	3389	2342	1.44705380017079	0.0942451118280244	0.0942451118280244	false	false	false	true	false
d3866cb0-4743-4ef1-a6b7-cbe76f37cc14	2026-08-17 14:06	2026-08-17 14:06	2026-08-17 14:06	SPXW	SPXW260818C07770000	call	7770.0000	2026-08-18	9.0000	8.8000	9.1000	7735.0000	180000.00	137700.00	42300.00	200	11	2936	169	17.3727810650888	0.0899534934070192	0.0899534934070192	false	false	false	true	false
743f50fc-e0fc-4c97-93d8-37c929c9d5e2	2026-08-17 14:10	2026-08-17 14:10	2026-08-17 14:10	SPXW	SPXW260819P07765000	put	7765.0000	2026-08-19	26.6800	26.2000	27.0000	7730.0000	266750.00	2650.00	264100.00	100	15	764	142	5.38028169014085	0.0957818999558553	0.094896855190489	false	false	false	true	false
1ccff044-2f5e-4c8a-a1d1-bd4a3afc8b05	2026-08-17 14:13	2026-08-17 14:13	2026-08-17 14:13	SPXW	SPXW260817C07750000	call	7750.0000	2026-08-17	9.5000	9.4000	9.5000	7757.4400	103540.00	102600.00	940.00	109	7	11988	1111	10.7902790279028	0.110126120126939	0.107371376642481	false	false	false	true	false
1b94add7-9d40-4d9f-96dc-6b9634179327	2026-08-17 14:20	2026-08-17 14:20	2026-08-17 14:20	SPXW	SPXW260918C08000000	call	8000.0000	2026-09-18	25.8700	25.7000	26.2000	7755.5100	403570.00	0.00	403570.00	156	12	326	1709	0.190754827384435	0.106664053310389	0.106490398110137	false	false	false	true	false
d1742e90-994e-4acd-bd27-c0926f9c05d2	2026-08-17 14:26	2026-08-17 14:26	2026-08-17 14:26	SPXW	SPXW260826C07815000	call	7815.0000	2026-08-26	21.2000	20.8000	21.3000	7757.9600	106000.00	33920.00	72080.00	50	5	79	42	1.88095238095238	0.0849226520325342	0.0849226520325342	false	false	false	true	false
945fd4ac-de8f-4cba-bee8-60df008cd17e	2026-08-17 14:31	2026-08-17 14:31	2026-08-17 14:31	SPXW	SPXW260818C07750000	call	7750.0000	2026-08-18	18.4000	18.4000	18.5000	7754.5400	180320.00	0.00	180320.00	98	15	1556	513	3.03313840155945	0.0962617365481196	0.0962617365481196	false	false	false	true	false
76e7bf61-5e07-4d8c-b5db-88f1a1ad1829	2026-08-17 14:35	2026-08-17 14:34	2026-08-17 14:34	SPXW	SPXW260831P07525000	put	7525.0000	2026-08-31	13.6000	13.5000	13.7000	7753.7600	1360000.00	0.00	0.00	1000	10	1155	623	1.85393258426966	0.141534157404752	0.141534157404752	false	false	false	true	false
5a619459-b909-4f2f-a1a4-69a0d2d130e4	2026-08-17 14:35	2026-08-17 14:34	2026-08-17 14:34	SPXW	SPXW260831P07475000	put	7475.0000	2026-08-31	10.4000	10.3000	10.4000	7753.7600	1040000.00	0.00	0.00	1000	10	1088	558	1.94982078853047	0.150524624604641	0.150524624604641	false	false	false	true	false
45ceac4b-94eb-48a2-a128-6ee0f7d7b472	2026-08-17 14:35	2026-08-17 14:34	2026-08-17 14:34	SPXW	SPXW260831P07725000	put	7725.0000	2026-08-31	49.3800	49.5000	49.8000	7753.7600	4938000.00	0.00	0.00	1000	10	1060	125	8.48	0.111702132464776	0.111702132464776	false	false	false	true	false
d29df438-20c5-439d-887a-c988141904fe	2026-08-17 14:35	2026-08-17 14:35	2026-08-17 14:35	SPXW	SPXW260818C07750000	call	7750.0000	2026-08-18	18.9000	18.8000	19.0000	7755.1300	149310.00	62370.00	0.00	79	7	1728	513	3.36842105263158	0.0973273845554439	0.0973273845554439	false	false	false	true	false
5cec80f3-30b8-4e91-b72a-a8e947ee1db1	2026-08-17 14:37	2026-08-17 14:37	2026-08-17 14:37	SPXW	SPXW260918C08000000	call	8000.0000	2026-09-18	25.6200	25.6000	25.9000	7754.7800	322800.00	0.00	322800.00	126	7	699	1709	0.409011117612639	0.106397380622182	0.106238395266892	false	false	false	true	false
199401d9-9033-4524-98f8-a841de9c6be3	2026-08-17 14:42	2026-08-17 14:42	2026-08-17 14:42	SPXW	SPXW260817C07750000	call	7750.0000	2026-08-17	7.6000	7.5000	7.6000	7756.1400	145160.00	145160.00	0.00	191	31	16018	1111	14.4176417641764	0.0991710963105016	0.0991710963105016	false	false	false	true	false
87a68260-c2d3-498b-a758-1fa8f1f45450	2026-08-17 14:43	2026-08-17 14:43	2026-08-17 14:43	SPXW	SPXW260918C08000000	call	8000.0000	2026-09-18	26.0100	25.9000	26.3000	7757.4300	754200.00	0.00	754200.00	290	7	1165	1709	0.681685196021065	0.106212049397705	0.106057476200779	false	false	false	true	false
f69c4baf-2ee6-422f-a146-ff17ac26c488	2026-08-17 14:52	2026-08-17 14:52	2026-08-17 14:52	SPXW	SPXW260831C08050000	call	8050.0000	2026-08-31	1.3000	1.2500	1.3500	7758.1100	161460.00	0.00	0.00	1242	6	1489	6031	0.246891062841983	0.091867283131913	0.091867283131913	false	false	false	true	false
8a661031-6397-4fdf-9fa4-2c85e07170a6	2026-08-17 15:03	2026-08-17 15:03	2026-08-17 15:03	SPXW	SPXW260817P07760000	put	7760.0000	2026-08-17	6.5000	6.4000	6.6000	7754.0700	109840.00	107250.00	640.00	169	20	109153	2006	54.413260219342	0.0789436184549958	0.0789436184549958	false	false	false	true	false
bf97f77e-06cb-4689-a294-f1f07e928d35	2026-08-17 15:14	2026-08-17 15:14	2026-08-17 15:14	SPXW	SPXW260831C07885000	call	7885.0000	2026-08-31	15.0000	14.9000	15.2000	7752.8800	778500.00	750000.00	28500.00	519	13	1108	229	4.83842794759825	0.0913293742679453	0.0913293742679453	false	false	false	true	false
f940d12c-1e02-4d72-a1b1-3e33539899fa	2026-08-17 15:31	2026-08-17 15:30	2026-08-17 15:30	SPXW	SPXW260825C07795000	call	7795.0000	2026-08-25	22.1000	22.0000	22.3000	7750.5200	243100.00	203320.00	39780.00	110	7	228	129	1.76744186046512	0.0830889298434965	0.0830889298434965	false	false	false	true	false
0654c5bc-9767-41f6-b64f-065a09893253	2026-08-17 15:31	2026-08-17 15:30	2026-08-17 15:30	SPXW	SPXW260818C07750000	call	7750.0000	2026-08-18	15.5000	15.3000	15.6000	7749.9200	105400.00	75950.00	29450.00	68	8	2227	513	4.3411306042885	0.0935275046758538	0.0935275046758538	false	false	false	true	false
977a175d-0929-4219-84a0-3fea264a711b	2026-08-17 15:32	2026-08-17 15:32	2026-08-17 15:32	SPXW	SPXW260817P07770000	put	7770.0000	2026-08-17	20.5000	20.4000	20.5000	7748.9000	301350.00	301350.00	0.00	147	14	116651	1003	116.302093718843	0.130167085017891	0.130167085017891	false	false	false	true	false
6b7c07e4-3ecb-485c-9860-07824dd9b593	2026-08-17 15:33	2026-08-17 15:32	2026-08-17 15:32	SPXW	SPXW260817P07750000	put	7750.0000	2026-08-17	3.7900	3.5000	3.9000	7748.0200	101600.00	15960.00	84200.00	268	114	152831	3857	39.6243194192378	0.1171419555622	0.126577499250216	false	false	false	true	false
bb642db9-d267-4541-a1a9-9473d2874107	2026-08-17 15:33	2026-08-17 15:33	2026-08-17 15:33	SPXW	SPXW260918C08000000	call	8000.0000	2026-09-18	24.6100	24.6000	25.0000	7748.8700	676870.00	0.00	676870.00	275	9	1465	1709	0.857226448215331	0.106595267643689	0.106432982689677	false	false	false	true	false
491b0030-1878-42f6-847f-295efa0d9bfc	2026-08-17 15:41	2026-08-17 15:41	2026-08-17 15:41	SPXW	SPXW260819C07750000	call	7750.0000	2026-08-19	22.0000	21.9000	22.1000	7750.2000	105600.00	0.00	77000.00	48	5	490	1184	0.413851351351351	0.0921281747358234	0.0921281747358234	false	false	false	true	false